APPS.MTL_STATUS_ATTRIB_VAL_PKG dependencies on MTL_STATUS_ATTRIBUTE_VALUES

Line 13: FROM MTL_STATUS_ATTRIBUTE_VALUES

9: X_Attribute_Value VARCHAR2
10: ) IS
11: CURSOR C IS
12: SELECT *
13: FROM MTL_STATUS_ATTRIBUTE_VALUES
14: WHERE rowid = X_Rowid
15: FOR UPDATE of Inventory_Item_Status_Code NOWAIT;
16: Recinfo C%ROWTYPE;
17:

Line 59: UPDATE MTL_STATUS_ATTRIBUTE_VALUES

55: X_Attribute_Value,
56: X_Inventory_Item_Status_Code);
57: END IF;
58:
59: UPDATE MTL_STATUS_ATTRIBUTE_VALUES
60: SET
61: inventory_item_status_code = X_Inventory_Item_Status_Code,
62: attribute_name = X_Attribute_Name,
63: attribute_value = X_Attribute_Value,

Line 77: DELETE FROM MTL_STATUS_ATTRIBUTE_VALUES

73:
74:
75: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
76: BEGIN
77: DELETE FROM MTL_STATUS_ATTRIBUTE_VALUES
78: WHERE rowid = X_Rowid;
79:
80: if (SQL%NOTFOUND) then
81: Raise NO_DATA_FOUND;

Line 88: ------ fields of MTL_STATUS_ATTRIBUTE_VALUES. Earlier 'logid' was used instead.

84:
85:
86: ------ BUG #867987 : Changes made in the following procedure.
87: ------ Adding variable 'userid' to populate the last_updated_by and created_by
88: ------ fields of MTL_STATUS_ATTRIBUTE_VALUES. Earlier 'logid' was used instead.
89:
90: PROCEDURE Populate_Tab ( status_code IN VARCHAR2 )
91: IS
92: logid NUMBER;

Line 98: insert into mtl_status_attribute_values

94: BEGIN
95: logid := FND_GLOBAL.LOGIN_ID;
96: userid := FND_GLOBAL.USER_ID;
97:
98: insert into mtl_status_attribute_values
99: ( inventory_item_status_code,
100: attribute_name,
101: attribute_value,
102: last_update_date,