1 PACKAGE PO_CHG_REQUEST_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXPCHGS.pls 120.5.12020000.2 2013/02/11 01:31:09 vegajula ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_CHG_REQUEST_PVT';
5 G_FILE_NAME CONSTANT VARCHAR2(30) := 'POSCHORB.pls';
6
7 procedure process_supplier_signature (
8 p_api_version IN NUMBER,
9 p_Init_Msg_List IN VARCHAR2,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_notification_id OUT NOCOPY NUMBER,
12 p_po_header_id IN number,
13 p_revision_num IN number,
14 p_document_subtype IN VARCHAR2,
15 p_document_number IN VARCHAR2,
16 p_org_id IN NUMBER,
17 p_Agent_Id IN NUMBER,
18 p_supplier_user_id IN number) ;
19
20 procedure process_supplier_signature (
21 p_api_version IN NUMBER,
22 p_Init_Msg_List IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_notification_id OUT NOCOPY NUMBER,
25 p_po_header_id IN number,
26 p_revision_num IN number,
27 p_document_subtype IN VARCHAR2,
28 p_document_number IN VARCHAR2,
29 p_org_id IN NUMBER,
30 p_Agent_Id IN NUMBER,
31 p_supplier_user_id IN NUMBER,
32 p_draft_id IN NUMBER) ;
33
34 procedure save_request(
35 p_api_version IN NUMBER ,
36 p_Init_Msg_List IN VARCHAR2 ,
37 x_return_status OUT NOCOPY VARCHAR2,
38 p_po_header_id IN number,
39 p_po_release_id IN number,
40 p_revision_num IN number,
41 p_po_change_requests IN pos_chg_rec_tbl,
42 x_request_group_id OUT NOCOPY NUMBER,
43 p_chn_int_cont_num IN varchar2 default null,
44 p_chn_source IN varchar2 default null,
45 p_chn_requestor_username in varchar2 default null,
46 p_user_id IN number default null,
47 p_login_id IN number default null);
48
49
50 /* This procedure will post acceptance request record cancellation
51 request at shipments level
52 also process change requests at line and shipments level
53 Call time phase pricing api for new price
54 The record will be split to Lines Shipments Distributions
55 and will call document submission check for core PO
56
57 */
58 /*
59 procedure process_supplier_request (
60 p_po_header_id IN number,
61 p_po_release_id IN number,
62 p_revision_num IN number,
63 p_po_change_requests IN pos_chg_rec_tbl,
64 x_online_report_id OUT NOCOPY number,
65 x_pos_errors out NOCOPY POS_ERR_TYPE,
66 p_chn_int_cont_num IN varchar2 default null,
67 p_chn_source IN varchar2 default null,
68 p_chn_requestor_username in varchar2 default null,
69 p_user_id IN number default null,
70 p_login_id IN number default null,
71 p_last_upd_date IN date default null) ;
72 */
73 -- This procedure will update the po attributes in core po tables
74 -- set the po to IN PROCESS and set the new flag on po_headers_all
75
76 procedure process_supplier_request (
77 p_po_header_id IN number,
78 p_po_release_id IN number,
79 p_revision_num IN number,
80 p_po_change_requests IN pos_chg_rec_tbl,
81 x_online_report_id OUT NOCOPY number,
82 x_pos_errors out NOCOPY POS_ERR_TYPE,
83 p_chn_int_cont_num IN varchar2 default null,
84 p_chn_source IN varchar2 default null,
85 p_chn_requestor_username in varchar2 default null,
86 p_user_id IN number default null,
87 p_login_id IN number default null,
88 p_last_upd_date IN date default null,
89 p_mpoc IN varchar2 default FND_API.G_FALSE) ;
90
91
92
93 procedure update_po_attributes(
94 p_po_header_id IN number,
95 p_po_release_id IN number,
96 p_revision_num IN number,
97 p_chg_request_grp_id IN number,
98 x_return_status OUT NOCOPY varchar2,
99 p_chn_requestor_username IN varchar2 default null,
100 p_user_id IN number default null,
101 p_login_id IN number default null);
102
103 procedure validate_change_request (
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_po_header_id IN number,
109 p_po_release_id IN number,
110 p_revision_num IN number,
111 p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
112 x_online_report_id OUT NOCOPY number,
113 x_pos_errors OUT NOCOPY POS_ERR_TYPE,
114 x_doc_check_error_msg OUT NOCOPY Doc_Check_Return_Type);
115
116
117 function ifLineChangable(
118 p_po_line_id IN number)
119 return varchar2;
120
121 procedure validateCancelRequest(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 p_po_header_id IN NUMBER,
126 p_po_release_id IN NUMBER);
127
128
129
130
131 procedure getShipmentStatus(
132 p_line_location_id IN NUMBER,
133 p_po_header_id IN NUMBER,
134 p_po_release_id IN NUMBER,
135 p_revision_num IN NUMBER,
136 x_msg_code OUT NOCOPY VARCHAR2,
137 x_msg_display OUT NOCOPY VARCHAR2,
138 x_note OUT NOCOPY CLOB);
139
140 procedure save_cancel_request(
141 p_api_version IN NUMBER ,
142 p_Init_Msg_List IN VARCHAR2 ,
143 x_return_status OUT NOCOPY VARCHAR2,
144 p_po_header_id IN number,
145 p_po_release_id IN number,
146 p_revision_num IN number,
147 p_po_change_requests IN pos_chg_rec_tbl,
148 x_request_group_id OUT NOCOPY NUMBER);
149
150 procedure validate_change_request (
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_po_header_id IN NUMBER,
156 p_po_release_id IN NUMBER,
157 p_revision_num IN NUMBER,
158 p_po_change_requests IN OUT NOCOPY pos_chg_rec_tbl,
159 x_online_report_id OUT NOCOPY number,
160 x_pos_errors OUT NOCOPY POS_ERR_TYPE);
161
162 procedure getLineAttrs(
163 p_from_header_id IN NUMBER,
164 p_un_number_id IN NUMBER,
165 p_haz_class_id IN NUMBER,
166 x_ga_number OUT NOCOPY VARCHAR2,
167 x_un_number OUT NOCOPY VARCHAR2,
168 x_haz_class_desc OUT NOCOPY VARCHAR2);
169
170 procedure cancel_change_request (
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 p_po_header_id IN NUMBER,
175 p_po_release_id IN NUMBER,
176 p_po_line_id IN NUMBER,
177 p_po_line_location_id IN NUMBER);
178
179
180 /****************************************************************
181 ** This function will create a pos_change_rec type object.
182 ** Each field corresponds to a column in the POS_CHANGE_REQUESTS table.
183 ** Note that the not null columns are required parameters and
184 ** nullable columns are defined with default null.
185 ** Recommondation : Use named parameter invocation to send in
186 ** only the fields that matter.
187 **
188 ** NOTE: If the pos_change_rec object has changed,
189 ** a new parameter has to be added.
190 **/
191
192
193 function create_pos_change_rec (
194 p_Action_Type IN VARCHAR2, --(30),
195 p_Initiator IN VARCHAR2, --(30),
196 p_Document_Type IN VARCHAR2, --(30),
197 p_Request_Level IN VARCHAR2, --(30),
198 p_Request_Status IN VARCHAR2, --(30),
199 p_Document_Header_Id IN NUMBER,
200 p_Request_Reason IN VARCHAR2 default null, --(2000),
201 p_PO_Release_Id IN NUMBER default null,
202 p_Document_Num IN VARCHAR2 default null, --(20),
203 p_Document_Revision_Num IN NUMBER default null,
204 p_Document_Line_Id IN NUMBER default null,
205 p_Document_Line_Number IN NUMBER default null,
206 p_Document_Line_Location_Id IN NUMBER default null,
207 p_Document_Shipment_Number IN NUMBER default null,
208 p_Document_Distribution_id IN NUMBER default null,
209 p_Document_Distribution_Number IN NUMBER default null,
210 p_Parent_Line_Location_Id IN NUMBER default null,
211 p_Old_Quantity IN NUMBER default null,
212 p_New_Quantity IN NUMBER default null,
213 p_Old_Promised_Date IN DATE default null,
214 p_New_Promised_Date IN DATE default null,
215 p_Old_Supplier_Part_Number IN VARCHAR2 default null, --(25),
216 p_New_Supplier_Part_Number IN VARCHAR2 default null, --(25),
217 p_Old_Price IN NUMBER default null,
218 p_New_Price IN NUMBER default null,
219 p_Old_Supplier_Reference_Num IN VARCHAR2 default null, --(30),
220 p_New_Supplier_Reference_Num IN VARCHAR2 default null, --(30),
221 p_From_Header_id IN NUMBER default null,
222 p_Recoverable_Tax IN NUMBER default null,
223 p_Non_recoverable_tax IN NUMBER default null,
224 p_Ship_To_Location_id IN NUMBER default null,
225 p_Ship_To_Organization_Id IN NUMBER default null,
226 p_Old_Need_By_Date IN DATE default null,
227 p_New_Need_By_Date IN DATE default null,
228 p_Approval_Required_Flag IN VARCHAR2 default null, --(1),
229 p_Parent_Change_request_Id IN NUMBER default null,
230 p_Requester_id IN NUMBER default null,
231 p_Old_Supplier_Order_Number IN VARCHAR2 default null, --(25),
232 p_New_Supplier_Order_Number IN VARCHAR2 default null, --(25),
233 p_Old_Supplier_Order_Line_Num IN VARCHAR2 default null, --(25),
234 p_New_Supplier_Order_Line_Num IN VARCHAR2 default null , --(25),
235 p_Additional_changes IN VARCHAR2 default null, --(2000),
236 p_old_Start_date IN DATE default null,
237 p_new_Start_date IN DATE default null,
238 p_old_Expiration_date IN DATE default null,
239 p_new_Expiration_date IN DATE default null,
240 p_old_Amount IN NUMBER default null,
241 p_new_Amount IN NUMBER default null,
242 p_SUPPLIER_DOC_REF IN varchar2 default null, --(256),
243 p_SUPPLIER_LINE_REF IN varchar2 default null, --(256),
244 p_SUPPLIER_SHIPMENT_REF IN varchar2 default null, --(256)
245 /* << Complex work changes for R12 >>*/
246 p_NEW_PROGRESS_TYPE IN varchar2 default null,
247 p_NEW_PAY_DESCRIPTION IN varchar2 default null
248
249 ) return pos_chg_rec;
250
251 function getMaxShipmentNum (
252 p_po_line_id IN NUMBER)
253 return NUMBER;
254
255 function getLastUpdateDate (
256 p_header_id IN NUMBER,
257 p_release_id IN NUMBER)
258 return DATE;
259 procedure validate_shipment_cancel (
260 p_po_header_id IN number,
261 p_po_release_id IN number,
262 p_po_change_requests IN pos_chg_rec_tbl,
263 x_pos_errors OUT NOCOPY POS_ERR_TYPE,
264 x_ret_sts OUT NOCOPY VARCHAR2
265 );
266
267 procedure validate_ship_inv_cancel (
268 p_po_header_id IN number,
269 p_po_change_requests IN pos_chg_rec_tbl,
270 x_pos_errors OUT NOCOPY POS_ERR_TYPE,
271 x_ret_sts OUT NOCOPY VARCHAR2
272 );
273 /*Added for bug#14155598*/
274 procedure IS_ASN_EXIST(
275 p_po_header_id IN number,
276 p_po_release_id IN number,
277 p_po_change_requests IN pos_chg_rec_tbl,
278 x_pos_errors OUT NOCOPY POS_ERR_TYPE,
279 x_ret_sts OUT NOCOPY VARCHAR2
280 );
281
282 END PO_CHG_REQUEST_PVT;