eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 2834: atp_simple_peg_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

2830: l_user_id number;
2831: l_table_name VARCHAR2(30);
2832: l_tbspace VARCHAR2(30);
2833: l_temp_table VARCHAR2(30);
2834: atp_simple_peg_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
2835: 'ATP_PEGGING');
2836: l_share_partition VARCHAR2(1);
2837: l_plan_id NUMBER;
2838: l_plan_name varchar2(10);

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

2845: l_pegging_id NUMBER;
2846:
2847: -- Bug 3362558 Store the original_demand_id
2848: -- CTO_PF_PRJ. This array is not needed anymore.
2849: l_original_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2850: -- CTO-PF
2851: l_time_phased_atp VARCHAR2(1) := 'N';
2852: -- This cursor fetches the list of configuration_items.
2853: CURSOR config_items IS

Line 4716: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

4712: p_plan_id IN NUMBER,
4713: p_refresh_number IN NUMBER,
4714: p_order_number IN NUMBER,
4715: p_demand_source_type IN NUMBER,--cmro
4716: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4717: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4718: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4719: x_return_status IN OUT NoCopy VARCHAR2
4720: )

Line 4717: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

4713: p_refresh_number IN NUMBER,
4714: p_order_number IN NUMBER,
4715: p_demand_source_type IN NUMBER,--cmro
4716: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4717: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4718: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4719: x_return_status IN OUT NoCopy VARCHAR2
4720: )
4721: IS

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

4714: p_order_number IN NUMBER,
4715: p_demand_source_type IN NUMBER,--cmro
4716: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4717: x_demand_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
4718: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
4719: x_return_status IN OUT NoCopy VARCHAR2
4720: )
4721: IS
4722: l_del_rows NUMBER;

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

4722: l_del_rows NUMBER;
4723: i PLS_INTEGER;
4724: my_sqlcode NUMBER;
4725:
4726: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4723: i PLS_INTEGER;
4724: my_sqlcode NUMBER;
4725:
4726: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

4724: my_sqlcode NUMBER;
4725:
4726: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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

4725:
4726: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

Line 4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4726: l_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4727: l_demand_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4728: l_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

4729: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

4730: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4738:

Line 4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4731: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4738:
4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4732: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4738:
4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: -- Bug 3890723 Introduce a pegging_id array to track pegging

Line 4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

4733: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4734: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4738:
4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: -- Bug 3890723 Introduce a pegging_id array to track pegging
4741: -- For filtering out released/firmed supplies instead of disposition_id array.

Line 4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

4735: l_customer_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4736: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4737: l_dmd_satisfied_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4738:
4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: -- Bug 3890723 Introduce a pegging_id array to track pegging
4741: -- For filtering out released/firmed supplies instead of disposition_id array.
4742: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4743: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

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

4738:
4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: -- Bug 3890723 Introduce a pegging_id array to track pegging
4741: -- For filtering out released/firmed supplies instead of disposition_id array.
4742: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4743: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4744: -- End Bug 3890723
4745:
4746: l_sysdate DATE;

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

4739: l_offset_demand_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4740: -- Bug 3890723 Introduce a pegging_id array to track pegging
4741: -- For filtering out released/firmed supplies instead of disposition_id array.
4742: l_disposition_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); -- Array retained as FYI for demand offsets.
4743: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4744: -- End Bug 3890723
4745:
4746: l_sysdate DATE;
4747: l_user_id number;

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

4744: -- End Bug 3890723
4745:
4746: l_sysdate DATE;
4747: l_user_id number;
4748: l_so_line_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4749:
4750: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4751: l_offset_type NUMBER;
4752: -- CTO_PF_PRJ_2 Impacts

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

4749:
4750: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4751: l_offset_type NUMBER;
4752: -- CTO_PF_PRJ_2 Impacts
4753: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4754: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4755: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4756: -- End CTO_PF_PRJ_2 Impacts
4757: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands

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

4750: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
4751: l_offset_type NUMBER;
4752: -- CTO_PF_PRJ_2 Impacts
4753: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4754: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4755: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4756: -- End CTO_PF_PRJ_2 Impacts
4757: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands
4758: -- that are pegged to supplies that can be relieved.

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

4751: l_offset_type NUMBER;
4752: -- CTO_PF_PRJ_2 Impacts
4753: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4754: l_original_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
4755: l_original_demand_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
4756: -- End CTO_PF_PRJ_2 Impacts
4757: -- Bug 3717618 Add supply offset type var. for limiting adjustment to demands
4758: -- that are pegged to supplies that can be relieved.
4759: l_sup_offset_type NUMBER;

Line 5246: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

5242: p_plan_id IN NUMBER,
5243: p_refresh_number IN NUMBER,
5244: p_order_number IN NUMBER,
5245: p_demand_source_type IN NUMBER,--cmro
5246: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5247: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5248: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5249: x_return_status IN OUT NoCopy VARCHAR2
5250: )

Line 5247: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

5243: p_refresh_number IN NUMBER,
5244: p_order_number IN NUMBER,
5245: p_demand_source_type IN NUMBER,--cmro
5246: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5247: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5248: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5249: x_return_status IN OUT NoCopy VARCHAR2
5250: )
5251: IS

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

5244: p_order_number IN NUMBER,
5245: p_demand_source_type IN NUMBER,--cmro
5246: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5247: x_supply_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5248: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5249: x_return_status IN OUT NoCopy VARCHAR2
5250: )
5251: IS
5252: l_del_rows NUMBER;

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

5252: l_del_rows NUMBER;
5253: i PLS_INTEGER;
5254: my_sqlcode NUMBER;
5255:
5256: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5253: i PLS_INTEGER;
5254: my_sqlcode NUMBER;
5255:
5256: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5254: my_sqlcode NUMBER;
5255:
5256: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5255:
5256: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

Line 5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

5256: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5257: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5258: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

5259: l_inventory_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5260: l_supply_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5261: l_supply_qty MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5262: l_reference_item_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5263: l_demand_class MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5264: l_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5265: l_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5266: l_src_supplier_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5274:

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

5267: l_src_supplier_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5274:
5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5268: l_src_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5274:
5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5276: l_sysdate DATE;

Line 5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5269: l_src_org_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5270: l_process_seq_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5274:
5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5276: l_sysdate DATE;
5277: l_user_id number;

Line 5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5271: l_customer_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5272: l_ship_to_site_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5273: l_firm_planned_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5274:
5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5276: l_sysdate DATE;
5277: l_user_id number;
5278: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5279: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 5278: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

5274:
5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5276: l_sysdate DATE;
5277: l_user_id number;
5278: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5279: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5280:
5281: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5282: l_offset_type NUMBER := NULL;

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

5275: l_offset_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5276: l_sysdate DATE;
5277: l_user_id number;
5278: l_dock_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5279: l_ship_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
5280:
5281: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5282: l_offset_type NUMBER := NULL;
5283:

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

5281: -- Bug 3344102 A variable/handle for processing reliefs/offsets.
5282: l_offset_type NUMBER := NULL;
5283:
5284: -- Bug 3381464 Array to track original supplies for updating msc_atp_pegging
5285: l_orig_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5286: -- Bug 3717618 Introduce a pegging_id array to track pegging
5287: -- For filtering out released/firmed supplies and pegging both are needed.
5288: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5289:

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

5284: -- Bug 3381464 Array to track original supplies for updating msc_atp_pegging
5285: l_orig_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5286: -- Bug 3717618 Introduce a pegging_id array to track pegging
5287: -- For filtering out released/firmed supplies and pegging both are needed.
5288: l_pegging_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5289:
5290: BEGIN
5291:
5292: IF PG_DEBUG in ('Y', 'C') THEN

Line 5700: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

5696: p_plan_id IN NUMBER,
5697: p_refresh_number IN NUMBER,
5698: p_order_number IN NUMBER,
5699: p_demand_source_type IN NUMBER,--cmro
5700: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5701: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5702: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5703: x_return_status IN OUT NoCopy VARCHAR2
5704: )

Line 5701: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,

5697: p_refresh_number IN NUMBER,
5698: p_order_number IN NUMBER,
5699: p_demand_source_type IN NUMBER,--cmro
5700: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5701: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5702: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5703: x_return_status IN OUT NoCopy VARCHAR2
5704: )
5705: IS

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

