DBA Data[Home] [Help]

APPS.AST_WRAPUP_ADM_PVT dependencies on JTF_IH_RESULTS_TL

Line 355: FROM JTF_IH_RESULTS_TL

351:
352: -- Cursor for retrieving from the table to verify insertion
353: CURSOR l_insert_tl_check_csr IS
354: SELECT 'x'
355: FROM JTF_IH_RESULTS_TL
356: WHERE RESULT_ID = l_RESULT_id;
357:
358: BEGIN
359: -- Standard start of API savepoint

Line 382: -- insert new RESULT into JTF_IH_RESULTS_TL

378: OPEN l_RESULT_id_csr;
379: FETCH l_RESULT_id_csr INTO l_RESULT_id;
380: CLOSE l_RESULT_id_csr;
381:
382: -- insert new RESULT into JTF_IH_RESULTS_TL
383: INSERT INTO JTF_IH_RESULTS_TL
384: (
385: RESULT_ID,
386: LANGUAGE,

Line 383: INSERT INTO JTF_IH_RESULTS_TL

379: FETCH l_RESULT_id_csr INTO l_RESULT_id;
380: CLOSE l_RESULT_id_csr;
381:
382: -- insert new RESULT into JTF_IH_RESULTS_TL
383: INSERT INTO JTF_IH_RESULTS_TL
384: (
385: RESULT_ID,
386: LANGUAGE,
387: OBJECT_VERSION_NUMBER,

Line 544: -- update outcome in JTF_IH_RESULTS_TL

540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: -- API body
543:
544: -- update outcome in JTF_IH_RESULTS_TL
545: UPDATE JTF_IH_RESULTS_TL
546: SET
547: LANGUAGE = P_LANGUAGE,
548: LAST_UPDATED_BY = G_USER_ID,

Line 545: UPDATE JTF_IH_RESULTS_TL

541:
542: -- API body
543:
544: -- update outcome in JTF_IH_RESULTS_TL
545: UPDATE JTF_IH_RESULTS_TL
546: SET
547: LANGUAGE = P_LANGUAGE,
548: LAST_UPDATED_BY = G_USER_ID,
549: LAST_UPDATE_DATE = SYSDATE,