DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on MRP_ATP_PUB

Line 27: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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(),

Line 28: base_item_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(),

Line 29: inventory_item_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(),

Line 30: plan_id 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(),

Line 31: sr_instance_id 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(),

Line 32: organization_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(),
36: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 33: bom_item_type 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(),

Line 34: fixed_lt 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

Line 35: variable_lt 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
39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 36: sales_order_qty 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(),
40: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 37: sales_order_line_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(),

Line 38: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro

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(),

Line 39: transaction_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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(),

Line 40: demand_id 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(),
44: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 41: demand_quantity 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(),

Line 42: disposition_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(),
46: supply_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 43: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_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(),

Line 44: consumed_qty 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(),

Line 45: overconsumption_qty 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(),

Line 46: supply_id 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(),

Line 47: supply_quantity 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(),

Line 48: allocated_quantity 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(),

Line 49: tot_relief_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(),
53: daily_resource_hours MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 50: resource_id 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(),

Line 51: department_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(),
55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 52: resource_hours 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(),
56: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 53: daily_resource_hours 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(),

Line 54: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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(),

Line 55: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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(),

Line 56: relief_type 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(),

Line 57: relief_quantity 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(),

Line 58: daily_relief_qty 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.

Line 59: end_pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_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.
63: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 60: pegging_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

Line 61: prev_pegging_id 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
65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 63: end_demand_id 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(),
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.

Line 65: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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.
68: end_item_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
69: -- Exclude flag helps in excluding supplies

Line 66: product_family_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
70: -- during relef data calculation.

Line 68: end_item_usage 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.
71: exclude_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
72: -- End Bug 3805136

Line 71: exclude_flag 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
73: );
74:
75: -- This record will hold the Detailed ATP Pegging Data.

Line 78: reference_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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(),

Line 79: base_item_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(),

Line 80: inventory_item_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(),

Line 81: plan_id 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(),

Line 82: sr_instance_id 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(),

Line 83: organization_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(),
87: variable_lt MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 84: end_item_usage 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(),

Line 85: bom_item_type 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

Line 86: fixed_lt 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
90: sales_order_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 87: variable_lt 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(),

Line 88: sales_order_line_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(),

Line 89: demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),--cmro

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(),

Line 90: sales_order_qty 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(),

Line 91: demand_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(),

Line 92: demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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(),

Line 93: demand_quantity 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(),

Line 94: disposition_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(),

Line 95: demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_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(),

Line 96: demand_type 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(),

Line 97: original_demand_id 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(),

Line 98: fcst_organization_id 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(),

Line 99: forecast_qty 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(),

Line 100: consumed_qty 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(),

Line 101: overconsumption_qty 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(),
105: supply_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 102: process_seq_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(),
106: allocated_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 103: supply_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(),
107: tot_relief_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 104: supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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(),

Line 105: supply_quantity 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(),

Line 106: allocated_quantity 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(),

Line 107: tot_relief_qty 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(),

Line 108: supply_type 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(),

Line 109: firm_planned_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_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(),

Line 110: release_status 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(),

Line 111: exclude_flag 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(),

Line 112: order_number MRP_ATP_PUB.char62_arr := MRP_ATP_PUB.char62_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.

Line 113: end_pegging_id 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.
117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 114: pegging_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

Line 115: prev_pegging_id 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
119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 117: end_demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_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: );

Line 119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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: );
122:
123: -- This record is for holding data obtained from msc_forecast_updates

Line 120: product_family_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
124: -- and msc_system_items.

Line 126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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(),

Line 127: sr_instance_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(),

Line 128: inventory_item_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(),

Line 129: parent_item_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(),

Line 130: organization_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(),

Line 131: fcst_organization_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(),
135: forecast_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 132: fcst_demand_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(),
136: consumed_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 133: sales_order_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(),
137: overconsumption_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 134: sales_order_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(),

Line 135: forecast_qty 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(),

Line 136: consumed_qty 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(),

Line 137: overconsumption_qty 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)

Line 138: bom_item_type 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)
142: -- or if model's forecast is overconsumed (1) or no forecast consumption (0).

Line 139: fixed_lt 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).
143: cons_config_mod_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

Line 140: variable_lt 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: );

Line 143: cons_config_mod_flag 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: );
145:
146: -- This record holds data resource_requirements
147: -- and corrsponding relief data.

Line 149: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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(),

