Tuesday, October 10, 2017

FND_LOOKUP - Single Record Script

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;

No comments: