APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_FLEET_UNIT_ASSOCS

Line 72: FROM ahl_fleet_unit_assocs

68: --Pekambar Added for Close SR
69: CURSOR get_fleet_unit_asss(c_fleet_id NUMBER)
70: IS
71: SELECT fleet_unit_assoc_id
72: FROM ahl_fleet_unit_assocs
73: WHERE fleet_header_id = c_fleet_id;
74:
75: --Standard local variables
76: L_API_NAME CONSTANT VARCHAR2(30) := 'Remove_Fleet';

Line 186: FROM AHL_FLEET_UNIT_ASSOCS

182: FROM AHL_FLEET_HEADERS_TL
183: WHERE fleet_header_id = p_fleet_id;
184: -- Delete fleet unit association
185: DELETE
186: FROM AHL_FLEET_UNIT_ASSOCS
187: WHERE fleet_header_id = p_fleet_id;
188: -- Delete UEs generated for the fleet
189: DELETE
190: FROM AHL_UE_SIMULATIONS

Line 299: FROM AHL_FLEET_UNIT_ASSOCS

295: FROM AHL_UE_SIMULATIONS
296: WHERE fleet_header_id = p_fleet_id;
297: -- Delete fleet unit association
298: DELETE
299: FROM AHL_FLEET_UNIT_ASSOCS
300: WHERE fleet_header_id = p_fleet_id;
301: -- Update fleet data in MRtable
302: -- Delete the effectivity
303: DELETE

Line 425: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt

421: IS
422: SELECT flt.fleet_header_id, flt.name, flt.operations_type_code, fus.unit_config_header_id,
423: fus.fleet_unit_assoc_id, fus.object_version_number, fus.reconfig_sr_id,
424: fus.association_start, fus.association_end
425: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt
426: WHERE sim.primary_plan_flag = 'Y'
427: AND sim.simulation_type = 'UMP'
428: AND flt.fleet_header_id = fus.fleet_header_id
429: AND flt.status_code = 'COMPLETE'

Line 467: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt

463:
464: CURSOR get_prev_opstype(c_unit_config_header_id NUMBER,c_association_start DATE )
465: IS
466: SELECT flt.operations_type_code
467: FROM ahl_fleet_unit_assocs fus, ahl_simulation_plans_b sim, ahl_fleet_headers_b flt
468: WHERE sim.primary_plan_flag = 'Y'
469: AND sim.simulation_type = 'UMP'
470: AND fus.simulation_plan_id = sim.simulation_plan_id
471: AND flt.fleet_header_id = fus.fleet_header_id

Line 507: FROM ahl_fleet_unit_assocs

503:
504: CURSOR get_sr_id(c_fleet_unit_asso_id NUMBER)
505: IS
506: SELECT reconfig_sr_id, unit_config_header_id
507: FROM ahl_fleet_unit_assocs
508: WHERE reconfig_sr_id IS NOT NULL
509: AND fleet_unit_assoc_id = c_fleet_unit_asso_id;
510:
511:

Line 1022: UPDATE ahl_fleet_unit_assocs

1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: -- Update Fleet - Unit Associtiaon Table with New SR_Incident_Id
1022: UPDATE ahl_fleet_unit_assocs
1023: SET reconfig_sr_id = l_nr_task_rec.incident_id,
1024: object_version_number = l_fleet_unit_asso_rec.object_version_number + 1,
1025: last_update_date = SYSDATE,
1026: last_updated_by = FND_GLOBAL.user_id,

Line 1387: UPDATE ahl_fleet_unit_assocs

1383: END IF;
1384:
1385: -- Nullify reconfig_sr_id Fleet - Unit Association table
1386: -- Whenever SR is closed
1387: UPDATE ahl_fleet_unit_assocs
1388: SET reconfig_sr_id = NULL,
1389: object_version_number = object_version_number + 1,
1390: last_update_date = SYSDATE,
1391: last_updated_by = FND_GLOBAL.user_id,