DBA Data[Home] [Help]

APPS.CN_CALC_FORMULAS_PKG dependencies on CN_CALC_FORMULAS_S

Line 14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,

10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,

Line 48: CURSOR id IS SELECT cn_calc_formulas_s.NEXTVAL FROM dual;

44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS
46: where CALC_FORMULA_ID = x_calc_formula_id;
47:
48: CURSOR id IS SELECT cn_calc_formulas_s.NEXTVAL FROM dual;
49: BEGIN
50: IF (x_calc_formula_id IS NULL) THEN
51: OPEN id;
52: FETCH id INTO x_calc_formula_id;

Line 192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,

188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,

Line 222: update CN_CALC_FORMULAS set

218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_FORMULAS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),