318: /* added for PM Reviewer -- start-- */
319: pm_header_row.LAST_REVIEWED_DATE ,
320: pm_header_row.Last_reviewed_by ,
321: /* ---PM reviewer--- end---- */
322: fnd_global.user_id,
323: sysdate,
324: fnd_global.login_id,
325: fnd_global.user_id,
326: sysdate ,
320: pm_header_row.Last_reviewed_by ,
321: /* ---PM reviewer--- end---- */
322: fnd_global.user_id,
323: sysdate,
324: fnd_global.login_id,
325: fnd_global.user_id,
326: sysdate ,
327: pm_header_row.generate_next_work_order );
328:
321: /* ---PM reviewer--- end---- */
322: fnd_global.user_id,
323: sysdate,
324: fnd_global.login_id,
325: fnd_global.user_id,
326: sysdate ,
327: pm_header_row.generate_next_work_order );
328:
329: --now start copying the activities.
361: a_pm_activity.activity_association_id,
362: a_pm_activity.interval_multiple,
363: a_pm_activity.allow_repeat_in_cycle,
364: a_pm_activity.day_tolerance,
365: fnd_global.user_id,
366: sysdate,
367: fnd_global.login_id,
368: fnd_global.user_id,
369: sysdate );
363: a_pm_activity.allow_repeat_in_cycle,
364: a_pm_activity.day_tolerance,
365: fnd_global.user_id,
366: sysdate,
367: fnd_global.login_id,
368: fnd_global.user_id,
369: sysdate );
370:
371: end if;
364: a_pm_activity.day_tolerance,
365: fnd_global.user_id,
366: sysdate,
367: fnd_global.login_id,
368: fnd_global.user_id,
369: sysdate );
370:
371: end if;
372:
434: a_pm_rule.RULE_TYPE,
435: a_pm_rule.DAY_INTERVAL,
436: l_meter_id,
437: a_pm_rule.RUNTIME_INTERVAL,
438: fnd_global.user_id,
439: sysdate,
440: fnd_global.login_id,
441: sysdate ,
442: fnd_global.user_id,
436: l_meter_id,
437: a_pm_rule.RUNTIME_INTERVAL,
438: fnd_global.user_id,
439: sysdate,
440: fnd_global.login_id,
441: sysdate ,
442: fnd_global.user_id,
443: a_pm_rule.EFFECTIVE_READING_FROM ,
444: a_pm_rule.EFFECTIVE_READING_TO ,
438: fnd_global.user_id,
439: sysdate,
440: fnd_global.login_id,
441: sysdate ,
442: fnd_global.user_id,
443: a_pm_rule.EFFECTIVE_READING_FROM ,
444: a_pm_rule.EFFECTIVE_READING_TO ,
445: a_pm_rule.EFFECTIVE_DATE_FROM ,
446: a_pm_rule.EFFECTIVE_DATE_TO ,
487: l_initial_reading,
488: null,
489: null,
490: sysdate,
491: fnd_global.user_id,
492: sysdate,
493: fnd_global.user_id,
494: fnd_global.login_id
495: );
489: null,
490: sysdate,
491: fnd_global.user_id,
492: sysdate,
493: fnd_global.user_id,
494: fnd_global.login_id
495: );
496: end if;
497: end if;
490: sysdate,
491: fnd_global.user_id,
492: sysdate,
493: fnd_global.user_id,
494: fnd_global.login_id
495: );
496: end if;
497: end if;
498:
950: p_pm_schedule_rec.SOURCE_TMPL_ID ,
951: p_pm_schedule_rec.AUTO_INSTANTIATION_FLAG,
952: p_pm_schedule_rec.NAME ,
953: p_pm_schedule_rec.TMPL_FLAG ,
954: fnd_global.user_id,
955: sysdate,
956: fnd_global.login_id,
957: fnd_global.user_id,
958: sysdate,
952: p_pm_schedule_rec.NAME ,
953: p_pm_schedule_rec.TMPL_FLAG ,
954: fnd_global.user_id,
955: sysdate,
956: fnd_global.login_id,
957: fnd_global.user_id,
958: sysdate,
959: p_pm_schedule_rec.GENERATE_WO_STATUS ,
960: p_pm_schedule_rec.INTERVAL_PER_CYCLE ,
953: p_pm_schedule_rec.TMPL_FLAG ,
954: fnd_global.user_id,
955: sysdate,
956: fnd_global.login_id,
957: fnd_global.user_id,
958: sysdate,
959: p_pm_schedule_rec.GENERATE_WO_STATUS ,
960: p_pm_schedule_rec.INTERVAL_PER_CYCLE ,
961: p_pm_schedule_rec.CURRENT_CYCLE ,
991: p_pm_activities_tbl(i).activity_association_id,
992: p_pm_activities_tbl(i).interval_multiple,
993: p_pm_activities_tbl(i).allow_repeat_in_cycle,
994: p_pm_activities_tbl(i).day_tolerance,
995: fnd_global.user_id,
996: sysdate,
997: fnd_global.login_id,
998: sysdate ,
999: fnd_global.user_id
993: p_pm_activities_tbl(i).allow_repeat_in_cycle,
994: p_pm_activities_tbl(i).day_tolerance,
995: fnd_global.user_id,
996: sysdate,
997: fnd_global.login_id,
998: sysdate ,
999: fnd_global.user_id
1000: );
1001: i:=i+1;
995: fnd_global.user_id,
996: sysdate,
997: fnd_global.login_id,
998: sysdate ,
999: fnd_global.user_id
1000: );
1001: i:=i+1;
1002: end loop;
1003:
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 ,
1033: p_pm_day_interval_rules_tbl(i).RUNTIME_INTERVAL,
1034: fnd_global.user_id,
1035: sysdate,
1036: fnd_global.login_id,
1037: sysdate ,
1038: fnd_global.user_id,
1032: p_pm_day_interval_rules_tbl(i).METER_ID ,
1033: p_pm_day_interval_rules_tbl(i).RUNTIME_INTERVAL,
1034: fnd_global.user_id,
1035: sysdate,
1036: fnd_global.login_id,
1037: sysdate ,
1038: fnd_global.user_id,
1039: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_FROM ,
1040: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_TO ,
1034: fnd_global.user_id,
1035: sysdate,
1036: fnd_global.login_id,
1037: sysdate ,
1038: fnd_global.user_id,
1039: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_FROM ,
1040: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_TO ,
1041: p_pm_day_interval_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1042: p_pm_day_interval_rules_tbl(i).EFFECTIVE_DATE_TO ,
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 ,
1078: p_pm_runtime_rules_tbl(i).RUNTIME_INTERVAL,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id,
1082: sysdate ,
1083: fnd_global.user_id,
1077: p_pm_runtime_rules_tbl(i).METER_ID ,
1078: p_pm_runtime_rules_tbl(i).RUNTIME_INTERVAL,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id,
1082: sysdate ,
1083: fnd_global.user_id,
1084: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_FROM ,
1085: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_TO ,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id,
1082: sysdate ,
1083: fnd_global.user_id,
1084: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_FROM ,
1085: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_TO ,
1086: p_pm_runtime_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1087: p_pm_runtime_rules_tbl(i).EFFECTIVE_DATE_TO ,
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 ,
1122: p_pm_list_date_rules_tbl(i).RUNTIME_INTERVAL,
1123: fnd_global.user_id,
1124: sysdate,
1125: fnd_global.login_id,
1126: sysdate ,
1127: fnd_global.user_id,
1121: p_pm_list_date_rules_tbl(i).METER_ID ,
1122: p_pm_list_date_rules_tbl(i).RUNTIME_INTERVAL,
1123: fnd_global.user_id,
1124: sysdate,
1125: fnd_global.login_id,
1126: sysdate ,
1127: fnd_global.user_id,
1128: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_FROM ,
1129: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_TO ,
1123: fnd_global.user_id,
1124: sysdate,
1125: fnd_global.login_id,
1126: sysdate ,
1127: fnd_global.user_id,
1128: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_FROM ,
1129: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_TO ,
1130: p_pm_list_date_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1131: p_pm_list_date_rules_tbl(i).EFFECTIVE_DATE_TO ,
1353: NAME =p_pm_schedule_rec.NAME,
1354: TMPL_FLAG =p_pm_schedule_rec.TMPL_FLAG,
1355: LAST_REVIEWED_BY = p_pm_schedule_rec.LAST_REVIEWED_BY,
1356: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1357: CREATED_BY=fnd_global.user_id,
1358: CREATION_DATE=sysdate,
1359: LAST_UPDATE_LOGIN=fnd_global.login_id,
1360: LAST_UPDATED_BY=fnd_global.user_id,
1361: LAST_UPDATE_DATE=sysdate ,
1355: LAST_REVIEWED_BY = p_pm_schedule_rec.LAST_REVIEWED_BY,
1356: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1357: CREATED_BY=fnd_global.user_id,
1358: CREATION_DATE=sysdate,
1359: LAST_UPDATE_LOGIN=fnd_global.login_id,
1360: LAST_UPDATED_BY=fnd_global.user_id,
1361: LAST_UPDATE_DATE=sysdate ,
1362: generate_next_work_order =p_pm_schedule_rec.generate_next_work_order
1363: where PM_SCHEDULE_ID=l_pm_schedule_id;
1356: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1357: CREATED_BY=fnd_global.user_id,
1358: CREATION_DATE=sysdate,
1359: LAST_UPDATE_LOGIN=fnd_global.login_id,
1360: LAST_UPDATED_BY=fnd_global.user_id,
1361: LAST_UPDATE_DATE=sysdate ,
1362: generate_next_work_order =p_pm_schedule_rec.generate_next_work_order
1363: where PM_SCHEDULE_ID=l_pm_schedule_id;
1364:
1385: p_pm_activities_tbl(i).activity_association_id,
1386: p_pm_activities_tbl(i).interval_multiple,
1387: p_pm_activities_tbl(i).allow_repeat_in_cycle,
1388: p_pm_activities_tbl(i).day_tolerance,
1389: fnd_global.user_id,
1390: sysdate,
1391: fnd_global.login_id,
1392: sysdate ,
1393: fnd_global.user_id
1387: p_pm_activities_tbl(i).allow_repeat_in_cycle,
1388: p_pm_activities_tbl(i).day_tolerance,
1389: fnd_global.user_id,
1390: sysdate,
1391: fnd_global.login_id,
1392: sysdate ,
1393: fnd_global.user_id
1394: );
1395: n:=n+1;
1389: fnd_global.user_id,
1390: sysdate,
1391: fnd_global.login_id,
1392: sysdate ,
1393: fnd_global.user_id
1394: );
1395: n:=n+1;
1396:
1397: end loop;
1437: l_current_rules_tbl(n).RULE_TYPE,
1438: l_current_rules_tbl(n).DAY_INTERVAL,
1439: l_current_rules_tbl(n).METER_ID ,
1440: l_current_rules_tbl(n).RUNTIME_INTERVAL,
1441: fnd_global.user_id,
1442: sysdate,
1443: fnd_global.login_id,
1444: sysdate ,
1445: fnd_global.user_id,
1439: l_current_rules_tbl(n).METER_ID ,
1440: l_current_rules_tbl(n).RUNTIME_INTERVAL,
1441: fnd_global.user_id,
1442: sysdate,
1443: fnd_global.login_id,
1444: sysdate ,
1445: fnd_global.user_id,
1446: l_current_rules_tbl(n).EFFECTIVE_READING_FROM ,
1447: l_current_rules_tbl(n).EFFECTIVE_READING_TO ,
1441: fnd_global.user_id,
1442: sysdate,
1443: fnd_global.login_id,
1444: sysdate ,
1445: fnd_global.user_id,
1446: l_current_rules_tbl(n).EFFECTIVE_READING_FROM ,
1447: l_current_rules_tbl(n).EFFECTIVE_READING_TO ,
1448: l_current_rules_tbl(n).EFFECTIVE_DATE_FROM ,
1449: l_current_rules_tbl(n).EFFECTIVE_DATE_TO ,
2433:
2434: UPDATE mtl_eam_asset_activities
2435: SET last_service_start_date = l_last_service_start_date,
2436: last_service_end_date = l_last_service_end_date,
2437: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,
2438: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id
2439: WHERE activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2440:
2441:
2434: UPDATE mtl_eam_asset_activities
2435: SET last_service_start_date = l_last_service_start_date,
2436: last_service_end_date = l_last_service_end_date,
2437: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,
2438: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id
2439: WHERE activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2440:
2441:
2442: end if;
2484: UPDATE mtl_eam_asset_activities meaa
2485: SET meaa.last_scheduled_start_date = l_last_scheduled_start_date,
2486: meaa.last_scheduled_end_date = l_last_scheduled_end_date,
2487: meaa.wip_entity_id=l_wip_entity_id,
2488: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,
2489: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id
2490: WHERE (meaa.last_scheduled_start_date is null OR
2491: meaa.last_scheduled_end_date is null) AND
2492: meaa.activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2485: SET meaa.last_scheduled_start_date = l_last_scheduled_start_date,
2486: meaa.last_scheduled_end_date = l_last_scheduled_end_date,
2487: meaa.wip_entity_id=l_wip_entity_id,
2488: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,
2489: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id
2490: WHERE (meaa.last_scheduled_start_date is null OR
2491: meaa.last_scheduled_end_date is null) AND
2492: meaa.activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2493:
2513: VALUES (p_pm_activity_grp_rec.activity_association_id,
2514: p_pm_runtime_rules_tbl(i).meter_id,
2515: nvl(p_pm_runtime_rules_tbl(i).last_service_reading, 0),
2516: sysdate,
2517: fnd_global.user_id,
2518: sysdate,
2519: fnd_global.login_id,
2520: fnd_global.user_id);
2521:
2515: nvl(p_pm_runtime_rules_tbl(i).last_service_reading, 0),
2516: sysdate,
2517: fnd_global.user_id,
2518: sysdate,
2519: fnd_global.login_id,
2520: fnd_global.user_id);
2521:
2522: l_lsi_updated := 'Y';
2523: x_activities :=l_act_name;
2516: sysdate,
2517: fnd_global.user_id,
2518: sysdate,
2519: fnd_global.login_id,
2520: fnd_global.user_id);
2521:
2522: l_lsi_updated := 'Y';
2523: x_activities :=l_act_name;
2524: end if;
3113: -- updating the eam_last_cyclic_act field
3114:
3115: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3116: last_update_date=sysdate,
3117: last_updated_by=fnd_global.user_id,
3118: creation_date=sysdate,
3119: last_update_login=fnd_global.login_id,
3120: created_by = fnd_global.user_id where
3121: pm_schedule_id = p_pm_schedule_id;
3115: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3116: last_update_date=sysdate,
3117: last_updated_by=fnd_global.user_id,
3118: creation_date=sysdate,
3119: last_update_login=fnd_global.login_id,
3120: created_by = fnd_global.user_id where
3121: pm_schedule_id = p_pm_schedule_id;
3122:
3123: --standard commit to be checked
3116: last_update_date=sysdate,
3117: last_updated_by=fnd_global.user_id,
3118: creation_date=sysdate,
3119: last_update_login=fnd_global.login_id,
3120: created_by = fnd_global.user_id where
3121: pm_schedule_id = p_pm_schedule_id;
3122:
3123: --standard commit to be checked
3124:
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,
3247: created_by = fnd_global.user_id
3248: where pm_schedule_id=runtime_rec.pm_schedule_id and
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,
3247: created_by = fnd_global.user_id
3248: where pm_schedule_id=runtime_rec.pm_schedule_id and
3249: meter_id = runtime_rec.meter_id and
3250: rule_id = runtime_rec.rule_id;
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,
3247: created_by = fnd_global.user_id
3248: where pm_schedule_id=runtime_rec.pm_schedule_id and
3249: meter_id = runtime_rec.meter_id and
3250: rule_id = runtime_rec.rule_id;
3251: