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 FND_GLOBAL

Line 324: fnd_global.user_id,

320: /* added for PM Reviewer -- start-- */
321: pm_header_row.LAST_REVIEWED_DATE ,
322: pm_header_row.Last_reviewed_by ,
323: /* ---PM reviewer--- end---- */
324: fnd_global.user_id,
325: sysdate,
326: fnd_global.login_id,
327: fnd_global.user_id,
328: sysdate ,

Line 326: fnd_global.login_id,

322: pm_header_row.Last_reviewed_by ,
323: /* ---PM reviewer--- end---- */
324: fnd_global.user_id,
325: sysdate,
326: fnd_global.login_id,
327: fnd_global.user_id,
328: sysdate ,
329: pm_header_row.generate_next_work_order,
330: pm_header_row.planner_maintenance );

Line 327: fnd_global.user_id,

323: /* ---PM reviewer--- end---- */
324: fnd_global.user_id,
325: sysdate,
326: fnd_global.login_id,
327: fnd_global.user_id,
328: sysdate ,
329: pm_header_row.generate_next_work_order,
330: pm_header_row.planner_maintenance );
331:

Line 368: fnd_global.user_id,

364: a_pm_activity.activity_association_id,
365: a_pm_activity.interval_multiple,
366: a_pm_activity.allow_repeat_in_cycle,
367: a_pm_activity.day_tolerance,
368: fnd_global.user_id,
369: sysdate,
370: fnd_global.login_id,
371: fnd_global.user_id,
372: sysdate );

Line 370: fnd_global.login_id,

366: a_pm_activity.allow_repeat_in_cycle,
367: a_pm_activity.day_tolerance,
368: fnd_global.user_id,
369: sysdate,
370: fnd_global.login_id,
371: fnd_global.user_id,
372: sysdate );
373:
374: end if;

Line 371: fnd_global.user_id,

367: a_pm_activity.day_tolerance,
368: fnd_global.user_id,
369: sysdate,
370: fnd_global.login_id,
371: fnd_global.user_id,
372: sysdate );
373:
374: end if;
375:

Line 441: fnd_global.user_id,

437: a_pm_rule.RULE_TYPE,
438: a_pm_rule.DAY_INTERVAL,
439: l_meter_id,
440: a_pm_rule.RUNTIME_INTERVAL,
441: fnd_global.user_id,
442: sysdate,
443: fnd_global.login_id,
444: sysdate ,
445: fnd_global.user_id,

Line 443: fnd_global.login_id,

439: l_meter_id,
440: a_pm_rule.RUNTIME_INTERVAL,
441: fnd_global.user_id,
442: sysdate,
443: fnd_global.login_id,
444: sysdate ,
445: fnd_global.user_id,
446: a_pm_rule.EFFECTIVE_READING_FROM ,
447: a_pm_rule.EFFECTIVE_READING_TO ,

Line 445: fnd_global.user_id,

441: fnd_global.user_id,
442: sysdate,
443: fnd_global.login_id,
444: sysdate ,
445: fnd_global.user_id,
446: a_pm_rule.EFFECTIVE_READING_FROM ,
447: a_pm_rule.EFFECTIVE_READING_TO ,
448: a_pm_rule.EFFECTIVE_DATE_FROM ,
449: a_pm_rule.EFFECTIVE_DATE_TO ,

Line 494: fnd_global.user_id,

490: l_initial_reading,
491: null,
492: null,
493: sysdate,
494: fnd_global.user_id,
495: sysdate,
496: fnd_global.user_id,
497: fnd_global.login_id
498: );

Line 496: fnd_global.user_id,

492: null,
493: sysdate,
494: fnd_global.user_id,
495: sysdate,
496: fnd_global.user_id,
497: fnd_global.login_id
498: );
499: end if;
500: end if;

Line 497: fnd_global.login_id

493: sysdate,
494: fnd_global.user_id,
495: sysdate,
496: fnd_global.user_id,
497: fnd_global.login_id
498: );
499: end if;
500: end if;
501:

Line 958: fnd_global.user_id,

954: p_pm_schedule_rec.SOURCE_TMPL_ID ,
955: p_pm_schedule_rec.AUTO_INSTANTIATION_FLAG,
956: p_pm_schedule_rec.NAME ,
957: p_pm_schedule_rec.TMPL_FLAG ,
958: fnd_global.user_id,
959: sysdate,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: sysdate,

Line 960: fnd_global.login_id,

956: p_pm_schedule_rec.NAME ,
957: p_pm_schedule_rec.TMPL_FLAG ,
958: fnd_global.user_id,
959: sysdate,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: sysdate,
963: p_pm_schedule_rec.GENERATE_WO_STATUS ,
964: p_pm_schedule_rec.INTERVAL_PER_CYCLE ,

