APPS.EAM_ASSET_ACTIVITIES_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 149: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ACTIVITIES

145: l_api_version CONSTANT NUMBER := 1.0;
146: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
147: l_object_type NUMBER;
148:
149: CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ACTIVITIES
150: WHERE ACTIVITY_ASSOCIATION_ID = P_ACTIVITY_ASSOCIATION_ID;
151:
152: BEGIN
153:

Line 172: INSERT INTO MTL_EAM_ASSET_ACTIVITIES(

168: x_return_status := fnd_api.g_ret_sts_success;
169:
170: -- API body
171:
172: INSERT INTO MTL_EAM_ASSET_ACTIVITIES(
173: ACTIVITY_ASSOCIATION_ID,
174: ASSET_ACTIVITY_ID,
175: INVENTORY_ITEM_ID,
176: SERIAL_NUMBER,

Line 209: mtl_eam_asset_activities_s.nextval,

205: TMPL_FLAG,
206: MAINTENANCE_OBJECT_ID,
207: MAINTENANCE_OBJECT_TYPE
208: ) VALUES (
209: mtl_eam_asset_activities_s.nextval,
210: P_ASSET_ACTIVITY_ID,
211: P_INVENTORY_ITEM_ID,
212: P_SERIAL_NUMBER,
213: P_START_DATE_ACTIVE,

Line 372: FROM MTL_EAM_ASSET_ACTIVITIES

368: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
369:
370: CURSOR C IS
371: SELECT *
372: FROM MTL_EAM_ASSET_ACTIVITIES
373: WHERE rowid = P_Rowid
374: FOR UPDATE of ASSET_ACTIVITY_ID NOWAIT;
375: Recinfo C%ROWTYPE;
376:

Line 583: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps

579: l_object_type NUMBER;
580:
581: cursor pmSchedules is
582: select eps.pm_schedule_id
583: from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
584: where epa.activity_association_id=meaa.activity_association_id and
585: epa.pm_schedule_id=eps.pm_schedule_id AND meaa.activity_association_id = P_ACTIVITY_ASSOCIATION_ID; --bug 10381070
586: BEGIN
587: -- Standard Start of API savepoint

Line 605: UPDATE MTL_EAM_ASSET_ACTIVITIES

601: x_return_status := fnd_api.g_ret_sts_success;
602:
603: -- API body
604:
605: UPDATE MTL_EAM_ASSET_ACTIVITIES
606: SET
607: -- INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
608: -- SERIAL_NUMBER = P_SERIAL_NUMBER,
609: START_DATE_ACTIVE = P_START_DATE_ACTIVE,