2012: l_old_need_by_date date;
2013: l_reschedule_result boolean;
2014: l_load_type number;
2015:
2016: var_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2013: l_reschedule_result boolean;
2014: l_load_type number;
2015:
2016: var_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2014: l_load_type number;
2015:
2016: var_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2015:
2016: var_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2016: var_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2017: var_loaded_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2018: var_loaded_scheds MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2019: var_resched_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2020: var_resched_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2021: var_wip_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2022: var_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2023: var_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2024: var_released_inst MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2025: var_loaded_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2026: var_resched_int_reqs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2027: var_int_req_load_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2028: var_int_req_reschd_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2029: var_loaded_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2030: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2031: var_resched_lot_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2032: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2033: var_osfm_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2034: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2035: var_resched_eam_jobs MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2036: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2037: var_eam_req_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2038: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2039: var_loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2040: MSC_Rel_Plan_PUB.NumTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2041: var_int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2042: MSC_Rel_Plan_PUB.NumTblTyp(0);
2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2096: p_po_pwb_count);
2097: p_request_id := p_po_res_id(1);
2098: else
2099: FND_FILE.PUT_LINE(FND_FILE.LOG,
2100: 'start msc_rel_plan_pub.msc_release_plan_sc for '||l_transaction_id);
2101: msc_rel_plan_pub.msc_release_plan_sc
2102: ( arg_plan_id => l_plan_id
2103: , arg_log_org_id => l_org_id
2104: , arg_log_sr_instance => l_sr_instance_id
2097: p_request_id := p_po_res_id(1);
2098: else
2099: FND_FILE.PUT_LINE(FND_FILE.LOG,
2100: 'start msc_rel_plan_pub.msc_release_plan_sc for '||l_transaction_id);
2101: msc_rel_plan_pub.msc_release_plan_sc
2102: ( arg_plan_id => l_plan_id
2103: , arg_log_org_id => l_org_id
2104: , arg_log_sr_instance => l_sr_instance_id
2105: , arg_org_id => l_org_id