APPS.JTF_IH_IMPORT dependencies on JTF_IH_PUB

Line 17: -- 09/26/03 - Bug# 3163407 - THE PACKAGE HARD CODES "APPS" SCHEMA NAME WHEN REFERENCING JTF_IH_PUB.

13: -- ANY DATA INTO IH TABLES
14: -- 03/10/03 - Fixed bug# 2841568 - TST1159.7:SOME LINES IN THE VIEW LOG FOR
15: -- DATAIMPORT IS NOT PSEUDO TRANSLATED
16: -- 03/07/03 - Enh# 3022511 - Added address column to JTF_IH_MEDIA_ITEMS table
17: -- 09/26/03 - Bug# 3163407 - THE PACKAGE HARD CODES "APPS" SCHEMA NAME WHEN REFERENCING JTF_IH_PUB.
18: -- 12/23/03 - Bug# 3184503 - ICFP-R:F -INTERACTION HISTORY TERMINATED: ORA-01422: EXACT FETCH RETURNS MORE TH
19: -- 05/07/04 - Fixed File.sql.35 issue.
20: --
21:

Line 108: sMediaItems_rec JTF_IH_PUB.media_rec_type;

104: WHERE
105: (Session_No = pnSessionNo OR Session_No IS NULL OR Session_No = v_Session_no)
106: AND (Status_FL = v_Status_Fl1 OR Status_FL IS NULL);
107:
108: sMediaItems_rec JTF_IH_PUB.media_rec_type;
109: sMedia_ID_Stg NUMBER;
110: e_Errors EXCEPTION;
111: l_Message VARCHAR2(2000);
112: e_ErrorInteraction EXCEPTION;

Line 270: l_interaction_rec JTF_IH_PUB.interaction_rec_type;

266: v_Status_Fl2 NUMBER;
267: v_Session_no NUMBER;
268: --end Perf fix for literal Usage
269:
270: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
271: l_interaction_id NUMBER;
272: l_jtf_note_id NUMBER;
273: n_Count NUMBER := 0;
274: m_active VARCHAR2(1);

Line 277: --l_activity_rec JTF_IH_PUB.activity_rec_type;

273: n_Count NUMBER := 0;
274: m_active VARCHAR2(1);
275: p_interaction_id NUMBER;
276:
277: --l_activity_rec JTF_IH_PUB.activity_rec_type;
278: l_activity_id_1 NUMBER;
279: l_activity_id_2 NUMBER;
280: m_activitycount NUMBER := 0;
281: m_activityactive VARCHAR2(1);

Line 297: l_media_item_rec JTF_IH_PUB.media_rec_type;

293: end_time_run DATE;
294: begin_time_run DATE;
295: total_time_run NUMBER;
296:
297: l_media_item_rec JTF_IH_PUB.media_rec_type;
298: l_media_item_id NUMBER;
299:
300: nRowsCompleted NUMBER;
301: nSessionNo NUMBER;

Line 413: l_activity_rec JTF_IH_PUB.Activity_Rec_Type;

409: FROM JTF_IH_ACTIVITIES_STG
410: WHERE Status_FL = v_Status_Fl1 AND Interaction_ID = nIntrctID
411: AND (Session_No IN (nSessionNo, v_Session_no) OR Session_No IS NULL);
412: --l_activity_rec curActivity%rowtype;
413: l_activity_rec JTF_IH_PUB.Activity_Rec_Type;
414: l_activity_stg NUMBER;
415: CURSOR curMediaItem IS SELECT
416: media_id,
417: source_id,

Line 441: l_media_item_stg_rec JTF_IH_PUB.Media_Rec_Type;

437: NULL as bulk_interaction_id,
438: address
439: FROM JTF_IH_MEDIA_ITEMS_STG
440: WHERE Status_FL = v_Status_Fl1 AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL);
441: l_media_item_stg_rec JTF_IH_PUB.Media_Rec_Type;
442: l_media_id_stg NUMBER;
443:
444: nCntInter NUMBER := 0;
445: nCntActiv NUMBER := 0;

Line 508: JTF_IH_PUB.Create_MediaItem(1.0,

504: l_media_item_stg_rec.media_id := NULL;
505: IF curMediaItem%NOTFOUND THEN
506: EXIT;
507: END IF;
508: JTF_IH_PUB.Create_MediaItem(1.0,
509: 'T',
510: 'F',
511: fnd_global.resp_appl_id,
512: fnd_global.resp_id,

Line 578: JTF_IH_PUB.Open_Interaction(1.0,

574: END IF;
575: l_interaction_stg := l_interaction_rec.interaction_id;
576: l_interaction_rec.Interaction_ID := NULL;
577: bInteractionError := FALSE;
578: JTF_IH_PUB.Open_Interaction(1.0,
579: 'T',
580: 'F',
581: fnd_global.resp_appl_id,
582: fnd_global.resp_id,

Line 604: JTF_IH_PUB.Add_Activity(1.0,

600: END IF;
601: l_activity_stg := l_activity_rec.Activity_ID;
602: l_activity_rec.Activity_ID := NULL;
603: l_activity_rec.Interaction_Id := l_interaction_id;
604: JTF_IH_PUB.Add_Activity(1.0,
605: 'T',
606: 'F',
607: fnd_global.resp_appl_id,
608: fnd_global.resp_id,

Line 633: JTF_IH_PUB.Close_Interaction( 1.0,

629: AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL);
630: IF nActive = 'N' THEN
631: -- dbms_output.put_line('Interaction No '||l_interaction_id||' was closed');
632: l_interaction_rec.Interaction_ID := l_interaction_id;
633: JTF_IH_PUB.Close_Interaction( 1.0,
634: 'T',
635: 'F',
636: fnd_global.resp_appl_id,
637: fnd_global.resp_id,