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:
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 .
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 (
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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(),
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
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
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
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
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
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
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
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
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: );
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
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:
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 (
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') ;
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');
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');
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.
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;
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;
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,
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,
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:
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,
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,
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: );
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:
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,
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,
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:
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
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
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;