1 PACKAGE OZF_QUOTA_ALLOCATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvqals.pls 115.6 2004/06/10 23:41:31 kvattiku noship $ */
3
4
5
6
7 PROCEDURE create_quota_alloc_hierarchy(
8 p_api_version IN NUMBER
9 , p_init_msg_list IN VARCHAR2
10 , p_commit IN VARCHAR2
11 , p_alloc_id IN NUMBER
12 , x_return_status OUT NOCOPY VARCHAR2
13 , x_msg_count OUT NOCOPY NUMBER
14 , x_msg_data OUT NOCOPY VARCHAR2
15 );
16
17
18 PROCEDURE publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
19 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
20 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
21 , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
22 , p_alloc_id IN NUMBER
23 , x_return_status OUT NOCOPY VARCHAR2
24 , x_msg_count OUT NOCOPY NUMBER
25 , x_msg_data OUT NOCOPY VARCHAR2
26 );
27
28
29 PROCEDURE cancel_alloc_hfq(
30 p_api_version IN NUMBER
31 , p_init_msg_list IN VARCHAR2
32 , p_commit IN VARCHAR2
33 , p_quota_id IN NUMBER
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39
40 ---------------------------------------------------------------------
41 -- FUNCTION
42 --- is_root_or_leaf
43 --
44 -- PURPOSE
45 -- This function returns is the quota a leaf/Root quota or otherwise.
46 -- used to render link to Account allocation page
47 --
48 -- HISTORY
49 -- Tue Dec 02 2003:4/56 PM RSSHARMA Created.
50 --
51 -- PARAMETERS
52 -- p_quota_id NUMBER
53 ---------------------------------------------------------------------
54 FUNCTION is_root_or_leaf(p_quota_id IN NUMBER)return VARCHAR2;
55
56 FUNCTION get_unallocated_amount(p_quota_id IN NUMBER)return NUMBER;
57
58 FUNCTION get_threshold_name(p_threshold_id IN NUMBER )RETURN VARCHAR2;
59 END OZF_Quota_allocations_Pvt;