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_CALC_FORMULAS_PVT dependencies on CN_CALC_FORMULAS

Line 1: PACKAGE BODY CN_CALC_FORMULAS_PVT AS

1: PACKAGE BODY CN_CALC_FORMULAS_PVT AS
2: /*$Header: cnvformb.pls 120.17 2006/06/20 01:02:42 jxsingh noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_FORMULAS_PVT';
5: g_end_of_time CONSTANT DATE := to_date('12-31-9999','MM-DD-YYYY');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_FORMULAS_PVT';

1: PACKAGE BODY CN_CALC_FORMULAS_PVT AS
2: /*$Header: cnvformb.pls 120.17 2006/06/20 01:02:42 jxsingh noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_FORMULAS_PVT';
5: g_end_of_time CONSTANT DATE := to_date('12-31-9999','MM-DD-YYYY');
6:
7: -- validate formula name and the flag combinations
8: PROCEDURE validate_name_flags

Line 9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,

5: g_end_of_time CONSTANT DATE := to_date('12-31-9999','MM-DD-YYYY');
6:
7: -- validate formula name and the flag combinations
8: PROCEDURE validate_name_flags
9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,
10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

Line 10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,

6:
7: -- validate formula name and the flag combinations
8: PROCEDURE validate_name_flags
9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,
10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

Line 11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,

7: -- validate formula name and the flag combinations
8: PROCEDURE validate_name_flags
9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,
10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

Line 12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

8: PROCEDURE validate_name_flags
9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,
10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

Line 13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

9: (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE := NULL,
10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

Line 14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

10: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

Line 15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

11: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
19: --R12 MOAC Changes--Start

Line 16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

12: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
19: --R12 MOAC Changes--Start
20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE

Line 17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

13: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
19: --R12 MOAC Changes--Start
20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE
21: --R12 MOAC Changes--End

Line 18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

14: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
15: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
19: --R12 MOAC Changes--Start
20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE
21: --R12 MOAC Changes--End
22: ) IS

Line 20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE

16: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
17: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
18: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
19: --R12 MOAC Changes--Start
20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE
21: --R12 MOAC Changes--End
22: ) IS
23:
24: l_prompt cn_lookups.meaning%TYPE;

Line 29: FROM cn_calc_formulas

25: l_dummy NUMBER;
26:
27: CURSOR formula_exists IS
28: SELECT 1
29: FROM cn_calc_formulas
30: WHERE name = p_name
31: AND (p_calc_formula_id IS NULL OR p_calc_formula_id <> calc_formula_id)
32: --R12 MOAC Changes--Start
33: AND org_id = p_org_id;

Line 178: PROCEDURE check_modeling (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

174: end if;
175: end loop;
176: end check_planning_exp;
177:
178: PROCEDURE check_modeling (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
179: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is

Line 179: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

175: end loop;
176: end check_planning_exp;
177:
178: PROCEDURE check_modeling (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
179: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is
183: select s.number_dim, d.dim_unit_code

Line 180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

176: end check_planning_exp;
177:
178: PROCEDURE check_modeling (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
179: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is
183: select s.number_dim, d.dim_unit_code
184: from cn_rt_formula_asgns a, cn_rate_schedules s,

Line 181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS

177:
178: PROCEDURE check_modeling (p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
179: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is
183: select s.number_dim, d.dim_unit_code
184: from cn_rt_formula_asgns a, cn_rate_schedules s,
185: cn_rate_sch_dims r, cn_rate_dimensions d

Line 237: p_name IN CN_CALC_FORMULAS.NAME%TYPE,

233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
237: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

Line 238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE

234: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
237: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

Line 240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,

236: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
237: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

Line 241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

237: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

Line 242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

238: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

Line 243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

239: := null,
240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,

Line 244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

240: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

Line 245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

241: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

Line 246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

242: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE

Line 247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,

243: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
251: := NULL,

Line 248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

244: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
251: := NULL,
252: p_input_tbl IN input_tbl_type := g_miss_input_tbl,

Line 249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

245: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
251: := NULL,
252: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
253: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,

Line 250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE

246: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
247: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
248: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
249: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
250: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE
251: := NULL,
252: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
253: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
254: --R12 MOAC Changes--Start

Line 255: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new

251: := NULL,
252: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
253: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
254: --R12 MOAC Changes--Start
255: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
256: x_calc_formula_id IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE, --changed
257: --R12 MOAC Changes--End
258: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,

Line 256: x_calc_formula_id IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE, --changed

252: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
253: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
254: --R12 MOAC Changes--Start
255: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
256: x_calc_formula_id IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE, --changed
257: --R12 MOAC Changes--End
258: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,

Line 258: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

254: --R12 MOAC Changes--Start
255: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
256: x_calc_formula_id IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE, --changed
257: --R12 MOAC Changes--End
258: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2) IS
262: l_api_name CONSTANT VARCHAR2(30) := 'Create_Formula';

Line 311: -- call table handler to create the formula record in cn_calc_formulas

307: p_org_id
308: --R12 MOAC Changes--End
309: );
310:
311: -- call table handler to create the formula record in cn_calc_formulas
312: cn_calc_formulas_pkg.insert_row
313: (x_calc_formula_id => x_calc_formula_id,
314: x_name => p_name,
315: x_description => p_description,

Line 312: cn_calc_formulas_pkg.insert_row

308: --R12 MOAC Changes--End
309: );
310:
311: -- call table handler to create the formula record in cn_calc_formulas
312: cn_calc_formulas_pkg.insert_row
313: (x_calc_formula_id => x_calc_formula_id,
314: x_name => p_name,
315: x_description => p_description,
316: x_formula_type => p_formula_type,

Line 337: from cn_calc_formulas

333:
334: l_consolidated_note := '';
335:
336: select name into l_formula_name
337: from cn_calc_formulas
338: where calc_formula_id = x_calc_formula_id;
339:
340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');
341: fnd_message.set_token('FORMULA_NAME', l_formula_name);

Line 350: p_source_object_code => 'CN_CALC_FORMULAS',

346: x_return_status => x_return_status,
347: x_msg_count => x_msg_count,
348: x_msg_data => x_msg_data,
349: p_source_object_id => x_calc_formula_id,
350: p_source_object_code => 'CN_CALC_FORMULAS',
351: p_notes => l_note_msg,
352: p_notes_detail => l_note_msg,
353: p_note_type => 'CN_SYSGEN', -- for system generated
354: x_jtf_note_id => l_note_id -- returned

Line 374: p_source_object_code => 'CN_CALC_FORMULAS',

370: x_return_status => x_return_status,
371: x_msg_count => x_msg_count,
372: x_msg_data => x_msg_data,
373: p_source_object_id => x_calc_formula_id,
374: p_source_object_code => 'CN_CALC_FORMULAS',
375: p_notes => l_note_msg,
376: p_notes_detail => l_note_msg,
377: p_note_type => 'CN_SYSGEN', -- for system generated
378: x_jtf_note_id => l_note_id -- returned

Line 400: p_source_object_code => 'CN_CALC_FORMULAS',

396: x_return_status => x_return_status,
397: x_msg_count => x_msg_count,
398: x_msg_data => x_msg_data,
399: p_source_object_id => x_calc_formula_id,
400: p_source_object_code => 'CN_CALC_FORMULAS',
401: p_notes => l_note_msg,
402: p_notes_detail => l_note_msg,
403: p_note_type => 'CN_SYSGEN', -- for system generated
404: x_jtf_note_id => l_note_id -- returned

Line 417: p_source_object_code => 'CN_CALC_FORMULAS',

413: x_return_status => x_return_status,
414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data,
416: p_source_object_id => x_calc_formula_id,
417: p_source_object_code => 'CN_CALC_FORMULAS',
418: p_notes => l_consolidated_note,
419: p_notes_detail => l_consolidated_note,
420: p_note_type => 'CN_SYSGEN', -- for system generated
421: x_jtf_note_id => l_note_id -- returned

Line 441: p_source_object_code => 'CN_CALC_FORMULAS',

437: x_return_status => x_return_status,
438: x_msg_count => x_msg_count,
439: x_msg_data => x_msg_data,
440: p_source_object_id => x_calc_formula_id,
441: p_source_object_code => 'CN_CALC_FORMULAS',
442: p_notes => l_note_msg,
443: p_notes_detail => l_note_msg,
444: p_note_type => 'CN_SYSGEN', -- for system generated
445: x_jtf_note_id => l_note_id -- returned

Line 580: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

576: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
577: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
580: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,

Line 581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,

577: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
580: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

Line 582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE

578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579: p_generate_packages IN VARCHAR2 := FND_API.G_TRUE ,
580: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

Line 584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,

580: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

Line 585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

581: p_name IN CN_CALC_FORMULAS.NAME%TYPE,
582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

Line 586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

582: p_description IN CN_CALC_FORMULAS.DESCRIPTION%TYPE
583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

Line 587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

583: := null,
584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

Line 588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,

584: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,

Line 589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

585: p_formula_status IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

Line 590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,

586: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

Line 591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,

587: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,

Line 592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,

588: p_cumulative_flag IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE,
589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,

Line 593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

589: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
597: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,

Line 594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

590: p_split_flag IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE,
591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
597: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
598: --R12 MOAC Changes--Start

Line 595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,

591: p_threshold_all_tier_flag IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE,
592: p_modeling_flag IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE,
593: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
594: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
597: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
598: --R12 MOAC Changes--Start
599: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new

Line 599: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new

595: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
597: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
598: --R12 MOAC Changes--Start
599: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
600: p_object_version_number IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --Changed
601: --R12 MOAC Changes--End
602: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
603: x_return_status OUT NOCOPY VARCHAR2,

Line 600: p_object_version_number IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --Changed

596: p_input_tbl IN input_tbl_type := g_miss_input_tbl,
597: p_rt_assign_tbl IN rt_assign_tbl_type := g_miss_rt_assign_tbl,
598: --R12 MOAC Changes--Start
599: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
600: p_object_version_number IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --Changed
601: --R12 MOAC Changes--End
602: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,

Line 602: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

598: --R12 MOAC Changes--Start
599: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --new
600: p_object_version_number IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --Changed
601: --R12 MOAC Changes--End
602: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2) IS
606:

Line 612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;

608: l_api_version CONSTANT NUMBER := 1.0;
609: l_temp_id NUMBER;
610: l_update_count NUMBER := 0;
611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;
612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
613: l_count_formula_input NUMBER := 0;
614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;
615:
616: /* Start - R12 Notes History */

Line 639: FROM cn_calc_formulas cf, cn_lookups cl,

635: SELECT cf.calc_formula_id, cf.NAME, cf.FORMULA_TYPE, cf.TRX_GROUP_CODE,
636: cf.SPLIT_FLAG, cf.CUMULATIVE_FLAG, cf.ITD_FLAG, cf.MODELING_FLAG, cl.MEANING,
637: cf.output_exp_id, cf.f_output_exp_id, cf.perf_measure_id, cs1.name oname,
638: cs2.name fname, cs3.name pname
639: FROM cn_calc_formulas cf, cn_lookups cl,
640: cn_calc_sql_exps cs1, cn_calc_sql_exps cs2, cn_calc_sql_exps cs3
641: WHERE cl.lookup_code = cf.FORMULA_TYPE
642: AND cl.lookup_type = 'FORMULA_TYPE'
643: AND cf.OUTPUT_EXP_ID = cs1.CALC_SQL_EXP_ID (+)

Line 676: FROM cn_calc_formulas

672: perf_measure_id,
673: output_exp_id,
674: f_output_exp_id,
675: formula_status
676: FROM cn_calc_formulas
677: WHERE calc_formula_id = p_calc_formula_id;
678: rec_info c1%ROWTYPE;
679:
680: cursor get_plans is

