APPS.JTF_IH_IMPORT dependencies on FND_API

Line 178: IF (curActivity.Media_ID IS NOT NULL) AND (curActivity.Media_ID <> fnd_api.g_miss_num) THEN

174: ELSE
175: FOR curActivity IN (SELECT Activity_ID, Media_ID FROM jtf_ih_activities_stg WHERE
176: Interaction_ID = curInteraction.Interaction_Id and
177: (Session_No IS NULL OR Session_No = pnSessionNo OR Session_No = v_Session_no)) LOOP
178: IF (curActivity.Media_ID IS NOT NULL) AND (curActivity.Media_ID <> fnd_api.g_miss_num) THEN
179: /* Looking for Media_ID in the JTF_IH_MEDIA_ITEM_STG */
180: SELECT Count(*) INTO nCount FROM jtf_ih_media_items_stg
181: WHERE Media_ID = curActivity.Media_ID AND (Session_No IN (pnSessionNo, v_Session_no) OR Session_No IS NULL);
182: IF nCount = 0 THEN