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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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
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;
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:
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
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;
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,
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
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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:
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;
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:
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),
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
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;
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
276: end if;
277:
278: end DELETE_ROW;
279:
280: end CN_CALC_FORMULAS_PKG;