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_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; --anurodh, 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; --anurodh, 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 6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

6529: p_last_refresh_number IN NUMBER,
6530: p_new_refresh_number IN NUMBER,
6531: p_sys_date IN DATE)
6532: IS
6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

6530: p_new_refresh_number IN NUMBER,
6531: p_sys_date IN DATE)
6532: IS
6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;

6531: p_sys_date IN DATE)
6532: IS
6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;

6532: IS
6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6537: l_sd_date_tab MRP_ATP_PUB.date_arr;

6533: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

6534: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

6535: l_supplier_id_tab MRP_ATP_PUB.number_arr;
6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

6536: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6544: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

6537: l_sd_date_tab MRP_ATP_PUB.date_arr;
6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6544: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6545:

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

6538: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6544: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6545:
6546: -- ATPR4drp

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

6539: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6544: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6545:
6546: -- ATPR4drp
6547: l_plan_type NUMBER;

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

6540: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6541: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6542: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6543: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
6544: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
6545:
6546: -- ATPR4drp
6547: l_plan_type NUMBER;
6548: BEGIN

Line 7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7316: p_sys_date IN DATE)
7317: IS
7318: l_user_id number;
7319: j pls_integer;
7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7321: l_organization_id_tab MRP_ATP_PUB.number_arr;

7317: IS
7318: l_user_id number;
7319: j pls_integer;
7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7318: l_user_id number;
7319: j pls_integer;
7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7323: l_sd_date_tab MRP_ATP_PUB.date_arr;

7319: j pls_integer;
7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7320: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

7321: l_organization_id_tab MRP_ATP_PUB.number_arr;
7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7329: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

7322: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7329: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7330:

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

7323: l_sd_date_tab MRP_ATP_PUB.date_arr;
7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7329: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7330:
7331: CURSOR c_net_sd (p_plan_id IN NUMBER,

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

7324: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7329: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7330:
7331: CURSOR c_net_sd (p_plan_id IN NUMBER,
7332: p_last_refresh_number IN NUMBER,

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

7325: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7326: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7327: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7328: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7329: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7330:
7331: CURSOR c_net_sd (p_plan_id IN NUMBER,
7332: p_last_refresh_number IN NUMBER,
7333: p_new_refresh_number IN NUMBER)

Line 7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7577: p_sys_date IN DATE)
7578: IS
7579: l_user_id number;
7580: j pls_integer;
7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 7582: l_organization_id_tab MRP_ATP_PUB.number_arr;

7578: IS
7579: l_user_id number;
7580: j pls_integer;
7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7579: l_user_id number;
7580: j pls_integer;
7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:

Line 7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;

7580: j pls_integer;
7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7585: l_sd_date_tab MRP_ATP_PUB.date_arr;

7581: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7582: l_organization_id_tab MRP_ATP_PUB.number_arr;
7583: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

7584: l_demand_class_tab MRP_ATP_PUB.char30_arr;
7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

7585: l_sd_date_tab MRP_ATP_PUB.date_arr;
7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7593: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

7586: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7593: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7594:

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

7587:
7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7593: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7594:
7595: CURSOR c_net_sd (p_plan_id IN NUMBER,

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

7588: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7593: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7594:
7595: CURSOR c_net_sd (p_plan_id IN NUMBER,
7596: p_last_refresh_number IN NUMBER,

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

7589: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7590: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7591: l_ins_demand_class_tab MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
7592: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7593: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7594:
7595: CURSOR c_net_sd (p_plan_id IN NUMBER,
7596: p_last_refresh_number IN NUMBER,
7597: p_new_refresh_number IN NUMBER)

Line 7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

7935: p_sys_date IN DATE)
7936: IS
7937: l_user_id number;
7938: j pls_integer;
7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

7936: IS
7937: l_user_id number;
7938: j pls_integer;
7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;

7937: l_user_id number;
7938: j pls_integer;
7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:

Line 7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;

7938: j pls_integer;
7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7943: l_sd_date_tab MRP_ATP_PUB.date_arr;

7939: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

7940: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
7941: l_supplier_id_tab MRP_ATP_PUB.number_arr;
7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

7942: l_supplier_site_id_tab MRP_ATP_PUB.number_arr;
7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

7943: l_sd_date_tab MRP_ATP_PUB.date_arr;
7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

7944: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7952:

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

7945:
7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7952:
7953: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because

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

7946: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7952:
7953: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7954: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs

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

7947: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7948: l_ins_supplier_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7952:
7953: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7954: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
7955: p_new_refresh_number IN NUMBER)

Line 8631: l_department_id_tab MRP_ATP_PUB.number_arr;

8627: p_sys_date IN DATE)
8628: IS
8629: l_user_id number;
8630: j pls_integer;
8631: l_department_id_tab MRP_ATP_PUB.number_arr;
8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;

Line 8632: l_resource_id_tab MRP_ATP_PUB.number_arr;

8628: IS
8629: l_user_id number;
8630: j pls_integer;
8631: l_department_id_tab MRP_ATP_PUB.number_arr;
8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 8633: l_organization_id_tab MRP_ATP_PUB.number_arr;

8629: l_user_id number;
8630: j pls_integer;
8631: l_department_id_tab MRP_ATP_PUB.number_arr;
8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:

Line 8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

8630: j pls_integer;
8631: l_department_id_tab MRP_ATP_PUB.number_arr;
8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8635: l_sd_date_tab MRP_ATP_PUB.date_arr;

8631: l_department_id_tab MRP_ATP_PUB.number_arr;
8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

8632: l_resource_id_tab MRP_ATP_PUB.number_arr;
8633: l_organization_id_tab MRP_ATP_PUB.number_arr;
8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

8634: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

8635: l_sd_date_tab MRP_ATP_PUB.date_arr;
8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

8636: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8644:

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

8637:
8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8644:
8645: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because

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

8638: l_ins_department_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8644:
8645: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8646: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs

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

8639: l_ins_resource_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8640: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8644:
8645: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8646: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
8647: p_new_refresh_number IN NUMBER)