[Home] [Help]
PACKAGE: APPS.GMI_MOVE_ORDER_LINE_UTIL
Source
1 PACKAGE GMI_MOVE_ORDER_LINE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: GMIUMOLS.pls 120.0 2005/05/25 16:17:20 appldev noship $
3 ===========================================================================
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 ===========================================================================
8 | FILENAME |
9 | GMIUMOLS.pls |
10 | |
11 | DESCRIPTION |
12 | |
13 | Spec of package GMI_Move_order_line_Util |
14 | |
15 | NOTES |
16 | |
17 | HISTORY |
18 | |
19 | 21-Apr-00 Created |
20 | May-2000 odab added : |
21 | - Line_Auto_Detail |
22 | - Line_Pick_Confirm |
23 | |
24 | 26-SEP-01 Hverddin Added Concurrent Request API |
25 | - AUTO_ALLOC_CONFIRM_SRS |
26 ===========================================================================
27
28
29 Attributes global constants
30 */
31
32 G_ATTRIBUTE1 CONSTANT NUMBER := 2;
33 G_ATTRIBUTE10 CONSTANT NUMBER := 3;
34 G_ATTRIBUTE11 CONSTANT NUMBER := 4;
35 G_ATTRIBUTE12 CONSTANT NUMBER := 5;
36 G_ATTRIBUTE13 CONSTANT NUMBER := 6;
37 G_ATTRIBUTE14 CONSTANT NUMBER := 7;
38 G_ATTRIBUTE15 CONSTANT NUMBER := 8;
39 G_ATTRIBUTE2 CONSTANT NUMBER := 9;
40 G_ATTRIBUTE3 CONSTANT NUMBER := 10;
41 G_ATTRIBUTE4 CONSTANT NUMBER := 11;
42 G_ATTRIBUTE5 CONSTANT NUMBER := 12;
43 G_ATTRIBUTE6 CONSTANT NUMBER := 13;
44 G_ATTRIBUTE7 CONSTANT NUMBER := 14;
45 G_ATTRIBUTE8 CONSTANT NUMBER := 15;
46 G_ATTRIBUTE9 CONSTANT NUMBER := 16;
47 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 17;
48 G_CREATED_BY CONSTANT NUMBER := 18;
49 G_CREATION_DATE CONSTANT NUMBER := 19;
50 G_DATE_REQUIRED CONSTANT NUMBER := 20;
51 G_FROM_LOCATOR CONSTANT NUMBER := 21;
52 G_FROM_SUBINVENTORY CONSTANT NUMBER := 22;
53 /* G_FROM_SUBINVENTORY CONSTANT NUMBER := 23; */
54 G_HEADER CONSTANT NUMBER := 24;
55 G_INVENTORY_ITEM CONSTANT NUMBER := 25;
56 G_LAST_UPDATED_BY CONSTANT NUMBER := 26;
57 G_LAST_UPDATE_DATE CONSTANT NUMBER := 27;
58 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 28;
59 G_LINE CONSTANT NUMBER := 29;
60 G_LINE_NUMBER CONSTANT NUMBER := 30;
61 G_LINE_STATUS CONSTANT NUMBER := 31;
62 G_LOT_NUMBER CONSTANT NUMBER := 32;
63 G_ORGANIZATION CONSTANT NUMBER := 33;
64 G_PROGRAM_APPLICATION CONSTANT NUMBER := 34;
65 G_PROGRAM CONSTANT NUMBER := 35;
66 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 36;
67 G_PROJECT CONSTANT NUMBER := 37;
68 G_QUANTITY CONSTANT NUMBER := 38;
69 G_QUANTITY_DELIVERED CONSTANT NUMBER := 39;
70 G_QUANTITY_DETAILED CONSTANT NUMBER := 40;
71 G_REASON CONSTANT NUMBER := 41;
72 G_REFERENCE CONSTANT NUMBER := 42;
73 /* G_REFERENCE CONSTANT NUMBER := 43; */
74 G_REFERENCE CONSTANT NUMBER := 44;
75 G_REQUEST CONSTANT NUMBER := 45;
76 G_REVISION CONSTANT NUMBER := 46;
77 G_SERIAL_NUMBER_END CONSTANT NUMBER := 47;
78 G_SERIAL_NUMBER_START CONSTANT NUMBER := 48;
79 G_STATUS_DATE CONSTANT NUMBER := 49;
80 G_TASK CONSTANT NUMBER := 50;
81 G_TO_ACCOUNT CONSTANT NUMBER := 51;
82 G_TO_LOCATOR CONSTANT NUMBER := 52;
83 G_TO_SUBINVENTORY CONSTANT NUMBER := 53;
84 /* G_TO_SUBINVENTORY CONSTANT NUMBER := 54; */
85 G_TRANSACTION_HEADER CONSTANT NUMBER := 55;
86 G_UOM CONSTANT NUMBER := 56;
87 /* G_UOM CONSTANT NUMBER := 57; */
88 G_MAX_ATTR_ID CONSTANT NUMBER := 58;
89 G_TRANSACTION_ID CONSTANT NUMBER := 59;
90 G_TRANSACTION_SOURCE_ID CONSTANT NUMBER := 60;
91 G_TXN_SOURCE_ID CONSTANT NUMBER := 61;
92 G_TXN_SOURCE_LINE_ID CONSTANT NUMBER := 62;
93 G_TXN_SOURCE_LINE_DETAIL_ID CONSTANT NUMBER := 63;
94 G_PRIMARY_QUANTITY CONSTANT NUMBER := 64;
95 G_TO_ORGANIZATION_ID CONSTANT NUMBER := 65;
96 G_PICK_STRATEGY_ID CONSTANT NUMBER := 66;
97 G_PUT_AWAY_STRATEGY_ID CONSTANT NUMBER := 67;
98
99 /* Procedure Clear_Dependent_Attr */
100 /*
101 PROCEDURE Clear_Dependent_Attr
102 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
103 , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
104 , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
105 , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
106 );
107 */
108 /* Procedure Apply_Attribute_Changes */
109 /*
110 PROCEDURE Apply_Attribute_Changes
111 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
112 , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
113 , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
114 );
115 */
116 /* Function Complete_Record */
117 /*
118 FUNCTION Complete_Record
119 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
120 , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
121 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
122 */
123
124 /* Function Convert_Miss_To_Null */
125
126 FUNCTION Convert_Miss_To_Null
127 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
128 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
129 /* Procedure Update_Row */
130
131 PROCEDURE Update_Row
132 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
133 );
134
135 /* Procedure Update_Row_Status */
136
137 PROCEDURE Update_Row_Status
138 ( p_line_id IN Number,
139 p_status IN Number
140 );
141
142 /* Procedure Insert_Row */
143
144 PROCEDURE Insert_Row
145 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
146 );
147
148 /* Procedure Delete_Row */
149
150 PROCEDURE Delete_Row
151 ( p_line_id IN NUMBER
152 );
153
154 /* Function Query_Row */
155
156 FUNCTION Query_Row
157 ( p_line_id IN NUMBER
158 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
159
160 /* Function Query_Rows */
161
162 -- HW BUG#:2643440, removed intitalization of G_MISS_XXX
163 -- to p_line_id and p_header_id
164 FUNCTION Query_Rows
165 ( p_line_id IN NUMBER default NULL
166 , p_header_id IN NUMBER default NULL
167 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Tbl ;
168
169
170 /* Function Get_Lines */
171
172 FUNCTION Get_Lines
173 (
174 p_header_id IN NUMBER
175
176 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Tbl ;
177
178 /* Procedure lock_Row */
179
180 PROCEDURE Lock_Row
181 ( x_return_status OUT NOCOPY VARCHAR2
182 , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
183 , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
184 );
185
186 /* Function Get_Values */
187 /*
188
189 FUNCTION Get_Values
190 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
191 , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec :=
192 GMI_MOVE_ORDER_GLOBAL.G_MISS_mo_line_REC
193 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec ;
194
195 Function Get_Ids
196
197 FUNCTION Get_Ids
198 ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
199 , p_mo_line_val_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec
200 ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
201 */
202
203 PROCEDURE Line_Auto_Detail
204 ( p_mo_line_id IN NUMBER
205 , p_init_msg_list IN NUMBER
206 , p_transaction_header_id IN NUMBER
207 , p_transaction_mode IN NUMBER
208 , p_move_order_type IN NUMBER
209 , p_allow_delete IN VARCHAR2 DEFAULT NULL
210 , x_number_of_rows OUT NOCOPY NUMBER
211 , x_qc_grade OUT NOCOPY VARCHAR2
212 , x_detailed_qty OUT NOCOPY NUMBER
213 , x_qty_UM OUT NOCOPY VARCHAR2
214 , x_detailed_qty2 OUT NOCOPY NUMBER
215 , x_qty_UM2 OUT NOCOPY VARCHAR2
216 , x_return_status OUT NOCOPY VARCHAR2
217 , x_msg_count OUT NOCOPY NUMBER
218 , x_msg_data OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE Line_Pick_Confirm
222 ( p_mo_line_id IN NUMBER
223 , p_init_msg_list IN NUMBER
224 , p_move_order_type IN NUMBER
225 , x_delivered_qty OUT NOCOPY NUMBER
226 , x_qty_UM OUT NOCOPY VARCHAR2
227 , x_delivered_qty2 OUT NOCOPY NUMBER
228 , x_qty_UM2 OUT NOCOPY VARCHAR2
229 , x_return_status OUT NOCOPY VARCHAR2
230 , x_msg_count OUT NOCOPY NUMBER
231 , x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE AUTO_ALLOC_CONFIRM_SRS
235 ( errbuf OUT NOCOPY VARCHAR2
236 , retcode OUT NOCOPY VARCHAR2
237 , p_pick_confirm IN VARCHAR2
238 , p_whse_code IN VARCHAR2
239 , p_from_order_num IN NUMBER
240 , p_to_order_num IN NUMBER
241 , p_item_num IN VARCHAR2
242 , p_cust_num IN VARCHAR2
243 , p_from_ship_date IN VARCHAR2
244 , p_to_ship_date IN VARCHAR2
245 , p_log_level IN NUMBER
246 );
247
248 PROCEDURE Cancel_Move_Order_Line(
249 x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,p_line_id IN NUMBER
253 ,p_delivery_detail_id IN NUMBER
254 ,p_delete_reservations IN VARCHAR2
255 ,p_txn_source_line_id IN NUMBER DEFAULT NULL
256 );
257
258 PROCEDURE Reduce_Move_Order_Quantity(
259 x_return_status OUT NOCOPY VARCHAR2
260 ,x_msg_count OUT NOCOPY NUMBER
261 ,x_msg_data OUT NOCOPY VARCHAR2
262 ,p_line_id IN NUMBER
263 ,p_delivery_detail_id IN NUMBER
264 ,p_reduction_quantity IN NUMBER
265 ,p_reduction_quantity2 IN NUMBER
266 ,p_txn_source_line_id IN NUMBER DEFAULT NULL
267 );
268
269 PROCEDURE update_txn_source_line
270 ( p_line_id IN NUMBER
271 , p_new_source_line_id IN NUMBER
272 ) ;
273
274 END GMI_MOVE_ORDER_LINE_UTIL;