DBA Data[Home] [Help]

APPS.AST_WRAPUP_ADM_PVT dependencies on JTF_IH_RESULTS_B

Line 349: FROM JTF_IH_RESULTS_B

345:
346: -- Cursor for retrieving from the table to verify insertion
347: CURSOR l_insert_b_check_csr IS
348: SELECT 'x'
349: FROM JTF_IH_RESULTS_B
350: WHERE RESULT_ID = l_RESULT_id;
351:
352: -- Cursor for retrieving from the table to verify insertion
353: CURSOR l_insert_tl_check_csr IS

Line 425: -- insert new RESULT into JTF_IH_RESULTS_B

421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: CLOSE l_insert_tl_check_csr;
424:
425: -- insert new RESULT into JTF_IH_RESULTS_B
426: INSERT INTO JTF_IH_RESULTS_B
427: (
428: RESULT_ID,
429: OBJECT_VERSION_NUMBER,

Line 426: INSERT INTO JTF_IH_RESULTS_B

422: END IF;
423: CLOSE l_insert_tl_check_csr;
424:
425: -- insert new RESULT into JTF_IH_RESULTS_B
426: INSERT INTO JTF_IH_RESULTS_B
427: (
428: RESULT_ID,
429: OBJECT_VERSION_NUMBER,
430: CREATED_BY,

Line 560: -- insert RESULT in JTF_IH_RESULTS_B

556: WHERE
557: RESULT_ID = P_RESULT_ID AND
558: LANGUAGE = P_LANGUAGE;
559:
560: -- insert RESULT in JTF_IH_RESULTS_B
561: UPDATE JTF_IH_RESULTS_B
562: SET
563: LAST_UPDATED_BY = G_USER_ID,
564: LAST_UPDATE_DATE = SYSDATE,

Line 561: UPDATE JTF_IH_RESULTS_B

557: RESULT_ID = P_RESULT_ID AND
558: LANGUAGE = P_LANGUAGE;
559:
560: -- insert RESULT in JTF_IH_RESULTS_B
561: UPDATE JTF_IH_RESULTS_B
562: SET
563: LAST_UPDATED_BY = G_USER_ID,
564: LAST_UPDATE_DATE = SYSDATE,
565: LAST_UPDATE_LOGIN = G_LOGIN_ID,