1 PACKAGE PO_FBO_PKG AUTHID CURRENT_USER AS
2 -- $Header: PO_FBO_PKG.pls 120.1 2011/11/10 12:28:14 inagdeo noship $
3
4 procedure IS_SOURCING_INSTALLED(itemtype in varchar2,
5 itemkey in varchar2,
6 actid in number,
7 funcmode in varchar2,
8 resultout out NOCOPY varchar2);
9
10 procedure HAS_ASSOCIATED_SOLICITATION(itemtype in varchar2,
11 itemkey in varchar2,
12 actid in number,
13 funcmode in varchar2,
14 resultout out NOCOPY varchar2);
15
16 procedure SUBMIT_AWARD_NOTICE(itemtype in varchar2,
17 itemkey in varchar2,
18 actid in number,
19 funcmode in varchar2,
20 resultout out NOCOPY varchar2);
21
22 PROCEDURE GENERATE_XML ( p_document_id IN NUMBER,
23 p_notice_type IN VARCHAR2,
24 p_request_id IN NUMBER,
25 x_xml IN OUT NOCOPY CLOB,
26 x_result IN OUT NOCOPY VARCHAR2,
27 x_message IN OUT NOCOPY VARCHAR2 );
28
29 FUNCTION ENCODE_BLOB (p_data BLOB) RETURN CLOB;
30
31 PROCEDURE INSERT_IN_PON_FBO_POSTS(p_document_id IN NUMBER,
32 p_notice_type IN VARCHAR2,
33 p_request_id IN NUMBER);
34
35 PROCEDURE VALIDATE_FBO_POSTING (p_document_id IN NUMBER,
36 p_notice_type IN VARCHAR2,
37 p_request_id IN NUMBER,
38 x_result IN OUT NOCOPY VARCHAR2,
39 x_message IN OUT NOCOPY VARCHAR2);
40
41 END PO_FBO_PKG;