APPS.EAM_METERS_UTIL dependencies on EAM_PM_SCHEDULINGS

Line 512: eam_pm_schedulings where pm_schedule_id =l_pm_schedule_id;

508: if ( l_pm_schedule_id is not null) then
509:
510: --5151820 added to get pm cycle and seq
511: select current_cycle,current_seq into l_pm_cycle_id,l_pm_seq_id from
512: eam_pm_schedulings where pm_schedule_id =l_pm_schedule_id;
513:
514: --Commenting the below code for bug 13414054.This logic does not work if intervals per cycle is greater than 9
515: /* -- 5151820 update pm only when pm cycle and seq are less than or equal to that of work order
516: --concatenating both the attributes and comparing below

Line 523: UPDATE EAM_PM_SCHEDULINGS

519: if l_pm_seq < l_wo_seq then*/
520:
521: --Added for bug 13414054
522: if (l_pm_cycle_id < l_cycle_id ) or (l_pm_cycle_id = l_cycle_id and l_pm_seq_id <= l_seq_id)then
523: UPDATE EAM_PM_SCHEDULINGS
524: SET current_cycle = l_cycle_id,
525: current_seq = l_seq_id ,
526: current_wo_seq = l_seq_id,
527: last_update_date=sysdate,

Line 631: UPDATE EAM_PM_SCHEDULINGS

627: ewod.wip_entity_id = wdj.wip_entity_id ;
628:
629: if(l_pm_schedule_id is not null) then
630:
631: UPDATE EAM_PM_SCHEDULINGS
632: SET current_cycle = l_cycle_id,
633: current_seq = l_seq_id ,
634: current_wo_seq = l_seq_id,
635: last_update_date=sysdate,

Line 721: from eam_pm_schedulings

717: where sup.parent_association_id = p_activity_assoc_id;
718:
719: cursor pm_schedule(activity_assoc_id NUMBER,l_default VARCHAR2) is
720: select rescheduling_point
721: from eam_pm_schedulings
722: where pm_schedule_id in (SELECT pm_schedule_id
723: FROM eam_pm_activities where activity_association_id=activity_assoc_id)
724: and default_implement=l_default;
725:

Line 922: eam_pm_schedulings eps,

918: p_meter_id in number) return boolean is
919: cursor C is
920: select epac.activity_association_id
921: from eam_pm_activities epac,
922: eam_pm_schedulings eps,
923: eam_suppression_relations sup
924: where sup.parent_association_id = p_activity_assoc_id
925: and sup.child_association_id = epac.activity_association_id
926: and eps.pm_schedule_id = epac.pm_schedule_id

Line 977: eam_pm_schedulings eps,

973: return boolean is
974: cursor C is
975: select epac.pm_schedule_id
976: from eam_pm_activities epac,
977: eam_pm_schedulings eps,
978: eam_pm_activities epap,
979: eam_suppression_relations sup
980: where epap.activity_association_id = sup.parent_association_id
981: and epap.pm_schedule_id = p_parent_pm_id