APPS.PON_FBO_PKG dependencies on DUAL

Line 622: INTO x_xml FROM dual ;

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:
626: END GET_SOL_NOTICE_XML;

Line 798: INTO x_xml FROM dual ;

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:
802: END GET_SECURE_PKG_NOTICE_XML;

Line 877: from dual';

873: xmlelement("uploadtype",''' || PON_FORMS_UTIL_PVT.get_fed_uploadtype(p_auction_header_id) || '''),
874: xmlelement("respdate",''' || fed_respdate ||''' ),
875: xmlelement("files",'''')
876: ))
877: from dual';
878:
879: EXECUTE IMMEDIATE query INTO x_xml;
880:
881: LOG_MESSAGE(l_module,'Query executed');

Line 945: INTO x_xml FROM dual ;

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;
949:

Line 1245: FROM dual;

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
1245: FROM dual;
1246:
1247: l_document_id := p_event.getValueForParameter('DOCUMENT_ID');
1248: l_form_id := p_event.getValueForParameter('FORM_ID');
1249: l_form_code := p_event.getValueForParameter('FORM_CODE');