[Home] [Help]
PACKAGE BODY: APPS.FVFCRT7B
Source
1 Package Body FVFCRT7B as
2 /* $Header: FVFCRT7B.pls 115.7 2002/06/17 00:41:37 ksriniva ship $ */
3 Procedure Main (errbuf out varchar2,
4 retcode out varchar2) IS
5 v_count number;
6 v_sob number;
7 v_sob_name Varchar2(100);
8 begin
9 -- Verify that the table is not already seeded for an specific set_of_books
10
11 v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
12 v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
13
14 SELECT count(*)
15 INTO v_count
16 FROM fv_facts_rt7_codes
17 WHERE set_of_books_id =v_sob;
18
19 IF v_count > 0
20 THEN
21 null;
22 /* errbuf := 'Table already seeded for Set of Books: '||v_sob_name; */
23 fv_utility.debug_mesg ('Table already seeded for Set of Books: '||v_sob_name);
24 ELSE
25 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
26 RT7_CODE_ID,
27 RT7_CODE,
28 RT7_BORROWING_SOURCE,
29 RT7_CODE_DESCRIPTION,
30 RT7_AUTHORITY_TYPE,
31 CREATION_DATE,
32 CREATED_BY,
33 LAST_UPDATE_DATE,
34 LAST_UPDATED_BY,
35 LAST_UPDATE_LOGIN)
36 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
37 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
38 '911', -- Authorization code
39 ' ', -- RT7 borrowing source
40 'Investments Purchased at a Discount - Unrealized Discount', -- Transaction Type
41 'O', -- RT7 authority type
42 sysdate, -- creation_date
43 FND_GLOBAL.USER_ID, -- created by
44 sysdate, -- last update date
45 FND_GLOBAL.USER_ID, -- last updated by
46 FND_GLOBAL.USER_ID -- last updated login
47 );
48
49 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
50 RT7_ACCOUNT_ID,
51 RT7_CODE_ID,
52 RT7_BE_FLAG,
53 RT7_USSGL_ACCOUNT,
54 RT7_TRANSACTION_PARTNER,
55 CREATION_DATE,
56 CREATED_BY,
57 LAST_UPDATE_DATE,
58 LAST_UPDATED_BY,
59 LAST_UPDATE_LOGIN)
60 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
61 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
62 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
63 'E', -- Begin/End flag
64 '1611', -- USSGL Account
65 'N', -- Transaction Partner
66 sysdate, -- creation_date
67 FND_GLOBAL.USER_ID, -- created by
68 sysdate, -- last update date
69 FND_GLOBAL.USER_ID, -- last updated by
70 FND_GLOBAL.USER_ID -- last updated login
71 );
72 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
73 RT7_ACCOUNT_ID,
74 RT7_CODE_ID,
75 RT7_BE_FLAG,
76 RT7_USSGL_ACCOUNT,
77 RT7_TRANSACTION_PARTNER,
78 CREATION_DATE,
79 CREATED_BY,
80 LAST_UPDATE_DATE,
81 LAST_UPDATED_BY,
82 LAST_UPDATE_LOGIN)
83 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
84 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
85 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
86 'E', -- Begin/End flag
87 '1621', -- USSGL Account
88 'N', -- Transaction Partner
89 sysdate, -- creation_date
90 FND_GLOBAL.USER_ID, -- created by
91 sysdate, -- last update date
92 FND_GLOBAL.USER_ID, -- last updated by
93 FND_GLOBAL.USER_ID -- last updated login
94 );
95
96 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
97 RT7_CODE_ID,
98 RT7_CODE,
99 RT7_BORROWING_SOURCE,
100 RT7_CODE_DESCRIPTION,
101 RT7_AUTHORITY_TYPE,
102 CREATION_DATE,
103 CREATED_BY,
104 LAST_UPDATE_DATE,
105 LAST_UPDATED_BY,
106 LAST_UPDATE_LOGIN)
107 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
108 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
109 '921', -- Authorization code
110 ' ', -- RT7 borrowing source
111 'Funds Held Outside the Treasury - Imprest Funds', -- Transaction Type
112 'O', -- RT7 authority type
113 sysdate, -- creation_date
114 FND_GLOBAL.USER_ID, -- created by
115 sysdate, -- last update date
116 FND_GLOBAL.USER_ID, -- last updated by
117 FND_GLOBAL.USER_ID -- last updated login
118 );
119 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
120 RT7_ACCOUNT_ID,
121 RT7_CODE_ID,
122 RT7_BE_FLAG,
123 RT7_USSGL_ACCOUNT,
124 RT7_TRANSACTION_PARTNER,
125 CREATION_DATE,
126 CREATED_BY,
127 LAST_UPDATE_DATE,
128 LAST_UPDATED_BY,
129 LAST_UPDATE_LOGIN)
130 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
131 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
132 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
133 'E', -- Begin/End flag
134 '1120', -- USSGL Account
135 'N', -- Transaction Partner
136 sysdate, -- creation_date
137 FND_GLOBAL.USER_ID, -- created by
138 sysdate, -- last update date
139 FND_GLOBAL.USER_ID, -- last updated by
140 FND_GLOBAL.USER_ID -- last updated login
141 );
142 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
143 RT7_ACCOUNT_ID,
144 RT7_CODE_ID,
145 RT7_BE_FLAG,
146 RT7_USSGL_ACCOUNT,
147 RT7_TRANSACTION_PARTNER,
148 CREATION_DATE,
149 CREATED_BY,
150 LAST_UPDATE_DATE,
151 LAST_UPDATED_BY,
152 LAST_UPDATE_LOGIN)
153 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
154 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
155 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
156 'E', -- Begin/End flag
157 '1130', -- USSGL Account
158 'N', -- Transaction Partner
159 sysdate, -- creation_date
160 FND_GLOBAL.USER_ID, -- created by
161 sysdate, -- last update date
162 FND_GLOBAL.USER_ID, -- last updated by
163 FND_GLOBAL.USER_ID -- last updated login
164 );
165
166
167 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
168 RT7_CODE_ID,
169 RT7_CODE,
170 RT7_BORROWING_SOURCE,
171 RT7_CODE_DESCRIPTION,
172 RT7_AUTHORITY_TYPE,
173 CREATION_DATE,
174 CREATED_BY,
175 LAST_UPDATE_DATE,
176 LAST_UPDATED_BY,
177 LAST_UPDATE_LOGIN)
178 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
179 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
180 '931', -- Authorization code
181 ' ', -- RT7 borrowing source
182 'Investments Purchased at a Discount - Unamortized Premium and Discount', -- Transaction Type
183 'O', -- RT7 authority type
184 sysdate, -- creation_date
185 FND_GLOBAL.USER_ID, -- created by
186 sysdate, -- last update date
187 FND_GLOBAL.USER_ID, -- last updated by
188 FND_GLOBAL.USER_ID -- last updated login
189 );
190 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
191 RT7_ACCOUNT_ID,
192 RT7_CODE_ID,
193 RT7_BE_FLAG,
194 RT7_USSGL_ACCOUNT,
195 RT7_TRANSACTION_PARTNER,
196 CREATION_DATE,
197 CREATED_BY,
198 LAST_UPDATE_DATE,
199 LAST_UPDATED_BY,
200 LAST_UPDATE_LOGIN)
201 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
202 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
203 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
204 'E', -- Begin/End flag
205 '1611', -- USSGL Account
206 'N', -- Transaction Partner
207 sysdate, -- creation_date
208 FND_GLOBAL.USER_ID, -- created by
209 sysdate, -- last update date
210 FND_GLOBAL.USER_ID, -- last updated by
211 FND_GLOBAL.USER_ID -- last updated login
212 );
213 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
214 RT7_ACCOUNT_ID,
215 RT7_CODE_ID,
216 RT7_BE_FLAG,
217 RT7_USSGL_ACCOUNT,
218 RT7_TRANSACTION_PARTNER,
219 CREATION_DATE,
220 CREATED_BY,
221 LAST_UPDATE_DATE,
222 LAST_UPDATED_BY,
223 LAST_UPDATE_LOGIN)
224 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
225 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
226 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
227 'E', -- Begin/End flag
228 '1612', -- USSGL Account
229 'N', -- Transaction Partner
230 sysdate, -- creation_date
231 FND_GLOBAL.USER_ID, -- created by
232 sysdate, -- last update date
233 FND_GLOBAL.USER_ID, -- last updated by
234 FND_GLOBAL.USER_ID -- last updated login
235 );
236 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
237 RT7_ACCOUNT_ID,
238 RT7_CODE_ID,
239 RT7_BE_FLAG,
240 RT7_USSGL_ACCOUNT,
241 RT7_TRANSACTION_PARTNER,
242 CREATION_DATE,
243 CREATED_BY,
244 LAST_UPDATE_DATE,
245 LAST_UPDATED_BY,
246 LAST_UPDATE_LOGIN)
247 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
248 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
249 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
250 'E', -- Begin/End flag
251 '1613', -- USSGL Account
252 'N', -- Transaction Partner
253 sysdate, -- creation_date
254 FND_GLOBAL.USER_ID, -- created by
255 sysdate, -- last update date
256 FND_GLOBAL.USER_ID, -- last updated by
257 FND_GLOBAL.USER_ID -- last updated login
258 );
259
260 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
261 RT7_CODE_ID,
262 RT7_CODE,
263 RT7_BORROWING_SOURCE,
264 RT7_CODE_DESCRIPTION,
265 RT7_AUTHORITY_TYPE,
266 CREATION_DATE,
267 CREATED_BY,
268 LAST_UPDATE_DATE,
269 LAST_UPDATED_BY,
270 LAST_UPDATE_LOGIN)
271 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
272 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
273 '941', -- Authorization code
274 ' ', -- RT7 borrowing source
275 'Unfunded Contract Authority', -- Transaction Type
276 'C', -- RT7 authority type
277 sysdate, -- creation_date
278 FND_GLOBAL.USER_ID, -- created by
279 sysdate, -- last update date
280 FND_GLOBAL.USER_ID, -- last updated by
281 FND_GLOBAL.USER_ID -- last updated login
282 );
283 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
284 RT7_ACCOUNT_ID,
285 RT7_CODE_ID,
286 RT7_BE_FLAG,
287 RT7_USSGL_ACCOUNT,
288 RT7_TRANSACTION_PARTNER,
289 CREATION_DATE,
290 CREATED_BY,
291 LAST_UPDATE_DATE,
292 LAST_UPDATED_BY,
293 LAST_UPDATE_LOGIN)
294 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
295 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
296 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
297 'E', -- Begin/End flag
298 '4032', -- USSGL Account
299 'N', -- Transaction Partner
300 sysdate, -- creation_date
301 FND_GLOBAL.USER_ID, -- created by
302 sysdate, -- last update date
303 FND_GLOBAL.USER_ID, -- last updated by
304 FND_GLOBAL.USER_ID -- last updated login
305 );
306
307 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
308 RT7_ACCOUNT_ID,
309 RT7_CODE_ID,
310 RT7_BE_FLAG,
311 RT7_USSGL_ACCOUNT,
312 RT7_TRANSACTION_PARTNER,
313 CREATION_DATE,
314 CREATED_BY,
315 LAST_UPDATE_DATE,
316 LAST_UPDATED_BY,
317 LAST_UPDATE_LOGIN)
318 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
319 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
320 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
321 'E', -- Begin/End flag
322 '4034', -- USSGL Account
323 'N', -- Transaction Partner
324 sysdate, -- creation_date
325 FND_GLOBAL.USER_ID, -- created by
326 sysdate, -- last update date
327 FND_GLOBAL.USER_ID, -- last updated by
328 FND_GLOBAL.USER_ID -- last updated login
329 );
330
331 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
332 RT7_ACCOUNT_ID,
333 RT7_CODE_ID,
334 RT7_BE_FLAG,
335 RT7_USSGL_ACCOUNT,
336 RT7_TRANSACTION_PARTNER,
337 CREATION_DATE,
338 CREATED_BY,
339 LAST_UPDATE_DATE,
340 LAST_UPDATED_BY,
341 LAST_UPDATE_LOGIN)
342 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
343 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
344 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
345 'E', -- Begin/End flag
346 '4131', -- USSGL Account
347 'N', -- Transaction Partner
348 sysdate, -- creation_date
349 FND_GLOBAL.USER_ID, -- created by
350 sysdate, -- last update date
351 FND_GLOBAL.USER_ID, -- last updated by
352 FND_GLOBAL.USER_ID -- last updated login
353 );
354
355 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
356 RT7_ACCOUNT_ID,
357 RT7_CODE_ID,
358 RT7_BE_FLAG,
359 RT7_USSGL_ACCOUNT,
360 RT7_TRANSACTION_PARTNER,
361 CREATION_DATE,
362 CREATED_BY,
363 LAST_UPDATE_DATE,
364 LAST_UPDATED_BY,
365 LAST_UPDATE_LOGIN)
366 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
367 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
368 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
369 'E', -- Begin/End flag
370 '4132', -- USSGL Account
371 'N', -- Transaction Partner
372 sysdate, -- creation_date
373 FND_GLOBAL.USER_ID, -- created by
374 sysdate, -- last update date
375 FND_GLOBAL.USER_ID, -- last updated by
376 FND_GLOBAL.USER_ID -- last updated login
377 );
378
379 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
383 RT7_USSGL_ACCOUNT,
380 RT7_ACCOUNT_ID,
381 RT7_CODE_ID,
382 RT7_BE_FLAG,
384 RT7_TRANSACTION_PARTNER,
385 CREATION_DATE,
386 CREATED_BY,
387 LAST_UPDATE_DATE,
388 LAST_UPDATED_BY,
389 LAST_UPDATE_LOGIN)
390 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
391 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
392 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
393 'E', -- Begin/End flag
394 '4133', -- USSGL Account
395 'N', -- Transaction Partner
396 sysdate, -- creation_date
397 FND_GLOBAL.USER_ID, -- created by
398 sysdate, -- last update date
399 FND_GLOBAL.USER_ID, -- last updated by
400 FND_GLOBAL.USER_ID -- last updated login
401 );
402
403 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
404 RT7_ACCOUNT_ID,
405 RT7_CODE_ID,
406 RT7_BE_FLAG,
407 RT7_USSGL_ACCOUNT,
408 RT7_TRANSACTION_PARTNER,
409 CREATION_DATE,
410 CREATED_BY,
411 LAST_UPDATE_DATE,
412 LAST_UPDATED_BY,
413 LAST_UPDATE_LOGIN)
414 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
415 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
416 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
417 'E', -- Begin/End flag
418 '4135', -- USSGL Account
419 'N', -- Transaction Partner
420 sysdate, -- creation_date
421 FND_GLOBAL.USER_ID, -- created by
422 sysdate, -- last update date
423 FND_GLOBAL.USER_ID, -- last updated by
424 FND_GLOBAL.USER_ID -- last updated login
425 );
426
427 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
428 RT7_ACCOUNT_ID,
429 RT7_CODE_ID,
430 RT7_BE_FLAG,
431 RT7_USSGL_ACCOUNT,
432 RT7_TRANSACTION_PARTNER,
433 CREATION_DATE,
434 CREATED_BY,
435 LAST_UPDATE_DATE,
436 LAST_UPDATED_BY,
437 LAST_UPDATE_LOGIN)
438 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
439 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
440 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
441 'E', -- Begin/End flag
442 '4138', -- USSGL Account
443 'N', -- Transaction Partner
444 sysdate, -- creation_date
445 FND_GLOBAL.USER_ID, -- created by
446 sysdate, -- last update date
447 FND_GLOBAL.USER_ID, -- last updated by
448 FND_GLOBAL.USER_ID -- last updated login
449 );
450
451 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
452 RT7_ACCOUNT_ID,
453 RT7_CODE_ID,
454 RT7_BE_FLAG,
455 RT7_USSGL_ACCOUNT,
456 RT7_TRANSACTION_PARTNER,
457 CREATION_DATE,
458 CREATED_BY,
459 LAST_UPDATE_DATE,
460 LAST_UPDATED_BY,
461 LAST_UPDATE_LOGIN)
462 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
463 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
464 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
465 'B', -- Begin/End flag
466 '4139', -- USSGL Account
467 'N', -- Transaction Partner
468 sysdate, -- creation_date
469 FND_GLOBAL.USER_ID, -- created by
470 sysdate, -- last update date
471 FND_GLOBAL.USER_ID, -- last updated by
472 FND_GLOBAL.USER_ID -- last updated login
473 );
474
475 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
476 RT7_CODE_ID,
477 RT7_CODE,
478 RT7_BORROWING_SOURCE,
479 RT7_CODE_DESCRIPTION,
480 RT7_AUTHORITY_TYPE,
481 CREATION_DATE,
482 CREATED_BY,
483 LAST_UPDATE_DATE,
484 LAST_UPDATED_BY,
485 LAST_UPDATE_LOGIN)
486 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
487 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
488 '951', -- Authorization code
489 'T', -- RT7 borrowing source
490 'Authority to Borrow from the Treasury', -- Transaction Type
491 'B', -- RT7 authority type
492 sysdate, -- creation_date
493 FND_GLOBAL.USER_ID, -- created by
494 sysdate, -- last update date
495 FND_GLOBAL.USER_ID, -- last updated by
496 FND_GLOBAL.USER_ID -- last updated login
497 );
498 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
499 RT7_ACCOUNT_ID,
500 RT7_CODE_ID,
501 RT7_BE_FLAG,
502 RT7_USSGL_ACCOUNT,
503 RT7_TRANSACTION_PARTNER,
504 CREATION_DATE,
505 CREATED_BY,
506 LAST_UPDATE_DATE,
507 LAST_UPDATED_BY,
508 LAST_UPDATE_LOGIN)
509 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
510 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
511 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
512 'E', -- Begin/End flag
513 '4042', -- USSGL Account
514 'N', -- Transaction Partner
515 sysdate, -- creation_date
516 FND_GLOBAL.USER_ID, -- created by
517 sysdate, -- last update date
518 FND_GLOBAL.USER_ID, -- last updated by
519 FND_GLOBAL.USER_ID -- last updated login
520 );
521
522 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
523 RT7_ACCOUNT_ID,
524 RT7_CODE_ID,
525 RT7_BE_FLAG,
526 RT7_USSGL_ACCOUNT,
527 RT7_TRANSACTION_PARTNER,
528 CREATION_DATE,
529 CREATED_BY,
530 LAST_UPDATE_DATE,
531 LAST_UPDATED_BY,
532 LAST_UPDATE_LOGIN)
533 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
534 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
535 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
536 'E', -- Begin/End flag
537 '4044', -- USSGL Account
541 sysdate, -- last update date
538 'N', -- Transaction Partner
539 sysdate, -- creation_date
540 FND_GLOBAL.USER_ID, -- created by
542 FND_GLOBAL.USER_ID, -- last updated by
543 FND_GLOBAL.USER_ID -- last updated login
544 );
545
546 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
547 RT7_ACCOUNT_ID,
548 RT7_CODE_ID,
549 RT7_BE_FLAG,
550 RT7_USSGL_ACCOUNT,
551 RT7_TRANSACTION_PARTNER,
552 CREATION_DATE,
553 CREATED_BY,
554 LAST_UPDATE_DATE,
555 LAST_UPDATED_BY,
556 LAST_UPDATE_LOGIN)
557 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
558 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
559 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
560 'E', -- Begin/End flag
561 '4141', -- USSGL Account
562 'N', -- Transaction Partner
563 sysdate, -- creation_date
564 FND_GLOBAL.USER_ID, -- created by
565 sysdate, -- last update date
566 FND_GLOBAL.USER_ID, -- last updated by
567 FND_GLOBAL.USER_ID -- last updated login
568 );
569
570 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
571 RT7_ACCOUNT_ID,
572 RT7_CODE_ID,
573 RT7_BE_FLAG,
574 RT7_USSGL_ACCOUNT,
575 RT7_TRANSACTION_PARTNER,
576 CREATION_DATE,
577 CREATED_BY,
578 LAST_UPDATE_DATE,
579 LAST_UPDATED_BY,
580 LAST_UPDATE_LOGIN)
581 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
582 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
583 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
584 'E', -- Begin/End flag
585 '4142', -- USSGL Account
586 'N', -- Transaction Partner
587 sysdate, -- creation_date
588 FND_GLOBAL.USER_ID, -- created by
589 sysdate, -- last update date
590 FND_GLOBAL.USER_ID, -- last updated by
591 FND_GLOBAL.USER_ID -- last updated login
592 );
593
594 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
595 RT7_ACCOUNT_ID,
596 RT7_CODE_ID,
597 RT7_BE_FLAG,
598 RT7_USSGL_ACCOUNT,
599 RT7_TRANSACTION_PARTNER,
600 CREATION_DATE,
601 CREATED_BY,
602 LAST_UPDATE_DATE,
603 LAST_UPDATED_BY,
604 LAST_UPDATE_LOGIN)
605 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
606 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
607 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
608 'E', -- Begin/End flag
609 '4143', -- USSGL Account
610 'N', -- Transaction Partner
611 sysdate, -- creation_date
612 FND_GLOBAL.USER_ID, -- created by
613 sysdate, -- last update date
614 FND_GLOBAL.USER_ID, -- last updated by
615 FND_GLOBAL.USER_ID -- last updated login
616 );
617
618 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
619 RT7_ACCOUNT_ID,
620 RT7_CODE_ID,
621 RT7_BE_FLAG,
622 RT7_USSGL_ACCOUNT,
623 RT7_TRANSACTION_PARTNER,
624 CREATION_DATE,
625 CREATED_BY,
626 LAST_UPDATE_DATE,
627 LAST_UPDATED_BY,
628 LAST_UPDATE_LOGIN)
629 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
630 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
631 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
632 'E', -- Begin/End flag
633 '4145', -- USSGL Account
634 'N', -- Transaction Partner
635 sysdate, -- creation_date
636 FND_GLOBAL.USER_ID, -- created by
637 sysdate, -- last update date
638 FND_GLOBAL.USER_ID, -- last updated by
639 FND_GLOBAL.USER_ID -- last updated login
640 );
641
642 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
643 RT7_ACCOUNT_ID,
644 RT7_CODE_ID,
645 RT7_BE_FLAG,
646 RT7_USSGL_ACCOUNT,
647 RT7_TRANSACTION_PARTNER,
648 CREATION_DATE,
649 CREATED_BY,
650 LAST_UPDATE_DATE,
651 LAST_UPDATED_BY,
652 LAST_UPDATE_LOGIN)
653 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
654 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
655 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
656 'E', -- Begin/End flag
657 '4148', -- USSGL Account
658 'N', -- Transaction Partner
659 sysdate, -- creation_date
660 FND_GLOBAL.USER_ID, -- created by
661 sysdate, -- last update date
662 FND_GLOBAL.USER_ID, -- last updated by
663 FND_GLOBAL.USER_ID -- last updated login
664 );
665
666 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
667 RT7_ACCOUNT_ID,
668 RT7_CODE_ID,
669 RT7_BE_FLAG,
670 RT7_USSGL_ACCOUNT,
671 RT7_TRANSACTION_PARTNER,
672 CREATION_DATE,
673 CREATED_BY,
674 LAST_UPDATE_DATE,
675 LAST_UPDATED_BY,
676 LAST_UPDATE_LOGIN)
677 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
678 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
679 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
680 'B', -- Begin/End flag
681 '4149', -- USSGL Account
682 'N', -- Transaction Partner
683 sysdate, -- creation_date
684 FND_GLOBAL.USER_ID, -- created by
685 sysdate, -- last update date
686 FND_GLOBAL.USER_ID, -- last updated by
687 FND_GLOBAL.USER_ID -- last updated login
688 );
689
690 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
691 RT7_CODE_ID,
692 RT7_CODE,
693 RT7_BORROWING_SOURCE,
694 RT7_CODE_DESCRIPTION,
695 RT7_AUTHORITY_TYPE,
696 CREATION_DATE,
697 CREATED_BY,
698 LAST_UPDATE_DATE,
702 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
699 LAST_UPDATED_BY,
700 LAST_UPDATE_LOGIN)
701 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
703 '962', -- Authorization code
704 'P', -- RT7 borrowing source
705 'Authority to Borrow from the Public', -- Transaction Type
706 'B', -- RT7 authority type
707 sysdate, -- creation_date
708 FND_GLOBAL.USER_ID, -- created by
709 sysdate, -- last update date
710 FND_GLOBAL.USER_ID, -- last updated by
711 FND_GLOBAL.USER_ID -- last updated login
712 );
713 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
714 RT7_ACCOUNT_ID,
715 RT7_CODE_ID,
716 RT7_BE_FLAG,
717 RT7_USSGL_ACCOUNT,
718 RT7_TRANSACTION_PARTNER,
719 CREATION_DATE,
720 CREATED_BY,
721 LAST_UPDATE_DATE,
722 LAST_UPDATED_BY,
723 LAST_UPDATE_LOGIN)
724 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
725 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
726 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
727 'E', -- Begin/End flag
728 '4042', -- USSGL Account
729 'N', -- Transaction Partner
730 sysdate, -- creation_date
731 FND_GLOBAL.USER_ID, -- created by
732 sysdate, -- last update date
733 FND_GLOBAL.USER_ID, -- last updated by
734 FND_GLOBAL.USER_ID -- last updated login
735 );
736
737 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
738 RT7_ACCOUNT_ID,
739 RT7_CODE_ID,
740 RT7_BE_FLAG,
741 RT7_USSGL_ACCOUNT,
742 RT7_TRANSACTION_PARTNER,
743 CREATION_DATE,
744 CREATED_BY,
745 LAST_UPDATE_DATE,
746 LAST_UPDATED_BY,
747 LAST_UPDATE_LOGIN)
748 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
749 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
750 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
751 'E', -- Begin/End flag
752 '4044', -- USSGL Account
753 'N', -- Transaction Partner
754 sysdate, -- creation_date
755 FND_GLOBAL.USER_ID, -- created by
756 sysdate, -- last update date
757 FND_GLOBAL.USER_ID, -- last updated by
758 FND_GLOBAL.USER_ID -- last updated login
759 );
760
761 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
762 RT7_ACCOUNT_ID,
763 RT7_CODE_ID,
764 RT7_BE_FLAG,
765 RT7_USSGL_ACCOUNT,
766 RT7_TRANSACTION_PARTNER,
767 CREATION_DATE,
768 CREATED_BY,
769 LAST_UPDATE_DATE,
770 LAST_UPDATED_BY,
771 LAST_UPDATE_LOGIN)
772 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
773 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
774 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
775 'E', -- Begin/End flag
776 '4141', -- USSGL Account
777 'N', -- Transaction Partner
778 sysdate, -- creation_date
779 FND_GLOBAL.USER_ID, -- created by
780 sysdate, -- last update date
781 FND_GLOBAL.USER_ID, -- last updated by
782 FND_GLOBAL.USER_ID -- last updated login
783 );
784
785 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
786 RT7_ACCOUNT_ID,
787 RT7_CODE_ID,
788 RT7_BE_FLAG,
789 RT7_USSGL_ACCOUNT,
790 RT7_TRANSACTION_PARTNER,
791 CREATION_DATE,
792 CREATED_BY,
793 LAST_UPDATE_DATE,
794 LAST_UPDATED_BY,
795 LAST_UPDATE_LOGIN)
796 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
797 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
798 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
799 'E', -- Begin/End flag
800 '4142', -- USSGL Account
801 'N', -- Transaction Partner
802 sysdate, -- creation_date
803 FND_GLOBAL.USER_ID, -- created by
804 sysdate, -- last update date
805 FND_GLOBAL.USER_ID, -- last updated by
806 FND_GLOBAL.USER_ID -- last updated login
807 );
808
809 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
810 RT7_ACCOUNT_ID,
811 RT7_CODE_ID,
812 RT7_BE_FLAG,
813 RT7_USSGL_ACCOUNT,
814 RT7_TRANSACTION_PARTNER,
815 CREATION_DATE,
816 CREATED_BY,
817 LAST_UPDATE_DATE,
818 LAST_UPDATED_BY,
819 LAST_UPDATE_LOGIN)
820 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
821 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
822 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
823 'E', -- Begin/End flag
824 '4143', -- USSGL Account
825 'N', -- Transaction Partner
826 sysdate, -- creation_date
827 FND_GLOBAL.USER_ID, -- created by
828 sysdate, -- last update date
829 FND_GLOBAL.USER_ID, -- last updated by
830 FND_GLOBAL.USER_ID -- last updated login
831 );
832
833 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
834 RT7_ACCOUNT_ID,
835 RT7_CODE_ID,
836 RT7_BE_FLAG,
837 RT7_USSGL_ACCOUNT,
838 RT7_TRANSACTION_PARTNER,
839 CREATION_DATE,
840 CREATED_BY,
841 LAST_UPDATE_DATE,
842 LAST_UPDATED_BY,
843 LAST_UPDATE_LOGIN)
844 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
845 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
846 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
847 'E', -- Begin/End flag
848 '4145', -- USSGL Account
849 'N', -- Transaction Partner
850 sysdate, -- creation_date
851 FND_GLOBAL.USER_ID, -- created by
852 sysdate, -- last update date
853 FND_GLOBAL.USER_ID, -- last updated by
854 FND_GLOBAL.USER_ID -- last updated login
858 RT7_ACCOUNT_ID,
855 );
856
857 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
859 RT7_CODE_ID,
860 RT7_BE_FLAG,
861 RT7_USSGL_ACCOUNT,
862 RT7_TRANSACTION_PARTNER,
863 CREATION_DATE,
864 CREATED_BY,
865 LAST_UPDATE_DATE,
866 LAST_UPDATED_BY,
867 LAST_UPDATE_LOGIN)
868 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
869 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
870 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
871 'E', -- Begin/End flag
872 '4148', -- USSGL Account
873 'N', -- Transaction Partner
874 sysdate, -- creation_date
875 FND_GLOBAL.USER_ID, -- created by
876 sysdate, -- last update date
877 FND_GLOBAL.USER_ID, -- last updated by
878 FND_GLOBAL.USER_ID -- last updated login
879 );
880
881 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
882 RT7_ACCOUNT_ID,
883 RT7_CODE_ID,
884 RT7_BE_FLAG,
885 RT7_USSGL_ACCOUNT,
886 RT7_TRANSACTION_PARTNER,
887 CREATION_DATE,
888 CREATED_BY,
889 LAST_UPDATE_DATE,
890 LAST_UPDATED_BY,
891 LAST_UPDATE_LOGIN)
892 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
893 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
894 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
895 'B', -- Begin/End flag
896 '4149', -- USSGL Account
897 'N', -- Transaction Partner
898 sysdate, -- creation_date
899 FND_GLOBAL.USER_ID, -- created by
900 sysdate, -- last update date
901 FND_GLOBAL.USER_ID, -- last updated by
902 FND_GLOBAL.USER_ID -- last updated login
903 );
904
905 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
906 RT7_CODE_ID,
907 RT7_CODE,
908 RT7_BORROWING_SOURCE,
909 RT7_CODE_DESCRIPTION,
910 RT7_AUTHORITY_TYPE,
911 CREATION_DATE,
912 CREATED_BY,
913 LAST_UPDATE_DATE,
914 LAST_UPDATED_BY,
915 LAST_UPDATE_LOGIN)
916 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
917 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
918 '971', -- Authorization code
919 ' ', -- RT7 borrowing source
920 'Investments in Public Debt Securities', -- Transaction Type
921 'O', -- RT7 authority type
922 sysdate, -- creation_date
923 FND_GLOBAL.USER_ID, -- created by
924 sysdate, -- last update date
925 FND_GLOBAL.USER_ID, -- last updated by
926 FND_GLOBAL.USER_ID -- last updated login
927 );
928 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
929 RT7_ACCOUNT_ID,
930 RT7_CODE_ID,
931 RT7_BE_FLAG,
932 RT7_USSGL_ACCOUNT,
933 RT7_TRANSACTION_PARTNER,
934 CREATION_DATE,
935 CREATED_BY,
936 LAST_UPDATE_DATE,
937 LAST_UPDATED_BY,
938 LAST_UPDATE_LOGIN)
939 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
940 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
941 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
942 'E', -- Begin/End flag
943 '1610', -- USSGL Account
944 'N', -- Transaction Partner
945 sysdate, -- creation_date
946 FND_GLOBAL.USER_ID, -- created by
947 sysdate, -- last update date
948 FND_GLOBAL.USER_ID, -- last updated by
949 FND_GLOBAL.USER_ID -- last updated login
950 );
951
952 INSERT INTO FV_FACTS_RT7_CODES (SET_OF_BOOKS_ID,
953 RT7_CODE_ID,
954 RT7_CODE,
955 RT7_BORROWING_SOURCE,
956 RT7_CODE_DESCRIPTION,
957 RT7_AUTHORITY_TYPE,
958 CREATION_DATE,
959 CREATED_BY,
960 LAST_UPDATE_DATE,
961 LAST_UPDATED_BY,
962 LAST_UPDATE_LOGIN)
963 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
964 FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
965 '972', -- Authorization code
966 ' ', -- RT7 borrowing source
967 'Investments in Agency Securities', -- Transaction Type
968 'O', -- RT7 authority type
969 sysdate, -- creation_date
970 FND_GLOBAL.USER_ID, -- created by
971 sysdate, -- last update date
972 FND_GLOBAL.USER_ID, -- last updated by
973 FND_GLOBAL.USER_ID -- last updated login
974 );
975
976 INSERT INTO FV_FACTS_RT7_ACCOUNTS (SET_OF_BOOKS_ID,
977 RT7_ACCOUNT_ID,
978 RT7_CODE_ID,
979 RT7_BE_FLAG,
980 RT7_USSGL_ACCOUNT,
981 RT7_TRANSACTION_PARTNER,
982 CREATION_DATE,
983 CREATED_BY,
984 LAST_UPDATE_DATE,
985 LAST_UPDATED_BY,
986 LAST_UPDATE_LOGIN)
987 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
988 FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
989 FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
990 'E', -- Begin/End flag
991 '1620', -- USSGL Account
992 'F', -- Transaction Partner
993 sysdate, -- creation_date
994 FND_GLOBAL.USER_ID, -- created by
995 sysdate, -- last update date
996 FND_GLOBAL.USER_ID, -- last updated by
997 FND_GLOBAL.USER_ID -- last updated login
998 );
999
1000 end if;
1001
1002 Exception
1003 When Others Then
1004 errbuf := substr(SQLERRM,1,225);
1005 retcode := -1;
1006 END;
1007 End;