APPS.MTL_CYCLE_COUNT_CLASSES_PKG dependencies on MTL_CYCLE_COUNT_CLASSES

Line 1: PACKAGE BODY MTL_CYCLE_COUNT_CLASSES_PKG as

1: PACKAGE BODY MTL_CYCLE_COUNT_CLASSES_PKG as
2: /* $Header: INVADC3B.pls 120.1 2005/06/19 05:07:35 appldev $ */
3: --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
4: --GSCC standard File.Sql.39. BUg:4410902
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 23: CURSOR C IS SELECT rowid FROM mtl_cycle_count_classes

19: X_Hit_Miss_Tolerance_Positive NUMBER,
20: X_Hit_Miss_Tolerance_Negative NUMBER,
21: X_Abc_Assignment_Group_Id NUMBER
22: ) IS
23: CURSOR C IS SELECT rowid FROM mtl_cycle_count_classes
24: WHERE ( (cycle_count_header_id = X_Cycle_Count_Header_Id)
25: or (cycle_count_header_id is NULL and X_Cycle_Count_Header_Id is NULL));
26:
27: BEGIN

Line 29: INSERT INTO mtl_cycle_count_classes(

25: or (cycle_count_header_id is NULL and X_Cycle_Count_Header_Id is NULL));
26:
27: BEGIN
28:
29: INSERT INTO mtl_cycle_count_classes(
30: abc_class_id,
31: cycle_count_header_id,
32: organization_id,
33: last_update_date,

Line 90: FROM mtl_cycle_count_classes

86: X_Abc_Assignment_Group_Id NUMBER
87: ) IS
88: CURSOR C IS
89: SELECT *
90: FROM mtl_cycle_count_classes
91: WHERE rowid = X_Rowid
92: FOR UPDATE of Cycle_Count_Header_Id NOWAIT;
93: Recinfo C%ROWTYPE;
94:

Line 161: UPDATE mtl_cycle_count_classes

157: X_Hit_Miss_Tolerance_Negative NUMBER,
158: X_Abc_Assignment_Group_Id NUMBER
159: ) IS
160: BEGIN
161: UPDATE mtl_cycle_count_classes
162: SET
163: abc_class_id = X_Abc_Class_Id,
164: cycle_count_header_id = X_Cycle_Count_Header_Id,
165: organization_id = X_Organization_Id,

Line 185: DELETE FROM mtl_cycle_count_classes

181: end if;
182: END Update_Row;
183: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
184: BEGIN
185: DELETE FROM mtl_cycle_count_classes
186: WHERE rowid = X_Rowid;
187:
188: if (SQL%NOTFOUND) then
189: Raise NO_DATA_FOUND;

Line 194: END MTL_CYCLE_COUNT_CLASSES_PKG;

190: end if;
191: END Delete_Row;
192:
193:
194: END MTL_CYCLE_COUNT_CLASSES_PKG;