DBA Data[Home] [Help]

APPS.AST_WRAPUP_ADM_PVT dependencies on JTF_IH_OUTCOMES_TL

Line 57: FROM JTF_IH_OUTCOMES_TL

53:
54: -- Cursor for retrieving from the table to verify insertion
55: CURSOR l_insert_tl_check_csr IS
56: SELECT 'x'
57: FROM JTF_IH_OUTCOMES_TL
58: WHERE OUTCOME_ID = l_outcome_id;
59:
60: BEGIN
61: -- Standard start of API savepoint

Line 84: -- insert new outcome into JTF_IH_OUTCOMES_TL

80: OPEN l_outcome_id_csr;
81: FETCH l_outcome_id_csr INTO l_outcome_id;
82: CLOSE l_outcome_id_csr;
83:
84: -- insert new outcome into JTF_IH_OUTCOMES_TL
85: INSERT INTO JTF_IH_OUTCOMES_TL
86: (
87: OUTCOME_ID,
88: LANGUAGE,

Line 85: INSERT INTO JTF_IH_OUTCOMES_TL

81: FETCH l_outcome_id_csr INTO l_outcome_id;
82: CLOSE l_outcome_id_csr;
83:
84: -- insert new outcome into JTF_IH_OUTCOMES_TL
85: INSERT INTO JTF_IH_OUTCOMES_TL
86: (
87: OUTCOME_ID,
88: LANGUAGE,
89: OBJECT_VERSION_NUMBER,

Line 249: -- update outcome in JTF_IH_OUTCOMES_TL

245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: -- API body
248:
249: -- update outcome in JTF_IH_OUTCOMES_TL
250: UPDATE JTF_IH_OUTCOMES_TL
251: SET
252: LANGUAGE = P_LANGUAGE,
253: LAST_UPDATED_BY = G_USER_ID,

Line 250: UPDATE JTF_IH_OUTCOMES_TL

246:
247: -- API body
248:
249: -- update outcome in JTF_IH_OUTCOMES_TL
250: UPDATE JTF_IH_OUTCOMES_TL
251: SET
252: LANGUAGE = P_LANGUAGE,
253: LAST_UPDATED_BY = G_USER_ID,
254: LAST_UPDATE_DATE = SYSDATE,