APPS.JTF_IH_PURGE dependencies on JTF_IH_ACTIVITIES

Line 102: sSql := 'SELECT DISTINCT JTFI.INTERACTION_ID FROM JTF_IH_INTERACTIONS JTFI, JTF_IH_ACTIVITIES ACT ';

98:
99: -- Now I'm going to build a dynamic sql statement based on input parameters.
100: --
101: IF p_ActivityOutcome IS NOT NULL OR p_ActivityResult IS NOT NULL OR p_ActivityReason IS NOT NULL THEN
102: sSql := 'SELECT DISTINCT JTFI.INTERACTION_ID FROM JTF_IH_INTERACTIONS JTFI, JTF_IH_ACTIVITIES ACT ';
103: -- If you've set up some value to p_Party_Type parameter, then include HZ_PARTIES table
104: -- to major sql statement, based on JTF_IH_INTERACTION.Party_ID
105: IF p_Party_Type IS NOT NULL THEN
106: sSql := sSql || ', HZ_PARTIES HZ ';

Line 271: FOR curActivity IN (SELECT ACTIVITY_ID FROM JTF_IH_ACTIVITIES

267: IF l_SafeMode = 'FALSE' THEN
268: BEGIN
269: SAVEPOINT Activities;
270: -- Clean Up an Activities
271: FOR curActivity IN (SELECT ACTIVITY_ID FROM JTF_IH_ACTIVITIES
272: WHERE INTERACTION_ID = nInteraction_Id) LOOP
273: DELETE FROM JTF_IH_ACTIVITIES
274: WHERE ACTIVITY_ID = curActivity.ACTIVITY_ID
275: RETURNING Media_ID INTO n_Media_Id;

Line 273: DELETE FROM JTF_IH_ACTIVITIES

269: SAVEPOINT Activities;
270: -- Clean Up an Activities
271: FOR curActivity IN (SELECT ACTIVITY_ID FROM JTF_IH_ACTIVITIES
272: WHERE INTERACTION_ID = nInteraction_Id) LOOP
273: DELETE FROM JTF_IH_ACTIVITIES
274: WHERE ACTIVITY_ID = curActivity.ACTIVITY_ID
275: RETURNING Media_ID INTO n_Media_Id;
276:
277: nCountActivities := nCountActivities + 1;

Line 280: FROM JTF_IH_ACTIVITIES WHERE MEDIA_ID = n_Media_Id;

276:
277: nCountActivities := nCountActivities + 1;
278: IF ( (n_Media_Id IS NOT NULL) AND (n_Media_Id <> fnd_api.g_miss_num) ) THEN
279: SELECT Count(*) INTO nCountMedia
280: FROM JTF_IH_ACTIVITIES WHERE MEDIA_ID = n_Media_Id;
281: --
282: -- Delete Media Item If they aren't
283: -- related to other Activities.
284: --

Line 319: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id;

315: RAISE ErrInteraction;
316: END;
317: ELSE
318: SELECT nCountActivities + Count(*) INTO nCountActivities
319: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id;
320:
321: SELECT nCountMediaItems + Count(*) INTO nCountMediaItems
322: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id AND
323: Media_ID IS NOT NULL;

Line 322: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id AND

318: SELECT nCountActivities + Count(*) INTO nCountActivities
319: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id;
320:
321: SELECT nCountMediaItems + Count(*) INTO nCountMediaItems
322: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = nInteraction_Id AND
323: Media_ID IS NOT NULL;
324:
325: END IF;
326: nCountInteraction := nCountInteraction + 1;

Line 514: FROM JTF_IH_ACTIVITIES

510: END IF;
511:
512: FORALL i IN l_incident_ids.FIRST..l_incident_ids.LAST
513: DELETE
514: FROM JTF_IH_ACTIVITIES
515: WHERE doc_id = l_incident_ids(i)
516: AND doc_ref = p_object_type
517: AND action_item_id
518: IN (SELECT meaning

Line 613: UPDATE JTF_IH_ACTIVITIES

609: END IF;
610:
611: --Delinking activities from SR
612: FORALL i IN l_incident_ids.FIRST..l_incident_ids.LAST
613: UPDATE JTF_IH_ACTIVITIES
614: SET doc_id = l_dummy_col(i),
615: doc_ref = l_dummy_col(i)
616: WHERE doc_id = l_incident_ids(i)
617: AND doc_ref = p_object_type;

Line 638: FROM JTF_IH_ACTIVITIES

634: FROM JTF_IH_INTERACTIONS
635: WHERE interaction_id = l_int_ids(j)
636: AND
637: NOT EXISTS (SELECT 1
638: FROM JTF_IH_ACTIVITIES
639: WHERE interaction_id = l_int_ids(j))
640: RETURNING interaction_id BULK COLLECT INTO l_inter_int_ids;
641: END IF;
642:

Line 756: FROM JTF_IH_ACTIVITIES

752: AND media_id <> fnd_api.g_miss_num
753: AND media_id = l_media_ids(j)
754: AND
755: NOT EXISTS (SELECT 1
756: FROM JTF_IH_ACTIVITIES
757: WHERE MEDIA_ID = l_media_ids(j))
758: RETURNING media_id BULK COLLECT INTO lc_media_ids;
759: END IF;
760: