APPS.CN_RATE_SCH_DIMS_PKG dependencies on CN_RATE_SCH_DIMS_S

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

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

Line 169: update CN_RATE_SCH_DIMS set

165: BEGIN
166:
167: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
168:
169: update CN_RATE_SCH_DIMS set
170: RATE_DIMENSION_ID = Decode(X_RATE_DIMENSION_ID, fnd_api.g_miss_num, rate_dimension_id, x_rate_dimension_id),
171: -- RATE_SCHEDULE_ID = Decode(X_RATE_SCHEDULE_ID, fnd_api.g_miss_num, rate_schedule_id, x_rate_schedule_id),
172: RATE_DIM_SEQUENCE = Decode(X_RATE_DIM_SEQUENCE, fnd_api.g_miss_num, rate_dim_sequence, x_rate_dim_sequence),
173: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),