DBA Data[Home] [Help]

APPS.AST_WRAPUP_ADM_PVT dependencies on JTF_IH_REASONS_TL

Line 647: FROM JTF_IH_REASONS_TL

643:
644: -- Cursor for retrieving from the table to verify insertion
645: CURSOR l_insert_tl_check_csr IS
646: SELECT 'x'
647: FROM JTF_IH_REASONS_TL
648: WHERE REASON_ID = l_REASON_id;
649:
650: BEGIN
651: -- Standard start of API savepoint

Line 674: -- insert new REASON into JTF_IH_REASONS_TL

670: OPEN l_REASON_id_csr;
671: FETCH l_REASON_id_csr INTO l_REASON_id;
672: CLOSE l_REASON_id_csr;
673:
674: -- insert new REASON into JTF_IH_REASONS_TL
675: INSERT INTO JTF_IH_REASONS_TL
676: (
677: REASON_ID,
678: LANGUAGE,

Line 675: INSERT INTO JTF_IH_REASONS_TL

671: FETCH l_REASON_id_csr INTO l_REASON_id;
672: CLOSE l_REASON_id_csr;
673:
674: -- insert new REASON into JTF_IH_REASONS_TL
675: INSERT INTO JTF_IH_REASONS_TL
676: (
677: REASON_ID,
678: LANGUAGE,
679: OBJECT_VERSION_NUMBER,

Line 830: -- update outcome in JTF_IH_REASONS_TL

826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: -- API body
829:
830: -- update outcome in JTF_IH_REASONS_TL
831: UPDATE JTF_IH_REASONS_TL
832: SET
833: LANGUAGE = P_LANGUAGE,
834: LAST_UPDATED_BY = G_USER_ID,

Line 831: UPDATE JTF_IH_REASONS_TL

827:
828: -- API body
829:
830: -- update outcome in JTF_IH_REASONS_TL
831: UPDATE JTF_IH_REASONS_TL
832: SET
833: LANGUAGE = P_LANGUAGE,
834: LAST_UPDATED_BY = G_USER_ID,
835: LAST_UPDATE_DATE = SYSDATE,