Line 150: sr_instance_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(),

Line 151: organization_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(),

Line 152: inventory_item_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(),

Line 153: supply_id 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(),

Line 154: resource_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(),
158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 155: department_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(),
159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 156: resource_hours 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(),
160: relief_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 157: daily_resource_hours 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(),

Line 158: start_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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()

Line 159: end_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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: );

Line 160: relief_type 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: );
164:

Line 161: relief_quantity 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:
165: -- Bug 3750638

Line 162: daily_relief_qty 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
166: -- Fix for Multiple (N) Level of Config Items using Loop

Line 187: INVENTORY_ITEM_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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(),

Line 188: SR_INSTANCE_ID 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(),

Line 189: BASE_ITEM_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(),

Line 190: SALES_ORDER_LINE_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(),

Line 191: DEMAND_SOURCE_TYPE 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()

Line 192: END_DEMAND_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: );

Line 193: SUPPLY_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: );
197: -- End Bug 3750638

Line 194: PEGGING_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
198:

Line 195: END_PEGGING_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:
199: /* Procedures for CTO Re-architecture and Resource Capacity Enhancements */

Line 320: atp_peg_tab.reference_item_id := MRP_ATP_PUB.number_arr();

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();

Line 321: atp_peg_tab.base_item_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();

Line 322: atp_peg_tab.inventory_item_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();

Line 323: atp_peg_tab.plan_id := 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();

Line 324: atp_peg_tab.sr_instance_id := 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();

Line 325: atp_peg_tab.organization_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();
329: atp_peg_tab.sales_order_qty := MRP_ATP_PUB.number_arr();

Line 326: atp_peg_tab.bom_item_type := 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();

Line 327: atp_peg_tab.fixed_lt := 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

Line 328: atp_peg_tab.variable_lt := 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
332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_arr();

Line 329: atp_peg_tab.sales_order_qty := 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();
333: atp_peg_tab.demand_id := MRP_ATP_PUB.number_arr();

Line 330: atp_peg_tab.sales_order_line_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();

Line 331: atp_peg_tab.demand_source_type := MRP_ATP_PUB.number_arr();--cmro

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();

Line 332: atp_peg_tab.transaction_date := MRP_ATP_PUB.date_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();

Line 333: atp_peg_tab.demand_id := 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();
337: atp_peg_tab.consumed_qty := MRP_ATP_PUB.number_arr();

Line 334: atp_peg_tab.demand_quantity := 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();

Line 335: atp_peg_tab.disposition_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();
339: atp_peg_tab.supply_id := MRP_ATP_PUB.number_arr();

Line 336: atp_peg_tab.demand_class := MRP_ATP_PUB.char30_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();

Line 337: atp_peg_tab.consumed_qty := 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();

Line 338: atp_peg_tab.overconsumption_qty := 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();

Line 339: atp_peg_tab.supply_id := 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();

Line 340: atp_peg_tab.supply_quantity := 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();

Line 341: atp_peg_tab.allocated_quantity := 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();

Line 342: atp_peg_tab.tot_relief_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();
346: atp_peg_tab.daily_resource_hours := MRP_ATP_PUB.number_arr();

Line 343: atp_peg_tab.resource_id := 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();

Line 344: atp_peg_tab.department_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();
348: atp_peg_tab.end_date := MRP_ATP_PUB.date_arr();

Line 345: atp_peg_tab.resource_hours := 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();
349: atp_peg_tab.relief_type := MRP_ATP_PUB.number_arr();

Line 346: atp_peg_tab.daily_resource_hours := 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();

Line 347: atp_peg_tab.start_date := MRP_ATP_PUB.date_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();

Line 348: atp_peg_tab.end_date := MRP_ATP_PUB.date_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();

Line 349: atp_peg_tab.relief_type := 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();

Line 350: atp_peg_tab.relief_quantity := 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();

Line 351: atp_peg_tab.daily_relief_qty := 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.

Line 352: atp_peg_tab.end_pegging_id := MRP_ATP_PUB.number_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.
356: atp_peg_tab.end_demand_id := MRP_ATP_PUB.number_arr();

Line 353: atp_peg_tab.pegging_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

Line 354: atp_peg_tab.prev_pegging_id := 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
358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_arr();

Line 356: atp_peg_tab.end_demand_id := 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();
359: atp_peg_tab.product_family_id := MRP_ATP_PUB.number_arr();
360: -- Bug 3805136 -- Add end_item_usage to handle no forecast consumption.

