APPS.AMS_ADI_OBJECTS_EXPORT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

PROCEDURE insert_export_schedules(
  P_SCHEDULE_IDS IN JTF_NUMBER_TABLE,
  P_COMMIT IN VARCHAR2   := FND_API.G_FALSE,
  X_EXPORT_BATCH_ID OUT NOCOPY NUMBER
)
IS
 l_export_batch_id NUMBER;

Line: 21

      SELECT AMS_ADI_OBJECTS_EXPORT_LIST_S.NEXTVAL
      FROM dual;

Line: 26

 delete
 from ams_adi_objects_export_list
 where created_by = FND_GLOBAL.user_id
 and creation_date < sysdate-1;

Line: 37

      INSERT INTO AMS_ADI_OBJECTS_EXPORT_LIST
      VALUES (l_export_batch_id,'CSCH',P_SCHEDULE_IDS(i),sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.login_id);

Line: 46

END insert_export_schedules;