DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on MRP_ATP_PUB

Line 84: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

80: -- 1- Full refresh on Sales Orders -- ATP is not available
81: -- 2- Full refresh on supply/demands-- ATP is available
82: -- 3- Full refresh on both S/O and S/D -- ATP is not available
83:
84: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
85: 'ATP_SUMMARY_SO',
86: 'ATP_SUMMARY_SD');
87: l_instance_id number;
88: i number;

Line 89: l_org_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

85: 'ATP_SUMMARY_SO',
86: 'ATP_SUMMARY_SD');
87: l_instance_id number;
88: i number;
89: l_org_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
90: i integer;
91: l_sql_stmt varchar2(3000);
92: l_sql_stmt_1 varchar2(3000);
93: l_applsys_schema varchar2(10);

Line 659: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

655: l_count number;
656: l_sysdate date;
657: l_user_id number;
658: l_alloc_atp VARCHAR2(1);
659: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
660: 'ATP_SUMMARY_SD',
661: 'ATP_SUMMARY_RES',
662: 'ATP_SUMMARY_SUP');
663: -- Bug 2516506

Line 693: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

689: -- summary enhancement
690: l_plan_start_date date;
691: -- IO Perf:3693983: Don't Launch ATP Post Plan Processes for IO Plans
692: l_plan_type NUMBER := 0;
693: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
694: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
695: j pls_integer;
696: l_is_cmro number := 0; --bug 7209209
697: BEGIN

Line 694: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

690: l_plan_start_date date;
691: -- IO Perf:3693983: Don't Launch ATP Post Plan Processes for IO Plans
692: l_plan_type NUMBER := 0;
693: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
694: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
695: j pls_integer;
696: l_is_cmro number := 0; --bug 7209209
697: BEGIN
698: msc_util.msc_log ('LOAD_PLAN_SD: ' || 'Calling Module: ' || p_calling_module);

Line 3423: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

3419: p_owner IN VARCHAR2,
3420: p_ret_code OUT NoCopy NUMBER,
3421: p_err_msg OUT NoCopy VARCHAR2)
3422: AS
3423: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
3424: 'ATP_SUMMARY_SD',
3425: 'ATP_SUMMARY_RES',
3426: 'ATP_SUMMARY_SUP');
3427: i NUMBER;

Line 3553: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

3549: p_owner IN VARCHAR2,
3550: p_ret_code OUT NoCopy NUMBER,
3551: p_err_msg OUT NoCopy VARCHAR2)
3552: AS
3553: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
3554: 'ATP_SUMMARY_SD',
3555: 'ATP_SUMMARY_SO');
3556: i NUMBER;
3557: l_partition_name VARCHAR2(30);

Line 3657: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

3653: PROCEDURE CREATE_PARTITIONS( ERRBUF OUT NoCopy VARCHAR2,
3654: RETCODE OUT NoCopy NUMBER)
3655: AS
3656:
3657: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
3658: 'ATP_SUMMARY_SO',
3659: 'ATP_SUMMARY_SD',
3660: 'ATP_SUMMARY_RES',
3661: 'ATP_SUMMARY_SUP',

Line 3674: INSTANCE_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

3670: l_summary_flag varchar2(30);
3671: l_higher_instance number;
3672: l_sql_stmt varchar2(1000);
3673: l_table_name varchar2(30);
3674: INSTANCE_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3675: PLAN_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3676: l_applsys_schema varchar2(10);
3677: l_msc_schema VARCHAR2(30);
3678: l_retval BOOLEAN;

Line 3675: PLAN_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

3671: l_higher_instance number;
3672: l_sql_stmt varchar2(1000);
3673: l_table_name varchar2(30);
3674: INSTANCE_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3675: PLAN_IDS MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
3676: l_applsys_schema varchar2(10);
3677: l_msc_schema VARCHAR2(30);
3678: l_retval BOOLEAN;
3679: dummy1 varchar2(10);

Line 4101: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(

4097: l_sql_stmt_1 VARCHAR2(8000);
4098: l_table_name VARCHAR2(30);
4099: l_tbspace VARCHAR2(30);
4100: l_temp_table VARCHAR2(30);
4101: atp_summ_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(
4102: 'ALLOC_DEMANDS',
4103: 'ALLOC_SUPPLIES');
4104: -- Bug 2516506
4105: l_plan_name varchar2(10);

Line 6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

6558: p_last_refresh_number IN NUMBER,
6559: p_new_refresh_number IN NUMBER,
6560: p_sys_date IN DATE)
6561: IS
6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

6559: p_new_refresh_number IN NUMBER,
6560: p_sys_date IN DATE)
6561: IS
6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;

6560: p_sys_date IN DATE)
6561: IS
6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;

6561: IS
6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6566: l_sd_date_tab MRP_ATP_PUB.date_arr;

6562: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

6563: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6564: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6565: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6566: l_sd_date_tab MRP_ATP_PUB.date_arr;
6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6574:

