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 667: p_line_ids IN MRP_ATP_PUB.number_arr,

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

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

681: l_cto_source_found number;
682: l_item_count number;
683: i number;
684:
685: l_org_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
686: l_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
687: l_sup_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
688:
689: BEGIN

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

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

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

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

Line 1252: p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

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