Line 358: atp_peg_tab.atf_date := MRP_ATP_PUB.date_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.
361: atp_peg_tab.end_item_usage := MRP_ATP_PUB.number_arr();
362: -- Exclude flag helps in excluding supplies

Line 359: atp_peg_tab.product_family_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
363: -- during relef data calculation.

Line 361: atp_peg_tab.end_item_usage := 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.
364: atp_peg_tab.exclude_flag := MRP_ATP_PUB.number_arr();
365: -- End Bug 3805136

Line 364: atp_peg_tab.exclude_flag := 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
366:
367: IF PG_DEBUG in ('Y', 'C') THEN
368: msc_util.msc_log('***** End Init_Atp_Peg Procedure *****');

Line 1219: l_item_typ MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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:

Line 2832: atp_simple_peg_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

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);

Line 2847: l_original_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

Line 4702: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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: )

Line 4703: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 4704: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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;

Line 4712: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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();

Line 4713: l_demand_qty 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();

Line 4714: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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();

Line 4715: l_reference_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();

Line 4716: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_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();

Line 4717: l_organization_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();

Line 4718: l_inventory_item_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();

Line 4719: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_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();

Line 4720: l_customer_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();
4724:

Line 4721: l_customer_site_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:
4725: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4722: l_ship_to_site_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

Line 4723: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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
4727: -- For filtering out released/firmed supplies instead of disposition_id array.

Line 4725: l_offset_demand_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.
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();

Line 4728: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.

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;

Line 4729: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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;

Line 4734: l_so_line_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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

Line 4739: l_supply_id 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
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

Line 4740: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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.

Line 4741: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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;

Line 5232: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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: )

Line 5233: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5234: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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;

Line 5242: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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();

Line 5243: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_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();

Line 5244: l_organization_id 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();

Line 5245: l_inventory_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();

Line 5246: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_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();

Line 5247: l_supply_qty 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();

Line 5248: l_reference_item_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();

Line 5249: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_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();

Line 5250: l_supplier_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();

Line 5251: l_supplier_site_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();

Line 5252: l_src_supplier_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();

Line 5253: l_src_supplier_site_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();

Line 5254: l_src_instance_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();

Line 5255: l_src_org_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();

Line 5256: l_process_seq_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();
5260:

Line 5257: l_customer_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:
5261: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5258: l_ship_to_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();
5262: l_sysdate DATE;

Line 5259: l_firm_planned_type 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;
5263: l_user_id number;

Line 5261: l_offset_supply_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;
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();

Line 5264: l_dock_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;

Line 5265: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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:

Line 5271: l_orig_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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:

Line 5274: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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

Line 5686: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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: )

Line 5687: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5688: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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;

Line 5696: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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();

Line 5697: l_instance_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();

Line 5698: l_organization_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();

Line 5699: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_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();

Line 5700: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_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();

Line 5701: l_department_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();
5705: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5702: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_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();

Line 5703: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_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();

Line 5704: l_resource_hours 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;

Line 5705: l_daily_resource_hours 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;
5709:

Line 5706: l_load_rate 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:
5710: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5707: l_assigned_units 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();

Line 5708: l_std_op_code MRP_ATP_PUB.char10_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();

Line 5710: l_basis_type 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;

Line 5711: l_op_seq_num 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;
5715: l_user_id number;

Line 5712: l_parent_id 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;
5716:

Line 5957: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5958: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5959: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5960: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,

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

Line 5961: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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: )

Line 5962: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 5963: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

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:

Line 5968: l_inv_demand_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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;

Line 5969: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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();

Line 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************');

Line 6061: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

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,

Line 6062: --p_plan_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

Line 6063: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 6064: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

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: )

Line 6065: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 6066: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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;

Line 6205: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

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,

Line 6206: --p_plan_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

Line 6207: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 6208: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

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: )

Line 6209: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 6210: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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;

Line 6388: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

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,

Line 6389: --p_plan_ids 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

Line 6390: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 6391: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

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: )

Line 6392: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

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

Line 6393: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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;

Line 6469: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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,

Line 6470: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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,

Line 6471: p_inv_item_ids 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

Line 6472: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 6473: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

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

Line 6474: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

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

Line 6475: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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

Line 6476: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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: )

Line 6477: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

Line 6478: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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