[Home] [Help]
PACKAGE: APPS.GCS_CURR_TREATMENTS_PKG
Source
1 PACKAGE GCS_CURR_TREATMENTS_PKG AS
2 /* $Header: gcs_curr_trts.pls 120.1 2005/10/30 05:17:17 appldev noship $ */
3
4 --
5 -- Procedure
6 -- Insert_Row
7 -- Purpose
8 -- Inserts a row into the gcs_curr_treatments_b and gcs_curr_treatments_tl table.
9 -- Arguments
10 -- row_id
11 -- CURR_TREATMENT_ID
12 -- ENDING_RATE_TYPE
13 -- AVERAGE_RATE_TYPE
14 -- EQUITY_MODE_CODE
15 -- INC_STMT_MODE_CODE
16 -- ENABLED_FLAG
17 -- DEFAULT_FLAG
18 -- FINANCIAL_ELEM_ID
19 -- PRODUCT_ID
20 -- NATURAL_ACCOUNT_ID
21 -- CHANNEL_ID
22 -- LINE_ITEM_ID
23 -- PROJECT_ID
24 -- CUSTOMER_ID
25 -- CTA_USER_DIM1_ID
26 -- CTA_USER_DIM2_ID
27 -- CTA_USER_DIM3_ID
28 -- CTA_USER_DIM4_ID
29 -- CTA_USER_DIM5_ID
30 -- CTA_USER_DIM6_ID
31 -- CTA_USER_DIM7_ID
32 -- CTA_USER_DIM8_ID
33 -- CTA_USER_DIM9_ID
34 -- CTA_USER_DIM10_ID
35 -- TASK_ID
36 -- CREATION_DATE
37 -- CREATED_BY
38 -- LAST_UPDATE_DATE
39 -- LAST_UPDATED_BY
40 -- LAST_UPDATE_LOGIN
41 -- OBJECT_VERSION_NUMBER
42 -- CURR_TREATMENT_NAME
43 -- DESCRIPTION
44
45 -- Example
46 -- GCS_CURR_TREATMENTS_PKG.Insert_Row(...);
47 -- Notes
48 --
49
50
51 PROCEDURE Insert_Row
52 (
53 row_id IN OUT NOCOPY VARCHAR2,
54 CURR_TREATMENT_ID NUMBER,
55 ENDING_RATE_TYPE VARCHAR2,
56 AVERAGE_RATE_TYPE VARCHAR2,
57 EQUITY_MODE_CODE VARCHAR2,
58 INC_STMT_MODE_CODE VARCHAR2,
59 ENABLED_FLAG VARCHAR2,
60 DEFAULT_FLAG VARCHAR2,
61 FINANCIAL_ELEM_ID NUMBER,
62 PRODUCT_ID NUMBER,
63 NATURAL_ACCOUNT_ID NUMBER,
64 CHANNEL_ID NUMBER,
65 LINE_ITEM_ID NUMBER,
66 PROJECT_ID NUMBER,
67 CUSTOMER_ID NUMBER,
68 CTA_USER_DIM1_ID NUMBER,
69 CTA_USER_DIM2_ID NUMBER,
70 CTA_USER_DIM3_ID NUMBER,
71 CTA_USER_DIM4_ID NUMBER,
72 CTA_USER_DIM5_ID NUMBER,
73 CTA_USER_DIM6_ID NUMBER,
74 CTA_USER_DIM7_ID NUMBER,
75 CTA_USER_DIM8_ID NUMBER,
76 CTA_USER_DIM9_ID NUMBER,
77 CTA_USER_DIM10_ID NUMBER,
78 TASK_ID NUMBER,
79 CREATION_DATE DATE,
80 CREATED_BY NUMBER,
81 LAST_UPDATE_DATE DATE,
82 LAST_UPDATED_BY NUMBER,
83 LAST_UPDATE_LOGIN NUMBER,
84 OBJECT_VERSION_NUMBER NUMBER,
85 CURR_TREATMENT_NAME VARCHAR2,
86 DESCRIPTION VARCHAR2
87 );
88
89
90
91 --
92 -- Procedure
93 -- Update_Row
94 -- Purpose
95 -- Updates a row in the gcs_curr_treatments_b table.
96 -- Arguments
97 -- row_id
98 -- CURR_TREATMENT_ID
99 -- ENDING_RATE_TYPE
100 -- AVERAGE_RATE_TYPE
101 -- EQUITY_MODE_CODE
102 -- INC_STMT_MODE_CODE
103 -- ENABLED_FLAG
104 -- DEFAULT_FLAG
105 -- LAST_UPDATE_DATE
106 -- LAST_UPDATED_BY
107 -- CREATION_DATE
108 -- CREATED_BY
109 -- LAST_UPDATE_LOGIN
110 -- FINANCIAL_ELEM_ID
111 -- PRODUCT_ID
112 -- NATURAL_ACCOUNT_ID
113 -- CHANNEL_ID
114 -- LINE_ITEM_ID
115 -- PROJECT_ID
116 -- CUSTOMER_ID
117 -- CTA_USER_DIM1_ID
118 -- CTA_USER_DIM2_ID
119 -- CTA_USER_DIM3_ID
120 -- CTA_USER_DIM4_ID
121 -- CTA_USER_DIM5_ID
122 -- CTA_USER_DIM6_ID
123 -- CTA_USER_DIM7_ID
124 -- CTA_USER_DIM8_ID
125 -- CTA_USER_DIM9_ID
126 -- CTA_USER_DIM10_ID
127 -- TASK_ID
128 -- OBJECT_VERSION_NUMBER
129 -- CURR_TREATMENT_NAME
130 -- DESCRIPTION
131
132 -- Example
133 -- GCS_CURR_TREATMENTS_PKG.Update_Row(...);
134 -- Notes
135 --
136
137
138 PROCEDURE Update_Row
139 (
140 row_id IN OUT NOCOPY VARCHAR2,
141 CURR_TREATMENT_ID NUMBER,
142 ENDING_RATE_TYPE VARCHAR2,
143 AVERAGE_RATE_TYPE VARCHAR2,
144 EQUITY_MODE_CODE VARCHAR2,
145 INC_STMT_MODE_CODE VARCHAR2,
146 ENABLED_FLAG VARCHAR2,
147 DEFAULT_FLAG VARCHAR2,
148 LAST_UPDATE_DATE DATE,
149 LAST_UPDATED_BY NUMBER,
150 CREATION_DATE DATE,
151 CREATED_BY NUMBER,
152 LAST_UPDATE_LOGIN NUMBER,
153 FINANCIAL_ELEM_ID NUMBER,
154 PRODUCT_ID NUMBER,
155 NATURAL_ACCOUNT_ID NUMBER,
156 CHANNEL_ID NUMBER,
157 LINE_ITEM_ID NUMBER,
158 PROJECT_ID NUMBER,
159 CUSTOMER_ID NUMBER,
160 CTA_USER_DIM1_ID NUMBER,
161 CTA_USER_DIM2_ID NUMBER,
162 CTA_USER_DIM3_ID NUMBER,
163 CTA_USER_DIM4_ID NUMBER,
164 CTA_USER_DIM5_ID NUMBER,
165 CTA_USER_DIM6_ID NUMBER,
166 CTA_USER_DIM7_ID NUMBER,
167 CTA_USER_DIM8_ID NUMBER,
168 CTA_USER_DIM9_ID NUMBER,
169 CTA_USER_DIM10_ID NUMBER,
170 TASK_ID NUMBER,
171 OBJECT_VERSION_NUMBER NUMBER,
172 CURR_TREATMENT_NAME VARCHAR2,
173 DESCRIPTION VARCHAR2
174 );
175
176
177
178
179 -- Procedure
180 -- Load_Row
181 -- Purpose
182 -- Loads a row in the gcs_curr_treatments_b table.
183 -- Arguments
184 --row_id
185 --CURR_TREATMENT_ID
186 --ENDING_RATE_TYPE
187 --AVERAGE_RATE_TYPE
188 --EQUITY_MODE_CODE
189 --INC_STMT_MODE_CODE
190 --ENABLED_FLAG
191 --DEFAULT_FLAG
192 --LAST_UPDATE_DATE
193 --LAST_UPDATED_BY
194 --CREATION_DATE
195 --CREATED_BY
196 --LAST_UPDATE_LOGIN
197 --FINANCIAL_ELEM_ID
198 --PRODUCT_ID
199 --NATURAL_ACCOUNT_ID
200 --CHANNEL_ID
201 --LINE_ITEM_ID
202 --PROJECT_ID
203 --CUSTOMER_ID
204 --CTA_USER_DIM1_ID
205 --CTA_USER_DIM2_ID
206 --CTA_USER_DIM3_ID
207 --CTA_USER_DIM4_ID
208 --CTA_USER_DIM5_ID
209 --CTA_USER_DIM6_ID
210 --CTA_USER_DIM7_ID
211 --CTA_USER_DIM8_ID
212 --CTA_USER_DIM9_ID
213 --CTA_USER_DIM10_ID
214 --TASK_ID
215 --OBJECT_VERSION_NUMBER
216 --CURR_TREATMENT_NAME
217 --DESCRIPTION
218 --owner
219 --custom_mode
220
221 -- Example
222 -- GCS_CURR_TREATMENTS_PKG.Update_Row(...);
223 -- Notes
224 --
225
226 PROCEDURE Load_Row
227 (
228 row_id IN OUT NOCOPY VARCHAR2,
229 CURR_TREATMENT_ID NUMBER,
230 ENDING_RATE_TYPE VARCHAR2,
231 AVERAGE_RATE_TYPE VARCHAR2,
232 EQUITY_MODE_CODE VARCHAR2,
233 INC_STMT_MODE_CODE VARCHAR2,
234 ENABLED_FLAG VARCHAR2,
235 DEFAULT_FLAG VARCHAR2,
236 LAST_UPDATE_DATE DATE,
237 LAST_UPDATED_BY NUMBER,
238 CREATION_DATE DATE,
239 CREATED_BY NUMBER,
240 LAST_UPDATE_LOGIN NUMBER,
241 FINANCIAL_ELEM_ID NUMBER,
242 PRODUCT_ID NUMBER,
243 NATURAL_ACCOUNT_ID NUMBER,
244 CHANNEL_ID NUMBER,
245 LINE_ITEM_ID NUMBER,
246 PROJECT_ID NUMBER,
247 CUSTOMER_ID NUMBER,
248 CTA_USER_DIM1_ID NUMBER,
249 CTA_USER_DIM2_ID NUMBER,
250 CTA_USER_DIM3_ID NUMBER,
251 CTA_USER_DIM4_ID NUMBER,
252 CTA_USER_DIM5_ID NUMBER,
253 CTA_USER_DIM6_ID NUMBER,
254 CTA_USER_DIM7_ID NUMBER,
255 CTA_USER_DIM8_ID NUMBER,
256 CTA_USER_DIM9_ID NUMBER,
257 CTA_USER_DIM10_ID NUMBER,
258 TASK_ID NUMBER,
259 OBJECT_VERSION_NUMBER NUMBER,
260 CURR_TREATMENT_NAME VARCHAR2,
261 DESCRIPTION VARCHAR2,
262 owner VARCHAR2,
263 custom_mode varchar2
264 );
265
266
267
268
269 -- Procedure
270 -- Load_Row
271 -- Purpose
272 -- Translates a row in the gcs_curr_treatments_tl table.
273 -- Arguments
274 -- CURR_TREATMENT_ID
275 -- LANGUAGE
276 -- SOURCE_LANG
277 -- CURR_TREATMENT_NAME
278 -- LAST_UPDATE_DATE
279 -- LAST_UPDATED_BY
280 -- CREATION_DATE
281 -- CREATED_BY
282 -- LAST_UPDATE_LOGIN
283 -- DESCRIPTION
284 -- owner
285 -- custom_mode
286
287 -- Example
288 -- GCS_CURR_TREATMENTS_PKG.Translate_Row(...);
289 -- Notes
290 --
291
292 PROCEDURE Translate_Row
293 (
294 CURR_TREATMENT_ID NUMBER,
295 CURR_TREATMENT_NAME VARCHAR2,
296 LAST_UPDATE_DATE DATE,
297 LAST_UPDATED_BY NUMBER,
298 CREATION_DATE DATE,
299 CREATED_BY NUMBER,
300 LAST_UPDATE_LOGIN NUMBER,
301 DESCRIPTION VARCHAR2,
302 owner VARCHAR2,
303 custom_mode varchar2
304
305 );
306
307
308 PROCEDURE ADD_LANGUAGE;
309
310 END GCS_CURR_TREATMENTS_PKG;