[Home] [Help]
PACKAGE: APPS.CN_CALC_FORMULAS_PKG
Source
1 package CN_CALC_FORMULAS_PKG AUTHID CURRENT_USER as
2 /* $Header: cntforms.pls 120.3 2006/05/26 00:48:47 jxsingh ship $ */
3
4 procedure INSERT_ROW (
5 X_CALC_FORMULA_ID IN OUT NOCOPY CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
6 X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
7 X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := NULL,
8 X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
9 X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := NULL,
10 X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := NULL,
11 X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := NULL,
12 X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := NULL,
13 X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := NULL,
14 X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := NULL,
15 X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := NULL,
16 X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := NULL,
17 X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := NULL,
18 X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := NULL,
19 X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := NULL,
20 --R12 MOAC Changes--Start
21 X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE,
22 --R12 MOAC Changes--End
23 X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := NULL,
24 X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := NULL,
25 X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := NULL,
26 X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := NULL,
27 X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := NULL,
28 X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := NULL,
29 X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := NULL,
30 X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := NULL,
31 X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := NULL,
32 X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := NULL,
33 X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := NULL,
34 X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := NULL,
35 X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := NULL,
36 X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := NULL,
37 X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := NULL,
38 X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := NULL,
39 X_CREATION_DATE IN CN_CALC_FORMULAS.CREATION_DATE%TYPE := SYSDATE,
40 X_CREATED_BY IN CN_CALC_FORMULAS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
41 X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
42 X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
43 X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
44
45 procedure LOCK_ROW (
46 X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
47 X_OBJECT_VERSION_NUMBER IN CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE);
48
49 procedure UPDATE_ROW (
50 X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
51 X_NAME IN CN_CALC_FORMULAS.NAME%TYPE,
52 X_DESCRIPTION IN CN_CALC_FORMULAS.DESCRIPTION%TYPE := CN_API.G_MISS_CHAR,
53 X_FORMULA_STATUS IN CN_CALC_FORMULAS.FORMULA_STATUS%TYPE := 'INCOMPLETE',
54 X_FORMULA_TYPE IN CN_CALC_FORMULAS.FORMULA_TYPE%TYPE := CN_API.G_MISS_CHAR,
55 X_TRX_GROUP_CODE IN CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE := CN_API.G_MISS_CHAR,
56 X_NUMBER_DIM IN CN_CALC_FORMULAS.NUMBER_DIM%TYPE := CN_API.G_MISS_NUM,
57 X_CUMULATIVE_FLAG IN CN_CALC_FORMULAS.CUMULATIVE_FLAG%TYPE := CN_API.G_MISS_CHAR,
58 X_ITD_FLAG IN CN_CALC_FORMULAS.ITD_FLAG%TYPE := CN_API.G_MISS_CHAR,
59 X_SPLIT_FLAG IN CN_CALC_FORMULAS.SPLIT_FLAG%TYPE := CN_API.G_MISS_CHAR,
60 X_THRESHOLD_ALL_TIER_FLAG IN CN_CALC_FORMULAS.THRESHOLD_ALL_TIER_FLAG%TYPE := CN_API.G_MISS_CHAR,
61 X_MODELING_FLAG IN CN_CALC_FORMULAS.MODELING_FLAG%TYPE := CN_API.G_MISS_CHAR,
62 X_PERF_MEASURE_ID IN CN_CALC_FORMULAS.PERF_MEASURE_ID%TYPE := CN_API.G_MISS_NUM,
63 X_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
64 X_F_OUTPUT_EXP_ID IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE := CN_API.G_MISS_NUM,
65 X_ATTRIBUTE_CATEGORY IN CN_CALC_FORMULAS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
66 X_ATTRIBUTE1 IN CN_CALC_FORMULAS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
67 X_ATTRIBUTE2 IN CN_CALC_FORMULAS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
68 X_ATTRIBUTE3 IN CN_CALC_FORMULAS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
69 X_ATTRIBUTE4 IN CN_CALC_FORMULAS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
70 X_ATTRIBUTE5 IN CN_CALC_FORMULAS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
71 X_ATTRIBUTE6 IN CN_CALC_FORMULAS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
72 X_ATTRIBUTE7 IN CN_CALC_FORMULAS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
73 X_ATTRIBUTE8 IN CN_CALC_FORMULAS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
74 X_ATTRIBUTE9 IN CN_CALC_FORMULAS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
75 X_ATTRIBUTE10 IN CN_CALC_FORMULAS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
76 X_ATTRIBUTE11 IN CN_CALC_FORMULAS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
77 X_ATTRIBUTE12 IN CN_CALC_FORMULAS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
78 X_ATTRIBUTE13 IN CN_CALC_FORMULAS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
79 X_ATTRIBUTE14 IN CN_CALC_FORMULAS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
80 X_ATTRIBUTE15 IN CN_CALC_FORMULAS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
81 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_CALC_FORMULAS.OBJECT_VERSION_NUMBER%TYPE,
82 X_LAST_UPDATE_DATE IN CN_CALC_FORMULAS.LAST_UPDATE_DATE%TYPE := SYSDATE,
83 X_LAST_UPDATED_BY IN CN_CALC_FORMULAS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
84 X_LAST_UPDATE_LOGIN IN CN_CALC_FORMULAS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID);
85
86 procedure DELETE_ROW (
87 X_CALC_FORMULA_ID IN CN_CALC_FORMULAS.CALC_FORMULA_ID%TYPE,
88 X_ORG_ID IN CN_CALC_FORMULAS.ORG_ID%TYPE);
89 end CN_CALC_FORMULAS_PKG;