1: package CN_CALC_FORMULAS_PKG as
2: /* $Header: cntforms.pls 120.3 2006/05/26 00:48:47 jxsingh ship $ */
3:
4: procedure INSERT_ROW (
5: X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
1: package CN_CALC_FORMULAS_PKG as
2: /* $Header: cntforms.pls 120.3 2006/05/26 00:48:47 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: cntforms.pls 120.3 2006/05/26 00:48:47 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);
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);
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);
44:
45: procedure LOCK_ROW (
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);
44:
45: procedure LOCK_ROW (
46: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
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);
44:
45: procedure LOCK_ROW (
46: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
47: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
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);
44:
45: procedure LOCK_ROW (
46: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
47: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
48:
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
43: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
44:
45: procedure LOCK_ROW (
46: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
47: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
48:
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
46: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
47: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
48:
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
47: X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
48:
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
48:
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
49: procedure UPDATE_ROW (
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
50: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
51: X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
52: X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
53: X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
54: X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
55: X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
56: X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
57: X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
58: X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
59: X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
60: X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
61: X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
62: X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
63: X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
64: X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
65: X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
66: X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
67: X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
68: X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
69: X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
70: X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
71: X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
72: X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
73: X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
74: X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
75: X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
76: X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
77: X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
78: X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
86: procedure DELETE_ROW (
79: X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
86: procedure DELETE_ROW (
87: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
80: X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82: X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
86: procedure DELETE_ROW (
87: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
88: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE);
83: X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
86: procedure DELETE_ROW (
87: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
88: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE);
89: end CN_CALC_FORMULAS_PKG;
84: X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85:
86: procedure DELETE_ROW (
87: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
88: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE);
89: end CN_CALC_FORMULAS_PKG;
85:
86: procedure DELETE_ROW (
87: X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
88: X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE);
89: end CN_CALC_FORMULAS_PKG;