DBA Data[Home] [Help]

APPS.MSC_ATP_DRP dependencies on MRP_ATP_PUB

Line 15: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

11: p_org_id IN NUMBER,
12: p_instance_id IN NUMBER,
13: p_plan_id IN NUMBER,
14: p_itf IN DATE,
15: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
16: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
17: ) IS
18: BEGIN
19: IF PG_DEBUG in ('Y', 'C') THEN

Line 16: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

12: p_instance_id IN NUMBER,
13: p_plan_id IN NUMBER,
14: p_itf IN DATE,
15: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
16: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
17: ) IS
18: BEGIN
19: IF PG_DEBUG in ('Y', 'C') THEN
20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');

Line 505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;

501: p_new_refresh_number IN NUMBER,
502: p_sys_date IN DATE)
503: IS
504: j pls_integer;
505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

Line 506: l_organization_id_tab MRP_ATP_PUB.number_arr;

502: p_sys_date IN DATE)
503: IS
504: j pls_integer;
505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;

503: IS
504: j pls_integer;
505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 508: l_sd_date_tab MRP_ATP_PUB.date_arr;

504: j pls_integer;
505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;

505: l_sr_instance_id_tab MRP_ATP_PUB.number_arr;
506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

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

506: l_organization_id_tab MRP_ATP_PUB.number_arr;
507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

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

507: l_inventory_item_id_tab MRP_ATP_PUB.number_arr;
508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
515:

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

508: l_sd_date_tab MRP_ATP_PUB.date_arr;
509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
515:
516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.

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

509: l_sd_quantity_tab MRP_ATP_PUB.number_arr;
510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
515:
516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
517: BEGIN

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

510: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
511: l_ins_organization_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
512: l_ins_inventory_item_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
513: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
514: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
515:
516: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
517: BEGIN
518:

Line 713: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

709: p_instance_id IN NUMBER,
710: p_plan_id IN NUMBER,
711: p_itf IN DATE,
712: p_refresh_number IN NUMBER, -- For summary enhancement
713: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
714: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
715: ) IS
716: BEGIN
717: IF PG_DEBUG in ('Y', 'C') THEN

Line 714: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

710: p_plan_id IN NUMBER,
711: p_itf IN DATE,
712: p_refresh_number IN NUMBER, -- For summary enhancement
713: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
714: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
715: ) IS
716: BEGIN
717: IF PG_DEBUG in ('Y', 'C') THEN
718: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');