APPS.EAM_PMDEF_PUB dependencies on EAM_PM_SCHEDULING_RULES

Line 76: from eam_pm_scheduling_rules

72: EFFECTIVE_DATE_FROM,
73: EFFECTIVE_DATE_TO,
74: LIST_DATE,
75: LIST_DATE_DESC
76: from eam_pm_scheduling_rules
77: where pm_schedule_id = p_pm_schedule_id;
78:
79: cursor pm_activities_csr IS
80: select

Line 417: insert into eam_pm_scheduling_rules

413: and cca.source_object_id= l_maintenance_object_id ;
414:
415: end if;
416:
417: insert into eam_pm_scheduling_rules
418: ( PM_SCHEDULE_ID,
419: RULE_TYPE,
420: DAY_INTERVAL,
421: METER_ID ,

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 1030: insert into eam_pm_scheduling_rules

1026:
1027: i:=1;
1028: while (p_pm_day_interval_rules_tbl.exists(i)) loop
1029:
1030: insert into eam_pm_scheduling_rules
1031: (RULE_ID,
1032: PM_SCHEDULE_ID,
1033: RULE_TYPE,
1034: DAY_INTERVAL,

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 1075: insert into eam_pm_scheduling_rules

1071:
1072: i:=1;
1073: while (p_pm_runtime_rules_tbl.exists(i)) loop
1074:
1075: insert into eam_pm_scheduling_rules
1076: ( RULE_ID,
1077: PM_SCHEDULE_ID,
1078: RULE_TYPE,
1079: DAY_INTERVAL,

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 1138: insert into eam_pm_scheduling_rules

1134:
1135: i:=1;
1136: while (p_pm_list_date_rules_tbl.exists(i)) loop
1137:
1138: insert into eam_pm_scheduling_rules
1139: ( RULE_ID,
1140: PM_SCHEDULE_ID,
1141: RULE_TYPE,
1142: DAY_INTERVAL,

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 1465: delete from eam_pm_scheduling_rules

1461: RAISE FND_API.G_EXC_ERROR;
1462: end if;
1463: /*bug 9744000 end*/
1464:
1465: delete from eam_pm_scheduling_rules
1466: where pm_schedule_id=l_pm_schedule_id;
1467:
1468: for i in 1..3 loop
1469: if (i=1) then

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 1481: insert into eam_pm_scheduling_rules

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,
1484: RULE_TYPE,
1485: DAY_INTERVAL,

Line 3304: from eam_pm_scheduling_rules

3300: cursor c_pm_runtime_rule is
3301: select pm_schedule_id,
3302: meter_id,
3303: rule_id
3304: from eam_pm_scheduling_rules
3305: where pm_schedule_id = l_pm_schedule_id
3306: and rule_type = 2;
3307:
3308: BEGIN

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