1 PACKAGE MSC_ATP_ALLOC AUTHID CURRENT_USER AS
2 /* $Header: MSCATALS.pls 120.1 2007/12/12 10:20:26 sbnaik ship $ */
3 G_SUCCESS CONSTANT NUMBER := 0;
4 G_WARNING CONSTANT NUMBER := 1;
5 G_ERROR CONSTANT NUMBER := 2;
6
7 -- time_phased_atp
8 G_ATF_DATE DATE;
9
10 PROCEDURE View_Allocation_Details(
11 p_session_id IN NUMBER,
12 p_inventory_item_id IN NUMBER,
13 p_instance_id IN NUMBER,
14 p_organization_id IN NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2);
16
17 PROCEDURE Refresh_Allocation_Details(
18 ERRBUF OUT NOCOPY VARCHAR2,
19 RETCODE OUT NOCOPY NUMBER,
20 p_session_id IN NUMBER,
21 p_inventory_item_id IN NUMBER,
22 p_instance_id IN NUMBER,
23 p_organization_id IN NUMBER);
24
25 -- Added function to call the refresh allocation concurrent program
26 -- from database package.
27 -- fix for bug 2781625
28 function Refresh_Alloc_request(
29 p_new_session_id in number ,
30 p_inventory_item_id in number ,
31 p_instance_id in number ,
32 p_organization_id in number ) return number;
33 END MSC_ATP_ALLOC;