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_RATE_SCH_DIMS_PKG dependencies on CN_RATE_SCH_DIMS

Line 1: PACKAGE BODY CN_RATE_SCH_DIMS_PKG AS

1: PACKAGE BODY CN_RATE_SCH_DIMS_PKG AS
2: /* $Header: cntschdb.pls 120.2 2005/10/05 22:25:08 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

Line 5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

1: PACKAGE BODY CN_RATE_SCH_DIMS_PKG AS
2: /* $Header: cntschdb.pls 120.2 2005/10/05 22:25:08 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start

Line 6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,

2: /* $Header: cntschdb.pls 120.2 2005/10/05 22:25:08 kjayapau ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new

Line 7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

3:
4: procedure INSERT_ROW (
5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End

Line 8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

4: procedure INSERT_ROW (
5: X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new

6: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,
13: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,
14: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,

Line 12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,

8: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,
13: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,
14: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,
15: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := NULL,
16: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := NULL,

Line 13: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,

9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,
13: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,
14: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,
15: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := NULL,
16: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := NULL,
17: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := NULL,

Line 14: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,

10: X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,
13: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,
14: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,
15: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := NULL,
16: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := NULL,
17: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := NULL,
18: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := NULL,

Line 15: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := NULL,

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

Line 16: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := NULL,

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

Line 17: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := NULL,

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

Line 18: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := NULL,

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

Line 19: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := NULL,

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

Line 20: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := NULL,

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

Line 21: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := NULL,

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

Line 22: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := NULL,

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

Line 23: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := NULL,

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

Line 24: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := NULL,

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

Line 25: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := NULL,

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

Line 26: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := NULL,

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

Line 27: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,

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

Line 28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,

24: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := NULL,
25: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := NULL,
26: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := NULL,
27: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,
28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is

Line 29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

25: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := NULL,
26: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := NULL,
27: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,
28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS

Line 30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,

26: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := NULL,
27: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,
28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS
34: where RATE_SCH_DIM_ID = x_rate_sch_dim_id;

Line 31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

27: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,
28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS
34: where RATE_SCH_DIM_ID = x_rate_sch_dim_id;
35:

Line 32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is

28: X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS
34: where RATE_SCH_DIM_ID = x_rate_sch_dim_id;
35:
36: CURSOR id IS SELECT cn_rate_sch_dims_s.NEXTVAL FROM dual;

Line 33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS

29: X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS
34: where RATE_SCH_DIM_ID = x_rate_sch_dim_id;
35:
36: CURSOR id IS SELECT cn_rate_sch_dims_s.NEXTVAL FROM dual;
37: BEGIN

Line 36: CURSOR id IS SELECT cn_rate_sch_dims_s.NEXTVAL FROM dual;

32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
33: cursor C is select rate_sch_dim_id from CN_RATE_SCH_DIMS
34: where RATE_SCH_DIM_ID = x_rate_sch_dim_id;
35:
36: CURSOR id IS SELECT cn_rate_sch_dims_s.NEXTVAL FROM dual;
37: BEGIN
38: IF (x_rate_sch_dim_id IS NULL) THEN
39: OPEN id;
40: FETCH id INTO x_rate_sch_dim_id;

Line 48: insert into CN_RATE_SCH_DIMS (

44: END IF;
45: CLOSE id;
46: END IF;
47:
48: insert into CN_RATE_SCH_DIMS (
49: RATE_SCH_DIM_ID,
50: RATE_DIMENSION_ID,
51: RATE_SCHEDULE_ID,
52: RATE_DIM_SEQUENCE,

Line 112: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

108:
109: end INSERT_ROW;
110:
111: procedure LOCK_ROW (
112: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
113: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE) IS
114:
115: cursor c is
116: select object_version_number

Line 113: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE) IS

109: end INSERT_ROW;
110:
111: procedure LOCK_ROW (
112: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
113: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE) IS
114:
115: cursor c is
116: select object_version_number
117: from CN_RATE_SCH_DIMS

Line 117: from CN_RATE_SCH_DIMS

113: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE) IS
114:
115: cursor c is
116: select object_version_number
117: from CN_RATE_SCH_DIMS
118: where RATE_SCH_DIM_ID = X_RATE_SCH_DIM_ID;
119:
120: tlinfo c%rowtype ;
121: BEGIN

Line 141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,

137:
138: END LOCK_ROW;
139:
140: procedure UPDATE_ROW (
141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,

Line 142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,

138: END LOCK_ROW;
139:
140: procedure UPDATE_ROW (
141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,

Line 143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,

139:
140: procedure UPDATE_ROW (
141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,

Line 144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,

140: procedure UPDATE_ROW (
141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,

Line 145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,

141: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,

Line 146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,

142: X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,

Line 147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,

143: X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,

Line 148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,

144: X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,

Line 149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,

145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,

Line 150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,

146: X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,

Line 151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,

147: X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,

Line 152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,

148: X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,

Line 153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,

149: X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,

Line 154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,

150: X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,

Line 155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,

151: X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,

Line 156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,

152: X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,

Line 157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,

153: X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

Line 158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,

154: X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,

155: X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,

156: X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is

Line 161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,

157: X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
165: BEGIN

Line 162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,

158: X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
165: BEGIN
166:

Line 163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

159: X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
165: BEGIN
166:
167: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is

160: X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) is
165: BEGIN
166:
167: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
168:

Line 169: update CN_RATE_SCH_DIMS set

165: BEGIN
166:
167: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
168:
169: update CN_RATE_SCH_DIMS set
170: RATE_DIMENSION_ID = Decode(X_RATE_DIMENSION_ID, fnd_api.g_miss_num, rate_dimension_id, x_rate_dimension_id),
171: -- RATE_SCHEDULE_ID = Decode(X_RATE_SCHEDULE_ID, fnd_api.g_miss_num, rate_schedule_id, x_rate_schedule_id),
172: RATE_DIM_SEQUENCE = Decode(X_RATE_DIM_SEQUENCE, fnd_api.g_miss_num, rate_dim_sequence, x_rate_dim_sequence),
173: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),

Line 201: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE) is

197: end if;
198: end UPDATE_ROW;
199:
200: procedure DELETE_ROW (
201: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE) is
202: begin
203: delete from CN_RATE_SCH_DIMS
204: where RATE_SCH_DIM_ID = X_RATE_SCH_DIM_ID;
205:

Line 203: delete from CN_RATE_SCH_DIMS

199:
200: procedure DELETE_ROW (
201: X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE) is
202: begin
203: delete from CN_RATE_SCH_DIMS
204: where RATE_SCH_DIM_ID = X_RATE_SCH_DIM_ID;
205:
206: if (sql%notfound) then
207: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 214: end CN_RATE_SCH_DIMS_PKG;

210: end if;
211:
212: end DELETE_ROW;
213:
214: end CN_RATE_SCH_DIMS_PKG;