APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_INT_REQUEST_HEADER

Line 220: FROM JTF_FM_INT_REQUEST_HEADER

216: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
217:
218: CURSOR crequest_path IS
219: SELECT decode(count(1),0,'N', 'Y','Y')
220: FROM JTF_FM_INT_REQUEST_HEADER
221: WHERE request_id = p_request_id;
222: BEGIN
223:
224: OPEN crequest_path;

Line 370: update JTF_FM_INT_REQUEST_HEADER

366: p_submit_dt_tm => p_submit_dt_tm
367: ) ;
368:
369:
370: update JTF_FM_INT_REQUEST_HEADER
371: set request_status = 'CANCELLED'
372: where REQUEST_ID = p_request_id ;
373: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
374:

Line 997: l_header_row jtf_fm_int_request_header%ROWTYPE;

993: l_api_name CONSTANT VARCHAR2(30) := 'GET_BIND_INFO';
994: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME ||'.'|| l_api_name;
995: l_parser xmlparser.parser;
996: l_doc xmldom.domdocument;
997: l_header_row jtf_fm_int_request_header%ROWTYPE;
998: l_processed_row jtf_fm_processed%ROWTYPE;
999: l_bind_xml LONG := '';
1000: l_bind_open_tag_begin VARCHAR2(32767) := '';

Line 1011: --Getting record from jtf_fm_int_request_header table based upon request_id

1007:
1008: BEGIN
1009: --select merge_xml into l_bind from JTF_FM_PROCESSED where request_id = p_request_id and job = p_job_id;
1010:
1011: --Getting record from jtf_fm_int_request_header table based upon request_id
1012: SELECT *
1013: INTO l_header_row
1014: FROM jtf_fm_int_request_header
1015: WHERE request_id = p_request_id

Line 1014: FROM jtf_fm_int_request_header

1010:
1011: --Getting record from jtf_fm_int_request_header table based upon request_id
1012: SELECT *
1013: INTO l_header_row
1014: FROM jtf_fm_int_request_header
1015: WHERE request_id = p_request_id
1016: ;
1017:
1018: --Getting record from jtf_fm_processed table based upon request_id and job id