APPS.EAM_ATTR_ASSIGN_PVT dependencies on MTL_EAM_ASSET_ATTR_GROUPS

Line 68: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_GROUPS

64: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
65: l_api_version CONSTANT NUMBER := 1.0;
66: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
67:
68: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_GROUPS
69: WHERE ASSOCIATION_ID = P_ATTRIBUTE_ASSOCIATION_ID;
70: BEGIN
71:
72: -- Standard Start of API savepoint

Line 90: INSERT INTO MTL_EAM_ASSET_ATTR_GROUPS(

86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: -- API body
89:
90: INSERT INTO MTL_EAM_ASSET_ATTR_GROUPS(
91: ASSOCIATION_ID,
92: APPLICATION_ID,
93: DESCRIPTIVE_FLEXFIELD_NAME,
94: DESCRIPTIVE_FLEX_CONTEXT_CODE,

Line 106: mtl_eam_asset_attr_groups_s.nextval,

102: LAST_UPDATE_LOGIN,
103: CREATION_ORGANIZATION_ID
104: ) values (
105: -- P_ATTRIBUTE_ASSOCIATION_ID,
106: mtl_eam_asset_attr_groups_s.nextval,
107: P_APPLICATION_ID,
108: P_FLEXFIELD_NAME,
109: P_FLEX_CONTEXT_CODE,
110: P_ORGANIZATION_ID,

Line 182: FROM MTL_EAM_ASSET_ATTR_GROUPS

178: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
179:
180: CURSOR C IS
181: SELECT *
182: FROM MTL_EAM_ASSET_ATTR_GROUPS
183: WHERE rowid = P_Rowid
184: FOR UPDATE of ASSOCIATION_ID NOWAIT;
185: Recinfo C%ROWTYPE;
186:

Line 296: UPDATE MTL_EAM_ASSET_ATTR_GROUPS

292: x_return_status := fnd_api.g_ret_sts_success;
293:
294: -- API body
295:
296: UPDATE MTL_EAM_ASSET_ATTR_GROUPS
297: SET
298: ENABLED_FLAG = P_ENABLED_FLAG,
299: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
300: LAST_UPDATED_BY = P_LAST_UPDATED_BY,