1 PACKAGE GMI_TO_Form_Trolin AUTHID CURRENT_USER AS
2 /* $Header: GMIFTRLS.pls 115.5 2002/10/29 15:19:09 jdiiorio ship $ */
3 /*
4 +=========================================================================+
5 | Copyright (c) 2000 Oracle Corporation |
6 | TVP, Reading, England |
7 | All rights reserved |
8 +=========================================================================+
9 | FILENAME |
10 | GMIFTRLS.pls |
11 | |
12 | DESCRIPTION |
13 | This package contains private utilities interface procedures |
14 | to forms ICTOTRX.fmb |
15 | |
16 | - Need to be cleaned |
17 | |
18 | HISTORY |
19 | 07-MAR-2000 odaboval Created |
20 | 29-OCT-2002 jdiiorio Update - Bug#2643440 11.5.1J |
21 | Added nocopy. |
22 +=========================================================================+
23 */
24
25
26 /* Procedure : Default_Attributes
27 */
28 /* odab
29 PROCEDURE Default_Attributes
30 ( x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , p_header_id IN NUMBER
34 , x_attribute1 OUT NOCOPY VARCHAR2
35 , x_attribute10 OUT NOCOPY VARCHAR2
36 , x_attribute11 OUT NOCOPY VARCHAR2
37 , x_attribute12 OUT NOCOPY VARCHAR2
38 , x_attribute13 OUT NOCOPY VARCHAR2
39 , x_attribute14 OUT NOCOPY VARCHAR2
40 , x_attribute15 OUT NOCOPY VARCHAR2
41 , x_attribute2 OUT NOCOPY VARCHAR2
42 , x_attribute3 OUT NOCOPY VARCHAR2
43 , x_attribute4 OUT NOCOPY VARCHAR2
44 , x_attribute5 OUT NOCOPY VARCHAR2
45 , x_attribute6 OUT NOCOPY VARCHAR2
46 , x_attribute7 OUT NOCOPY VARCHAR2
47 , x_attribute8 OUT NOCOPY VARCHAR2
48 , x_attribute9 OUT NOCOPY VARCHAR2
49 , x_attribute_category OUT NOCOPY VARCHAR2
50 , x_date_required OUT NOCOPY DATE
51 , x_from_locator_id OUT NOCOPY NUMBER
52 , x_from_subinventory_code OUT NOCOPY VARCHAR2
53 , x_from_subinventory_id OUT NOCOPY NUMBER
54 , x_header_id OUT NOCOPY NUMBER
55 , x_inventory_item_id OUT NOCOPY NUMBER
56 , x_line_id OUT NOCOPY NUMBER
57 , x_line_number OUT NOCOPY NUMBER
58 , x_line_status OUT NOCOPY NUMBER
59 , x_lot_number OUT NOCOPY VARCHAR2
60 , x_organization_id OUT NOCOPY NUMBER
61 , x_project_id OUT NOCOPY NUMBER
62 , x_quantity OUT NOCOPY NUMBER
63 , x_quantity_delivered OUT NOCOPY NUMBER
64 , x_quantity_detailed OUT NOCOPY NUMBER
65 , x_reason_id OUT NOCOPY NUMBER
66 , x_reference OUT NOCOPY VARCHAR2
67 , x_reference_id OUT NOCOPY NUMBER
68 , x_reference_type_code OUT NOCOPY NUMBER
69 , x_revision OUT NOCOPY VARCHAR2
70 , x_serial_number_end OUT NOCOPY VARCHAR2
71 , x_serial_number_start OUT NOCOPY VARCHAR2
72 , x_status_date OUT NOCOPY DATE
73 , x_task_id OUT NOCOPY NUMBER
74 , x_to_account_id OUT NOCOPY NUMBER
75 , x_to_locator_id OUT NOCOPY NUMBER
76 , x_to_subinventory_code OUT NOCOPY VARCHAR2
77 , x_to_subinventory_id OUT NOCOPY NUMBER
78 , x_transaction_header_id OUT NOCOPY NUMBER
79 , x_uom_code OUT NOCOPY VARCHAR2
80 , x_from_locator OUT NOCOPY VARCHAR2
81 , x_inventory_item OUT NOCOPY VARCHAR2
82 , x_project OUT NOCOPY VARCHAR2
83 , x_reason OUT NOCOPY VARCHAR2
84 , x_reference_type OUT NOCOPY VARCHAR2
85 , x_task OUT NOCOPY VARCHAR2
86 , x_to_account OUT NOCOPY VARCHAR2
87 , x_to_locator OUT NOCOPY VARCHAR2
88 , x_transaction_type_id OUT NOCOPY NUMBER
89 , x_transaction_source_type_id OUT NOCOPY NUMBER
90 , x_txn_source_id OUT NOCOPY NUMBER
91 , x_txn_source_line_id OUT NOCOPY NUMBER
92 , x_txn_source_line_detail_id OUT NOCOPY NUMBER
93 , x_primary_quantity OUT NOCOPY NUMBER
94 , x_to_organization_id OUT NOCOPY NUMBER
95 , x_pick_strategy_id OUT NOCOPY NUMBER
96 , x_put_away_strategy_id OUT NOCOPY NUMBER
97 , x_unit_number OUT NOCOPY VARCHAR2
98 */
99 /* , x_ship_to_location_id OUT NOCOPY NUMBER NL MERGE */
100 /*
101 , x_transaction_type OUT NOCOPY VARCHAR2
102 );
103 */
104 /* Procedure : Validate_Record
105 */
106 /*
107 PROCEDURE Validate_Record
108 ( x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_attribute1 IN VARCHAR2
112 , p_attribute10 IN VARCHAR2
113 , p_attribute11 IN VARCHAR2
114 , p_attribute12 IN VARCHAR2
115 , p_attribute13 IN VARCHAR2
116 , p_attribute14 IN VARCHAR2
117 , p_attribute15 IN VARCHAR2
118 , p_attribute2 IN VARCHAR2
119 , p_attribute3 IN VARCHAR2
120 , p_attribute4 IN VARCHAR2
121 , p_attribute5 IN VARCHAR2
122 , p_attribute6 IN VARCHAR2
123 , p_attribute7 IN VARCHAR2
124 , p_attribute8 IN VARCHAR2
125 , p_attribute9 IN VARCHAR2
126 , p_attribute_category IN VARCHAR2
127 , p_date_required IN DATE
128 , p_from_locator_id IN NUMBER
129 , p_from_subinventory_code IN VARCHAR2
130 , p_from_subinventory_id IN NUMBER
131 , p_header_id IN NUMBER
132 , p_inventory_item_id IN NUMBER
133 , p_line_id IN NUMBER
134 , p_line_number IN NUMBER
135 , p_line_status IN NUMBER
136 , p_lot_number IN VARCHAR2
137 , p_organization_id IN NUMBER
138 , p_project_id IN NUMBER
139 , p_quantity IN NUMBER
140 , p_quantity_delivered IN NUMBER
141 , p_quantity_detailed IN NUMBER
142 , p_reason_id IN NUMBER
143 , p_reference IN VARCHAR2
144 , p_reference_id IN NUMBER
145 , p_reference_type_code IN NUMBER
146 , p_revision IN VARCHAR2
147 , p_serial_number_end IN VARCHAR2
148 , p_serial_number_start IN VARCHAR2
149 , p_status_date IN DATE
150 , p_task_id IN NUMBER
151 , p_to_account_id IN NUMBER
152 , p_to_locator_id IN NUMBER
153 , p_to_subinventory_code IN VARCHAR2
154 , p_to_subinventory_id IN NUMBER
155 , p_transaction_header_id IN NUMBER
156 , p_uom_code IN VARCHAR2
157 , p_transaction_type_id IN NUMBER
158 , p_transaction_source_type_id IN NUMBER
159 , p_txn_source_id IN NUMBER
160 , p_txn_source_line_id IN NUMBER
161 , p_txn_source_line_detail_id IN NUMBER
162 , p_primary_quantity IN NUMBER
163 , p_to_organization_id IN NUMBER
164 , p_pick_strategy_id IN NUMBER
165 , p_put_away_strategy_id IN NUMBER
166 , p_unit_number IN VARCHAR2
167 , p_ship_to_location_id IN NUMBER DEFAULT NULL
168 , p_db_flag IN VARCHAR2
169 );
170 odab */
171 /* Procedure Validate_And_Write
172 */
173
174 PROCEDURE Validate_And_Write
175 ( p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
176 , x_return_status OUT NOCOPY VARCHAR2
177 , x_msg_count OUT NOCOPY NUMBER
178 , x_msg_data OUT NOCOPY VARCHAR2
179 );
180
181 /* Procedure Delete_Row
182 */
183 /* odab
184
185 PROCEDURE Delete_Row
186 ( x_return_status OUT NOCOPY VARCHAR2
187 , x_msg_count OUT NOCOPY NUMBER
188 , x_msg_data OUT NOCOPY VARCHAR2
189 , p_line_id IN NUMBER
190 );
191 */
192 /* Procedure Process_Entity
193 */
194 /*
195 PROCEDURE Process_Entity
196 ( x_return_status OUT NOCOPY VARCHAR2
197 , x_msg_count OUT NOCOPY NUMBER
198 , x_msg_data OUT NOCOPY VARCHAR2
199 );
200 */
201 /* Procedure lock_Row
202 */
203 /* odab */
204 PROCEDURE Lock_Row
205 ( p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
206 , p_init_msg_list IN NUMBER
207 , x_return_status OUT NOCOPY VARCHAR2
208 , x_msg_count OUT NOCOPY NUMBER
209 , x_msg_data OUT NOCOPY VARCHAR2
210 );
211
212 END GMI_TO_Form_Trolin;