APPS.EAM_METERS_UTIL dependencies on EAM_PM_SCHEDULINGS

Line 511: eam_pm_schedulings where pm_schedule_id =l_pm_schedule_id;

507: if ( l_pm_schedule_id is not null) then
508:
509: --5151820 added to get pm cycle and seq
510: select current_cycle,current_seq into l_pm_cycle_id,l_pm_seq_id from
511: eam_pm_schedulings where pm_schedule_id =l_pm_schedule_id;
512:
513: -- 5151820 update pm only when pm cycle and seq are less than or equal to that of work order
514: --concatenating both the attributes and comparing below
515: l_pm_seq := to_number(to_char(l_pm_cycle_id) || to_char(l_pm_seq_id));

Line 520: UPDATE EAM_PM_SCHEDULINGS

516: l_wo_seq := to_number(to_char(l_cycle_id) || to_char(l_seq_id));
517:
518: if l_pm_seq < l_wo_seq then
519:
520: UPDATE EAM_PM_SCHEDULINGS
521: SET current_cycle = l_cycle_id,
522: current_seq = l_seq_id ,
523: current_wo_seq = l_seq_id,
524: last_update_date=sysdate,

Line 628: UPDATE EAM_PM_SCHEDULINGS

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

Line 718: from eam_pm_schedulings

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

Line 918: eam_pm_schedulings eps,

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

Line 973: eam_pm_schedulings eps,

969: return boolean is
970: cursor C is
971: select epac.pm_schedule_id
972: from eam_pm_activities epac,
973: eam_pm_schedulings eps,
974: eam_pm_activities epap,
975: eam_suppression_relations sup
976: where epap.activity_association_id = sup.parent_association_id
977: and epap.pm_schedule_id = p_parent_pm_id