Line 832: -- call table handler to update the formula record in cn_calc_formulas

828: FETCH get_old_formula_rec INTO l_old_rec;
829: CLOSE get_old_formula_rec;
830: /* End - R12 Notes History */
831:
832: -- call table handler to update the formula record in cn_calc_formulas
833: cn_calc_formulas_pkg.lock_row
834: (x_calc_formula_id => p_calc_formula_id,
835: x_object_version_number => p_object_version_number);
836: cn_calc_formulas_pkg.update_row

Line 833: cn_calc_formulas_pkg.lock_row

829: CLOSE get_old_formula_rec;
830: /* End - R12 Notes History */
831:
832: -- call table handler to update the formula record in cn_calc_formulas
833: cn_calc_formulas_pkg.lock_row
834: (x_calc_formula_id => p_calc_formula_id,
835: x_object_version_number => p_object_version_number);
836: cn_calc_formulas_pkg.update_row
837: (x_calc_formula_id => p_calc_formula_id,

Line 836: cn_calc_formulas_pkg.update_row

832: -- call table handler to update the formula record in cn_calc_formulas
833: cn_calc_formulas_pkg.lock_row
834: (x_calc_formula_id => p_calc_formula_id,
835: x_object_version_number => p_object_version_number);
836: cn_calc_formulas_pkg.update_row
837: (x_calc_formula_id => p_calc_formula_id,
838: x_name => p_name,
839: x_description => p_description,
840: x_formula_status => x_formula_status,

Line 873: p_source_object_code => 'CN_CALC_FORMULAS',

869: x_return_status => x_return_status,
870: x_msg_count => x_msg_count,
871: x_msg_data => x_msg_data,
872: p_source_object_id => p_calc_formula_id,
873: p_source_object_code => 'CN_CALC_FORMULAS',
874: p_notes => l_note_msg,
875: p_notes_detail => l_note_msg,
876: p_note_type => 'CN_SYSGEN', -- for system generated
877: x_jtf_note_id => l_note_id -- returned

Line 884: FROM cn_calc_formulas cf, cn_lookups cl

880: END IF;
881:
882: IF (l_old_rec.formula_type <> p_formula_type) THEN
883: SELECT meaning into l_meaning
884: FROM cn_calc_formulas cf, cn_lookups cl
885: WHERE cl.lookup_code = cf.FORMULA_TYPE
886: AND cl.lookup_type = 'FORMULA_TYPE'
887: AND calc_formula_id = p_calc_formula_id;
888:

Line 902: p_source_object_code => 'CN_CALC_FORMULAS',

898: x_return_status => x_return_status,
899: x_msg_count => x_msg_count,
900: x_msg_data => x_msg_data,
901: p_source_object_id => p_calc_formula_id,
902: p_source_object_code => 'CN_CALC_FORMULAS',
903: p_notes => l_note_msg,
904: p_notes_detail => l_note_msg,
905: p_note_type => 'CN_SYSGEN', -- for system generated
906: x_jtf_note_id => l_note_id -- returned

Line 925: p_source_object_code => 'CN_CALC_FORMULAS',

921: x_return_status => x_return_status,
922: x_msg_count => x_msg_count,
923: x_msg_data => x_msg_data,
924: p_source_object_id => p_calc_formula_id,
925: p_source_object_code => 'CN_CALC_FORMULAS',
926: p_notes => l_note_msg,
927: p_notes_detail => l_note_msg,
928: p_note_type => 'CN_SYSGEN', -- for system generated
929: x_jtf_note_id => l_note_id -- returned

Line 959: p_source_object_code => 'CN_CALC_FORMULAS',

955: x_return_status => x_return_status,
956: x_msg_count => x_msg_count,
957: x_msg_data => x_msg_data,
958: p_source_object_id => p_calc_formula_id,
959: p_source_object_code => 'CN_CALC_FORMULAS',
960: p_notes => l_note_msg,
961: p_notes_detail => l_note_msg,
962: p_note_type => 'CN_SYSGEN', -- for system generated
963: x_jtf_note_id => l_note_id -- returned

Line 985: p_source_object_code => 'CN_CALC_FORMULAS',

981: x_return_status => x_return_status,
982: x_msg_count => x_msg_count,
983: x_msg_data => x_msg_data,
984: p_source_object_id => p_calc_formula_id,
985: p_source_object_code => 'CN_CALC_FORMULAS',
986: p_notes => l_note_msg,
987: p_notes_detail => l_note_msg,
988: p_note_type => 'CN_SYSGEN', -- for system generated
989: x_jtf_note_id => l_note_id -- returned

Line 1011: p_source_object_code => 'CN_CALC_FORMULAS',

1007: x_return_status => x_return_status,
1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data,
1010: p_source_object_id => p_calc_formula_id,
1011: p_source_object_code => 'CN_CALC_FORMULAS',
1012: p_notes => l_note_msg,
1013: p_notes_detail => l_note_msg,
1014: p_note_type => 'CN_SYSGEN', -- for system generated
1015: x_jtf_note_id => l_note_id -- returned

Line 1037: p_source_object_code => 'CN_CALC_FORMULAS',

1033: x_return_status => x_return_status,
1034: x_msg_count => x_msg_count,
1035: x_msg_data => x_msg_data,
1036: p_source_object_id => p_calc_formula_id,
1037: p_source_object_code => 'CN_CALC_FORMULAS',
1038: p_notes => l_note_msg,
1039: p_notes_detail => l_note_msg,
1040: p_note_type => 'CN_SYSGEN', -- for system generated
1041: x_jtf_note_id => l_note_id -- returned

Line 1053: p_source_object_code => 'CN_CALC_FORMULAS',

1049: x_return_status => x_return_status,
1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data,
1052: p_source_object_id => p_calc_formula_id,
1053: p_source_object_code => 'CN_CALC_FORMULAS',
1054: p_notes => l_consolidated_note,
1055: p_notes_detail => l_consolidated_note,
1056: p_note_type => 'CN_SYSGEN', -- for system generated
1057: x_jtf_note_id => l_note_id -- returned

Line 1088: p_source_object_code => 'CN_CALC_FORMULAS',

1084: x_return_status => x_return_status,
1085: x_msg_count => x_msg_count,
1086: x_msg_data => x_msg_data,
1087: p_source_object_id => p_calc_formula_id,
1088: p_source_object_code => 'CN_CALC_FORMULAS',
1089: p_notes => l_note_msg,
1090: p_notes_detail => l_note_msg,
1091: p_note_type => 'CN_SYSGEN', -- for system generated
1092: x_jtf_note_id => l_note_id -- returned

Line 1111: p_source_object_code => 'CN_CALC_FORMULAS',

1107: x_return_status => x_return_status,
1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data,
1110: p_source_object_id => p_calc_formula_id,
1111: p_source_object_code => 'CN_CALC_FORMULAS',
1112: p_notes => l_note_msg,
1113: p_notes_detail => l_note_msg,
1114: p_note_type => 'CN_SYSGEN', -- for system generated
1115: x_jtf_note_id => l_note_id -- returned

Line 1149: p_source_object_code => 'CN_CALC_FORMULAS',

1145: x_return_status => x_return_status,
1146: x_msg_count => x_msg_count,
1147: x_msg_data => x_msg_data,
1148: p_source_object_id => p_calc_formula_id,
1149: p_source_object_code => 'CN_CALC_FORMULAS',
1150: p_notes => l_note_msg,
1151: p_notes_detail => l_note_msg,
1152: p_note_type => 'CN_SYSGEN', -- for system generated
1153: x_jtf_note_id => l_note_id -- returned

Line 1172: p_source_object_code => 'CN_CALC_FORMULAS',

1168: x_return_status => x_return_status,
1169: x_msg_count => x_msg_count,
1170: x_msg_data => x_msg_data,
1171: p_source_object_id => p_calc_formula_id,
1172: p_source_object_code => 'CN_CALC_FORMULAS',
1173: p_notes => l_note_msg,
1174: p_notes_detail => l_note_msg,
1175: p_note_type => 'CN_SYSGEN', -- for system generated
1176: x_jtf_note_id => l_note_id -- returned

Line 1189: p_source_object_code => 'CN_CALC_FORMULAS',

1185: x_return_status => x_return_status,
1186: x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data,
1188: p_source_object_id => p_calc_formula_id,
1189: p_source_object_code => 'CN_CALC_FORMULAS',
1190: p_notes => l_consolidated_exp_note,
1191: p_notes_detail => l_consolidated_exp_note,
1192: p_note_type => 'CN_SYSGEN', -- for system generated
1193: x_jtf_note_id => l_note_id -- returned

Line 1224: p_source_object_code => 'CN_CALC_FORMULAS',

1220: x_return_status => x_return_status,
1221: x_msg_count => x_msg_count,
1222: x_msg_data => x_msg_data,
1223: p_source_object_id => p_calc_formula_id,
1224: p_source_object_code => 'CN_CALC_FORMULAS',
1225: p_notes => l_note_msg,
1226: p_notes_detail => l_note_msg,
1227: p_note_type => 'CN_SYSGEN', -- for system generated
1228: x_jtf_note_id => l_note_id -- returned

Line 1243: p_source_object_code => 'CN_CALC_FORMULAS',

1239: x_return_status => x_return_status,
1240: x_msg_count => x_msg_count,
1241: x_msg_data => x_msg_data,
1242: p_source_object_id => p_calc_formula_id,
1243: p_source_object_code => 'CN_CALC_FORMULAS',
1244: p_notes => l_note_msg,
1245: p_notes_detail => l_note_msg,
1246: p_note_type => 'CN_SYSGEN', -- for system generated
1247: x_jtf_note_id => l_note_id -- returned

Line 1446: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

1442: (p_api_version IN NUMBER ,
1443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1444: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1446: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1447: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
1448: --R12 MOAC Changes--Start
1449: p_object_version_number IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --new
1450: --R12 MOAC Changes--End

Line 1447: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change

1443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1444: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1446: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1447: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
1448: --R12 MOAC Changes--Start
1449: p_object_version_number IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --new
1450: --R12 MOAC Changes--End
1451: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1449: p_object_version_number IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --new

1445: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1446: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1447: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE, --SFP related change
1448: --R12 MOAC Changes--Start
1449: p_object_version_number IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE, --new
1450: --R12 MOAC Changes--End
1451: x_return_status OUT NOCOPY VARCHAR2 ,
1452: x_msg_count OUT NOCOPY NUMBER ,
1453: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 1520: from cn_calc_formulas f, cn_role_quota_cates r

1516: RAISE fnd_api.g_exc_error;
1517: END IF;
1518:
1519: select count(1) into l_dummy
1520: from cn_calc_formulas f, cn_role_quota_cates r
1521: where f.calc_formula_id = p_calc_formula_id
1522: and f.calc_formula_id = r.calc_formula_id
1523: and f.modeling_flag = 'Y';
1524: if l_dummy > 0 THEN

Line 1534: --FROM cn_calc_formulas

1530: END IF;
1531:
1532: /* Start - R12 Notes History */
1533: --SELECT org_id, name INTO l_org_id, l_formula_name
1534: --FROM cn_calc_formulas
1535: --WHERE calc_formula_id = p_calc_formula_id;
1536:
1537: SELECT name INTO l_formula_name
1538: FROM cn_calc_formulas

Line 1538: FROM cn_calc_formulas

1534: --FROM cn_calc_formulas
1535: --WHERE calc_formula_id = p_calc_formula_id;
1536:
1537: SELECT name INTO l_formula_name
1538: FROM cn_calc_formulas
1539: WHERE calc_formula_id = p_calc_formula_id
1540: AND org_id = p_org_id;
1541:
1542: /* End - R12 Notes History */

Line 1544: cn_calc_formulas_pkg.delete_row(p_calc_formula_id, p_org_id);

1540: AND org_id = p_org_id;
1541:
1542: /* End - R12 Notes History */
1543:
1544: cn_calc_formulas_pkg.delete_row(p_calc_formula_id, p_org_id);
1545:
1546: /* Start - R12 Notes History */
1547: IF (p_org_id <> -999) THEN
1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');

Line 1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

1617: (p_api_version IN NUMBER ,
1618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1619: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

Line 1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,

1618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1619: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

Line 1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,

1619: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

Line 1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,

1620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,

Line 1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,

1621: p_calc_formula_id IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

Line 1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,

1622: p_formula_type IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE,
1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
1630: --R12 MOAC Changes--Start

Line 1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,

1623: p_trx_group_code IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE,
1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
1630: --R12 MOAC Changes--Start
1631: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,

Line 1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,

1624: p_number_dim IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE,
1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
1630: --R12 MOAC Changes--Start
1631: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,
1632: --R12 MOAC Changes--End

Line 1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,

1625: p_itd_flag IN CN_CALC_FORMULAS.ITD_FLAG%TYPE,
1626: p_perf_measure_id IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE,
1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
1630: --R12 MOAC Changes--Start
1631: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,
1632: --R12 MOAC Changes--End
1633: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1631: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,

1627: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
1628: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE,
1629: x_formula_status OUT NOCOPY CN_CALC_FORMULAS.FORMULA_STATUS%TYPE,
1630: --R12 MOAC Changes--Start
1631: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE,
1632: --R12 MOAC Changes--End
1633: x_return_status OUT NOCOPY VARCHAR2 ,
1634: x_msg_count OUT NOCOPY NUMBER ,
1635: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;

1640: l_process_audit_id NUMBER;
1641: l_input_count pls_integer := 0;
1642: l_dummy pls_integer;
1643: l_ii_flag VARCHAR2(30) := 'N';
1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;

Line 1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;

1641: l_input_count pls_integer := 0;
1642: l_dummy pls_integer;
1643: l_ii_flag VARCHAR2(30) := 'N';
1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;

Line 1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;

1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;

Line 1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;

1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;

Line 1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;

1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;

Line 1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;

1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;
1655: l_count_formula_input NUMBER := 0;

Line 1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;

1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;
1655: l_count_formula_input NUMBER := 0;
1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;

Line 1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;

1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;
1655: l_count_formula_input NUMBER := 0;
1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;
1657:

Line 1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;

1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;
1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;
1655: l_count_formula_input NUMBER := 0;
1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;
1657:
1658: --clku

Line 1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;

1652: l_perf_measure_id CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE;
1653: l_output_exp_id CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE;
1654: l_f_output_exp_id CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE;
1655: l_count_formula_input NUMBER := 0;
1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;
1657:
1658: --clku
1659: l_name CN_CALC_FORMULAS.NAME%TYPE;
1660:

Line 1659: l_name CN_CALC_FORMULAS.NAME%TYPE;

1655: l_count_formula_input NUMBER := 0;
1656: l_split_flag CN_CALC_FORMULAS.SPLIT_FLAG%TYPE;
1657:
1658: --clku
1659: l_name CN_CALC_FORMULAS.NAME%TYPE;
1660:
1661:
1662: CURSOR formula_info IS
1663: SELECT

Line 1671: FROM cn_calc_formulas

1667: itd_flag,
1668: perf_measure_id,
1669: output_exp_id,
1670: f_output_exp_id
1671: FROM cn_calc_formulas
1672: WHERE calc_formula_id = p_calc_formula_id;
1673:
1674: CURSOR formula_split_info IS
1675: SELECT

Line 1677: FROM cn_calc_formulas

1673:
1674: CURSOR formula_split_info IS
1675: SELECT
1676: split_flag
1677: FROM cn_calc_formulas
1678: WHERE calc_formula_id = p_calc_formula_id;
1679:
1680:
1681: CURSOR perf_measure IS

Line 1967: from cn_calc_formulas

1963:
1964: -- clku, bug 2805095, call mark event here instead of call in table trigger
1965: select name into
1966: l_name
1967: from cn_calc_formulas
1968: where calc_formula_id = p_calc_formula_id;
1969:
1970: cn_mark_events_pkg.mark_event_formula
1971: (p_event_name => 'CHANGE_FORMULA',

Line 2029: END CN_CALC_FORMULAS_PVT;

2025: p_data => x_msg_data ,
2026: p_encoded => FND_API.G_FALSE );
2027: END generate_formula;
2028:
2029: END CN_CALC_FORMULAS_PVT;