APPS.CN_RATE_TIERS_PKG dependencies on DUAL

Line 13: individual insert, update and delete procedure.*/

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.*/
14:
15: PROCEDURE INSERT_ROW
16: (X_RATE_TIER_ID IN OUT NOCOPY CN_RATE_TIERS.RATE_TIER_ID%TYPE,
17: X_RATE_SCHEDULE_ID IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,

Line 32: CURSOR id IS SELECT CN_RATE_TIERS_S.NEXTVAL FROM DUAL;

28:
29: CURSOR C IS SELECT RATE_TIER_ID FROM CN_RATE_TIERS
30: WHERE RATE_TIER_ID = X_RATE_TIER_ID;
31:
32: CURSOR id IS SELECT CN_RATE_TIERS_S.NEXTVAL FROM DUAL;
33: BEGIN
34: IF (x_rate_tier_id IS NULL) THEN
35: OPEN id;
36: FETCH id INTO x_rate_tier_id;

Line 201: -- If the tier_id is not null then we delete an individual tier.

197: -- Notes
198: -- If the rate tier id is null this routine has been called on delete
199: -- or a rate schedule. You cannot delete a schedule that is assigned to a
200: -- quota so there's no need to try and update the status of the plans.
201: -- If the tier_id is not null then we delete an individual tier.
202:
203: PROCEDURE Delete_Row
204: (X_RATE_SCHEDULE_ID IN CN_RATE_TIERS.RATE_SCHEDULE_ID%TYPE,
205: X_RATE_TIER_ID IN CN_RATE_TIERS.RATE_TIER_ID%TYPE) IS