APPS.PON_FBO_PKG dependencies on XMLTYPE

Line 292: x_xml IN OUT NOCOPY xmltype )

288: END backing_solicitation_info;
289:
290: PROCEDURE GET_SOL_NOTICE_XML ( p_auction_header_id IN NUMBER,
291: p_form_id IN NUMBER,
292: x_xml IN OUT NOCOPY xmltype )
293: AS
294: l_result xmltype;
295: l_username VARCHAR2(1001);
296: l_pwd VARCHAR2(1000);

Line 294: l_result xmltype;

290: PROCEDURE GET_SOL_NOTICE_XML ( p_auction_header_id IN NUMBER,
291: p_form_id IN NUMBER,
292: x_xml IN OUT NOCOPY xmltype )
293: AS
294: l_result xmltype;
295: l_username VARCHAR2(1001);
296: l_pwd VARCHAR2(1000);
297: query VARCHAR2(20000);
298: l_form_code VARCHAR2(100);

Line 621: select updatexml(x_xml,'//files',xmltype(files_clob))

617: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
618:
619: LOG_MESSAGE(l_module,'file element constructed');
620:
621: select updatexml(x_xml,'//files',xmltype(files_clob))
622: INTO x_xml FROM dual ;
623:
624: LOG_MESSAGE(l_module,'file handling done');
625:

Line 630: x_xml IN OUT NOCOPY xmltype )

626: END GET_SOL_NOTICE_XML;
627:
628: PROCEDURE GET_SECURE_PKG_NOTICE_XML ( p_auction_header_id IN NUMBER,
629: p_form_id IN NUMBER,
630: x_xml IN OUT NOCOPY xmltype )
631: AS
632: l_result xmltype;
633: query VARCHAR2(20000);
634: l_form_code VARCHAR2(100);

Line 632: l_result xmltype;

628: PROCEDURE GET_SECURE_PKG_NOTICE_XML ( p_auction_header_id IN NUMBER,
629: p_form_id IN NUMBER,
630: x_xml IN OUT NOCOPY xmltype )
631: AS
632: l_result xmltype;
633: query VARCHAR2(20000);
634: l_form_code VARCHAR2(100);
635:
636: FED_PRNUMBER_COL VARCHAR2(1000);

Line 797: select updatexml(x_xml,'//files',xmltype(files_clob))

793: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
794:
795: LOG_MESSAGE(l_module,'file element constructed');
796:
797: select updatexml(x_xml,'//files',xmltype(files_clob))
798: INTO x_xml FROM dual ;
799:
800: LOG_MESSAGE(l_module,'file handling done');
801:

Line 806: x_xml IN OUT NOCOPY xmltype )

802: END GET_SECURE_PKG_NOTICE_XML;
803:
804: PROCEDURE GET_DOCUPLOAD_XML ( p_auction_header_id IN NUMBER,
805: p_form_id IN NUMBER,
806: x_xml IN OUT NOCOPY xmltype )
807: AS
808: l_username VARCHAR2(1001);
809: l_pwd VARCHAR2(1000);
810: query VARCHAR2(20000);

Line 944: select updatexml(x_xml,'//files',xmltype(files_clob))

940: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
941:
942: LOG_MESSAGE(l_module,'file element constructed');
943:
944: select updatexml(x_xml,'//files',xmltype(files_clob))
945: INTO x_xml FROM dual ;
946:
947:
948: END GET_DOCUPLOAD_XML;

Line 964: l_result xmltype;

960: AS
961:
962: l_form_code pon_forms_sections.form_code%TYPE;
963: l_form_id pon_forms_sections.form_id%TYPE;
964: l_result xmltype;
965:
966: l_module VARCHAR2(100) := 'generate_xml';
967:
968:

Line 1229: l_response_xml xmltype;

1225: p_event in out NOCOPY WF_EVENT_T)
1226: RETURN VARCHAR2 IS
1227: l_module VARCHAR2(100) := 'PROCESS_FBO_RESPONSE';
1228: l_response_clob CLOB;
1229: l_response_xml xmltype;
1230: l_result VARCHAR2(100);
1231: l_res_message VARCHAR2(1000);
1232: l_document_id VARCHAR2(100);
1233: l_form_id VARCHAR2(100);

Line 1240: l_response_xml := xmltype(l_response_clob);

1236: BEGIN
1237: LOG_MESSAGE(l_module,'Begin');
1238:
1239: l_response_clob := p_event.getEventData;
1240: l_response_xml := xmltype(l_response_clob);
1241:
1242: SELECT l_response_xml.extract('//success/text()').getStringVal(),
1243: l_response_xml.extract('//item/text()').getStringVal()
1244: INTO l_result,l_res_message