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 DBMS_LOB

Line 577: DBMS_LOB.OPEN(l_file_data,DBMS_LOB.LOB_READWRITE);

573: where file_id = x_query_file_id
574: for update;
575:
576: l_amount := length(l_query ) ;
577: DBMS_LOB.OPEN(l_file_data,DBMS_LOB.LOB_READWRITE);
578: DBMS_LOB.WRITE(l_file_data, l_amount, 1, l_query_raw);
579: DBMS_LOB.CLOSE(l_file_data);
580:
581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 578: DBMS_LOB.WRITE(l_file_data, l_amount, 1, l_query_raw);

574: for update;
575:
576: l_amount := length(l_query ) ;
577: DBMS_LOB.OPEN(l_file_data,DBMS_LOB.LOB_READWRITE);
578: DBMS_LOB.WRITE(l_file_data, l_amount, 1, l_query_raw);
579: DBMS_LOB.CLOSE(l_file_data);
580:
581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
582:

Line 579: DBMS_LOB.CLOSE(l_file_data);

575:
576: l_amount := length(l_query ) ;
577: DBMS_LOB.OPEN(l_file_data,DBMS_LOB.LOB_READWRITE);
578: DBMS_LOB.WRITE(l_file_data, l_amount, 1, l_query_raw);
579: DBMS_LOB.CLOSE(l_file_data);
580:
581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
582:
583: update jtf_fm_queries_all set file_id = x_query_file_id

Line 2361: l_amount := DBMS_LOB.GETLENGTH(l_bind);

2357: RAISE FND_API.G_EXC_ERROR;
2358: END;
2359:
2360: /*
2361: l_amount := DBMS_LOB.GETLENGTH(l_bind);
2362:
2363: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2364: DBMS_LOB.READ (l_bind, l_amount, 1, l_buffer);
2365:

Line 2364: DBMS_LOB.READ (l_bind, l_amount, 1, l_buffer);

2360: /*
2361: l_amount := DBMS_LOB.GETLENGTH(l_bind);
2362:
2363: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2364: DBMS_LOB.READ (l_bind, l_amount, 1, l_buffer);
2365:
2366: l_parser := xmlparser.newparser();
2367: xmlparser.parseBuffer(l_parser, UTL_RAW.CAST_TO_VARCHAR2(l_buffer));
2368: l_doc := xmlparser.getdocument(l_parser);

Line 5013: l_amount := DBMS_LOB.GETLENGTH(l_request);

5009:
5010: RAISE FND_API.G_EXC_ERROR;
5011: ELSE
5012: -- Read the XML request from the CLOB
5013: l_amount := DBMS_LOB.GETLENGTH(l_request);
5014: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5015: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);
5016: l_message_properties.priority := l_priority;
5017:

Line 5015: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);

5011: ELSE
5012: -- Read the XML request from the CLOB
5013: l_amount := DBMS_LOB.GETLENGTH(l_request);
5014: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5015: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);
5016: l_message_properties.priority := l_priority;
5017:
5018:
5019:

Line 5114: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);

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);
5115: l_amount := LENGTH(l_message1);
5116: DBMS_LOB.WRITE (l_request, l_amount, 1, l_message1);
5117: DBMS_LOB.CLOSE (l_request);
5118:

Line 5116: DBMS_LOB.WRITE (l_request, l_amount, 1, l_message1);

5112: AND SUBMIT_DT_TM = l_submit_dt
5113: FOR UPDATE;
5114: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);
5115: l_amount := LENGTH(l_message1);
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

Line 5117: DBMS_LOB.CLOSE (l_request);

5113: FOR UPDATE;
5114: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);
5115: l_amount := LENGTH(l_message1);
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: (

Line 5537: l_amount := DBMS_LOB.GETLENGTH(l_request);

5533:
5534: RAISE FND_API.G_EXC_ERROR;
5535: ELSE
5536: -- Read the XML request from the CLOB
5537: l_amount := DBMS_LOB.GETLENGTH(l_request);
5538: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5539: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);
5540: l_message_properties.priority := l_priority;
5541:

Line 5539: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);

5535: ELSE
5536: -- Read the XML request from the CLOB
5537: l_amount := DBMS_LOB.GETLENGTH(l_request);
5538: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5539: DBMS_LOB.READ (l_request, l_amount, 1, l_buffer);
5540: l_message_properties.priority := l_priority;
5541:
5542:
5543:

Line 5730: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);

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);
5731: l_amount := LENGTH(newXML);
5732: DBMS_LOB.WRITE (l_request, l_amount, 1, newXML);
5733: DBMS_LOB.CLOSE (l_request);
5734:

Line 5732: DBMS_LOB.WRITE (l_request, l_amount, 1, newXML);

5728: AND SUBMIT_DT_TM = l_submit_dt
5729: FOR UPDATE;
5730: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);
5731: l_amount := LENGTH(newXML);
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

Line 5733: DBMS_LOB.CLOSE (l_request);

5729: FOR UPDATE;
5730: DBMS_LOB.OPEN(l_request, DBMS_LOB.LOB_READWRITE);
5731: l_amount := LENGTH(newXML);
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: (