APPS.AMS_ADI_OBJECTS_EXPORT_PVT dependencies on AMS_ADI_OBJECTS_EXPORT_LIST

Line 9: -- Inserts Schedules in AMS_ADI_OBJECTS_EXPORT_LIST table

5: --========================================================================
6: -- PROCEDURE
7: -- Inserts_Schedules_Export
8: -- Purpose
9: -- Inserts Schedules in AMS_ADI_OBJECTS_EXPORT_LIST table
10: -- HISTORY
11: --
12: --========================================================================
13: PROCEDURE insert_export_schedules(

Line 21: SELECT AMS_ADI_OBJECTS_EXPORT_LIST_S.NEXTVAL

17: )
18: IS
19: l_export_batch_id NUMBER;
20: CURSOR c_id IS
21: SELECT AMS_ADI_OBJECTS_EXPORT_LIST_S.NEXTVAL
22: FROM dual;
23: BEGIN
24:
25: --deletes all schedules previously exported by the same user

Line 27: from ams_adi_objects_export_list

23: BEGIN
24:
25: --deletes all schedules previously exported by the same user
26: delete
27: from ams_adi_objects_export_list
28: where created_by = FND_GLOBAL.user_id
29: and creation_date < sysdate-1;
30:
31: OPEN c_id;

Line 37: INSERT INTO AMS_ADI_OBJECTS_EXPORT_LIST

33: CLOSE c_id;
34:
35: IF (P_SCHEDULE_IDS is not null) THEN
36: FORALL i IN 1..P_SCHEDULE_IDS.COUNT
37: INSERT INTO AMS_ADI_OBJECTS_EXPORT_LIST
38: VALUES (l_export_batch_id,'CSCH',P_SCHEDULE_IDS(i),sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
39: END IF;
40:
41: IF(P_COMMIT = FND_API.G_TRUE) THEN