APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_RATE_ASSIGNS_PKG

Line 472: cn_srp_rate_assigns_pkg.insert_record

468:
469: -- This procedure will ensure that only target and revenue quota types
470: -- get rate assignments
471:
472: cn_srp_rate_assigns_pkg.insert_record
473: (
474: x_srp_plan_assign_id => x_srp_plan_assign_id
475: ,x_srp_quota_assign_id => NULL
476: ,x_srp_rate_assign_id => NULL

Line 691: cn_srp_rate_assigns_pkg.delete_record

687: AND rownum = 1
688: ;
689:
690: IF l_count > 0 THEN
691: cn_srp_rate_assigns_pkg.delete_record
692: ( x_srp_plan_assign_id => l_srp_plan_assign_id
693: ,x_srp_rate_assign_id => null
694: ,x_quota_id => l_quota_id
695: ,x_rate_schedule_id => null

Line 719: cn_srp_rate_assigns_pkg.delete_record

715:
716: -- Revert the SRP level Commission Rates, work with arch of
717: -- Sparse Rate Table implementation
718:
719: cn_srp_rate_assigns_pkg.delete_record
720: ( x_srp_plan_assign_id => l_srp_plan_assign_id
721: ,x_quota_id => x_quota_id
722: -- not used
723: ,x_srp_rate_assign_id => null

Line 738: cn_srp_rate_assigns_pkg.insert_record

734: INTO l_srp_plan_assign_id, l_quota_id
735: FROM cn_srp_quota_assigns_all
736: WHERE srp_quota_assign_id = x_srp_quota_assign_id;
737:
738: cn_srp_rate_assigns_pkg.insert_record
739: (x_srp_plan_assign_id => l_srp_plan_assign_id
740: ,x_srp_quota_assign_id => NULL
741: ,x_srp_rate_assign_id => NULL
742: ,x_quota_id => l_quota_id

Line 823: cn_srp_rate_assigns_pkg.delete_record

819: open quota_rt_assigns_curs;
820: Loop
821: fetch quota_rt_assigns_curs into l_rate_schedule_id, l_calc_formula_id;
822: exit when quota_rt_assigns_curs%notfound;
823: cn_srp_rate_assigns_pkg.delete_record
824: (
825: x_srp_plan_assign_id => null
826: ,x_srp_rate_assign_id => null
827: ,x_quota_id => x_quota_id

Line 845: cn_srp_rate_assigns_pkg.insert_record

841: Loop
842: fetch quota_rt_assigns_curs into l_rate_schedule_id, l_calc_formula_id;
843:
844: exit when quota_rt_assigns_curs%notfound;
845: cn_srp_rate_assigns_pkg.insert_record
846: (
847: x_srp_plan_assign_id => null
848: ,x_srp_quota_assign_id => null
849: ,x_srp_rate_assign_id => null

Line 997: cn_srp_rate_assigns_pkg.delete_record

993: ,x_revenue_class_id => null);
994:
995: -- delete srp rate assigns
996:
997: cn_srp_rate_assigns_pkg.delete_record
998: ( x_srp_plan_assign_id => x_srp_plan_assign_id
999: ,x_srp_rate_assign_id => null
1000: ,x_quota_id => x_quota_id
1001: ,x_rate_schedule_id => null