DBA Data[Home] [Help]

APPS.JTF_FM_UTL_V dependencies on JTF_FM_REQUEST_HISTORY_ALL

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,