APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_QUOTA_RULES

Line 2028: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;

2024: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element';
2025: l_api_version CONSTANT NUMBER := 1.0;
2026: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
2027: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2028: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2029: l_per_quota_id cn_period_quotas.period_quota_id%TYPE;
2030: l_tmp NUMBER;
2031: l_meaning cn_lookups.meaning%TYPE;
2032: l_p_plan_element_rec plan_element_rec_type;

Line 2439: cn_quota_rules_grp.create_quota_rules (p_api_version => p_api_version,

2435: -- table record and the Quota Type.
2436: IF l_p_revenue_class_rec_tbl.COUNT > 0
2437: THEN
2438: -- call the group api to insert the quota rules and the trx factors.
2439: cn_quota_rules_grp.create_quota_rules (p_api_version => p_api_version,
2440: p_init_msg_list => 'T',
2441: p_commit => p_commit,
2442: p_validation_level => p_validation_level,
2443: x_return_status => x_return_status,

Line 3203: cn_quota_rules_grp.update_quota_rules (p_api_version => p_api_version,

3199: THEN
3200: IF l_p_revenue_class_rec_tbl.COUNT > 0
3201: THEN
3202: -- Call the Quota Rules Update Procedure if the Count IS > 0
3203: cn_quota_rules_grp.update_quota_rules (p_api_version => p_api_version,
3204: p_init_msg_list => 'T',
3205: p_commit => p_commit,
3206: p_validation_level => p_validation_level,
3207: x_return_status => x_return_status,

Line 3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS

3575: -- Type : Public
3576: -- Pre-reqs : None.
3577: -- Purpose : The following API performs the following
3578: -- 1. Deletes the Plan Element and it's associated records in
3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS
3580: -- 2.
3581: -- 3.
3582: -- Parameters :
3583: -- IN : p_api_version IN NUMBER API version

Line 3947: -- the code was added in cn_quota_rules_pvt itself.

3943: -- Call the Quota Rules group Package to Delete the Quota Rules
3944: -- It will cascade the Child records as well.
3945: -- Previously this used to call the group API. During the
3946: -- rewrite in R12 the group api for quota rules was eliminated and
3947: -- the code was added in cn_quota_rules_pvt itself.
3948: cn_quota_rule_pvt.delete_quota_rules (p_api_version => p_api_version,
3949: p_init_msg_list => p_init_msg_list,
3950: p_commit => p_commit,
3951: p_validation_level => p_validation_level,

Line 4130: l_revenue_class_id cn_quota_rules.revenue_class_id%TYPE;

4126: l_quota_rule_id NUMBER;
4127: l_period_index NUMBER;
4128: l_pe_name cn_quotas.NAME%TYPE;
4129: l_quota_id cn_quotas.quota_id%TYPE;
4130: l_revenue_class_id cn_quota_rules.revenue_class_id%TYPE;
4131:
4132: -- Quotas Cursor
4133: CURSOR c_plan_element_rec_csr (
4134: pe_name cn_quotas.NAME%TYPE

Line 4228: cn_quota_rules qr

4224: qr.attribute14,
4225: qr.attribute15,
4226: qr.org_id
4227: FROM cn_revenue_classes rc,
4228: cn_quota_rules qr
4229: WHERE qr.revenue_class_id = rc.revenue_class_id AND quota_id = pe_id;
4230:
4231: -- Quota rule uplifts
4232: CURSOR c_rule_uplift_rec_csr (

Line 4233: p_quota_rule_id cn_quota_rules.quota_rule_id%TYPE

4229: WHERE qr.revenue_class_id = rc.revenue_class_id AND quota_id = pe_id;
4230:
4231: -- Quota rule uplifts
4232: CURSOR c_rule_uplift_rec_csr (
4233: p_quota_rule_id cn_quota_rules.quota_rule_id%TYPE
4234: )
4235: IS
4236: SELECT NULL rev_class_name,
4237: qru.start_date,

Line 4269: p_quota_rule_id cn_quota_rules.quota_rule_id%TYPE

4265:
4266: -- Trx Factors Cursor
4267: CURSOR c_trx_factor_rec_csr (
4268: pe_id cn_quotas.quota_id%TYPE,
4269: p_quota_rule_id cn_quota_rules.quota_rule_id%TYPE
4270: )
4271: IS
4272: SELECT tf.trx_type,
4273: tf.event_factor,