DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MRP_ATP_PUB

Line 17: REMOVE_PEGGING_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),

13: -- These will be used to call remove_invalid_sd_rec() and delete_row()
14: -- procedures at request level in case of ATP_Inquiry
15:
16: TYPE REMOVE_REQUEST_LEVEL_REC IS RECORD (
17: REMOVE_PEGGING_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
18: REMOVE_PLAN_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
19: REMOVE_DC_ATP_FLAG_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr()
20: );
21:

Line 18: REMOVE_PLAN_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),

14: -- procedures at request level in case of ATP_Inquiry
15:
16: TYPE REMOVE_REQUEST_LEVEL_REC IS RECORD (
17: REMOVE_PEGGING_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
18: REMOVE_PLAN_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
19: REMOVE_DC_ATP_FLAG_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr()
20: );
21:
22: --3720018, new record type for returning records from call_delete_row .

Line 19: REMOVE_DC_ATP_FLAG_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr()

15:
16: TYPE REMOVE_REQUEST_LEVEL_REC IS RECORD (
17: REMOVE_PEGGING_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
18: REMOVE_PLAN_ID_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr(),
19: REMOVE_DC_ATP_FLAG_REQUEST MRP_ATP_PUB.NUMBER_ARR := MRP_ATP_PUB.number_arr()
20: );
21:
22: --3720018, new record type for returning records from call_delete_row .
23: TYPE DELETE_ATP_REC IS RECORD (

Line 25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

21:
22: --3720018, new record type for returning records from call_delete_row .
23: TYPE DELETE_ATP_REC IS RECORD (
24: time_phased_set VARCHAR2(1),
25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),

22: --3720018, new record type for returning records from call_delete_row .
23: TYPE DELETE_ATP_REC IS RECORD (
24: time_phased_set VARCHAR2(1),
25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

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

23: TYPE DELETE_ATP_REC IS RECORD (
24: time_phased_set VARCHAR2(1),
25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

24: time_phased_set VARCHAR2(1),
25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

25: error_code MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),

Line 30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

26: attribute_07 MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),

Line 31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

27: old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

28: del_demand_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),

29: del_inv_item_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),

30: del_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

31: del_identifiers MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

32: del_demand_source_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

33: del_copy_demand_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

34: del_copy_demand_plan_ids mrp_atp_pub.number_arr := MRP_ATP_PUB.number_arr(),
35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

35: del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

36: del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

Line 41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

37: del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

38: del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

39: atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),

40: atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

41: atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

42: off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

43: off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

Line 48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

44: off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(),
45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS

Line 49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

45: del_ods_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS
53: );

Line 50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

46: del_ods_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS
53: );
54: ----3720018

Line 51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS

47: del_ods_demand_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS
53: );
54: ----3720018
55:

Line 52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS

48: del_ods_cto_demand_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
49: del_ods_cto_inv_item_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
50: del_ods_cto_dem_src_type MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
51: del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr(), --3720018, added for support of rescheduling in ODS
52: del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.number_arr() --3720018, added for support of rescheduling in ODS
53: );
54: ----3720018
55:
56: TYPE item_attribute_rec IS RECORD (

Line 172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

168: -- Supplier Capacity Lead Time (SCLT) project.
169: G_PLAN_INFO_REC plan_info_rec;
170:
171: G_FIND_FUTURE_DATE VARCHAR2(1) := 'N';
172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;

Line 173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

169: G_PLAN_INFO_REC plan_info_rec;
170:
171: G_FIND_FUTURE_DATE VARCHAR2(1) := 'N';
172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');

Line 174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

170:
171: G_FIND_FUTURE_DATE VARCHAR2(1) := 'N';
172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

Line 175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

171: G_FIND_FUTURE_DATE VARCHAR2(1) := 'N';
172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
179: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.

Line 430: G_COPY_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

426: RESOURCE_DEMAND CONSTANT NUMBER := 8;
427: RESOURCE_SUPPLY CONSTANT NUMBER := 9;
428:
429: -- For summary enhancement
430: G_COPY_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
431: G_COPY_DEMAND_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
432: --Global Variable Defined at this level just to avoid hardcoding for
433: --enhancment for Plan by request Date
434: G_SCHEDULE_SHIP_DATE_LEGEND CONSTANT NUMBER :=1;

Line 431: G_COPY_DEMAND_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

427: RESOURCE_SUPPLY CONSTANT NUMBER := 9;
428:
429: -- For summary enhancement
430: G_COPY_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
431: G_COPY_DEMAND_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
432: --Global Variable Defined at this level just to avoid hardcoding for
433: --enhancment for Plan by request Date
434: G_SCHEDULE_SHIP_DATE_LEGEND CONSTANT NUMBER :=1;
435: G_SCHEDULE_ARRIVAL_DATE_LEGEND CONSTANT NUMBER :=2;

Line 464: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

460:
461:
462:
463: PROCEDURE Schedule (
464: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
465: p_instance_id IN NUMBER,
466: p_assign_set_id IN NUMBER,
467: p_refresh_number IN NUMBER,
468: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 468: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

464: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
465: p_instance_id IN NUMBER,
466: p_assign_set_id IN NUMBER,
467: p_refresh_number IN NUMBER,
468: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER,
472: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 472: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

468: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER,
472: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
473: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
474: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
475: );
476:

Line 473: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER,
472: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
473: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
474: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
475: );
476:
477: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

Line 474: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER,
472: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
473: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
474: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
475: );
476:
477: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
478: p_plan_id IN NUMBER,

Line 485: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

481: p_search IN NUMBER,
482: p_refresh_number IN NUMBER,
483: p_parent_pegging_id IN NUMBER,
484: p_assign_set_id IN NUMBER,
485: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
486: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
487: x_return_status OUT NoCopy VARCHAR2,
488: p_pre_processing_lead_time IN NUMBER :=0
489: );

Line 486: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

482: p_refresh_number IN NUMBER,
483: p_parent_pegging_id IN NUMBER,
484: p_assign_set_id IN NUMBER,
485: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
486: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
487: x_return_status OUT NoCopy VARCHAR2,
488: p_pre_processing_lead_time IN NUMBER :=0
489: );
490:

Line 494: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

490:
491:
492: PROCEDURE Call_Schedule (
493: p_session_id IN NUMBER,
494: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
495: p_instance_id IN NUMBER,
496: p_assign_set_id IN NUMBER,
497: p_refresh_number IN NUMBER,
498: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 498: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

494: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
495: p_instance_id IN NUMBER,
496: p_assign_set_id IN NUMBER,
497: p_refresh_number IN NUMBER,
498: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
499: x_return_status OUT NoCopy VARCHAR2,
500: x_msg_data OUT NoCopy VARCHAR2,
501: x_msg_count OUT NoCopy NUMBER,
502: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 502: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

498: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
499: x_return_status OUT NoCopy VARCHAR2,
500: x_msg_data OUT NoCopy VARCHAR2,
501: x_msg_count OUT NoCopy NUMBER,
502: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
503: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
504: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
505: );
506:

Line 503: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

499: x_return_status OUT NoCopy VARCHAR2,
500: x_msg_data OUT NoCopy VARCHAR2,
501: x_msg_count OUT NoCopy NUMBER,
502: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
503: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
504: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
505: );
506:
507: -- p_inv_ctp added in argument of call_schedule_remote

Line 504: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

500: x_msg_data OUT NoCopy VARCHAR2,
501: x_msg_count OUT NoCopy NUMBER,
502: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
503: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
504: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
505: );
506:
507: -- p_inv_ctp added in argument of call_schedule_remote
508: -- for bug 2368426 to match source and destination INV_CTP

Line 529: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

525: p_node_id IN NUMBER DEFAULT null --bug3520746
526: -- p_use_ship_rec IN VARCHAR2 DEFAULT 'N' --bug3593394 --bug3940999
527: );
528:
529: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
530: i NUMBER);--4460369
531:
532: END MSC_ATP_PVT;