[Home] [Help]
445: a_pm_rule.EFFECTIVE_DATE_FROM ,
446: a_pm_rule.EFFECTIVE_DATE_TO ,
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:
1024: LIST_DATE ,
1025: LIST_DATE_DESC
1026: )
1027: values
1028: (eam_pm_scheduling_rules_s.nextval,
1029: l_pm_schedule_id,
1030: p_pm_day_interval_rules_tbl(i).RULE_TYPE,
1031: p_pm_day_interval_rules_tbl(i).DAY_INTERVAL,
1032: p_pm_day_interval_rules_tbl(i).METER_ID ,
1069: LIST_DATE ,
1070: LIST_DATE_DESC
1071: )
1072: values
1073: (eam_pm_scheduling_rules_s.nextval,
1074: l_pm_schedule_id,
1075: p_pm_runtime_rules_tbl(i).RULE_TYPE,
1076: p_pm_runtime_rules_tbl(i).DAY_INTERVAL,
1077: p_pm_runtime_rules_tbl(i).METER_ID ,
1113: LIST_DATE ,
1114: LIST_DATE_DESC
1115: )
1116: values
1117: (eam_pm_scheduling_rules_s.nextval,
1118: l_pm_schedule_id,
1119: p_pm_list_date_rules_tbl(i).RULE_TYPE,
1120: p_pm_list_date_rules_tbl(i).DAY_INTERVAL,
1121: p_pm_list_date_rules_tbl(i).METER_ID ,
1409: end if;
1410: n:=1;
1411: while (l_current_rules_tbl.exists(n)) loop
1412:
1413: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536
1414:
1415: insert into eam_pm_scheduling_rules
1416: ( rule_id,
1417: PM_SCHEDULE_ID,
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,
3244: last_updated_by=fnd_global.user_id,
3245: creation_date=sysdate,
3246: last_update_login=fnd_global.login_id,