37: p_plan_id IN NUMBER,
38: p_refresh_number IN NUMBER,
39: p_order_number IN NUMBER,
40: p_demand_source_type IN NUMBER,--cmro
41: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
38: p_refresh_number IN NUMBER,
39: p_order_number IN NUMBER,
40: p_demand_source_type IN NUMBER,--cmro
41: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
39: p_order_number IN NUMBER,
40: p_demand_source_type IN NUMBER,--cmro
41: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
47: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
40: p_demand_source_type IN NUMBER,--cmro
41: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
47: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
48: x_return_status OUT NoCopy VARCHAR2
41: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
47: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
48: x_return_status OUT NoCopy VARCHAR2
49: );
42: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
47: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
48: x_return_status OUT NoCopy VARCHAR2
49: );
50:
43: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
44: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
45: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
46: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
47: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
48: x_return_status OUT NoCopy VARCHAR2
49: );
50:
51: -- Procedure that removes offset demands, supplies and resource_requirements
50:
51: -- Procedure that removes offset demands, supplies and resource_requirements
52: -- during ATP process when dealing with pre-scheduled ATO models, configuration items.
53: PROCEDURE Remove_Offset_Data (
54: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
51: -- Procedure that removes offset demands, supplies and resource_requirements
52: -- during ATP process when dealing with pre-scheduled ATO models, configuration items.
53: PROCEDURE Remove_Offset_Data (
54: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
52: -- during ATP process when dealing with pre-scheduled ATO models, configuration items.
53: PROCEDURE Remove_Offset_Data (
54: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
53: PROCEDURE Remove_Offset_Data (
54: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
54: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
55: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
63: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
56: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
63: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
64: x_return_status OUT NoCopy VARCHAR2
57: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
63: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
64: x_return_status OUT NoCopy VARCHAR2
65: );
58: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
63: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
64: x_return_status OUT NoCopy VARCHAR2
65: );
66:
59: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
60: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
61: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
62: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
63: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
64: x_return_status OUT NoCopy VARCHAR2
65: );
66:
67: -- Creates the simplified ATP Pegging for