1: package CN_FORMULA_INPUTS_PKG as
2: /* $Header: cntfinps.pls 120.1 2005/06/22 16:38:31 appldev ship $ */
3:
4: procedure INSERT_ROW
5: (X_FORMULA_INPUT_ID IN OUT NOCOPY CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
1: package CN_FORMULA_INPUTS_PKG as
2: /* $Header: cntfinps.pls 120.1 2005/06/22 16:38:31 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,
2: /* $Header: cntfinps.pls 120.1 2005/06/22 16:38:31 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,
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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);
36:
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);
36:
37: procedure LOCK_ROW
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);
36:
37: procedure LOCK_ROW
38: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
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);
36:
37: procedure LOCK_ROW
38: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
39: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE);
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);
36:
37: procedure LOCK_ROW
38: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
39: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE);
40:
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
36:
37: procedure LOCK_ROW
38: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
39: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE);
40:
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
38: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
39: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE);
40:
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
39: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE);
40:
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
40:
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
41: procedure UPDATE_ROW
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
42: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
43: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
44: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
45: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
46: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
47: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
48: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
58: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
59: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
60: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
61: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
69:
62: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
69:
70: procedure DELETE_ROW
63: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
69:
70: procedure DELETE_ROW
71: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE);
64: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
65: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
66: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
69:
70: procedure DELETE_ROW
71: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE);
72:
67: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
68: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
69:
70: procedure DELETE_ROW
71: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE);
72:
73: end CN_FORMULA_INPUTS_PKG;
69:
70: procedure DELETE_ROW
71: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE);
72:
73: end CN_FORMULA_INPUTS_PKG;