DBA Data[Home] [Help]

APPS.CN_RATE_DIMENSIONS_PKG dependencies on CN_RATE_DIMENSIONS_S

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

34:
35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS
36: where RATE_DIMENSION_ID = x_rate_dimension_id;
37:
38: CURSOR id IS SELECT cn_rate_dimensions_s.NEXTVAL FROM dual;
39: BEGIN
40: IF (x_rate_dimension_id IS NULL) THEN
41: OPEN id;
42: FETCH id INTO x_rate_dimension_id;

Line 184: update CN_RATE_DIMENSIONS set

180: BEGIN
181:
182: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
183:
184: update CN_RATE_DIMENSIONS set
185: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
186: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
187: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
188: NUMBER_TIER = Decode(X_NUMBER_TIER, fnd_api.g_miss_num, number_tier, x_number_tier),