1 PACKAGE CN_QUOTA_RULES_GRP AUTHID CURRENT_USER as
2 /* $Header: cnxgqrs.pls 120.3 2005/09/14 03:38:59 rarajara noship $ */
3
4 -- API name : Create_Quota_Rules
5 -- Type : Group.
6 -- Pre-reqs : None.
7 -- Usage : Used to create entry into cn_quota_rules
8 --
9 -- Desc : Create quota rules, can be called independently from any oracle
10 -- applications. currently this program is called from public API
11 -- and from Forms directly.
12 --
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- : x_loading_status OUT VARCHAR2(50)
25 -- Detailed error code returned from procedure.
26 -- IN : p_quota_name IN NUMBER Required
27 -- p_revenue_class_rec_tbl IN Required
28 -- CN_PLAN_ELEMENT_PUB.revenue_class_rec_tbl_type
29 -- : p_trx_factor_rec_tbl IN Optional
30 -- CN_PLAN_ELEMENT_PUB.trx_factor_rec_tbl_typ
31 -- Version : Current version 1.0
32 -- Initial version 1.0
33 --
34 -- Notes : Note text
35 --
36 -- End of comments
37
38 PROCEDURE Create_Quota_rules
39 (
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER :=
44 FND_API.G_VALID_LEVEL_FULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_quota_name IN VARCHAR2,
49 p_revenue_class_rec_tbl IN CN_PLAN_ELEMENT_PUB.REVENUE_CLASS_REC_TBL_TYPE
50 := CN_PLAN_ELEMENT_PUB.G_MISS_REVENUE_CLASS_REC_TBL,
51 p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type
52 := cn_plan_element_pub.G_MISS_REV_UPLIFT_REC_TBL,
53 p_trx_factor_rec_tbl IN CN_PLAN_ELEMENT_PUB.trx_factor_rec_tbl_type
54 := CN_PLAN_ELEMENT_PUB.G_MISS_TRX_FACTOR_REC_TBL,
55 x_loading_status OUT NOCOPY VARCHAR2
56 );
57
58 -- API name : Update_Quota_Rules
59 -- Type : Group.
60 -- Pre-reqs : None.
61 -- Usage : Used to Update the cn_quota_rules
62 --
63 -- Desc : Update quota rules, can be called independently from any oracle
64 -- applications. currently this program is called from public API
65 -- and from Forms directly.
66 --
67 -- Parameters :
68 -- IN : p_api_version IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_commit IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Optional
74 -- Default = FND_API.G_VALID_LEVEL_FULL
75 -- OUT : x_return_status OUT VARCHAR2(1)
76 -- x_msg_count OUT NUMBER
77 -- x_msg_data OUT VARCHAR2(2000)
78 -- : x_loading_status OUT VARCHAR2(50)
79 -- Detailed error code returned from procedure.
80 -- IN : p_quota_name IN NUMBER Required
81 -- p_revenue_class_rec_tbl IN Required
82 -- CN_PLAN_ELEMENT_PUB.revenue_class_rec_tbl_type
83 -- : p_trx_factor_rec_tbl IN Optional
84 -- CN_PLAN_ELEMENT_PUB.trx_factor_rec_tbl_typ
85 -- Version : Current version 1.0
86 -- Initial version 1.0
87 --
88 -- Notes : Note text
89 --
90 -- End of comments
91
92
93 PROCEDURE Update_Quota_rules
94 (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER :=
99 FND_API.G_VALID_LEVEL_FULL,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_quota_name IN VARCHAR2,
104 p_revenue_class_rec_tbl IN CN_PLAN_ELEMENT_PUB.REVENUE_CLASS_REC_TBL_TYPE
105 := CN_PLAN_ELEMENT_PUB.G_MISS_REVENUE_CLASS_REC_TBL,
106 p_trx_factor_rec_tbl IN CN_PLAN_ELEMENT_PUB.trx_factor_rec_tbl_type
107 := CN_PLAN_ELEMENT_PUB.G_MISS_TRX_FACTOR_REC_TBL,
108 x_loading_status OUT NOCOPY VARCHAR2
109 );
110
111 -- API name : Delete_Quota_Rules
112 -- Type : Group.
113 -- Pre-reqs : None.
114 -- Usage : Used to Delete the cn_quota_rules
115 --
116 -- Desc : Delete quota rules, can be called independently from any oracle
117 -- applications. currently this program is called from public API
118 -- and from Forms directly.
119 --
120 -- Parameters :
121 -- IN : p_api_version IN NUMBER Required
122 -- p_init_msg_list IN VARCHAR2 Optional
123 -- Default = FND_API.G_FALSE
124 -- p_commit IN VARCHAR2 Optional
125 -- Default = FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Optional
127 -- Default = FND_API.G_VALID_LEVEL_FULL
128 -- OUT : x_return_status OUT VARCHAR2(1)
129 -- x_msg_count OUT NUMBER
130 -- x_msg_data OUT VARCHAR2(2000)
131 -- : x_loading_status OUT VARCHAR2(50)
132 -- Detailed error code returned from procedure.
133 -- IN : p_quota_name IN NUMBER Required
134 -- p_revenue_class_name IN Required
135 -- Version : Current version 1.0
136 -- Initial version 1.0
137 --
138 -- Notes : Note text
139 --
140 -- End of comments
141
142 PROCEDURE Delete_Quota_rules
143 (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_validation_level IN NUMBER :=
148 FND_API.G_VALID_LEVEL_FULL,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_quota_name IN VARCHAR2,
153 p_revenue_class_rec_tbl IN CN_PLAN_ELEMENT_PUB.REVENUE_CLASS_REC_TBL_TYPE
154 := CN_PLAN_ELEMENT_PUB.G_MISS_REVENUE_CLASS_REC_TBL,
155 p_trx_factor_rec_tbl IN CN_PLAN_ELEMENT_PUB.trx_factor_rec_tbl_type
156 := CN_PLAN_ELEMENT_PUB.G_MISS_TRX_FACTOR_REC_TBL,
157 x_loading_status OUT NOCOPY VARCHAR2
158 );
159 END CN_QUOTA_RULES_GRP;