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_AATP_REQ dependencies on MRP_ATP_PUB

Line 21: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

17: p_demand_class IN VARCHAR2,
18: p_request_date IN DATE,
19: p_insert_flag IN NUMBER,
20: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
21: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
22: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
23: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
24: p_refresh_number IN NUMBER, -- For summary enhancement
25: p_request_item_id IN NUMBER, -- For time_phased_atp

Line 22: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

18: p_request_date IN DATE,
19: p_insert_flag IN NUMBER,
20: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
21: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
22: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
23: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
24: p_refresh_number IN NUMBER, -- For summary enhancement
25: p_request_item_id IN NUMBER, -- For time_phased_atp
26: p_atf_date IN DATE) -- For time_phased_atp

Line 626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,

622: END Item_Pre_Allocated_Atp;
623:
624:
625: PROCEDURE Atp_Alloc_Consume(
626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,
629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,
630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)

Line 627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,

623:
624:
625: PROCEDURE Atp_Alloc_Consume(
626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,
629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,
630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)
631: IS

Line 628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,

624:
625: PROCEDURE Atp_Alloc_Consume(
626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,
629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,
630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)
631: IS
632: i NUMBER;

Line 629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,

625: PROCEDURE Atp_Alloc_Consume(
626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,
629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,
630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)
631: IS
632: i NUMBER;
633: j NUMBER;

Line 630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)

626: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
627: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
628: x_dc_list_tab OUT NoCopy MRP_ATP_PUB.char80_arr,
629: x_dc_start_index OUT NoCopy MRP_ATP_PUB.number_arr,
630: x_dc_end_index OUT NoCopy MRP_ATP_PUB.number_arr)
631: IS
632: i NUMBER;
633: j NUMBER;
634:

Line 641: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();

637: IF PG_DEBUG in ('Y', 'C') THEN
638: msc_sch_wb.atp_debug('**********Begin Atp_Alloc_Consume Procedure************');
639: END IF;
640:
641: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
642: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
643: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
644:
645: x_dc_list_tab.EXTEND;

Line 642: x_dc_start_index := MRP_ATP_PUB.Number_Arr();

638: msc_sch_wb.atp_debug('**********Begin Atp_Alloc_Consume Procedure************');
639: END IF;
640:
641: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
642: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
643: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
644:
645: x_dc_list_tab.EXTEND;
646: x_dc_start_index.EXTEND;

Line 643: x_dc_end_index := MRP_ATP_PUB.Number_Arr();

639: END IF;
640:
641: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
642: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
643: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
644:
645: x_dc_list_tab.EXTEND;
646: x_dc_start_index.EXTEND;
647: x_dc_end_index.EXTEND;

Line 838: x_atp_pegging_tab OUT NOCOPY MRP_ATP_PUB.Number_Arr,

834: x_requested_date_quantity OUT NoCopy NUMBER,
835: x_atf_date_quantity OUT NoCopy NUMBER, -- For time_phased_atp
836: x_atp_date_this_level OUT NoCopy DATE,
837: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
838: x_atp_pegging_tab OUT NOCOPY MRP_ATP_PUB.Number_Arr,
839: x_return_status OUT NoCopy VARCHAR2,
840: x_used_available_quantity OUT NoCopy NUMBER, --bug3409973
841: p_substitution_window IN number,
842: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,

Line 876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

872: j PLS_INTEGER := 1;
873: k PLS_INTEGER := 1;
874: m PLS_INTEGER := 1;
875: n PLS_INTEGER := 1;
876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

Line 877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

873: k PLS_INTEGER := 1;
874: m PLS_INTEGER := 1;
875: n PLS_INTEGER := 1;
876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

874: m PLS_INTEGER := 1;
875: n PLS_INTEGER := 1;
876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

875: n PLS_INTEGER := 1;
876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

Line 880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

876: l_atp_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

Line 881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

877: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

Line 882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

878: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

Line 883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

879: l_dc_end_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
880: l_dc_list_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
887: l_used_dc_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

881: l_dc_start_index MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
887: l_used_dc_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
888: l_substitution_end_date DATE;
889: --- Enhance CTO Phase 1 Req #17 new variable

Line 886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

882: l_demand_class_priority_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
887: l_used_dc_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
888: l_substitution_end_date DATE;
889: --- Enhance CTO Phase 1 Req #17 new variable
890: l_demand_pegging_id NUMBER;

Line 887: l_used_dc_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

883: l_demand_class_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
884: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
885: l_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
886: l_used_dc_tab MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
887: l_used_dc_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
888: l_substitution_end_date DATE;
889: --- Enhance CTO Phase 1 Req #17 new variable
890: l_demand_pegging_id NUMBER;
891: l_demand_id NUMBER;

Line 900: l_used_dc_mem_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

896:
897: -- time_phased_atp
898: l_time_phased_atp VARCHAR2(1) := 'N';
899: l_return_status VARCHAR2(1);
900: l_used_dc_mem_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
901: l_atf_quantity NUMBER; -- l_atf_quantity is qty total qty used within ATF, may not be equal to ATF date qty
902: l_mem_stealing_qty NUMBER;
903: l_pf_stealing_qty NUMBER;
904: k_atf PLS_INTEGER;

Line 915: x_atp_pegging_tab := MRP_ATP_PUB.Number_Arr();

911: msc_sch_wb.atp_debug('**********Begin Get_Forward_Material_Atp Procedure************');
912: END IF;
913: -- initialize API return status to success
914: x_return_status := FND_API.G_RET_STS_SUCCESS;
915: x_atp_pegging_tab := MRP_ATP_PUB.Number_Arr();
916:
917: IF PG_DEBUG in ('Y', 'C') THEN
918: msc_sch_wb.atp_debug('********** INPUT DATA:Get_Forward_Material_Atp **********');
919: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'p_inventory_item_id: '|| to_char(p_inventory_item_id));