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.
PACKAGE: APPS.CN_MULTI_RATE_SCHEDULES_PKG

Source


1 PACKAGE CN_MULTI_RATE_SCHEDULES_PKG 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
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,
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,
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);
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,
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,
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 
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;