[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;