APPS.EAM_PMDEF_PUB dependencies on EAM_PM_LAST_SERVICE

Line 451: -- if it's a runtime rule, insert meter initial reading into eam_pm_last_services table

447: a_pm_rule.LIST_DATE ,
448: a_pm_rule.LIST_DATE_DESC ,
449: eam_pm_scheduling_rules_s.nextval);
450:
451: -- if it's a runtime rule, insert meter initial reading into eam_pm_last_services table
452: if a_pm_rule.meter_id is not null then
453:
454: --added for performance issues
455: select initial_reading into l_initial_reading from

Line 466: from eam_pm_last_service

462:
463: -- for bug 7230256
464: l_count := 0;
465: select count (*) into l_count
466: from eam_pm_last_service
467: where meter_id=l_meter_id and ACTIVITY_ASSOCIATION_ID =l_last_act;
468:
469: if l_count = 0 then
470:

Line 471: insert into eam_pm_last_service

467: where meter_id=l_meter_id and ACTIVITY_ASSOCIATION_ID =l_last_act;
468:
469: if l_count = 0 then
470:
471: insert into eam_pm_last_service
472: ( METER_ID ,
473: ACTIVITY_ASSOCIATION_ID ,
474: LAST_SERVICE_READING ,
475: PREV_SERVICE_READING ,

Line 2504: from eam_pm_last_service

2500: if (p_pm_schedule_rec.tmpl_flag='N') then
2501: while (p_pm_runtime_rules_tbl.exists(i)) loop
2502:
2503: select count(*) into l_count
2504: from eam_pm_last_service
2505: where meter_id=p_pm_runtime_rules_tbl(i).meter_id
2506: and activity_association_id=p_pm_activity_grp_rec.activity_association_id;
2507:
2508: if (l_count = 0) then

Line 2510: INSERT INTO eam_pm_last_service (activity_association_id, meter_id,

2506: and activity_association_id=p_pm_activity_grp_rec.activity_association_id;
2507:
2508: if (l_count = 0) then
2509:
2510: INSERT INTO eam_pm_last_service (activity_association_id, meter_id,
2511: last_service_reading, last_update_date, last_updated_by, creation_date,
2512: last_update_login, created_by)
2513: VALUES (p_pm_activity_grp_rec.activity_association_id,
2514: p_pm_runtime_rules_tbl(i).meter_id,

Line 2609: x_message := 'EAM_PM_LAST_SERVICE_DEFAULT';

2605:
2606: end if;
2607:
2608: if l_lsi_updated = 'Y' then
2609: x_message := 'EAM_PM_LAST_SERVICE_DEFAULT';
2610: end if;
2611:
2612: return true;
2613:

Line 3239: from eam_pm_last_service

3235:
3236: for runtime_rec in c_pm_runtime_rule loop
3237:
3238: select last_service_reading into lsr
3239: from eam_pm_last_service
3240: where meter_id = runtime_rec.meter_id and activity_association_id = l_act_assoc_id;
3241:
3242: update eam_pm_scheduling_rules set last_service_reading = lsr,
3243: last_update_date=sysdate,