Line 961: fnd_global.user_id,

957: p_pm_schedule_rec.TMPL_FLAG ,
958: fnd_global.user_id,
959: sysdate,
960: fnd_global.login_id,
961: fnd_global.user_id,
962: sysdate,
963: p_pm_schedule_rec.GENERATE_WO_STATUS ,
964: p_pm_schedule_rec.INTERVAL_PER_CYCLE ,
965: p_pm_schedule_rec.CURRENT_CYCLE ,

Line 1000: fnd_global.user_id,

996: p_pm_activities_tbl(i).activity_association_id,
997: p_pm_activities_tbl(i).interval_multiple,
998: p_pm_activities_tbl(i).allow_repeat_in_cycle,
999: p_pm_activities_tbl(i).day_tolerance,
1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id,
1003: sysdate ,
1004: fnd_global.user_id

Line 1002: fnd_global.login_id,

998: p_pm_activities_tbl(i).allow_repeat_in_cycle,
999: p_pm_activities_tbl(i).day_tolerance,
1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id,
1003: sysdate ,
1004: fnd_global.user_id
1005: );
1006: i:=i+1;

Line 1004: fnd_global.user_id

1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id,
1003: sysdate ,
1004: fnd_global.user_id
1005: );
1006: i:=i+1;
1007: end loop;
1008:

Line 1056: fnd_global.user_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 ,
1055: p_pm_day_interval_rules_tbl(i).RUNTIME_INTERVAL,
1056: fnd_global.user_id,
1057: sysdate,
1058: fnd_global.login_id,
1059: sysdate ,
1060: fnd_global.user_id,

Line 1058: fnd_global.login_id,

1054: p_pm_day_interval_rules_tbl(i).METER_ID ,
1055: p_pm_day_interval_rules_tbl(i).RUNTIME_INTERVAL,
1056: fnd_global.user_id,
1057: sysdate,
1058: fnd_global.login_id,
1059: sysdate ,
1060: fnd_global.user_id,
1061: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_FROM ,
1062: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_TO ,

Line 1060: fnd_global.user_id,

1056: fnd_global.user_id,
1057: sysdate,
1058: fnd_global.login_id,
1059: sysdate ,
1060: fnd_global.user_id,
1061: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_FROM ,
1062: p_pm_day_interval_rules_tbl(i).EFFECTIVE_READING_TO ,
1063: p_pm_day_interval_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1064: p_pm_day_interval_rules_tbl(i).EFFECTIVE_DATE_TO ,

Line 1101: fnd_global.user_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 ,
1100: p_pm_runtime_rules_tbl(i).RUNTIME_INTERVAL,
1101: fnd_global.user_id,
1102: sysdate,
1103: fnd_global.login_id,
1104: sysdate ,
1105: fnd_global.user_id,

Line 1103: fnd_global.login_id,

1099: p_pm_runtime_rules_tbl(i).METER_ID ,
1100: p_pm_runtime_rules_tbl(i).RUNTIME_INTERVAL,
1101: fnd_global.user_id,
1102: sysdate,
1103: fnd_global.login_id,
1104: sysdate ,
1105: fnd_global.user_id,
1106: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_FROM ,
1107: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_TO ,

Line 1105: fnd_global.user_id,

1101: fnd_global.user_id,
1102: sysdate,
1103: fnd_global.login_id,
1104: sysdate ,
1105: fnd_global.user_id,
1106: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_FROM ,
1107: p_pm_runtime_rules_tbl(i).EFFECTIVE_READING_TO ,
1108: p_pm_runtime_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1109: p_pm_runtime_rules_tbl(i).EFFECTIVE_DATE_TO ,

Line 1164: fnd_global.user_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 ,
1163: p_pm_list_date_rules_tbl(i).RUNTIME_INTERVAL,
1164: fnd_global.user_id,
1165: sysdate,
1166: fnd_global.login_id,
1167: sysdate ,
1168: fnd_global.user_id,

Line 1166: fnd_global.login_id,

1162: p_pm_list_date_rules_tbl(i).METER_ID ,
1163: p_pm_list_date_rules_tbl(i).RUNTIME_INTERVAL,
1164: fnd_global.user_id,
1165: sysdate,
1166: fnd_global.login_id,
1167: sysdate ,
1168: fnd_global.user_id,
1169: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_FROM ,
1170: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_TO ,

Line 1168: fnd_global.user_id,

1164: fnd_global.user_id,
1165: sysdate,
1166: fnd_global.login_id,
1167: sysdate ,
1168: fnd_global.user_id,
1169: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_FROM ,
1170: p_pm_list_date_rules_tbl(i).EFFECTIVE_READING_TO ,
1171: p_pm_list_date_rules_tbl(i).EFFECTIVE_DATE_FROM ,
1172: p_pm_list_date_rules_tbl(i).EFFECTIVE_DATE_TO ,

