DBA Data[Home] [Help]

PACKAGE: APPS.PO_CHG_REQUEST_PVT

Source


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;