DECLARE
ln_rowid1 VARCHAR2 (1000);
BEGIN
fnd_lookup_values_pkg.insert_row
(x_rowid => ln_rowid1,
x_lookup_type => :p_lookup_type,
x_security_group_id => 0,
x_view_application_id => :p_application_id,
x_lookup_code => :p_lookup_code,
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
('01-JAN-1950',
'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_meaning => :p_meaning,
x_description => :p_description,
x_creation_date => SYSDATE,
x_created_by => 0,
x_last_update_date => SYSDATE,
x_last_updated_by => 0,
x_last_update_login => -1
);
DBMS_OUTPUT.put_line (ln_rowid1);
COMMIT;
END;
ln_rowid1 VARCHAR2 (1000);
BEGIN
fnd_lookup_values_pkg.insert_row
(x_rowid => ln_rowid1,
x_lookup_type => :p_lookup_type,
x_security_group_id => 0,
x_view_application_id => :p_application_id,
x_lookup_code => :p_lookup_code,
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
('01-JAN-1950',
'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_meaning => :p_meaning,
x_description => :p_description,
x_creation_date => SYSDATE,
x_created_by => 0,
x_last_update_date => SYSDATE,
x_last_updated_by => 0,
x_last_update_login => -1
);
DBMS_OUTPUT.put_line (ln_rowid1);
COMMIT;
END;
No comments:
Post a Comment