DBA Data[Home] [Help]

APPS.CN_CALC_FORMULAS_PVT dependencies on FND_API

Line 69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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,

Line 70: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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

Line 71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 72: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,

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,

Line 113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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,

Line 114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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,

Line 115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 116: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,

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,

Line 151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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

Line 152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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

Line 153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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

Line 170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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

Line 171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 175: := fnd_api.g_miss_char ,

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 ,

Line 177: := fnd_api.g_miss_char ,

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 ,

Line 179: := fnd_api.g_miss_num ,

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 ,

Line 181: := fnd_api.g_miss_char ,

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 ,

Line 183: := 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 ,

Line 185: := 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

Line 187: := fnd_api.g_miss_num ,

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