APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_REQUEST_HISTORY_ALL

Line 773: UPDATE JTF_FM_REQUEST_HISTORY_ALL

769: REQUEST_STATUS = p_outcome_code
770: WHERE
771: request_id = p_request_id;
772:
773: UPDATE JTF_FM_REQUEST_HISTORY_ALL
774: SET
775: outcome_code = p_outcome_code,
776: message_id = p_msg_id
777: WHERE

Line 4596: FROM JTF_FM_REQUEST_HISTORY_ALL

4592: SERVER_ID = l_server_id;
4593:
4594: CURSOR GETREQUEST IS
4595: SELECT REQUEST, SERVER_ID
4596: FROM JTF_FM_REQUEST_HISTORY_ALL
4597: WHERE
4598: HIST_REQ_ID = p_request_id;
4599:
4600: BEGIN

Line 4722: UPDATE JTF_FM_REQUEST_HISTORY_ALL

4718: payload => l_mesg, msgid => l_message_handle);
4719:
4720: l_meaning := 'PREVIEWED_SUBMITTED';
4721:
4722: UPDATE JTF_FM_REQUEST_HISTORY_ALL
4723: SET
4724: outcome_code = 'PREVIEWED_SUBMITTED',
4725: outcome_desc = 'JTF_FM_API_PREVIEWED_SUBMITTED',
4726: last_update_date = sysdate

Line 4921: FROM JTF_FM_REQUEST_HISTORY_ALL

4917: ORDER_ID,
4918: RESUBMIT_COUNT,
4919: REQUEST_TYPE,
4920: MEDIA_TYPE
4921: FROM JTF_FM_REQUEST_HISTORY_ALL
4922: WHERE
4923: HIST_REQ_ID = p_request_id;
4924:
4925: BEGIN

Line 5053: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL

5049:
5050: INSERT_REQ_CONTENTS(p_request_id,x_request_id);
5051: l_media_type := JTF_FM_UTL_V.GET_MEDIA_TYPE(l_message1);
5052:
5053: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL
5054: (
5055: MESSAGE_ID,
5056: SUBMIT_DT_TM,
5057: TEMPLATE_ID,

Line 5110: FROM JTF_FM_REQUEST_HISTORY_ALL

5106: l_media_type);
5107:
5108: -- Insert the XML request into the History record created above
5109: SELECT REQUEST INTO l_request
5110: FROM JTF_FM_REQUEST_HISTORY_ALL
5111: WHERE HIST_REQ_ID = x_request_id
5112: AND SUBMIT_DT_TM = l_submit_dt
5113: FOR UPDATE;
5114: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);

Line 5418: FROM JTF_FM_REQUEST_HISTORY_ALL

5414: ORDER_ID,
5415: RESUBMIT_COUNT,
5416: REQUEST_TYPE,
5417: MEDIA_TYPE
5418: FROM JTF_FM_REQUEST_HISTORY_ALL
5419: WHERE
5420: HIST_REQ_ID = p_request_id;
5421:
5422:

Line 5669: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL

5665: --- Get a new request id for the resubmitted request
5666: l_media_type := JTF_FM_UTL_V.GET_MEDIA_TYPE(newXML);
5667:
5668:
5669: INSERT INTO JTF_FM_REQUEST_HISTORY_ALL
5670: (
5671: MESSAGE_ID,
5672: SUBMIT_DT_TM,
5673: TEMPLATE_ID,

Line 5726: FROM JTF_FM_REQUEST_HISTORY_ALL

5722: l_media_type);
5723:
5724: -- Insert the XML request into the History record created above
5725: SELECT REQUEST INTO l_request
5726: FROM JTF_FM_REQUEST_HISTORY_ALL
5727: WHERE HIST_REQ_ID = x_request_id
5728: AND SUBMIT_DT_TM = l_submit_dt
5729: FOR UPDATE;
5730: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);

Line 5788: UPDATE JTF_FM_REQUEST_HISTORY_ALL

5784:
5785:
5786:
5787: -- Update the resubmit_count of the parent_request_id
5788: UPDATE JTF_FM_REQUEST_HISTORY_ALL
5789: set resubmit_count = l_requeue_count+1
5790: where hist_req_id = p_request_id;
5791:
5792: UPDATE JTF_FM_EMAIL_STATS

Line 6239: FROM JTF_FM_REQUEST_HISTORY_ALL

6235: --
6236:
6237: CURSOR CMESG IS
6238: SELECT MESSAGE_ID, SERVER_ID, REQUEST_TYPE,OUTCOME_CODE
6239: FROM JTF_FM_REQUEST_HISTORY_ALL
6240: WHERE
6241: HIST_REQ_ID=p_request_id;
6242:
6243: --

Line 6400: UPDATE JTF_FM_REQUEST_HISTORY_ALL

6396: request_id = p_request_id;
6397:
6398: l_meaning := 'CANCELLED';
6399:
6400: UPDATE JTF_FM_REQUEST_HISTORY_ALL
6401: SET
6402: outcome_code = l_meaning
6403: WHERE
6404: hist_req_id = p_request_id;

Line 7402: FROM JTF_FM_REQUEST_HISTORY_ALL

7398:
7399: --
7400: CURSOR CSTATUS( p_request_id NUMBER) IS
7401: SELECT outcome_code, request_type, MESSAGE_ID, SERVER_ID
7402: FROM JTF_FM_REQUEST_HISTORY_ALL
7403: WHERE HIST_REQ_ID = p_request_id;
7404:
7405:
7406: BEGIN