eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_QUOTA_RULE_UPLIFTS_GRP dependencies on CN_API

Line 66: l_pe_rec.rev_class_id := cn_api.get_rev_class_id (l_pe_rec.rev_class_name, p_rev_uplift_rec.org_id);

62: l_pe_rec.rev_class_name := LTRIM (RTRIM (p_rev_uplift_rec.rev_class_name));
63: l_pe_rec.rev_uplift_start_date := p_rev_uplift_rec.start_date;
64: l_pe_rec.rev_uplift_end_date := p_rev_uplift_rec.end_date;
65: -- Get the Revenue Class Id
66: l_pe_rec.rev_class_id := cn_api.get_rev_class_id (l_pe_rec.rev_class_name, p_rev_uplift_rec.org_id);
67: -- Get the Quota Id
68: l_pe_rec.quota_id := cn_chk_plan_element_pkg.get_quota_id (l_pe_rec.NAME, l_pe_rec.org_id);
69: -- Get the Quota Rule Id
70: l_pe_rec.quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => l_pe_rec.quota_id, p_rev_class_id => l_pe_rec.rev_class_id);

Line 126: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.NAME,

122:
123: -- API body
124: -- check for required data in Plan Element Name
125: -- Check MISS and NULL ( Revenue class Name, Quota Name )
126: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.NAME,
127: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
128: p_loading_status => x_loading_status,
129: x_loading_status => l_loading_status
130: )

Line 135: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.NAME,

131: ) = fnd_api.g_true
132: )
133: THEN
134: RAISE fnd_api.g_exc_error;
135: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.NAME,
136: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
137: p_loading_status => x_loading_status,
138: x_loading_status => l_loading_status
139: )

Line 167: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,

163:
164: --+
165: -- Check Revenue Class name is null or miss char
166: --+
167: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,
168: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,
169: p_loading_status => x_loading_status,
170: x_loading_status => l_loading_status
171: )

Line 176: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.rev_class_name,

172: ) = fnd_api.g_true
173: )
174: THEN
175: RAISE fnd_api.g_exc_error;
176: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.rev_class_name,
177: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,
178: p_loading_status => x_loading_status,
179: x_loading_status => l_loading_status
180: )

Line 250: IF (cn_api.chk_miss_num_para (p_num_para => p_pe_rec.rev_class_payment_uplift,

246:
247: --+
248: -- Check payment Uplift
249: --+
250: IF (cn_api.chk_miss_num_para (p_num_para => p_pe_rec.rev_class_payment_uplift,
251: p_para_name => cn_chk_plan_element_pkg.g_uplift_payment_factor,
252: p_loading_status => x_loading_status,
253: x_loading_status => l_loading_status
254: ) = fnd_api.g_true

Line 258: ELSIF ((cn_api.chk_null_num_para (p_num_para => p_pe_rec.rev_class_payment_uplift,

254: ) = fnd_api.g_true
255: )
256: THEN
257: RAISE fnd_api.g_exc_error;
258: ELSIF ((cn_api.chk_null_num_para (p_num_para => p_pe_rec.rev_class_payment_uplift,
259: p_obj_name => cn_chk_plan_element_pkg.g_uplift_payment_factor,
260: p_loading_status => x_loading_status,
261: x_loading_status => l_loading_status
262: )

Line 272: IF (cn_api.chk_miss_num_para (p_num_para => p_pe_rec.rev_class_quota_uplift,

268:
269: --+
270: -- Check Quota Uplift
271: --+
272: IF (cn_api.chk_miss_num_para (p_num_para => p_pe_rec.rev_class_quota_uplift,
273: p_para_name => cn_chk_plan_element_pkg.g_uplift_quota_factor,
274: p_loading_status => x_loading_status,
275: x_loading_status => l_loading_status
276: ) = fnd_api.g_true

Line 280: ELSIF ((cn_api.chk_null_num_para (p_num_para => p_pe_rec.rev_class_quota_uplift,

276: ) = fnd_api.g_true
277: )
278: THEN
279: RAISE fnd_api.g_exc_error;
280: ELSIF ((cn_api.chk_null_num_para (p_num_para => p_pe_rec.rev_class_quota_uplift,
281: p_obj_name => cn_chk_plan_element_pkg.g_uplift_quota_factor,
282: p_loading_status => x_loading_status,
283: x_loading_status => l_loading_status
284: )

Line 405: l_rev_class_id_old := cn_api.get_rev_class_id (p_rev_class_name_old, p_new_pe_rec.org_id);

401: x_loading_status := p_loading_status;
402: --+
403: -- Get revenue Class ID
404: --+
405: l_rev_class_id_old := cn_api.get_rev_class_id (p_rev_class_name_old, p_new_pe_rec.org_id);
406: --+
407: -- Get quota rule ID
408: -- +
409: l_quota_rule_id_old := cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => p_new_pe_rec.quota_id, p_rev_class_id => l_rev_class_id_old);

Line 414: IF ((cn_api.chk_miss_char_para (p_char_para => p_rev_class_name_old,

410:
411: -- +
412: -- Check the old revenue class name is not null or miss char
413: --+
414: IF ((cn_api.chk_miss_char_para (p_char_para => p_rev_class_name_old,
415: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,
416: p_loading_status => x_loading_status,
417: x_loading_status => l_loading_status
418: )

Line 423: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_rev_class_name_old,

419: ) = fnd_api.g_true
420: )
421: THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_rev_class_name_old,
424: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,
425: p_loading_status => x_loading_status,
426: x_loading_status => l_loading_status
427: )