APPS.PO_FBO_PKG dependencies on PON_FBO_POSTS

Line 186: INSERT_IN_PON_FBO_POSTS(l_document_id,'FED_AWARD',l_request_id);

182: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : Request id : ' || l_request_id;
183: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
184:
185:
186: INSERT_IN_PON_FBO_POSTS(l_document_id,'FED_AWARD',l_request_id);
187:
188: COMMIT;
189:
190: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;

Line 668: --Name: INSERT_IN_PON_FBO_POSTS

664: END ENCODE_BLOB;
665:
666: -------------------------------------------------------------------------------
667: --Start of Comments
668: --Name: INSERT_IN_PON_FBO_POSTS
669: --Pre-reqs: None.
670: --Function:
671: --This inserts record in pon_fbo_posts
672: --Parameters:

Line 671: --This inserts record in pon_fbo_posts

667: --Start of Comments
668: --Name: INSERT_IN_PON_FBO_POSTS
669: --Pre-reqs: None.
670: --Function:
671: --This inserts record in pon_fbo_posts
672: --Parameters:
673: --IN:
674: --p_document_id
675: -- po_header_id

Line 683: PROCEDURE INSERT_IN_PON_FBO_POSTS(p_document_id IN NUMBER,

679: -- Concurrent program request id
680: --End of Comments
681: -------------------------------------------------------------------------------
682:
683: PROCEDURE INSERT_IN_PON_FBO_POSTS(p_document_id IN NUMBER,
684: p_notice_type IN VARCHAR2,
685: p_request_id IN NUMBER
686: ) IS
687:

Line 689: INSERT INTO pon_fbo_posts

685: p_request_id IN NUMBER
686: ) IS
687:
688: BEGIN
689: INSERT INTO pon_fbo_posts
690: (transaction_id,
691: document_id,
692: form_id,
693: form_code,

Line 697: VALUES(PON_FBO_POSTS_S.NEXTVAL,

693: form_code,
694: product_code,
695: cp_request_id,
696: xml_request_date)
697: VALUES(PON_FBO_POSTS_S.NEXTVAL,
698: p_document_id,
699: NULL,
700: p_notice_type,
701: 'PO',

Line 709: END INSERT_IN_PON_FBO_POSTS;

705: EXCEPTION
706: WHEN OTHERS THEN
707: NULL;
708:
709: END INSERT_IN_PON_FBO_POSTS;
710:
711:
712: -------------------------------------------------------------------------------
713: --Start of Comments

Line 760: FROM pon_fbo_posts

756: BEGIN
757:
758: SELECT 'Y'
759: INTO l_is_post_pending
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'