5698: p_order_number IN NUMBER,
5699: p_demand_source_type IN NUMBER,--cmro
5700: x_inv_item_id IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5701: x_res_transactions IN OUT NoCopy MRP_ATP_PUB.Number_Arr,
5702: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5703: x_return_status IN OUT NoCopy VARCHAR2
5704: )
5705: IS
5706: l_del_rows NUMBER;

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

5706: l_del_rows NUMBER;
5707: i PLS_INTEGER;
5708: my_sqlcode NUMBER;
5709:
5710: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5707: i PLS_INTEGER;
5708: my_sqlcode NUMBER;
5709:
5710: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5708: my_sqlcode NUMBER;
5709:
5710: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();

Line 5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5709:
5710: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();

Line 5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5710: l_supply_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5711: l_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();

5712: l_organization_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();

5713: l_resource_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5714: l_resource_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;

Line 5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5715: l_department_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:

Line 5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5716: l_start_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5717: l_end_date MRP_ATP_PUB.Date_Arr := MRP_ATP_PUB.Date_Arr();
5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5722: l_std_op_code MRP_ATP_PUB.char10_arr;

5718: l_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5719: l_daily_resource_hours MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5726: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5720: l_load_rate MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5726: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5727:
5728: l_sysdate DATE;

Line 5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5721: l_assigned_units MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5726: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5727:
5728: l_sysdate DATE;
5729: l_user_id number;

Line 5726: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5722: l_std_op_code MRP_ATP_PUB.char10_arr;
5723:
5724: l_basis_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5725: l_op_seq_num MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5726: l_parent_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5727:
5728: l_sysdate DATE;
5729: l_user_id number;
5730:

Line 5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

5967: p_plan_id IN NUMBER,
5968: p_refresh_number IN NUMBER,
5969: p_order_number IN NUMBER,
5970: p_demand_source_type IN NUMBER,--cmro
5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

5968: p_refresh_number IN NUMBER,
5969: p_order_number IN NUMBER,
5970: p_demand_source_type IN NUMBER,--cmro
5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,

5969: p_order_number IN NUMBER,
5970: p_demand_source_type IN NUMBER,--cmro
5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5977: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,

5970: p_demand_source_type IN NUMBER,--cmro
5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5977: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5978: x_return_status OUT NoCopy VARCHAR2

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

5971: x_inv_item_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5977: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5978: x_return_status OUT NoCopy VARCHAR2
5979: )

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

5972: x_demand_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5977: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5978: x_return_status OUT NoCopy VARCHAR2
5979: )
5980: IS

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

5973: x_supply_id OUT NoCopy MRP_ATP_PUB.Number_Arr,
5974: x_res_transactions OUT NoCopy MRP_ATP_PUB.Number_Arr,
5975: x_demand_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5976: x_supply_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5977: x_res_instance_id OUT NoCopy MRP_ATP_PUB.Number_Arr, --Bug 3629191
5978: x_return_status OUT NoCopy VARCHAR2
5979: )
5980: IS
5981:

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

5978: x_return_status OUT NoCopy VARCHAR2
5979: )
5980: IS
5981:
5982: l_inv_demand_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5983: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5984: j PLS_INTEGER;
5985: i PLS_INTEGER;
5986: match_found NUMBER;

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

5979: )
5980: IS
5981:
5982: l_inv_demand_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5983: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5984: j PLS_INTEGER;
5985: i PLS_INTEGER;
5986: match_found NUMBER;
5987: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 5987: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

5983: l_inv_supply_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5984: j PLS_INTEGER;
5985: i PLS_INTEGER;
5986: match_found NUMBER;
5987: l_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5988: BEGIN
5989:
5990: IF PG_DEBUG in ('Y', 'C') THEN
5991: msc_sch_wb.atp_debug('**********Begin Add_Offset_Data Procedure************');

Line 6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

