[Home] [Help]
PACKAGE: APPS.CN_RT_FORMULA_ASGNS_PKG
Source
1 package CN_RT_FORMULA_ASGNS_PKG as
2 /* $Header: cntrtass.pls 120.1 2005/06/22 16:32:26 appldev ship $ */
3
4 procedure INSERT_ROW
5 (X_RT_FORMULA_ASGN_ID IN OUT NOCOPY CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE,
6 X_CALC_FORMULA_ID IN CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
7 X_RATE_SCHEDULE_ID IN CN_RT_FORMULA_ASGNS.RATE_SCHEDULE_ID%TYPE,
8 X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE,
9 X_END_DATE IN CN_RT_FORMULA_ASGNS.END_DATE%TYPE := NULL,
10 --R12 MOAC Changes--Start
11 X_ORG_ID IN CN_RT_FORMULA_ASGNS.ORG_ID%TYPE,
12 --R12 MOAC Changes--End
13 X_ATTRIBUTE_CATEGORY IN CN_RT_FORMULA_ASGNS.ATTRIBUTE_CATEGORY%TYPE := NULL,
14 X_ATTRIBUTE1 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE1%TYPE := NULL,
15 X_ATTRIBUTE2 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE2%TYPE := NULL,
16 X_ATTRIBUTE3 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE3%TYPE := NULL,
17 X_ATTRIBUTE4 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE4%TYPE := NULL,
18 X_ATTRIBUTE5 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE5%TYPE := NULL,
19 X_ATTRIBUTE6 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE6%TYPE := NULL,
20 X_ATTRIBUTE7 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE7%TYPE := NULL,
21 X_ATTRIBUTE8 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE8%TYPE := NULL,
22 X_ATTRIBUTE9 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE9%TYPE := NULL,
23 X_ATTRIBUTE10 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE10%TYPE := NULL,
24 X_ATTRIBUTE11 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE11%TYPE := NULL,
25 X_ATTRIBUTE12 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE12%TYPE := NULL,
26 X_ATTRIBUTE13 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE13%TYPE := NULL,
27 X_ATTRIBUTE14 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE14%TYPE := NULL,
28 X_ATTRIBUTE15 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE15%TYPE := NULL,
29 X_CREATION_DATE IN CN_RT_FORMULA_ASGNS.CREATION_DATE%TYPE := SYSDATE,
30 X_CREATED_BY IN CN_RT_FORMULA_ASGNS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
31 X_LAST_UPDATE_DATE IN CN_RT_FORMULA_ASGNS.LAST_UPDATE_DATE%TYPE := SYSDATE,
32 X_LAST_UPDATED_BY IN CN_RT_FORMULA_ASGNS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
33 X_LAST_UPDATE_LOGIN IN CN_RT_FORMULA_ASGNS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
34
35 procedure LOCK_ROW
36 (X_RT_FORMULA_ASGN_ID IN CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE,
37 X_OBJECT_VERSION_NUMBER IN CN_RT_FORMULA_ASGNS.OBJECT_VERSION_NUMBER%TYPE);
38
39 procedure UPDATE_ROW
40 (X_RT_FORMULA_ASGN_ID IN CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE,
41 X_CALC_FORMULA_ID IN CN_RT_FORMULA_ASGNS.CALC_FORMULA_ID%TYPE,
42 X_RATE_SCHEDULE_ID IN CN_RT_FORMULA_ASGNS.RATE_SCHEDULE_ID%TYPE := CN_API.G_MISS_NUM,
43 X_START_DATE IN CN_RT_FORMULA_ASGNS.START_DATE%TYPE := CN_API.G_MISS_DATE,
44 X_END_DATE IN CN_RT_FORMULA_ASGNS.END_DATE%TYPE := CN_API.G_MISS_DATE,
45 X_ATTRIBUTE_CATEGORY IN CN_RT_FORMULA_ASGNS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
46 X_ATTRIBUTE1 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
47 X_ATTRIBUTE2 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
48 X_ATTRIBUTE3 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
49 X_ATTRIBUTE4 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
50 X_ATTRIBUTE5 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
51 X_ATTRIBUTE6 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
52 X_ATTRIBUTE7 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
53 X_ATTRIBUTE8 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
54 X_ATTRIBUTE9 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
55 X_ATTRIBUTE10 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
56 X_ATTRIBUTE11 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
57 X_ATTRIBUTE12 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
58 X_ATTRIBUTE13 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
59 X_ATTRIBUTE14 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
60 X_ATTRIBUTE15 IN CN_RT_FORMULA_ASGNS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
61 X_OBJECT_VERSION_NUMBER IN CN_RT_FORMULA_ASGNS.OBJECT_VERSION_NUMBER%TYPE,
62 X_LAST_UPDATE_DATE IN CN_RT_FORMULA_ASGNS.LAST_UPDATE_DATE%TYPE := SYSDATE,
63 X_LAST_UPDATED_BY IN CN_RT_FORMULA_ASGNS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
64 X_LAST_UPDATE_LOGIN IN CN_RT_FORMULA_ASGNS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
65
66 procedure DELETE_ROW
67 (X_RT_FORMULA_ASGN_ID IN CN_RT_FORMULA_ASGNS.RT_FORMULA_ASGN_ID%TYPE);
68
69 end CN_RT_FORMULA_ASGNS_PKG;