[Home] [Help]
PACKAGE: APPS.AMW_COMPLIANCE_ENVS_PKG
Source
1 PACKAGE AMW_COMPLIANCE_ENVS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwtenvs.pls 120.1 2006/05/31 23:33:50 npanandi noship $ */
3
4
5 -- ===============================================================
6 -- Package name
7 -- AMW_COMPLIANCE_ENVS_PKG
8 -- Purpose
9 --
10 -- History
11 -- 06/24/2004 tsho Creates
12 -- ===============================================================
13
14
15 -- ===============================================================
16 -- Procedure name
17 -- INSERT_ROW
18 -- Purpose
19 -- create new compliance environment
20 -- in AMW_COMPLIANCE_ENVS_B and AMW_COMPLIANCE_ENVS_TL
21 -- ===============================================================
22 procedure INSERT_ROW (
23 X_ROWID in out nocopy VARCHAR2,
24 X_COMPLIANCE_ENV_ID in NUMBER,
25 X_START_DATE in DATE,
26 X_END_DATE in DATE,
27 X_ENABLED_FLAG in VARCHAR2,
28 X_LAST_UPDATED_BY in NUMBER,
29 X_LAST_UPDATE_DATE in DATE,
30 X_CREATED_BY in NUMBER,
31 X_CREATION_DATE in DATE,
32 X_LAST_UPDATE_LOGIN in NUMBER,
33 X_SECURITY_GROUP_ID in NUMBER,
34 X_OBJECT_VERSION_NUMBER in NUMBER,
35 X_ATTRIBUTE_CATEGORY in VARCHAR2,
36 X_ATTRIBUTE1 in VARCHAR2,
37 X_ATTRIBUTE2 in VARCHAR2,
38 X_ATTRIBUTE3 in VARCHAR2,
39 X_ATTRIBUTE4 in VARCHAR2,
40 X_ATTRIBUTE5 in VARCHAR2,
41 X_ATTRIBUTE6 in VARCHAR2,
42 X_ATTRIBUTE7 in VARCHAR2,
43 X_ATTRIBUTE8 in VARCHAR2,
44 X_ATTRIBUTE9 in VARCHAR2,
45 X_ATTRIBUTE10 in VARCHAR2,
46 X_ATTRIBUTE11 in VARCHAR2,
47 X_ATTRIBUTE12 in VARCHAR2,
48 X_ATTRIBUTE13 in VARCHAR2,
49 X_ATTRIBUTE14 in VARCHAR2,
50 X_ATTRIBUTE15 in VARCHAR2,
51 X_COMPLIANCE_ENV_NAME in VARCHAR2,
52 X_COMPLIANCE_ENV_ALIAS in VARCHAR2,
53 X_COMPLIANCE_ENV_DESCRIPTION in VARCHAR2);
54
55
56
57 -- ===============================================================
58 -- Procedure name
59 -- LOCK_ROW
60 -- Purpose
61 --
62 -- ===============================================================
63 procedure LOCK_ROW (
64 X_COMPLIANCE_ENV_ID in NUMBER,
65 X_START_DATE in DATE,
66 X_END_DATE in DATE,
67 X_ENABLED_FLAG in VARCHAR2,
68 X_SECURITY_GROUP_ID in NUMBER,
69 X_OBJECT_VERSION_NUMBER in NUMBER,
70 X_ATTRIBUTE_CATEGORY in VARCHAR2,
71 X_ATTRIBUTE1 in VARCHAR2,
72 X_ATTRIBUTE2 in VARCHAR2,
73 X_ATTRIBUTE3 in VARCHAR2,
74 X_ATTRIBUTE4 in VARCHAR2,
75 X_ATTRIBUTE5 in VARCHAR2,
76 X_ATTRIBUTE6 in VARCHAR2,
77 X_ATTRIBUTE7 in VARCHAR2,
78 X_ATTRIBUTE8 in VARCHAR2,
79 X_ATTRIBUTE9 in VARCHAR2,
80 X_ATTRIBUTE10 in VARCHAR2,
81 X_ATTRIBUTE11 in VARCHAR2,
82 X_ATTRIBUTE12 in VARCHAR2,
83 X_ATTRIBUTE13 in VARCHAR2,
84 X_ATTRIBUTE14 in VARCHAR2,
85 X_ATTRIBUTE15 in VARCHAR2,
86 X_COMPLIANCE_ENV_NAME in VARCHAR2,
87 X_COMPLIANCE_ENV_ALIAS in VARCHAR2,
88 X_COMPLIANCE_ENV_DESCRIPTION in VARCHAR2);
89
90
91
92 -- ===============================================================
93 -- Procedure name
94 -- UPDATE_ROW
95 -- Purpose
96 -- update AMW_COMPLIANCE_ENVS_B and AMW_COMPLIANCE_ENVS_TL
97 -- ===============================================================
98 procedure UPDATE_ROW (
99 X_COMPLIANCE_ENV_ID in NUMBER,
100 X_START_DATE in DATE,
101 X_END_DATE in DATE,
102 X_ENABLED_FLAG in VARCHAR2,
103 X_LAST_UPDATED_BY in NUMBER,
104 X_LAST_UPDATE_DATE in DATE,
105 X_LAST_UPDATE_LOGIN in NUMBER,
106 X_SECURITY_GROUP_ID in NUMBER,
107 X_OBJECT_VERSION_NUMBER in NUMBER,
108 X_ATTRIBUTE_CATEGORY in VARCHAR2,
109 X_ATTRIBUTE1 in VARCHAR2,
110 X_ATTRIBUTE2 in VARCHAR2,
111 X_ATTRIBUTE3 in VARCHAR2,
112 X_ATTRIBUTE4 in VARCHAR2,
113 X_ATTRIBUTE5 in VARCHAR2,
114 X_ATTRIBUTE6 in VARCHAR2,
115 X_ATTRIBUTE7 in VARCHAR2,
116 X_ATTRIBUTE8 in VARCHAR2,
117 X_ATTRIBUTE9 in VARCHAR2,
118 X_ATTRIBUTE10 in VARCHAR2,
119 X_ATTRIBUTE11 in VARCHAR2,
120 X_ATTRIBUTE12 in VARCHAR2,
121 X_ATTRIBUTE13 in VARCHAR2,
122 X_ATTRIBUTE14 in VARCHAR2,
123 X_ATTRIBUTE15 in VARCHAR2,
124 X_COMPLIANCE_ENV_NAME in VARCHAR2,
125 X_COMPLIANCE_ENV_ALIAS in VARCHAR2,
126 X_COMPLIANCE_ENV_DESCRIPTION in VARCHAR2);
127
128
129 -- ===============================================================
130 -- Procedure name
131 -- LOAD_ROW
132 -- Purpose
133 -- load data to AMW_COMPLIANCE_ENVS_B and AMW_COMPLIANCE_ENVS_TL
134 -- ===============================================================
135 procedure LOAD_ROW (
136 X_COMPLIANCE_ENV_ID in NUMBER,
137 X_START_DATE in DATE,
138 X_END_DATE in DATE,
139 X_ENABLED_FLAG in VARCHAR2,
140 X_SECURITY_GROUP_ID in NUMBER,
141 X_OBJECT_VERSION_NUMBER in NUMBER,
142 X_ATTRIBUTE_CATEGORY in VARCHAR2,
143 X_ATTRIBUTE1 in VARCHAR2,
144 X_ATTRIBUTE2 in VARCHAR2,
145 X_ATTRIBUTE3 in VARCHAR2,
146 X_ATTRIBUTE4 in VARCHAR2,
147 X_ATTRIBUTE5 in VARCHAR2,
148 X_ATTRIBUTE6 in VARCHAR2,
149 X_ATTRIBUTE7 in VARCHAR2,
150 X_ATTRIBUTE8 in VARCHAR2,
151 X_ATTRIBUTE9 in VARCHAR2,
152 X_ATTRIBUTE10 in VARCHAR2,
153 X_ATTRIBUTE11 in VARCHAR2,
154 X_ATTRIBUTE12 in VARCHAR2,
155 X_ATTRIBUTE13 in VARCHAR2,
156 X_ATTRIBUTE14 in VARCHAR2,
157 X_ATTRIBUTE15 in VARCHAR2,
158 X_COMPLIANCE_ENV_NAME in VARCHAR2,
159 X_COMPLIANCE_ENV_ALIAS in VARCHAR2,
160 X_COMPLIANCE_ENV_DESCRIPTION in VARCHAR2,
161 X_OWNER in VARCHAR2);
162
163
164 -- ===============================================================
165 -- Procedure name
166 -- DELETE_ROW
167 -- Purpose
168 --
169 -- ===============================================================
170 procedure DELETE_ROW (
171 X_COMPLIANCE_ENV_ID in NUMBER);
172
173
174
175 -- ===============================================================
176 -- Procedure name
177 -- ADD_LANGUAGE
178 -- Purpose
179 --
180 -- ===============================================================
181 procedure ADD_LANGUAGE;
182
183 /**05.31.2006 npanandi: bug 5259681 fix, added translate row***/
184 -- ===============================================================
185 -- Procedure name
186 -- TRANSLATE_ROW
187 -- Purpose
188 -- translate a row for MLS enabled DB environments
189 -- ===============================================================
190 procedure TRANSLATE_ROW(
191 X_COMPLIANCE_ENV_ID in NUMBER,
192 X_COMPLIANCE_ENV_NAME in VARCHAR2,
193 X_COMPLIANCE_ENV_DESCRIPTION In VARCHAR2,
194 X_COMPLIANCE_ENV_ALIAS in VARCHAR2,
195 X_LAST_UPDATE_DATE in VARCHAR2,
196 X_OWNER in VARCHAR2,
197 X_CUSTOM_MODE in VARCHAR2);
198 /**05.31.2006 npanandi: bug 5259681 fix ends***/
199
200 -- ----------------------------------------------------------------------
201 end AMW_COMPLIANCE_ENVS_PKG;