DBA Data[Home] [Help]

APPS.AST_WRAPUP_ADM_PVT dependencies on JTF_IH_OUTCOMES_B

Line 51: FROM JTF_IH_OUTCOMES_B

47:
48: -- Cursor for retrieving from the table to verify insertion
49: CURSOR l_insert_b_check_csr IS
50: SELECT 'x'
51: FROM JTF_IH_OUTCOMES_B
52: WHERE OUTCOME_ID = l_outcome_id;
53:
54: -- Cursor for retrieving from the table to verify insertion
55: CURSOR l_insert_tl_check_csr IS

Line 127: -- insert new outcome into JTF_IH_OUTCOMES_B

123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125: CLOSE l_insert_tl_check_csr;
126:
127: -- insert new outcome into JTF_IH_OUTCOMES_B
128: INSERT INTO JTF_IH_OUTCOMES_B
129: (
130: OUTCOME_ID,
131: OBJECT_VERSION_NUMBER,

Line 128: INSERT INTO JTF_IH_OUTCOMES_B

124: END IF;
125: CLOSE l_insert_tl_check_csr;
126:
127: -- insert new outcome into JTF_IH_OUTCOMES_B
128: INSERT INTO JTF_IH_OUTCOMES_B
129: (
130: OUTCOME_ID,
131: OBJECT_VERSION_NUMBER,
132: CREATED_BY,

Line 265: -- insert outcome in JTF_IH_OUTCOMES_B

261: WHERE
262: OUTCOME_ID = P_OUTCOME_ID AND
263: LANGUAGE = P_LANGUAGE;
264:
265: -- insert outcome in JTF_IH_OUTCOMES_B
266: UPDATE JTF_IH_OUTCOMES_B
267: SET
268: LAST_UPDATED_BY = G_USER_ID,
269: LAST_UPDATE_DATE = SYSDATE,

Line 266: UPDATE JTF_IH_OUTCOMES_B

262: OUTCOME_ID = P_OUTCOME_ID AND
263: LANGUAGE = P_LANGUAGE;
264:
265: -- insert outcome in JTF_IH_OUTCOMES_B
266: UPDATE JTF_IH_OUTCOMES_B
267: SET
268: LAST_UPDATED_BY = G_USER_ID,
269: LAST_UPDATE_DATE = SYSDATE,
270: LAST_UPDATE_LOGIN = G_LOGIN_ID,