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_DIM_TIERS_PKG dependencies on CN_RATE_DIM_TIERS

Line 1: PACKAGE BODY CN_RATE_DIM_TIERS_PKG AS

1: PACKAGE BODY CN_RATE_DIM_TIERS_PKG AS
2: /* $Header: cntrdtib.pls 120.3 2005/10/20 03:24:26 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

Line 5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

1: PACKAGE BODY CN_RATE_DIM_TIERS_PKG AS
2: /* $Header: cntrdtib.pls 120.3 2005/10/20 03:24:26 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,

Line 6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

2: /* $Header: cntrdtib.pls 120.3 2005/10/20 03:24:26 chanthon ship $ */
3:
4: procedure INSERT_ROW (
5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,

Line 7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,

3:
4: procedure INSERT_ROW (
5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,

Line 8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,

4: procedure INSERT_ROW (
5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,

Line 9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,

5: X_RATE_DIM_TIER_ID IN OUT NOCOPY CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

Line 10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,

6: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start

Line 11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,

7: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := NULL,
8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

Line 12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,

8: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := NULL,
9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
16: -- R12 MOAC Changes--End

Line 13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,

9: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := NULL,
10: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := NULL,
11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
16: -- R12 MOAC Changes--End
17: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := NULL,

Line 15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new

11: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := NULL,
12: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := NULL,
13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
16: -- R12 MOAC Changes--End
17: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := NULL,

Line 17: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := NULL,

13: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
14: -- R12 MOAC Changes--Start
15: X_ORG_ID IN CN_RATE_DIM_TIERS.ORG_ID%TYPE, --new
16: -- R12 MOAC Changes--End
17: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := NULL,
18: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := NULL,
19: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := NULL,
20: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := NULL,
21: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := NULL,

Line 18: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := NULL,

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

Line 19: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := NULL,

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

Line 20: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := NULL,

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

Line 21: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := NULL,

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

Line 22: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := NULL,

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

Line 23: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := NULL,

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

Line 24: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := NULL,

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

Line 25: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := NULL,

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

Line 26: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := NULL,

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

Line 27: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := NULL,

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

Line 28: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := NULL,

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

Line 29: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := NULL,

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

Line 30: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := NULL,

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

Line 31: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := NULL,

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

Line 32: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := NULL,

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

Line 33: X_CREATION_DATE IN CN_RATE_DIM_TIERS.CREATION_DATE%TYPE := SYSDATE,

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

Line 34: X_CREATED_BY IN CN_RATE_DIM_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

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

Line 35: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,

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

Line 36: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

32: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := NULL,
33: X_CREATION_DATE IN CN_RATE_DIM_TIERS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_RATE_DIM_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;

Line 37: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

33: X_CREATION_DATE IN CN_RATE_DIM_TIERS.CREATION_DATE%TYPE := SYSDATE,
34: X_CREATED_BY IN CN_RATE_DIM_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
41:

Line 39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS

35: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
36: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
37: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
41:
42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;
43: BEGIN

Line 42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;

38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
41:
42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;
43: BEGIN
44: IF (x_rate_dim_tier_id IS NULL) THEN
45: OPEN id;
46: FETCH id INTO x_rate_dim_tier_id;

Line 54: insert into CN_RATE_DIM_TIERS (

50: END IF;
51: CLOSE id;
52: END IF;
53:
54: insert into CN_RATE_DIM_TIERS (
55: RATE_DIM_TIER_ID,
56: RATE_DIMENSION_ID,
57: DIM_UNIT_CODE,
58: MINIMUM_AMOUNT,

Line 136: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

132:
133: end INSERT_ROW;
134:
135: procedure LOCK_ROW (
136: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
137: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
138:
139: cursor c is
140: select object_version_number

Line 137: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS

133: end INSERT_ROW;
134:
135: procedure LOCK_ROW (
136: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
137: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
138:
139: cursor c is
140: select object_version_number
141: from CN_RATE_DIM_TIERS

Line 141: from CN_RATE_DIM_TIERS

137: X_OBJECT_VERSION_NUMBER IN CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
138:
139: cursor c is
140: select object_version_number
141: from CN_RATE_DIM_TIERS
142: where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID
143: for update of RATE_DIM_TIER_ID nowait;
144:
145: tlinfo c%rowtype ;

Line 166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,

162:
163: END LOCK_ROW;
164:
165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,

Line 167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

163: END LOCK_ROW;
164:
165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,

Line 168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,

164:
165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,

Line 169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,

165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,

Line 170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,

166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

Line 171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,

167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

Line 172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,

168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

Line 173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,

169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

Line 174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

Line 175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

Line 176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

Line 177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

Line 178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

Line 179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

Line 180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

Line 181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

Line 182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

Line 183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

Line 184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

Line 185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

Line 186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

Line 187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

Line 190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS

Line 191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,

187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:

Line 192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:
196: BEGIN

Line 193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:
196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS

190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:
196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set

Line 198: update CN_RATE_DIM_TIERS set

194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS
195:
196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),

Line 236: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE) is

232: end if;
233: end UPDATE_ROW;
234:
235: procedure DELETE_ROW (
236: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE) is
237: begin
238: delete from CN_RATE_DIM_TIERS
239: where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID;
240:

Line 238: delete from CN_RATE_DIM_TIERS

234:
235: procedure DELETE_ROW (
236: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE) is
237: begin
238: delete from CN_RATE_DIM_TIERS
239: where RATE_DIM_TIER_ID = X_RATE_DIM_TIER_ID;
240:
241: if (sql%notfound) then
242: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line 249: end CN_RATE_DIM_TIERS_PKG;

245: end if;
246:
247: end DELETE_ROW;
248:
249: end CN_RATE_DIM_TIERS_PKG;