APPS.JTF_IH_PURGE dependencies on JTF_IH_INTERACTION_INTERS

Line 299: -- Clean Up Parent and All Child Interactions in the JTF_IH_INTERACTION_INTERS.

295: END;
296: END IF;
297: END IF;
298: END LOOP;
299: -- Clean Up Parent and All Child Interactions in the JTF_IH_INTERACTION_INTERS.
300: DELETE FROM JTF_IH_INTERACTION_INTERS WHERE
301: (INTERACT_INTERACTION_IDRELATES = nInteraction_Id)
302: OR (INTERACT_INTERACTION_ID = nInteraction_Id);
303: -- Clean Up current Intraction.

Line 300: DELETE FROM JTF_IH_INTERACTION_INTERS WHERE

296: END IF;
297: END IF;
298: END LOOP;
299: -- Clean Up Parent and All Child Interactions in the JTF_IH_INTERACTION_INTERS.
300: DELETE FROM JTF_IH_INTERACTION_INTERS WHERE
301: (INTERACT_INTERACTION_IDRELATES = nInteraction_Id)
302: OR (INTERACT_INTERACTION_ID = nInteraction_Id);
303: -- Clean Up current Intraction.
304: DELETE FROM JTF_IH_INTERACTIONS WHERE INTERACTION_ID = nInteraction_Id;

Line 653: --in the JTF_IH_INTERACTION_INTERS.

649: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.del_inter',l_fnd_log_msg);
650: END IF;
651:
652: -- Clean Up Parent and All Child Interactions
653: --in the JTF_IH_INTERACTION_INTERS.
654: IF l_inter_int_ids.COUNT > 0 THEN
655: FORALL j IN l_inter_int_ids.FIRST..l_inter_int_ids.LAST
656: DELETE
657: FROM JTF_IH_INTERACTION_INTERS

Line 657: FROM JTF_IH_INTERACTION_INTERS

653: --in the JTF_IH_INTERACTION_INTERS.
654: IF l_inter_int_ids.COUNT > 0 THEN
655: FORALL j IN l_inter_int_ids.FIRST..l_inter_int_ids.LAST
656: DELETE
657: FROM JTF_IH_INTERACTION_INTERS
658: WHERE (INTERACT_INTERACTION_IDRELATES = l_inter_int_ids(j))
659: OR (INTERACT_INTERACTION_ID = l_inter_int_ids(j));
660: END IF;
661: