DBA Data[Home] [Help]

APPS.PON_FBO_PKG dependencies on PON_FORMS_UTIL_PVT

Line 535: xmlelement("offadd",'''|| PON_FORMS_UTIL_PVT.get_uda_fed_offadd(p_auction_header_id) || '''),

531: xmlelement("date",''' || fed_date || '''),
532: xmlelement("zip",' || fed_zip_col || '),
533: xmlelement("classcod",''' || l_classcode_charvalue || '''),
534: xmlelement("naics",' || fed_naics_col || '),
535: xmlelement("offadd",'''|| PON_FORMS_UTIL_PVT.get_uda_fed_offadd(p_auction_header_id) || '''),
536: xmlelement("subject",' || fed_subject_col || ' ),
537: xmlelement("solnbr",''' || fed_solnbr ||''' ),';
538:
539: IF l_form_code IN ('FED_MOD_PRESOL','FED_AMD_COMB_SOL') THEN

Line 729: xmlelement("on_fbo",''' || PON_FORMS_UTIL_PVT.GET_FED_ONFBO(p_auction_header_id) || '''),

725:
726: query := 'SELECT xmlelement("' || l_soap_operation || '",
727: xmlelement("data",
728: xmlelement("date",''' || To_Char(SYSDATE,'YYYYMMDD') || '''),
729: xmlelement("on_fbo",''' || PON_FORMS_UTIL_PVT.GET_FED_ONFBO(p_auction_header_id) || '''),
730: xmlelement("pr_number",' || FED_PRNUMBER_COL || '),
731: xmlelement("package_label",' || fed_PKGLABEL_col || '),
732: xmlelement("project_number",'|| FED_PROJECTNUMBER_COL || '),
733: xmlelement("nsn_mmac",' || FED_NSNMMAC_COL || ' ),

Line 873: xmlelement("uploadtype",''' || PON_FORMS_UTIL_PVT.get_fed_uploadtype(p_auction_header_id) || '''),

869: xmlelement("data",
870: xmlelement("date",''' || To_Char(SYSDATE,'YYYYMMDD')|| '''),
871: xmlelement("solnbr",''' || fed_solnbr ||''' ),
872: xmlelement("ntype",''' || l_ntype_val ||''' ),
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';