APPS.CN_SRP_QUOTA_RULES_PKG dependencies on CN_SRP_RULE_UPLIFTS_PKG

Line 357: cn_srp_rule_uplifts_pkg.insert_record

353: ,x_start_period_id => null
354: ,x_end_period_id => null);
355:
356: -- Srp Quota Rule uplifts
357: cn_srp_rule_uplifts_pkg.insert_record
358: ( p_srp_plan_assign_id => x_srp_plan_assign_id
359: ,p_quota_id => x_quota_id
360: ,p_quota_rule_id => x_quota_rule_id
361: ,p_quota_rule_uplift_id=> null

Line 387: cn_srp_rule_uplifts_pkg.Delete_record

383: -- We really needed another foreign key to avoid the subquery
384:
385: -- before delete the srp rules, delete the uplifts.
386:
387: cn_srp_rule_uplifts_pkg.Delete_record
388: (
389: p_srp_plan_assign_id => x_srp_plan_assign_id
390: ,p_quota_id => x_quota_id
391: ,p_quota_rule_id => NULL

Line 410: cn_srp_rule_uplifts_pkg.Delete_record

406:
407: -- cn_srp_plan_assigns record has been deleted
408: -- delete srp rule uplifs before delete the srp rules.
409:
410: cn_srp_rule_uplifts_pkg.Delete_record
411: (
412: p_srp_plan_assign_id => x_srp_plan_assign_id
413: ,p_quota_id => NULL
414: ,p_quota_rule_id => NULL

Line 429: cn_srp_rule_uplifts_pkg.Delete_record

425: -- The revenue_class_id is also passed to ensure we can delete the
426: -- per_quota_rc records.
427:
428: -- ** Delete SRp Quota rule uplifs before delete the srp quota rules
429: cn_srp_rule_uplifts_pkg.Delete_record
430: (
431: p_srp_plan_assign_id => NULL
432: ,p_quota_id => x_quota_id
433: ,p_quota_rule_id => x_quota_rule_id

Line 447: cn_srp_rule_uplifts_pkg.Delete_record

443: -- Quota's type has changed to 'manual' or 'draw' which do not support
444: -- revenue classes
445: -- delete srp quota rule uplifts
446:
447: cn_srp_rule_uplifts_pkg.Delete_record
448: (
449: p_srp_plan_assign_id => NULL
450: ,p_quota_id => x_quota_id
451: ,p_quota_rule_id => NULL