APPS.CN_ROLE_QUOTA_RATES_PKG dependencies on CN_ROLE_QUOTA_RATES_S

Line 38: CURSOR id IS SELECT cn_role_quota_rates_s.NEXTVAL FROM dual;

34: ) IS
35: cursor C is select ROWID from cn_role_quota_rates
36: where ROLE_QUOTA_RATE_ID = x_role_quota_rate_id;
37:
38: CURSOR id IS SELECT cn_role_quota_rates_s.NEXTVAL FROM dual;
39: BEGIN
40: IF (x_role_quota_rate_id IS NULL) THEN
41: OPEN id;
42: FETCH id INTO x_role_quota_rate_id;

Line 273: update CN_ROLE_QUOTA_RATES SET

269: X_LAST_UPDATE_LOGIN IN NUMBER,
270: X_OBJECT_VERSION_NUMBER IN NUMBER
271: ) IS
272: BEGIN
273: update CN_ROLE_QUOTA_RATES SET
274: ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID,
275: RATE_TIER_ID = X_RATE_TIER_ID,
276: RATE_SCHEDULE_ID = X_RATE_SCHEDULE_ID,
277: MIN_RATE = X_MIN_RATE,