DBA Data[Home] [Help]

APPS.AMS_ADI_OBJECTS_EXPORT_PVT dependencies on FND_GLOBAL

Line 28: where created_by = FND_GLOBAL.user_id

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;
32: FETCH c_id INTO l_export_batch_id;

Line 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);

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
42: COMMIT;