APPS.JTF_IH_IMPORT dependencies on JTF_IH_INTERACTIONS_STG_LOG

Line 690: (SELECT interaction_id FROM jtf_ih_interactions_stg_log

686: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
687:
688: -- If import has any errors then show message about them
689: SELECT COUNT(*) INTO nErr_InterCnt FROM
690: (SELECT interaction_id FROM jtf_ih_interactions_stg_log
691: WHERE session_no = nSessionNo);
692:
693: SELECT COUNT(*) INTO nErr_ActivCnt FROM
694: (SELECT activity_id FROM jtf_ih_activities_stg_log

Line 741: INSERT INTO JTF_IH_INTERACTIONS_STG_LOG(

737: PROCEDURE Insert_Interaction_Log( nInteraction NUMBER, sComments VARCHAR2, nSessionNo IN OUT NOCOPY NUMBER) AS
738: l_Comments VARCHAR(2000);
739: BEGIN
740: l_Comments := sComments;
741: INSERT INTO JTF_IH_INTERACTIONS_STG_LOG(
742: interaction_id,
743: object_version_number,
744: creation_date,
745: created_by,