Line 1402: --CREATED_BY=fnd_global.user_id,

1398: INTERVAL_PER_CYCLE = p_pm_schedule_rec.INTERVAL_PER_CYCLE, -- 13263283
1399: CURRENT_SEQ = p_pm_schedule_rec.CURRENT_SEQ, -- added for bug14641909
1400: LAST_REVIEWED_BY = p_pm_schedule_rec.LAST_REVIEWED_BY,
1401: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1402: --CREATED_BY=fnd_global.user_id,
1403: --CREATION_DATE=sysdate,
1404: LAST_UPDATE_LOGIN=fnd_global.login_id,
1405: LAST_UPDATED_BY=fnd_global.user_id,
1406: LAST_UPDATE_DATE=sysdate ,

Line 1404: LAST_UPDATE_LOGIN=fnd_global.login_id,

1400: LAST_REVIEWED_BY = p_pm_schedule_rec.LAST_REVIEWED_BY,
1401: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1402: --CREATED_BY=fnd_global.user_id,
1403: --CREATION_DATE=sysdate,
1404: LAST_UPDATE_LOGIN=fnd_global.login_id,
1405: LAST_UPDATED_BY=fnd_global.user_id,
1406: LAST_UPDATE_DATE=sysdate ,
1407: generate_next_work_order =p_pm_schedule_rec.generate_next_work_order,
1408: BASE_DATE = p_pm_schedule_rec.BASE_DATE, -- added for bug13906069

Line 1405: LAST_UPDATED_BY=fnd_global.user_id,

1401: LAST_REVIEWED_DATE = p_pm_schedule_rec.LAST_REVIEWED_DATE ,
1402: --CREATED_BY=fnd_global.user_id,
1403: --CREATION_DATE=sysdate,
1404: LAST_UPDATE_LOGIN=fnd_global.login_id,
1405: LAST_UPDATED_BY=fnd_global.user_id,
1406: LAST_UPDATE_DATE=sysdate ,
1407: generate_next_work_order =p_pm_schedule_rec.generate_next_work_order,
1408: BASE_DATE = p_pm_schedule_rec.BASE_DATE, -- added for bug13906069
1409: BASE_READING = p_pm_schedule_rec.BASE_READING, -- bug 13906069

Line 1438: fnd_global.user_id,

1434: p_pm_activities_tbl(n).activity_association_id,
1435: p_pm_activities_tbl(n).interval_multiple,
1436: p_pm_activities_tbl(n).allow_repeat_in_cycle,
1437: p_pm_activities_tbl(n).day_tolerance,
1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.login_id,
1441: sysdate ,
1442: fnd_global.user_id

Line 1440: fnd_global.login_id,

1436: p_pm_activities_tbl(n).allow_repeat_in_cycle,
1437: p_pm_activities_tbl(n).day_tolerance,
1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.login_id,
1441: sysdate ,
1442: fnd_global.user_id
1443: );
1444: n:=n+1;

Line 1442: fnd_global.user_id

1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.login_id,
1441: sysdate ,
1442: fnd_global.user_id
1443: );
1444: n:=n+1;
1445:
1446: end loop;

Line 1507: fnd_global.user_id,

1503: l_current_rules_tbl(n).RULE_TYPE,
1504: l_current_rules_tbl(n).DAY_INTERVAL,
1505: l_current_rules_tbl(n).METER_ID ,
1506: l_current_rules_tbl(n).RUNTIME_INTERVAL,
1507: fnd_global.user_id,
1508: sysdate,
1509: fnd_global.login_id,
1510: sysdate ,
1511: fnd_global.user_id,

Line 1509: fnd_global.login_id,

1505: l_current_rules_tbl(n).METER_ID ,
1506: l_current_rules_tbl(n).RUNTIME_INTERVAL,
1507: fnd_global.user_id,
1508: sysdate,
1509: fnd_global.login_id,
1510: sysdate ,
1511: fnd_global.user_id,
1512: l_current_rules_tbl(n).EFFECTIVE_READING_FROM ,
1513: l_current_rules_tbl(n).EFFECTIVE_READING_TO ,

Line 1511: fnd_global.user_id,

1507: fnd_global.user_id,
1508: sysdate,
1509: fnd_global.login_id,
1510: sysdate ,
1511: fnd_global.user_id,
1512: l_current_rules_tbl(n).EFFECTIVE_READING_FROM ,
1513: l_current_rules_tbl(n).EFFECTIVE_READING_TO ,
1514: l_current_rules_tbl(n).EFFECTIVE_DATE_FROM ,
1515: l_current_rules_tbl(n).EFFECTIVE_DATE_TO ,

