APPS.AMS_ITEM_OWNERS_PKG dependencies on AMS_ITEM_ATTRIBUTES

Line 30: CURSOR C IS SELECT rowid FROM AMS_ITEM_ATTRIBUTES

26:
27: IS
28: X_ROWID VARCHAR2(30);
29:
30: CURSOR C IS SELECT rowid FROM AMS_ITEM_ATTRIBUTES
31: WHERE ITEM_OWNER_ID = px_ITEM_OWNER_ID;
32: CURSOR C2 IS SELECT AMS_ITEM_ATTRIBUTES_S.nextval FROM sys.dual;
33:
34: BEGIN

Line 32: CURSOR C2 IS SELECT AMS_ITEM_ATTRIBUTES_S.nextval FROM sys.dual;

28: X_ROWID VARCHAR2(30);
29:
30: CURSOR C IS SELECT rowid FROM AMS_ITEM_ATTRIBUTES
31: WHERE ITEM_OWNER_ID = px_ITEM_OWNER_ID;
32: CURSOR C2 IS SELECT AMS_ITEM_ATTRIBUTES_S.nextval FROM sys.dual;
33:
34: BEGIN
35:
36: IF (px_ITEM_OWNER_ID IS NULL) THEN

Line 47: INSERT INTO AMS_ITEM_ATTRIBUTES(

43: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
44: px_OBJECT_VERSION_NUMBER := 1;
45: END IF;
46:
47: INSERT INTO AMS_ITEM_ATTRIBUTES(
48: ITEM_OWNER_ID,
49: OBJECT_VERSION_NUMBER,
50: INVENTORY_ITEM_ID,
51: ORGANIZATION_ID,

Line 103: Update AMS_ITEM_ATTRIBUTES

99: p_ITEM_SETUP_TYPE VARCHAR2)
100:
101: IS
102: BEGIN
103: Update AMS_ITEM_ATTRIBUTES
104: SET
105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

Line 129: DELETE FROM AMS_ITEM_ATTRIBUTES

125: PROCEDURE Delete_Row(
126: p_ITEM_OWNER_ID NUMBER)
127: IS
128: BEGIN
129: DELETE FROM AMS_ITEM_ATTRIBUTES
130: WHERE ITEM_OWNER_ID = p_ITEM_OWNER_ID;
131: If (SQL%NOTFOUND) then
132: RAISE NO_DATA_FOUND;
133: End If;

Line 151: FROM AMS_ITEM_ATTRIBUTES

147:
148: IS
149: CURSOR C IS
150: SELECT *
151: FROM AMS_ITEM_ATTRIBUTES
152: WHERE ITEM_OWNER_ID = p_ITEM_OWNER_ID
153: FOR UPDATE of ITEM_OWNER_ID NOWAIT;
154: Recinfo C%ROWTYPE;
155: BEGIN