APPS.JTF_FM_UTL_V dependencies on JTF_FM_REQUEST_HISTORY

Line 1259: JTF_FM_REQUEST_HISTORY

1255: CURSOR CREQID IS
1256: SELECT
1257: count(hist_req_id)
1258: FROM
1259: JTF_FM_REQUEST_HISTORY
1260: WHERE
1261: hist_req_id = fm_pvt_rec.request_id;
1262:
1263: CURSOR CREQ_Q IS

Line 1344: || 'exists in the JTF_FM_REQUEST_HISTORY table';

1340: CLOSE CREQID;
1341: IF l_count >= 1
1342: THEN
1343: l_Error_Msg := 'A request with the request_id passed already'
1344: || 'exists in the JTF_FM_REQUEST_HISTORY table';
1345:
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1347: THEN
1348: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_REQUESTID_REUSED');

Line 1406: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL

1402:
1403: -- Create a hitory record for the request
1404: BEGIN
1405:
1406: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL
1407: (
1408: HIST_REQ_ID,
1409: SUBMIT_DT_TM,
1410: REQUEST,

Line 1681: JTF_FM_REQUEST_HISTORY_ALL

1677:
1678: SELECT
1679: REQUEST INTO l_request
1680: FROM
1681: JTF_FM_REQUEST_HISTORY_ALL
1682: WHERE
1683: HIST_REQ_ID = fm_pvt_rec.request_id
1684: AND
1685: SUBMIT_DT_TM = l_submit_dt

Line 1713: UPDATE JTF_FM_REQUEST_HISTORY_ALL

1709: -- Updating the history table
1710: -- Mod to update org_id when sent
1711: BEGIN
1712:
1713: UPDATE JTF_FM_REQUEST_HISTORY_ALL
1714: SET
1715: TEMPLATE_ID = decode(p_fulfill_electronic_rec.template_id, FND_API.G_MISS_NUM,
1716: NULL,p_fulfill_electronic_rec.template_id),
1717: USER_ID = p_fulfill_electronic_rec.requestor_id,