APPS.MSC_ATP_CTO dependencies on MRP_ATP_PUB

Line 9: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
7:
8: PROCEDURE Check_Lines_For_CTO_ATP (
9: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
10: p_session_id IN number,
11: p_dblink IN varchar2,
12: p_instance_id IN Number,
13: x_return_status OUT NoCopy VARCHAR2

Line 16: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

12: p_instance_id IN Number,
13: x_return_status OUT NoCopy VARCHAR2
14: ) IS
15:
16: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
19: l_msg_data VARCHAR2(30);
20: l_msg_count VARCHAR2(30);

Line 17: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

13: x_return_status OUT NoCopy VARCHAR2
14: ) IS
15:
16: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
19: l_msg_data VARCHAR2(30);
20: l_msg_count VARCHAR2(30);
21: l_return_status VARCHAR2(30);

Line 18: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

14: ) IS
15:
16: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
19: l_msg_data VARCHAR2(30);
20: l_msg_count VARCHAR2(30);
21: l_return_status VARCHAR2(30);
22: l_atp_count number;

Line 664: p_line_ids IN MRP_ATP_PUB.number_arr,

660: END IF;
661: END Get_Mandatory_Components;
662:
663: Procedure Validate_CTO_Sources (P_SOURCE_LIST IN OUT NOCOPY MRP_ATP_PVT.Atp_Source_Typ,
664: p_line_ids IN MRP_ATP_PUB.number_arr,
665: p_instance_id IN number,
666: p_session_id IN number,
667: x_return_status OUT NOCOPY varchar2)
668: IS

Line 682: l_org_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

678: l_cto_source_found number;
679: l_item_count number;
680: i number;
681:
682: l_org_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
683: l_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
684: l_sup_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
685:
686: BEGIN

Line 683: l_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

679: l_item_count number;
680: i number;
681:
682: l_org_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
683: l_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
684: l_sup_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
685:
686: BEGIN
687: IF PG_DEBUG in ('Y', 'C') THEN

Line 684: l_sup_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

680: i number;
681:
682: l_org_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
683: l_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
684: l_sup_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
685:
686: BEGIN
687: IF PG_DEBUG in ('Y', 'C') THEN
688: msc_sch_wb.atp_debug('Validate CTO Source');

Line 1249: p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

1245:
1246: END Get_CTO_BOM;
1247:
1248: Procedure Maintain_OS_Sourcing(p_instance_id IN Number,
1249: p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
1250: p_status IN Number)
1251: IS
1252: i number;
1253: BEGIN