APPS.PO_FBO_PKG dependencies on PON_FBO_PKG

Line 106: PON_FBO_PKG.backing_solicitation_info(l_document_id,l_solicitation_no,

102: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
103: itemkey => itemkey,
104: aname => 'DOCUMENT_ID');
105:
106: PON_FBO_PKG.backing_solicitation_info(l_document_id,l_solicitation_no,
107: l_solicitation_title);
108:
109: x_progress := 'PO_FBO_PKG.HAS_ASSOCIATED_SOLICITATION Solicitation No : ' || l_solicitation_no;
110: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 221: -- If XML is successfully generated,it calls PON_FBO_PKG.store_xml_raise_event

217: --Pre-reqs: None.
218: --Function:
219: -- This procedure generates XML for Award Notice/J&A Notice.
220: -- It is called from sourcing concurrent program - GenerateFboXmlCp.java
221: -- If XML is successfully generated,it calls PON_FBO_PKG.store_xml_raise_event
222: --Parameters:
223: --IN:
224: --p_document_id
225: -- po_header_id

Line 341: pon_fbo_pkg.backing_solicitation_info(p_document_id,

337: )
338: )';
339:
340: --Get backing solicitation info
341: pon_fbo_pkg.backing_solicitation_info(p_document_id,
342: l_solicitation_no,
343: l_solicitation_title);
344:
345: --Get naics code

Line 443: PON_FBO_PKG.store_xml_raise_event(p_document_id,NULL,p_notice_type,p_request_id,x_xml);

439:
440:
441: if l_result is not null then
442: x_xml := l_result.getclobval();
443: PON_FBO_PKG.store_xml_raise_event(p_document_id,NULL,p_notice_type,p_request_id,x_xml);
444: x_result := 'S';
445: else
446: x_result := 'E';
447: x_message := 'PON_FBO_XML_ERR';

Line 748: pon_fbo_pkg.is_docupload_published(p_document_id,x_result);

744:
745: BEGIN
746:
747: IF p_notice_type = 'FED_AWARD' THEN
748: pon_fbo_pkg.is_docupload_published(p_document_id,x_result);
749:
750: IF x_result <> 'S' THEN
751: x_message := 'PON_FBO_DOCUPLOAD_NOT_POSTED';
752: RETURN;

Line 764: AND pon_fbo_pkg.Get_request_internal_status(cp_request_id) <> 'ERROR'

760: FROM pon_fbo_posts
761: WHERE document_id = p_document_id
762: AND form_id = p_notice_type
763: AND Nvl(fbo_post_status, 'INPROGRESS') NOT IN ( 'SUCCESS', 'FAILED' )
764: AND pon_fbo_pkg.Get_request_internal_status(cp_request_id) <> 'ERROR'
765: AND Nvl2(p_request_id, cp_request_id, -9999) <> Nvl(p_request_id, -9998)
766: AND ROWNUM < 2;
767:
768: IF l_is_post_pending = 'Y' THEN