eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_FORMULA_INPUTS_PKG dependencies on CN_FORMULA_INPUTS_S

Line 11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 40: CURSOR id IS SELECT cn_formula_inputs_s.NEXTVAL FROM dual;

36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;
39:
40: CURSOR id IS SELECT cn_formula_inputs_s.NEXTVAL FROM dual;
41: BEGIN
42: IF (x_formula_input_id IS NULL) THEN
43: OPEN id;
44: FETCH id INTO x_formula_input_id;

Line 163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

Line 186: update CN_FORMULA_INPUTS set

182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set
187: CALC_SQL_EXP_ID = Decode(X_CALC_SQL_EXP_ID, fnd_api.g_miss_num, calc_sql_exp_id, x_calc_sql_exp_id),
188: F_CALC_SQL_EXP_ID = Decode(X_F_CALC_SQL_EXP_ID, fnd_api.g_miss_num, f_calc_sql_exp_id, x_f_calc_sql_exp_id),
189: RATE_DIM_SEQUENCE = Decode(X_RATE_DIM_SEQUENCE, fnd_api.g_miss_num, rate_dim_sequence, x_rate_dim_sequence),
190: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, CUMULATIVE_FLAG, X_CUMULATIVE_FLAG),