65: --
66: -- End of comments
67: PROCEDURE Create_Formula
68: (p_api_version IN NUMBER ,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
73: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
66: -- End of comments
67: PROCEDURE Create_Formula
68: (p_api_version IN NUMBER ,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
73: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
74: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
67: PROCEDURE Create_Formula
68: (p_api_version IN NUMBER ,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
73: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
74: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
75: := null,
68: (p_api_version IN NUMBER ,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
73: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
74: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
75: := null,
76: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
109: --
110: -- End of comments
111: PROCEDURE Update_Formula
112: (p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
117: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
110: -- End of comments
111: PROCEDURE Update_Formula
112: (p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
117: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
118: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
111: PROCEDURE Update_Formula
112: (p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
117: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
118: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
119: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
112: (p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
117: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
118: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
119: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
120: := null,
147: --
148: -- End of comments
149: PROCEDURE Delete_Formula
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
155: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
148: -- End of comments
149: PROCEDURE Delete_Formula
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
155: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
156: --R12 MOAC Changes--Start
149: PROCEDURE Delete_Formula
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
155: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
156: --R12 MOAC Changes--Start
157: p_object_version_number IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --new
166: --
167: -- End of comments
168: PROCEDURE generate_formula
169: (p_api_version IN NUMBER ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
174: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE
167: -- End of comments
168: PROCEDURE generate_formula
169: (p_api_version IN NUMBER ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
174: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE
175: := fnd_api.g_miss_char ,
168: PROCEDURE generate_formula
169: (p_api_version IN NUMBER ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
174: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE
175: := fnd_api.g_miss_char ,
176: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
174: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE
175: := fnd_api.g_miss_char ,
176: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE
177: := fnd_api.g_miss_char ,
178: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE
179: := fnd_api.g_miss_num ,
173: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
174: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE
175: := fnd_api.g_miss_char ,
176: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE
177: := fnd_api.g_miss_char ,
178: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE
179: := fnd_api.g_miss_num ,
180: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE
181: := fnd_api.g_miss_char ,
175: := fnd_api.g_miss_char ,
176: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE
177: := fnd_api.g_miss_char ,
178: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE
179: := fnd_api.g_miss_num ,
180: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE
181: := fnd_api.g_miss_char ,
182: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE
183: := fnd_api.g_miss_num ,
177: := fnd_api.g_miss_char ,
178: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE
179: := fnd_api.g_miss_num ,
180: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE
181: := fnd_api.g_miss_char ,
182: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE
183: := fnd_api.g_miss_num ,
184: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE
185: := fnd_api.g_miss_num ,
179: := fnd_api.g_miss_num ,
180: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE
181: := fnd_api.g_miss_char ,
182: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE
183: := fnd_api.g_miss_num ,
184: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE
185: := fnd_api.g_miss_num ,
186: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
187: := fnd_api.g_miss_num ,
181: := fnd_api.g_miss_char ,
182: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE
183: := fnd_api.g_miss_num ,
184: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE
185: := fnd_api.g_miss_num ,
186: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
187: := fnd_api.g_miss_num ,
188: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
189: --R12 MOAC Changes--Start
183: := fnd_api.g_miss_num ,
184: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE
185: := fnd_api.g_miss_num ,
186: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
187: := fnd_api.g_miss_num ,
188: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
189: --R12 MOAC Changes--Start
190: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,
191: --R12 MOAC Changes--End