[Home] [Help]
PACKAGE: APPS.GMI_MOVE_ORDER_GLOBAL
Source
1 PACKAGE GMI_Move_Order_Global AS
2 /* $Header: GMIGMOVS.pls 120.0 2005/05/25 15:49:54 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIGMOVS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains All public record definitions for |
13 | Process_Move_Order_Header |
14 | |
15 | |
16 | HISTORY |
17 | 02-MAY-2000 hverddin Created |
18 | |
19 | HW 09/2002 added ship_set_id BUG#:2296620 |
20 +=========================================================================+
21 API Name : GMI_Move_Order_Global
22 Type : Global
23 -
24 Pre-reqs : N/A
25 Parameters: Per function
26
27 Current Vers : 1.0
28
29
30
31 Record types for move order header and move order lines
32
33 Trohdr record type
34 Record type to hold a move order header record
35 */
36
37 -- HW BUG#:2643440 - Removed G_MISS_XXX from MO_HDR_Rec
38 TYPE MO_HDR_Rec IS RECORD
39 ( attribute1 VARCHAR2(150)
40 , attribute10 VARCHAR2(150)
41 , attribute11 VARCHAR2(150)
42 , attribute12 VARCHAR2(150)
43 , attribute13 VARCHAR2(150)
44 , attribute14 VARCHAR2(150)
45 , attribute15 VARCHAR2(150)
46 , attribute2 VARCHAR2(150)
47 , attribute3 VARCHAR2(150)
48 , attribute4 VARCHAR2(150)
49 , attribute5 VARCHAR2(150)
50 , attribute6 VARCHAR2(150)
51 , attribute7 VARCHAR2(150)
52 , attribute8 VARCHAR2(150)
53 , attribute9 VARCHAR2(150)
54 , attribute_category VARCHAR2(30)
55 , created_by NUMBER
56 , creation_date DATE
57 , date_required DATE
58 , description VARCHAR2(240)
59 , from_subinventory_code VARCHAR2(10)
60 , header_id NUMBER
61 , header_status NUMBER
62 , last_updated_by NUMBER
63 , last_update_date DATE
64 , last_update_login NUMBER
65 , organization_id NUMBER
66 , program_application_id NUMBER
67 , program_id NUMBER
68 , program_update_date DATE
69 , request_id NUMBER
70 , request_number VARCHAR2(30)
71 , status_date DATE
72 , to_account_id NUMBER
73 , to_subinventory_code VARCHAR2(10)
74 , move_order_type NUMBER
75 , transaction_type_id NUMBER
76 , grouping_rule_id NUMBER
77 , ship_to_location_id NUMBER
78 , return_status VARCHAR2(1)
79 , db_flag VARCHAR2(1)
80 , operation VARCHAR2(30)
81 );
82
83
84 TYPE MO_HDR_TBL IS TABLE OF MO_HDR_Rec
85 INDEX BY BINARY_INTEGER;
86
87 TYPE MO_LINE_Rec IS RECORD
88 ( attribute1 VARCHAR2(150)
89 , attribute10 VARCHAR2(150)
90 , attribute11 VARCHAR2(150)
91 , attribute12 VARCHAR2(150)
92 , attribute13 VARCHAR2(150)
93 , attribute14 VARCHAR2(150)
94 , attribute15 VARCHAR2(150)
95 , attribute2 VARCHAR2(150)
96 , attribute3 VARCHAR2(150)
97 , attribute4 VARCHAR2(150)
98 , attribute5 VARCHAR2(150)
99 , attribute6 VARCHAR2(150)
100 , attribute7 VARCHAR2(150)
101 , attribute8 VARCHAR2(150)
102 , attribute9 VARCHAR2(150)
103 , attribute_category VARCHAR2(30)
104 , created_by NUMBER
105 , creation_date DATE
106 , date_required DATE
107 , from_locator_id NUMBER
108 , from_subinventory_code VARCHAR2(10)
109 , from_subinventory_id NUMBER
110 , header_id NUMBER
111 , inventory_item_id NUMBER
112 , last_updated_by NUMBER
113 , last_update_date DATE
114 , last_update_login NUMBER
115 , line_id NUMBER
116 , line_number NUMBER
117 , line_status NUMBER
118 , organization_id NUMBER
119 , program_application_id NUMBER
120 , program_id NUMBER
121 , program_update_date DATE
122 , quantity NUMBER
123 , quantity_delivered NUMBER
124 , quantity_detailed NUMBER
125 , reason_id NUMBER
126 , reference VARCHAR2(240)
127 , reference_id NUMBER
128 , reference_type_code NUMBER
129 , request_id NUMBER
130 , status_date DATE
131 , to_account_id NUMBER
132 , to_locator_id NUMBER
133 , to_subinventory_code VARCHAR2(10)
134 , to_subinventory_id NUMBER
135 , transaction_header_id NUMBER
136 , transaction_type_id NUMBER
137 , txn_source_id NUMBER
138 , txn_source_line_id NUMBER
139 , txn_source_line_detail_id NUMBER
140 , transaction_source_type_id NUMBER
141 , primary_quantity NUMBER
142 , to_organization_id NUMBER
143 , pick_strategy_id NUMBER
144 , put_away_strategy_id NUMBER
145 , uom_code VARCHAR2(3)
146 , return_status VARCHAR2(1)
147 , db_flag VARCHAR2(1)
148 , operation VARCHAR2(30)
149 , secondary_quantity NUMBER
150 , secondary_quantity_delivered NUMBER
151 , secondary_quantity_detailed NUMBER
152 , lot_no VARCHAR2(32)
153 , sublot_no VARCHAR2(32)
154 , qc_grade VARCHAR2(4)
155 , secondary_uom_code VARCHAR2(4)
156 , unit_number VARCHAR2(30)
157 , grouping_rule_id NUMBER
158 , request_number VARCHAR2(30)
159 , move_order_type NUMBER
160 -- HW added ship_set_id BUG#:2296620
161 , ship_set_id NUMBER :=NULL
162 );
163
164 TYPE MO_LINE_Tbl IS TABLE OF MO_LINE_Rec
165 INDEX BY BINARY_INTEGER;
166
167
168 TYPE MO_LINE_TXN_REC is RECORD
169 ( trans_id IC_TRAN_PND.TRANS_ID%TYPE
170 ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
171 ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
172 ,qc_grade IC_TRAN_PND.QC_GRADE%TYPE
173 ,lot_no IC_LOTS_MST.LOT_NO%TYPE
174 ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
175 ,locator_id IC_LOCT_MST.INVENTORY_LOCATION_ID%TYPE
176 );
177
178 END GMI_Move_Order_Global;