eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_PROCESSED

Line 998: l_processed_row jtf_fm_processed%ROWTYPE;

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) := '';
1002: l_bind_end_tag VARCHAR2(32767) := '';

Line 1009: --select merge_xml into l_bind from JTF_FM_PROCESSED where request_id = p_request_id and job = p_job_id;

1005: BEGIN
1006: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
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

Line 1018: --Getting record from jtf_fm_processed table based upon request_id and job id

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
1019: SELECT *
1020: INTO l_processed_row
1021: FROM jtf_fm_processed
1022: WHERE request_id = p_request_id

Line 1021: FROM jtf_fm_processed

1017:
1018: --Getting record from jtf_fm_processed table based upon request_id and job id
1019: SELECT *
1020: INTO l_processed_row
1021: FROM jtf_fm_processed
1022: WHERE request_id = p_request_id
1023: AND job = p_job_id
1024: ;
1025:

Line 5550: -- info is stored in the JTF_FM_PROCESSED table for this job_id and request_id

5546:
5547:
5548: /*******************************************************************
5549: -- This is a resubmit_job: The query has been executed and the bind
5550: -- info is stored in the JTF_FM_PROCESSED table for this job_id and request_id
5551: -- Extract the CLOB from JTF_FM_REQUEST_HISTORT_ALL, Modify it,
5552: -- Extract the BLOB from JTF_FM_PROCESSED, Add the info from the BLOB to the
5553: -- CLOB and create it as a new CLOB and submit the request as a new req
5554: -- The parent_req_id col should be updated with the original_request_id

Line 5552: -- Extract the BLOB from JTF_FM_PROCESSED, Add the info from the BLOB to the

5548: /*******************************************************************
5549: -- This is a resubmit_job: The query has been executed and the bind
5550: -- info is stored in the JTF_FM_PROCESSED table for this job_id and request_id
5551: -- Extract the CLOB from JTF_FM_REQUEST_HISTORT_ALL, Modify it,
5552: -- Extract the BLOB from JTF_FM_PROCESSED, Add the info from the BLOB to the
5553: -- CLOB and create it as a new CLOB and submit the request as a new req
5554: -- The parent_req_id col should be updated with the original_request_id
5555:
5556: *****************************************************/