1 PACKAGE PON_AUCTION_APPROVAL_PKG AUTHID CURRENT_USER as
2 /* $Header: PONAPPRS.pls 120.7 2009/07/31 15:17:49 ssreekum ship $ */
3 g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_AUCTION_APPROVAL_PKG.';
4
5 PROCEDURE CANCEL_NOTIFICATION(p_auction_header_id number,
6 p_user_name varchar2,
7 p_resultOut out nocopy number);
8 PROCEDURE UPDATE_NOTIF_ONLINE (p_auction_header_id number,
9 p_user_name varchar2,
10 p_result varchar2,
11 p_note_to_buyer varchar2,
12 p_signed_date DATE,
13 p_resultOut out nocopy NUMBER
14 );
15 Procedure Close_Child_Process(p_parent_item_key Varchar2);
16 Procedure UPD_AUCTION_STATUSHISTORY(p_auction_header_id number,
17 p_status Varchar2,
18 p_notes Varchar2,
19 p_user_id Number,
20 p_upd_history_type VARCHAR2,
21 p_signed_date DATE);
22 PROCEDURE Doc_Approved(itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 uncmode in varchar2,
26 resultout out nocopy varchar2);
27 PROCEDURE Doc_TimedOut(itemtype in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 uncmode in varchar2,
31 resultout out nocopy varchar2);
32 PROCEDURE Doc_Rejected(itemtype in varchar2,
33 itemkey in varchar2,
34 actid in number,
35 uncmode in varchar2,
36 resultout out nocopy varchar2);
37 PROCEDURE User_Approved(itemtype in varchar2,
38 itemkey in varchar2,
39 actid in number,
40 uncmode in varchar2,
41 resultout out nocopy varchar2);
42 PROCEDURE User_Rejected(itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 uncmode in varchar2,
46 resultout out nocopy varchar2);
47
48
49 PROCEDURE UPDATE_DOC_TO_CANCELLED ( itemtype in varchar2,
50 Itemkey in varchar2,
51 actid in number,
52 uncmode in varchar2,
53 resultout out nocopy varchar2);
54
55 PROCEDURE SUBMIT_FOR_APPROVAL(p_auction_header_id_encrypted VARCHAR2, -- 1
56 p_auction_header_id number, -- 2
57 p_note_to_approvers varchar2, -- 3
58 p_submit_user_name varchar2, -- 4
59 p_redirect_func varchar2); -- 5
60
61 PROCEDURE StartUserApprovalProcess(itemtype in varchar2,
62 Itemkey in varchar2,
63 actid in number,
64 uncmode in varchar2,
65 resultout out nocopy varchar2);
66
67 PROCEDURE User_Decision_Without_WF(p_user_id in number,
68 p_decision in varchar2,
69 p_notes in varchar2,
70 p_auctionHeaderId in number);
71
72 PROCEDURE SET_NOTIFICATION_SUBJECT(p_itemtype in varchar2,
73 p_itemkey in varchar2,
74 p_msg_suffix in varchar2,
75 p_doc_number in varchar2,
76 p_orig_document_number in varchar2,
77 p_amendment_number in number,
78 p_auction_title in varchar2);
79
80 --added for eric test only,begin
81 PROCEDURE StartEmdApprovalProcess
82 (
83 itemtype IN VARCHAR2
84 , Itemkey IN VARCHAR2
85 , actid IN NUMBER
86 , uncmode IN VARCHAR2
87 , resultout OUT NOCOPY VARCHAR2
88 );
89
90 --choli add for emd update page link in notification
91 Procedure Get_Emd_HeaderId(pn_notification_id IN NUMBER,
92 l_auction_header_id OUT NOCOPY NUMBER) ;
93
94 PROCEDURE Emd_User_Approved
95 (
96 itemtype IN VARCHAR2
97 , itemkey IN VARCHAR2
98 , actid IN NUMBER
99 , uncmode IN VARCHAR2
100 , resultout OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE Emd_User_Rejected
104 (
105 itemtype IN VARCHAR2
106 , itemkey IN VARCHAR2
107 , actid IN NUMBER
108 , uncmode IN VARCHAR2
109 , resultout OUT NOCOPY VARCHAR2
110 );
111 --added for eric test only,end
112
113 /* Added for Federal CLM Solicitaion Amendments Project.
114 * Will be called from Souring Approval Workflow in case of federal document.
115 */
116 PROCEDURE Create_Cnf_Doc_CLM(itemtype in varchar2,
117 itemkey in varchar2,
118 actid in number,
119 uncmode in varchar2,
120 resultout out nocopy varchar2);
121
122 /* Added for Federal CLM Solicitaion Amendments Project.
123 * Will be called from approval page when approval is done online.
124 * Gets the conformed document number, auction header id, revision,
125 * concurrent req id, (doc number + revision) message, amendment_number from workflow.
126 */
127 PROCEDURE get_cnf_doc_params_wf(p_auction_header_id IN NUMBER,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_cnf_doc_auc_head_id OUT NOCOPY NUMBER,
130 x_cnf_doc_number OUT NOCOPY VARCHAR2,
131 x_cnf_doc_rev OUT NOCOPY NUMBER,
132 x_request_id OUT NOCOPY NUMBER,
133 x_message OUT NOCOPY VARCHAR2,
134 x_amend_doc_number OUT NOCOPY VARCHAR2,
135 x_error_messages OUT NOCOPY VARCHAR2,
136 x_is_unexp_error OUT NOCOPY VARCHAR2);
137
138 /* Added for Federal CLM Solicitaion Amendments Project.
139 * Will be called from NegotiationCreation am in case of cancellation amendments.
140 * This procedure inturn calls actual submit_for_approval procedure.
141 */
142 PROCEDURE SUB_CANCEL_AMEND_FOR_APPROVAL(
143 p_auction_header_id_encrypted VARCHAR2,
144 p_auction_header_id number,
145 p_note_to_approvers varchar2,
146 p_submit_user_name varchar2,
147 p_redirect_func varchar2,
148 p_cancel_supplier_note varchar2);
149
150
151 /* Added for Federal CLM Solicitaion Amendments Project.
152 * Will be called from Souring Approval Workflow to find if amendment type is cancellation.
153 */
154 PROCEDURE Is_Cancel_Amendment(itemtype in varchar2,
155 itemkey in varchar2,
156 actid in number,
157 uncmode in varchar2,
158 resultout out nocopy varchar2);
159
160 /* Added for Federal CLM Solicitaion Amendments Project.
161 * Will be called from Souring Approval Workflow to cancel the original document.
162 */
163 PROCEDURE CANCEL_FEDERAL_DOCUMENT_WF(itemtype in varchar2,
164 itemkey in varchar2,
165 actid in number,
166 uncmode in varchar2,
167 resultout out nocopy varchar2);
168
169
170 /* Added for Federal CLM Solicitaion Amendments Project.
171 * Will be called from approval page when approval is done online.
172 * Gets the conformed document number, auction header id, revision from workflow.
173 */
174 PROCEDURE get_cancel_doc_params_wf(p_auction_header_id IN NUMBER,
175 x_cnf_doc_auc_head_id OUT NOCOPY NUMBER,
176 x_cnf_doc_number OUT NOCOPY VARCHAR2,
177 x_cnf_doc_rev OUT NOCOPY NUMBER,
178 x_message OUT NOCOPY VARCHAR2,
179 x_amend_doc_number OUT NOCOPY VARCHAR2);
180
181 end PON_AUCTION_APPROVAL_PKG;
182
183