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
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,
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,
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,
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,