APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 325: p_desc_flex_name => 'MTL_EAM_ASSET_ACTIVITIES',

321: -- validate the desc. flex fields
322: if not EAM_COMMON_UTILITIES_PVT.validate_desc_flex_field
323: (
324: p_app_short_name => 'INV',
325: p_desc_flex_name => 'MTL_EAM_ASSET_ACTIVITIES',
326: p_ATTRIBUTE_CATEGORY => p_ATTRIBUTE_CATEGORY,
327: p_ATTRIBUTE1 => p_ATTRIBUTE1,
328: p_ATTRIBUTE2 => p_ATTRIBUTE2,
329: p_ATTRIBUTE3 => p_ATTRIBUTE3,

Line 368: FROM mtl_eam_asset_activities

364: BEGIN
365:
366:
367: SELECT activity_association_id INTO x_act_assoc_id
368: FROM mtl_eam_asset_activities
369: WHERE maintenance_object_id = p_maintenance_object_id
370: AND asset_activity_id = P_asset_activity_id
371: AND maintenance_object_type = p_maintenance_object_type
372: AND NVL(tmpl_flag, 'N') = NVL(p_tmpl_flag, 'N');

Line 379: fnd_message.set_token('TABLE_NAME', 'MTL_EAM_ASSET_ACTIVITIES');

375: WHEN NO_DATA_FOUND THEN
376: x_act_assoc_id := -1;
377: WHEN TOO_MANY_ROWS THEN
378: fnd_message.set_name('EAM', 'EAM_DATA_CORRUPT');
379: fnd_message.set_token('TABLE_NAME', 'MTL_EAM_ASSET_ACTIVITIES');
380: fnd_msg_pub.add;
381: RAISE fnd_api.g_exc_error;
382: END;
383:

Line 761: from mtl_eam_asset_activities

757: IF (p_source_tmpl_id is NOT NULL) THEN
758:
759: l_item_id := 0;
760: select count(*) into l_item_id
761: from mtl_eam_asset_activities
762: where activity_association_id = p_source_tmpl_id
763: and asset_activity_id = p_asset_activity_id
764: and inventory_item_id = l_asset_group_id
765: and tmpl_flag = 'Y';

Line 775: select MTL_EAM_ASSET_ACTIVITIES_S.NEXTVAL into l_actv_assoc_id from dual;

771: END IF;
772:
773: IF (l_actv_assoc_id = -1) THEN
774:
775: select MTL_EAM_ASSET_ACTIVITIES_S.NEXTVAL into l_actv_assoc_id from dual;
776: INSERT INTO mtl_eam_asset_activities
777: (
778: ACTIVITY_ASSOCIATION_ID ,
779: ASSET_ACTIVITY_ID ,

Line 776: INSERT INTO mtl_eam_asset_activities

772:
773: IF (l_actv_assoc_id = -1) THEN
774:
775: select MTL_EAM_ASSET_ACTIVITIES_S.NEXTVAL into l_actv_assoc_id from dual;
776: INSERT INTO mtl_eam_asset_activities
777: (
778: ACTIVITY_ASSOCIATION_ID ,
779: ASSET_ACTIVITY_ID ,
780: MAINTENANCE_OBJECT_ID ,

Line 1115: from mtl_eam_asset_activities

1111:
1112: -- Bug # 3441956
1113: BEGIN
1114: select count(*) into l_cnt
1115: from mtl_eam_asset_activities
1116: where asset_activity_id = p_asset_activity_id
1117: and activity_association_id = p_activity_association_id;
1118:
1119: IF (l_cnt = 0) THEN

Line 1343: UPDATE mtl_eam_asset_activities

1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341:
1342:
1343: UPDATE mtl_eam_asset_activities
1344: SET
1345: START_DATE_ACTIVE = P_START_DATE_ACTIVE ,
1346: END_DATE_ACTIVE = P_END_DATE_ACTIVE ,
1347: PRIORITY_CODE = P_PRIORITY_CODE ,