eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FVFCRT7B dependencies on FND_PROFILE

Line 11: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

7: v_sob_name Varchar2(100);
8: begin
9: -- Verify that the table is not already seeded for an specific set_of_books
10:
11: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
12: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
13:
14: SELECT count(*)
15: INTO v_count

Line 12: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');

8: begin
9: -- Verify that the table is not already seeded for an specific set_of_books
10:
11: v_sob := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
12: v_sob_name := FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME');
13:
14: SELECT count(*)
15: INTO v_count
16: FROM fv_facts_rt7_codes

Line 36: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

32: CREATED_BY,
33: LAST_UPDATE_DATE,
34: LAST_UPDATED_BY,
35: LAST_UPDATE_LOGIN)
36: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
37: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
38: '911', -- Authorization code
39: ' ', -- RT7 borrowing source
40: 'Investments Purchased at a Discount - Unrealized Discount', -- Transaction Type

Line 60: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

56: CREATED_BY,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,
59: LAST_UPDATE_LOGIN)
60: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
61: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
62: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
63: 'E', -- Begin/End flag
64: '1611', -- USSGL Account

Line 83: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

79: CREATED_BY,
80: LAST_UPDATE_DATE,
81: LAST_UPDATED_BY,
82: LAST_UPDATE_LOGIN)
83: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
84: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
85: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
86: 'E', -- Begin/End flag
87: '1621', -- USSGL Account

Line 107: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

103: CREATED_BY,
104: LAST_UPDATE_DATE,
105: LAST_UPDATED_BY,
106: LAST_UPDATE_LOGIN)
107: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
108: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
109: '921', -- Authorization code
110: ' ', -- RT7 borrowing source
111: 'Funds Held Outside the Treasury - Imprest Funds', -- Transaction Type

Line 130: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

126: CREATED_BY,
127: LAST_UPDATE_DATE,
128: LAST_UPDATED_BY,
129: LAST_UPDATE_LOGIN)
130: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
131: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
132: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
133: 'E', -- Begin/End flag
134: '1120', -- USSGL Account

Line 153: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

149: CREATED_BY,
150: LAST_UPDATE_DATE,
151: LAST_UPDATED_BY,
152: LAST_UPDATE_LOGIN)
153: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
154: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
155: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
156: 'E', -- Begin/End flag
157: '1130', -- USSGL Account

Line 178: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

174: CREATED_BY,
175: LAST_UPDATE_DATE,
176: LAST_UPDATED_BY,
177: LAST_UPDATE_LOGIN)
178: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
179: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
180: '931', -- Authorization code
181: ' ', -- RT7 borrowing source
182: 'Investments Purchased at a Discount - Unamortized Premium and Discount', -- Transaction Type

Line 201: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

197: CREATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATED_BY,
200: LAST_UPDATE_LOGIN)
201: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
202: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
203: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
204: 'E', -- Begin/End flag
205: '1611', -- USSGL Account

Line 224: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

220: CREATED_BY,
221: LAST_UPDATE_DATE,
222: LAST_UPDATED_BY,
223: LAST_UPDATE_LOGIN)
224: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
225: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
226: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
227: 'E', -- Begin/End flag
228: '1612', -- USSGL Account

Line 247: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

243: CREATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATED_BY,
246: LAST_UPDATE_LOGIN)
247: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
248: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
249: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
250: 'E', -- Begin/End flag
251: '1613', -- USSGL Account

Line 271: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

267: CREATED_BY,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,
270: LAST_UPDATE_LOGIN)
271: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
272: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
273: '941', -- Authorization code
274: ' ', -- RT7 borrowing source
275: 'Unfunded Contract Authority', -- Transaction Type

Line 294: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

290: CREATED_BY,
291: LAST_UPDATE_DATE,
292: LAST_UPDATED_BY,
293: LAST_UPDATE_LOGIN)
294: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
295: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
296: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
297: 'E', -- Begin/End flag
298: '4032', -- USSGL Account

Line 318: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

314: CREATED_BY,
315: LAST_UPDATE_DATE,
316: LAST_UPDATED_BY,
317: LAST_UPDATE_LOGIN)
318: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
319: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
320: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
321: 'E', -- Begin/End flag
322: '4034', -- USSGL Account

