APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_QUOTA_RULES

Line 526: IF (NOT (cn_quota_rules_pkg.check_rev_class_hier (x_revenue_class_id => p_pe_rec.rev_class_id,

522: -- Validate Rule :
523: -- Checks if p_pe_rec.rev_class_id is a parent in a hierarchy
524: -- for any other p_pe_rec.rev_class_id already saved in the database
525: -- for the p_pe_rec.quota_id
526: IF (NOT (cn_quota_rules_pkg.check_rev_class_hier (x_revenue_class_id => p_pe_rec.rev_class_id,
527: x_revenue_class_id_old => p_revenue_class_id_old,
528: x_quota_id => p_pe_rec.quota_id,
529: x_start_period_id => NULL,
530: x_end_period_id => NULL

Line 2459: cn_quota_rules qr

2455: THEN
2456: SELECT q.NAME
2457: INTO l_pe_name
2458: FROM cn_quotas q,
2459: cn_quota_rules qr
2460: WHERE qr.quota_rule_id = p_quota_rule_id AND q.quota_id = qr.quota_id;
2461:
2462: fnd_message.set_name ('CN', 'PLN_QUOTA_RULE_FACTORS_NOT_100');
2463: fnd_message.set_token ('PLAN_NAME', NULL);

Line 2616: RETURN cn_quota_rules.quota_rule_id%TYPE

2612: FUNCTION get_quota_rule_id (
2613: p_quota_id NUMBER,
2614: p_rev_class_id NUMBER
2615: )
2616: RETURN cn_quota_rules.quota_rule_id%TYPE
2617: IS
2618: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2619: BEGIN
2620: SELECT quota_rule_id

Line 2618: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;

2614: p_rev_class_id NUMBER
2615: )
2616: RETURN cn_quota_rules.quota_rule_id%TYPE
2617: IS
2618: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2619: BEGIN
2620: SELECT quota_rule_id
2621: INTO l_quota_rule_id
2622: FROM cn_quota_rules

Line 2622: FROM cn_quota_rules

2618: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2619: BEGIN
2620: SELECT quota_rule_id
2621: INTO l_quota_rule_id
2622: FROM cn_quota_rules
2623: WHERE quota_id = p_quota_id AND revenue_class_id = p_rev_class_id;
2624:
2625: RETURN l_quota_rule_id;
2626: EXCEPTION

Line 3835: cn_quota_rules r

3831: CURSOR uplift_curs
3832: IS
3833: SELECT COUNT (1)
3834: FROM cn_quota_rule_uplifts u,
3835: cn_quota_rules r
3836: WHERE r.quota_id = p_quota_id
3837: AND r.quota_rule_id = u.quota_rule_id
3838: AND (u.start_date < p_start_date OR (p_end_date IS NOT NULL AND u.end_date IS NULL) OR u.end_date > p_end_date);
3839: