[Home] [Help]
PACKAGE: APPS.PO_SHIPMENTS_SV4
Source
1 PACKAGE PO_SHIPMENTS_SV4 AUTHID CURRENT_USER AS
2 /* $Header: POXPOS4S.pls 120.1 2005/08/17 02:04:09 arudas noship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: delete_all_shipments
6
7 DESCRIPTION: Deletes all the shipments associated with
8 a particular entity level.
9
10 PARAMETERS: X_delete_id IN NUMBER,
11 X_entity_level IN VARCHAR2
12
13 DESIGN REFERENCES:
14
15
16 ALGORITHM: If this is a line, delete all shipments that
17 are associated with the Line and
18 are of type PLANNED, STANDARD, PRICE BREAK
19 If this is a header, delete all shipments
20 that are associated with the Header and
21 are of type PLANNED, STANDARD, PRICE BREAK
22 If this is a release, delete all shipments
23 that are associated with the release header
24 and are of type SCHEDULED, BLANKET.
25
26 For Lines you should pass:
27 entity_level = LINE
28 For Headers you should pass:
29 entity_level = HEADER
30 For Releases you should pass:
31 entity_level = RELEASE
32 NOTES:
33
34 OPEN ISSUES:
35
36 CLOSED ISSUES:
37
38 CHANGE HISTORY: KPOWELL 5/2 Created
39
40 ===========================================================================*/
41 PROCEDURE delete_all_shipments
42 (X_delete_id IN NUMBER,
43 X_entity_level IN VARCHAR2,
44 X_type_lookup_code IN VARCHAR2);
45
46
47 /*===========================================================================
48 PROCEDURE NAME: delete_shipments
49
50 DESCRIPTION: Deletes the current shipment and calls the
51 routine to delete all of it's children.
52
53 PARAMETERS: X_line_location_id IN NUMBER,
54 X_row_id IN VARCHAR2,
55 X_doc_header_id IN NUMBER
56
57 DESIGN REFERENCES:
58
59 ALGORITHM:
60
61 NOTES:
62
63 OPEN ISSUES:
64
65 CLOSED ISSUES:
66
67 CHANGE HISTORY: KPOWELL 5/3 Created
68 SIYER 6/6 Added parameter X_doc_header_id
69
70 ===========================================================================*/
71 PROCEDURE delete_shipment
72 (X_line_location_id IN NUMBER,
73 X_row_id IN VARCHAR2,
74 X_doc_header_id IN NUMBER,
75 X_shipment_type IN VARCHAR2);
76
77
78 /*===========================================================================
79 PROCEDURE NAME: delete_children
80
81 DESCRIPTION: Deletes all of the children associated with
82 a purchase order shipment including:
83 Requisition Line Link
84 Purchase Order Distributions.
85
86 PARAMETERS: X_line_location_id IN NUMBER
87 X_doc_header_id IN NUMBER
88 X_shipment_type IN VARCHAR2
89
90 DESIGN REFERENCES:
91
92 ALGORITHM:
93
94 NOTES:
95
96 OPEN ISSUES: Need to fill in the calls to the routines
97 in the other packages. DEBUG.
98 (5/3 - KP)
99
100 CLOSED ISSUES:
101
102 CHANGE HISTORY: KPOWELL 5/3 Created
103 SIYER 6/6 Added parameter X_doc_header_id
104
105 ===========================================================================*/
106 PROCEDURE delete_children
107 (X_line_location_id IN NUMBER,
108 X_doc_header_id IN NUMBER,
109 X_shipment_type IN VARCHAR2);
110
111 /*===========================================================================
112 PROCEDURE NAME: update_shipment
113
114 DESCRIPTION: Cover routine to update the shipment and
115 to update all of the distributions.
116
117
118 PARAMETERS: See Below
119
120 DESIGN REFERENCES:
121
122 ALGORITHM:
123
124 NOTES:
125
126 OPEN ISSUES: Need to fill in the calls to the routines
127 in the other packages. DEBUG.
128 (5/3 - KP)
129
130 CLOSED ISSUES:
131
132 CHANGE HISTORY: KPOWELL 5/3 Created
133 SIYER Changed
134 ECSO 2/27/97 Add Global Flex
135
136 ===========================================================================*/
137 PROCEDURE update_shipment
138 (X_Rowid VARCHAR2,
139 X_Line_Location_Id NUMBER,
140 X_Last_Update_Date DATE,
141 X_Last_Updated_By NUMBER,
142 X_Po_Header_Id NUMBER,
143 X_Po_Line_Id NUMBER,
144 X_Last_Update_Login NUMBER,
145 X_Quantity NUMBER,
146 X_Quantity_Received NUMBER,
147 X_Quantity_Accepted NUMBER,
148 X_Quantity_Rejected NUMBER,
149 X_Quantity_Billed NUMBER,
150 X_Quantity_Cancelled NUMBER,
151 X_Unit_Meas_Lookup_Code VARCHAR2,
152 X_Po_Release_Id NUMBER,
153 X_Ship_To_Location_Id NUMBER,
154 X_Ship_Via_Lookup_Code VARCHAR2,
155 X_Need_By_Date DATE,
156 X_Promised_Date DATE,
157 X_Last_Accept_Date DATE,
158 X_Price_Override NUMBER,
159 X_Encumbered_Flag VARCHAR2,
160 X_Encumbered_Date DATE,
161 X_Fob_Lookup_Code VARCHAR2,
162 X_Freight_Terms_Lookup_Code VARCHAR2,
163 X_Taxable_Flag VARCHAR2,
164 X_Tax_Code_Id NUMBER,
165 X_Tax_User_Override_Flag VARCHAR2,
166 X_Calculate_Tax_Flag VARCHAR2,
167 X_From_Header_Id NUMBER,
168 X_From_Line_Id NUMBER,
169 X_From_Line_Location_Id NUMBER,
170 X_Start_Date DATE,
171 X_End_Date DATE,
172 X_Lead_Time NUMBER,
173 X_Lead_Time_Unit VARCHAR2,
174 X_Price_Discount NUMBER,
175 X_Terms_Id NUMBER,
176 X_Approved_Flag IN OUT NOCOPY VARCHAR2,
177 X_Approved_Date DATE,
178 X_Closed_Flag VARCHAR2,
179 X_Cancel_Flag VARCHAR2,
180 X_Cancelled_By NUMBER,
181 X_Cancel_Date DATE,
182 X_Cancel_Reason VARCHAR2,
183 X_Firm_Status_Lookup_Code VARCHAR2,
184 X_Attribute_Category VARCHAR2,
185 X_Attribute1 VARCHAR2,
186 X_Attribute2 VARCHAR2,
187 X_Attribute3 VARCHAR2,
188 X_Attribute4 VARCHAR2,
189 X_Attribute5 VARCHAR2,
190 X_Attribute6 VARCHAR2,
191 X_Attribute7 VARCHAR2,
192 X_Attribute8 VARCHAR2,
193 X_Attribute9 VARCHAR2,
194 X_Attribute10 VARCHAR2,
195 X_Attribute11 VARCHAR2,
196 X_Attribute12 VARCHAR2,
197 X_Attribute13 VARCHAR2,
198 X_Attribute14 VARCHAR2,
199 X_Attribute15 VARCHAR2,
200 X_Inspection_Required_Flag VARCHAR2,
201 X_Receipt_Required_Flag VARCHAR2,
202 X_Qty_Rcv_Tolerance NUMBER,
203 X_Qty_Rcv_Exception_Code VARCHAR2,
204 X_Enforce_Ship_To_Location VARCHAR2,
205 X_Allow_Substitute_Receipts VARCHAR2,
206 X_Days_Early_Receipt_Allowed NUMBER,
207 X_Days_Late_Receipt_Allowed NUMBER,
208 X_Receipt_Days_Exception_Code VARCHAR2,
209 X_Invoice_Close_Tolerance NUMBER,
210 X_Receive_Close_Tolerance NUMBER,
211 X_Ship_To_Organization_Id NUMBER,
212 X_Shipment_Num NUMBER,
213 X_Source_Shipment_Id NUMBER,
214 X_Shipment_Type VARCHAR2,
215 X_Closed_Code VARCHAR2,
216 X_Ussgl_Transaction_Code VARCHAR2,
217 X_Government_Context VARCHAR2,
218 X_Receiving_Routing_Id NUMBER,
219 X_Accrue_On_Receipt_Flag VARCHAR2,
220 X_Closed_Reason VARCHAR2,
221 X_Closed_Date DATE,
222 X_Closed_By NUMBER,
223 X_need_to_approve IN OUT NOCOPY NUMBER,
224 X_increment_revision BOOLEAN,
225 X_new_rev_num NUMBER,
226 X_po_rel_Rowid VARCHAR2,
227 X_dist_window_open VARCHAR2,
228 X_Global_Attribute_Category VARCHAR2,
229 X_Global_Attribute1 VARCHAR2,
230 X_Global_Attribute2 VARCHAR2,
231 X_Global_Attribute3 VARCHAR2,
232 X_Global_Attribute4 VARCHAR2,
233 X_Global_Attribute5 VARCHAR2,
234 X_Global_Attribute6 VARCHAR2,
235 X_Global_Attribute7 VARCHAR2,
236 X_Global_Attribute8 VARCHAR2,
237 X_Global_Attribute9 VARCHAR2,
238 X_Global_Attribute10 VARCHAR2,
239 X_Global_Attribute11 VARCHAR2,
240 X_Global_Attribute12 VARCHAR2,
241 X_Global_Attribute13 VARCHAR2,
242 X_Global_Attribute14 VARCHAR2,
243 X_Global_Attribute15 VARCHAR2,
244 X_Global_Attribute16 VARCHAR2,
245 X_Global_Attribute17 VARCHAR2,
246 X_Global_Attribute18 VARCHAR2,
247 X_Global_Attribute19 VARCHAR2,
248 X_Global_Attribute20 VARCHAR2,
249 X_Country_of_Origin_Code VARCHAR2,
250 X_Invoice_Match_Option VARCHAR2, --bgu, Dec. 7, 98
251 --togeorge 10/03/2000
252 --added note to receiver
253 X_note_to_receiver VARCHAR2 default null,
254 -- Mahesh Chandak(GML) Add 7 process related fields.
255 -- start of Bug# 1548597
256 X_Secondary_Unit_Of_Measure VARCHAR2 default null,
257 X_Secondary_Quantity NUMBER default null ,
258 X_Preferred_Grade VARCHAR2 default null,
259 X_Secondary_Quantity_Received NUMBER default null,
260 X_Secondary_Quantity_Accepted NUMBER default null,
261 X_Secondary_Quantity_Rejected NUMBER default null,
262 X_Secondary_Quantity_Cancelled NUMBER default null,
263 -- end of Bug# 1548597
264 X_Consigned_Flag VARCHAR2 default null, /* CONSIGNED FPI */
265 X_amount NUMBER default null, -- <SERVICES FPJ>
266 p_transaction_flow_header_id NUMBER default null, --< Shared Proc FPJ >
267 p_manual_price_change_flag VARCHAR2 default null --< Manual Price Override FPJ >
268 );
269 --<HTML Agreements R12 Start>
270 PROCEDURE validate_delete_line_loc( p_line_loc_id IN NUMBER
271 ,p_po_line_id IN NUMBER
272 ,p_doc_type IN VARCHAR2
273 ,p_style_disp_name IN VARCHAR2
274 ,x_message_text OUT NOCOPY VARCHAR2);
275
276 PROCEDURE process_delete_line_loc(p_line_loc_id IN NUMBER
277 ,p_line_loc_row_id IN ROWID
278 ,p_po_header_id IN NUMBER
279 ,p_po_line_id IN NUMBER
280 ,p_doc_subtype IN VARCHAR2);
281 --<HTML Agreements R12 End>
282 END PO_SHIPMENTS_SV4;