APPS.CN_QUOTA_RULES_PKG dependencies on CN_SRP_QUOTA_RULES_PKG

Line 256: cn_srp_quota_rules_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,

252: update_quota (x_quota_id);
253: -- Create trx factors
254: cn_trx_factors_pkg.INSERT_RECORD (x_quota_id, x_quota_rule_id, x_revenue_class_id);
255: -- Create Srp quota Rules
256: cn_srp_quota_rules_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,
257: x_quota_id => x_quota_id,
258: x_quota_rule_id => x_quota_rule_id,
259: x_revenue_class_id => x_revenue_class_id
260: );

Line 349: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

345: END IF;
346:
347: IF NVL (x_revenue_class_id_old, x_revenue_class_id) <> x_revenue_class_id
348: THEN
349: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
350: x_srp_quota_assign_id => NULL,
351: x_quota_id => x_quota_id,
352: x_quota_rule_id => x_quota_rule_id,
353: x_revenue_class_id => x_revenue_class_id_old

Line 355: cn_srp_quota_rules_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,

351: x_quota_id => x_quota_id,
352: x_quota_rule_id => x_quota_rule_id,
353: x_revenue_class_id => x_revenue_class_id_old
354: );
355: cn_srp_quota_rules_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,
356: x_quota_id => x_quota_id,
357: x_quota_rule_id => x_quota_rule_id,
358: x_revenue_class_id => x_revenue_class_id
359: );

Line 369: cn_srp_quota_rules_pkg.UPDATE_RECORD (x_quota_rule_id => x_quota_rule_id,

365: ELSIF NVL (x_target, 0) <> NVL (x_target_old, 0)
366: OR NVL (x_payment_amount, 0) <> NVL (x_payment_amount_old, 0)
367: OR NVL (x_performance_goal, 0) <> NVL (x_performance_goal_old, 0)
368: THEN
369: cn_srp_quota_rules_pkg.UPDATE_RECORD (x_quota_rule_id => x_quota_rule_id,
370: x_target => x_target,
371: x_payment_amount => x_payment_amount,
372: x_performance_goal => x_performance_goal
373: );

Line 493: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

489: -- quota rules, and we should take care all the quota rule uplifts
490: -- must be deleted if there is a full delete in quota rules using
491: --quota id
492: cn_quota_rule_uplifts_pkg.DELETE_RECORD (x_quota_rule_uplift_id => NULL, x_quota_rule_id => x_quota_rule_id, x_quota_id => x_quota_id);
493: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
494: x_srp_quota_assign_id => NULL,
495: x_quota_id => x_quota_id,
496: x_quota_rule_id => x_quota_rule_id,
497: x_revenue_class_id => x_revenue_class_id

Line 519: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

515: -- If we are deleting a quota there is no need to maintain the srp
516: -- tables because you can't delete a quota that is assigned to a rep.
517: -- However we don't discriminate between deletinga quota and changing
518: -- its type so we must maintain the srp tables in this statement.
519: cn_srp_quota_rules_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
520: x_srp_quota_assign_id => NULL,
521: x_quota_id => x_quota_id,
522: x_quota_rule_id => x_quota_rule_id,
523: x_revenue_class_id => x_revenue_class_id