[Home] [Help]
PACKAGE BODY: APPS.FVFCATT2
Source
1 PAckage Body FVFCATT2 as
2 /* $Header: FVFCAT2B.pls 115.15 2002/03/06 14:11:43 pkm ship $ */
3
4 Procedure Main (errbuf out varchar2,
5 retcode out varchar2) IS
6 v_count number;
7 v_sob number;
8 v_sob_name Varchar2(100);
9 begin
10 -- Verify that the table is not already seeded for an specific set_of_books
11
12 v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
13 v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
14
15 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
16 SGL_ATTRIBUTES_ID,
17 FACTS_ACCT_NUMBER,
18 USSGL_ACCT_NUMBER,
19 BALANCE_TYPE,
20 AUTHORITY_TYPE,
21 DEFINITE_INDEFINITE_FLAG,
22 LEGISLATIVE_INDICATOR,
23 PUBLIC_LAW_CODE,
24 APPORTIONMENT_CATEGORY,
25 REIMBURSEABLE_FLAG,
26 AVAILABILITY_TIME,
27 TRANSACTION_PARTNER,
28 BORROWING_SOURCE,
29 BEA_CATEGORY,
30 DEFICIENCY_FLAG,
31 FUNCTION_FLAG,
32 GOVT_NON_GOVT,
33 EXCH_NON_EXCH,
34 CUST_NON_CUST,
35 BUDGET_SUBFUNCTION,
36 ADVANCE_FLAG,
37 TRANSFER_FLAG,
38 CREATION_DATE,
39 CREATED_BY,
40 LAST_UPDATE_DATE,
41 LAST_UPDATED_BY,
42 LAST_UPDATE_LOGIN)
43 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
44 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
45 '2990', -- facct account number
46 '2990', -- ussgl account number
47 'E', -- balance type
48 'N', -- authority type
49 'N', -- definie indefinite flag
50 'N', -- legislative indicator
51 'N', -- public law code
52 'N', -- apportionmnet category
53 'N', -- reimburseable flag
54 'N', -- availability time
55 'N', -- transaction partner
56 'N', -- borrowing source
57 'N', -- bea category
58 'N', -- deficiency flag
59 'N', -- function flag
60 'Y', -- govt not govt
61 'N', -- exch non exch flag
62 'N', -- cust non cust
63 'N', -- budget subfunction
64 'N', -- advance flag
65 'N', -- transfer flag
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_ATTRIBUTES (SET_OF_BOOKS_ID,
73 SGL_ATTRIBUTES_ID,
74 FACTS_ACCT_NUMBER,
75 USSGL_ACCT_NUMBER,
76 BALANCE_TYPE,
77 AUTHORITY_TYPE,
78 DEFINITE_INDEFINITE_FLAG,
79 LEGISLATIVE_INDICATOR,
80 PUBLIC_LAW_CODE,
81 APPORTIONMENT_CATEGORY,
82 REIMBURSEABLE_FLAG,
83 AVAILABILITY_TIME,
84 TRANSACTION_PARTNER,
85 BORROWING_SOURCE,
86 BEA_CATEGORY,
87 DEFICIENCY_FLAG,
88 FUNCTION_FLAG,
89 GOVT_NON_GOVT,
90 EXCH_NON_EXCH,
91 CUST_NON_CUST,
92 BUDGET_SUBFUNCTION,
93 ADVANCE_FLAG,
94 TRANSFER_FLAG,
95 CREATION_DATE,
96 CREATED_BY,
97 LAST_UPDATE_DATE,
98 LAST_UPDATED_BY,
99 LAST_UPDATE_LOGIN)
100 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
101 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
102 '2995', -- facct account number
103 '2995', -- ussgl account number
104 'E', -- balance type
105 'N', -- authority type
106 'N', -- definie indefinite flag
107 'N', -- legislative indicator
108 'N', -- public law code
109 'N', -- apportionmnet category
110 'N', -- reimburseable flag
111 'N', -- availability time
112 'N', -- transaction partner
113 'N', -- borrowing source
114 'N', -- bea category
115 'N', -- deficiency flag
116 'N', -- function flag
117 'Y', -- govt not govt
118 'N', -- exch non exch flag
119 'N', -- cust non cust
120 'N', -- budget subfunction
121 'N', -- advance flag
122 'N', -- transfer flag
123 sysdate, -- creation_date
124 FND_GLOBAL.USER_ID, -- created by
125 sysdate, -- last update date
126 FND_GLOBAL.USER_ID, -- last updated by
127 FND_GLOBAL.USER_ID -- last updated login
128 );
129 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
130 SGL_ATTRIBUTES_ID,
131 FACTS_ACCT_NUMBER,
132 USSGL_ACCT_NUMBER,
133 BALANCE_TYPE,
134 AUTHORITY_TYPE,
135 DEFINITE_INDEFINITE_FLAG,
136 LEGISLATIVE_INDICATOR,
137 PUBLIC_LAW_CODE,
138 APPORTIONMENT_CATEGORY,
139 REIMBURSEABLE_FLAG,
140 AVAILABILITY_TIME,
141 TRANSACTION_PARTNER,
142 BORROWING_SOURCE,
143 BEA_CATEGORY,
144 DEFICIENCY_FLAG,
145 FUNCTION_FLAG,
146 GOVT_NON_GOVT,
147 EXCH_NON_EXCH,
148 CUST_NON_CUST,
149 BUDGET_SUBFUNCTION,
150 ADVANCE_FLAG,
151 TRANSFER_FLAG,
152 CREATION_DATE,
153 CREATED_BY,
154 LAST_UPDATE_DATE,
155 LAST_UPDATED_BY,
156 LAST_UPDATE_LOGIN)
157 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
158 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
159 '3100', -- facct account number
160 '3100', -- ussgl account number
161 'E', -- balance type
162 'N', -- authority type
163 'N', -- definie indefinite flag
164 'N', -- legislative indicator
165 'N', -- public law code
166 'N', -- apportionmnet category
167 'N', -- reimburseable flag
168 'N', -- availability time
169 'N', -- transaction partner
170 'N', -- borrowing source
171 'N', -- bea category
172 'N', -- deficiency flag
173 'N', -- function flag
174 'X', -- govt not govt
175 'N', -- exch non exch flag
176 'N', -- cust non cust
177 'N', -- budget subfunction
178 'N', -- advance flag
179 'N', -- transfer flag
180 sysdate, -- creation_date
181 FND_GLOBAL.USER_ID, -- created by
182 sysdate, -- last update date
183 FND_GLOBAL.USER_ID, -- last updated by
184 FND_GLOBAL.USER_ID -- last updated login
185 );
186 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
187 SGL_ATTRIBUTES_ID,
188 FACTS_ACCT_NUMBER,
189 USSGL_ACCT_NUMBER,
190 BALANCE_TYPE,
191 AUTHORITY_TYPE,
192 DEFINITE_INDEFINITE_FLAG,
193 LEGISLATIVE_INDICATOR,
194 PUBLIC_LAW_CODE,
195 APPORTIONMENT_CATEGORY,
196 REIMBURSEABLE_FLAG,
197 AVAILABILITY_TIME,
198 TRANSACTION_PARTNER,
199 BORROWING_SOURCE,
200 BEA_CATEGORY,
201 DEFICIENCY_FLAG,
202 FUNCTION_FLAG,
203 GOVT_NON_GOVT,
204 EXCH_NON_EXCH,
205 CUST_NON_CUST,
206 BUDGET_SUBFUNCTION,
207 ADVANCE_FLAG,
208 TRANSFER_FLAG,
209 CREATION_DATE,
210 CREATED_BY,
211 LAST_UPDATE_DATE,
212 LAST_UPDATED_BY,
213 LAST_UPDATE_LOGIN)
214 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
215 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
216 '3105', -- facct account number
217 '3105', -- ussgl account number
218 'E', -- balance type
219 'N', -- authority type
220 'N', -- definie indefinite flag
221 'N', -- legislative indicator
222 'N', -- public law code
223 'N', -- apportionmnet category
224 'N', -- reimburseable flag
225 'N', -- availability time
226 'N', -- transaction partner
227 'N', -- borrowing source
228 'N', -- bea category
229 'N', -- deficiency flag
230 'N', -- function flag
231 'X', -- govt not govt
232 'N', -- exch non exch flag
233 'N', -- cust non cust
234 'N', -- budget subfunction
235 'N', -- advance flag
236 'N', -- transfer flag
237 sysdate, -- creation_date
238 FND_GLOBAL.USER_ID, -- created by
239 sysdate, -- last update date
240 FND_GLOBAL.USER_ID, -- last updated by
241 FND_GLOBAL.USER_ID -- last updated login
242 );
243 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
244 SGL_ATTRIBUTES_ID,
245 FACTS_ACCT_NUMBER,
246 USSGL_ACCT_NUMBER,
247 BALANCE_TYPE,
248 AUTHORITY_TYPE,
249 DEFINITE_INDEFINITE_FLAG,
250 LEGISLATIVE_INDICATOR,
251 PUBLIC_LAW_CODE,
252 APPORTIONMENT_CATEGORY,
253 REIMBURSEABLE_FLAG,
254 AVAILABILITY_TIME,
255 TRANSACTION_PARTNER,
256 BORROWING_SOURCE,
257 BEA_CATEGORY,
258 DEFICIENCY_FLAG,
259 FUNCTION_FLAG,
260 GOVT_NON_GOVT,
261 EXCH_NON_EXCH,
262 CUST_NON_CUST,
263 BUDGET_SUBFUNCTION,
264 ADVANCE_FLAG,
265 TRANSFER_FLAG,
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_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
273 '3310', -- facct account number
274 '3310', -- ussgl account number
275 'E', -- balance type
276 'N', -- authority type
277 'N', -- definie indefinite flag
278 'N', -- legislative indicator
279 'N', -- public law code
280 'N', -- apportionmnet category
281 'N', -- reimburseable flag
282 'N', -- availability time
283 'N', -- transaction partner
284 'N', -- borrowing source
285 'N', -- bea category
286 'N', -- deficiency flag
287 'N', -- function flag
288 'X', -- govt not govt
289 'N', -- exch non exch flag
290 'N', -- cust non cust
291 'N', -- budget subfunction
292 'N', -- advance flag
293 'N', -- transfer flag
294 sysdate, -- creation_date
295 FND_GLOBAL.USER_ID, -- created by
296 sysdate, -- last update date
297 FND_GLOBAL.USER_ID, -- last updated by
298 FND_GLOBAL.USER_ID -- last updated login
299 );
300 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
301 SGL_ATTRIBUTES_ID,
302 FACTS_ACCT_NUMBER,
303 USSGL_ACCT_NUMBER,
304 BALANCE_TYPE,
305 AUTHORITY_TYPE,
306 DEFINITE_INDEFINITE_FLAG,
307 LEGISLATIVE_INDICATOR,
308 PUBLIC_LAW_CODE,
309 APPORTIONMENT_CATEGORY,
310 REIMBURSEABLE_FLAG,
311 AVAILABILITY_TIME,
312 TRANSACTION_PARTNER,
313 BORROWING_SOURCE,
314 BEA_CATEGORY,
315 DEFICIENCY_FLAG,
316 FUNCTION_FLAG,
317 GOVT_NON_GOVT,
318 EXCH_NON_EXCH,
319 CUST_NON_CUST,
320 BUDGET_SUBFUNCTION,
321 ADVANCE_FLAG,
322 TRANSFER_FLAG,
323 CREATION_DATE,
324 CREATED_BY,
325 LAST_UPDATE_DATE,
326 LAST_UPDATED_BY,
327 LAST_UPDATE_LOGIN)
328 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
329 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
330 '5100', -- facct account number
331 '5100', -- ussgl account number
332 'E', -- balance type
333 'N', -- authority type
334 'N', -- definie indefinite flag
335 'N', -- legislative indicator
336 'N', -- public law code
337 'N', -- apportionmnet category
338 'N', -- reimburseable flag
339 'N', -- availability time
340 'N', -- transaction partner
341 'N', -- borrowing source
342 'N', -- bea category
343 'N', -- deficiency flag
344 'N', -- function flag
345 'Y', -- govt not govt
346 'X', -- exch non exch flag
347 'N', -- cust non cust
348 'Y', -- budget subfunction
349 'N', -- advance flag
350 'N', -- transfer flag
351 sysdate, -- creation_date
352 FND_GLOBAL.USER_ID, -- created by
353 sysdate, -- last update date
354 FND_GLOBAL.USER_ID, -- last updated by
355 FND_GLOBAL.USER_ID -- last updated login
356 );
357 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
358 SGL_ATTRIBUTES_ID,
359 FACTS_ACCT_NUMBER,
360 USSGL_ACCT_NUMBER,
361 BALANCE_TYPE,
362 AUTHORITY_TYPE,
363 DEFINITE_INDEFINITE_FLAG,
364 LEGISLATIVE_INDICATOR,
365 PUBLIC_LAW_CODE,
366 APPORTIONMENT_CATEGORY,
367 REIMBURSEABLE_FLAG,
368 AVAILABILITY_TIME,
369 TRANSACTION_PARTNER,
370 BORROWING_SOURCE,
371 BEA_CATEGORY,
372 DEFICIENCY_FLAG,
373 FUNCTION_FLAG,
374 GOVT_NON_GOVT,
375 EXCH_NON_EXCH,
376 CUST_NON_CUST,
377 BUDGET_SUBFUNCTION,
378 ADVANCE_FLAG,
379 TRANSFER_FLAG,
380 CREATION_DATE,
381 CREATED_BY,
382 LAST_UPDATE_DATE,
383 LAST_UPDATED_BY,
384 LAST_UPDATE_LOGIN)
385 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
389 'E', -- balance type
386 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
387 '5109', -- facct account number
388 '5109', -- ussgl account number
390 'N', -- authority type
391 'N', -- definie indefinite flag
392 'N', -- legislative indicator
393 'N', -- public law code
394 'N', -- apportionmnet category
395 'N', -- reimburseable flag
396 'N', -- availability time
397 'N', -- transaction partner
398 'N', -- borrowing source
399 'N', -- bea category
400 'N', -- deficiency flag
401 'N', -- function flag
402 'Y', -- govt not govt
403 'X', -- exch non exch flag
404 'N', -- cust non cust
405 'Y', -- budget subfunction
406 'N', -- advance flag
407 'N', -- transfer flag
408 sysdate, -- creation_date
409 FND_GLOBAL.USER_ID, -- created by
410 sysdate, -- last update date
411 FND_GLOBAL.USER_ID, -- last updated by
412 FND_GLOBAL.USER_ID -- last updated login
413 );
414 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
415 SGL_ATTRIBUTES_ID,
416 FACTS_ACCT_NUMBER,
417 USSGL_ACCT_NUMBER,
418 BALANCE_TYPE,
419 AUTHORITY_TYPE,
420 DEFINITE_INDEFINITE_FLAG,
421 LEGISLATIVE_INDICATOR,
422 PUBLIC_LAW_CODE,
423 APPORTIONMENT_CATEGORY,
424 REIMBURSEABLE_FLAG,
425 AVAILABILITY_TIME,
426 TRANSACTION_PARTNER,
427 BORROWING_SOURCE,
428 BEA_CATEGORY,
429 DEFICIENCY_FLAG,
430 FUNCTION_FLAG,
431 GOVT_NON_GOVT,
432 EXCH_NON_EXCH,
433 CUST_NON_CUST,
434 BUDGET_SUBFUNCTION,
435 ADVANCE_FLAG,
436 TRANSFER_FLAG,
437 CREATION_DATE,
438 CREATED_BY,
439 LAST_UPDATE_DATE,
440 LAST_UPDATED_BY,
441 LAST_UPDATE_LOGIN)
442 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
443 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
444 '5200', -- facct account number
445 '5200', -- ussgl account number
446 'E', -- balance type
447 'N', -- authority type
448 'N', -- definie indefinite flag
449 'N', -- legislative indicator
450 'N', -- public law code
451 'N', -- apportionmnet category
452 'N', -- reimburseable flag
453 'N', -- availability time
454 'N', -- transaction partner
455 'N', -- borrowing source
456 'N', -- bea category
457 'N', -- deficiency flag
458 'N', -- function flag
459 'Y', -- govt not govt
460 'X', -- exch non exch flag
461 'N', -- cust non cust
462 'Y', -- budget subfunction
463 'N', -- advance flag
464 'N', -- transfer flag
465 sysdate, -- creation_date
466 FND_GLOBAL.USER_ID, -- created by
467 sysdate, -- last update date
468 FND_GLOBAL.USER_ID, -- last updated by
469 FND_GLOBAL.USER_ID -- last updated login
470 );
471 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
472 SGL_ATTRIBUTES_ID,
473 FACTS_ACCT_NUMBER,
474 USSGL_ACCT_NUMBER,
475 BALANCE_TYPE,
476 AUTHORITY_TYPE,
477 DEFINITE_INDEFINITE_FLAG,
478 LEGISLATIVE_INDICATOR,
479 PUBLIC_LAW_CODE,
480 APPORTIONMENT_CATEGORY,
481 REIMBURSEABLE_FLAG,
482 AVAILABILITY_TIME,
483 TRANSACTION_PARTNER,
484 BORROWING_SOURCE,
485 BEA_CATEGORY,
486 DEFICIENCY_FLAG,
487 FUNCTION_FLAG,
488 GOVT_NON_GOVT,
489 EXCH_NON_EXCH,
490 CUST_NON_CUST,
491 BUDGET_SUBFUNCTION,
492 ADVANCE_FLAG,
493 TRANSFER_FLAG,
494 CREATION_DATE,
495 CREATED_BY,
496 LAST_UPDATE_DATE,
497 LAST_UPDATED_BY,
498 LAST_UPDATE_LOGIN)
499 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
500 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
501 '5209', -- facct account number
502 '5209', -- ussgl account number
503 'E', -- balance type
504 'N', -- authority type
505 'N', -- definie indefinite flag
506 'N', -- legislative indicator
507 'N', -- public law code
508 'N', -- apportionmnet category
509 'N', -- reimburseable flag
510 'N', -- availability time
511 'N', -- transaction partner
512 'N', -- borrowing source
513 'N', -- bea category
514 'N', -- deficiency flag
515 'N', -- function flag
516 'Y', -- govt not govt
517 'X', -- exch non exch flag
518 'N', -- cust non cust
519 'Y', -- budget subfunction
520 'N', -- advance flag
521 'N', -- transfer flag
522 sysdate, -- creation_date
523 FND_GLOBAL.USER_ID, -- created by
524 sysdate, -- last update date
525 FND_GLOBAL.USER_ID, -- last updated by
526 FND_GLOBAL.USER_ID -- last updated login
527 );
528 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
529 SGL_ATTRIBUTES_ID,
530 FACTS_ACCT_NUMBER,
531 USSGL_ACCT_NUMBER,
532 BALANCE_TYPE,
533 AUTHORITY_TYPE,
534 DEFINITE_INDEFINITE_FLAG,
535 LEGISLATIVE_INDICATOR,
536 PUBLIC_LAW_CODE,
537 APPORTIONMENT_CATEGORY,
538 REIMBURSEABLE_FLAG,
539 AVAILABILITY_TIME,
540 TRANSACTION_PARTNER,
541 BORROWING_SOURCE,
542 BEA_CATEGORY,
543 DEFICIENCY_FLAG,
544 FUNCTION_FLAG,
545 GOVT_NON_GOVT,
546 EXCH_NON_EXCH,
547 CUST_NON_CUST,
548 BUDGET_SUBFUNCTION,
549 ADVANCE_FLAG,
553 LAST_UPDATE_DATE,
550 TRANSFER_FLAG,
551 CREATION_DATE,
552 CREATED_BY,
554 LAST_UPDATED_BY,
555 LAST_UPDATE_LOGIN)
556 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
557 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
558 '5310', -- facct account number
559 '5310', -- ussgl account number
560 'E', -- balance type
561 'N', -- authority type
562 'N', -- definie indefinite flag
563 'N', -- legislative indicator
564 'N', -- public law code
565 'N', -- apportionmnet category
566 'N', -- reimburseable flag
567 'N', -- availability time
568 'N', -- transaction partner
569 'N', -- borrowing source
570 'N', -- bea category
571 'N', -- deficiency flag
572 'N', -- function flag
573 'Y', -- govt not govt
574 'Y', -- exch non exch flag
575 'Y', -- cust non cust
576 'Y', -- budget subfunction
577 'N', -- advance flag
578 'N', -- transfer flag
579 sysdate, -- creation_date
580 FND_GLOBAL.USER_ID, -- created by
581 sysdate, -- last update date
582 FND_GLOBAL.USER_ID, -- last updated by
583 FND_GLOBAL.USER_ID -- last updated login
584 );
585 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
586 SGL_ATTRIBUTES_ID,
587 FACTS_ACCT_NUMBER,
588 USSGL_ACCT_NUMBER,
589 BALANCE_TYPE,
590 AUTHORITY_TYPE,
591 DEFINITE_INDEFINITE_FLAG,
592 LEGISLATIVE_INDICATOR,
593 PUBLIC_LAW_CODE,
594 APPORTIONMENT_CATEGORY,
595 REIMBURSEABLE_FLAG,
596 AVAILABILITY_TIME,
597 TRANSACTION_PARTNER,
598 BORROWING_SOURCE,
599 BEA_CATEGORY,
600 DEFICIENCY_FLAG,
601 FUNCTION_FLAG,
602 GOVT_NON_GOVT,
603 EXCH_NON_EXCH,
604 CUST_NON_CUST,
605 BUDGET_SUBFUNCTION,
606 ADVANCE_FLAG,
607 TRANSFER_FLAG,
608 CREATION_DATE,
609 CREATED_BY,
610 LAST_UPDATE_DATE,
611 LAST_UPDATED_BY,
612 LAST_UPDATE_LOGIN)
613 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
614 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
615 '5319', -- facct account number
616 '5319', -- ussgl account number
617 'E', -- balance type
618 'N', -- authority type
619 'N', -- definie indefinite flag
620 'N', -- legislative indicator
621 'N', -- public law code
622 'N', -- apportionmnet category
623 'N', -- reimburseable flag
624 'N', -- availability time
625 'N', -- transaction partner
626 'N', -- borrowing source
627 'N', -- bea category
628 'N', -- deficiency flag
629 'N', -- function flag
630 'Y', -- govt not govt
631 'Y', -- exch non exch flag
632 'Y', -- cust non cust
633 'Y', -- budget subfunction
634 'N', -- advance flag
635 'N', -- transfer flag
636 sysdate, -- creation_date
637 FND_GLOBAL.USER_ID, -- created by
638 sysdate, -- last update date
639 FND_GLOBAL.USER_ID, -- last updated by
640 FND_GLOBAL.USER_ID -- last updated login
641 );
642 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
643 SGL_ATTRIBUTES_ID,
644 FACTS_ACCT_NUMBER,
645 USSGL_ACCT_NUMBER,
646 BALANCE_TYPE,
647 AUTHORITY_TYPE,
648 DEFINITE_INDEFINITE_FLAG,
649 LEGISLATIVE_INDICATOR,
650 PUBLIC_LAW_CODE,
651 APPORTIONMENT_CATEGORY,
652 REIMBURSEABLE_FLAG,
653 AVAILABILITY_TIME,
654 TRANSACTION_PARTNER,
655 BORROWING_SOURCE,
656 BEA_CATEGORY,
657 DEFICIENCY_FLAG,
658 FUNCTION_FLAG,
659 GOVT_NON_GOVT,
660 EXCH_NON_EXCH,
661 CUST_NON_CUST,
662 BUDGET_SUBFUNCTION,
663 ADVANCE_FLAG,
664 TRANSFER_FLAG,
665 CREATION_DATE,
666 CREATED_BY,
667 LAST_UPDATE_DATE,
668 LAST_UPDATED_BY,
669 LAST_UPDATE_LOGIN)
670 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
671 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
672 '5320', -- facct account number
673 '5320', -- ussgl account number
674 'E', -- balance type
675 'N', -- authority type
676 'N', -- definie indefinite flag
677 'N', -- legislative indicator
678 'N', -- public law code
679 'N', -- apportionmnet category
680 'N', -- reimburseable flag
681 'N', -- availability time
682 'N', -- transaction partner
683 'N', -- borrowing source
684 'N', -- bea category
685 'N', -- deficiency flag
686 'N', -- function flag
687 'Y', -- govt not govt
688 'Y', -- exch non exch flag
689 'Y', -- cust non cust
690 'Y', -- budget subfunction
691 'N', -- advance flag
692 'N', -- transfer flag
693 sysdate, -- creation_date
694 FND_GLOBAL.USER_ID, -- created by
695 sysdate, -- last update date
696 FND_GLOBAL.USER_ID, -- last updated by
697 FND_GLOBAL.USER_ID -- last updated login
698 );
699 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
700 SGL_ATTRIBUTES_ID,
701 FACTS_ACCT_NUMBER,
702 USSGL_ACCT_NUMBER,
703 BALANCE_TYPE,
704 AUTHORITY_TYPE,
705 DEFINITE_INDEFINITE_FLAG,
706 LEGISLATIVE_INDICATOR,
707 PUBLIC_LAW_CODE,
708 APPORTIONMENT_CATEGORY,
709 REIMBURSEABLE_FLAG,
710 AVAILABILITY_TIME,
711 TRANSACTION_PARTNER,
712 BORROWING_SOURCE,
716 GOVT_NON_GOVT,
713 BEA_CATEGORY,
714 DEFICIENCY_FLAG,
715 FUNCTION_FLAG,
717 EXCH_NON_EXCH,
718 CUST_NON_CUST,
719 BUDGET_SUBFUNCTION,
720 ADVANCE_FLAG,
721 TRANSFER_FLAG,
722 CREATION_DATE,
723 CREATED_BY,
724 LAST_UPDATE_DATE,
725 LAST_UPDATED_BY,
726 LAST_UPDATE_LOGIN)
727 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
728 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
729 '5329', -- facct account number
730 '5329', -- ussgl account number
731 'E', -- balance type
732 'N', -- authority type
733 'N', -- definie indefinite flag
734 'N', -- legislative indicator
735 'N', -- public law code
736 'N', -- apportionmnet category
737 'N', -- reimburseable flag
738 'N', -- availability time
739 'N', -- transaction partner
740 'N', -- borrowing source
741 'N', -- bea category
742 'N', -- deficiency flag
743 'N', -- function flag
744 'Y', -- govt not govt
745 'Y', -- exch non exch flag
746 'Y', -- cust non cust
747 'Y', -- budget subfunction
748 'N', -- advance flag
749 'N', -- transfer flag
750 sysdate, -- creation_date
751 FND_GLOBAL.USER_ID, -- created by
752 sysdate, -- last update date
753 FND_GLOBAL.USER_ID, -- last updated by
754 FND_GLOBAL.USER_ID -- last updated login
755 );
756 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
757 SGL_ATTRIBUTES_ID,
758 FACTS_ACCT_NUMBER,
759 USSGL_ACCT_NUMBER,
760 BALANCE_TYPE,
761 AUTHORITY_TYPE,
762 DEFINITE_INDEFINITE_FLAG,
763 LEGISLATIVE_INDICATOR,
764 PUBLIC_LAW_CODE,
765 APPORTIONMENT_CATEGORY,
766 REIMBURSEABLE_FLAG,
767 AVAILABILITY_TIME,
768 TRANSACTION_PARTNER,
769 BORROWING_SOURCE,
770 BEA_CATEGORY,
771 DEFICIENCY_FLAG,
772 FUNCTION_FLAG,
773 GOVT_NON_GOVT,
774 EXCH_NON_EXCH,
775 CUST_NON_CUST,
776 BUDGET_SUBFUNCTION,
777 ADVANCE_FLAG,
778 TRANSFER_FLAG,
779 CREATION_DATE,
780 CREATED_BY,
781 LAST_UPDATE_DATE,
782 LAST_UPDATED_BY,
783 LAST_UPDATE_LOGIN)
784 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
785 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
786 '5400', -- facct account number
787 '5400', -- ussgl account number
788 'E', -- balance type
789 'N', -- authority type
790 'N', -- definie indefinite flag
791 'N', -- legislative indicator
792 'N', -- public law code
793 'N', -- apportionmnet category
794 'N', -- reimburseable flag
795 'N', -- availability time
796 'N', -- transaction partner
797 'N', -- borrowing source
798 'N', -- bea category
799 'N', -- deficiency flag
800 'N', -- function flag
801 'Y', -- govt not govt
802 'Y', -- exch non exch flag
803 'N', -- cust non cust
804 'Y', -- budget subfunction
805 'N', -- advance flag
806 'N', -- transfer flag
807 sysdate, -- creation_date
808 FND_GLOBAL.USER_ID, -- created by
809 sysdate, -- last update date
810 FND_GLOBAL.USER_ID, -- last updated by
811 FND_GLOBAL.USER_ID -- last updated login
812 );
813 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
814 SGL_ATTRIBUTES_ID,
815 FACTS_ACCT_NUMBER,
816 USSGL_ACCT_NUMBER,
817 BALANCE_TYPE,
818 AUTHORITY_TYPE,
819 DEFINITE_INDEFINITE_FLAG,
820 LEGISLATIVE_INDICATOR,
821 PUBLIC_LAW_CODE,
822 APPORTIONMENT_CATEGORY,
823 REIMBURSEABLE_FLAG,
824 AVAILABILITY_TIME,
825 TRANSACTION_PARTNER,
826 BORROWING_SOURCE,
827 BEA_CATEGORY,
828 DEFICIENCY_FLAG,
829 FUNCTION_FLAG,
830 GOVT_NON_GOVT,
831 EXCH_NON_EXCH,
832 CUST_NON_CUST,
833 BUDGET_SUBFUNCTION,
834 ADVANCE_FLAG,
835 TRANSFER_FLAG,
836 CREATION_DATE,
837 CREATED_BY,
838 LAST_UPDATE_DATE,
839 LAST_UPDATED_BY,
840 LAST_UPDATE_LOGIN)
841 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
842 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
843 '5409', -- facct account number
844 '5409', -- ussgl account number
845 'E', -- balance type
846 'N', -- authority type
847 'N', -- definie indefinite flag
848 'N', -- legislative indicator
849 'N', -- public law code
850 'N', -- apportionmnet category
851 'N', -- reimburseable flag
852 'N', -- availability time
853 'N', -- transaction partner
854 'N', -- borrowing source
855 'N', -- bea category
856 'N', -- deficiency flag
857 'N', -- function flag
858 'Y', -- govt not govt
859 'Y', -- exch non exch flag
860 'N', -- cust non cust
861 'Y', -- budget subfunction
862 'N', -- advance flag
863 'N', -- transfer flag
864 sysdate, -- creation_date
865 FND_GLOBAL.USER_ID, -- created by
866 sysdate, -- last update date
867 FND_GLOBAL.USER_ID, -- last updated by
868 FND_GLOBAL.USER_ID -- last updated login
869 );
870 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
871 SGL_ATTRIBUTES_ID,
872 FACTS_ACCT_NUMBER,
873 USSGL_ACCT_NUMBER,
874 BALANCE_TYPE,
875 AUTHORITY_TYPE,
876 DEFINITE_INDEFINITE_FLAG,
880 REIMBURSEABLE_FLAG,
877 LEGISLATIVE_INDICATOR,
878 PUBLIC_LAW_CODE,
879 APPORTIONMENT_CATEGORY,
881 AVAILABILITY_TIME,
882 TRANSACTION_PARTNER,
883 BORROWING_SOURCE,
884 BEA_CATEGORY,
885 DEFICIENCY_FLAG,
886 FUNCTION_FLAG,
887 GOVT_NON_GOVT,
888 EXCH_NON_EXCH,
889 CUST_NON_CUST,
890 BUDGET_SUBFUNCTION,
891 ADVANCE_FLAG,
892 TRANSFER_FLAG,
893 CREATION_DATE,
894 CREATED_BY,
895 LAST_UPDATE_DATE,
896 LAST_UPDATED_BY,
897 LAST_UPDATE_LOGIN)
898 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
899 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
900 '5500', -- facct account number
901 '5500', -- ussgl account number
902 'E', -- balance type
903 'N', -- authority type
904 'N', -- definie indefinite flag
905 'N', -- legislative indicator
906 'N', -- public law code
907 'N', -- apportionmnet category
908 'N', -- reimburseable flag
909 'N', -- availability time
910 'N', -- transaction partner
911 'N', -- borrowing source
912 'N', -- bea category
913 'N', -- deficiency flag
914 'N', -- function flag
915 'Y', -- govt not govt
916 'X', -- exch non exch flag
917 'N', -- cust non cust
918 'Y', -- budget subfunction
919 'N', -- advance flag
920 'N', -- transfer flag
921 sysdate, -- creation_date
922 FND_GLOBAL.USER_ID, -- created by
923 sysdate, -- last update date
924 FND_GLOBAL.USER_ID, -- last updated by
925 FND_GLOBAL.USER_ID -- last updated login
926 );
927 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
928 SGL_ATTRIBUTES_ID,
929 FACTS_ACCT_NUMBER,
930 USSGL_ACCT_NUMBER,
931 BALANCE_TYPE,
932 AUTHORITY_TYPE,
933 DEFINITE_INDEFINITE_FLAG,
934 LEGISLATIVE_INDICATOR,
935 PUBLIC_LAW_CODE,
936 APPORTIONMENT_CATEGORY,
937 REIMBURSEABLE_FLAG,
938 AVAILABILITY_TIME,
939 TRANSACTION_PARTNER,
940 BORROWING_SOURCE,
941 BEA_CATEGORY,
942 DEFICIENCY_FLAG,
943 FUNCTION_FLAG,
944 GOVT_NON_GOVT,
945 EXCH_NON_EXCH,
946 CUST_NON_CUST,
947 BUDGET_SUBFUNCTION,
948 ADVANCE_FLAG,
949 TRANSFER_FLAG,
950 CREATION_DATE,
951 CREATED_BY,
952 LAST_UPDATE_DATE,
953 LAST_UPDATED_BY,
954 LAST_UPDATE_LOGIN)
955 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
956 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
957 '5509', -- facct account number
958 '5509', -- ussgl account number
959 'E', -- balance type
960 'N', -- authority type
961 'N', -- definie indefinite flag
962 'N', -- legislative indicator
963 'N', -- public law code
964 'N', -- apportionmnet category
965 'N', -- reimburseable flag
966 'N', -- availability time
967 'N', -- transaction partner
968 'N', -- borrowing source
969 'N', -- bea category
970 'N', -- deficiency flag
971 'N', -- function flag
972 'Y', -- govt not govt
973 'X', -- exch non exch flag
974 'N', -- cust non cust
975 'Y', -- budget subfunction
976 'N', -- advance flag
977 'N', -- transfer flag
978 sysdate, -- creation_date
979 FND_GLOBAL.USER_ID, -- created by
980 sysdate, -- last update date
981 FND_GLOBAL.USER_ID, -- last updated by
982 FND_GLOBAL.USER_ID -- last updated login
983 );
984 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
985 SGL_ATTRIBUTES_ID,
986 FACTS_ACCT_NUMBER,
987 USSGL_ACCT_NUMBER,
988 BALANCE_TYPE,
989 AUTHORITY_TYPE,
990 DEFINITE_INDEFINITE_FLAG,
991 LEGISLATIVE_INDICATOR,
992 PUBLIC_LAW_CODE,
993 APPORTIONMENT_CATEGORY,
994 REIMBURSEABLE_FLAG,
995 AVAILABILITY_TIME,
996 TRANSACTION_PARTNER,
997 BORROWING_SOURCE,
998 BEA_CATEGORY,
999 DEFICIENCY_FLAG,
1000 FUNCTION_FLAG,
1001 GOVT_NON_GOVT,
1002 EXCH_NON_EXCH,
1003 CUST_NON_CUST,
1004 BUDGET_SUBFUNCTION,
1005 ADVANCE_FLAG,
1006 TRANSFER_FLAG,
1007 CREATION_DATE,
1008 CREATED_BY,
1009 LAST_UPDATE_DATE,
1010 LAST_UPDATED_BY,
1011 LAST_UPDATE_LOGIN)
1012 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1013 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1014 '5600', -- facct account number
1015 '5600', -- ussgl account number
1016 'E', -- balance type
1017 'N', -- authority type
1018 'N', -- definie indefinite flag
1019 'N', -- legislative indicator
1020 'N', -- public law code
1021 'N', -- apportionmnet category
1022 'N', -- reimburseable flag
1023 'N', -- availability time
1024 'N', -- transaction partner
1025 'N', -- borrowing source
1026 'N', -- bea category
1027 'N', -- deficiency flag
1028 'N', -- function flag
1029 'N', -- govt not govt
1030 'T', -- exch non exch flag
1031 'N', -- cust non cust
1032 'N', -- budget subfunction
1033 'N', -- advance flag
1034 'N', -- transfer flag
1035 sysdate, -- creation_date
1036 FND_GLOBAL.USER_ID, -- created by
1037 sysdate, -- last update date
1038 FND_GLOBAL.USER_ID, -- last updated by
1039 FND_GLOBAL.USER_ID -- last updated login
1040 );
1044 USSGL_ACCT_NUMBER,
1041 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1042 SGL_ATTRIBUTES_ID,
1043 FACTS_ACCT_NUMBER,
1045 BALANCE_TYPE,
1046 AUTHORITY_TYPE,
1047 DEFINITE_INDEFINITE_FLAG,
1048 LEGISLATIVE_INDICATOR,
1049 PUBLIC_LAW_CODE,
1050 APPORTIONMENT_CATEGORY,
1051 REIMBURSEABLE_FLAG,
1052 AVAILABILITY_TIME,
1053 TRANSACTION_PARTNER,
1054 BORROWING_SOURCE,
1055 BEA_CATEGORY,
1056 DEFICIENCY_FLAG,
1057 FUNCTION_FLAG,
1058 GOVT_NON_GOVT,
1059 EXCH_NON_EXCH,
1060 CUST_NON_CUST,
1061 BUDGET_SUBFUNCTION,
1062 ADVANCE_FLAG,
1063 TRANSFER_FLAG,
1064 CREATION_DATE,
1065 CREATED_BY,
1066 LAST_UPDATE_DATE,
1067 LAST_UPDATED_BY,
1068 LAST_UPDATE_LOGIN)
1069 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1070 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1071 '5609', -- facct account number
1072 '5609', -- ussgl account number
1073 'E', -- balance type
1074 'N', -- authority type
1075 'N', -- definie indefinite flag
1076 'N', -- legislative indicator
1077 'N', -- public law code
1078 'N', -- apportionmnet category
1079 'N', -- reimburseable flag
1080 'N', -- availability time
1081 'N', -- transaction partner
1082 'N', -- borrowing source
1083 'N', -- bea category
1084 'N', -- deficiency flag
1085 'N', -- function flag
1086 'N', -- govt not govt
1087 'T', -- exch non exch flag
1088 'N', -- cust non cust
1089 'N', -- budget subfunction
1090 'N', -- advance flag
1091 'N', -- transfer flag
1092 sysdate, -- creation_date
1093 FND_GLOBAL.USER_ID, -- created by
1094 sysdate, -- last update date
1095 FND_GLOBAL.USER_ID, -- last updated by
1096 FND_GLOBAL.USER_ID -- last updated login
1097 );
1098 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1099 SGL_ATTRIBUTES_ID,
1100 FACTS_ACCT_NUMBER,
1101 USSGL_ACCT_NUMBER,
1102 BALANCE_TYPE,
1103 AUTHORITY_TYPE,
1104 DEFINITE_INDEFINITE_FLAG,
1105 LEGISLATIVE_INDICATOR,
1106 PUBLIC_LAW_CODE,
1107 APPORTIONMENT_CATEGORY,
1108 REIMBURSEABLE_FLAG,
1109 AVAILABILITY_TIME,
1110 TRANSACTION_PARTNER,
1111 BORROWING_SOURCE,
1112 BEA_CATEGORY,
1113 DEFICIENCY_FLAG,
1114 FUNCTION_FLAG,
1115 GOVT_NON_GOVT,
1116 EXCH_NON_EXCH,
1117 CUST_NON_CUST,
1118 BUDGET_SUBFUNCTION,
1119 ADVANCE_FLAG,
1120 TRANSFER_FLAG,
1121 CREATION_DATE,
1122 CREATED_BY,
1123 LAST_UPDATE_DATE,
1124 LAST_UPDATED_BY,
1125 LAST_UPDATE_LOGIN)
1126 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1127 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1128 '5610', -- facct account number
1129 '5610', -- ussgl account number
1130 'E', -- balance type
1131 'N', -- authority type
1132 'N', -- definie indefinite flag
1133 'N', -- legislative indicator
1134 'N', -- public law code
1135 'N', -- apportionmnet category
1136 'N', -- reimburseable flag
1137 'N', -- availability time
1138 'N', -- transaction partner
1139 'N', -- borrowing source
1140 'N', -- bea category
1141 'N', -- deficiency flag
1142 'N', -- function flag
1143 'N', -- govt not govt
1144 'T', -- exch non exch flag
1145 'N', -- cust non cust
1146 'N', -- budget subfunction
1147 'N', -- advance flag
1148 'N', -- transfer flag
1149 sysdate, -- creation_date
1150 FND_GLOBAL.USER_ID, -- created by
1151 sysdate, -- last update date
1152 FND_GLOBAL.USER_ID, -- last updated by
1153 FND_GLOBAL.USER_ID -- last updated login
1154 );
1155 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1156 SGL_ATTRIBUTES_ID,
1157 FACTS_ACCT_NUMBER,
1158 USSGL_ACCT_NUMBER,
1159 BALANCE_TYPE,
1163 PUBLIC_LAW_CODE,
1160 AUTHORITY_TYPE,
1161 DEFINITE_INDEFINITE_FLAG,
1162 LEGISLATIVE_INDICATOR,
1164 APPORTIONMENT_CATEGORY,
1165 REIMBURSEABLE_FLAG,
1166 AVAILABILITY_TIME,
1167 TRANSACTION_PARTNER,
1168 BORROWING_SOURCE,
1169 BEA_CATEGORY,
1170 DEFICIENCY_FLAG,
1171 FUNCTION_FLAG,
1172 GOVT_NON_GOVT,
1173 EXCH_NON_EXCH,
1174 CUST_NON_CUST,
1175 BUDGET_SUBFUNCTION,
1176 ADVANCE_FLAG,
1177 TRANSFER_FLAG,
1178 CREATION_DATE,
1179 CREATED_BY,
1180 LAST_UPDATE_DATE,
1181 LAST_UPDATED_BY,
1182 LAST_UPDATE_LOGIN)
1183 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1184 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1185 '5619', -- facct account number
1186 '5619', -- ussgl account number
1187 'E', -- balance type
1188 'N', -- authority type
1189 'N', -- definie indefinite flag
1190 'N', -- legislative indicator
1191 'N', -- public law code
1192 'N', -- apportionmnet category
1193 'N', -- reimburseable flag
1194 'N', -- availability time
1195 'N', -- transaction partner
1196 'N', -- borrowing source
1197 'N', -- bea category
1198 'N', -- deficiency flag
1199 'N', -- function flag
1200 'N', -- govt not govt
1201 'T', -- exch non exch flag
1202 'N', -- cust non cust
1203 'N', -- budget subfunction
1204 'N', -- advance flag
1205 'N', -- transfer flag
1206 sysdate, -- creation_date
1207 FND_GLOBAL.USER_ID, -- created by
1208 sysdate, -- last update date
1209 FND_GLOBAL.USER_ID, -- last updated by
1210 FND_GLOBAL.USER_ID -- last updated login
1211 );
1212 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1213 SGL_ATTRIBUTES_ID,
1214 FACTS_ACCT_NUMBER,
1215 USSGL_ACCT_NUMBER,
1216 BALANCE_TYPE,
1217 AUTHORITY_TYPE,
1218 DEFINITE_INDEFINITE_FLAG,
1219 LEGISLATIVE_INDICATOR,
1220 PUBLIC_LAW_CODE,
1221 APPORTIONMENT_CATEGORY,
1222 REIMBURSEABLE_FLAG,
1223 AVAILABILITY_TIME,
1224 TRANSACTION_PARTNER,
1225 BORROWING_SOURCE,
1226 BEA_CATEGORY,
1227 DEFICIENCY_FLAG,
1228 FUNCTION_FLAG,
1229 GOVT_NON_GOVT,
1230 EXCH_NON_EXCH,
1231 CUST_NON_CUST,
1232 BUDGET_SUBFUNCTION,
1233 ADVANCE_FLAG,
1234 TRANSFER_FLAG,
1235 CREATION_DATE,
1236 CREATED_BY,
1237 LAST_UPDATE_DATE,
1238 LAST_UPDATED_BY,
1239 LAST_UPDATE_LOGIN)
1240 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1241 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1242 '5700', -- facct account number
1243 '5700', -- ussgl account number
1244 'E', -- balance type
1245 'N', -- authority type
1246 'N', -- definie indefinite flag
1247 'N', -- legislative indicator
1248 'N', -- public law code
1249 'N', -- apportionmnet category
1250 'N', -- reimburseable flag
1251 'N', -- availability time
1252 'N', -- transaction partner
1253 'N', -- borrowing source
1254 'N', -- bea category
1255 'N', -- deficiency flag
1256 'N', -- function flag
1257 'X', -- govt not govt
1258 'N', -- exch non exch flag
1259 'N', -- cust non cust
1260 'N', -- budget subfunction
1261 'N', -- advance flag
1262 'N', -- transfer flag
1263 sysdate, -- creation_date
1264 FND_GLOBAL.USER_ID, -- created by
1265 sysdate, -- last update date
1266 FND_GLOBAL.USER_ID, -- last updated by
1267 FND_GLOBAL.USER_ID -- last updated login
1268 );
1269 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1270 SGL_ATTRIBUTES_ID,
1271 FACTS_ACCT_NUMBER,
1272 USSGL_ACCT_NUMBER,
1273 BALANCE_TYPE,
1274 AUTHORITY_TYPE,
1275 DEFINITE_INDEFINITE_FLAG,
1276 LEGISLATIVE_INDICATOR,
1277 PUBLIC_LAW_CODE,
1278 APPORTIONMENT_CATEGORY,
1279 REIMBURSEABLE_FLAG,
1280 AVAILABILITY_TIME,
1281 TRANSACTION_PARTNER,
1282 BORROWING_SOURCE,
1283 BEA_CATEGORY,
1284 DEFICIENCY_FLAG,
1285 FUNCTION_FLAG,
1286 GOVT_NON_GOVT,
1287 EXCH_NON_EXCH,
1288 CUST_NON_CUST,
1289 BUDGET_SUBFUNCTION,
1290 ADVANCE_FLAG,
1291 TRANSFER_FLAG,
1292 CREATION_DATE,
1293 CREATED_BY,
1294 LAST_UPDATE_DATE,
1295 LAST_UPDATED_BY,
1296 LAST_UPDATE_LOGIN)
1300 '5720', -- ussgl account number
1297 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1298 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1299 '5720', -- facct account number
1301 'E', -- balance type
1302 'N', -- authority type
1303 'N', -- definie indefinite flag
1304 'N', -- legislative indicator
1305 'N', -- public law code
1306 'N', -- apportionmnet category
1307 'N', -- reimburseable flag
1308 'N', -- availability time
1309 'N', -- transaction partner
1310 'N', -- borrowing source
1311 'N', -- bea category
1312 'N', -- deficiency flag
1313 'N', -- function flag
1314 'F', -- govt not govt
1315 'N', -- exch non exch flag
1316 'N', -- cust non cust
1317 'N', -- budget subfunction
1318 'N', -- advance flag
1319 'N', -- transfer flag
1320 sysdate, -- creation_date
1321 FND_GLOBAL.USER_ID, -- created by
1322 sysdate, -- last update date
1323 FND_GLOBAL.USER_ID, -- last updated by
1324 FND_GLOBAL.USER_ID -- last updated login
1325 );
1326 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1327 SGL_ATTRIBUTES_ID,
1328 FACTS_ACCT_NUMBER,
1329 USSGL_ACCT_NUMBER,
1330 BALANCE_TYPE,
1331 AUTHORITY_TYPE,
1332 DEFINITE_INDEFINITE_FLAG,
1333 LEGISLATIVE_INDICATOR,
1334 PUBLIC_LAW_CODE,
1335 APPORTIONMENT_CATEGORY,
1336 REIMBURSEABLE_FLAG,
1337 AVAILABILITY_TIME,
1338 TRANSACTION_PARTNER,
1339 BORROWING_SOURCE,
1340 BEA_CATEGORY,
1341 DEFICIENCY_FLAG,
1342 FUNCTION_FLAG,
1343 GOVT_NON_GOVT,
1344 EXCH_NON_EXCH,
1345 CUST_NON_CUST,
1346 BUDGET_SUBFUNCTION,
1347 ADVANCE_FLAG,
1348 TRANSFER_FLAG,
1349 CREATION_DATE,
1350 CREATED_BY,
1351 LAST_UPDATE_DATE,
1352 LAST_UPDATED_BY,
1353 LAST_UPDATE_LOGIN)
1354 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1358 'E', -- balance type
1355 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1356 '5730', -- facct account number
1357 '5730', -- ussgl account number
1359 'N', -- authority type
1360 'N', -- definie indefinite flag
1361 'N', -- legislative indicator
1362 'N', -- public law code
1363 'N', -- apportionmnet category
1364 'N', -- reimburseable flag
1365 'N', -- availability time
1366 'N', -- transaction partner
1367 'N', -- borrowing source
1368 'N', -- bea category
1369 'N', -- deficiency flag
1370 'N', -- function flag
1371 'F', -- govt not govt
1372 'N', -- exch non exch flag
1373 'N', -- cust non cust
1374 'N', -- budget subfunction
1375 'N', -- advance flag
1376 'N', -- transfer flag
1377 sysdate, -- creation_date
1378 FND_GLOBAL.USER_ID, -- created by
1379 sysdate, -- last update date
1380 FND_GLOBAL.USER_ID, -- last updated by
1381 FND_GLOBAL.USER_ID -- last updated login
1382 );
1383 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1384 SGL_ATTRIBUTES_ID,
1385 FACTS_ACCT_NUMBER,
1386 USSGL_ACCT_NUMBER,
1387 BALANCE_TYPE,
1388 AUTHORITY_TYPE,
1389 DEFINITE_INDEFINITE_FLAG,
1390 LEGISLATIVE_INDICATOR,
1391 PUBLIC_LAW_CODE,
1392 APPORTIONMENT_CATEGORY,
1393 REIMBURSEABLE_FLAG,
1394 AVAILABILITY_TIME,
1395 TRANSACTION_PARTNER,
1396 BORROWING_SOURCE,
1397 BEA_CATEGORY,
1398 DEFICIENCY_FLAG,
1399 FUNCTION_FLAG,
1400 GOVT_NON_GOVT,
1401 EXCH_NON_EXCH,
1402 CUST_NON_CUST,
1403 BUDGET_SUBFUNCTION,
1404 ADVANCE_FLAG,
1405 TRANSFER_FLAG,
1406 CREATION_DATE,
1407 CREATED_BY,
1408 LAST_UPDATE_DATE,
1409 LAST_UPDATED_BY,
1410 LAST_UPDATE_LOGIN)
1411 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1412 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1413 '5740', -- facct account number
1414 '5740', -- ussgl account number
1415 'E', -- balance type
1416 'N', -- authority type
1417 'N', -- definie indefinite flag
1418 'N', -- legislative indicator
1419 'N', -- public law code
1420 'N', -- apportionmnet category
1421 'N', -- reimburseable flag
1422 'N', -- availability time
1423 'N', -- transaction partner
1424 'N', -- borrowing source
1425 'N', -- bea category
1426 'N', -- deficiency flag
1427 'N', -- function flag
1428 'F', -- govt not govt
1429 'N', -- exch non exch flag
1430 'N', -- cust non cust
1434 sysdate, -- creation_date
1431 'N', -- budget subfunction
1432 'N', -- advance flag
1433 'N', -- transfer flag
1435 FND_GLOBAL.USER_ID, -- created by
1436 sysdate, -- last update date
1437 FND_GLOBAL.USER_ID, -- last updated by
1438 FND_GLOBAL.USER_ID -- last updated login
1439 );
1440 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1441 SGL_ATTRIBUTES_ID,
1442 FACTS_ACCT_NUMBER,
1443 USSGL_ACCT_NUMBER,
1444 BALANCE_TYPE,
1445 AUTHORITY_TYPE,
1446 DEFINITE_INDEFINITE_FLAG,
1447 LEGISLATIVE_INDICATOR,
1448 PUBLIC_LAW_CODE,
1449 APPORTIONMENT_CATEGORY,
1450 REIMBURSEABLE_FLAG,
1451 AVAILABILITY_TIME,
1452 TRANSACTION_PARTNER,
1453 BORROWING_SOURCE,
1454 BEA_CATEGORY,
1455 DEFICIENCY_FLAG,
1456 FUNCTION_FLAG,
1457 GOVT_NON_GOVT,
1458 EXCH_NON_EXCH,
1459 CUST_NON_CUST,
1460 BUDGET_SUBFUNCTION,
1461 ADVANCE_FLAG,
1462 TRANSFER_FLAG,
1463 CREATION_DATE,
1464 CREATED_BY,
1465 LAST_UPDATE_DATE,
1466 LAST_UPDATED_BY,
1467 LAST_UPDATE_LOGIN)
1468 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1469 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1470 '5745', -- facct account number
1471 '5745', -- ussgl account number
1472 'E', -- balance type
1473 'N', -- authority type
1474 'N', -- definie indefinite flag
1475 'N', -- legislative indicator
1476 'N', -- public law code
1477 'N', -- apportionmnet category
1478 'N', -- reimburseable flag
1479 'N', -- availability time
1480 'N', -- transaction partner
1481 'N', -- borrowing source
1482 'N', -- bea category
1483 'N', -- deficiency flag
1484 'N', -- function flag
1485 'F', -- govt not govt
1486 'N', -- exch non exch flag
1487 'N', -- cust non cust
1488 'N', -- budget subfunction
1489 'N', -- advance flag
1490 'N', -- transfer flag
1491 sysdate, -- creation_date
1492 FND_GLOBAL.USER_ID, -- created by
1493 sysdate, -- last update date
1494 FND_GLOBAL.USER_ID, -- last updated by
1495 FND_GLOBAL.USER_ID -- last updated login
1496 );
1497 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1498 SGL_ATTRIBUTES_ID,
1499 FACTS_ACCT_NUMBER,
1500 USSGL_ACCT_NUMBER,
1501 BALANCE_TYPE,
1502 AUTHORITY_TYPE,
1503 DEFINITE_INDEFINITE_FLAG,
1504 LEGISLATIVE_INDICATOR,
1505 PUBLIC_LAW_CODE,
1506 APPORTIONMENT_CATEGORY,
1507 REIMBURSEABLE_FLAG,
1508 AVAILABILITY_TIME,
1509 TRANSACTION_PARTNER,
1510 BORROWING_SOURCE,
1511 BEA_CATEGORY,
1512 DEFICIENCY_FLAG,
1513 FUNCTION_FLAG,
1514 GOVT_NON_GOVT,
1515 EXCH_NON_EXCH,
1516 CUST_NON_CUST,
1517 BUDGET_SUBFUNCTION,
1518 ADVANCE_FLAG,
1519 TRANSFER_FLAG,
1520 CREATION_DATE,
1521 CREATED_BY,
1522 LAST_UPDATE_DATE,
1523 LAST_UPDATED_BY,
1524 LAST_UPDATE_LOGIN)
1525 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1526 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1527 '5750', -- facct account number
1528 '5750', -- ussgl account number
1529 'E', -- balance type
1530 'N', -- authority type
1531 'N', -- definie indefinite flag
1532 'N', -- legislative indicator
1533 'N', -- public law code
1534 'N', -- apportionmnet category
1535 'N', -- reimburseable flag
1536 'N', -- availability time
1537 'N', -- transaction partner
1538 'N', -- borrowing source
1539 'N', -- bea category
1540 'N', -- deficiency flag
1541 'N', -- function flag
1542 'F', -- govt not govt
1543 'N', -- exch non exch flag
1544 'N', -- cust non cust
1548 sysdate, -- creation_date
1545 'N', -- budget subfunction
1546 'N', -- advance flag
1547 'N', -- transfer flag
1549 FND_GLOBAL.USER_ID, -- created by
1550 sysdate, -- last update date
1551 FND_GLOBAL.USER_ID, -- last updated by
1552 FND_GLOBAL.USER_ID -- last updated login
1553 );
1554 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1555 SGL_ATTRIBUTES_ID,
1556 FACTS_ACCT_NUMBER,
1557 USSGL_ACCT_NUMBER,
1558 BALANCE_TYPE,
1559 AUTHORITY_TYPE,
1560 DEFINITE_INDEFINITE_FLAG,
1561 LEGISLATIVE_INDICATOR,
1562 PUBLIC_LAW_CODE,
1563 APPORTIONMENT_CATEGORY,
1564 REIMBURSEABLE_FLAG,
1565 AVAILABILITY_TIME,
1566 TRANSACTION_PARTNER,
1567 BORROWING_SOURCE,
1571 GOVT_NON_GOVT,
1568 BEA_CATEGORY,
1569 DEFICIENCY_FLAG,
1570 FUNCTION_FLAG,
1572 EXCH_NON_EXCH,
1573 CUST_NON_CUST,
1574 BUDGET_SUBFUNCTION,
1575 ADVANCE_FLAG,
1576 TRANSFER_FLAG,
1577 CREATION_DATE,
1578 CREATED_BY,
1579 LAST_UPDATE_DATE,
1580 LAST_UPDATED_BY,
1581 LAST_UPDATE_LOGIN)
1582 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1583 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1584 '5755', -- facct account number
1585 '5755', -- ussgl account number
1586 'E', -- balance type
1587 'N', -- authority type
1588 'N', -- definie indefinite flag
1589 'N', -- legislative indicator
1590 'N', -- public law code
1591 'N', -- apportionmnet category
1592 'N', -- reimburseable flag
1593 'N', -- availability time
1594 'N', -- transaction partner
1595 'N', -- borrowing source
1596 'N', -- bea category
1597 'N', -- deficiency flag
1598 'N', -- function flag
1599 'F', -- govt not govt
1600 'N', -- exch non exch flag
1601 'N', -- cust non cust
1602 'N', -- budget subfunction
1603 'N', -- advance flag
1604 'N', -- transfer flag
1605 sysdate, -- creation_date
1606 FND_GLOBAL.USER_ID, -- created by
1607 sysdate, -- last update date
1608 FND_GLOBAL.USER_ID, -- last updated by
1609 FND_GLOBAL.USER_ID -- last updated login
1610 );
1611 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1612 SGL_ATTRIBUTES_ID,
1613 FACTS_ACCT_NUMBER,
1614 USSGL_ACCT_NUMBER,
1615 BALANCE_TYPE,
1616 AUTHORITY_TYPE,
1617 DEFINITE_INDEFINITE_FLAG,
1618 LEGISLATIVE_INDICATOR,
1619 PUBLIC_LAW_CODE,
1620 APPORTIONMENT_CATEGORY,
1621 REIMBURSEABLE_FLAG,
1622 AVAILABILITY_TIME,
1623 TRANSACTION_PARTNER,
1624 BORROWING_SOURCE,
1625 BEA_CATEGORY,
1626 DEFICIENCY_FLAG,
1627 FUNCTION_FLAG,
1628 GOVT_NON_GOVT,
1629 EXCH_NON_EXCH,
1630 CUST_NON_CUST,
1631 BUDGET_SUBFUNCTION,
1632 ADVANCE_FLAG,
1633 TRANSFER_FLAG,
1634 CREATION_DATE,
1635 CREATED_BY,
1636 LAST_UPDATE_DATE,
1637 LAST_UPDATED_BY,
1638 LAST_UPDATE_LOGIN)
1639 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1640 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1641 '5760', -- facct account number
1642 '5760', -- ussgl account number
1643 'E', -- balance type
1644 'N', -- authority type
1645 'N', -- definie indefinite flag
1646 'N', -- legislative indicator
1647 'N', -- public law code
1648 'N', -- apportionmnet category
1649 'N', -- reimburseable flag
1650 'N', -- availability time
1651 'N', -- transaction partner
1652 'N', -- borrowing source
1653 'N', -- bea category
1654 'N', -- deficiency flag
1655 'N', -- function flag
1656 'F', -- govt not govt
1657 'N', -- exch non exch flag
1658 'N', -- cust non cust
1659 'N', -- budget subfunction
1660 'N', -- advance flag
1661 'N', -- transfer flag
1662 sysdate, -- creation_date
1663 FND_GLOBAL.USER_ID, -- created by
1664 sysdate, -- last update date
1665 FND_GLOBAL.USER_ID, -- last updated by
1666 FND_GLOBAL.USER_ID -- last updated login
1667 );
1668 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1669 SGL_ATTRIBUTES_ID,
1670 FACTS_ACCT_NUMBER,
1671 USSGL_ACCT_NUMBER,
1672 BALANCE_TYPE,
1673 AUTHORITY_TYPE,
1674 DEFINITE_INDEFINITE_FLAG,
1675 LEGISLATIVE_INDICATOR,
1676 PUBLIC_LAW_CODE,
1677 APPORTIONMENT_CATEGORY,
1678 REIMBURSEABLE_FLAG,
1679 AVAILABILITY_TIME,
1680 TRANSACTION_PARTNER,
1681 BORROWING_SOURCE,
1682 BEA_CATEGORY,
1683 DEFICIENCY_FLAG,
1684 FUNCTION_FLAG,
1685 GOVT_NON_GOVT,
1686 EXCH_NON_EXCH,
1687 CUST_NON_CUST,
1688 BUDGET_SUBFUNCTION,
1689 ADVANCE_FLAG,
1690 TRANSFER_FLAG,
1691 CREATION_DATE,
1692 CREATED_BY,
1693 LAST_UPDATE_DATE,
1694 LAST_UPDATED_BY,
1695 LAST_UPDATE_LOGIN)
1696 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1697 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1698 '5765', -- facct account number
1699 '5765', -- ussgl account number
1700 'E', -- balance type
1701 'N', -- authority type
1702 'N', -- definie indefinite flag
1703 'N', -- legislative indicator
1704 'N', -- public law code
1705 'N', -- apportionmnet category
1706 'N', -- reimburseable flag
1707 'N', -- availability time
1708 'N', -- transaction partner
1709 'N', -- borrowing source
1710 'N', -- bea category
1711 'N', -- deficiency flag
1712 'N', -- function flag
1713 'F', -- govt not govt
1714 'N', -- exch non exch flag
1715 'N', -- cust non cust
1716 'N', -- budget subfunction
1717 'N', -- advance flag
1718 'N', -- transfer flag
1719 sysdate, -- creation_date
1720 FND_GLOBAL.USER_ID, -- created by
1721 sysdate, -- last update date
1722 FND_GLOBAL.USER_ID, -- last updated by
1723 FND_GLOBAL.USER_ID -- last updated login
1724 );
1725 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1726 SGL_ATTRIBUTES_ID,
1727 FACTS_ACCT_NUMBER,
1728 USSGL_ACCT_NUMBER,
1729 BALANCE_TYPE,
1730 AUTHORITY_TYPE,
1731 DEFINITE_INDEFINITE_FLAG,
1735 REIMBURSEABLE_FLAG,
1732 LEGISLATIVE_INDICATOR,
1733 PUBLIC_LAW_CODE,
1734 APPORTIONMENT_CATEGORY,
1736 AVAILABILITY_TIME,
1737 TRANSACTION_PARTNER,
1741 FUNCTION_FLAG,
1738 BORROWING_SOURCE,
1739 BEA_CATEGORY,
1740 DEFICIENCY_FLAG,
1742 GOVT_NON_GOVT,
1743 EXCH_NON_EXCH,
1744 CUST_NON_CUST,
1745 BUDGET_SUBFUNCTION,
1746 ADVANCE_FLAG,
1747 TRANSFER_FLAG,
1748 CREATION_DATE,
1749 CREATED_BY,
1750 LAST_UPDATE_DATE,
1751 LAST_UPDATED_BY,
1752 LAST_UPDATE_LOGIN)
1753 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1754 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1755 '5780', -- facct account number
1756 '5780', -- ussgl account number
1757 'E', -- balance type
1758 'N', -- authority type
1759 'N', -- definie indefinite flag
1760 'N', -- legislative indicator
1761 'N', -- public law code
1762 'N', -- apportionmnet category
1763 'N', -- reimburseable flag
1764 'N', -- availability time
1765 'N', -- transaction partner
1766 'N', -- borrowing source
1767 'N', -- bea category
1768 'N', -- deficiency flag
1769 'N', -- function flag
1770 'F', -- govt not govt
1771 'N', -- exch non exch flag
1772 'N', -- cust non cust
1773 'N', -- budget subfunction
1774 'N', -- advance flag
1775 'N', -- transfer flag
1776 sysdate, -- creation_date
1777 FND_GLOBAL.USER_ID, -- created by
1778 sysdate, -- last update date
1779 FND_GLOBAL.USER_ID, -- last updated by
1780 FND_GLOBAL.USER_ID -- last updated login
1781 );
1782 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1783 SGL_ATTRIBUTES_ID,
1784 FACTS_ACCT_NUMBER,
1785 USSGL_ACCT_NUMBER,
1786 BALANCE_TYPE,
1787 AUTHORITY_TYPE,
1788 DEFINITE_INDEFINITE_FLAG,
1789 LEGISLATIVE_INDICATOR,
1790 PUBLIC_LAW_CODE,
1791 APPORTIONMENT_CATEGORY,
1792 REIMBURSEABLE_FLAG,
1793 AVAILABILITY_TIME,
1794 TRANSACTION_PARTNER,
1795 BORROWING_SOURCE,
1796 BEA_CATEGORY,
1797 DEFICIENCY_FLAG,
1798 FUNCTION_FLAG,
1799 GOVT_NON_GOVT,
1800 EXCH_NON_EXCH,
1801 CUST_NON_CUST,
1802 BUDGET_SUBFUNCTION,
1803 ADVANCE_FLAG,
1804 TRANSFER_FLAG,
1805 CREATION_DATE,
1806 CREATED_BY,
1807 LAST_UPDATE_DATE,
1808 LAST_UPDATED_BY,
1809 LAST_UPDATE_LOGIN)
1810 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1811 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1812 '5790', -- facct account number
1813 '5790', -- ussgl account number
1814 'E', -- balance type
1815 'N', -- authority type
1816 'N', -- definie indefinite flag
1817 'N', -- legislative indicator
1818 'N', -- public law code
1819 'N', -- apportionmnet category
1820 'N', -- reimburseable flag
1821 'N', -- availability time
1822 'N', -- transaction partner
1823 'N', -- borrowing source
1824 'N', -- bea category
1825 'N', -- deficiency flag
1826 'N', -- function flag
1827 'F', -- govt not govt
1828 'N', -- exch non exch flag
1829 'N', -- cust non cust
1830 'N', -- budget subfunction
1831 'N', -- advance flag
1832 'N', -- transfer flag
1833 sysdate, -- creation_date
1834 FND_GLOBAL.USER_ID, -- created by
1835 sysdate, -- last update date
1836 FND_GLOBAL.USER_ID, -- last updated by
1837 FND_GLOBAL.USER_ID -- last updated login
1838 );
1839 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1840 SGL_ATTRIBUTES_ID,
1841 FACTS_ACCT_NUMBER,
1842 USSGL_ACCT_NUMBER,
1843 BALANCE_TYPE,
1844 AUTHORITY_TYPE,
1848 APPORTIONMENT_CATEGORY,
1845 DEFINITE_INDEFINITE_FLAG,
1846 LEGISLATIVE_INDICATOR,
1847 PUBLIC_LAW_CODE,
1849 REIMBURSEABLE_FLAG,
1850 AVAILABILITY_TIME,
1851 TRANSACTION_PARTNER,
1852 BORROWING_SOURCE,
1853 BEA_CATEGORY,
1854 DEFICIENCY_FLAG,
1855 FUNCTION_FLAG,
1856 GOVT_NON_GOVT,
1857 EXCH_NON_EXCH,
1858 CUST_NON_CUST,
1859 BUDGET_SUBFUNCTION,
1860 ADVANCE_FLAG,
1861 TRANSFER_FLAG,
1862 CREATION_DATE,
1863 CREATED_BY,
1864 LAST_UPDATE_DATE,
1865 LAST_UPDATED_BY,
1866 LAST_UPDATE_LOGIN)
1867 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1868 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1869 '5799', -- facct account number
1870 '5799', -- ussgl account number
1871 'E', -- balance type
1872 'N', -- authority type
1873 'N', -- definie indefinite flag
1874 'N', -- legislative indicator
1875 'N', -- public law code
1876 'N', -- apportionmnet category
1877 'N', -- reimburseable flag
1878 'N', -- availability time
1879 'N', -- transaction partner
1880 'N', -- borrowing source
1881 'N', -- bea category
1882 'N', -- deficiency flag
1883 'N', -- function flag
1884 'X', -- govt not govt
1885 'N', -- exch non exch flag
1886 'N', -- cust non cust
1887 'N', -- budget subfunction
1888 'N', -- advance flag
1889 'N', -- transfer flag
1890 sysdate, -- creation_date
1891 FND_GLOBAL.USER_ID, -- created by
1892 sysdate, -- last update date
1893 FND_GLOBAL.USER_ID, -- last updated by
1894 FND_GLOBAL.USER_ID -- last updated login
1895 );
1896 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1897 SGL_ATTRIBUTES_ID,
1898 FACTS_ACCT_NUMBER,
1899 USSGL_ACCT_NUMBER,
1900 BALANCE_TYPE,
1901 AUTHORITY_TYPE,
1902 DEFINITE_INDEFINITE_FLAG,
1903 LEGISLATIVE_INDICATOR,
1904 PUBLIC_LAW_CODE,
1905 APPORTIONMENT_CATEGORY,
1906 REIMBURSEABLE_FLAG,
1907 AVAILABILITY_TIME,
1908 TRANSACTION_PARTNER,
1909 BORROWING_SOURCE,
1910 BEA_CATEGORY,
1911 DEFICIENCY_FLAG,
1912 FUNCTION_FLAG,
1913 GOVT_NON_GOVT,
1914 EXCH_NON_EXCH,
1915 CUST_NON_CUST,
1916 BUDGET_SUBFUNCTION,
1917 ADVANCE_FLAG,
1918 TRANSFER_FLAG,
1919 CREATION_DATE,
1920 CREATED_BY,
1921 LAST_UPDATE_DATE,
1922 LAST_UPDATED_BY,
1923 LAST_UPDATE_LOGIN)
1924 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1925 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1926 '5800', -- facct account number
1927 '5800', -- ussgl account number
1928 'E', -- balance type
1929 'N', -- authority type
1930 'N', -- definie indefinite flag
1931 'N', -- legislative indicator
1935 'N', -- availability time
1932 'N', -- public law code
1933 'N', -- apportionmnet category
1934 'N', -- reimburseable flag
1936 'N', -- transaction partner
1937 'N', -- borrowing source
1938 'N', -- bea category
1939 'N', -- deficiency flag
1940 'N', -- function flag
1941 'Y', -- govt not govt
1942 'T', -- exch non exch flag
1943 'Y', -- cust non cust
1944 'N', -- budget subfunction
1945 'N', -- advance flag
1946 'N', -- transfer flag
1947 sysdate, -- creation_date
1948 FND_GLOBAL.USER_ID, -- created by
1949 sysdate, -- last update date
1950 FND_GLOBAL.USER_ID, -- last updated by
1951 FND_GLOBAL.USER_ID -- last updated login
1952 );
1953 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
1954 SGL_ATTRIBUTES_ID,
1955 FACTS_ACCT_NUMBER,
1959 DEFINITE_INDEFINITE_FLAG,
1956 USSGL_ACCT_NUMBER,
1957 BALANCE_TYPE,
1958 AUTHORITY_TYPE,
1960 LEGISLATIVE_INDICATOR,
1961 PUBLIC_LAW_CODE,
1962 APPORTIONMENT_CATEGORY,
1963 REIMBURSEABLE_FLAG,
1964 AVAILABILITY_TIME,
1965 TRANSACTION_PARTNER,
1966 BORROWING_SOURCE,
1967 BEA_CATEGORY,
1968 DEFICIENCY_FLAG,
1969 FUNCTION_FLAG,
1970 GOVT_NON_GOVT,
1971 EXCH_NON_EXCH,
1972 CUST_NON_CUST,
1973 BUDGET_SUBFUNCTION,
1974 ADVANCE_FLAG,
1975 TRANSFER_FLAG,
1976 CREATION_DATE,
1977 CREATED_BY,
1978 LAST_UPDATE_DATE,
1979 LAST_UPDATED_BY,
1980 LAST_UPDATE_LOGIN)
1981 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
1982 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
1983 '5801', -- facct account number
1984 '5801', -- ussgl account number
1985 'E', -- balance type
1986 'N', -- authority type
1987 'N', -- definie indefinite flag
1988 'N', -- legislative indicator
1989 'N', -- public law code
1990 'N', -- apportionmnet category
1991 'N', -- reimburseable flag
1992 'N', -- availability time
1993 'N', -- transaction partner
1994 'N', -- borrowing source
1995 'N', -- bea category
1996 'N', -- deficiency flag
1997 'N', -- function flag
1998 'Y', -- govt not govt
1999 'T', -- exch non exch flag
2000 'Y', -- cust non cust
2001 'N', -- budget subfunction
2002 'N', -- advance flag
2003 'N', -- transfer flag
2004 sysdate, -- creation_date
2005 FND_GLOBAL.USER_ID, -- created by
2006 sysdate, -- last update date
2007 FND_GLOBAL.USER_ID, -- last updated by
2008 FND_GLOBAL.USER_ID -- last updated login
2009 );
2010 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2011 SGL_ATTRIBUTES_ID,
2012 FACTS_ACCT_NUMBER,
2013 USSGL_ACCT_NUMBER,
2014 BALANCE_TYPE,
2015 AUTHORITY_TYPE,
2016 DEFINITE_INDEFINITE_FLAG,
2017 LEGISLATIVE_INDICATOR,
2018 PUBLIC_LAW_CODE,
2019 APPORTIONMENT_CATEGORY,
2020 REIMBURSEABLE_FLAG,
2021 AVAILABILITY_TIME,
2022 TRANSACTION_PARTNER,
2023 BORROWING_SOURCE,
2024 BEA_CATEGORY,
2025 DEFICIENCY_FLAG,
2026 FUNCTION_FLAG,
2027 GOVT_NON_GOVT,
2028 EXCH_NON_EXCH,
2029 CUST_NON_CUST,
2030 BUDGET_SUBFUNCTION,
2031 ADVANCE_FLAG,
2032 TRANSFER_FLAG,
2033 CREATION_DATE,
2034 CREATED_BY,
2035 LAST_UPDATE_DATE,
2036 LAST_UPDATED_BY,
2037 LAST_UPDATE_LOGIN)
2038 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2039 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2040 '5809', -- facct account number
2041 '5809', -- ussgl account number
2042 'E', -- balance type
2043 'N', -- authority type
2044 'N', -- definie indefinite flag
2045 'N', -- legislative indicator
2046 'N', -- public law code
2047 'N', -- apportionmnet category
2048 'N', -- reimburseable flag
2049 'N', -- availability time
2050 'N', -- transaction partner
2051 'N', -- borrowing source
2052 'N', -- bea category
2053 'N', -- deficiency flag
2054 'N', -- function flag
2055 'Y', -- govt not govt
2056 'T', -- exch non exch flag
2057 'Y', -- cust non cust
2058 'N', -- budget subfunction
2059 'N', -- advance flag
2060 'N', -- transfer flag
2061 sysdate, -- creation_date
2062 FND_GLOBAL.USER_ID, -- created by
2063 sysdate, -- last update date
2064 FND_GLOBAL.USER_ID, -- last updated by
2065 FND_GLOBAL.USER_ID -- last updated login
2066 );
2067 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2068 SGL_ATTRIBUTES_ID,
2069 FACTS_ACCT_NUMBER,
2070 USSGL_ACCT_NUMBER,
2071 BALANCE_TYPE,
2072 AUTHORITY_TYPE,
2073 DEFINITE_INDEFINITE_FLAG,
2074 LEGISLATIVE_INDICATOR,
2075 PUBLIC_LAW_CODE,
2076 APPORTIONMENT_CATEGORY,
2077 REIMBURSEABLE_FLAG,
2078 AVAILABILITY_TIME,
2079 TRANSACTION_PARTNER,
2080 BORROWING_SOURCE,
2081 BEA_CATEGORY,
2082 DEFICIENCY_FLAG,
2083 FUNCTION_FLAG,
2084 GOVT_NON_GOVT,
2085 EXCH_NON_EXCH,
2086 CUST_NON_CUST,
2087 BUDGET_SUBFUNCTION,
2088 ADVANCE_FLAG,
2089 TRANSFER_FLAG,
2090 CREATION_DATE,
2091 CREATED_BY,
2092 LAST_UPDATE_DATE,
2093 LAST_UPDATED_BY,
2094 LAST_UPDATE_LOGIN)
2095 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2096 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2097 '5890', -- facct account number
2098 '5890', -- ussgl account number
2099 'E', -- balance type
2100 'N', -- authority type
2101 'N', -- definie indefinite flag
2102 'N', -- legislative indicator
2103 'N', -- public law code
2104 'N', -- apportionmnet category
2105 'N', -- reimburseable flag
2106 'N', -- availability time
2107 'N', -- transaction partner
2108 'N', -- borrowing source
2109 'N', -- bea category
2110 'N', -- deficiency flag
2111 'N', -- function flag
2112 'Y', -- govt not govt
2113 'T', -- exch non exch flag
2114 'Y', -- cust non cust
2115 'N', -- budget subfunction
2116 'N', -- advance flag
2117 'N', -- transfer flag
2118 sysdate, -- creation_date
2119 FND_GLOBAL.USER_ID, -- created by
2120 sysdate, -- last update date
2126 FACTS_ACCT_NUMBER,
2121 FND_GLOBAL.USER_ID, -- last updated by
2122 FND_GLOBAL.USER_ID -- last updated login
2123 );
2124 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2125 SGL_ATTRIBUTES_ID,
2127 USSGL_ACCT_NUMBER,
2128 BALANCE_TYPE,
2129 AUTHORITY_TYPE,
2130 DEFINITE_INDEFINITE_FLAG,
2131 LEGISLATIVE_INDICATOR,
2132 PUBLIC_LAW_CODE,
2133 APPORTIONMENT_CATEGORY,
2134 REIMBURSEABLE_FLAG,
2135 AVAILABILITY_TIME,
2136 TRANSACTION_PARTNER,
2137 BORROWING_SOURCE,
2138 BEA_CATEGORY,
2139 DEFICIENCY_FLAG,
2140 FUNCTION_FLAG,
2141 GOVT_NON_GOVT,
2142 EXCH_NON_EXCH,
2143 CUST_NON_CUST,
2144 BUDGET_SUBFUNCTION,
2145 ADVANCE_FLAG,
2146 TRANSFER_FLAG,
2147 CREATION_DATE,
2148 CREATED_BY,
2149 LAST_UPDATE_DATE,
2150 LAST_UPDATED_BY,
2151 LAST_UPDATE_LOGIN)
2152 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2153 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2154 '5900', -- facct account number
2155 '5900', -- ussgl account number
2156 'E', -- balance type
2157 'N', -- authority type
2158 'N', -- definie indefinite flag
2159 'N', -- legislative indicator
2160 'N', -- public law code
2161 'N', -- apportionmnet category
2162 'N', -- reimburseable flag
2163 'N', -- availability time
2164 'N', -- transaction partner
2165 'N', -- borrowing source
2166 'N', -- bea category
2167 'N', -- deficiency flag
2168 'N', -- function flag
2169 'Y', -- govt not govt
2170 'Y', -- exch non exch flag
2171 'Y', -- cust non cust
2172 'Y', -- budget subfunction
2173 'N', -- advance flag
2174 'N', -- transfer flag
2175 sysdate, -- creation_date
2176 FND_GLOBAL.USER_ID, -- created by
2177 sysdate, -- last update date
2178 FND_GLOBAL.USER_ID, -- last updated by
2179 FND_GLOBAL.USER_ID -- last updated login
2180 );
2181 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2182 SGL_ATTRIBUTES_ID,
2183 FACTS_ACCT_NUMBER,
2184 USSGL_ACCT_NUMBER,
2185 BALANCE_TYPE,
2186 AUTHORITY_TYPE,
2187 DEFINITE_INDEFINITE_FLAG,
2188 LEGISLATIVE_INDICATOR,
2189 PUBLIC_LAW_CODE,
2190 APPORTIONMENT_CATEGORY,
2191 REIMBURSEABLE_FLAG,
2192 AVAILABILITY_TIME,
2193 TRANSACTION_PARTNER,
2194 BORROWING_SOURCE,
2195 BEA_CATEGORY,
2196 DEFICIENCY_FLAG,
2197 FUNCTION_FLAG,
2198 GOVT_NON_GOVT,
2199 EXCH_NON_EXCH,
2200 CUST_NON_CUST,
2201 BUDGET_SUBFUNCTION,
2202 ADVANCE_FLAG,
2203 TRANSFER_FLAG,
2204 CREATION_DATE,
2205 CREATED_BY,
2206 LAST_UPDATE_DATE,
2207 LAST_UPDATED_BY,
2208 LAST_UPDATE_LOGIN)
2209 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2210 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2211 '5909', -- facct account number
2212 '5909', -- ussgl account number
2213 'E', -- balance type
2214 'N', -- authority type
2215 'N', -- definie indefinite flag
2216 'N', -- legislative indicator
2217 'N', -- public law code
2218 'N', -- apportionmnet category
2219 'N', -- reimburseable flag
2220 'N', -- availability time
2221 'N', -- transaction partner
2222 'N', -- borrowing source
2223 'N', -- bea category
2224 'N', -- deficiency flag
2225 'N', -- function flag
2226 'Y', -- govt not govt
2227 'Y', -- exch non exch flag
2228 'Y', -- cust non cust
2229 'Y', -- budget subfunction
2230 'N', -- advance flag
2231 'N', -- transfer flag
2232 sysdate, -- creation_date
2233 FND_GLOBAL.USER_ID, -- created by
2234 sysdate, -- last update date
2235 FND_GLOBAL.USER_ID, -- last updated by
2236 FND_GLOBAL.USER_ID -- last updated login
2237 );
2238 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2239 SGL_ATTRIBUTES_ID,
2240 FACTS_ACCT_NUMBER,
2241 USSGL_ACCT_NUMBER,
2242 BALANCE_TYPE,
2243 AUTHORITY_TYPE,
2244 DEFINITE_INDEFINITE_FLAG,
2245 LEGISLATIVE_INDICATOR,
2246 PUBLIC_LAW_CODE,
2247 APPORTIONMENT_CATEGORY,
2248 REIMBURSEABLE_FLAG,
2249 AVAILABILITY_TIME,
2250 TRANSACTION_PARTNER,
2251 BORROWING_SOURCE,
2252 BEA_CATEGORY,
2253 DEFICIENCY_FLAG,
2254 FUNCTION_FLAG,
2255 GOVT_NON_GOVT,
2256 EXCH_NON_EXCH,
2257 CUST_NON_CUST,
2258 BUDGET_SUBFUNCTION,
2259 ADVANCE_FLAG,
2260 TRANSFER_FLAG,
2264 LAST_UPDATED_BY,
2261 CREATION_DATE,
2262 CREATED_BY,
2263 LAST_UPDATE_DATE,
2265 LAST_UPDATE_LOGIN)
2266 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2267 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2268 '5990', -- facct account number
2269 '5990', -- ussgl account number
2270 'E', -- balance type
2271 'N', -- authority type
2272 'N', -- definie indefinite flag
2273 'N', -- legislative indicator
2274 'N', -- public law code
2275 'N', -- apportionmnet category
2276 'N', -- reimburseable flag
2277 'N', -- availability time
2278 'N', -- transaction partner
2279 'N', -- borrowing source
2280 'N', -- bea category
2281 'N', -- deficiency flag
2282 'N', -- function flag
2283 'Y', -- govt not govt
2284 'Y', -- exch non exch flag
2285 'Y', -- cust non cust
2286 'Y', -- budget subfunction
2287 'N', -- advance flag
2288 'N', -- transfer flag
2289 sysdate, -- creation_date
2290 FND_GLOBAL.USER_ID, -- created by
2291 sysdate, -- last update date
2292 FND_GLOBAL.USER_ID, -- last updated by
2293 FND_GLOBAL.USER_ID -- last updated login
2294 );
2295 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2296 SGL_ATTRIBUTES_ID,
2297 FACTS_ACCT_NUMBER,
2298 USSGL_ACCT_NUMBER,
2299 BALANCE_TYPE,
2300 AUTHORITY_TYPE,
2301 DEFINITE_INDEFINITE_FLAG,
2302 LEGISLATIVE_INDICATOR,
2303 PUBLIC_LAW_CODE,
2304 APPORTIONMENT_CATEGORY,
2305 REIMBURSEABLE_FLAG,
2306 AVAILABILITY_TIME,
2307 TRANSACTION_PARTNER,
2308 BORROWING_SOURCE,
2309 BEA_CATEGORY,
2310 DEFICIENCY_FLAG,
2311 FUNCTION_FLAG,
2312 GOVT_NON_GOVT,
2313 EXCH_NON_EXCH,
2314 CUST_NON_CUST,
2315 BUDGET_SUBFUNCTION,
2316 ADVANCE_FLAG,
2317 TRANSFER_FLAG,
2318 CREATION_DATE,
2322 LAST_UPDATE_LOGIN)
2319 CREATED_BY,
2320 LAST_UPDATE_DATE,
2321 LAST_UPDATED_BY,
2323 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2324 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2325 '5991', -- facct account number
2326 '5991', -- ussgl account number
2327 'E', -- balance type
2328 'N', -- authority type
2329 'N', -- definie indefinite flag
2330 'N', -- legislative indicator
2331 'N', -- public law code
2332 'N', -- apportionmnet category
2333 'N', -- reimburseable flag
2334 'N', -- availability time
2335 'N', -- transaction partner
2336 'N', -- borrowing source
2337 'N', -- bea category
2338 'N', -- deficiency flag
2339 'N', -- function flag
2340 'Y', -- govt not govt
2341 'Y', -- exch non exch flag
2342 'Y', -- cust non cust
2343 'Y', -- budget subfunction
2344 'N', -- advance flag
2345 'N', -- transfer flag
2346 sysdate, -- creation_date
2347 FND_GLOBAL.USER_ID, -- created by
2348 sysdate, -- last update date
2349 FND_GLOBAL.USER_ID, -- last updated by
2350 FND_GLOBAL.USER_ID -- last updated login
2351 );
2352 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2353 SGL_ATTRIBUTES_ID,
2354 FACTS_ACCT_NUMBER,
2355 USSGL_ACCT_NUMBER,
2356 BALANCE_TYPE,
2357 AUTHORITY_TYPE,
2358 DEFINITE_INDEFINITE_FLAG,
2359 LEGISLATIVE_INDICATOR,
2360 PUBLIC_LAW_CODE,
2361 APPORTIONMENT_CATEGORY,
2362 REIMBURSEABLE_FLAG,
2363 AVAILABILITY_TIME,
2364 TRANSACTION_PARTNER,
2365 BORROWING_SOURCE,
2366 BEA_CATEGORY,
2367 DEFICIENCY_FLAG,
2368 FUNCTION_FLAG,
2369 GOVT_NON_GOVT,
2370 EXCH_NON_EXCH,
2371 CUST_NON_CUST,
2372 BUDGET_SUBFUNCTION,
2373 ADVANCE_FLAG,
2374 TRANSFER_FLAG,
2375 CREATION_DATE,
2376 CREATED_BY,
2377 LAST_UPDATE_DATE,
2378 LAST_UPDATED_BY,
2379 LAST_UPDATE_LOGIN)
2380 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2381 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2382 '6100', -- facct account number
2383 '6100', -- ussgl account number
2384 'E', -- balance type
2385 'N', -- authority type
2386 'N', -- definie indefinite flag
2387 'N', -- legislative indicator
2388 'N', -- public law code
2389 'N', -- apportionmnet category
2390 'N', -- reimburseable flag
2391 'N', -- availability time
2392 'N', -- transaction partner
2393 'N', -- borrowing source
2394 'N', -- bea category
2395 'N', -- deficiency flag
2396 'N', -- function flag
2400 'Y', -- budget subfunction
2397 'Y', -- govt not govt
2398 'N', -- exch non exch flag
2399 'N', -- cust non cust
2401 'N', -- advance flag
2402 'N', -- transfer flag
2403 sysdate, -- creation_date
2404 FND_GLOBAL.USER_ID, -- created by
2405 sysdate, -- last update date
2406 FND_GLOBAL.USER_ID, -- last updated by
2407 FND_GLOBAL.USER_ID -- last updated login
2408 );
2409 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2410 SGL_ATTRIBUTES_ID,
2411 FACTS_ACCT_NUMBER,
2412 USSGL_ACCT_NUMBER,
2413 BALANCE_TYPE,
2414 AUTHORITY_TYPE,
2415 DEFINITE_INDEFINITE_FLAG,
2416 LEGISLATIVE_INDICATOR,
2417 PUBLIC_LAW_CODE,
2418 APPORTIONMENT_CATEGORY,
2419 REIMBURSEABLE_FLAG,
2420 AVAILABILITY_TIME,
2421 TRANSACTION_PARTNER,
2422 BORROWING_SOURCE,
2423 BEA_CATEGORY,
2424 DEFICIENCY_FLAG,
2425 FUNCTION_FLAG,
2426 GOVT_NON_GOVT,
2427 EXCH_NON_EXCH,
2428 CUST_NON_CUST,
2429 BUDGET_SUBFUNCTION,
2430 ADVANCE_FLAG,
2431 TRANSFER_FLAG,
2432 CREATION_DATE,
2433 CREATED_BY,
2434 LAST_UPDATE_DATE,
2435 LAST_UPDATED_BY,
2436 LAST_UPDATE_LOGIN)
2437 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2438 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2439 '6190', -- facct account number
2440 '6190', -- ussgl account number
2441 'E', -- balance type
2442 'N', -- authority type
2443 'N', -- definie indefinite flag
2444 'N', -- legislative indicator
2445 'N', -- public law code
2446 'N', -- apportionmnet category
2447 'N', -- reimburseable flag
2448 'N', -- availability time
2449 'N', -- transaction partner
2450 'N', -- borrowing source
2451 'N', -- bea category
2452 'N', -- deficiency flag
2453 'N', -- function flag
2454 'Y', -- govt not govt
2455 'N', -- exch non exch flag
2456 'N', -- cust non cust
2457 'Y', -- budget subfunction
2458 'N', -- advance flag
2459 'N', -- transfer flag
2460 sysdate, -- creation_date
2461 FND_GLOBAL.USER_ID, -- created by
2462 sysdate, -- last update date
2463 FND_GLOBAL.USER_ID, -- last updated by
2464 FND_GLOBAL.USER_ID -- last updated login
2465 );
2466 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2467 SGL_ATTRIBUTES_ID,
2468 FACTS_ACCT_NUMBER,
2469 USSGL_ACCT_NUMBER,
2470 BALANCE_TYPE,
2471 AUTHORITY_TYPE,
2472 DEFINITE_INDEFINITE_FLAG,
2473 LEGISLATIVE_INDICATOR,
2474 PUBLIC_LAW_CODE,
2475 APPORTIONMENT_CATEGORY,
2476 REIMBURSEABLE_FLAG,
2477 AVAILABILITY_TIME,
2478 TRANSACTION_PARTNER,
2479 BORROWING_SOURCE,
2480 BEA_CATEGORY,
2481 DEFICIENCY_FLAG,
2482 FUNCTION_FLAG,
2483 GOVT_NON_GOVT,
2484 EXCH_NON_EXCH,
2485 CUST_NON_CUST,
2486 BUDGET_SUBFUNCTION,
2487 ADVANCE_FLAG,
2488 TRANSFER_FLAG,
2489 CREATION_DATE,
2490 CREATED_BY,
2491 LAST_UPDATE_DATE,
2492 LAST_UPDATED_BY,
2493 LAST_UPDATE_LOGIN)
2494 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2495 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2496 '6199', -- facct account number
2497 '6199', -- ussgl account number
2498 'E', -- balance type
2499 'N', -- authority type
2500 'N', -- definie indefinite flag
2501 'N', -- legislative indicator
2502 'N', -- public law code
2503 'N', -- apportionmnet category
2504 'N', -- reimburseable flag
2505 'N', -- availability time
2506 'N', -- transaction partner
2507 'N', -- borrowing source
2508 'N', -- bea category
2512 'N', -- exch non exch flag
2509 'N', -- deficiency flag
2510 'N', -- function flag
2511 'N', -- govt not govt
2513 'N', -- cust non cust
2514 'Y', -- budget subfunction
2515 'N', -- advance flag
2516 'N', -- transfer flag
2517 sysdate, -- creation_date
2518 FND_GLOBAL.USER_ID, -- created by
2519 sysdate, -- last update date
2520 FND_GLOBAL.USER_ID, -- last updated by
2521 FND_GLOBAL.USER_ID -- last updated login
2522 );
2523 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2524 SGL_ATTRIBUTES_ID,
2525 FACTS_ACCT_NUMBER,
2526 USSGL_ACCT_NUMBER,
2527 BALANCE_TYPE,
2528 AUTHORITY_TYPE,
2529 DEFINITE_INDEFINITE_FLAG,
2530 LEGISLATIVE_INDICATOR,
2531 PUBLIC_LAW_CODE,
2532 APPORTIONMENT_CATEGORY,
2533 REIMBURSEABLE_FLAG,
2534 AVAILABILITY_TIME,
2535 TRANSACTION_PARTNER,
2536 BORROWING_SOURCE,
2537 BEA_CATEGORY,
2538 DEFICIENCY_FLAG,
2539 FUNCTION_FLAG,
2540 GOVT_NON_GOVT,
2541 EXCH_NON_EXCH,
2542 CUST_NON_CUST,
2543 BUDGET_SUBFUNCTION,
2544 ADVANCE_FLAG,
2545 TRANSFER_FLAG,
2546 CREATION_DATE,
2547 CREATED_BY,
2548 LAST_UPDATE_DATE,
2549 LAST_UPDATED_BY,
2550 LAST_UPDATE_LOGIN)
2551 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2552 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2553 '6310', -- facct account number
2554 '6310', -- ussgl account number
2555 'E', -- balance type
2556 'N', -- authority type
2557 'N', -- definie indefinite flag
2558 'N', -- legislative indicator
2559 'N', -- public law code
2560 'N', -- apportionmnet category
2561 'N', -- reimburseable flag
2562 'N', -- availability time
2563 'N', -- transaction partner
2564 'N', -- borrowing source
2565 'N', -- bea category
2566 'N', -- deficiency flag
2567 'N', -- function flag
2568 'F', -- govt not govt
2569 'N', -- exch non exch flag
2570 'N', -- cust non cust
2571 'Y', -- budget subfunction
2572 'N', -- advance flag
2573 'N', -- transfer flag
2574 sysdate, -- creation_date
2575 FND_GLOBAL.USER_ID, -- created by
2576 sysdate, -- last update date
2580 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2577 FND_GLOBAL.USER_ID, -- last updated by
2578 FND_GLOBAL.USER_ID -- last updated login
2579 );
2581 SGL_ATTRIBUTES_ID,
2582 FACTS_ACCT_NUMBER,
2583 USSGL_ACCT_NUMBER,
2584 BALANCE_TYPE,
2585 AUTHORITY_TYPE,
2586 DEFINITE_INDEFINITE_FLAG,
2587 LEGISLATIVE_INDICATOR,
2588 PUBLIC_LAW_CODE,
2589 APPORTIONMENT_CATEGORY,
2590 REIMBURSEABLE_FLAG,
2591 AVAILABILITY_TIME,
2592 TRANSACTION_PARTNER,
2593 BORROWING_SOURCE,
2594 BEA_CATEGORY,
2595 DEFICIENCY_FLAG,
2596 FUNCTION_FLAG,
2597 GOVT_NON_GOVT,
2598 EXCH_NON_EXCH,
2599 CUST_NON_CUST,
2600 BUDGET_SUBFUNCTION,
2601 ADVANCE_FLAG,
2602 TRANSFER_FLAG,
2603 CREATION_DATE,
2604 CREATED_BY,
2605 LAST_UPDATE_DATE,
2606 LAST_UPDATED_BY,
2607 LAST_UPDATE_LOGIN)
2608 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2609 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2610 '6320', -- facct account number
2611 '6320', -- ussgl account number
2612 'E', -- balance type
2613 'N', -- authority type
2614 'N', -- definie indefinite flag
2615 'N', -- legislative indicator
2616 'N', -- public law code
2617 'N', -- apportionmnet category
2618 'N', -- reimburseable flag
2619 'N', -- availability time
2620 'N', -- transaction partner
2621 'N', -- borrowing source
2622 'N', -- bea category
2623 'N', -- deficiency flag
2624 'N', -- function flag
2625 'Y', -- govt not govt
2626 'N', -- exch non exch flag
2627 'N', -- cust non cust
2628 'Y', -- budget subfunction
2629 'N', -- advance flag
2630 'N', -- transfer flag
2631 sysdate, -- creation_date
2632 FND_GLOBAL.USER_ID, -- created by
2633 sysdate, -- last update date
2634 FND_GLOBAL.USER_ID, -- last updated by
2635 FND_GLOBAL.USER_ID -- last updated login
2636 );
2637 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2638 SGL_ATTRIBUTES_ID,
2639 FACTS_ACCT_NUMBER,
2640 USSGL_ACCT_NUMBER,
2641 BALANCE_TYPE,
2642 AUTHORITY_TYPE,
2643 DEFINITE_INDEFINITE_FLAG,
2644 LEGISLATIVE_INDICATOR,
2645 PUBLIC_LAW_CODE,
2646 APPORTIONMENT_CATEGORY,
2647 REIMBURSEABLE_FLAG,
2648 AVAILABILITY_TIME,
2649 TRANSACTION_PARTNER,
2650 BORROWING_SOURCE,
2651 BEA_CATEGORY,
2652 DEFICIENCY_FLAG,
2653 FUNCTION_FLAG,
2654 GOVT_NON_GOVT,
2655 EXCH_NON_EXCH,
2656 CUST_NON_CUST,
2657 BUDGET_SUBFUNCTION,
2658 ADVANCE_FLAG,
2659 TRANSFER_FLAG,
2660 CREATION_DATE,
2661 CREATED_BY,
2662 LAST_UPDATE_DATE,
2663 LAST_UPDATED_BY,
2664 LAST_UPDATE_LOGIN)
2665 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2666 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2667 '6330', -- facct account number
2668 '6330', -- ussgl account number
2669 'E', -- balance type
2670 'N', -- authority type
2671 'N', -- definie indefinite flag
2672 'N', -- legislative indicator
2673 'N', -- public law code
2674 'N', -- apportionmnet category
2675 'N', -- reimburseable flag
2676 'N', -- availability time
2677 'N', -- transaction partner
2678 'N', -- borrowing source
2679 'N', -- bea category
2680 'N', -- deficiency flag
2681 'N', -- function flag
2682 'Y', -- govt not govt
2683 'N', -- exch non exch flag
2684 'Y', -- cust non cust
2685 'Y', -- budget subfunction
2686 'N', -- advance flag
2687 'N', -- transfer flag
2688 sysdate, -- creation_date
2689 FND_GLOBAL.USER_ID, -- created by
2690 sysdate, -- last update date
2691 FND_GLOBAL.USER_ID, -- last updated by
2692 FND_GLOBAL.USER_ID -- last updated login
2693 );
2694 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2695 SGL_ATTRIBUTES_ID,
2696 FACTS_ACCT_NUMBER,
2697 USSGL_ACCT_NUMBER,
2698 BALANCE_TYPE,
2699 AUTHORITY_TYPE,
2700 DEFINITE_INDEFINITE_FLAG,
2701 LEGISLATIVE_INDICATOR,
2702 PUBLIC_LAW_CODE,
2703 APPORTIONMENT_CATEGORY,
2704 REIMBURSEABLE_FLAG,
2705 AVAILABILITY_TIME,
2706 TRANSACTION_PARTNER,
2707 BORROWING_SOURCE,
2708 BEA_CATEGORY,
2709 DEFICIENCY_FLAG,
2710 FUNCTION_FLAG,
2711 GOVT_NON_GOVT,
2712 EXCH_NON_EXCH,
2713 CUST_NON_CUST,
2714 BUDGET_SUBFUNCTION,
2715 ADVANCE_FLAG,
2716 TRANSFER_FLAG,
2717 CREATION_DATE,
2718 CREATED_BY,
2719 LAST_UPDATE_DATE,
2720 LAST_UPDATED_BY,
2721 LAST_UPDATE_LOGIN)
2722 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2723 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2724 '6400', -- facct account number
2725 '6400', -- ussgl account number
2726 'E', -- balance type
2727 'N', -- authority type
2728 'N', -- definie indefinite flag
2729 'N', -- legislative indicator
2730 'N', -- public law code
2731 'N', -- apportionmnet category
2732 'N', -- reimburseable flag
2733 'N', -- availability time
2734 'N', -- transaction partner
2735 'N', -- borrowing source
2736 'N', -- bea category
2737 'N', -- deficiency flag
2738 'N', -- function flag
2739 'Y', -- govt not govt
2740 'N', -- exch non exch flag
2741 'N', -- cust non cust
2745 sysdate, -- creation_date
2742 'Y', -- budget subfunction
2743 'N', -- advance flag
2744 'N', -- transfer flag
2746 FND_GLOBAL.USER_ID, -- created by
2747 sysdate, -- last update date
2748 FND_GLOBAL.USER_ID, -- last updated by
2749 FND_GLOBAL.USER_ID -- last updated login
2750 );
2751 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2752 SGL_ATTRIBUTES_ID,
2753 FACTS_ACCT_NUMBER,
2754 USSGL_ACCT_NUMBER,
2755 BALANCE_TYPE,
2756 AUTHORITY_TYPE,
2757 DEFINITE_INDEFINITE_FLAG,
2758 LEGISLATIVE_INDICATOR,
2759 PUBLIC_LAW_CODE,
2760 APPORTIONMENT_CATEGORY,
2761 REIMBURSEABLE_FLAG,
2762 AVAILABILITY_TIME,
2763 TRANSACTION_PARTNER,
2764 BORROWING_SOURCE,
2765 BEA_CATEGORY,
2766 DEFICIENCY_FLAG,
2767 FUNCTION_FLAG,
2768 GOVT_NON_GOVT,
2769 EXCH_NON_EXCH,
2770 CUST_NON_CUST,
2771 BUDGET_SUBFUNCTION,
2772 ADVANCE_FLAG,
2773 TRANSFER_FLAG,
2774 CREATION_DATE,
2775 CREATED_BY,
2776 LAST_UPDATE_DATE,
2777 LAST_UPDATED_BY,
2778 LAST_UPDATE_LOGIN)
2779 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2780 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2781 '6500', -- facct account number
2782 '6500', -- ussgl account number
2783 'E', -- balance type
2784 'N', -- authority type
2785 'N', -- definie indefinite flag
2786 'N', -- legislative indicator
2787 'N', -- public law code
2788 'N', -- apportionmnet category
2789 'N', -- reimburseable flag
2790 'N', -- availability time
2791 'N', -- transaction partner
2792 'N', -- borrowing source
2793 'N', -- bea category
2794 'N', -- deficiency flag
2795 'N', -- function flag
2796 'Y', -- govt not govt
2797 'N', -- exch non exch flag
2798 'N', -- cust non cust
2799 'Y', -- budget subfunction
2800 'N', -- advance flag
2801 'N', -- transfer flag
2802 sysdate, -- creation_date
2803 FND_GLOBAL.USER_ID, -- created by
2804 sysdate, -- last update date
2805 FND_GLOBAL.USER_ID, -- last updated by
2806 FND_GLOBAL.USER_ID -- last updated login
2807 );
2808 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2809 SGL_ATTRIBUTES_ID,
2810 FACTS_ACCT_NUMBER,
2811 USSGL_ACCT_NUMBER,
2812 BALANCE_TYPE,
2813 AUTHORITY_TYPE,
2814 DEFINITE_INDEFINITE_FLAG,
2815 LEGISLATIVE_INDICATOR,
2816 PUBLIC_LAW_CODE,
2817 APPORTIONMENT_CATEGORY,
2818 REIMBURSEABLE_FLAG,
2819 AVAILABILITY_TIME,
2820 TRANSACTION_PARTNER,
2821 BORROWING_SOURCE,
2822 BEA_CATEGORY,
2823 DEFICIENCY_FLAG,
2824 FUNCTION_FLAG,
2825 GOVT_NON_GOVT,
2826 EXCH_NON_EXCH,
2827 CUST_NON_CUST,
2828 BUDGET_SUBFUNCTION,
2829 ADVANCE_FLAG,
2830 TRANSFER_FLAG,
2831 CREATION_DATE,
2832 CREATED_BY,
2833 LAST_UPDATE_DATE,
2834 LAST_UPDATED_BY,
2835 LAST_UPDATE_LOGIN)
2836 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2837 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2838 '6600', -- facct account number
2839 '6600', -- ussgl account number
2840 'E', -- balance type
2841 'N', -- authority type
2842 'N', -- definie indefinite flag
2843 'N', -- legislative indicator
2844 'N', -- public law code
2845 'N', -- apportionmnet category
2846 'N', -- reimburseable flag
2847 'N', -- availability time
2848 'N', -- transaction partner
2849 'N', -- borrowing source
2850 'N', -- bea category
2851 'N', -- deficiency flag
2852 'N', -- function flag
2853 'N', -- govt not govt
2854 'N', -- exch non exch flag
2855 'N', -- cust non cust
2856 'Y', -- budget subfunction
2857 'N', -- advance flag
2858 'N', -- transfer flag
2859 sysdate, -- creation_date
2860 FND_GLOBAL.USER_ID, -- created by
2861 sysdate, -- last update date
2862 FND_GLOBAL.USER_ID, -- last updated by
2863 FND_GLOBAL.USER_ID -- last updated login
2864 );
2865
2866 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2867 SGL_ATTRIBUTES_ID,
2868 FACTS_ACCT_NUMBER,
2869 USSGL_ACCT_NUMBER,
2870 BALANCE_TYPE,
2871 AUTHORITY_TYPE,
2872 DEFINITE_INDEFINITE_FLAG,
2873 LEGISLATIVE_INDICATOR,
2874 PUBLIC_LAW_CODE,
2875 APPORTIONMENT_CATEGORY,
2876 REIMBURSEABLE_FLAG,
2877 AVAILABILITY_TIME,
2878 TRANSACTION_PARTNER,
2879 BORROWING_SOURCE,
2880 BEA_CATEGORY,
2881 DEFICIENCY_FLAG,
2882 FUNCTION_FLAG,
2883 GOVT_NON_GOVT,
2884 EXCH_NON_EXCH,
2885 CUST_NON_CUST,
2886 BUDGET_SUBFUNCTION,
2887 ADVANCE_FLAG,
2888 TRANSFER_FLAG,
2889 CREATION_DATE,
2890 CREATED_BY,
2891 LAST_UPDATE_DATE,
2892 LAST_UPDATED_BY,
2893 LAST_UPDATE_LOGIN)
2894 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2895 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2896 '6710', -- facct account number
2897 '6710', -- ussgl account number
2898 'E', -- balance type
2899 'N', -- authority type
2900 'N', -- definie indefinite flag
2901 'N', -- legislative indicator
2902 'N', -- public law code
2903 'N', -- apportionmnet category
2904 'N', -- reimburseable flag
2905 'N', -- availability time
2906 'N', -- transaction partner
2910 'N', -- function flag
2907 'N', -- borrowing source
2908 'N', -- bea category
2909 'N', -- deficiency flag
2911 'N', -- govt not govt
2912 'N', -- exch non exch flag
2913 'N', -- cust non cust
2914 'Y', -- budget subfunction
2915 'N', -- advance flag
2916 'N', -- transfer flag
2917 sysdate, -- creation_date
2918 FND_GLOBAL.USER_ID, -- created by
2919 sysdate, -- last update date
2920 FND_GLOBAL.USER_ID, -- last updated by
2921 FND_GLOBAL.USER_ID -- last updated login
2922 );
2923 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2924 SGL_ATTRIBUTES_ID,
2925 FACTS_ACCT_NUMBER,
2926 USSGL_ACCT_NUMBER,
2927 BALANCE_TYPE,
2928 AUTHORITY_TYPE,
2929 DEFINITE_INDEFINITE_FLAG,
2930 LEGISLATIVE_INDICATOR,
2931 PUBLIC_LAW_CODE,
2932 APPORTIONMENT_CATEGORY,
2933 REIMBURSEABLE_FLAG,
2934 AVAILABILITY_TIME,
2935 TRANSACTION_PARTNER,
2936 BORROWING_SOURCE,
2937 BEA_CATEGORY,
2938 DEFICIENCY_FLAG,
2939 FUNCTION_FLAG,
2940 GOVT_NON_GOVT,
2941 EXCH_NON_EXCH,
2942 CUST_NON_CUST,
2943 BUDGET_SUBFUNCTION,
2944 ADVANCE_FLAG,
2945 TRANSFER_FLAG,
2946 CREATION_DATE,
2947 CREATED_BY,
2948 LAST_UPDATE_DATE,
2949 LAST_UPDATED_BY,
2950 LAST_UPDATE_LOGIN)
2951 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
2952 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
2953 '6720', -- facct account number
2954 '6720', -- ussgl account number
2955 'E', -- balance type
2956 'N', -- authority type
2957 'N', -- definie indefinite flag
2958 'N', -- legislative indicator
2959 'N', -- public law code
2960 'N', -- apportionmnet category
2961 'N', -- reimburseable flag
2962 'N', -- availability time
2963 'N', -- transaction partner
2964 'N', -- borrowing source
2965 'N', -- bea category
2966 'N', -- deficiency flag
2967 'N', -- function flag
2968 'Y', -- govt not govt
2969 'N', -- exch non exch flag
2970 'N', -- cust non cust
2971 'Y', -- budget subfunction
2972 'N', -- advance flag
2973 'N', -- transfer flag
2974 sysdate, -- creation_date
2975 FND_GLOBAL.USER_ID, -- created by
2976 sysdate, -- last update date
2977 FND_GLOBAL.USER_ID, -- last updated by
2978 FND_GLOBAL.USER_ID -- last updated login
2979 );
2980 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
2981 SGL_ATTRIBUTES_ID,
2982 FACTS_ACCT_NUMBER,
2983 USSGL_ACCT_NUMBER,
2984 BALANCE_TYPE,
2985 AUTHORITY_TYPE,
2986 DEFINITE_INDEFINITE_FLAG,
2987 LEGISLATIVE_INDICATOR,
2988 PUBLIC_LAW_CODE,
2989 APPORTIONMENT_CATEGORY,
2990 REIMBURSEABLE_FLAG,
2991 AVAILABILITY_TIME,
2992 TRANSACTION_PARTNER,
2993 BORROWING_SOURCE,
2994 BEA_CATEGORY,
2995 DEFICIENCY_FLAG,
2996 FUNCTION_FLAG,
2997 GOVT_NON_GOVT,
2998 EXCH_NON_EXCH,
2999 CUST_NON_CUST,
3000 BUDGET_SUBFUNCTION,
3001 ADVANCE_FLAG,
3002 TRANSFER_FLAG,
3003 CREATION_DATE,
3004 CREATED_BY,
3005 LAST_UPDATE_DATE,
3006 LAST_UPDATED_BY,
3007 LAST_UPDATE_LOGIN)
3008 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3009 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3010 '6730', -- facct account number
3011 '6730', -- ussgl account number
3012 'E', -- balance type
3013 'N', -- authority type
3014 'N', -- definie indefinite flag
3015 'N', -- legislative indicator
3016 'N', -- public law code
3017 'N', -- apportionmnet category
3018 'N', -- reimburseable flag
3019 'N', -- availability time
3020 'N', -- transaction partner
3021 'N', -- borrowing source
3022 'N', -- bea category
3023 'N', -- deficiency flag
3024 'N', -- function flag
3025 'F', -- govt not govt
3026 'N', -- exch non exch flag
3027 'N', -- cust non cust
3028 'Y', -- budget subfunction
3029 'N', -- advance flag
3030 'N', -- transfer flag
3031 sysdate, -- creation_date
3032 FND_GLOBAL.USER_ID, -- created by
3033 sysdate, -- last update date
3034 FND_GLOBAL.USER_ID, -- last updated by
3035 FND_GLOBAL.USER_ID -- last updated login
3036 );
3037 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3038 SGL_ATTRIBUTES_ID,
3039 FACTS_ACCT_NUMBER,
3040 USSGL_ACCT_NUMBER,
3041 BALANCE_TYPE,
3042 AUTHORITY_TYPE,
3043 DEFINITE_INDEFINITE_FLAG,
3044 LEGISLATIVE_INDICATOR,
3045 PUBLIC_LAW_CODE,
3046 APPORTIONMENT_CATEGORY,
3047 REIMBURSEABLE_FLAG,
3048 AVAILABILITY_TIME,
3049 TRANSACTION_PARTNER,
3050 BORROWING_SOURCE,
3051 BEA_CATEGORY,
3052 DEFICIENCY_FLAG,
3053 FUNCTION_FLAG,
3054 GOVT_NON_GOVT,
3055 EXCH_NON_EXCH,
3056 CUST_NON_CUST,
3057 BUDGET_SUBFUNCTION,
3058 ADVANCE_FLAG,
3059 TRANSFER_FLAG,
3060 CREATION_DATE,
3061 CREATED_BY,
3062 LAST_UPDATE_DATE,
3063 LAST_UPDATED_BY,
3064 LAST_UPDATE_LOGIN)
3065 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3066 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3067 '6790', -- facct account number
3068 '6790', -- ussgl account number
3069 'E', -- balance type
3070 'N', -- authority type
3071 'N', -- definie indefinite flag
3075 'N', -- reimburseable flag
3072 'N', -- legislative indicator
3073 'N', -- public law code
3074 'N', -- apportionmnet category
3076 'N', -- availability time
3077 'N', -- transaction partner
3078 'N', -- borrowing source
3079 'N', -- bea category
3080 'N', -- deficiency flag
3081 'N', -- function flag
3082 'Y', -- govt not govt
3083 'N', -- exch non exch flag
3084 'N', -- cust non cust
3085 'Y', -- budget subfunction
3086 'N', -- advance flag
3087 'N', -- transfer flag
3088 sysdate, -- creation_date
3089 FND_GLOBAL.USER_ID, -- created by
3090 sysdate, -- last update date
3091 FND_GLOBAL.USER_ID, -- last updated by
3092 FND_GLOBAL.USER_ID -- last updated login
3093 );
3094 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3095 SGL_ATTRIBUTES_ID,
3096 FACTS_ACCT_NUMBER,
3097 USSGL_ACCT_NUMBER,
3098 BALANCE_TYPE,
3099 AUTHORITY_TYPE,
3100 DEFINITE_INDEFINITE_FLAG,
3101 LEGISLATIVE_INDICATOR,
3102 PUBLIC_LAW_CODE,
3103 APPORTIONMENT_CATEGORY,
3104 REIMBURSEABLE_FLAG,
3105 AVAILABILITY_TIME,
3106 TRANSACTION_PARTNER,
3107 BORROWING_SOURCE,
3108 BEA_CATEGORY,
3109 DEFICIENCY_FLAG,
3110 FUNCTION_FLAG,
3111 GOVT_NON_GOVT,
3112 EXCH_NON_EXCH,
3113 CUST_NON_CUST,
3114 BUDGET_SUBFUNCTION,
3115 ADVANCE_FLAG,
3116 TRANSFER_FLAG,
3117 CREATION_DATE,
3118 CREATED_BY,
3119 LAST_UPDATE_DATE,
3120 LAST_UPDATED_BY,
3121 LAST_UPDATE_LOGIN)
3122 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3123 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3124 '6800', -- facct account number
3125 '6800', -- ussgl account number
3126 'E', -- balance type
3127 'N', -- authority type
3128 'N', -- definie indefinite flag
3129 'N', -- legislative indicator
3130 'N', -- public law code
3131 'N', -- apportionmnet category
3132 'N', -- reimburseable flag
3133 'N', -- availability time
3134 'N', -- transaction partner
3135 'N', -- borrowing source
3136 'N', -- bea category
3137 'N', -- deficiency flag
3138 'N', -- function flag
3139 'Y', -- govt not govt
3140 'N', -- exch non exch flag
3141 'N', -- cust non cust
3142 'Y', -- budget subfunction
3143 'N', -- advance flag
3144 'N', -- transfer flag
3145 sysdate, -- creation_date
3146 FND_GLOBAL.USER_ID, -- created by
3147 sysdate, -- last update date
3148 FND_GLOBAL.USER_ID, -- last updated by
3149 FND_GLOBAL.USER_ID -- last updated login
3150 );
3151 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3152 SGL_ATTRIBUTES_ID,
3153 FACTS_ACCT_NUMBER,
3154 USSGL_ACCT_NUMBER,
3155 BALANCE_TYPE,
3156 AUTHORITY_TYPE,
3157 DEFINITE_INDEFINITE_FLAG,
3158 LEGISLATIVE_INDICATOR,
3159 PUBLIC_LAW_CODE,
3160 APPORTIONMENT_CATEGORY,
3161 REIMBURSEABLE_FLAG,
3162 AVAILABILITY_TIME,
3163 TRANSACTION_PARTNER,
3164 BORROWING_SOURCE,
3165 BEA_CATEGORY,
3166 DEFICIENCY_FLAG,
3167 FUNCTION_FLAG,
3168 GOVT_NON_GOVT,
3169 EXCH_NON_EXCH,
3170 CUST_NON_CUST,
3171 BUDGET_SUBFUNCTION,
3172 ADVANCE_FLAG,
3173 TRANSFER_FLAG,
3174 CREATION_DATE,
3175 CREATED_BY,
3176 LAST_UPDATE_DATE,
3177 LAST_UPDATED_BY,
3178 LAST_UPDATE_LOGIN)
3179 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3180 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3181 '6850', -- facct account number
3182 '6850', -- ussgl account number
3183 'E', -- balance type
3184 'N', -- authority type
3185 'N', -- definie indefinite flag
3186 'N', -- legislative indicator
3187 'N', -- public law code
3188 'N', -- apportionmnet category
3189 'N', -- reimburseable flag
3190 'N', -- availability time
3191 'N', -- transaction partner
3192 'N', -- borrowing source
3193 'N', -- bea category
3194 'N', -- deficiency flag
3195 'N', -- function flag
3196 'F', -- govt not govt
3197 'N', -- exch non exch flag
3198 'N', -- cust non cust
3199 'Y', -- budget subfunction
3200 'N', -- advance flag
3201 'N', -- transfer flag
3202 sysdate, -- creation_date
3203 FND_GLOBAL.USER_ID, -- created by
3204 sysdate, -- last update date
3205 FND_GLOBAL.USER_ID, -- last updated by
3206 FND_GLOBAL.USER_ID -- last updated login
3207 );
3208 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3209 SGL_ATTRIBUTES_ID,
3210 FACTS_ACCT_NUMBER,
3211 USSGL_ACCT_NUMBER,
3212 BALANCE_TYPE,
3213 AUTHORITY_TYPE,
3214 DEFINITE_INDEFINITE_FLAG,
3215 LEGISLATIVE_INDICATOR,
3216 PUBLIC_LAW_CODE,
3217 APPORTIONMENT_CATEGORY,
3218 REIMBURSEABLE_FLAG,
3219 AVAILABILITY_TIME,
3220 TRANSACTION_PARTNER,
3221 BORROWING_SOURCE,
3222 BEA_CATEGORY,
3223 DEFICIENCY_FLAG,
3224 FUNCTION_FLAG,
3225 GOVT_NON_GOVT,
3226 EXCH_NON_EXCH,
3227 CUST_NON_CUST,
3228 BUDGET_SUBFUNCTION,
3229 ADVANCE_FLAG,
3230 TRANSFER_FLAG,
3231 CREATION_DATE,
3232 CREATED_BY,
3233 LAST_UPDATE_DATE,
3234 LAST_UPDATED_BY,
3235 LAST_UPDATE_LOGIN)
3236 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3240 'E', -- balance type
3237 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3238 '6900', -- facct account number
3239 '6900', -- ussgl account number
3241 'N', -- authority type
3242 'N', -- definie indefinite flag
3243 'N', -- legislative indicator
3244 'N', -- public law code
3245 'N', -- apportionmnet category
3246 'N', -- reimburseable flag
3247 'N', -- availability time
3248 'N', -- transaction partner
3249 'N', -- borrowing source
3250 'N', -- bea category
3251 'N', -- deficiency flag
3252 'N', -- function flag
3253 'Y', -- govt not govt
3254 'N', -- exch non exch flag
3255 'N', -- cust non cust
3256 'Y', -- budget subfunction
3257 'N', -- advance flag
3258 'N', -- transfer flag
3259 sysdate, -- creation_date
3260 FND_GLOBAL.USER_ID, -- created by
3261 sysdate, -- last update date
3262 FND_GLOBAL.USER_ID, -- last updated by
3263 FND_GLOBAL.USER_ID -- last updated login
3264 );
3265 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3266 SGL_ATTRIBUTES_ID,
3267 FACTS_ACCT_NUMBER,
3268 USSGL_ACCT_NUMBER,
3269 BALANCE_TYPE,
3270 AUTHORITY_TYPE,
3271 DEFINITE_INDEFINITE_FLAG,
3272 LEGISLATIVE_INDICATOR,
3273 PUBLIC_LAW_CODE,
3274 APPORTIONMENT_CATEGORY,
3275 REIMBURSEABLE_FLAG,
3276 AVAILABILITY_TIME,
3277 TRANSACTION_PARTNER,
3278 BORROWING_SOURCE,
3279 BEA_CATEGORY,
3280 DEFICIENCY_FLAG,
3281 FUNCTION_FLAG,
3282 GOVT_NON_GOVT,
3283 EXCH_NON_EXCH,
3284 CUST_NON_CUST,
3285 BUDGET_SUBFUNCTION,
3286 ADVANCE_FLAG,
3287 TRANSFER_FLAG,
3288 CREATION_DATE,
3289 CREATED_BY,
3290 LAST_UPDATE_DATE,
3291 LAST_UPDATED_BY,
3292 LAST_UPDATE_LOGIN)
3293 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3294 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3295 '7110', -- facct account number
3296 '7110', -- ussgl account number
3297 'E', -- balance type
3298 'N', -- authority type
3299 'N', -- definie indefinite flag
3300 'N', -- legislative indicator
3301 'N', -- public law code
3302 'N', -- apportionmnet category
3303 'N', -- reimburseable flag
3304 'N', -- availability time
3305 'N', -- transaction partner
3306 'N', -- borrowing source
3307 'N', -- bea category
3308 'N', -- deficiency flag
3309 'N', -- function flag
3310 'Y', -- govt not govt
3311 'Y', -- exch non exch flag
3312 'N', -- cust non cust
3313 'Y', -- budget subfunction
3314 'N', -- advance flag
3315 'N', -- transfer flag
3316 sysdate, -- creation_date
3317 FND_GLOBAL.USER_ID, -- created by
3318 sysdate, -- last update date
3319 FND_GLOBAL.USER_ID, -- last updated by
3320 FND_GLOBAL.USER_ID -- last updated login
3321 );
3322 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3323 SGL_ATTRIBUTES_ID,
3324 FACTS_ACCT_NUMBER,
3325 USSGL_ACCT_NUMBER,
3326 BALANCE_TYPE,
3327 AUTHORITY_TYPE,
3328 DEFINITE_INDEFINITE_FLAG,
3329 LEGISLATIVE_INDICATOR,
3330 PUBLIC_LAW_CODE,
3331 APPORTIONMENT_CATEGORY,
3332 REIMBURSEABLE_FLAG,
3333 AVAILABILITY_TIME,
3334 TRANSACTION_PARTNER,
3335 BORROWING_SOURCE,
3336 BEA_CATEGORY,
3337 DEFICIENCY_FLAG,
3338 FUNCTION_FLAG,
3339 GOVT_NON_GOVT,
3340 EXCH_NON_EXCH,
3341 CUST_NON_CUST,
3342 BUDGET_SUBFUNCTION,
3343 ADVANCE_FLAG,
3344 TRANSFER_FLAG,
3345 CREATION_DATE,
3346 CREATED_BY,
3347 LAST_UPDATE_DATE,
3348 LAST_UPDATED_BY,
3349 LAST_UPDATE_LOGIN)
3350 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3351 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3352 '7180', -- facct account number
3353 '7180', -- ussgl account number
3354 'E', -- balance type
3355 'N', -- authority type
3356 'N', -- definie indefinite flag
3357 'N', -- legislative indicator
3358 'N', -- public law code
3359 'N', -- apportionmnet category
3360 'N', -- reimburseable flag
3361 'N', -- availability time
3362 'N', -- transaction partner
3363 'N', -- borrowing source
3364 'N', -- bea category
3365 'N', -- deficiency flag
3366 'N', -- function flag
3367 'Y', -- govt not govt
3368 'Y', -- exch non exch flag
3369 'N', -- cust non cust
3370 'N', -- budget subfunction
3371 'N', -- advance flag
3372 'N', -- transfer flag
3373 sysdate, -- creation_date
3374 FND_GLOBAL.USER_ID, -- created by
3375 sysdate, -- last update date
3376 FND_GLOBAL.USER_ID, -- last updated by
3377 FND_GLOBAL.USER_ID -- last updated login
3378 );
3379 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3380 SGL_ATTRIBUTES_ID,
3381 FACTS_ACCT_NUMBER,
3382 USSGL_ACCT_NUMBER,
3383 BALANCE_TYPE,
3384 AUTHORITY_TYPE,
3385 DEFINITE_INDEFINITE_FLAG,
3386 LEGISLATIVE_INDICATOR,
3387 PUBLIC_LAW_CODE,
3388 APPORTIONMENT_CATEGORY,
3389 REIMBURSEABLE_FLAG,
3390 AVAILABILITY_TIME,
3391 TRANSACTION_PARTNER,
3392 BORROWING_SOURCE,
3393 BEA_CATEGORY,
3394 DEFICIENCY_FLAG,
3395 FUNCTION_FLAG,
3396 GOVT_NON_GOVT,
3397 EXCH_NON_EXCH,
3398 CUST_NON_CUST,
3399 BUDGET_SUBFUNCTION,
3400 ADVANCE_FLAG,
3404 LAST_UPDATE_DATE,
3401 TRANSFER_FLAG,
3402 CREATION_DATE,
3403 CREATED_BY,
3405 LAST_UPDATED_BY,
3406 LAST_UPDATE_LOGIN)
3407 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3408 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3409 '7190', -- facct account number
3410 '7190', -- ussgl account number
3411 'E', -- balance type
3412 'N', -- authority type
3413 'N', -- definie indefinite flag
3414 'N', -- legislative indicator
3415 'N', -- public law code
3416 'N', -- apportionmnet category
3417 'N', -- reimburseable flag
3418 'N', -- availability time
3419 'N', -- transaction partner
3420 'N', -- borrowing source
3421 'N', -- bea category
3422 'N', -- deficiency flag
3423 'N', -- function flag
3424 'Y', -- govt not govt
3425 'Y', -- exch non exch flag
3426 'N', -- cust non cust
3427 'Y', -- budget subfunction
3428 'N', -- advance flag
3429 'N', -- transfer flag
3430 sysdate, -- creation_date
3431 FND_GLOBAL.USER_ID, -- created by
3432 sysdate, -- last update date
3433 FND_GLOBAL.USER_ID, -- last updated by
3434 FND_GLOBAL.USER_ID -- last updated login
3435 );
3436 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3437 SGL_ATTRIBUTES_ID,
3438 FACTS_ACCT_NUMBER,
3439 USSGL_ACCT_NUMBER,
3440 BALANCE_TYPE,
3441 AUTHORITY_TYPE,
3442 DEFINITE_INDEFINITE_FLAG,
3443 LEGISLATIVE_INDICATOR,
3444 PUBLIC_LAW_CODE,
3445 APPORTIONMENT_CATEGORY,
3446 REIMBURSEABLE_FLAG,
3447 AVAILABILITY_TIME,
3448 TRANSACTION_PARTNER,
3449 BORROWING_SOURCE,
3450 BEA_CATEGORY,
3451 DEFICIENCY_FLAG,
3452 FUNCTION_FLAG,
3453 GOVT_NON_GOVT,
3454 EXCH_NON_EXCH,
3455 CUST_NON_CUST,
3456 BUDGET_SUBFUNCTION,
3457 ADVANCE_FLAG,
3458 TRANSFER_FLAG,
3459 CREATION_DATE,
3460 CREATED_BY,
3461 LAST_UPDATE_DATE,
3462 LAST_UPDATED_BY,
3463 LAST_UPDATE_LOGIN)
3464 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3465 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3466 '7210', -- facct account number
3467 '7210', -- ussgl account number
3468 'E', -- balance type
3469 'N', -- authority type
3470 'N', -- definie indefinite flag
3471 'N', -- legislative indicator
3472 'N', -- public law code
3473 'N', -- apportionmnet category
3474 'N', -- reimburseable flag
3475 'N', -- availability time
3476 'N', -- transaction partner
3477 'N', -- borrowing source
3478 'N', -- bea category
3479 'N', -- deficiency flag
3480 'N', -- function flag
3481 'Y', -- govt not govt
3482 'Y', -- exch non exch flag
3483 'N', -- cust non cust
3484 'Y', -- budget subfunction
3485 'N', -- advance flag
3486 'N', -- transfer flag
3487 sysdate, -- creation_date
3488 FND_GLOBAL.USER_ID, -- created by
3489 sysdate, -- last update date
3490 FND_GLOBAL.USER_ID, -- last updated by
3491 FND_GLOBAL.USER_ID -- last updated login
3492 );
3493 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3494 SGL_ATTRIBUTES_ID,
3495 FACTS_ACCT_NUMBER,
3496 USSGL_ACCT_NUMBER,
3497 BALANCE_TYPE,
3498 AUTHORITY_TYPE,
3499 DEFINITE_INDEFINITE_FLAG,
3500 LEGISLATIVE_INDICATOR,
3501 PUBLIC_LAW_CODE,
3502 APPORTIONMENT_CATEGORY,
3503 REIMBURSEABLE_FLAG,
3504 AVAILABILITY_TIME,
3505 TRANSACTION_PARTNER,
3506 BORROWING_SOURCE,
3507 BEA_CATEGORY,
3508 DEFICIENCY_FLAG,
3509 FUNCTION_FLAG,
3510 GOVT_NON_GOVT,
3511 EXCH_NON_EXCH,
3512 CUST_NON_CUST,
3513 BUDGET_SUBFUNCTION,
3514 ADVANCE_FLAG,
3515 TRANSFER_FLAG,
3516 CREATION_DATE,
3517 CREATED_BY,
3518 LAST_UPDATE_DATE,
3519 LAST_UPDATED_BY,
3520 LAST_UPDATE_LOGIN)
3521 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3522 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3523 '7280', -- facct account number
3524 '7280', -- ussgl account number
3525 'E', -- balance type
3526 'N', -- authority type
3527 'N', -- definie indefinite flag
3528 'N', -- legislative indicator
3529 'N', -- public law code
3530 'N', -- apportionmnet category
3531 'N', -- reimburseable flag
3532 'N', -- availability time
3533 'N', -- transaction partner
3534 'N', -- borrowing source
3535 'N', -- bea category
3536 'N', -- deficiency flag
3537 'N', -- function flag
3538 'Y', -- govt not govt
3539 'Y', -- exch non exch flag
3540 'N', -- cust non cust
3541 'N', -- budget subfunction
3542 'N', -- advance flag
3543 'N', -- transfer flag
3544 sysdate, -- creation_date
3545 FND_GLOBAL.USER_ID, -- created by
3546 sysdate, -- last update date
3547 FND_GLOBAL.USER_ID, -- last updated by
3548 FND_GLOBAL.USER_ID -- last updated login
3549 );
3550 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3551 SGL_ATTRIBUTES_ID,
3552 FACTS_ACCT_NUMBER,
3553 USSGL_ACCT_NUMBER,
3554 BALANCE_TYPE,
3555 AUTHORITY_TYPE,
3556 DEFINITE_INDEFINITE_FLAG,
3557 LEGISLATIVE_INDICATOR,
3558 PUBLIC_LAW_CODE,
3559 APPORTIONMENT_CATEGORY,
3560 REIMBURSEABLE_FLAG,
3561 AVAILABILITY_TIME,
3562 TRANSACTION_PARTNER,
3563 BORROWING_SOURCE,
3567 GOVT_NON_GOVT,
3564 BEA_CATEGORY,
3565 DEFICIENCY_FLAG,
3566 FUNCTION_FLAG,
3568 EXCH_NON_EXCH,
3569 CUST_NON_CUST,
3570 BUDGET_SUBFUNCTION,
3571 ADVANCE_FLAG,
3572 TRANSFER_FLAG,
3573 CREATION_DATE,
3574 CREATED_BY,
3575 LAST_UPDATE_DATE,
3576 LAST_UPDATED_BY,
3577 LAST_UPDATE_LOGIN)
3578 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3579 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3580 '7290', -- facct account number
3581 '7290', -- ussgl account number
3582 'E', -- balance type
3583 'N', -- authority type
3584 'N', -- definie indefinite flag
3585 'N', -- legislative indicator
3586 'N', -- public law code
3587 'N', -- apportionmnet category
3588 'N', -- reimburseable flag
3589 'N', -- availability time
3590 'N', -- transaction partner
3591 'N', -- borrowing source
3592 'N', -- bea category
3593 'N', -- deficiency flag
3594 'N', -- function flag
3595 'Y', -- govt not govt
3596 'Y', -- exch non exch flag
3597 'N', -- cust non cust
3598 'Y', -- budget subfunction
3599 'N', -- advance flag
3600 'N', -- transfer flag
3601 sysdate, -- creation_date
3602 FND_GLOBAL.USER_ID, -- created by
3603 sysdate, -- last update date
3604 FND_GLOBAL.USER_ID, -- last updated by
3605 FND_GLOBAL.USER_ID -- last updated login
3606 );
3607 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3608 SGL_ATTRIBUTES_ID,
3609 FACTS_ACCT_NUMBER,
3610 USSGL_ACCT_NUMBER,
3611 BALANCE_TYPE,
3612 AUTHORITY_TYPE,
3613 DEFINITE_INDEFINITE_FLAG,
3614 LEGISLATIVE_INDICATOR,
3615 PUBLIC_LAW_CODE,
3616 APPORTIONMENT_CATEGORY,
3617 REIMBURSEABLE_FLAG,
3618 AVAILABILITY_TIME,
3619 TRANSACTION_PARTNER,
3620 BORROWING_SOURCE,
3621 BEA_CATEGORY,
3622 DEFICIENCY_FLAG,
3623 FUNCTION_FLAG,
3624 GOVT_NON_GOVT,
3625 EXCH_NON_EXCH,
3626 CUST_NON_CUST,
3627 BUDGET_SUBFUNCTION,
3628 ADVANCE_FLAG,
3629 TRANSFER_FLAG,
3630 CREATION_DATE,
3631 CREATED_BY,
3632 LAST_UPDATE_DATE,
3633 LAST_UPDATED_BY,
3634 LAST_UPDATE_LOGIN)
3635 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3636 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3637 '7300', -- facct account number
3638 '7300', -- ussgl account number
3639 'E', -- balance type
3640 'N', -- authority type
3641 'N', -- definie indefinite flag
3642 'N', -- legislative indicator
3643 'N', -- public law code
3644 'N', -- apportionmnet category
3645 'N', -- reimburseable flag
3646 'N', -- availability time
3647 'N', -- transaction partner
3648 'N', -- borrowing source
3649 'N', -- bea category
3650 'N', -- deficiency flag
3651 'N', -- function flag
3652 'Y', -- govt not govt
3653 'N', -- exch non exch flag
3654 'N', -- cust non cust
3655 'Y', -- budget subfunction
3656 'N', -- advance flag
3657 'N', -- transfer flag
3658 sysdate, -- creation_date
3659 FND_GLOBAL.USER_ID, -- created by
3660 sysdate, -- last update date
3661 FND_GLOBAL.USER_ID, -- last updated by
3662 FND_GLOBAL.USER_ID -- last updated login
3663 );
3664 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3665 SGL_ATTRIBUTES_ID,
3666 FACTS_ACCT_NUMBER,
3667 USSGL_ACCT_NUMBER,
3668 BALANCE_TYPE,
3669 AUTHORITY_TYPE,
3670 DEFINITE_INDEFINITE_FLAG,
3671 LEGISLATIVE_INDICATOR,
3672 PUBLIC_LAW_CODE,
3673 APPORTIONMENT_CATEGORY,
3674 REIMBURSEABLE_FLAG,
3675 AVAILABILITY_TIME,
3676 TRANSACTION_PARTNER,
3677 BORROWING_SOURCE,
3678 BEA_CATEGORY,
3679 DEFICIENCY_FLAG,
3680 FUNCTION_FLAG,
3681 GOVT_NON_GOVT,
3682 EXCH_NON_EXCH,
3683 CUST_NON_CUST,
3684 BUDGET_SUBFUNCTION,
3685 ADVANCE_FLAG,
3686 TRANSFER_FLAG,
3687 CREATION_DATE,
3688 CREATED_BY,
3689 LAST_UPDATE_DATE,
3690 LAST_UPDATED_BY,
3691 LAST_UPDATE_LOGIN)
3692 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3693 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3694 '7400', -- facct account number
3695 '7400', -- ussgl account number
3696 'E', -- balance type
3697 'N', -- authority type
3698 'N', -- definie indefinite flag
3699 'N', -- legislative indicator
3700 'N', -- public law code
3701 'N', -- apportionmnet category
3702 'N', -- reimburseable flag
3703 'N', -- availability time
3704 'N', -- transaction partner
3705 'N', -- borrowing source
3706 'N', -- bea category
3707 'N', -- deficiency flag
3708 'N', -- function flag
3709 'Y', -- govt not govt
3710 'N', -- exch non exch flag
3711 'N', -- cust non cust
3712 'N', -- budget subfunction
3713 'N', -- advance flag
3714 'N', -- transfer flag
3715 sysdate, -- creation_date
3716 FND_GLOBAL.USER_ID, -- created by
3717 sysdate, -- last update date
3718 FND_GLOBAL.USER_ID, -- last updated by
3719 FND_GLOBAL.USER_ID -- last updated login
3720 );
3721 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3722 SGL_ATTRIBUTES_ID,
3723 FACTS_ACCT_NUMBER,
3724 USSGL_ACCT_NUMBER,
3725 BALANCE_TYPE,
3726 AUTHORITY_TYPE,
3727 DEFINITE_INDEFINITE_FLAG,
3731 REIMBURSEABLE_FLAG,
3728 LEGISLATIVE_INDICATOR,
3729 PUBLIC_LAW_CODE,
3730 APPORTIONMENT_CATEGORY,
3732 AVAILABILITY_TIME,
3733 TRANSACTION_PARTNER,
3734 BORROWING_SOURCE,
3735 BEA_CATEGORY,
3736 DEFICIENCY_FLAG,
3737 FUNCTION_FLAG,
3738 GOVT_NON_GOVT,
3739 EXCH_NON_EXCH,
3740 CUST_NON_CUST,
3741 BUDGET_SUBFUNCTION,
3742 ADVANCE_FLAG,
3743 TRANSFER_FLAG,
3744 CREATION_DATE,
3745 CREATED_BY,
3746 LAST_UPDATE_DATE,
3747 LAST_UPDATED_BY,
3748 LAST_UPDATE_LOGIN)
3749 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3750 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3751 '7500', -- facct account number
3752 '7500', -- ussgl account number
3753 'E', -- balance type
3754 'N', -- authority type
3755 'N', -- definie indefinite flag
3756 'N', -- legislative indicator
3757 'N', -- public law code
3758 'N', -- apportionmnet category
3759 'N', -- reimburseable flag
3760 'N', -- availability time
3761 'N', -- transaction partner
3762 'N', -- borrowing source
3763 'N', -- bea category
3764 'N', -- deficiency flag
3765 'N', -- function flag
3766 'Y', -- govt not govt
3767 'Y', -- exch non exch flag
3768 'N', -- cust non cust
3769 'Y', -- budget subfunction
3770 'N', -- advance flag
3771 'N', -- transfer flag
3772 sysdate, -- creation_date
3773 FND_GLOBAL.USER_ID, -- created by
3774 sysdate, -- last update date
3775 FND_GLOBAL.USER_ID, -- last updated by
3776 FND_GLOBAL.USER_ID -- last updated login
3777 );
3778 INSERT INTO FV_FACTS_ATTRIBUTES (SET_OF_BOOKS_ID,
3779 SGL_ATTRIBUTES_ID,
3780 FACTS_ACCT_NUMBER,
3781 USSGL_ACCT_NUMBER,
3782 BALANCE_TYPE,
3783 AUTHORITY_TYPE,
3784 DEFINITE_INDEFINITE_FLAG,
3785 LEGISLATIVE_INDICATOR,
3786 PUBLIC_LAW_CODE,
3787 APPORTIONMENT_CATEGORY,
3788 REIMBURSEABLE_FLAG,
3789 AVAILABILITY_TIME,
3790 TRANSACTION_PARTNER,
3791 BORROWING_SOURCE,
3792 BEA_CATEGORY,
3793 DEFICIENCY_FLAG,
3794 FUNCTION_FLAG,
3795 GOVT_NON_GOVT,
3796 EXCH_NON_EXCH,
3797 CUST_NON_CUST,
3798 BUDGET_SUBFUNCTION,
3799 ADVANCE_FLAG,
3800 TRANSFER_FLAG,
3801 CREATION_DATE,
3802 CREATED_BY,
3803 LAST_UPDATE_DATE,
3804 LAST_UPDATED_BY,
3805 LAST_UPDATE_LOGIN)
3806 VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
3807 FV_FACTS_ATTRIBUTES_S.NEXTVAL, -- SGL_ATTRIBUTES_ID
3808 '7600', -- facct account number
3809 '7600', -- ussgl account number
3810 'E', -- balance type
3811 'N', -- authority type
3812 'N', -- definie indefinite flag
3813 'N', -- legislative indicator
3814 'N', -- public law code
3815 'N', -- apportionmnet category
3816 'N', -- reimburseable flag
3817 'N', -- availability time
3818 'N', -- transaction partner
3819 'N', -- borrowing source
3820 'N', -- bea category
3821 'N', -- deficiency flag
3822 'N', -- function flag
3823 'N', -- govt not govt
3824 'N', -- exch non exch flag
3825 'N', -- cust non cust
3826 'Y', -- budget subfunction
3827 'N', -- advance flag
3828 'N', -- transfer flag
3829 sysdate, -- creation_date
3830 FND_GLOBAL.USER_ID, -- created by
3831 sysdate, -- last update date
3832 FND_GLOBAL.USER_ID, -- last updated by
3833 FND_GLOBAL.USER_ID -- last updated login
3834 );
3835
3836 Exception
3837 When Others Then
3838 errbuf := substr(SQLERRM,1,225);
3839 retcode := -1;
3840 END;
3841 End;