Oracle Lookup Creation

--Lookup Type Creation:

SET SERVEROUTPUT ON;

DECLARE
    ln_rowid   VARCHAR2(1000);
BEGIN
    fnd_lookup_types_pkg.insert_row(x_rowid => ln_rowid,
x_lookup_type => 'XXCGI_ALG_MS_PEC',--Lookup Type
    x_security_group_id => 0,       --Security Group Id
    x_view_application_id => 3,       -- Application Id (0-AOL)
    x_application_id => 20003,       -- Application Id (0-AOL)
    x_customization_level => 'U',     --User
    x_description => 'Various Plan Element Categories Of MS Plan Elements Types For ALG Application',--Meaning for Lookup
    x_meaning => 'XXCGI_ALG_MS_PEC',--Description for Lookup
    x_creation_date => SYSDATE,x_created_by =>-1,x_last_update_date => SYSDATE,x_last_updated_by =>-1,x_last_update_login =>-1);
    COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('Excetpion' || sqlerrm);
END;

/

--Lookup value Creation:

SET SERVEROUTPUT ON;
SET DEFINE OFF;

DECLARE
    ln_rowid   VARCHAR2(1000);
BEGIN

fnd_lookup_values_pkg.insert_row
(x_rowid                   => ln_rowid,
x_lookup_type              => 'XXCGI_ALG_MS_PEC',
 x_security_group_id        => 0,
x_view_application_id      => 3,
x_lookup_code              => 'MS-RECURRING OFFER|RR0',
x_meaning                  => 'MS-RECURRING OFFER|RR0',
x_tag                      => NULL,
x_attribute_category       => NULL,
x_attribute1               => NULL,
x_attribute2               => NULL,
x_attribute3               => NULL,
x_attribute4               => NULL,
x_enabled_flag             => 'Y',
x_start_date_active        => TO_DATE ('21-NOV-2017','DD-MON-YYYY'),
x_end_date_active          => NULL,
x_territory_code           => NULL,
x_attribute5               => NULL,
x_attribute6               => NULL,
x_attribute7               => NULL,
x_attribute8               => NULL,
x_attribute9               => NULL,
x_attribute10              => NULL,
x_attribute11              => NULL,
x_attribute12              => NULL,
x_attribute13              => NULL,
x_attribute14              => NULL,
x_attribute15              => NULL,
x_description              => NULL,
x_creation_date            => SYSDATE,
x_created_by               => -1,
x_last_update_date         => SYSDATE,
x_last_updated_by          => -1,
x_last_update_login        => -1
);
COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('Excetpion' || sqlerrm);
END;

/