1 PACKAGE PO_ChangeOrderWF_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVSCWS.pls 120.8.12020000.2 2013/02/10 15:52:09 vegajula ship $ */
3
4 procedure IsPOHeaderRejected( p_api_version in number,
5 x_return_status out NOCOPY varchar2,
6 p_header_id in number,
7 p_release_id in number,
8 p_revision_num in number,
9 x_result_code out NOCOPY varchar);
10
11 procedure KickOffPOApproval( p_api_version in number,
12 x_return_status out NOCOPY varchar2,
13 p_header_id in number,
14 p_release_id in number,
15 x_return_msg out NOCOPY varchar2);
16
17 -- Making this api public RDP requirements
18 procedure NotifySupAllChgRpdWF( p_header_id in number,
19 p_release_id in number,
20 p_revision_num in number,
21 p_chg_req_grp_id in number);
22
23
24 PROCEDURE GEN_NTF_FOR_PLAN_SUP_CHN( p_code IN varchar2,
25 display_type in Varchar2,
26 document in out NOCOPY clob,
27 document_type in out NOCOPY varchar2);
28
29 PROCEDURE GEN_NTF_FOR_REQ_SUP_CHN( p_code IN varchar2,
30 display_type in Varchar2,
31 document in out NOCOPY clob,
32 document_type in out NOCOPY varchar2);
33
34 PROCEDURE GEN_NTF_FOR_SUP_BUY_RP( p_chg_req_grp_id IN number,
35 display_type in Varchar2,
36 document in out NOCOPY clob,
37 document_type in out NOCOPY varchar2);
38
39
40
41 PROCEDURE GEN_NTF_FOR_BUYER_SUP_CHG(p_code IN varchar2,
42 display_type in Varchar2,
43 document in out NOCOPY clob,
44 document_type in out NOCOPY varchar2);
45
46 ---------------------------------------------------------
47 -- workflow document procedure to generate notification
48 -- subject for buyer
49 ---------------------------------------------------------
50 PROCEDURE GEN_NTF_FOR_BUYER_SUBJECT
51 (document_id IN VARCHAR2,
52 display_type IN VARCHAR2,
53 document IN OUT nocopy VARCHAR2,
54 document_type IN OUT nocopy VARCHAR2);
55
56 ---------------------------------------------------------
57 -- workflow document procedure to generate notification
58 -- subject for supplier
59 ---------------------------------------------------------
60 PROCEDURE GEN_NTF_FOR_SUP_SUBJECT
61 (document_id IN VARCHAR2,
62 display_type IN VARCHAR2,
63 document IN OUT nocopy VARCHAR2,
64 document_type IN OUT nocopy VARCHAR2);
65
66 ---------------------------------------------------------
67 -- workflow document procedure to generate notification
68 -- subject for planner
69 ---------------------------------------------------------
70 PROCEDURE GEN_NTF_FOR_PLAN_SUBJECT
71 (document_id IN VARCHAR2,
72 display_type IN VARCHAR2,
73 document IN OUT nocopy VARCHAR2,
74 document_type IN OUT nocopy VARCHAR2);
75
76 ---------------------------------------------------------
77 -- workflow document procedure to generate notification
78 -- subject for requester
79 ---------------------------------------------------------
80 PROCEDURE GEN_NTF_FOR_REQ_SUBJECT
81 (document_id IN VARCHAR2,
82 display_type IN VARCHAR2,
83 document IN OUT nocopy VARCHAR2,
84 document_type IN OUT nocopy VARCHAR2);
85
86 procedure ProcessHdrCancelResponse( p_api_version in number,
87 x_return_status out NOCOPY varchar2,
88 p_header_id in number,
89 p_release_id in number,
90 p_revision_num in number,
91 p_user_id in number,
92 p_acc_rej in varchar2,
93 p_reason in varchar2);
94
95
96 procedure ProcessResponse(p_api_version in number,
97 x_return_status out NOCOPY varchar2,
98 p_header_id in number,
99 p_release_id in number,
100 p_revision_num in number,
101 p_chg_req_grp_id in number,
102 p_user_id in number,
103 x_err_msg out NOCOPY varchar2,
104 x_return_code out NOCOPY number,
105 x_doc_check_rec_type out NOCOPY POS_ERR_TYPE,
106 p_flag in varchar2,
107 p_launch_approvals_flag in varchar2,
108 p_mass_update_releases IN VARCHAR2 DEFAULT NULL -- Bug 3373453
109 );
110
111 procedure StartSupplierChangeWF( p_api_version in number,
112 x_return_status out NOCOPY varchar2,
113 p_header_id in number,
114 p_release_id in number,
115 p_revision_num in number,
116 p_chg_req_grp_id in number,
117 p_acc_req_flag in varchar2 default 'N');
118
119 procedure NOTIFY_REQ_PLAN ( itemtype in varchar2,
120 itemkey in varchar2,
121 actid in number,
122 funcmode in varchar2,
123 resultout out NOCOPY varchar2);
124
125 procedure PROCESS_RESPONSE ( itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 funcmode in varchar2,
129 resultout out NOCOPY varchar2);
130
131 procedure BUYER_ACCEPT_CHANGE ( itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 funcmode in varchar2,
135 resultout out NOCOPY varchar2);
136
137 procedure BUYER_REJECT_CHANGE ( itemtype in varchar2,
138 itemkey in varchar2,
139 actid in number,
140 funcmode in varchar2,
141 resultout out NOCOPY varchar2);
142
143 procedure IS_PRORATE_NEEDED( itemtype in varchar2,
144 itemkey in varchar2,
145 actid in number,
146 funcmode in varchar2,
147 resultout out NOCOPY varchar2);
148
149 procedure CHG_STATUS_TO_APPROVED( itemtype in varchar2,
150 itemkey in varchar2,
151 actid in number,
152 funcmode in varchar2,
153 resultout out NOCOPY varchar2);
154
155 procedure CARRY_SUP_ACK_TO_NEW_REV( itemtype in varchar2,
156 itemkey in varchar2,
157 actid in number,
158 funcmode in varchar2,
159 resultout out NOCOPY varchar2);
160
161 procedure DOES_PO_REQ_SUP_ACK( itemtype in varchar2,
162 itemkey in varchar2,
163 actid in number,
164 funcmode in varchar2,
165 resultout out NOCOPY varchar2);
166
167 procedure is_po_approved_by_hie( itemtype in varchar2,
168 itemkey in varchar2,
169 actid in number,
170 funcmode in varchar2,
171 resultout out NOCOPY varchar2);
172
173 procedure set_data_sup_chn_evt( itemtype in varchar2,
174 itemkey in varchar2,
175 actid in number,
176 funcmode in varchar2,
177 resultout out NOCOPY varchar2);
178
179 procedure ANY_NEW_SUP_CHN( itemtype in varchar2,
180 itemkey in varchar2,
181 actid in number,
182 funcmode in varchar2,
183 resultout out NOCOPY varchar2);
184
185 procedure any_supplier_change( itemtype in varchar2,
186 itemkey in varchar2,
187 actid in number,
188 funcmode in varchar2,
189 resultout out NOCOPY varchar2);
190
191 procedure Register_rejection ( itemtype in varchar2,
192 itemkey in varchar2,
193 actid in number,
194 funcmode in varchar2,
195 result out NOCOPY varchar2 );
196
197 procedure IS_PO_HDR_REJECTED( itemtype in varchar2,
198 itemkey in varchar2,
199 actid in number,
200 funcmode in varchar2,
201 resultout out NOCOPY varchar2);
202
203 function getEmailResponderUserName(p_supp_user_name varchar2,
204 p_ntf_role_name varchar2) return varchar2;
205 -- New procedures used in RDP
206 procedure GETADDITIONALCHANGES(p_chg_req_grp_id in NUMBER, x_addl_chg OUT NOCOPY VARCHAR2, x_count OUT NOCOPY number);
207
208 procedure getReqNumber(p_po_header_id in NUMBER,p_po_release_id in NUMBER, x_req_num out nocopy varchar2, x_req_hdr_id out nocopy varchar2);
209
210 procedure getChgReqMode(p_chg_req_grp_id in number, x_req_mode out nocopy varchar2);
211
212
213 procedure getHdrCancel(p_chg_req_grp_id in NUMBER,
214 po_header_id in NUMBER,
215 po_release_id in NUMBER,
216 x_action_type out nocopy varchar2,
217 x_request_status out nocopy varchar2,
218 x_doc_type out nocopy varchar2,
219 x_doc_num out nocopy varchar2,
220 x_revision_num out nocopy varchar2);
221
222 PROCEDURE getOpenShipCount(po_line_location_id in number, x_ship_invalid_for_ctrl_actn out nocopy varchar2);
223
224 PROCEDURE SET_SUPPLIER_CONTEXT(p_supplier_user_id in NUMBER,p_resp_id in NUMBER,p_appl_resp_id in NUMBER);
225
226 procedure CHECK_POS_EXTERNAL_URL(itemtype in varchar2,
227 itemkey in varchar2,
228 actid in number,
229 funcmode in varchar2,
230 resultout out NOCOPY varchar2);
231
232 procedure post_approval_notif
233 (p_itemtype in varchar2,
234 p_itemkey in varchar2,
235 p_actid in number,
236 p_funcmode in varchar2,
237 x_resultout out NOCOPY varchar2);
238
239 PROCEDURE PO_SUPCHG_SELECTOR ( p_itemtype IN VARCHAR2,
240 p_itemkey IN VARCHAR2,
241 p_actid IN NUMBER,
242 p_funcmode IN VARCHAR2,
243 resultout IN OUT NOCOPY VARCHAR2);
244
245
246
247 END PO_ChangeOrderWF_PVT;