APPS.EAM_NETWORK_ASSETS_PVT dependencies on MTL_EAM_NETWORK_ASSETS

Line 116: CURSOR C IS SELECT rowid FROM MTL_EAM_NETWORK_ASSETS

112: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
113: l_api_version CONSTANT NUMBER := 1.0;
114: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
115:
116: CURSOR C IS SELECT rowid FROM MTL_EAM_NETWORK_ASSETS
117: WHERE NETWORK_ASSOCIATION_ID = P_NETWORK_ASSOCIATION_ID;
118:
119: BEGIN
120:

Line 139: INSERT INTO MTL_EAM_NETWORK_ASSETS(

135: x_return_status := fnd_api.g_ret_sts_success;
136:
137: -- API body
138:
139: INSERT INTO MTL_EAM_NETWORK_ASSETS(
140: NETWORK_ASSOCIATION_ID,
141: ORGANIZATION_ID,
142: NETWORK_OBJECT_TYPE,
143: NETWORK_OBJECT_ID,

Line 178: mtl_eam_network_assets_s.nextval,

174: PROGRAM_APPLICATION_ID,
175: PROGRAM_ID,
176: PROGRAM_UPDATE_DATE
177: ) VALUES (
178: mtl_eam_network_assets_s.nextval,
179: P_ORGANIZATION_ID ,
180: P_NETWORK_OBJECT_TYPE ,
181: P_NETWORK_OBJECT_ID,
182: P_MAINTENANCE_OBJECT_TYPE,

Line 304: FROM MTL_EAM_NETWORK_ASSETS

300: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
301:
302: CURSOR C IS
303: SELECT *
304: FROM MTL_EAM_NETWORK_ASSETS
305: WHERE rowid = P_Rowid
306: FOR UPDATE of NETWORK_ASSOCIATION_ID NOWAIT;
307: Recinfo C%ROWTYPE;
308:

Line 521: UPDATE MTL_EAM_NETWORK_ASSETS

517: x_return_status := fnd_api.g_ret_sts_success;
518:
519: -- API body
520:
521: UPDATE MTL_EAM_NETWORK_ASSETS
522: SET
523: ORGANIZATION_ID = P_ORGANIZATION_ID,
524: MAINTENANCE_OBJECT_TYPE = P_MAINTENANCE_OBJECT_TYPE,
525: MAINTENANCE_OBJECT_ID = P_MAINTENANCE_OBJECT_ID,