DBA Data[Home] [Help]

APPS.CN_QUOTAS_PKG dependencies on CN_QUOTA_RULES_PKG

Line 117: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_quota_rule_id => NULL, x_revenue_class_id => NULL);

113: )
114: IS
115: BEGIN
116: -- delete quota rules
117: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_quota_rule_id => NULL, x_revenue_class_id => NULL);
118: -- delete period qutoas
119: cn_period_quotas_pkg.DELETE_RECORD (x_quota_id => x_quota_id);
120: -- delete rt quota asgns id
121: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);

Line 529: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_quota_rule_id => NULL, x_revenue_class_id => NULL);

525: -- Delete the Quota rules if there is a change in the Quota Type
526: -- Quota Type none cannot have a revenue class
527: IF (x_quota_type_code IN ('NONE') AND recinfo.quota_type_code IN ('FORMULA', 'EXTERNAL'))
528: THEN
529: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_quota_rule_id => NULL, x_revenue_class_id => NULL);
530: END IF;
531:
532: -- update the srp quota assigns
533: -- delete the srp_rt_quota_assigns if the formula changes