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_DIMENSIONS_PKG dependencies on CN_RATE_DIMENSIONS

Line 1: PACKAGE BODY CN_RATE_DIMENSIONS_PKG AS

1: PACKAGE BODY CN_RATE_DIMENSIONS_PKG AS
2: /* $Header: cntrdimb.pls 120.3 2005/10/19 00:53:21 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

Line 5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

1: PACKAGE BODY CN_RATE_DIMENSIONS_PKG AS
2: /* $Header: cntrdimb.pls 120.3 2005/10/19 00:53:21 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,
7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

Line 6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,

2: /* $Header: cntrdimb.pls 120.3 2005/10/19 00:53:21 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,
7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
10: -- R12 MOAC Changes--Start

Line 7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

3:
4: procedure INSERT_ROW (
5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,
7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
10: -- R12 MOAC Changes--Start
11: X_ORG_ID IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

Line 8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

4: procedure INSERT_ROW (
5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,
7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
10: -- R12 MOAC Changes--Start
11: X_ORG_ID IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
12: -- R12 MOAC Changes--End

Line 9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

5: X_RATE_DIMENSION_ID IN OUT NOCOPY CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
6: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE,
7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
10: -- R12 MOAC Changes--Start
11: X_ORG_ID IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
12: -- R12 MOAC Changes--End
13: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 11: X_ORG_ID IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new

7: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
8: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
9: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,
10: -- R12 MOAC Changes--Start
11: X_ORG_ID IN CN_RATE_DIMENSIONS.ORG_ID%TYPE, --new
12: -- R12 MOAC Changes--End
13: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := NULL,
14: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := NULL,
15: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := NULL,

Line 13: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := NULL,

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

Line 14: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := NULL,

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

Line 15: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := NULL,

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

Line 16: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := NULL,

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

Line 17: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := NULL,

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

Line 18: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := NULL,

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

Line 19: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := NULL,

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

Line 20: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := NULL,

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

Line 21: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := NULL,

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

Line 22: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := NULL,

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

Line 23: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := NULL,

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

Line 24: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := NULL,

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

Line 25: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := NULL,

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

Line 26: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := NULL,

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

Line 27: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := NULL,

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

Line 28: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := NULL,

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

Line 29: X_CREATION_DATE IN CN_RATE_DIMENSIONS.CREATION_DATE%TYPE := SYSDATE,

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

Line 30: X_CREATED_BY IN CN_RATE_DIMENSIONS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

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

Line 31: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,

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

Line 32: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

28: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := NULL,
29: X_CREATION_DATE IN CN_RATE_DIMENSIONS.CREATION_DATE%TYPE := SYSDATE,
30: X_CREATED_BY IN CN_RATE_DIMENSIONS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
31: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
32: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
34:
35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS
36: where RATE_DIMENSION_ID = x_rate_dimension_id;

Line 33: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

29: X_CREATION_DATE IN CN_RATE_DIMENSIONS.CREATION_DATE%TYPE := SYSDATE,
30: X_CREATED_BY IN CN_RATE_DIMENSIONS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
31: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
32: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
34:
35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS
36: where RATE_DIMENSION_ID = x_rate_dimension_id;
37:

Line 35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS

31: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
32: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
34:
35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS
36: where RATE_DIMENSION_ID = x_rate_dimension_id;
37:
38: CURSOR id IS SELECT cn_rate_dimensions_s.NEXTVAL FROM dual;
39: BEGIN

Line 38: CURSOR id IS SELECT cn_rate_dimensions_s.NEXTVAL FROM dual;

34:
35: cursor C is select rate_dimension_id from CN_RATE_DIMENSIONS
36: where RATE_DIMENSION_ID = x_rate_dimension_id;
37:
38: CURSOR id IS SELECT cn_rate_dimensions_s.NEXTVAL FROM dual;
39: BEGIN
40: IF (x_rate_dimension_id IS NULL) THEN
41: OPEN id;
42: FETCH id INTO x_rate_dimension_id;

Line 50: insert into CN_RATE_DIMENSIONS (

46: END IF;
47: CLOSE id;
48: END IF;
49:
50: insert into CN_RATE_DIMENSIONS (
51: RATE_DIMENSION_ID,
52: NAME,
53: DESCRIPTION,
54: DIM_UNIT_CODE,

Line 124: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

120:
121: end INSERT_ROW;
122:
123: procedure LOCK_ROW (
124: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
125: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
126:
127: cursor c is
128: select object_version_number

Line 125: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS

121: end INSERT_ROW;
122:
123: procedure LOCK_ROW (
124: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
125: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
126:
127: cursor c is
128: select object_version_number
129: from CN_RATE_DIMENSIONS

Line 129: from CN_RATE_DIMENSIONS

125: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
126:
127: cursor c is
128: select object_version_number
129: from CN_RATE_DIMENSIONS
130: where RATE_DIMENSION_ID = X_RATE_DIMENSION_ID
131: for update of RATE_DIMENSION_ID nowait;
132:
133: tlinfo c%rowtype ;

Line 154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,

150:
151: END LOCK_ROW;
152:
153: procedure UPDATE_ROW (
154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,

Line 155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,

151: END LOCK_ROW;
152:
153: procedure UPDATE_ROW (
154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

Line 156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,

152:
153: procedure UPDATE_ROW (
154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

Line 157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,

153: procedure UPDATE_ROW (
154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

Line 158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,

154: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

Line 159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

155: X_NAME IN CN_RATE_DIMENSIONS.NAME%TYPE := CN_API.G_MISS_CHAR,
156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

Line 160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

156: X_DESCRIPTION IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

Line 161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

157: X_DIM_UNIT_CODE IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

Line 162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

158: X_NUMBER_TIER IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE := CN_API.G_MISS_NUM,
159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

Line 163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

159: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIMENSIONS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

Line 164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

160: X_ATTRIBUTE1 IN CN_RATE_DIMENSIONS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

Line 165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

161: X_ATTRIBUTE2 IN CN_RATE_DIMENSIONS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

Line 166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

162: X_ATTRIBUTE3 IN CN_RATE_DIMENSIONS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

Line 167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

163: X_ATTRIBUTE4 IN CN_RATE_DIMENSIONS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

Line 168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

164: X_ATTRIBUTE5 IN CN_RATE_DIMENSIONS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

Line 169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

165: X_ATTRIBUTE6 IN CN_RATE_DIMENSIONS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

Line 170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

166: X_ATTRIBUTE7 IN CN_RATE_DIMENSIONS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

Line 171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

167: X_ATTRIBUTE8 IN CN_RATE_DIMENSIONS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

168: X_ATTRIBUTE9 IN CN_RATE_DIMENSIONS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

169: X_ATTRIBUTE10 IN CN_RATE_DIMENSIONS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

Line 174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

170: X_ATTRIBUTE11 IN CN_RATE_DIMENSIONS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS

Line 175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,

171: X_ATTRIBUTE12 IN CN_RATE_DIMENSIONS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
179:

Line 176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

172: X_ATTRIBUTE13 IN CN_RATE_DIMENSIONS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
179:
180: BEGIN

Line 177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

173: X_ATTRIBUTE14 IN CN_RATE_DIMENSIONS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
179:
180: BEGIN
181:

Line 178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS

174: X_ATTRIBUTE15 IN CN_RATE_DIMENSIONS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
175: X_LAST_UPDATE_DATE IN CN_RATE_DIMENSIONS.LAST_UPDATE_DATE%TYPE := SYSDATE,
176: X_LAST_UPDATED_BY IN CN_RATE_DIMENSIONS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
177: X_LAST_UPDATE_LOGIN IN CN_RATE_DIMENSIONS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
178: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE) IS
179:
180: BEGIN
181:
182: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 184: update CN_RATE_DIMENSIONS set

180: BEGIN
181:
182: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
183:
184: update CN_RATE_DIMENSIONS set
185: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
186: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
187: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
188: NUMBER_TIER = Decode(X_NUMBER_TIER, fnd_api.g_miss_num, number_tier, x_number_tier),

Line 217: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE) is

213: end if;
214: end UPDATE_ROW;
215:
216: procedure DELETE_ROW (
217: X_RATE_DIMENSION_ID IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE) is
218: begin
219: -- delete dimension_tiers first
220: delete from cn_rate_dim_tiers
221: where rate_dimension_id = x_rate_dimension_id;

Line 223: delete from cn_rate_dimensions

219: -- delete dimension_tiers first
220: delete from cn_rate_dim_tiers
221: where rate_dimension_id = x_rate_dimension_id;
222:
223: delete from cn_rate_dimensions
224: where rate_dimension_id = x_rate_dimension_id;
225:
226: if (sql%notfound) then
227: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 234: end CN_RATE_DIMENSIONS_PKG;

230: end if;
231:
232: end DELETE_ROW;
233:
234: end CN_RATE_DIMENSIONS_PKG;