[Home] [Help]
431: FROM msc_shift_dates dates,
432: msc_shift_times shifts,
433: msc_resource_shifts res_shifts,
434: msc_department_resources dept_res1,
435: msc_dept_res_instances dept_ins,
436: msc_trading_partners param
437: WHERE dates.calendar_code = param.calendar_code
438: AND dates.exception_set_id = param.calendar_exception_set_id
439: AND dates.sr_instance_id = param.sr_instance_id
547: sysdate,
548: arg_refresh_number
549: FROM msc_calendar_dates dates,
550: msc_department_resources dept_res1,
551: msc_dept_res_instances dept_ins,
552: msc_trading_partners param
553: WHERE dates.calendar_code = param.calendar_code
554: AND dates.exception_set_id = param.calendar_exception_set_id
555: AND dates.sr_instance_id = param.sr_instance_id
832: --org.calendar_code, --**
833: -- org.calendar_exception_set_id --**
834: FROM msc_trading_partners org,
835: msc_department_resources dept_res,
836: msc_dept_res_instances dept_ins
837: WHERE dept_res.owning_department_id = dept_res.department_id
838: AND dept_res.plan_id = -1
839: AND dept_res.resource_id <> -1
840: AND dept_res.aggregate_resource_flag <> 1 -- if it's not aggregate
903: var_capacity_units NUMBER; -- new variables for calling calc_res_avail
904: var_disable_date DATE;
905:
906: var_res_instance_id NUMBER;
907: var_serial_number msc_dept_res_instances.serial_number%type;
908: var_equipment_item_id msc_dept_res_instances.equipment_item_id%type;
909:
910: BEGIN
911:
904: var_disable_date DATE;
905:
906: var_res_instance_id NUMBER;
907: var_serial_number msc_dept_res_instances.serial_number%type;
908: var_equipment_item_id msc_dept_res_instances.equipment_item_id%type;
909:
910: BEGIN
911:
912: var_gt_date := SYSDATE;