Line 342: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

338: CREATED_BY,
339: LAST_UPDATE_DATE,
340: LAST_UPDATED_BY,
341: LAST_UPDATE_LOGIN)
342: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
343: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
344: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
345: 'E', -- Begin/End flag
346: '4131', -- USSGL Account

Line 366: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

362: CREATED_BY,
363: LAST_UPDATE_DATE,
364: LAST_UPDATED_BY,
365: LAST_UPDATE_LOGIN)
366: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
367: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
368: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
369: 'E', -- Begin/End flag
370: '4132', -- USSGL Account

Line 390: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

386: CREATED_BY,
387: LAST_UPDATE_DATE,
388: LAST_UPDATED_BY,
389: LAST_UPDATE_LOGIN)
390: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
391: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
392: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
393: 'E', -- Begin/End flag
394: '4133', -- USSGL Account

Line 414: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

410: CREATED_BY,
411: LAST_UPDATE_DATE,
412: LAST_UPDATED_BY,
413: LAST_UPDATE_LOGIN)
414: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
415: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
416: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
417: 'E', -- Begin/End flag
418: '4135', -- USSGL Account

Line 438: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

434: CREATED_BY,
435: LAST_UPDATE_DATE,
436: LAST_UPDATED_BY,
437: LAST_UPDATE_LOGIN)
438: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
439: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
440: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
441: 'E', -- Begin/End flag
442: '4138', -- USSGL Account

Line 462: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

458: CREATED_BY,
459: LAST_UPDATE_DATE,
460: LAST_UPDATED_BY,
461: LAST_UPDATE_LOGIN)
462: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
463: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
464: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
465: 'B', -- Begin/End flag
466: '4139', -- USSGL Account

Line 486: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

482: CREATED_BY,
483: LAST_UPDATE_DATE,
484: LAST_UPDATED_BY,
485: LAST_UPDATE_LOGIN)
486: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
487: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
488: '951', -- Authorization code
489: 'T', -- RT7 borrowing source
490: 'Authority to Borrow from the Treasury', -- Transaction Type

Line 509: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

505: CREATED_BY,
506: LAST_UPDATE_DATE,
507: LAST_UPDATED_BY,
508: LAST_UPDATE_LOGIN)
509: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
510: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
511: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
512: 'E', -- Begin/End flag
513: '4042', -- USSGL Account

Line 533: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

529: CREATED_BY,
530: LAST_UPDATE_DATE,
531: LAST_UPDATED_BY,
532: LAST_UPDATE_LOGIN)
533: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
534: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
535: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
536: 'E', -- Begin/End flag
537: '4044', -- USSGL Account

Line 557: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

553: CREATED_BY,
554: LAST_UPDATE_DATE,
555: LAST_UPDATED_BY,
556: LAST_UPDATE_LOGIN)
557: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
558: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
559: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
560: 'E', -- Begin/End flag
561: '4141', -- USSGL Account

Line 581: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

577: CREATED_BY,
578: LAST_UPDATE_DATE,
579: LAST_UPDATED_BY,
580: LAST_UPDATE_LOGIN)
581: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
582: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
583: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
584: 'E', -- Begin/End flag
585: '4142', -- USSGL Account

Line 605: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

601: CREATED_BY,
602: LAST_UPDATE_DATE,
603: LAST_UPDATED_BY,
604: LAST_UPDATE_LOGIN)
605: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
606: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
607: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
608: 'E', -- Begin/End flag
609: '4143', -- USSGL Account

Line 629: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

625: CREATED_BY,
626: LAST_UPDATE_DATE,
627: LAST_UPDATED_BY,
628: LAST_UPDATE_LOGIN)
629: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
630: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
631: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
632: 'E', -- Begin/End flag
633: '4145', -- USSGL Account

Line 653: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

649: CREATED_BY,
650: LAST_UPDATE_DATE,
651: LAST_UPDATED_BY,
652: LAST_UPDATE_LOGIN)
653: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
654: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
655: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
656: 'E', -- Begin/End flag
657: '4148', -- USSGL Account

Line 677: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

673: CREATED_BY,
674: LAST_UPDATE_DATE,
675: LAST_UPDATED_BY,
676: LAST_UPDATE_LOGIN)
677: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
678: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
679: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
680: 'B', -- Begin/End flag
681: '4149', -- USSGL Account

