APPS.AHL_SIMULATION_PVT dependencies on AHL_UTIL_UC_PKG

Line 247: AND ahl_util_uc_pkg.get_uc_status_code(unit_config_header_id) <>'EXPIRED'-- added to avoid expired units

243: AND unit_config_header_id IN
244: (SELECT DISTINCT unit_config_header_id
245: FROM AHL_FLEET_UNIT_ASSOCS
246: WHERE SIMULATION_PLAN_ID= p_simulation_plan_id
247: AND ahl_util_uc_pkg.get_uc_status_code(unit_config_header_id) <>'EXPIRED'-- added to avoid expired units
248: );
249:
250: -- Get the associations which needs to be start dated correctly for the simulation plans
251: CURSOR sim_assoc_for_upd(p_simulation_plan_id NUMBER)

Line 259: AND ahl_util_uc_pkg.get_uc_status_code(unit_config_header_id) <>'EXPIRED';

255: WHERE trunc(association_start) < trunc(SYSDATE)
256: AND NVL(trunc(association_end), trunc(SYSDATE)) >= trunc(SYSDATE)
257: AND NOT (association_start IS NULL AND association_end IS NULL)
258: AND simulation_plan_id = p_simulation_plan_id
259: AND ahl_util_uc_pkg.get_uc_status_code(unit_config_header_id) <>'EXPIRED';
260:
261: -- End of changes for bug 13869885
262:
263: --Standard local variables

Line 382: AND ahl_util_uc_pkg.get_uc_status_code(ua.unit_config_header_id) <>'EXPIRED'-- added to avoid expired units;

378: BULK COLLECT
379: INTO unit_config_header_tbl
380: FROM AHL_FLEET_UNIT_ASSOCS ua
381: WHERE ua.simulation_plan_id = p_simulation_plan_id
382: AND ahl_util_uc_pkg.get_uc_status_code(ua.unit_config_header_id) <>'EXPIRED'-- added to avoid expired units;
383: AND NOT (association_start IS NULL AND association_end IS NULL);
384:
385:
386:

Line 403: AND ahl_util_uc_pkg.get_uc_status_code(UNIT_CONFIG_HEADER_ID) <>'EXPIRED'

399: AND UNIT_CONFIG_HEADER_ID IN
400: (SELECT DISTINCT unit_config_header_id
401: FROM AHL_FLEET_UNIT_ASSOCS
402: WHERE simulation_plan_id= p_simulation_plan_id
403: AND ahl_util_uc_pkg.get_uc_status_code(UNIT_CONFIG_HEADER_ID) <>'EXPIRED'
404: AND NOT (association_start IS NULL AND association_end IS NULL)-- added to avoid expired units
405: )
406: --Added by debadey for bug 13869885
407: AND trunc(association_start)>=trunc(SYSDATE);

Line 455: AND ahl_util_uc_pkg.get_uc_status_code(assoc.unit_config_header_id) <>'EXPIRED'-- added to avoid expired units;

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
458: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Updates mades in assocs table from sim to pri');
459: END IF;