eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

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

Line 449: eam_pm_scheduling_rules_s.nextval);

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:

Line 1008: insert into eam_pm_scheduling_rules

1004:
1005: i:=1;
1006: while (p_pm_day_interval_rules_tbl.exists(i)) loop
1007:
1008: insert into eam_pm_scheduling_rules
1009: (RULE_ID,
1010: PM_SCHEDULE_ID,
1011: RULE_TYPE,
1012: DAY_INTERVAL,

Line 1028: (eam_pm_scheduling_rules_s.nextval,

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 ,

Line 1053: insert into eam_pm_scheduling_rules

1049:
1050: i:=1;
1051: while (p_pm_runtime_rules_tbl.exists(i)) loop
1052:
1053: insert into eam_pm_scheduling_rules
1054: ( RULE_ID,
1055: PM_SCHEDULE_ID,
1056: RULE_TYPE,
1057: DAY_INTERVAL,

Line 1073: (eam_pm_scheduling_rules_s.nextval,

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 ,

Line 1097: insert into eam_pm_scheduling_rules

1093:
1094: i:=1;
1095: while (p_pm_list_date_rules_tbl.exists(i)) loop
1096:
1097: insert into eam_pm_scheduling_rules
1098: ( RULE_ID,
1099: PM_SCHEDULE_ID,
1100: RULE_TYPE,
1101: DAY_INTERVAL,

Line 1117: (eam_pm_scheduling_rules_s.nextval,

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 ,

Line 1399: delete from eam_pm_scheduling_rules

1395: n:=n+1;
1396:
1397: end loop;
1398:
1399: delete from eam_pm_scheduling_rules
1400: where pm_schedule_id=l_pm_schedule_id;
1401:
1402: for i in 1..3 loop
1403: if (i=1) then

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

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,

Line 1415: insert into eam_pm_scheduling_rules

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,
1418: RULE_TYPE,
1419: DAY_INTERVAL,

Line 3200: from eam_pm_scheduling_rules

3196: cursor c_pm_runtime_rule is
3197: select pm_schedule_id,
3198: meter_id,
3199: rule_id
3200: from eam_pm_scheduling_rules
3201: where pm_schedule_id = l_pm_schedule_id
3202: and rule_type = 2;
3203:
3204: BEGIN

Line 3242: update eam_pm_scheduling_rules set last_service_reading = lsr,

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,