APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SCHEDULING_RULES_S

Line 452: eam_pm_scheduling_rules_s.nextval);

448: a_pm_rule.EFFECTIVE_DATE_FROM ,
449: a_pm_rule.EFFECTIVE_DATE_TO ,
450: a_pm_rule.LIST_DATE ,
451: a_pm_rule.LIST_DATE_DESC ,
452: eam_pm_scheduling_rules_s.nextval);
453:
454: -- if it's a runtime rule, insert meter initial reading into eam_pm_last_services table
455: if a_pm_rule.meter_id is not null then
456:

Line 1050: (eam_pm_scheduling_rules_s.nextval,

1046: LIST_DATE ,
1047: LIST_DATE_DESC
1048: )
1049: values
1050: (eam_pm_scheduling_rules_s.nextval,
1051: l_pm_schedule_id,
1052: p_pm_day_interval_rules_tbl(i).RULE_TYPE,
1053: p_pm_day_interval_rules_tbl(i).DAY_INTERVAL,
1054: p_pm_day_interval_rules_tbl(i).METER_ID ,

Line 1095: (eam_pm_scheduling_rules_s.nextval,

1091: LIST_DATE ,
1092: LIST_DATE_DESC
1093: )
1094: values
1095: (eam_pm_scheduling_rules_s.nextval,
1096: l_pm_schedule_id,
1097: p_pm_runtime_rules_tbl(i).RULE_TYPE,
1098: p_pm_runtime_rules_tbl(i).DAY_INTERVAL,
1099: p_pm_runtime_rules_tbl(i).METER_ID ,

Line 1158: (eam_pm_scheduling_rules_s.nextval,

1154: LIST_DATE ,
1155: LIST_DATE_DESC
1156: )
1157: values
1158: (eam_pm_scheduling_rules_s.nextval,
1159: l_pm_schedule_id,
1160: p_pm_list_date_rules_tbl(i).RULE_TYPE,
1161: p_pm_list_date_rules_tbl(i).DAY_INTERVAL,
1162: p_pm_list_date_rules_tbl(i).METER_ID ,

Line 1479: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536

1475: end if;
1476: n:=1;
1477: while (l_current_rules_tbl.exists(n)) loop
1478:
1479: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536
1480:
1481: insert into eam_pm_scheduling_rules
1482: ( rule_id,
1483: PM_SCHEDULE_ID,

Line 3346: update eam_pm_scheduling_rules set last_service_reading = lsr,

3342: select last_service_reading into lsr
3343: from eam_pm_last_service
3344: where meter_id = runtime_rec.meter_id and activity_association_id = l_act_assoc_id;
3345:
3346: update eam_pm_scheduling_rules set last_service_reading = lsr,
3347: last_update_date=sysdate,
3348: last_updated_by=fnd_global.user_id,
3349: last_update_login=fnd_global.login_id
3350: where pm_schedule_id=runtime_rec.pm_schedule_id and