[Home] [Help]
PACKAGE: APPS.CN_RATE_SCH_DIMS_PKG
Source
1 PACKAGE CN_RATE_SCH_DIMS_PKG AS
2 /* $Header: cntschds.pls 120.2 2005/10/05 23:27:55 kjayapau ship $ */
3
4 procedure INSERT_ROW (
5 X_RATE_SCH_DIM_ID IN OUT NOCOPY CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
6 X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
7 X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
8 X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
9 --R12 MOAC Changes--Start
10 X_ORG_ID IN CN_RATE_SCH_DIMS.ORG_ID%TYPE, --new
11 --R12 MOAC Changes--End
12 X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := NULL,
13 X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := NULL,
14 X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := NULL,
15 X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := NULL,
16 X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := NULL,
17 X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := NULL,
18 X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := NULL,
19 X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := NULL,
20 X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := NULL,
21 X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := NULL,
22 X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := NULL,
23 X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := NULL,
24 X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := NULL,
25 X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := NULL,
26 X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := NULL,
27 X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := NULL,
28 X_CREATION_DATE IN CN_RATE_SCH_DIMS.CREATION_DATE%TYPE := SYSDATE,
29 X_CREATED_BY IN CN_RATE_SCH_DIMS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
30 X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
31 X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
32 X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
33
34 procedure LOCK_ROW (
35 X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
36 X_OBJECT_VERSION_NUMBER IN CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE);
37
38 procedure UPDATE_ROW (
39 X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
40 X_RATE_DIMENSION_ID IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
41 X_RATE_SCHEDULE_ID IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE := cn_api.g_miss_num,
42 X_RATE_DIM_SEQUENCE IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,
43 X_ATTRIBUTE_CATEGORY IN CN_RATE_SCH_DIMS.ATTRIBUTE_CATEGORY%TYPE := cn_api.g_miss_char,
44 X_ATTRIBUTE1 IN CN_RATE_SCH_DIMS.ATTRIBUTE1%TYPE := cn_api.g_miss_char,
45 X_ATTRIBUTE2 IN CN_RATE_SCH_DIMS.ATTRIBUTE2%TYPE := cn_api.g_miss_char,
46 X_ATTRIBUTE3 IN CN_RATE_SCH_DIMS.ATTRIBUTE3%TYPE := cn_api.g_miss_char,
47 X_ATTRIBUTE4 IN CN_RATE_SCH_DIMS.ATTRIBUTE4%TYPE := cn_api.g_miss_char,
48 X_ATTRIBUTE5 IN CN_RATE_SCH_DIMS.ATTRIBUTE5%TYPE := cn_api.g_miss_char,
49 X_ATTRIBUTE6 IN CN_RATE_SCH_DIMS.ATTRIBUTE6%TYPE := cn_api.g_miss_char,
50 X_ATTRIBUTE7 IN CN_RATE_SCH_DIMS.ATTRIBUTE7%TYPE := cn_api.g_miss_char,
51 X_ATTRIBUTE8 IN CN_RATE_SCH_DIMS.ATTRIBUTE8%TYPE := cn_api.g_miss_char,
52 X_ATTRIBUTE9 IN CN_RATE_SCH_DIMS.ATTRIBUTE9%TYPE := cn_api.g_miss_char,
53 X_ATTRIBUTE10 IN CN_RATE_SCH_DIMS.ATTRIBUTE10%TYPE := cn_api.g_miss_char,
54 X_ATTRIBUTE11 IN CN_RATE_SCH_DIMS.ATTRIBUTE11%TYPE := cn_api.g_miss_char,
55 X_ATTRIBUTE12 IN CN_RATE_SCH_DIMS.ATTRIBUTE12%TYPE := cn_api.g_miss_char,
56 X_ATTRIBUTE13 IN CN_RATE_SCH_DIMS.ATTRIBUTE13%TYPE := cn_api.g_miss_char,
57 X_ATTRIBUTE14 IN CN_RATE_SCH_DIMS.ATTRIBUTE14%TYPE := cn_api.g_miss_char,
58 X_ATTRIBUTE15 IN CN_RATE_SCH_DIMS.ATTRIBUTE15%TYPE := cn_api.g_miss_char,
59 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
60 X_LAST_UPDATE_DATE IN CN_RATE_SCH_DIMS.LAST_UPDATE_DATE%TYPE := SYSDATE,
61 X_LAST_UPDATED_BY IN CN_RATE_SCH_DIMS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
62 X_LAST_UPDATE_LOGIN IN CN_RATE_SCH_DIMS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID);
63
64 procedure DELETE_ROW (
65 X_RATE_SCH_DIM_ID IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE);
66 end CN_RATE_SCH_DIMS_PKG;