eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_FORMULA_INPUTS_PKG dependencies on CN_FORMULA_INPUTS

Line 1: package body CN_FORMULA_INPUTS_PKG as

1: package body CN_FORMULA_INPUTS_PKG as
2: /* $Header: cntfinpb.pls 120.1 2005/06/22 16:38:51 appldev ship $ */
3:
4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,

Line 5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,

1: package body CN_FORMULA_INPUTS_PKG as
2: /* $Header: cntfinpb.pls 120.1 2005/06/22 16:38:51 appldev ship $ */
3:
4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,

Line 6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,

2: /* $Header: cntfinpb.pls 120.1 2005/06/22 16:38:51 appldev ship $ */
3:
4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,

Line 7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,

3:
4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

Line 8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,

4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start

Line 9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,

5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,

Line 10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,

6: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End

Line 11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

7: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
8: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := NULL,
9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,

9: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
10: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,

Line 15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,

11: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,

Line 16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,

12: --R12 MOAC Changes--Start
13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,

Line 17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,

13: X_ORG_ID IN CN_FORMULA_INPUTS.ORG_ID%TYPE,
14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,

Line 18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,

14: --R12 MOAC Changes--End
15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,

Line 19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,

15: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := NULL,
16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,

Line 20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,

16: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := NULL,
17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,

Line 21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,

17: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := NULL,
18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,

Line 22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,

18: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := NULL,
19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,

Line 23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,

19: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := NULL,
20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,

Line 24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,

20: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := NULL,
21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,

Line 25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,

21: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := NULL,
22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,

Line 26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,

22: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := NULL,
23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,

Line 27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,

23: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := NULL,
24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,

Line 28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,

24: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := NULL,
25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,

25: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := NULL,
26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,

26: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := NULL,
27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,

27: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := NULL,
28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

Line 32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:

Line 33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,

29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS

Line 34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;

Line 35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;
39:

Line 37: cursor C is select formula_input_id from CN_FORMULA_INPUTS

33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;
39:
40: CURSOR id IS SELECT cn_formula_inputs_s.NEXTVAL FROM dual;
41: BEGIN

Line 40: CURSOR id IS SELECT cn_formula_inputs_s.NEXTVAL FROM dual;

36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;
39:
40: CURSOR id IS SELECT cn_formula_inputs_s.NEXTVAL FROM dual;
41: BEGIN
42: IF (x_formula_input_id IS NULL) THEN
43: OPEN id;
44: FETCH id INTO x_formula_input_id;

Line 51: insert into CN_FORMULA_INPUTS

47: RAISE no_data_found;
48: END IF;
49: CLOSE id;
50: END IF;
51: insert into CN_FORMULA_INPUTS
52: (FORMULA_INPUT_ID,
53: CALC_FORMULA_ID,
54: CALC_SQL_EXP_ID,
55: F_CALC_SQL_EXP_ID,

Line 129: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,

125:
126: end INSERT_ROW;
127:
128: procedure LOCK_ROW
129: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
130: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE) IS
131:
132: cursor c is
133: select object_version_number

Line 130: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE) IS

126: end INSERT_ROW;
127:
128: procedure LOCK_ROW
129: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
130: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE) IS
131:
132: cursor c is
133: select object_version_number
134: from cn_formula_inputs

Line 134: from cn_formula_inputs

130: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE) IS
131:
132: cursor c is
133: select object_version_number
134: from cn_formula_inputs
135: where formula_input_id = x_formula_input_id
136: for update of formula_input_id nowait;
137: tlinfo c%rowtype ;
138: BEGIN

Line 157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,

153: end if;
154: end LOCK_ROW;
155:
156: procedure UPDATE_ROW
157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,

Line 158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,

154: end LOCK_ROW;
155:
156: procedure UPDATE_ROW
157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,

Line 159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,

155:
156: procedure UPDATE_ROW
157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

Line 160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,

156: procedure UPDATE_ROW
157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

Line 161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,

157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

Line 162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,

158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

Line 163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,

159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

Line 164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

Line 165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

Line 166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

Line 167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

Line 168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

Line 169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

Line 170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

Line 171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

Line 172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

Line 173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

Line 174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

Line 175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

Line 176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,

Line 177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

Line 180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,

176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:

Line 181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,

177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN

Line 182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set

Line 183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set
187: CALC_SQL_EXP_ID = Decode(X_CALC_SQL_EXP_ID, fnd_api.g_miss_num, calc_sql_exp_id, x_calc_sql_exp_id),

Line 186: update CN_FORMULA_INPUTS set

182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set
187: CALC_SQL_EXP_ID = Decode(X_CALC_SQL_EXP_ID, fnd_api.g_miss_num, calc_sql_exp_id, x_calc_sql_exp_id),
188: F_CALC_SQL_EXP_ID = Decode(X_F_CALC_SQL_EXP_ID, fnd_api.g_miss_num, f_calc_sql_exp_id, x_f_calc_sql_exp_id),
189: RATE_DIM_SEQUENCE = Decode(X_RATE_DIM_SEQUENCE, fnd_api.g_miss_num, rate_dim_sequence, x_rate_dim_sequence),
190: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, CUMULATIVE_FLAG, X_CUMULATIVE_FLAG),

Line 220: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE) IS

216: end if;
217: end UPDATE_ROW;
218:
219: procedure DELETE_ROW
220: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE) IS
221: begin
222: delete from CN_FORMULA_INPUTS
223: where FORMULA_INPUT_ID = X_FORMULA_INPUT_ID;
224:

Line 222: delete from CN_FORMULA_INPUTS

218:
219: procedure DELETE_ROW
220: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE) IS
221: begin
222: delete from CN_FORMULA_INPUTS
223: where FORMULA_INPUT_ID = X_FORMULA_INPUT_ID;
224:
225: if (sql%notfound) then
226: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 233: end CN_FORMULA_INPUTS_PKG;

229: end if;
230:
231: end DELETE_ROW;
232:
233: end CN_FORMULA_INPUTS_PKG;