[Home] [Help]
PACKAGE: APPS.MTL_CYCLE_COUNT_HEADERS_PKG
Source
1 PACKAGE MTL_CYCLE_COUNT_HEADERS_PKG as
2 /* $Header: INVADCYS.pls 120.1 2005/06/19 05:35:23 appldev $ */
3
4 --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
5 --GSCC File.Sql.39 standard Bug:4410902
6 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
7 X_Cycle_Count_Header_Id NUMBER,
8 X_Organization_Id NUMBER,
9 X_Last_Update_Date DATE,
10 X_Last_Updated_By NUMBER,
11 X_Creation_Date DATE,
12 X_Created_By NUMBER,
13 X_Last_Update_Login NUMBER,
14 X_Cycle_Count_Header_Name VARCHAR2,
15 X_Inventory_Adjustment_Account NUMBER,
16 X_Orientation_Code NUMBER,
17 X_Abc_Assignment_Group_Id NUMBER,
18 X_Onhand_Visible_Flag NUMBER,
19 X_Days_Until_Late NUMBER,
20 X_Autoschedule_Enabled_Flag NUMBER,
21 X_Schedule_Interval_Time NUMBER,
22 X_Zero_Count_Flag NUMBER,
23 X_Header_Last_Schedule_Date DATE,
24 X_Header_Next_Schedule_Date DATE,
25 X_Disable_Date DATE,
26 X_Approval_Option_Code NUMBER,
27 X_Automatic_Recount_Flag NUMBER,
28 X_Next_User_Count_Sequence NUMBER,
29 X_Unscheduled_Count_Entry NUMBER,
30 X_Cycle_Count_Calendar VARCHAR2,
31 X_Calendar_Exception_Set NUMBER,
32 X_Approval_Tolerance_Positive NUMBER,
33 X_Approval_Tolerance_Negative NUMBER,
34 X_Cost_Tolerance_Positive NUMBER,
35 X_Cost_Tolerance_Negative NUMBER,
36 X_Hit_Miss_Tolerance_Positive NUMBER,
37 X_Hit_Miss_Tolerance_Negative NUMBER,
38 X_Abc_Initialization_Status NUMBER,
39 X_Description VARCHAR2,
40 X_Attribute_Category VARCHAR2,
41 X_Attribute1 VARCHAR2,
42 X_Attribute2 VARCHAR2,
43 X_Attribute3 VARCHAR2,
44 X_Attribute4 VARCHAR2,
45 X_Attribute5 VARCHAR2,
46 X_Attribute6 VARCHAR2,
47 X_Attribute7 VARCHAR2,
48 X_Attribute8 VARCHAR2,
49 X_Attribute9 VARCHAR2,
50 X_Attribute10 VARCHAR2,
51 X_Attribute11 VARCHAR2,
52 X_Attribute12 VARCHAR2,
53 X_Attribute13 VARCHAR2,
54 X_Attribute14 VARCHAR2,
55 X_Attribute15 VARCHAR2,
56 X_Maximum_Auto_Recounts NUMBER,
57 X_Serial_Count_Option NUMBER,
58 X_Serial_Detail_Option NUMBER,
59 X_Serial_Adjustment_Option NUMBER,
60 X_Serial_Discrepancy_Option NUMBER
61
62 -- WMS
63 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
64 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
65 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
66 );
67
68 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
69 X_Cycle_Count_Header_Id NUMBER,
70 X_Organization_Id NUMBER,
71 X_Cycle_Count_Header_Name VARCHAR2,
72 X_Inventory_Adjustment_Account NUMBER,
73 X_Orientation_Code NUMBER,
74 X_Abc_Assignment_Group_Id NUMBER,
75 X_Onhand_Visible_Flag NUMBER,
76 X_Days_Until_Late NUMBER,
77 X_Autoschedule_Enabled_Flag NUMBER,
78 X_Schedule_Interval_Time NUMBER,
79 X_Zero_Count_Flag NUMBER,
80 X_Header_Last_Schedule_Date DATE,
81 X_Header_Next_Schedule_Date DATE,
82 X_Disable_Date DATE,
83 X_Approval_Option_Code NUMBER,
84 X_Automatic_Recount_Flag NUMBER,
85 X_Next_User_Count_Sequence NUMBER,
86 X_Unscheduled_Count_Entry NUMBER,
87 X_Cycle_Count_Calendar VARCHAR2,
88 X_Calendar_Exception_Set NUMBER,
89 X_Approval_Tolerance_Positive NUMBER,
90 X_Approval_Tolerance_Negative NUMBER,
91 X_Cost_Tolerance_Positive NUMBER,
92 X_Cost_Tolerance_Negative NUMBER,
93 X_Hit_Miss_Tolerance_Positive NUMBER,
94 X_Hit_Miss_Tolerance_Negative NUMBER,
95 X_Abc_Initialization_Status NUMBER,
96 X_Description VARCHAR2,
97 X_Attribute_Category VARCHAR2,
98 X_Attribute1 VARCHAR2,
99 X_Attribute2 VARCHAR2,
100 X_Attribute3 VARCHAR2,
101 X_Attribute4 VARCHAR2,
102 X_Attribute5 VARCHAR2,
103 X_Attribute6 VARCHAR2,
104 X_Attribute7 VARCHAR2,
105 X_Attribute8 VARCHAR2,
106 X_Attribute9 VARCHAR2,
107 X_Attribute10 VARCHAR2,
108 X_Attribute11 VARCHAR2,
109 X_Attribute12 VARCHAR2,
110 X_Attribute13 VARCHAR2,
111 X_Attribute14 VARCHAR2,
112 X_Attribute15 VARCHAR2,
113 X_Maximum_Auto_Recounts NUMBER,
114 X_Serial_Count_Option NUMBER,
115 X_Serial_Detail_Option NUMBER,
116 X_Serial_Adjustment_Option NUMBER,
117 X_Serial_Discrepancy_Option NUMBER
118
119 -- WMS
120 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
121 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
122 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
123 );
124
125
126 PROCEDURE Update_Row(X_Rowid VARCHAR2,
127 X_Cycle_Count_Header_Id NUMBER,
128 X_Organization_Id NUMBER,
129 X_Last_Update_Date DATE,
130 X_Last_Updated_By NUMBER,
131 X_Last_Update_Login NUMBER,
132 X_Cycle_Count_Header_Name VARCHAR2,
133 X_Inventory_Adjustment_Account NUMBER,
134 X_Orientation_Code NUMBER,
135 X_Abc_Assignment_Group_Id NUMBER,
136 X_Onhand_Visible_Flag NUMBER,
137 X_Days_Until_Late NUMBER,
138 X_Autoschedule_Enabled_Flag NUMBER,
139 X_Schedule_Interval_Time NUMBER,
140 X_Zero_Count_Flag NUMBER,
141 X_Header_Last_Schedule_Date DATE,
142 X_Header_Next_Schedule_Date DATE,
143 X_Disable_Date DATE,
144 X_Approval_Option_Code NUMBER,
145 X_Automatic_Recount_Flag NUMBER,
146 X_Next_User_Count_Sequence NUMBER,
147 X_Unscheduled_Count_Entry NUMBER,
148 X_Cycle_Count_Calendar VARCHAR2,
149 X_Calendar_Exception_Set NUMBER,
150 X_Approval_Tolerance_Positive NUMBER,
151 X_Approval_Tolerance_Negative NUMBER,
152 X_Cost_Tolerance_Positive NUMBER,
153 X_Cost_Tolerance_Negative NUMBER,
154 X_Hit_Miss_Tolerance_Positive NUMBER,
155 X_Hit_Miss_Tolerance_Negative NUMBER,
156 X_Abc_Initialization_Status NUMBER,
157 X_Description VARCHAR2,
158 X_Attribute_Category VARCHAR2,
159 X_Attribute1 VARCHAR2,
160 X_Attribute2 VARCHAR2,
161 X_Attribute3 VARCHAR2,
162 X_Attribute4 VARCHAR2,
163 X_Attribute5 VARCHAR2,
164 X_Attribute6 VARCHAR2,
165 X_Attribute7 VARCHAR2,
166 X_Attribute8 VARCHAR2,
167 X_Attribute9 VARCHAR2,
168 X_Attribute10 VARCHAR2,
169 X_Attribute11 VARCHAR2,
170 X_Attribute12 VARCHAR2,
171 X_Attribute13 VARCHAR2,
172 X_Attribute14 VARCHAR2,
173 X_Attribute15 VARCHAR2,
174 X_Maximum_Auto_Recounts NUMBER,
175 X_Serial_Count_Option NUMBER,
176 X_Serial_Detail_Option NUMBER,
177 X_Serial_Adjustment_Option NUMBER,
178 X_Serial_Discrepancy_Option NUMBER
179
180 -- WMS
181 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
182 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
183 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
184 );
185
186 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
187
188 END MTL_CYCLE_COUNT_HEADERS_PKG;