APPS.EAM_METERS_UTIL dependencies on EAM_PM_LAST_SERVICE

Line 339: select count(*) into x_count from eam_pm_last_service

335: BEGIN
336: -- populate the previous service reading field with the old last service reading value
337: /* Following select and if condition are
338: Added for bug no : 2756121 */
339: select count(*) into x_count from eam_pm_last_service
340: where
341: meter_id = p_meter_id and
342: activity_association_id = p_activity_assoc_id;
343:

Line 345: insert into eam_pm_last_service(

341: meter_id = p_meter_id and
342: activity_association_id = p_activity_assoc_id;
343:
344: if(x_count = 0) then
345: insert into eam_pm_last_service(
346: meter_id,
347: activity_association_id,
348: last_service_reading,
349: wip_entity_id,

Line 367: update eam_pm_last_service

363: g_last_updated_by,
364: SYSDATE
365: );
366: else
367: update eam_pm_last_service
368: set prev_service_reading = last_service_reading
369: where meter_id = p_meter_id
370: and activity_association_id = p_activity_assoc_id;
371:

Line 372: update eam_pm_last_service

368: set prev_service_reading = last_service_reading
369: where meter_id = p_meter_id
370: and activity_association_id = p_activity_assoc_id;
371:
372: update eam_pm_last_service
373: set last_service_reading = p_meter_reading,
374: wip_entity_id = p_wip_entity_id
375: where meter_id = p_meter_id
376: and activity_association_id = p_activity_assoc_id;