[Home] [Help]
5: table tier.
6:
7: Notes : If we add, update or delete a tier we must 'INCOMPLETE' any comp
8: plans that this schedule is assigned to (via a quota).
9: This is done in the calls to cn_comp_plans_pkg.set_status.
10: Since there is no custom validation in this package the com plan
11: status update could've gone at the start of the begin procedure.
12: But for consistency with the other packages we call it in each
13: individual insert, update and delete procedure.*/
41: CLOSE id;
42: END IF;
43:
44: -- invalidate all comp plans using a rate table with this tier
45: cn_comp_plans_pkg.set_status
46: (x_comp_plan_id => NULL,
47: x_quota_id => NULL,
48: x_rate_schedule_id => X_rate_schedule_id,
49: x_status_code => 'INCOMPLETE',
146: l_commission_amount_old number := 0;
147: BEGIN
148: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
149: -- invalidate all comp plans using a rate schedule with this tier
150: cn_comp_plans_pkg.set_status
151: (x_comp_plan_id => NULL,
152: x_quota_id => NULL,
153: x_rate_schedule_id => x_rate_schedule_id,
154: x_status_code => 'INCOMPLETE',
213: DELETE FROM cn_rate_tiers
214: WHERE rate_schedule_id = X_Rate_Schedule_Id;
215:
216: ELSE
217: cn_comp_plans_pkg.set_status(
218: x_comp_plan_id => NULL
219: ,x_quota_id => NULL
220: ,x_rate_schedule_id => X_rate_schedule_id
221: ,x_status_code => 'INCOMPLETE'