APPS.CN_QUOTA_RULE_PVT dependencies on CN_QUOTA_RULES

Line 416: FROM cn_quota_rules

412: SELECT quota_id,
413: revenue_class_id
414: INTO p_quota_rule.quota_id,
415: p_quota_rule.revenue_class_id
416: FROM cn_quota_rules
417: WHERE quota_rule_id = p_quota_rule.quota_rule_id;
418: EXCEPTION
419: WHEN NO_DATA_FOUND
420: THEN

Line 529: FROM cn_quota_rules

525: THEN
526: -- 2. revenue class must be unique
527: SELECT COUNT (1)
528: INTO l_temp_count
529: FROM cn_quota_rules
530: WHERE quota_id = p_quota_rule.quota_id AND revenue_class_id = p_quota_rule.revenue_class_id AND ROWNUM = 1;
531: -- update validations only
532: ELSIF p_action = 'UPDATE'
533: THEN

Line 545: FROM cn_quota_rules qr

541:
542: -- cannot change the planelement assignment of a quota_rule_assignment
543: SELECT COUNT (*)
544: INTO l_same_pe
545: FROM cn_quota_rules qr
546: WHERE qr.revenue_class_id = p_old_quota_rule.revenue_class_id
547: AND qr.quota_id = p_quota_rule.quota_id
548: AND qr.quota_rule_id = p_quota_rule.quota_rule_id;
549:

Line 616: FROM cn_quota_rules

612:
613: -- revenue class must be unique
614: SELECT COUNT (1)
615: INTO l_temp_count
616: FROM cn_quota_rules
617: WHERE quota_id = p_quota_rule.quota_id
618: AND revenue_class_id = p_quota_rule.revenue_class_id
619: AND quota_rule_id <> p_quota_rule.quota_rule_id
620: AND ROWNUM = 1;

Line 642: cn_quota_rules_pkg.check_rev_class_hier (x_revenue_class_id => p_quota_rule.revenue_class_id,

638: -- and only if there is a change
639: IF checkif_parent_revclass
640: THEN
641: l_ret_val :=
642: cn_quota_rules_pkg.check_rev_class_hier (x_revenue_class_id => p_quota_rule.revenue_class_id,
643: x_revenue_class_id_old => p_old_quota_rule.revenue_class_id,
644: x_quota_id => p_quota_rule.quota_id,
645: x_start_period_id => NULL,
646: x_end_period_id => NULL

Line 748: SELECT cn_quota_rules_s.NEXTVAL

744:
745: -- get the primary key if you dont already have it
746: IF p_quota_rule.quota_rule_id IS NULL
747: THEN
748: SELECT cn_quota_rules_s.NEXTVAL
749: INTO p_quota_rule.quota_rule_id
750: FROM DUAL;
751: END IF;
752:

Line 768: cn_quota_rules_pkg.begin_record (x_operation => 'INSERT',

764: RAISE fnd_api.g_exc_error;
765: END IF;
766:
767: -- call table handler to insert data
768: cn_quota_rules_pkg.begin_record (x_operation => 'INSERT',
769: x_object_version_number => p_quota_rule.object_version_number,
770: x_quota_rule_id => p_quota_rule.quota_rule_id,
771: x_quota_id => p_quota_rule.quota_id,
772: x_org_id => p_quota_rule.org_id,

Line 1068: FROM cn_quota_rules

1064:
1065: CURSOR l_old_quota_rule_cr
1066: IS
1067: SELECT *
1068: FROM cn_quota_rules
1069: WHERE quota_rule_id = p_quota_rule.quota_rule_id;
1070:
1071: l_old_quota_rule l_old_quota_rule_cr%ROWTYPE;
1072: l_old_rec quota_rule_rec_type;

Line 1126: cn_quota_rules_pkg.begin_record (x_operation => 'UPDATE',

1122: RAISE fnd_api.g_exc_error;
1123: END IF;
1124:
1125: -- update table using the handler
1126: cn_quota_rules_pkg.begin_record (x_operation => 'UPDATE',
1127: x_object_version_number => p_quota_rule.object_version_number,
1128: x_quota_rule_id => p_quota_rule.quota_rule_id,
1129: x_quota_id => p_quota_rule.quota_id,
1130: x_org_id => p_quota_rule.org_id,

Line 1425: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => p_quota_rule.quota_id,

1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:
1424: -- Delete Record;
1425: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => p_quota_rule.quota_id,
1426: x_quota_rule_id => p_quota_rule.quota_rule_id,
1427: x_revenue_class_id => p_quota_rule.revenue_class_id
1428: );
1429: