DBA Data[Home] [Help]

PACKAGE: APPS.MSC_ATP_PUB

Source


1 PACKAGE MSC_ATP_PUB AUTHID CURRENT_USER AS
2 /* $Header: MSCEATPS.pls 120.1 2007/12/12 10:26:05 sbnaik ship $  */
3 
4 /* Exception for invalid objects */
5 /* Error Handlng Modifications */
6 ATP_INVALID_OBJECTS_FOUND       Exception;
7 PRAGMA  EXCEPTION_INIT(ATP_INVALID_OBJECTS_FOUND, -6508);
8 G_ATP_CHECK        VARCHAR2(1) := 'N';
9 
10 
11 PROCEDURE Call_ATP (
12 	p_session_id	     IN OUT 	NoCopy NUMBER,
13 	p_atp_rec            IN    	MRP_ATP_PUB.ATP_Rec_Typ,
14 	x_atp_rec            OUT NOCOPY	MRP_ATP_PUB.ATP_Rec_Typ,
15 	x_atp_supply_demand  OUT NOCOPY	MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16 	x_atp_period         OUT NOCOPY	MRP_ATP_PUB.ATP_Period_Typ,
17 	x_atp_details        OUT NOCOPY	MRP_ATP_PUB.ATP_Details_Typ,
18 	x_return_status      OUT   	NoCopy VARCHAR2,
19 	x_msg_data           OUT   	NoCopy VARCHAR2,
20 	x_msg_count          OUT   	NoCopy NUMBER
21 );
22 
23 PROCEDURE Call_ATP_No_Commit (
24                p_session_id         IN OUT      NoCopy NUMBER,
25                p_atp_rec            IN          MRP_ATP_PUB.ATP_Rec_Typ,
26                x_atp_rec            OUT NOCOPY  MRP_ATP_PUB.ATP_Rec_Typ,
27                x_atp_supply_demand  OUT NOCOPY  MRP_ATP_PUB.ATP_Supply_Demand_Typ,
28                x_atp_period         OUT NOCOPY  MRP_ATP_PUB.ATP_Period_Typ,
29                x_atp_details        OUT NOCOPY  MRP_ATP_PUB.ATP_Details_Typ,
30                x_return_status      OUT         NoCopy VARCHAR2,
31                x_msg_data           OUT         NoCopy VARCHAR2,
32                x_msg_count          OUT         NoCopy NUMBER
33 );
34 
35 -- Commented out as part of NGOEL Fixes by krajan
36 -- Procedure Subst_Workflow(p_atp_rec  IN MRP_ATP_PUB.ATP_Rec_Typ);
37 PROCEDURE UPDATE_TABLES (
38                 p_summary_flag IN  VARCHAR2,
39                 p_end_refresh_number IN NUMBER ,
40                 p_refresh_number IN NUMBER ,
41                 p_session_id IN NUMBER
42                          );
43 
44 
45 END MSC_ATP_PUB;