APPS.CN_MULTI_RATE_SCHEDULES_PKG dependencies on CN_RATE_SCHEDULES_S

Line 36: CURSOR id IS SELECT cn_rate_schedules_s.NEXTVAL FROM dual;

32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_schedule_id from CN_RATE_SCHEDULES
34: where RATE_SCHEDULE_ID = x_rate_schedule_id;
35:
36: CURSOR id IS SELECT cn_rate_schedules_s.NEXTVAL FROM dual;
37: BEGIN
38: IF (x_rate_schedule_id IS NULL) THEN
39: OPEN id;
40: FETCH id INTO x_rate_schedule_id;

Line 170: update CN_RATE_SCHEDULES set

166: BEGIN
167:
168: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
169:
170: update CN_RATE_SCHEDULES set
171: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
172: COMMISSION_UNIT_CODE = Decode(X_COMMISSION_UNIT_CODE, fnd_api.g_miss_char, commission_unit_code, x_commission_unit_code),
173: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_num, number_dim, x_number_dim),
174: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),