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