APPS.EAM_ASSET_ACTIVITIES_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 144: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ACTIVITIES

140: l_api_version CONSTANT NUMBER := 1.0;
141: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
142: l_object_type NUMBER;
143:
144: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ACTIVITIES
145: WHERE ACTIVITY_ASSOCIATION_ID = P_ACTIVITY_ASSOCIATION_ID;
146:
147: BEGIN
148:

Line 167: INSERT INTO MTL_EAM_ASSET_ACTIVITIES(

163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: -- API body
166:
167: INSERT INTO MTL_EAM_ASSET_ACTIVITIES(
168: ACTIVITY_ASSOCIATION_ID,
169: ASSET_ACTIVITY_ID,
170: INVENTORY_ITEM_ID,
171: SERIAL_NUMBER,

Line 204: mtl_eam_asset_activities_s.nextval,

200: TMPL_FLAG,
201: MAINTENANCE_OBJECT_ID,
202: MAINTENANCE_OBJECT_TYPE
203: ) VALUES (
204: mtl_eam_asset_activities_s.nextval,
205: P_ASSET_ACTIVITY_ID,
206: P_INVENTORY_ITEM_ID,
207: P_SERIAL_NUMBER,
208: P_START_DATE_ACTIVE,

Line 362: FROM MTL_EAM_ASSET_ACTIVITIES

358: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
359:
360: CURSOR C IS
361: SELECT *
362: FROM MTL_EAM_ASSET_ACTIVITIES
363: WHERE rowid = P_Rowid
364: FOR UPDATE of ASSET_ACTIVITY_ID NOWAIT;
365: Recinfo C%ROWTYPE;
366:

Line 584: UPDATE MTL_EAM_ASSET_ACTIVITIES

580: x_return_status := fnd_api.g_ret_sts_success;
581:
582: -- API body
583:
584: UPDATE MTL_EAM_ASSET_ACTIVITIES
585: SET
586: -- INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
587: -- SERIAL_NUMBER = P_SERIAL_NUMBER,
588: START_DATE_ACTIVE = P_START_DATE_ACTIVE,