APPS.CN_RATE_TIERS_PKG dependencies on CN_SRP_RATE_ASSIGNS_PKG

Line 90: cn_srp_rate_assigns_pkg.insert_record

86: end if;
87: close c;
88:
89: -- assign this rate tier to all salesreps with this rate schedule
90: cn_srp_rate_assigns_pkg.insert_record
91: (x_rate_schedule_id => x_rate_schedule_id,
92: x_rate_tier_id => x_rate_tier_id,
93: x_rate_sequence => x_rate_sequence,
94:

Line 179: cn_srp_rate_assigns_pkg.synch_rate(

175:
176: IF x_commission_amount <> l_commission_amount_old THEN
177:
178: -- Only the commission amount is denormalized no srp_tiers to maintain
179: cn_srp_rate_assigns_pkg.synch_rate(
180: x_srp_plan_assign_id => null
181: ,x_srp_quota_assign_id => null
182: ,x_rate_schedule_id => x_rate_schedule_id
183: ,x_rate_tier_id => x_rate_tier_id

Line 231: cn_srp_rate_assigns_pkg.delete_record(

227: IF (SQL%NOTFOUND) then
228: Raise NO_DATA_FOUND;
229: END if;
230:
231: cn_srp_rate_assigns_pkg.delete_record(
232: x_srp_plan_assign_id => null
233: ,x_srp_rate_assign_id => null
234: ,x_quota_id => null
235: ,x_rate_schedule_id => x_rate_schedule_id