[Home] [Help]
PACKAGE: APPS.CN_PLAN_ELEMENT_PVT
Source
1 PACKAGE cn_plan_element_pvt AS
2 /*$Header: cnvpes.pls 120.2.12000000.2 2007/10/08 18:25:54 rnagired ship $*/
3
4 -- plan element
5 TYPE plan_element_rec_type IS RECORD (
6 quota_id NUMBER := NULL,
7 NAME cn_quotas.NAME%TYPE := NULL,
8 description cn_quotas.description%TYPE := NULL,
9 quota_type_code cn_quotas.quota_type_code%TYPE := NULL,
10 target cn_quotas.target%TYPE := NULL,
11 payment_amount cn_quotas.payment_amount%TYPE := NULL,
12 performance_goal cn_quotas.performance_goal%TYPE := NULL,
13 incentive_type_code cn_quotas.incentive_type_code%TYPE := NULL,
14 start_date cn_quotas.start_date%TYPE := NULL,
15 end_date cn_quotas.end_date%TYPE := NULL,
16 credit_type_id NUMBER := NULL,
17 interval_type_id NUMBER := NULL,
18 calc_formula_id NUMBER := NULL,
19 liability_account_id NUMBER := NULL,
20 expense_account_id NUMBER := NULL,
21 --clku
22 liability_account_cc VARCHAR (4000) := NULL,
23 expense_account_cc VARCHAR (4000) := NULL,
24 vesting_flag cn_quotas.vesting_flag%TYPE := NULL,
25 quota_group_code cn_quotas.quota_group_code%TYPE := NULL,
26 --clku, PAYMENT ENHANCEMENT
27 payment_group_code cn_quotas.payment_group_code%TYPE := NULL,
28 --clku-n-
29 attribute_category cn_quotas.attribute_category%TYPE := NULL,
30 attribute1 cn_quotas.attribute1%TYPE := NULL,
31 attribute2 cn_quotas.attribute2%TYPE := NULL,
32 attribute3 cn_quotas.attribute3%TYPE := NULL,
33 attribute4 cn_quotas.attribute4%TYPE := NULL,
34 attribute5 cn_quotas.attribute5%TYPE := NULL,
35 attribute6 cn_quotas.attribute6%TYPE := NULL,
36 attribute7 cn_quotas.attribute7%TYPE := NULL,
37 attribute8 cn_quotas.attribute8%TYPE := NULL,
38 attribute9 cn_quotas.attribute9%TYPE := NULL,
39 attribute10 cn_quotas.attribute10%TYPE := NULL,
40 attribute11 cn_quotas.attribute11%TYPE := NULL,
41 attribute12 cn_quotas.attribute12%TYPE := NULL,
42 attribute13 cn_quotas.attribute13%TYPE := NULL,
43 attribute14 cn_quotas.attribute14%TYPE := NULL,
44 attribute15 cn_quotas.attribute15%TYPE := NULL,
45 --clku-n-
46 addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := NULL,
47 payee_assign_flag cn_quotas.payee_assign_flag%TYPE := NULL,
48 package_name cn_quotas.package_name%TYPE := NULL,
49 object_version_number cn_quotas.object_version_number%TYPE := NULL,
50 -- r12
51 org_id cn_quotas.org_id%TYPE := NULL,
52 indirect_credit_code cn_quotas.indirect_credit%TYPE := NULL,
53 quota_status cn_quotas.quota_status%TYPE := NULL,
54 call_type VARCHAR2 (30) := NULL,
55 sreps_enddated_flag cn_quotas.salesreps_enddated_flag%TYPE := NULL
56 );
57
58 TYPE plan_element_tbl_type IS TABLE OF plan_element_rec_type
59 INDEX BY BINARY_INTEGER;
60
61 -- Global variable that represent missing values.
62 g_miss_plan_element_rec plan_element_rec_type;
63 g_miss_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
64 g_miss_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
65 g_new_status VARCHAR2 (10) := 'NEW';
66 g_updated_status VARCHAR2 (10) := 'UPDATED';
67 g_complete_status VARCHAR2 (10) := 'COMPLETE';
68 g_public_api VARCHAR2 (10) := 'PUBLIC_API' ;
69
70 -- Start of comments
71 -- API name : is_valid_org
72 -- Type : Private.
73 -- Function :
74 -- Pre-reqs : None.
75 -- Parameters : Checks that the org_id is valid and consistent with the plan
76 -- element's org id.
77 -- Notes : Note text
78 --
79 -- End of comments
80 FUNCTION is_valid_org (
81 p_org_id NUMBER,
82 p_quota_id NUMBER := NULL
83 )
84 RETURN BOOLEAN;
85
86 -- Start of comments
87 -- API name : Create_Plan_Element
88 -- Type : Private.
89 -- Function :
90 -- Pre-reqs : None.
91 -- Parameters :
92 -- IN : p_api_version IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Optional
94 -- Default = FND_API.G_FALSE
95 -- p_commit IN VARCHAR2 Optional
96 -- Default = FND_API.G_FALSE
97 -- p_validation_level IN NUMBER Optional
98 -- Default = FND_API.G_VALID_LEVEL_FULL
99 -- p_plan_element IN plan_element_rec_type
100 -- OUT : x_return_status OUT VARCHAR2(1)
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2(2000)
103 -- x_plan_element_id OUT NUMBER
104 -- Version : Current version 1.0
105 -- Notes : Note text
106 --
107 -- End of comments
108 PROCEDURE create_plan_element (
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
111 p_commit IN VARCHAR2 := fnd_api.g_false,
112 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
113 p_plan_element IN OUT NOCOPY plan_element_rec_type,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 -- Start of comments
120 -- API name : Update_Plan_Element
121 -- Type : Private.
122 -- Function :
123 -- Pre-reqs : None.
124 -- Parameters :
125 -- IN : p_api_version IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Optional
127 -- Default = FND_API.G_FALSE
128 -- p_commit IN VARCHAR2 Optional
129 -- Default = FND_API.G_FALSE
130 -- p_validation_level IN NUMBER Optional
131 -- Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_plan_element IN plan_element_rec_type
133 -- OUT : x_return_status OUT VARCHAR2(1)
134 -- x_msg_count OUT NUMBER
135 -- x_msg_data OUT VARCHAR2(2000)
136 -- Version : Current version 1.0
137 -- Notes : Note text
138 --
139 -- End of comments
140 PROCEDURE update_plan_element (
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143 p_commit IN VARCHAR2 := fnd_api.g_false,
144 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
145 p_plan_element IN OUT NOCOPY plan_element_rec_type,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2
149 );
150
151 -- Start of comments
152 -- API name : Delete_Plan_Element
153 -- Type : Private.
154 -- Function :
155 -- Pre-reqs : None.
156 -- Parameters :
157 -- IN : p_api_version IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional
159 -- Default = FND_API.G_FALSE
160 -- p_commit IN VARCHAR2 Optional
161 -- Default = FND_API.G_FALSE
162 -- p_validation_level IN NUMBER Optional
163 -- Default = FND_API.G_VALID_LEVEL_FULL
164 -- p_plan_element IN plan_element_rec_type
165 -- OUT : x_return_status OUT VARCHAR2(1)
166 -- x_msg_count OUT NUMBER
167 -- x_msg_data OUT VARCHAR2(2000)
168 -- Version : Current version 1.0
169 -- Notes : Note text
170 --
171 -- End of comments
172 PROCEDURE delete_plan_element (
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175 p_commit IN VARCHAR2 := fnd_api.g_false,
176 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177 p_plan_element IN OUT NOCOPY plan_element_rec_type,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2
181 );
182
183 -- Start of comments
184 -- API name : Duplicate_Plan_Element
185 -- Type : Private.
186 -- Function :
187 -- Pre-reqs : None.
188 -- Parameters :
189 PROCEDURE duplicate_plan_element (
190 p_api_version IN NUMBER := cn_api.g_miss_num,
191 p_init_msg_list IN VARCHAR2 := cn_api.g_false,
192 p_commit IN VARCHAR2 := cn_api.g_false,
193 p_validation_level IN NUMBER := cn_api.g_valid_level_full,
194 p_quota_id IN cn_quotas.quota_id%TYPE := NULL,
195 x_plan_element OUT NOCOPY plan_element_rec_type,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 x_loading_status OUT NOCOPY VARCHAR2
200 );
201
202 -- Start of comments
203 -- API name : Validate_Plan_Element
204 -- Type : Private.
205 -- Function :
206 -- Pre-reqs : None.
207 -- Parameters :
208 -- IN : p_api_version IN NUMBER Required
209 -- p_init_msg_list IN VARCHAR2 Optional
210 -- Default = FND_API.G_FALSE
211 -- p_commit IN VARCHAR2 Optional
212 -- Default = FND_API.G_FALSE
213 -- p_validation_level IN NUMBER Optional
214 -- Default = FND_API.G_VALID_LEVEL_FULL
215 -- p_plan_element IN plan_element_rec_type
216 -- OUT : x_return_status OUT VARCHAR2(1)
217 -- x_msg_count OUT NUMBER
218 -- x_msg_data OUT VARCHAR2(2000)
219 -- Version : Current version 1.0
220 -- Notes : Note text
221 --
222 -- End of comments
223 PROCEDURE validate_plan_element (
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226 p_commit IN VARCHAR2 := fnd_api.g_false,
227 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
228 p_action IN VARCHAR2,
229 p_plan_element IN OUT NOCOPY plan_element_rec_type,
230 p_old_plan_element IN plan_element_rec_type := NULL,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2
234 );
235
236 -- Start of comments
237 -- API name : Validate_Plan_Element
238 -- Type : Private.
239 -- Function :
240 -- Pre-reqs : None.
241 -- Parameters :
242 -- IN : p_api_version IN NUMBER Required
243 -- p_init_msg_list IN VARCHAR2 Optional
244 -- Default = FND_API.G_FALSE
245 -- p_commit IN VARCHAR2 Optional
246 -- Default = FND_API.G_FALSE
247 -- p_validation_level IN NUMBER Optional
248 -- Default = FND_API.G_VALID_LEVEL_FULL
249 -- p_comp_plan_id IN NUMBER
250 -- p_quota_id IN NUMBER
251 -- x_status_code OUT VARCHAR2(30)
252 -- OUT : x_return_status OUT VARCHAR2(1)
253 -- x_msg_count OUT NUMBER
254 -- x_msg_data OUT VARCHAR2(2000)
255 -- Version : Current version 1.0
256 -- Notes : Note text
257 --
258 -- End of comments
259 PROCEDURE validate_plan_element (
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
262 p_commit IN VARCHAR2 := fnd_api.g_false,
263 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
264 p_comp_plan_id IN NUMBER := NULL,
265 p_quota_id IN NUMBER,
266 x_status_code OUT NOCOPY VARCHAR2,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2
270 );
271 END cn_plan_element_pvt;