23: /* Currently the ATP Pegging Record Types will be defined local to this package. */
24: -- This record will hold the ATP simplified Pegging Data.
25: -- Corresponds to the table msc_atp_pegging
26: TYPE ATP_Simple_Peg_Typ is RECORD (
27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
24: -- This record will hold the ATP simplified Pegging Data.
25: -- Corresponds to the table msc_atp_pegging
26: TYPE ATP_Simple_Peg_Typ is RECORD (
27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
25: -- Corresponds to the table msc_atp_pegging
26: TYPE ATP_Simple_Peg_Typ is RECORD (
27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: TYPE ATP_Simple_Peg_Typ is RECORD (
27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
31: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
32: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
34: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
35: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
37: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
41: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
42: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
45: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
47: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
48: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
49: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
50: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
51: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
52: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
64: -- CTO-PF
57: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
58: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
64: -- CTO-PF
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
60: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
64: -- CTO-PF
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
66: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
67: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
61: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
64: -- CTO-PF
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
66: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
67: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
68: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
69: -- Exclude flag helps in excluding supplies
62: -- CTO_PF_PRJ changes.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
64: -- CTO-PF
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
66: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
67: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
68: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
69: -- Exclude flag helps in excluding supplies
70: -- during relef data calculation.
64: -- CTO-PF
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
66: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
67: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
68: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
69: -- Exclude flag helps in excluding supplies
70: -- during relef data calculation.
71: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
72: -- End Bug 3805136
67: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
68: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
69: -- Exclude flag helps in excluding supplies
70: -- during relef data calculation.
71: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
72: -- End Bug 3805136
73: );
74:
75: -- This record will hold the Detailed ATP Pegging Data.
74:
75: -- This record will hold the Detailed ATP Pegging Data.
76: -- Corresponds to the table msc_atp_detail_peg_temp
77: TYPE ATP_Detail_Peg_Typ is RECORD (
78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
75: -- This record will hold the Detailed ATP Pegging Data.
76: -- Corresponds to the table msc_atp_detail_peg_temp
77: TYPE ATP_Detail_Peg_Typ is RECORD (
78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
76: -- Corresponds to the table msc_atp_detail_peg_temp
77: TYPE ATP_Detail_Peg_Typ is RECORD (
78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
77: TYPE ATP_Detail_Peg_Typ is RECORD (
78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
79: base_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
80: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
81: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
82: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
83: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
84: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
85: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
86: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
88: sales_order_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
91: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
93: demand_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
94: disposition_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
96: demand_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
97: original_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
98: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
99: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
100: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
102: process_seq_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
103: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
108: supply_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
110: release_status MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
118: -- CTO-PF
111: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
118: -- CTO-PF
119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
113: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
114: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
118: -- CTO-PF
119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
120: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
121: );
115: prev_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
118: -- CTO-PF
119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
120: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
121: );
122:
123: -- This record is for holding data obtained from msc_forecast_updates
116: -- CTO_PF_PRJ changes.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
118: -- CTO-PF
119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
120: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
121: );
122:
123: -- This record is for holding data obtained from msc_forecast_updates
124: -- and msc_system_items.
122:
123: -- This record is for holding data obtained from msc_forecast_updates
124: -- and msc_system_items.
125: TYPE ATP_Fcst_Cons_Typ is RECORD (
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
123: -- This record is for holding data obtained from msc_forecast_updates
124: -- and msc_system_items.
125: TYPE ATP_Fcst_Cons_Typ is RECORD (
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
124: -- and msc_system_items.
125: TYPE ATP_Fcst_Cons_Typ is RECORD (
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
125: TYPE ATP_Fcst_Cons_Typ is RECORD (
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
128: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
129: parent_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
130: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
131: fcst_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
132: fcst_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: sales_order_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: -- Bug 3701093 Flag to indicate if config item's forecast is consumed (2)
134: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: -- Bug 3701093 Flag to indicate if config item's forecast is consumed (2)
142: -- or if model's forecast is overconsumed (1) or no forecast consumption (0).
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: -- Bug 3701093 Flag to indicate if config item's forecast is consumed (2)
142: -- or if model's forecast is overconsumed (1) or no forecast consumption (0).
143: cons_config_mod_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
138: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: -- Bug 3701093 Flag to indicate if config item's forecast is consumed (2)
142: -- or if model's forecast is overconsumed (1) or no forecast consumption (0).
143: cons_config_mod_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
144: );
139: fixed_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: -- Bug 3701093 Flag to indicate if config item's forecast is consumed (2)
142: -- or if model's forecast is overconsumed (1) or no forecast consumption (0).
143: cons_config_mod_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
144: );
145:
146: -- This record holds data resource_requirements
147: -- and corrsponding relief data.
145:
146: -- This record holds data resource_requirements
147: -- and corrsponding relief data.
148: TYPE ATP_Res_Peg_Typ is RECORD (
149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
146: -- This record holds data resource_requirements
147: -- and corrsponding relief data.
148: TYPE ATP_Res_Peg_Typ is RECORD (
149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: -- and corrsponding relief data.
148: TYPE ATP_Res_Peg_Typ is RECORD (
149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
148: TYPE ATP_Res_Peg_Typ is RECORD (
149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
151: organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
152: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
153: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
154: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
162: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
155: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
162: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
163: );
156: resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
162: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
163: );
164:
157: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
162: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
163: );
164:
165: -- Bug 3750638
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
161: relief_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
162: daily_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
163: );
164:
165: -- Bug 3750638
166: -- Fix for Multiple (N) Level of Config Items using Loop
183: -- Fix for Multiple (N) Level of Config Items using Loop
184: -- Define PL/SQL Record of Arrays Type to correspond to
185: -- Config Item Supplies being processed in the Pegging Retrieval loop.
186: TYPE ATP_Config_Sup_Typ is RECORD (
187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
184: -- Define PL/SQL Record of Arrays Type to correspond to
185: -- Config Item Supplies being processed in the Pegging Retrieval loop.
186: TYPE ATP_Config_Sup_Typ is RECORD (
187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
185: -- Config Item Supplies being processed in the Pegging Retrieval loop.
186: TYPE ATP_Config_Sup_Typ is RECORD (
187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
186: TYPE ATP_Config_Sup_Typ is RECORD (
187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
195: END_PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
188: SR_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
195: END_PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
196: );
189: BASE_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
195: END_PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
196: );
197: -- End Bug 3750638
190: SALES_ORDER_LINE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
195: END_PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
196: );
197: -- End Bug 3750638
198:
191: DEMAND_SOURCE_TYPE MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
192: END_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
193: SUPPLY_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
194: PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
195: END_PEGGING_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
196: );
197: -- End Bug 3750638
198:
199: /* Procedures for CTO Re-architecture and Resource Capacity Enhancements */
316: END IF;
317:
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
317:
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
319:
320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
321: atp_peg_tab.base_item_id := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
322: atp_peg_tab.inventory_item_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
323: atp_peg_tab.plan_id := MRP_ATP_PUB.number_arr();
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
324: atp_peg_tab.sr_instance_id := MRP_ATP_PUB.number_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
325: atp_peg_tab.organization_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
326: atp_peg_tab.bom_item_type := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
327: atp_peg_tab.fixed_lt := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
328: atp_peg_tab.variable_lt := MRP_ATP_PUB.number_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
330: atp_peg_tab.sales_order_line_id := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
334: atp_peg_tab.demand_quantity := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
335: atp_peg_tab.disposition_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
338: atp_peg_tab.overconsumption_qty := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
340: atp_peg_tab.supply_quantity := MRP_ATP_PUB.number_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
341: atp_peg_tab.allocated_quantity := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
342: atp_peg_tab.tot_relief_qty := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
343: atp_peg_tab.resource_id := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
344: atp_peg_tab.department_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
345: atp_peg_tab.resource_hours := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
347: atp_peg_tab.start_date := MRP_ATP_PUB.date_arr();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
357: -- CTO-PF
350: atp_peg_tab.relief_quantity := MRP_ATP_PUB.number_arr();
351: atp_peg_tab.daily_relief_qty := MRP_ATP_PUB.number_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
357: -- CTO-PF
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();
352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_arr();
353: atp_peg_tab.pegging_id := MRP_ATP_PUB.number_arr();
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
357: -- CTO-PF
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();
359: atp_peg_tab.product_family_id := MRP_ATP_PUB.number_arr();
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
354: atp_peg_tab.prev_pegging_id := MRP_ATP_PUB.number_arr();
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
357: -- CTO-PF
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();
359: atp_peg_tab.product_family_id := MRP_ATP_PUB.number_arr();
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
361: atp_peg_tab.end_item_usage := MRP_ATP_PUB.number_arr();
362: -- Exclude flag helps in excluding supplies
355: -- CTO_PF_PRJ changes.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();
357: -- CTO-PF
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();
359: atp_peg_tab.product_family_id := MRP_ATP_PUB.number_arr();
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
361: atp_peg_tab.end_item_usage := MRP_ATP_PUB.number_arr();
362: -- Exclude flag helps in excluding supplies
363: -- during relef data calculation.
357: -- CTO-PF
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();
359: atp_peg_tab.product_family_id := MRP_ATP_PUB.number_arr();
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
361: atp_peg_tab.end_item_usage := MRP_ATP_PUB.number_arr();
362: -- Exclude flag helps in excluding supplies
363: -- during relef data calculation.
364: atp_peg_tab.exclude_flag := MRP_ATP_PUB.number_arr();
365: -- End Bug 3805136
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.
361: atp_peg_tab.end_item_usage := MRP_ATP_PUB.number_arr();
362: -- Exclude flag helps in excluding supplies
363: -- during relef data calculation.
364: atp_peg_tab.exclude_flag := MRP_ATP_PUB.number_arr();
365: -- End Bug 3805136
366:
367: IF PG_DEBUG in ('Y', 'C') THEN
368: msc_util.msc_log('***** End Init_Atp_Peg Procedure *****');
1215: x_return_status OUT NOCOPY VARCHAR2)
1216: IS
1217: i PLS_INTEGER;
1218: k PLS_INTEGER;
1219: l_item_typ MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
1220: l_process_seq_id NUMBER;
1221: l_routing_seq_id NUMBER;
1222: l_bill_seq_id NUMBER;
1223:
2828: l_user_id number;
2829: l_table_name VARCHAR2(30);
2830: l_tbspace VARCHAR2(30);
2831: l_temp_table VARCHAR2(30);
2832: atp_simple_peg_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
2833: 'ATP_PEGGING');
2834: l_share_partition VARCHAR2(1);
2835: l_plan_id NUMBER;
2836: l_plan_name varchar2(10);
2843: l_pegging_id NUMBER;
2844:
2845: -- Bug 3362558 Store the original_demand_id
2846: -- CTO_PF_PRJ. This array is not needed anymore.
2847: l_original_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2848: -- CTO-PF
2849: l_time_phased_atp VARCHAR2(1) := 'N';
2850: -- This cursor fetches the list of configuration_items.
2851: CURSOR config_items IS
4698: p_plan_id IN NUMBER,
4699: p_refresh_number IN NUMBER,
4700: p_order_number IN NUMBER,
4701: p_demand_source_type IN NUMBER,--cmro
4702: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4703: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4704: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4705: x_return_status IN OUT NoCopy VARCHAR2
4706: )
4699: p_refresh_number IN NUMBER,
4700: p_order_number IN NUMBER,
4701: p_demand_source_type IN NUMBER,--cmro
4702: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4703: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4704: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4705: x_return_status IN OUT NoCopy VARCHAR2
4706: )
4707: IS
4700: p_order_number IN NUMBER,
4701: p_demand_source_type IN NUMBER,--cmro
4702: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4703: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4704: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4705: x_return_status IN OUT NoCopy VARCHAR2
4706: )
4707: IS
4708: l_del_rows NUMBER;
4708: l_del_rows NUMBER;
4709: i PLS_INTEGER;
4710: my_sqlcode NUMBER;
4711:
4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4709: i PLS_INTEGER;
4710: my_sqlcode NUMBER;
4711:
4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4710: my_sqlcode NUMBER;
4711:
4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4711:
4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4713: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4715: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4724:
4717: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4724:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4718: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4724:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4726: -- Bug 3890723 Introduce a pegging_id array to track pegging
4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4720: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4724:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4726: -- Bug 3890723 Introduce a pegging_id array to track pegging
4727: -- For filtering out released/firmed supplies instead of disposition_id array.
4721: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4722: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4724:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4726: -- Bug 3890723 Introduce a pegging_id array to track pegging
4727: -- For filtering out released/firmed supplies instead of disposition_id array.
4728: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4729: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4724:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4726: -- Bug 3890723 Introduce a pegging_id array to track pegging
4727: -- For filtering out released/firmed supplies instead of disposition_id array.
4728: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4729: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: -- End Bug 3890723
4731:
4732: l_sysdate DATE;
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4726: -- Bug 3890723 Introduce a pegging_id array to track pegging
4727: -- For filtering out released/firmed supplies instead of disposition_id array.
4728: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4729: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: -- End Bug 3890723
4731:
4732: l_sysdate DATE;
4733: l_user_id number;
4730: -- End Bug 3890723
4731:
4732: l_sysdate DATE;
4733: l_user_id number;
4734: l_so_line_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735:
4736: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4737: l_offset_type NUMBER;
4738: -- CTO_PF_PRJ_2 Impacts
4735:
4736: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4737: l_offset_type NUMBER;
4738: -- CTO_PF_PRJ_2 Impacts
4739: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4741: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4742: -- End CTO_PF_PRJ_2 Impacts
4743: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands
4736: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4737: l_offset_type NUMBER;
4738: -- CTO_PF_PRJ_2 Impacts
4739: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4741: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4742: -- End CTO_PF_PRJ_2 Impacts
4743: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands
4744: -- that are pegged to supplies that can be relieved.
4737: l_offset_type NUMBER;
4738: -- CTO_PF_PRJ_2 Impacts
4739: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4741: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4742: -- End CTO_PF_PRJ_2 Impacts
4743: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands
4744: -- that are pegged to supplies that can be relieved.
4745: l_sup_offset_type NUMBER;
5228: p_plan_id IN NUMBER,
5229: p_refresh_number IN NUMBER,
5230: p_order_number IN NUMBER,
5231: p_demand_source_type IN NUMBER,--cmro
5232: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5233: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5234: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5235: x_return_status IN OUT NoCopy VARCHAR2
5236: )
5229: p_refresh_number IN NUMBER,
5230: p_order_number IN NUMBER,
5231: p_demand_source_type IN NUMBER,--cmro
5232: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5233: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5234: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5235: x_return_status IN OUT NoCopy VARCHAR2
5236: )
5237: IS
5230: p_order_number IN NUMBER,
5231: p_demand_source_type IN NUMBER,--cmro
5232: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5233: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5234: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5235: x_return_status IN OUT NoCopy VARCHAR2
5236: )
5237: IS
5238: l_del_rows NUMBER;
5238: l_del_rows NUMBER;
5239: i PLS_INTEGER;
5240: my_sqlcode NUMBER;
5241:
5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5239: i PLS_INTEGER;
5240: my_sqlcode NUMBER;
5241:
5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5240: my_sqlcode NUMBER;
5241:
5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5241:
5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5244: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5245: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5247: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5248: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5250: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5251: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5252: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260:
5253: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5254: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_sysdate DATE;
5255: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5256: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_sysdate DATE;
5263: l_user_id number;
5257: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_sysdate DATE;
5263: l_user_id number;
5264: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5265: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5260:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_sysdate DATE;
5263: l_user_id number;
5264: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5265: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5266:
5267: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5268: l_offset_type NUMBER := NULL;
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_sysdate DATE;
5263: l_user_id number;
5264: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5265: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5266:
5267: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5268: l_offset_type NUMBER := NULL;
5269:
5267: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5268: l_offset_type NUMBER := NULL;
5269:
5270: -- Bug 3381464 Array to track original supplies for updating msc_atp_pegging
5271: l_orig_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: -- Bug 3717618 Introduce a pegging_id array to track pegging
5273: -- For filtering out released/firmed supplies and pegging both are needed.
5274: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5275:
5270: -- Bug 3381464 Array to track original supplies for updating msc_atp_pegging
5271: l_orig_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: -- Bug 3717618 Introduce a pegging_id array to track pegging
5273: -- For filtering out released/firmed supplies and pegging both are needed.
5274: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5275:
5276: BEGIN
5277:
5278: IF PG_DEBUG in ('Y', 'C') THEN
5682: p_plan_id IN NUMBER,
5683: p_refresh_number IN NUMBER,
5684: p_order_number IN NUMBER,
5685: p_demand_source_type IN NUMBER,--cmro
5686: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5687: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5688: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5689: x_return_status IN OUT NoCopy VARCHAR2
5690: )
5683: p_refresh_number IN NUMBER,
5684: p_order_number IN NUMBER,
5685: p_demand_source_type IN NUMBER,--cmro
5686: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5687: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5688: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5689: x_return_status IN OUT NoCopy VARCHAR2
5690: )
5691: IS
5684: p_order_number IN NUMBER,
5685: p_demand_source_type IN NUMBER,--cmro
5686: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5687: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5688: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5689: x_return_status IN OUT NoCopy VARCHAR2
5690: )
5691: IS
5692: l_del_rows NUMBER;
5692: l_del_rows NUMBER;
5693: i PLS_INTEGER;
5694: my_sqlcode NUMBER;
5695:
5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5693: i PLS_INTEGER;
5694: my_sqlcode NUMBER;
5695:
5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5694: my_sqlcode NUMBER;
5695:
5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5695:
5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5697: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5698: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5701: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5704: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5706: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713:
5714: l_sysdate DATE;
5707: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713:
5714: l_sysdate DATE;
5715: l_user_id number;
5708: l_std_op_code MRP_ATP_PUB.char10_arr;
5709:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713:
5714: l_sysdate DATE;
5715: l_user_id number;
5716:
5953: p_plan_id IN NUMBER,
5954: p_refresh_number IN NUMBER,
5955: p_order_number IN NUMBER,
5956: p_demand_source_type IN NUMBER,--cmro
5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5954: p_refresh_number IN NUMBER,
5955: p_order_number IN NUMBER,
5956: p_demand_source_type IN NUMBER,--cmro
5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5955: p_order_number IN NUMBER,
5956: p_demand_source_type IN NUMBER,--cmro
5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5956: p_demand_source_type IN NUMBER,--cmro
5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5964: x_return_status OUT NoCopy VARCHAR2
5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5964: x_return_status OUT NoCopy VARCHAR2
5965: )
5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5964: x_return_status OUT NoCopy VARCHAR2
5965: )
5966: IS
5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5964: x_return_status OUT NoCopy VARCHAR2
5965: )
5966: IS
5967:
5964: x_return_status OUT NoCopy VARCHAR2
5965: )
5966: IS
5967:
5968: l_inv_demand_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5969: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5970: j PLS_INTEGER;
5971: i PLS_INTEGER;
5972: match_found NUMBER;
5965: )
5966: IS
5967:
5968: l_inv_demand_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5969: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5970: j PLS_INTEGER;
5971: i PLS_INTEGER;
5972: match_found NUMBER;
5973: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5969: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5970: j PLS_INTEGER;
5971: i PLS_INTEGER;
5972: match_found NUMBER;
5973: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5974: BEGIN
5975:
5976: IF PG_DEBUG in ('Y', 'C') THEN
5977: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');
6057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6058: END Add_Offset_Data;
6059:
6060: PROCEDURE Remove_Offset_Demands (
6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6058: END Add_Offset_Data;
6059:
6060: PROCEDURE Remove_Offset_Demands (
6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6059:
6060: PROCEDURE Remove_Offset_Demands (
6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6067: x_return_status IN OUT NoCopy VARCHAR2
6060: PROCEDURE Remove_Offset_Demands (
6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6067: x_return_status IN OUT NoCopy VARCHAR2
6068: )
6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6067: x_return_status IN OUT NoCopy VARCHAR2
6068: )
6069: IS
6062: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6067: x_return_status IN OUT NoCopy VARCHAR2
6068: )
6069: IS
6070: l_del_rows NUMBER;
6201:
6202: END Remove_Offset_Demands;
6203:
6204: PROCEDURE Remove_Offset_Supplies (
6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6202: END Remove_Offset_Demands;
6203:
6204: PROCEDURE Remove_Offset_Supplies (
6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6203:
6204: PROCEDURE Remove_Offset_Supplies (
6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6211: x_return_status IN OUT NoCopy VARCHAR2
6204: PROCEDURE Remove_Offset_Supplies (
6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6211: x_return_status IN OUT NoCopy VARCHAR2
6212: )
6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6211: x_return_status IN OUT NoCopy VARCHAR2
6212: )
6213: IS
6206: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6211: x_return_status IN OUT NoCopy VARCHAR2
6212: )
6213: IS
6214: l_del_rows NUMBER;
6384: END Remove_Offset_Supplies;
6385:
6386:
6387: PROCEDURE Remove_Offset_Resource_Reqs (
6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6385:
6386:
6387: PROCEDURE Remove_Offset_Resource_Reqs (
6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6386:
6387: PROCEDURE Remove_Offset_Resource_Reqs (
6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6394: x_return_status IN OUT NoCopy VARCHAR2
6387: PROCEDURE Remove_Offset_Resource_Reqs (
6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6394: x_return_status IN OUT NoCopy VARCHAR2
6395: )
6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6394: x_return_status IN OUT NoCopy VARCHAR2
6395: )
6396: IS
6389: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6394: x_return_status IN OUT NoCopy VARCHAR2
6395: )
6396: IS
6397: l_del_rows NUMBER;
6465:
6466: END Remove_Offset_Resource_Reqs;
6467:
6468: PROCEDURE Remove_Offset_Data (
6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6466: END Remove_Offset_Resource_Reqs;
6467:
6468: PROCEDURE Remove_Offset_Data (
6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6467:
6468: PROCEDURE Remove_Offset_Data (
6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6468: PROCEDURE Remove_Offset_Data (
6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6471: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6479: x_return_status OUT NoCopy VARCHAR2
6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6479: x_return_status OUT NoCopy VARCHAR2
6480: )
6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6479: x_return_status OUT NoCopy VARCHAR2
6480: )
6481: IS
6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6479: x_return_status OUT NoCopy VARCHAR2
6480: )
6481: IS
6482: BEGIN