DBA Data[Home] [Help]

APPS.JTF_IH_IMPORT dependencies on JTF_IH_MEDIA_ITEMS_STG_LOG

Line 698: (SELECT media_id FROM jtf_ih_media_items_stg_log

694: (SELECT activity_id FROM jtf_ih_activities_stg_log
695: WHERE session_no = nSessionNo);
696:
697: SELECT COUNT(*) INTO nErr_MediaCnt FROM
698: (SELECT media_id FROM jtf_ih_media_items_stg_log
699: WHERE session_no = nSessionNo);
700: IF (nErr_InterCnt <> 0) OR (nErr_ActivCnt<> 0) OR (nErr_MediaCnt <> 0) THEN
701: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DONE_WITH_ERRORS');
702: FND_MESSAGE.SET_TOKEN('INTERACTIONS', to_char(nErr_InterCnt));

Line 893: INSERT INTO jtf_ih_media_items_stg_log(

889: PROCEDURE Insert_Media_Item_Log( nMediaID NUMBER, sComments VARCHAR2, nSessionNo IN OUT NOCOPY NUMBER) AS
890: l_Comments VARCHAR(2000);
891: BEGIN
892: l_Comments := sComments;
893: INSERT INTO jtf_ih_media_items_stg_log(
894: media_id,
895: object_version_number,
896: creation_date,
897: last_update_date,