Line 6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6567: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6574:
6575: -- ATPR4drp

Line 6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

6568: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6574:
6575: -- ATPR4drp
6576: l_plan_type NUMBER;

Line 6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6569: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6570: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6571: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6572: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6573: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6574:
6575: -- ATPR4drp
6576: l_plan_type NUMBER;
6577: BEGIN

Line 7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7345: p_sys_date IN DATE)
7346: IS
7347: l_user_id number;
7348: j pls_integer;
7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7350: l_organization_id_tab MRP_ATP_PUB.number_arr;

7346: IS
7347: l_user_id number;
7348: j pls_integer;
7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7347: l_user_id number;
7348: j pls_integer;
7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7352: l_sd_date_tab MRP_ATP_PUB.date_arr;

7348: j pls_integer;
7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7349: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7350: l_organization_id_tab MRP_ATP_PUB.number_arr;
7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7351: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7359:

Line 7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7352: l_sd_date_tab MRP_ATP_PUB.date_arr;
7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7359:
7360: CURSOR c_net_sd (p_plan_id IN NUMBER,

Line 7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

7353: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7359:
7360: CURSOR c_net_sd (p_plan_id IN NUMBER,
7361: p_last_refresh_number IN NUMBER,

Line 7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7354: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7355: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7356: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7357: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7358: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7359:
7360: CURSOR c_net_sd (p_plan_id IN NUMBER,
7361: p_last_refresh_number IN NUMBER,
7362: p_new_refresh_number IN NUMBER)

Line 7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7606: p_sys_date IN DATE)
7607: IS
7608: l_user_id number;
7609: j pls_integer;
7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 7611: l_organization_id_tab MRP_ATP_PUB.number_arr;

7607: IS
7608: l_user_id number;
7609: j pls_integer;
7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7608: l_user_id number;
7609: j pls_integer;
7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:

Line 7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;

7609: j pls_integer;
7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7614: l_sd_date_tab MRP_ATP_PUB.date_arr;

7610: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7611: l_organization_id_tab MRP_ATP_PUB.number_arr;
7612: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7613: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7614: l_sd_date_tab MRP_ATP_PUB.date_arr;
7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7615: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7623:

Line 7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

7616:
7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7623:
7624: CURSOR c_net_sd (p_plan_id IN NUMBER,

Line 7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

7617: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7623:
7624: CURSOR c_net_sd (p_plan_id IN NUMBER,
7625: p_last_refresh_number IN NUMBER,

Line 7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7618: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7619: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7620: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7621: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7622: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7623:
7624: CURSOR c_net_sd (p_plan_id IN NUMBER,
7625: p_last_refresh_number IN NUMBER,
7626: p_new_refresh_number IN NUMBER)

Line 7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7964: p_sys_date IN DATE)
7965: IS
7966: l_user_id number;
7967: j pls_integer;
7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7965: IS
7966: l_user_id number;
7967: j pls_integer;
7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;

7966: l_user_id number;
7967: j pls_integer;
7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:

Line 7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;

7967: j pls_integer;
7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7972: l_sd_date_tab MRP_ATP_PUB.date_arr;

7968: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7969: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7970: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7971: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7972: l_sd_date_tab MRP_ATP_PUB.date_arr;
7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7973: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7981:

Line 7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7974:
7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7981:
7982: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because

Line 7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

7975: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7981:
7982: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7983: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs

Line 7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

7976: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7977: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7981:
7982: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7983: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
7984: p_new_refresh_number IN NUMBER)

Line 8660: l_department_id_tab MRP_ATP_PUB.number_arr;

8656: p_sys_date IN DATE)
8657: IS
8658: l_user_id number;
8659: j pls_integer;
8660: l_department_id_tab MRP_ATP_PUB.number_arr;
8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 8661: l_resource_id_tab MRP_ATP_PUB.number_arr;

8657: IS
8658: l_user_id number;
8659: j pls_integer;
8660: l_department_id_tab MRP_ATP_PUB.number_arr;
8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 8662: l_organization_id_tab MRP_ATP_PUB.number_arr;

8658: l_user_id number;
8659: j pls_integer;
8660: l_department_id_tab MRP_ATP_PUB.number_arr;
8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:

Line 8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

8659: j pls_integer;
8660: l_department_id_tab MRP_ATP_PUB.number_arr;
8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8664: l_sd_date_tab MRP_ATP_PUB.date_arr;

8660: l_department_id_tab MRP_ATP_PUB.number_arr;
8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

8661: l_resource_id_tab MRP_ATP_PUB.number_arr;
8662: l_organization_id_tab MRP_ATP_PUB.number_arr;
8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8663: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

Line 8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8664: l_sd_date_tab MRP_ATP_PUB.date_arr;
8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8665: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8673:

Line 8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8666:
8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8673:
8674: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because

Line 8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

8667: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8673:
8674: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8675: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs

Line 8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8668: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8669: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8673:
8674: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8675: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
8676: p_new_refresh_number IN NUMBER)