DBA Data[Home] [Help]

APPS.AHL_SIMULATION_PVT dependencies on FND_GLOBAL

Line 418: last_updated_by = fnd_global.user_id,

414: LOOP
415: UPDATE AHL_FLEET_UNIT_ASSOCS
416: SET association_end = SYSDATE-1,
417: last_update_date = SYSDATE,
418: last_updated_by = fnd_global.user_id,
419: last_update_login = fnd_global.login_id
420: WHERE fleet_unit_assoc_id = rec.fleet_unit_assoc_id
421: AND simulation_plan_id = l_primary_plan_id;
422: IF (l_log_unexpected >= l_log_current_level) THEN

Line 419: last_update_login = fnd_global.login_id

415: UPDATE AHL_FLEET_UNIT_ASSOCS
416: SET association_end = SYSDATE-1,
417: last_update_date = SYSDATE,
418: last_updated_by = fnd_global.user_id,
419: last_update_login = fnd_global.login_id
420: WHERE fleet_unit_assoc_id = rec.fleet_unit_assoc_id
421: AND simulation_plan_id = l_primary_plan_id;
422: IF (l_log_unexpected >= l_log_current_level) THEN
423: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Implement_Simulation_Plan', 'Updated end date for primary plan fleet assoc id '||rec.fleet_unit_assoc_id );

Line 440: last_updated_by = fnd_global.user_id,

436: LOOP
437: UPDATE AHL_FLEET_UNIT_ASSOCS
438: SET association_start = SYSDATE,
439: last_update_date = SYSDATE,
440: last_updated_by = fnd_global.user_id,
441: last_update_login = fnd_global.login_id
442: WHERE simulation_plan_id = p_simulation_plan_id
443: AND fleet_unit_assoc_id = rec.fleet_unit_assoc_id;
444: IF (l_log_unexpected >= l_log_current_level) THEN

Line 441: last_update_login = fnd_global.login_id

437: UPDATE AHL_FLEET_UNIT_ASSOCS
438: SET association_start = SYSDATE,
439: last_update_date = SYSDATE,
440: last_updated_by = fnd_global.user_id,
441: last_update_login = fnd_global.login_id
442: WHERE simulation_plan_id = p_simulation_plan_id
443: AND fleet_unit_assoc_id = rec.fleet_unit_assoc_id;
444: IF (l_log_unexpected >= l_log_current_level) THEN
445: fnd_log.string ( l_log_unexpected, 'ahl.plsql.Implement_Simulation_Plan', 'Updated assoc start for sim plan for assoc id '||rec.fleet_unit_assoc_id);

Line 453: last_updated_by = fnd_global.login_id

449: -- convert the sim plan unit rows into primary plan rows
450: UPDATE AHL_FLEET_UNIT_ASSOCS assoc
451: SET SIMULATION_PLAN_ID =l_primary_plan_id,
452: last_update_date = SYSDATE,
453: last_updated_by = fnd_global.login_id
454: WHERE SIMULATION_PLAN_ID= p_simulation_plan_id
455: AND ahl_util_uc_pkg.get_uc_status_code(assoc.unit_config_header_id) <>'EXPIRED'-- added to avoid expired units;
456: AND NOT (association_start IS NULL AND association_end IS NULL);
457: IF (l_log_statement >= l_log_current_level) THEN