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.

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: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563

Line 208: G_FW_CTP_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

204: G_ATP_COMP_FLAG VARCHAR2(1) := 'Y';
205: --This variable @ first pass on top level.
206: G_REQUESTED_SHIP_DATE DATE; --User entered value
207: G_FW_PEGGING_ID NUMBER; --Points to the ATP supply line pegging added during subsequent passes.
208: G_FW_CTP_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
209: --Points to the PO supply line pegging added during subsequent passes.
210: G_FW_STEAL_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
211: --Points to the Stealing line in forward pass.
212: G_FORWARD_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ENHANCED_FORWARD_ATP'), 'N');

Line 210: G_FW_STEAL_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

206: G_REQUESTED_SHIP_DATE DATE; --User entered value
207: G_FW_PEGGING_ID NUMBER; --Points to the ATP supply line pegging added during subsequent passes.
208: G_FW_CTP_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
209: --Points to the PO supply line pegging added during subsequent passes.
210: G_FW_STEAL_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
211: --Points to the Stealing line in forward pass.
212: G_FORWARD_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ENHANCED_FORWARD_ATP'), 'N');
213: --Profile to control which f/w pass we choose.
214: G_DEMAND_ID NUMBER; --5158454

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

442: RESOURCE_DEMAND CONSTANT NUMBER := 8;
443: RESOURCE_SUPPLY CONSTANT NUMBER := 9;
444:
445: -- For summary enhancement
446: G_COPY_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
447: G_COPY_DEMAND_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
448: --Global Variable Defined at this level just to avoid hardcoding for
449: --enhancment for Plan by request Date
450: G_SCHEDULE_SHIP_DATE_LEGEND CONSTANT NUMBER :=1;

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

443: RESOURCE_SUPPLY CONSTANT NUMBER := 9;
444:
445: -- For summary enhancement
446: G_COPY_DEMAND_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
447: G_COPY_DEMAND_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
448: --Global Variable Defined at this level just to avoid hardcoding for
449: --enhancment for Plan by request Date
450: G_SCHEDULE_SHIP_DATE_LEGEND CONSTANT NUMBER :=1;
451: G_SCHEDULE_ARRIVAL_DATE_LEGEND CONSTANT NUMBER :=2;

Line 483: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

479: --ALLOC ATP CHANGES -12973673
480: G_HYBRID_ALLOC_ATP VARCHAR(1) := LEAST(G_ORIG_ALLOC_ATP, Nvl(FND_Profile.value('MSC_HYBRID_ALLOC_ATP'),'N'));
481:
482: PROCEDURE Schedule (
483: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
484: p_instance_id IN NUMBER,
485: p_assign_set_id IN NUMBER,
486: p_refresh_number IN NUMBER,
487: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 487: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

483: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
484: p_instance_id IN NUMBER,
485: p_assign_set_id IN NUMBER,
486: p_refresh_number IN NUMBER,
487: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
488: x_return_status OUT NoCopy VARCHAR2,
489: x_msg_data OUT NoCopy VARCHAR2,
490: x_msg_count OUT NoCopy NUMBER,
491: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 491: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

487: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
488: x_return_status OUT NoCopy VARCHAR2,
489: x_msg_data OUT NoCopy VARCHAR2,
490: x_msg_count OUT NoCopy NUMBER,
491: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
492: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
493: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
494: );
495:

Line 492: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

488: x_return_status OUT NoCopy VARCHAR2,
489: x_msg_data OUT NoCopy VARCHAR2,
490: x_msg_count OUT NoCopy NUMBER,
491: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
492: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
493: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
494: );
495:
496: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

Line 493: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

489: x_msg_data OUT NoCopy VARCHAR2,
490: x_msg_count OUT NoCopy NUMBER,
491: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
492: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
493: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
494: );
495:
496: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
497: p_plan_id IN NUMBER,

Line 504: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

500: p_search IN NUMBER,
501: p_refresh_number IN NUMBER,
502: p_parent_pegging_id IN NUMBER,
503: p_assign_set_id IN NUMBER,
504: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
505: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
506: x_return_status OUT NoCopy VARCHAR2,
507: p_pre_processing_lead_time IN NUMBER :=0
508: );

Line 505: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

501: p_refresh_number IN NUMBER,
502: p_parent_pegging_id IN NUMBER,
503: p_assign_set_id IN NUMBER,
504: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
505: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
506: x_return_status OUT NoCopy VARCHAR2,
507: p_pre_processing_lead_time IN NUMBER :=0
508: );
509:

Line 513: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

509:
510:
511: PROCEDURE Call_Schedule (
512: p_session_id IN NUMBER,
513: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
514: p_instance_id IN NUMBER,
515: p_assign_set_id IN NUMBER,
516: p_refresh_number IN NUMBER,
517: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 517: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

513: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
514: p_instance_id IN NUMBER,
515: p_assign_set_id IN NUMBER,
516: p_refresh_number IN NUMBER,
517: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
518: x_return_status OUT NoCopy VARCHAR2,
519: x_msg_data OUT NoCopy VARCHAR2,
520: x_msg_count OUT NoCopy NUMBER,
521: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 521: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

517: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
518: x_return_status OUT NoCopy VARCHAR2,
519: x_msg_data OUT NoCopy VARCHAR2,
520: x_msg_count OUT NoCopy NUMBER,
521: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
522: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
523: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
524: );
525:

Line 522: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

518: x_return_status OUT NoCopy VARCHAR2,
519: x_msg_data OUT NoCopy VARCHAR2,
520: x_msg_count OUT NoCopy NUMBER,
521: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
522: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
523: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
524: );
525:
526: -- p_inv_ctp added in argument of call_schedule_remote

Line 523: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

519: x_msg_data OUT NoCopy VARCHAR2,
520: x_msg_count OUT NoCopy NUMBER,
521: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
522: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
523: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
524: );
525:
526: -- p_inv_ctp added in argument of call_schedule_remote
527: -- for bug 2368426 to match source and destination INV_CTP

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

544: p_node_id IN NUMBER DEFAULT null --bug3520746
545: -- p_use_ship_rec IN VARCHAR2 DEFAULT 'N' --bug3593394 --bug3940999
546: );
547:
548: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
549: i NUMBER);--4460369
550:
551: --optional_fw
552: /*--GET_SEQ_NUM-------------------------------------------------