Line 701: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

697: CREATED_BY,
698: LAST_UPDATE_DATE,
699: LAST_UPDATED_BY,
700: LAST_UPDATE_LOGIN)
701: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
702: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
703: '962', -- Authorization code
704: 'P', -- RT7 borrowing source
705: 'Authority to Borrow from the Public', -- Transaction Type

Line 724: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

720: CREATED_BY,
721: LAST_UPDATE_DATE,
722: LAST_UPDATED_BY,
723: LAST_UPDATE_LOGIN)
724: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
725: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
726: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
727: 'E', -- Begin/End flag
728: '4042', -- USSGL Account

Line 748: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

744: CREATED_BY,
745: LAST_UPDATE_DATE,
746: LAST_UPDATED_BY,
747: LAST_UPDATE_LOGIN)
748: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
749: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
750: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
751: 'E', -- Begin/End flag
752: '4044', -- USSGL Account

Line 772: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

768: CREATED_BY,
769: LAST_UPDATE_DATE,
770: LAST_UPDATED_BY,
771: LAST_UPDATE_LOGIN)
772: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
773: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
774: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
775: 'E', -- Begin/End flag
776: '4141', -- USSGL Account

Line 796: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

792: CREATED_BY,
793: LAST_UPDATE_DATE,
794: LAST_UPDATED_BY,
795: LAST_UPDATE_LOGIN)
796: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
797: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
798: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
799: 'E', -- Begin/End flag
800: '4142', -- USSGL Account

Line 820: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

816: CREATED_BY,
817: LAST_UPDATE_DATE,
818: LAST_UPDATED_BY,
819: LAST_UPDATE_LOGIN)
820: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
821: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
822: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
823: 'E', -- Begin/End flag
824: '4143', -- USSGL Account

Line 844: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

840: CREATED_BY,
841: LAST_UPDATE_DATE,
842: LAST_UPDATED_BY,
843: LAST_UPDATE_LOGIN)
844: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
845: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
846: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
847: 'E', -- Begin/End flag
848: '4145', -- USSGL Account

Line 868: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

864: CREATED_BY,
865: LAST_UPDATE_DATE,
866: LAST_UPDATED_BY,
867: LAST_UPDATE_LOGIN)
868: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
869: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
870: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
871: 'E', -- Begin/End flag
872: '4148', -- USSGL Account

Line 892: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

888: CREATED_BY,
889: LAST_UPDATE_DATE,
890: LAST_UPDATED_BY,
891: LAST_UPDATE_LOGIN)
892: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
893: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
894: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
895: 'B', -- Begin/End flag
896: '4149', -- USSGL Account

Line 916: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

912: CREATED_BY,
913: LAST_UPDATE_DATE,
914: LAST_UPDATED_BY,
915: LAST_UPDATE_LOGIN)
916: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
917: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
918: '971', -- Authorization code
919: ' ', -- RT7 borrowing source
920: 'Investments in Public Debt Securities', -- Transaction Type

Line 939: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

935: CREATED_BY,
936: LAST_UPDATE_DATE,
937: LAST_UPDATED_BY,
938: LAST_UPDATE_LOGIN)
939: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
940: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
941: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
942: 'E', -- Begin/End flag
943: '1610', -- USSGL Account

Line 963: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

959: CREATED_BY,
960: LAST_UPDATE_DATE,
961: LAST_UPDATED_BY,
962: LAST_UPDATE_LOGIN)
963: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
964: FV_FACTS_RT7_CODES_S.NEXTVAL, -- RT7 header id
965: '972', -- Authorization code
966: ' ', -- RT7 borrowing source
967: 'Investments in Agency Securities', -- Transaction Type

Line 987: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob

983: CREATED_BY,
984: LAST_UPDATE_DATE,
985: LAST_UPDATED_BY,
986: LAST_UPDATE_LOGIN)
987: VALUES (TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')), -- sob
988: FV_FACTS_RT7_ACCOUNTS_S.NEXTVAL, -- RT7 DETAIL id
989: FV_FACTS_RT7_CODES_S.CURRVAL, -- RT7 HEADER ID
990: 'E', -- Begin/End flag
991: '1620', -- USSGL Account