APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_STATUS_ALL

Line 767: UPDATE JTF_FM_STATUS_ALL

763: BEGIN
764:
765: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
766:
767: UPDATE JTF_FM_STATUS_ALL
768: SET
769: REQUEST_STATUS = p_outcome_code
770: WHERE
771: request_id = p_request_id;

Line 4732: UPDATE JTF_FM_STATUS_ALL

4728: hist_req_id = p_request_id
4729: AND
4730: submit_dt_tm = l_submit_dt;
4731:
4732: UPDATE JTF_FM_STATUS_ALL
4733: SET
4734: request_status='PREVIEWED_SUBMITTED',
4735: last_update_date = sysdate
4736: WHERE

Line 5120: INSERT INTO JTF_FM_STATUS_ALL

5116: DBMS_LOB.WRITE (l_request, l_amount, 1, l_message1);
5117: DBMS_LOB.CLOSE (l_request);
5118:
5119: -- Create a new record in the status table.
5120: INSERT INTO JTF_FM_STATUS_ALL
5121: (
5122: SUBMIT_DT_TM,
5123: TEMPLATE_ID,
5124: USER_ID,

Line 5736: INSERT INTO JTF_FM_STATUS_ALL

5732: DBMS_LOB.WRITE (l_request, l_amount, 1, newXML);
5733: DBMS_LOB.CLOSE (l_request);
5734:
5735: -- Create a new record in the status table.
5736: INSERT INTO JTF_FM_STATUS_ALL
5737: (
5738: SUBMIT_DT_TM,
5739: TEMPLATE_ID,
5740: USER_ID,

Line 6394: DELETE FROM JTF_FM_STATUS_ALL

6390: END;
6391: END IF; --End IF l_request_type = 'M'
6392:
6393: -- Delete the entry from the status table
6394: DELETE FROM JTF_FM_STATUS_ALL
6395: WHERE
6396: request_id = p_request_id;
6397:
6398: l_meaning := 'CANCELLED';