DBA Data[Home] [Help]

APPS.EAM_PMDEF_PUB dependencies on FND_GLOBAL

Line 322: fnd_global.user_id,

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 ,

Line 324: fnd_global.login_id,

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:

Line 325: fnd_global.user_id,

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.

Line 365: fnd_global.user_id,

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 );

Line 367: fnd_global.login_id,

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;

Line 368: fnd_global.user_id,

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:

Line 438: fnd_global.user_id,

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,

Line 440: fnd_global.login_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 ,

Line 442: fnd_global.user_id,

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 ,

Line 491: fnd_global.user_id,

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: );

Line 493: fnd_global.user_id,

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;

Line 494: fnd_global.login_id

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:

Line 954: fnd_global.user_id,

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,

Line 956: fnd_global.login_id,

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 ,

Line 957: fnd_global.user_id,

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 ,

Line 995: fnd_global.user_id,

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

Line 997: fnd_global.login_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;

Line 999: fnd_global.user_id

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:

Line 1034: fnd_global.user_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 ,
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,

Line 1036: fnd_global.login_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 ,

Line 1038: fnd_global.user_id,

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 ,

Line 1079: fnd_global.user_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 ,
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,

Line 1081: fnd_global.login_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 ,

Line 1083: fnd_global.user_id,

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 ,

Line 1123: fnd_global.user_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 ,
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,

Line 1125: fnd_global.login_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 ,

Line 1127: fnd_global.user_id,

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 ,

Line 1357: CREATED_BY=fnd_global.user_id,

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 ,

Line 1359: LAST_UPDATE_LOGIN=fnd_global.login_id,

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;

Line 1360: LAST_UPDATED_BY=fnd_global.user_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:

Line 1389: fnd_global.user_id,

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

Line 1391: fnd_global.login_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;

Line 1393: fnd_global.user_id

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;

Line 1441: fnd_global.user_id,

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,

Line 1443: fnd_global.login_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 ,

Line 1445: fnd_global.user_id,

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 ,

Line 2437: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,

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:

Line 2438: last_update_login=fnd_global.login_id, created_by = fnd_global.user_id

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;

Line 2488: last_update_date=sysdate, last_updated_by=fnd_global.user_id, creation_date=sysdate,

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;

Line 2489: last_update_login=fnd_global.login_id, created_by = fnd_global.user_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:

Line 2517: fnd_global.user_id,

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:

Line 2519: fnd_global.login_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:
2522: l_lsi_updated := 'Y';
2523: x_activities :=l_act_name;

Line 2520: fnd_global.user_id);

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;

Line 3117: last_updated_by=fnd_global.user_id,

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;

Line 3119: last_update_login=fnd_global.login_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

Line 3120: created_by = fnd_global.user_id where

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:

Line 3244: last_updated_by=fnd_global.user_id,

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

Line 3246: last_update_login=fnd_global.login_id,

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;

Line 3247: created_by = fnd_global.user_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: