[Home] [Help]
PACKAGE: APPS.MTL_CYCLE_COUNT_ENTRIES_PKG
Source
1 PACKAGE MTL_CYCLE_COUNT_ENTRIES_PKG as
2 /* $Header: INVATCES.pls 120.1.12000000.1 2007/01/17 16:11:19 appldev ship $ */
3 --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
4 --GSCC File.Sql.39 standard Bug:4410902
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Cycle_Count_Entry_Id NUMBER,
7 X_Last_Update_Date DATE,
8 X_Last_Updated_By NUMBER,
9 X_Creation_Date DATE,
10 X_Created_By NUMBER,
11 X_Last_Update_Login NUMBER,
12 X_Count_List_Sequence NUMBER,
13 X_Count_Date_First DATE,
14 X_Count_Date_Current DATE,
15 X_Count_Date_Prior DATE,
16 X_Count_Date_Dummy DATE,
17 X_Counted_By_Employee_Id_First NUMBER,
18 X_Counted_By_Employee_Id_Curr NUMBER,
19 X_Counted_By_Employee_Id_Prior NUMBER,
20 X_Counted_By_Employee_Id_Dummy NUMBER,
21 X_Count_Uom_First VARCHAR2,
22 X_Count_Uom_Current VARCHAR2,
23 X_Count_Uom_Prior VARCHAR2,
24 X_Count_Quantity_First NUMBER,
25 X_Count_Quantity_Current NUMBER,
26 X_Count_Quantity_Prior NUMBER,
27 X_Inventory_Item_Id NUMBER,
28 X_Subinventory VARCHAR2,
29 X_Entry_Status_Code NUMBER,
30 X_Count_Due_Date DATE,
31 X_Organization_Id NUMBER,
32 X_Cycle_Count_Header_Id NUMBER,
33 X_Number_Of_Counts NUMBER,
34 X_Locator_Id NUMBER,
35 X_Adjustment_Quantity NUMBER,
36 X_Adjustment_Date DATE,
37 X_Adjustment_Amount NUMBER,
38 X_Item_Unit_Cost NUMBER,
39 X_Inventory_Adjustment_Account NUMBER,
40 X_Approval_Date DATE,
41 X_Approver_Employee_Id NUMBER,
42 X_Revision VARCHAR2,
43 X_Lot_Number VARCHAR2,
44 X_Lot_Control VARCHAR2,
45 X_System_Quantity_First NUMBER,
46 X_System_Quantity_Current NUMBER,
47 X_System_Quantity_Prior NUMBER,
48 X_Reference_First VARCHAR2,
49 X_Reference_Current VARCHAR2,
50 X_Reference_Prior VARCHAR2,
51 X_Primary_Uom_Quantity_First NUMBER,
52 X_Primary_Uom_Quantity_Current NUMBER,
53 X_Primary_Uom_Quantity_Prior NUMBER,
54 X_Count_Type_Code NUMBER,
55 X_Transaction_Reason_Id NUMBER,
56 X_Approval_Type NUMBER,
57 X_Attribute_Category VARCHAR2,
58 X_Attribute1 VARCHAR2,
59 X_Attribute2 VARCHAR2,
60 X_Attribute3 VARCHAR2,
61 X_Attribute4 VARCHAR2,
62 X_Attribute5 VARCHAR2,
63 X_Attribute6 VARCHAR2,
64 X_Attribute7 VARCHAR2,
65 X_Attribute8 VARCHAR2,
66 X_Attribute9 VARCHAR2,
67 X_Attribute10 VARCHAR2,
68 X_Attribute11 VARCHAR2,
69 X_Attribute12 VARCHAR2,
70 X_Attribute13 VARCHAR2,
71 X_Attribute14 VARCHAR2,
72 X_Attribute15 VARCHAR2,
73 X_Serial_Number VARCHAR2,
74 X_Serial_Detail NUMBER,
75 X_Approval_Condition NUMBER,
76 X_Neg_Adjustment_Quantity NUMBER,
77 X_Neg_Adjustment_Amount NUMBER,
78
79 -- WMS
80 X_Outermost_Lpn_ID NUMBER DEFAULT NULL,
81 X_Parent_Lpn_ID NUMBER DEFAULT NULL,
82 X_Cost_Group_ID NUMBER DEFAULT NULL,
83
84 -- BEGIN INVCONV
85 X_Count_Secondary_Uom_First VARCHAR2 DEFAULT NULL,
86 X_Count_Secondary_Uom_Current VARCHAR2 DEFAULT NULL,
87 X_Count_Secondary_Uom_Prior VARCHAR2 DEFAULT NULL,
88 X_Secondary_Uom_Quantity_First NUMBER DEFAULT NULL,
89 X_Secondary_Uom_Quantity_Curr NUMBER DEFAULT NULL,
90 X_Secondary_Uom_Quantity_Prior NUMBER DEFAULT NULL,
91 X_Secondary_System_Qty_First NUMBER DEFAULT NULL,
92 X_Secondary_System_Qty_Current NUMBER DEFAULT NULL,
93 X_Secondary_System_Qty_Prior NUMBER DEFAULT NULL,
94 X_Secondary_Adjustment_Qty NUMBER DEFAULT NULL
95 -- END INVCONV
96 );
97
98 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
99 X_Cycle_Count_Entry_Id NUMBER,
100 X_Count_List_Sequence NUMBER,
101 X_Count_Date_First DATE,
102 X_Count_Date_Current DATE,
103 X_Count_Date_Prior DATE,
104 X_Count_Date_Dummy DATE,
105 X_Counted_By_Employee_Id_First NUMBER,
106 X_Counted_By_Employee_Id_Curr NUMBER,
107 X_Counted_By_Employee_Id_Prior NUMBER,
108 X_Counted_By_Employee_Id_Dummy NUMBER,
109 X_Count_Uom_First VARCHAR2,
110 X_Count_Uom_Current VARCHAR2,
111 X_Count_Uom_Prior VARCHAR2,
112 X_Count_Quantity_First NUMBER,
113 X_Count_Quantity_Current NUMBER,
114 X_Count_Quantity_Prior NUMBER,
115 X_Inventory_Item_Id NUMBER,
116 X_Subinventory VARCHAR2,
117 X_Entry_Status_Code NUMBER,
118 X_Count_Due_Date DATE,
119 X_Organization_Id NUMBER,
120 X_Cycle_Count_Header_Id NUMBER,
121 X_Number_Of_Counts NUMBER,
122 X_Locator_Id NUMBER,
123 X_Adjustment_Quantity NUMBER,
124 X_Adjustment_Date DATE,
125 X_Adjustment_Amount NUMBER,
126 X_Item_Unit_Cost NUMBER,
127 X_Inventory_Adjustment_Account NUMBER,
128 X_Approval_Date DATE,
129 X_Approver_Employee_Id NUMBER,
130 X_Revision VARCHAR2,
131 X_Lot_Number VARCHAR2,
132 X_Lot_Control VARCHAR2,
133 X_System_Quantity_First NUMBER,
134 X_System_Quantity_Current NUMBER,
135 X_System_Quantity_Prior NUMBER,
136 X_Reference_First VARCHAR2,
137 X_Reference_Current VARCHAR2,
138 X_Reference_Prior VARCHAR2,
139 X_Primary_Uom_Quantity_First NUMBER,
140 X_Primary_Uom_Quantity_Current NUMBER,
141 X_Primary_Uom_Quantity_Prior NUMBER,
142 X_Count_Type_Code NUMBER,
143 X_Transaction_Reason_Id NUMBER,
144 X_Approval_Type NUMBER,
145 X_Attribute_Category VARCHAR2,
146 X_Attribute1 VARCHAR2,
147 X_Attribute2 VARCHAR2,
148 X_Attribute3 VARCHAR2,
149 X_Attribute4 VARCHAR2,
150 X_Attribute5 VARCHAR2,
151 X_Attribute6 VARCHAR2,
152 X_Attribute7 VARCHAR2,
153 X_Attribute8 VARCHAR2,
154 X_Attribute9 VARCHAR2,
155 X_Attribute10 VARCHAR2,
156 X_Attribute11 VARCHAR2,
157 X_Attribute12 VARCHAR2,
158 X_Attribute13 VARCHAR2,
159 X_Attribute14 VARCHAR2,
160 X_Attribute15 VARCHAR2,
161 X_Serial_number VARCHAR2,
162 X_Serial_Detail NUMBER,
163 X_Approval_Condition NUMBER,
164 X_Neg_Adjustment_Quantity NUMBER,
165 X_Neg_Adjustment_Amount NUMBER,
166
167 -- WMS
168 X_Outermost_Lpn_ID NUMBER DEFAULT NULL,
169 X_Parent_Lpn_ID NUMBER DEFAULT NULL,
170 X_Cost_Group_ID NUMBER DEFAULT NULL,
171
172 -- BEGIN INVCONV
173 X_Count_Secondary_Uom_First VARCHAR2 DEFAULT NULL,
174 X_Count_Secondary_Uom_Current VARCHAR2 DEFAULT NULL,
175 X_Count_Secondary_Uom_Prior VARCHAR2 DEFAULT NULL,
176 X_Secondary_Uom_Quantity_First NUMBER DEFAULT NULL,
177 X_Secondary_Uom_Quantity_Curr NUMBER DEFAULT NULL,
178 X_Secondary_Uom_Quantity_Prior NUMBER DEFAULT NULL,
179 X_Secondary_System_Qty_First NUMBER DEFAULT NULL,
180 X_Secondary_System_Qty_Current NUMBER DEFAULT NULL,
181 X_Secondary_System_Qty_Prior NUMBER DEFAULT NULL,
182 X_Secondary_Adjustment_Qty NUMBER DEFAULT NULL
183 -- END INVCONV
184 );
185
186 PROCEDURE Update_Row(X_Rowid VARCHAR2,
187 X_Cycle_Count_Entry_Id NUMBER,
188 X_Last_Update_Date DATE,
189 X_Last_Updated_By NUMBER,
190 X_Last_Update_Login NUMBER,
191 X_Count_List_Sequence NUMBER,
192 X_Count_Date_First DATE,
193 X_Count_Date_Current DATE,
194 X_Count_Date_Prior DATE,
195 X_Count_Date_Dummy DATE,
196 X_Counted_By_Employee_Id_First NUMBER,
197 X_Counted_By_Employee_Id_Curr NUMBER,
198 X_Counted_By_Employee_Id_Prior NUMBER,
199 X_Counted_By_Employee_Id_Dummy NUMBER,
200 X_Count_Uom_First VARCHAR2,
201 X_Count_Uom_Current VARCHAR2,
202 X_Count_Uom_Prior VARCHAR2,
203 X_Count_Quantity_First NUMBER,
204 X_Count_Quantity_Current NUMBER,
205 X_Count_Quantity_Prior NUMBER,
206 X_Inventory_Item_Id NUMBER,
207 X_Subinventory VARCHAR2,
208 X_Entry_Status_Code NUMBER,
209 X_Count_Due_Date DATE,
210 X_Organization_Id NUMBER,
211 X_Cycle_Count_Header_Id NUMBER,
212 X_Number_Of_Counts NUMBER,
213 X_Locator_Id NUMBER,
214 X_Adjustment_Quantity NUMBER,
215 X_Adjustment_Date DATE,
216 X_Adjustment_Amount NUMBER,
217 X_Item_Unit_Cost NUMBER,
218 X_Inventory_Adjustment_Account NUMBER,
219 X_Approval_Date DATE,
220 X_Approver_Employee_Id NUMBER,
221 X_Revision VARCHAR2,
222 X_Lot_Number VARCHAR2,
223 X_Lot_Control VARCHAR2,
224 X_System_Quantity_First NUMBER,
225 X_System_Quantity_Current NUMBER,
226 X_System_Quantity_Prior NUMBER,
227 X_Reference_First VARCHAR2,
228 X_Reference_Current VARCHAR2,
229 X_Reference_Prior VARCHAR2,
230 X_Primary_Uom_Quantity_First NUMBER,
231 X_Primary_Uom_Quantity_Current NUMBER,
232 X_Primary_Uom_Quantity_Prior NUMBER,
233 X_Count_Type_Code NUMBER,
234 X_Transaction_Reason_Id NUMBER,
235 X_Approval_Type NUMBER,
236 X_Attribute_Category VARCHAR2,
237 X_Attribute1 VARCHAR2,
238 X_Attribute2 VARCHAR2,
239 X_Attribute3 VARCHAR2,
240 X_Attribute4 VARCHAR2,
241 X_Attribute5 VARCHAR2,
242 X_Attribute6 VARCHAR2,
243 X_Attribute7 VARCHAR2,
244 X_Attribute8 VARCHAR2,
245 X_Attribute9 VARCHAR2,
246 X_Attribute10 VARCHAR2,
247 X_Attribute11 VARCHAR2,
248 X_Attribute12 VARCHAR2,
249 X_Attribute13 VARCHAR2,
250 X_Attribute14 VARCHAR2,
251 X_Attribute15 VARCHAR2,
252 X_Serial_Number VARCHAR2,
253 X_Serial_Detail NUMBER,
254 X_Approval_Condition NUMBER,
255 X_Neg_Adjustment_Quantity NUMBER,
256 X_Neg_Adjustment_Amount NUMBER,
257
258 -- WMS
259 X_Outermost_Lpn_ID NUMBER DEFAULT NULL,
260 X_Parent_Lpn_ID NUMBER DEFAULT NULL,
261 X_Cost_Group_ID NUMBER DEFAULT NULL,
262
263 -- BEGIN INVCONV
267 X_Secondary_Uom_Quantity_First NUMBER DEFAULT NULL,
264 X_Count_Secondary_Uom_First VARCHAR2 DEFAULT NULL,
265 X_Count_Secondary_Uom_Current VARCHAR2 DEFAULT NULL,
266 X_Count_Secondary_Uom_Prior VARCHAR2 DEFAULT NULL,
268 X_Secondary_Uom_Quantity_Curr NUMBER DEFAULT NULL,
269 X_Secondary_Uom_Quantity_Prior NUMBER DEFAULT NULL,
270 X_Secondary_System_Qty_First NUMBER DEFAULT NULL,
271 X_Secondary_System_Qty_Current NUMBER DEFAULT NULL,
272 X_Secondary_System_Qty_Prior NUMBER DEFAULT NULL,
273 X_Secondary_Adjustment_Qty NUMBER DEFAULT NULL
274 -- END INVCONV
275 );
276 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
277
278 END MTL_CYCLE_COUNT_ENTRIES_PKG;