Line 2524: last_update_date=sysdate, last_updated_by=fnd_global.user_id,

2520:
2521: UPDATE mtl_eam_asset_activities
2522: SET last_service_start_date = l_last_service_start_date,
2523: last_service_end_date = l_last_service_end_date,
2524: last_update_date=sysdate, last_updated_by=fnd_global.user_id,
2525: last_update_login=fnd_global.login_id
2526: WHERE activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2527:
2528:

Line 2525: last_update_login=fnd_global.login_id

2521: UPDATE mtl_eam_asset_activities
2522: SET last_service_start_date = l_last_service_start_date,
2523: last_service_end_date = l_last_service_end_date,
2524: last_update_date=sysdate, last_updated_by=fnd_global.user_id,
2525: last_update_login=fnd_global.login_id
2526: WHERE activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2527:
2528:
2529: end if;

Line 2575: last_update_date=sysdate, last_updated_by=fnd_global.user_id,

2571: UPDATE mtl_eam_asset_activities meaa
2572: SET meaa.last_scheduled_start_date = l_last_scheduled_start_date,
2573: meaa.last_scheduled_end_date = l_last_scheduled_end_date,
2574: meaa.wip_entity_id=l_wip_entity_id,
2575: last_update_date=sysdate, last_updated_by=fnd_global.user_id,
2576: last_update_login=fnd_global.login_id
2577: WHERE (meaa.last_scheduled_start_date is null OR
2578: meaa.last_scheduled_end_date is null) AND
2579: meaa.activity_association_id = p_pm_activity_grp_rec.activity_association_id;

Line 2576: last_update_login=fnd_global.login_id

2572: SET meaa.last_scheduled_start_date = l_last_scheduled_start_date,
2573: meaa.last_scheduled_end_date = l_last_scheduled_end_date,
2574: meaa.wip_entity_id=l_wip_entity_id,
2575: last_update_date=sysdate, last_updated_by=fnd_global.user_id,
2576: last_update_login=fnd_global.login_id
2577: WHERE (meaa.last_scheduled_start_date is null OR
2578: meaa.last_scheduled_end_date is null) AND
2579: meaa.activity_association_id = p_pm_activity_grp_rec.activity_association_id;
2580:

Line 2604: fnd_global.user_id,

2600: VALUES (p_pm_activity_grp_rec.activity_association_id,
2601: p_pm_runtime_rules_tbl(i).meter_id,
2602: nvl(p_pm_runtime_rules_tbl(i).last_service_reading, 0),
2603: sysdate,
2604: fnd_global.user_id,
2605: sysdate,
2606: fnd_global.login_id,
2607: fnd_global.user_id);
2608:

Line 2606: fnd_global.login_id,

2602: nvl(p_pm_runtime_rules_tbl(i).last_service_reading, 0),
2603: sysdate,
2604: fnd_global.user_id,
2605: sysdate,
2606: fnd_global.login_id,
2607: fnd_global.user_id);
2608:
2609: l_lsi_updated := 'Y';
2610: x_activities :=l_act_name;

Line 2607: fnd_global.user_id);

2603: sysdate,
2604: fnd_global.user_id,
2605: sysdate,
2606: fnd_global.login_id,
2607: fnd_global.user_id);
2608:
2609: l_lsi_updated := 'Y';
2610: x_activities :=l_act_name;
2611: end if;

Line 3223: last_updated_by=fnd_global.user_id,

3219: -- modified for 9754424.
3220: if (l_act_assoc_id is not null) or (l_act_assoc_id <>FND_API.G_MISS_NUM) THEN
3221: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3222: last_update_date=sysdate,
3223: last_updated_by=fnd_global.user_id,
3224: last_update_login=fnd_global.login_id
3225: where pm_schedule_id = p_pm_schedule_id;
3226: end if;
3227: --standard commit to be checked

Line 3224: last_update_login=fnd_global.login_id

3220: if (l_act_assoc_id is not null) or (l_act_assoc_id <>FND_API.G_MISS_NUM) THEN
3221: update eam_pm_schedulings set EAM_LAST_CYCLIC_ACT = l_act_assoc_id,
3222: last_update_date=sysdate,
3223: last_updated_by=fnd_global.user_id,
3224: last_update_login=fnd_global.login_id
3225: where pm_schedule_id = p_pm_schedule_id;
3226: end if;
3227: --standard commit to be checked
3228:

Line 3348: last_updated_by=fnd_global.user_id,

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
3351: meter_id = runtime_rec.meter_id and
3352: rule_id = runtime_rec.rule_id;

Line 3349: last_update_login=fnd_global.login_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
3351: meter_id = runtime_rec.meter_id and
3352: rule_id = runtime_rec.rule_id;
3353: