[Home] [Help]
5: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
6: X_CALC_SQL_EXP_ID IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
7: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
8: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
9: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := NULL,
10: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := NULL,
11: X_EXPRESSION_DISP IN VARCHAR2 := NULL, -- CLOBs
12: X_SQL_SELECT IN VARCHAR2 := NULL,
13: X_SQL_FROM IN VARCHAR2 := NULL,
38: X_OBJECT_VERSION_NUMBER OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE
39: ) is
40: cursor C is select calc_sql_exp_id from CN_CALC_SQL_EXPS
41: where CALC_SQL_EXP_ID = x_calc_sql_exp_id;
42: CURSOR id IS SELECT cn_calc_sql_exps_s.NEXTVAL FROM dual;
43:
44: x_return_status VARCHAR2(4000);
45: l_note_msg VARCHAR2(4000);
46: x_msg_data VARCHAR2(4000);
185: X_ORG_ID IN CN_CALC_SQl_EXPS.ORG_ID%TYPE,
186: X_CALC_SQL_EXP_ID IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
187: X_NAME IN CN_CALC_SQL_EXPS.NAME%TYPE,
188: X_DESCRIPTION IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
189: X_STATUS IN CN_CALC_SQL_EXPS.STATUS%TYPE := CN_API.G_MISS_CHAR,
190: X_EXP_TYPE_CODE IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE := CN_API.G_MISS_CHAR,
191: X_EXPRESSION_DISP IN VARCHAR2 := CN_API.G_MISS_CHAR,
192: X_SQL_SELECT IN VARCHAR2 := CN_API.G_MISS_CHAR,
193: X_SQL_FROM IN VARCHAR2 := CN_API.G_MISS_CHAR,
218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_SQL_EXPS 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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),