6071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6072: END Add_Offset_Data;
6073:
6074: PROCEDURE Remove_Offset_Demands (
6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

Line 6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,

6072: END Add_Offset_Data;
6073:
6074: PROCEDURE Remove_Offset_Demands (
6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6080: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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

6073:
6074: PROCEDURE Remove_Offset_Demands (
6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6080: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6081: x_return_status IN OUT NoCopy VARCHAR2

Line 6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

6074: PROCEDURE Remove_Offset_Demands (
6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6080: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6081: x_return_status IN OUT NoCopy VARCHAR2
6082: )

Line 6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

6075: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6080: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6081: x_return_status IN OUT NoCopy VARCHAR2
6082: )
6083: IS

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

6076: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6077: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6078: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6079: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6080: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6081: x_return_status IN OUT NoCopy VARCHAR2
6082: )
6083: IS
6084: l_del_rows NUMBER;

Line 6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

6215:
6216: END Remove_Offset_Demands;
6217:
6218: PROCEDURE Remove_Offset_Supplies (
6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

Line 6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,

6216: END Remove_Offset_Demands;
6217:
6218: PROCEDURE Remove_Offset_Supplies (
6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6224: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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

6217:
6218: PROCEDURE Remove_Offset_Supplies (
6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6224: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6225: x_return_status IN OUT NoCopy VARCHAR2

Line 6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

6218: PROCEDURE Remove_Offset_Supplies (
6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6224: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6225: x_return_status IN OUT NoCopy VARCHAR2
6226: )

Line 6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

6219: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6224: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6225: x_return_status IN OUT NoCopy VARCHAR2
6226: )
6227: IS

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

6220: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6221: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6222: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6223: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6224: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6225: x_return_status IN OUT NoCopy VARCHAR2
6226: )
6227: IS
6228: l_del_rows NUMBER;

Line 6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,

6398: END Remove_Offset_Supplies;
6399:
6400:
6401: PROCEDURE Remove_Offset_Resource_Reqs (
6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

Line 6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,

6399:
6400:
6401: PROCEDURE Remove_Offset_Resource_Reqs (
6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6407: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

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

6400:
6401: PROCEDURE Remove_Offset_Resource_Reqs (
6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6407: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6408: x_return_status IN OUT NoCopy VARCHAR2

Line 6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

6401: PROCEDURE Remove_Offset_Resource_Reqs (
6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6407: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6408: x_return_status IN OUT NoCopy VARCHAR2
6409: )

Line 6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

6402: --p_identifiers IN MRP_ATP_PUB.Number_Arr,
6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6407: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6408: x_return_status IN OUT NoCopy VARCHAR2
6409: )
6410: IS

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

6403: --p_plan_ids IN MRP_ATP_PUB.Number_Arr,
6404: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6405: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6406: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6407: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6408: x_return_status IN OUT NoCopy VARCHAR2
6409: )
6410: IS
6411: l_del_rows NUMBER;

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

6479:
6480: END Remove_Offset_Resource_Reqs;
6481:
6482: PROCEDURE Remove_Offset_Data (
6483: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

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

6480: END Remove_Offset_Resource_Reqs;
6481:
6482: PROCEDURE Remove_Offset_Data (
6483: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

Line 6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,

6481:
6482: PROCEDURE Remove_Offset_Data (
6483: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro

Line 6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,

6482: PROCEDURE Remove_Offset_Data (
6483: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,

6483: --p_identifiers IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

Line 6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,

6484: --p_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6492: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191

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

6485: p_inv_item_ids IN MRP_ATP_PUB.Number_Arr,
6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6492: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6493: x_return_status OUT NoCopy VARCHAR2

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

6486: p_del_demand_ids IN MRP_ATP_PUB.Number_Arr,
6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6492: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6493: x_return_status OUT NoCopy VARCHAR2
6494: )

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

6487: p_del_supply_ids IN MRP_ATP_PUB.Number_Arr,
6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6492: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6493: x_return_status OUT NoCopy VARCHAR2
6494: )
6495: IS

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

6488: p_del_resrc_reqs IN MRP_ATP_PUB.Number_Arr,
6489: p_demand_source_type IN MRP_ATP_PUB.Number_Arr,--cmro
6490: p_atp_peg_demands_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6491: p_atp_peg_supplies_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6492: p_atp_peg_res_reqs_plan_ids IN MRP_ATP_PUB.Number_Arr, --Bug 3629191
6493: x_return_status OUT NoCopy VARCHAR2
6494: )
6495: IS
6496: BEGIN