1: PACKAGE CN_MULTI_RATE_SCHEDULES_PKG AUTHID CURRENT_USER AS
2: /* $Header: cntrschs.pls 120.2 2005/10/05 23:27:26 kjayapau 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
2: /* $Header: cntrschs.pls 120.2 2005/10/05 23:27:26 kjayapau 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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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);
33:
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);
33:
34: procedure LOCK_ROW (
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);
33:
34: procedure LOCK_ROW (
35: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
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);
33:
34: procedure LOCK_ROW (
35: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
36: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
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);
33:
34: procedure LOCK_ROW (
35: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
36: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
37:
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
32: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
33:
34: procedure LOCK_ROW (
35: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
36: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
37:
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
35: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
36: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
37:
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
36: X_OBJECT_VERSION_NUMBER IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE);
37:
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
37:
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
38: procedure UPDATE_ROW (
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
39: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
40: X_NAME IN CN_RATE_SCHEDULES.NAME%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
41: X_COMMISSION_UNIT_CODE IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
42: X_NUMBER_DIM IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
43: X_ATTRIBUTE_CATEGORY IN CN_RATE_SCHEDULES.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
44: X_ATTRIBUTE1 IN CN_RATE_SCHEDULES.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
45: X_ATTRIBUTE2 IN CN_RATE_SCHEDULES.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
46: X_ATTRIBUTE3 IN CN_RATE_SCHEDULES.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
47: X_ATTRIBUTE4 IN CN_RATE_SCHEDULES.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
48: X_ATTRIBUTE5 IN CN_RATE_SCHEDULES.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
49: X_ATTRIBUTE6 IN CN_RATE_SCHEDULES.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
50: X_ATTRIBUTE7 IN CN_RATE_SCHEDULES.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
51: X_ATTRIBUTE8 IN CN_RATE_SCHEDULES.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
52: X_ATTRIBUTE9 IN CN_RATE_SCHEDULES.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
53: X_ATTRIBUTE10 IN CN_RATE_SCHEDULES.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
54: X_ATTRIBUTE11 IN CN_RATE_SCHEDULES.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
55: X_ATTRIBUTE12 IN CN_RATE_SCHEDULES.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63:
56: X_ATTRIBUTE13 IN CN_RATE_SCHEDULES.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63:
64: procedure DELETE_ROW (
57: X_ATTRIBUTE14 IN CN_RATE_SCHEDULES.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63:
64: procedure DELETE_ROW (
65: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE);
58: X_ATTRIBUTE15 IN CN_RATE_SCHEDULES.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
59: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
60: X_LAST_UPDATE_DATE IN CN_RATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := SYSDATE,
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63:
64: procedure DELETE_ROW (
65: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE);
66:
61: X_LAST_UPDATED_BY IN CN_RATE_SCHEDULES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62: X_LAST_UPDATE_LOGIN IN CN_RATE_SCHEDULES.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63:
64: procedure DELETE_ROW (
65: X_RATE_SCHEDULE_ID IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE);
66:
67: end CN_MULTI_RATE_SCHEDULES_PKG;