DBA Data[Home] [Help]

APPS.JTF_IH_PURGE dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 441: FROM JTF_OBJECT_PURGE_PARAM_TMP

437: -- interactions and activities are to be purged
438:
439: CURSOR c_jtf_obj_purge_temp_success IS
440: SELECT distinct object_id, null
441: FROM JTF_OBJECT_PURGE_PARAM_TMP
442: WHERE nvl(purge_status, 'S') <> 'E'
443: AND OBJECT_TYPE = p_object_type
444: AND PROCESSING_SET_ID = p_processing_set_id;
445:

Line 553: INSERT INTO JTF_OBJECT_PURGE_PARAM_TMP

549: WHERE rownum = 1;
550:
551:
552: FORALL i IN l_activity_id.FIRST..l_activity_id.LAST
553: INSERT INTO JTF_OBJECT_PURGE_PARAM_TMP
554: (
555: object_id,
556: object_type,
557: processing_set_id,

Line 686: INSERT INTO JTF_OBJECT_PURGE_PARAM_TMP

682: WHERE rownum = 1;
683:
684:
685: FORALL i IN l_inter_int_ids.FIRST..l_inter_int_ids.LAST
686: INSERT INTO JTF_OBJECT_PURGE_PARAM_TMP
687: (
688: object_id,
689: object_type,
690: processing_set_id,