637:
638: -- Cursor for retrieving from the table to verify insertion
639: CURSOR l_insert_b_check_csr IS
640: SELECT 'x'
641: FROM JTF_IH_REASONS_B
642: WHERE REASON_ID = l_REASON_id;
643:
644: -- Cursor for retrieving from the table to verify insertion
645: CURSOR l_insert_tl_check_csr IS
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: END IF;
715: CLOSE l_insert_tl_check_csr;
716:
717: -- insert new REASON into JTF_IH_REASONS_B
718: INSERT INTO JTF_IH_REASONS_B
719: (
720: REASON_ID,
721: OBJECT_VERSION_NUMBER,
714: END IF;
715: CLOSE l_insert_tl_check_csr;
716:
717: -- insert new REASON into JTF_IH_REASONS_B
718: INSERT INTO JTF_IH_REASONS_B
719: (
720: REASON_ID,
721: OBJECT_VERSION_NUMBER,
722: CREATED_BY,
842: WHERE
843: REASON_ID = P_REASON_ID AND
844: LANGUAGE = P_LANGUAGE;
845:
846: -- insert REASON in JTF_IH_REASONS_B
847: UPDATE JTF_IH_REASONS_B
848: SET
849: LAST_UPDATED_BY = G_USER_ID,
850: LAST_UPDATE_DATE = SYSDATE,
843: REASON_ID = P_REASON_ID AND
844: LANGUAGE = P_LANGUAGE;
845:
846: -- insert REASON in JTF_IH_REASONS_B
847: UPDATE JTF_IH_REASONS_B
848: SET
849: LAST_UPDATED_BY = G_USER_ID,
850: LAST_UPDATE_DATE = SYSDATE,
851: LAST_UPDATE_LOGIN = G_LOGIN_ID,