APPS.XDP_PURGE dependencies on XDP_FA_RUNTIME_LIST

Line 246: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST

242: RECORDS_PURGED_MSGS(l_counter,'XDP_WORKLIST_DETAILS '||
243: 'WHERE WORKITEM_INSTANCE_ID = '
244: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
245:
246: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST
247: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
248:
249: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_RUNTIME_LIST '||
250: 'WHERE WORKITEM_INSTANCE_ID = '

Line 249: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_RUNTIME_LIST '||

245:
246: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST
247: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
248:
249: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_RUNTIME_LIST '||
250: 'WHERE WORKITEM_INSTANCE_ID = '
251: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
252:
253: IF l_temp <> 0 THEN

Line 254: FOR c_fa IN (SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST

250: 'WHERE WORKITEM_INSTANCE_ID = '
251: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
252:
253: IF l_temp <> 0 THEN
254: FOR c_fa IN (SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST
255: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID)
256: LOOP
257: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS WHERE
258: FA_INSTANCE_ID = c_fa.FA_INSTANCE_ID;

Line 439: SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST

435: line_item_id = p_line_item_id
436: FOR UPDATE NOWAIT;
437:
438: CURSOR c_fulfill_action(p_workitem_instance_id XDP_FULFILL_WORKLIST.WORKITEM_INSTANCE_ID%TYPE) IS
439: SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST
440: WHERE WORKITEM_INSTANCE_ID = p_workitem_instance_id
441: FOR UPDATE NOWAIT;
442:
443: l_temp NUMBER := 0;

Line 481: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST

477: = l_worklist.WORKITEM_INSTANCE_ID);
478: RECORDS_PURGED_MSGS(l_temp ,'XDP_FE_CMD_AUD_TRAILS WHERE WORKITEM_INSTANCE_ID = '
479: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
480:
481: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST
482: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
483: RECORDS_PURGED_MSGS(l_temp, 'XDP_FA_RUNTIME_LIST WHERE WORKITEM_INSTANCE_ID = '
484: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
485:

Line 483: RECORDS_PURGED_MSGS(l_temp, 'XDP_FA_RUNTIME_LIST WHERE WORKITEM_INSTANCE_ID = '

479: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
480:
481: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST
482: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
483: RECORDS_PURGED_MSGS(l_temp, 'XDP_FA_RUNTIME_LIST WHERE WORKITEM_INSTANCE_ID = '
484: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
485:
486: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS
487: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;

Line 509: DELETE FROM XDP_FA_RUNTIME_LIST

505: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS
506: WHERE WORKITEM_INSTANCE_ID
507: = l_worklist.WORKITEM_INSTANCE_ID);
508:
509: DELETE FROM XDP_FA_RUNTIME_LIST
510: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
511:
512: DELETE FROM XDP_FMC_AUDIT_TRAILS
513: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;