APPS.MTL_CYCLE_COUNT_ITEMS_PKG dependencies on MTL_CYCLE_COUNT_ITEMS

Line 1: PACKAGE BODY MTL_CYCLE_COUNT_ITEMS_PKG as

1: PACKAGE BODY MTL_CYCLE_COUNT_ITEMS_PKG as
2: /* $Header: INVADC2B.pls 120.1 2005/06/19 01:01:08 appldev $ */
3: --Added NOCOPY hint to X_Rowid to comply with GSCC File.Sql.39
4: --standard Bug:4410902
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 20: CURSOR C IS SELECT rowid FROM mtl_cycle_count_items

16: X_Approval_Tolerance_Positive NUMBER,
17: X_Approval_Tolerance_Negative NUMBER,
18: X_Control_Group_Flag NUMBER
19: ) IS
20: CURSOR C IS SELECT rowid FROM mtl_cycle_count_items
21: WHERE cycle_count_header_id = X_Cycle_Count_Header_Id;
22:
23: BEGIN
24: INSERT INTO mtl_cycle_count_items(

Line 24: INSERT INTO mtl_cycle_count_items(

20: CURSOR C IS SELECT rowid FROM mtl_cycle_count_items
21: WHERE cycle_count_header_id = X_Cycle_Count_Header_Id;
22:
23: BEGIN
24: INSERT INTO mtl_cycle_count_items(
25: cycle_count_header_id,
26: inventory_item_id,
27: last_update_date,
28: last_updated_by,

Line 76: FROM mtl_cycle_count_items

72: X_Control_Group_Flag NUMBER
73: ) IS
74: CURSOR C IS
75: SELECT *
76: FROM mtl_cycle_count_items
77: WHERE rowid = X_Rowid
78: FOR UPDATE of Cycle_Count_Header_Id NOWAIT;
79: Recinfo C%ROWTYPE;
80:

Line 133: UPDATE mtl_cycle_count_items

129: X_Approval_Tolerance_Negative NUMBER,
130: X_Control_Group_Flag NUMBER
131: ) IS
132: BEGIN
133: UPDATE mtl_cycle_count_items
134: SET
135: cycle_count_header_id = X_Cycle_Count_Header_Id,
136: inventory_item_id = X_Inventory_Item_Id,
137: last_update_date = X_Last_Update_Date,

Line 154: DELETE FROM mtl_cycle_count_items

150: end if;
151: END Update_Row;
152: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
153: BEGIN
154: DELETE FROM mtl_cycle_count_items
155: WHERE rowid = X_Rowid;
156:
157: if (SQL%NOTFOUND) then
158: Raise NO_DATA_FOUND;

Line 163: END MTL_CYCLE_COUNT_ITEMS_PKG;

159: end if;
160: END Delete_Row;
161:
162:
163: END MTL_CYCLE_COUNT_ITEMS_PKG;