DBA Data[Home] [Help]

APPS.JTF_FM_REQUEST_GRP dependencies on UTL_RAW

Line 565: l_query_raw := UTL_RAW.CAST_TO_RAW(l_query);

561: --dbms_output.put_line('QUERY LENGTH: ' || to_char(length(l_query)));
562: --dbms_output.put_line('QUERY: ' || substr(l_query,1,200));
563:
564: --dbms_output.put_line('casting to raw...');
565: l_query_raw := UTL_RAW.CAST_TO_RAW(l_query);
566:
567: JTF_FM_UTL_V.PRINT_MESSAGE('Query converted to RAW',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
568:
569: --dbms_output.put_line('Length of l_query...' || to_char(length(l_query)));

Line 2367: xmlparser.parseBuffer(l_parser, UTL_RAW.CAST_TO_VARCHAR2(l_buffer));

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);
2369: BUILD_BIND(l_doc,x_bind_info);
2370: xmlparser.FREEPARSER(l_parser);
2371: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 4710: l_mesg := UTL_RAW.CAST_TO_RAW(l_xml);

4706: xmldom.writeToBuffer(l_doc, l_xml);
4707:
4708: -- Convert the message to RAW so that it can be enqueued
4709: -- as RAW payload
4710: l_mesg := UTL_RAW.CAST_TO_RAW(l_xml);
4711: -- Set the default message properties
4712: l_message_properties.priority := l_priority;
4713: -- Enqueue the request in to the Request queue for the
4714: -- fulfillment Processor

Line 5043: payload => UTL_RAW.CAST_TO_RAW(l_message1), msgid => l_message_handle);

5039: -- Enqueue the message into the request queue
5040: dbms_aq.enqueue(queue_name => l_request_queue,
5041: enqueue_options => l_enqueue_options,
5042: message_properties => l_message_properties,
5043: payload => UTL_RAW.CAST_TO_RAW(l_message1), msgid => l_message_handle);
5044:
5045: l_meaning := 'RESUBMITTED';
5046:
5047: -- Following modifications by sxkrishn

Line 5658: payload => UTL_RAW.CAST_TO_RAW(l_footprint_xml), msgid => l_message_handle);

5654:
5655: dbms_aq.enqueue(queue_name => l_request_queue,
5656: enqueue_options => l_enqueue_options,
5657: message_properties => l_message_properties,
5658: payload => UTL_RAW.CAST_TO_RAW(l_footprint_xml), msgid => l_message_handle);
5659:
5660: l_meaning := 'RESUBMITTED';
5661:
5662:

Line 7554: payload => UTL_RAW.CAST_TO_RAW(l_footprint_xml), msgid => l_message_handle);

7550: l_request_queue := GET_QUEUE_NAME('M',l_server_id);
7551: dbms_aq.enqueue(queue_name => l_request_queue,
7552: enqueue_options => l_enqueue_options,
7553: message_properties => l_message_properties,
7554: payload => UTL_RAW.CAST_TO_RAW(l_footprint_xml), msgid => l_message_handle);
7555:
7556: ELSIF l_request_status = 'RESUMED' THEN
7557: l_Error_Msg := 'The request has already been resumed. ';
7558: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_ALREADY_RESUMED', to_char(p_request_id));