[Home] [Help]
PACKAGE: APPS.CN_OVER_ASSIGN_PVT
Source
1 PACKAGE cn_over_assign_pvt AUTHID CURRENT_USER AS
2 -- $Header: cnvoasgs.pls 115.5 2002/11/21 21:14:33 hlchen ship $
3
4 TYPE quota_overassign_rec_type IS RECORD
5 ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
6 direct_overassign_pct NUMBER,
7 street_overassign_pct NUMBER,
8 direct_pro_oasg_pct NUMBER,
9 street_pro_oasg_pct NUMBER,
10 direct_pln_oasg_pct NUMBER,
11 street_pln_oasg_pct NUMBER)
12 ;
13
14 TYPE quota_overassign_tbl_type IS TABLE OF quota_overassign_rec_type
15 INDEX BY BINARY_INTEGER;
16
17 -- API name : Get_overassign
18 -- Type : Public.
19 -- Pre-reqs :
20 -- Usage :
21 --
22 -- Desc :
23 --
24 --
25 --
26 -- Parameters :
27 -- IN : p_api_version NUMBER Require
28 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
29 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
30 -- p_validation_level NUMBER Optional
31 -- (FND_API.G_VALID_LEVEL_FULL)
32 -- OUT : x_return_status VARCHAR2(1)
33 -- x_msg_count NUMBER
34 -- x_msg_data VARCHAR2(2000)
35 -- IN : p_srp_role_id NUMBER, Required
36 -- p_org_code VARCHAR2, Required
37 -- OUT : x_quota_overassign_tbl quota_overassign_tbl_type
38 --
39 --
40 -- Version : Current version 1.0
41 -- Initial version 1.0
42 --
43 -- Notes :
44 --
45 -- End of comments
46
47 PROCEDURE get_overassign
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_qm_mgr_srp_group_id IN NUMBER ,
56 p_org_code IN VARCHAR2,
57 x_quota_overassign_tbl OUT NOCOPY quota_overassign_tbl_type
58
59 );
60
61
62 END cn_over_assign_pvt;
63