DBA Data[Home] [Help]

APPS.MSC_ATP_SUBST dependencies on MRP_ATP_PUB

Line 585: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

581: p_search IN NUMBER,
582: p_refresh_number IN NUMBER,
583: p_parent_pegging_id IN NUMBER,
584: p_assign_set_id IN NUMBER,
585: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
586: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
587: x_return_status OUT NoCopy VARCHAR2
588: ) IS
589:

Line 586: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

582: p_refresh_number IN NUMBER,
583: p_parent_pegging_id IN NUMBER,
584: p_assign_set_id IN NUMBER,
585: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
586: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
587: x_return_status OUT NoCopy VARCHAR2
588: ) IS
589:
590: l_parent_org_cntr number;

Line 610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

606: l_sd_begin_idx number;
607: ORG_AVAILABILITY_INFO MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ;
608: l_null_org_avail_info MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ;
609: l_return_status VARCHAR2(1);
610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;

607: ORG_AVAILABILITY_INFO MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ;
608: l_null_org_avail_info MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ;
609: l_return_status VARCHAR2(1);
610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;
615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

608: l_null_org_avail_info MSC_ATP_SUBST.ATP_Org_Info_Rec_Typ;
609: l_return_status VARCHAR2(1);
610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;
615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
616: l_org_code VARCHAR2(7);

Line 613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;

609: l_return_status VARCHAR2(1);
610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;
615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
616: l_org_code VARCHAR2(7);
617: l_top_tier_org_code VARCHAR2(7);

Line 614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;

610: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;
615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
616: l_org_code VARCHAR2(7);
617: l_top_tier_org_code VARCHAR2(7);
618: L_REQUESTED_DATE_QUANTITY number;

Line 615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

611: L_NULL_ATP_PERIOD MRP_ATP_PUB.ATP_Period_Typ;
612: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
613: L_NULL_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_Supply_Demand_Typ;
614: l_all_atp_period MRP_ATP_PUB.ATP_Period_Typ;
615: l_all_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
616: l_org_code VARCHAR2(7);
617: l_top_tier_org_code VARCHAR2(7);
618: L_REQUESTED_DATE_QUANTITY number;
619: --bug3467631 not needed

Line 680: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

676: l_stealing_qty NUMBER := 0.0;
677: l_demand_class varchar2(30);
678:
679: --forward steal
680: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
681: l_fwd_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
682:
683: -- dsting diag_atp
684: l_make_buy_cd NUMBER;

Line 681: l_fwd_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

677: l_demand_class varchar2(30);
678:
679: --forward steal
680: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
681: l_fwd_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
682:
683: -- dsting diag_atp
684: l_make_buy_cd NUMBER;
685: l_ptf_due_date DATE;

Line 1848: --MRP_ATP_PUB.number_arr(NULL),

1844: NULL,
1845: NULL,
1846: org_availability_info.assign_set_id(l_parent_org_cntr),
1847: l_item_sourcing_info_rec,
1848: --MRP_ATP_PUB.number_arr(NULL),
1849: MSC_ATP_PVT.G_SESSION_ID,
1850: l_sources,
1851: l_return_status);
1852: IF l_sources.source_type.count = 0 THEN

Line 4839: l_effective_dates MRP_ATP_PUB.date_arr;

4835: p_request_date IN DATE,
4836: p_organization_id IN NUMBER)
4837: IS
4838: l_item_table MSC_ATP_SUBST.Item_Info_Rec_Typ;
4839: l_effective_dates MRP_ATP_PUB.date_arr;
4840: l_disable_dates MRP_ATP_PUB.date_arr;
4841: i number;
4842: l_count number;
4843: L_RETURN_STATUS varchar2(1);

Line 4840: l_disable_dates MRP_ATP_PUB.date_arr;

4836: p_organization_id IN NUMBER)
4837: IS
4838: l_item_table MSC_ATP_SUBST.Item_Info_Rec_Typ;
4839: l_effective_dates MRP_ATP_PUB.date_arr;
4840: l_disable_dates MRP_ATP_PUB.date_arr;
4841: i number;
4842: l_count number;
4843: L_RETURN_STATUS varchar2(1);
4844: l_customer_id number;

Line 5599: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

5595:
5596: END Extend_Item_Info_Rec_Typ;
5597:
5598: PROCEDURE Details_Output (
5599: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
5600: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5601: p_begin_period_idx IN NUMBER,
5602: p_end_period_idx IN NUMBER,
5603: p_begin_sd_idx IN NUMBER,

Line 5600: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

5596: END Extend_Item_Info_Rec_Typ;
5597:
5598: PROCEDURE Details_Output (
5599: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
5600: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5601: p_begin_period_idx IN NUMBER,
5602: p_end_period_idx IN NUMBER,
5603: p_begin_sd_idx IN NUMBER,
5604: p_end_sd_idx IN NUMBER,

Line 5605: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5601: p_begin_period_idx IN NUMBER,
5602: p_end_period_idx IN NUMBER,
5603: p_begin_sd_idx IN NUMBER,
5604: p_end_sd_idx IN NUMBER,
5605: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5606: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5607: x_return_status OUT NoCopy VARCHAR2
5608: ) IS
5609:

Line 5606: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

5602: p_end_period_idx IN NUMBER,
5603: p_begin_sd_idx IN NUMBER,
5604: p_end_sd_idx IN NUMBER,
5605: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5606: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5607: x_return_status OUT NoCopy VARCHAR2
5608: ) IS
5609:
5610: l_period_count PLS_INTEGER;