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_MULTI_RATE_SCHEDULES_PKG dependencies on CN_RATE_SCHEDULES

Line 5: X_RATE_SCHEDULE_ID IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

1: PACKAGE BODY CN_MULTI_RATE_SCHEDULES_PKG AS
2: /* $Header: cntrschb.pls 120.2.12010000.2 2010/02/04 21:29:40 rnagired ship $ */
3:
4: PROCEDURE INSERT_ROW (
5: X_RATE_SCHEDULE_ID IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,
7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
9: --R12 MOAC Changes--Start

Line 6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,

2: /* $Header: cntrschb.pls 120.2.12010000.2 2010/02/04 21:29:40 rnagired ship $ */
3:
4: PROCEDURE INSERT_ROW (
5: X_RATE_SCHEDULE_ID IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,
7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

Line 7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

3:
4: PROCEDURE INSERT_ROW (
5: X_RATE_SCHEDULE_ID IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,
7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End

Line 8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

4: PROCEDURE INSERT_ROW (
5: X_RATE_SCHEDULE_ID IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,
7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := NULL,

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

6: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE,
7: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
8: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
9: --R12 MOAC Changes--Start
10: X_ORG_ID IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
11: --R12 MOAC Changes--End
12: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := NULL,
13: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := NULL,
14: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := NULL,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 33: cursor C is select rate_schedule_id from CN_RATE_SCHEDULES

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

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

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

Line 48: insert into CN_RATE_SCHEDULES (

44: END IF;
45: CLOSE id;
46: END IF;
47:
48: insert into CN_RATE_SCHEDULES (
49: RATE_SCHEDULE_ID,
50: NAME,
51: COMMISSION_UNIT_CODE,
52: NUMBER_DIM,

Line 112: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

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

Line 113: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE) is

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

Line 117: from CN_RATE_SCHEDULES

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

Line 141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,

137:
138: END LOCK_ROW;
139:
140: procedure UPDATE_ROW (
141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

Line 142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,

138: END LOCK_ROW;
139:
140: procedure UPDATE_ROW (
141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

Line 143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,

139:
140: procedure UPDATE_ROW (
141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

Line 144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,

140: procedure UPDATE_ROW (
141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

Line 145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,

141: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
149: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

Line 146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,

142: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
149: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
150: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

Line 147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,

143: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
149: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
150: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
151: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

Line 148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,

144: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
145: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
146: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
147: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
148: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
149: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
150: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
151: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
152: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

Line 149: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,

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

Line 150: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,

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

Line 151: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,

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

Line 152: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,

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

Line 153: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,

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

Line 154: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,

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

Line 155: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,

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

Line 156: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,

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

Line 157: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,

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

Line 158: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,

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

Line 159: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,

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

Line 160: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,

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

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

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

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

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

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

159: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
160: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
161: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
162: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
163: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
165:
166: BEGIN
167:

Line 164: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS

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

Line 170: update CN_RATE_SCHEDULES set

166: BEGIN
167:
168: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
169:
170: update CN_RATE_SCHEDULES set
171: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
172: COMMISSION_UNIT_CODE = Decode(X_COMMISSION_UNIT_CODE, fnd_api.g_miss_char, commission_unit_code, x_commission_unit_code),
173: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_num, number_dim, x_number_dim),
174: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),

Line 204: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE) IS

200: end if;
201: end UPDATE_ROW;
202:
203: procedure DELETE_ROW (
204: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE) IS
205: begin
206:
207: -- delete dimension assignments
208: DELETE FROM cn_rate_sch_dims WHERE rate_schedule_id = x_rate_schedule_id;

Line 213: delete from CN_RATE_SCHEDULES

209:
210: -- delete records in cn_rate_tiers
211: DELETE FROM cn_rate_tiers WHERE rate_schedule_id = x_rate_schedule_id;
212:
213: delete from CN_RATE_SCHEDULES
214: where RATE_SCHEDULE_ID = X_RATE_SCHEDULE_ID;
215:
216: if (sql%notfound) then
217: fnd_message.set_name('CN', 'CN_RECORD_DELETED');