1 PACKAGE pon_fbo_pkg AUTHID CURRENT_USER AS
2 -- $Header: PON_FBO_PKG.pls 120.7 2011/11/16 11:35:01 irasoolm noship $
3
4 PROCEDURE VALIDATE_FBO_POSTING (p_document_id IN NUMBER,
5 p_form_id IN NUMBER,
6 p_form_code IN VARCHAR2,
7 p_request_id IN NUMBER,
8 x_result IN OUT NOCOPY VARCHAR2,
9 x_message IN OUT NOCOPY VARCHAR2);
10
11 PROCEDURE UPDATE_CP_PROGRESS(p_document_id IN NUMBER,
12 p_form_id IN NUMBER,
13 p_form_code IN VARCHAR2,
14 p_product_code IN VARCHAR2 ,
15 p_request_id IN NUMBER,
16 p_status IN VARCHAR2);
17
18 FUNCTION GET_FORM_NAME(p_form_id IN NUMBER,
19 p_form_code IN VARCHAR2)
20 RETURN VARCHAR2;
21
22 PROCEDURE IS_PRESOL_PUBLISHED(p_auction_header_id IN NUMBER,
23 x_result IN OUT NOCOPY VARCHAR2);
24
25 PROCEDURE SOL_PUBLISH_CHECK(p_auction_header_id IN NUMBER,
26 x_result IN OUT NOCOPY VARCHAR2);
27
28 PROCEDURE IS_DOCUPLOAD_PUBLISHED(p_po_Header_id IN NUMBER,
29 x_result IN OUT NOCOPY VARCHAR2);
30
31 PROCEDURE BACKING_SOLICITATION_INFO(p_po_header_id IN NUMBER,
32 x_sol_number OUT NOCOPY VARCHAR2,
33 x_sol_title OUT NOCOPY VARCHAR2);
34
35 PROCEDURE GET_SOL_NOTICE_XML ( p_auction_header_id IN NUMBER,
36 p_form_id IN NUMBER,
37 x_xml IN OUT NOCOPY xmltype );
38
39 PROCEDURE GET_SECURE_PKG_NOTICE_XML ( p_auction_header_id IN NUMBER,
40 p_form_id IN NUMBER,
41 x_xml IN OUT NOCOPY xmltype );
42
43 PROCEDURE GET_DOCUPLOAD_XML ( p_auction_header_id IN NUMBER,
44 p_form_id IN NUMBER,
45 x_xml IN OUT NOCOPY xmltype );
46
47 PROCEDURE GENERATE_XML
48 ( p_auction_header_id IN NUMBER,
49 p_form_id IN NUMBER,
50 p_form_code IN VARCHAR2,
51 p_request_id IN NUMBER,
52 x_xml IN OUT NOCOPY CLOB,
53 x_result IN OUT NOCOPY VARCHAR2,
54 x_message IN OUT NOCOPY VARCHAR2);
55
56 PROCEDURE STORE_XML_RAISE_EVENT(p_document_id IN NUMBER,
57 p_FORM_id IN NUMBER,
58 p_FORM_code IN VARCHAR2,
59 p_request_id IN NUMBER,
60 p_xml IN CLOB);
61
62 PROCEDURE UPDATE_FBO_POST_STATUS(p_document_id IN NUMBER,
63 p_form_id IN NUMBER,
64 p_form_code IN VARCHAR2,
65 p_product_code IN VARCHAR2,
66 p_status IN VARCHAR2,
67 p_message IN VARCHAR2,
68 x_result IN OUT NOCOPY VARCHAR2);
69
70 FUNCTION PROCESS_FBO_RESPONSE(p_subscription_guid in raw,
71 p_event in out NOCOPY WF_EVENT_T)
72 return VARCHAR2;
73
74 PROCEDURE NOTIFY_REQUESTORS(p_auction_header_id IN NUMBER,
75 p_form_id IN NUMBER );
76
77 PROCEDURE insert_record(p_document_id IN NUMBER,
78 p_form_id IN NUMBER,
79 p_form_code IN VARCHAR2,
80 p_request_id IN NUMBER,
81 p_product_code IN VARCHAR2);
82
83 PROCEDURE INSERT_DOC_UPLOAD_RECORD(p_document_id IN NUMBER,
84 p_form_id IN NUMBER,
85 p_status IN VARCHAR2,
86 p_user_id IN NUMBER,
87 p_user_login IN NUMBER);
88
89 FUNCTION ENCODE_BLOB (p_data IN BLOB) RETURN CLOB;
90
91 FUNCTION get_request_internal_status
92 (
93 p_request_id IN fnd_concurrent_requests.request_id%TYPE
94 ) RETURN VARCHAR2;
95
96 FUNCTION get_request_display_status
97 (
98 p_request_id IN fnd_concurrent_requests.request_id%TYPE
99 ) RETURN VARCHAR2;
100
101 PROCEDURE LOG_MESSAGE( p_module IN VARCHAR2,
102 p_message IN VARCHAR2);
103
104 END PON_FBO_PKG;