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

Line 1: package body CN_CALC_FORMULAS_PKG as

1: package body CN_CALC_FORMULAS_PKG as
2: /* $Header: cntformb.pls 120.4 2006/05/26 00:49:04 jxsingh ship $ */
3:
4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

Line 5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

1: package body CN_CALC_FORMULAS_PKG as
2: /* $Header: cntformb.pls 120.4 2006/05/26 00:49:04 jxsingh ship $ */
3:
4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,

Line 6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,

2: /* $Header: cntformb.pls 120.4 2006/05/26 00:49:04 jxsingh ship $ */
3:
4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,

Line 7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,

3:
4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,

Line 8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',

4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,

Line 9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,

5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,

Line 10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,

6: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,

Line 11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,

7: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,

Line 12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,

8: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,

Line 13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,

9: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,

Line 14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,

10: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,

Line 15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,

11: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,

Line 16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,

12: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start

Line 17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,

13: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,

Line 18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,

14: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End

Line 19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,

15: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,

17: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,

Line 23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,

19: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,

Line 24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,

20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,

Line 25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,

21: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,

Line 26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,

22: --R12 MOAC Changes--End
23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,

Line 27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,

23: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,

Line 28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,

24: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,

Line 29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,

25: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,

Line 30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,

26: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,

Line 31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,

27: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,

Line 32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,

28: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,

Line 33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,

29: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,

Line 34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,

30: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,

Line 35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,

31: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,

Line 36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,

32: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,

33: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,

34: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,

35: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

Line 40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

36: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
44:

Line 41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,

37: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS

Line 42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

38: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS
46: where CALC_FORMULA_ID = x_calc_formula_id;

Line 43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

39: X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40: X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS
46: where CALC_FORMULA_ID = x_calc_formula_id;
47:

Line 45: cursor C is select calc_formula_id from CN_CALC_FORMULAS

41: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS
46: where CALC_FORMULA_ID = x_calc_formula_id;
47:
48: CURSOR id IS SELECT cn_calc_formulas_s.NEXTVAL FROM dual;
49: BEGIN

Line 48: CURSOR id IS SELECT cn_calc_formulas_s.NEXTVAL FROM dual;

44:
45: cursor C is select calc_formula_id from CN_CALC_FORMULAS
46: where CALC_FORMULA_ID = x_calc_formula_id;
47:
48: CURSOR id IS SELECT cn_calc_formulas_s.NEXTVAL FROM dual;
49: BEGIN
50: IF (x_calc_formula_id IS NULL) THEN
51: OPEN id;
52: FETCH id INTO x_calc_formula_id;

Line 60: insert into CN_CALC_FORMULAS (

56: END IF;
57: CLOSE id;
58: END IF;
59:
60: insert into CN_CALC_FORMULAS (
61: CALC_FORMULA_ID,
62: NAME,
63: DESCRIPTION,
64: FORMULA_STATUS,

Line 154: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

150:
151: end INSERT_ROW;
152:
153: procedure LOCK_ROW (
154: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
155: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE) IS
156:
157: cursor c is
158: select object_version_number

Line 155: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE) IS

151: end INSERT_ROW;
152:
153: procedure LOCK_ROW (
154: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
155: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE) IS
156:
157: cursor c is
158: select object_version_number
159: from cn_calc_formulas

Line 159: from cn_calc_formulas

155: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE) IS
156:
157: cursor c is
158: select object_version_number
159: from cn_calc_formulas
160: where calc_formula_id = x_calc_formula_id
161: for update of calc_formula_id nowait;
162: tlinfo c%rowtype ;
163: BEGIN

Line 183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

179:
180: END LOCK_ROW;
181:
182: procedure UPDATE_ROW (
183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,

Line 184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,

180: END LOCK_ROW;
181:
182: procedure UPDATE_ROW (
183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,

Line 185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,

181:
182: procedure UPDATE_ROW (
183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,

Line 186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',

182: procedure UPDATE_ROW (
183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,

Line 187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,

183: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,

Line 188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,

184: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,

Line 189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,

185: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,

Line 190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,

186: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,

Line 191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,

187: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,

Line 192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,

188: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,

Line 193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,

189: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,

Line 194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,

190: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

Line 195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,

191: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

Line 196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,

192: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

Line 197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,

193: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

Line 198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

194: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

Line 199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

195: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

Line 200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

196: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

Line 201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

197: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

Line 202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

198: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

Line 203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

199: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

Line 204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

200: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

Line 205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

201: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

Line 206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

202: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

Line 207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

203: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

Line 208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

204: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

Line 209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

205: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

Line 210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

206: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,

Line 211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

207: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

208: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

209: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

Line 214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,

210: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
218: BEGIN

Line 215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,

211: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
218: BEGIN
219:

Line 216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

212: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

213: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
214: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
215: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
216: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
217: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:

Line 222: update CN_CALC_FORMULAS set

218: BEGIN
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_FORMULAS 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: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),

Line 265: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,

261: end if;
262: end UPDATE_ROW;
263:
264: procedure DELETE_ROW (
265: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
266: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE) IS
267: begin
268: delete from CN_CALC_FORMULAS
269: where CALC_FORMULA_ID = X_CALC_FORMULA_ID

Line 266: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE) IS

262: end UPDATE_ROW;
263:
264: procedure DELETE_ROW (
265: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
266: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE) IS
267: begin
268: delete from CN_CALC_FORMULAS
269: where CALC_FORMULA_ID = X_CALC_FORMULA_ID
270: and ORG_ID = X_ORG_ID;

Line 268: delete from CN_CALC_FORMULAS

264: procedure DELETE_ROW (
265: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
266: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE) IS
267: begin
268: delete from CN_CALC_FORMULAS
269: where CALC_FORMULA_ID = X_CALC_FORMULA_ID
270: and ORG_ID = X_ORG_ID;
271:
272: if (sql%notfound) then

Line 280: end CN_CALC_FORMULAS_PKG;

276: end if;
277:
278: end DELETE_ROW;
279:
280: end CN_CALC_FORMULAS_PKG;