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.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FV_TREASURY_SYMBOLS

Line 414: FROM fv_agency_id_map m, fv_treasury_symbols tas

410: SELECT f.treasury_dept_code, f.treasury_acct_code
411: FROM fv_facts_federal_accounts f
412: WHERE NOT EXISTS
413: (SELECT *
414: FROM fv_agency_id_map m, fv_treasury_symbols tas
415: WHERE tas.FEDERAL_ACCT_SYMBOL_ID = f.FEDERAL_ACCT_SYMBOL_ID
416: AND m.star_dept_reg = f.treasury_dept_code
417: AND m.star_main_acct = f.treasury_acct_code
418: AND m.star_dept_reg = tas.department_id

Line 432: FROM fv_facts_federal_accounts f, fv_treasury_symbols t

428: */
429: CURSOR c_aid_NOT_exISts IS
430: SELECT DISTINCT f.set_of_books_id, f.treasury_dept_code, f.treasury_acct_code,
431: t.TAFS_SUB_ACCT, t.dept_transfer
432: FROM fv_facts_federal_accounts f, fv_treasury_symbols t
433: WHERE f.federal_acct_symbol_id = t.federal_acct_symbol_id
434: AND NOT EXISTS
435: (SELECT 1
436: FROM fv_agency_id_map m

Line 450: FROM fv_agency_id_map m, fv_facts_federal_accounts f, fv_treasury_symbols t

446: treasury_dept_code, treasury_acct_code, f.federal_acct_symbol_id,
447: treasury_symbol_id, tafs_sub_acct, department_id, dept_transfer,
448: fund_group_code, aid,ata, f.start_date start_date, f.SET_of_books_id SET_of_books_id,
449: federal_acct_symbol_name
450: FROM fv_agency_id_map m, fv_facts_federal_accounts f, fv_treasury_symbols t
451: WHERE m.star_dept_reg = f.treasury_dept_code
452: AND m.star_main_acct = f.treasury_acct_code
453: AND f.federal_acct_symbol_id = t.federal_acct_symbol_id(+)
454: AND ((t.tafs_sub_acct IS NULL) OR (t.tafs_sub_acct IS NOT NULL AND t.tafs_sub_acct=sub));

Line 496: UPDATE fv_treasury_symbols

492: IF rec.sub IS NULL THEN
493: -- 1)Upgrade to new allocation agency id when there is a match between
494: -- star_dept_reg and agency id, star_main_acct and main account,
495: -- star_dept_xfer and allocation transfer agency id, sub and sub account code
496: UPDATE fv_treasury_symbols
497: SET dept_transfer = rec.ata
498: WHERE treasury_symbol_id = rec.treasury_symbol_id
499: AND dept_transfer = rec.star_dept_xfer
500: AND department_id = rec.star_dept_reg

Line 503: UPDATE fv_treasury_symbols

499: AND dept_transfer = rec.star_dept_xfer
500: AND department_id = rec.star_dept_reg
501: AND fund_group_code = rec.star_main_acct;
502: ELSE
503: UPDATE fv_treasury_symbols
504: SET dept_transfer = rec.ata
505: WHERE treasury_symbol_id = rec.treasury_symbol_id
506: AND dept_transfer = rec.star_dept_xfer
507: AND department_id = rec.star_dept_reg

Line 528: SELECT count(*) INTO cnt1 FROM fv_Treasury_symbols

524: AND m.aid <> rec.aid
525: AND (m.sub IS NOT NULL AND m.sub <> rec.sub);
526:
527: IF cnt > 0 THEN
528: SELECT count(*) INTO cnt1 FROM fv_Treasury_symbols
529: WHERE treasury_symbol_id <> rec.treasury_symbol_id
530: AND department_id = rec.star_dept_reg
531: AND fund_group_code = rec.star_main_acct
532: AND tafs_sub_acct <> rec.sub;

Line 541: UPDATE fv_treasury_symbols

537: from fv_facts_federal_accounts
538: where treasury_dept_code = rec.aid
539: and treasury_acct_code = rec.star_main_acct;
540:
541: UPDATE fv_treasury_symbols
542: SET department_id = rec.aid,
543: federal_acct_symbol_id = l_FEDERAL_ACCT_SYMBOL_ID
544: WHERE treasury_symbol_id = rec.treasury_symbol_id;
545: l_UPDATE_fed_tas := false;

Line 577: UPDATE fv_treasury_symbols

573: WHEN OTHERS THEN
574: fnd_file.put_line(fnd_file.log,SQLERRM);
575: END;
576:
577: UPDATE fv_treasury_symbols
578: SET department_id = rec.aid,
579: federal_acct_symbol_id = l_federal_seq
580: WHERE treasury_symbol_id = rec.treasury_symbol_id;
581:

Line 605: UPDATE Fv_Treasury_Symbols

601: WHERE treasury_dept_code = rec.aid
602: AND treasury_acct_code = rec.treasury_acct_code
603: AND federal_acct_symbol_id <> rec.federal_acct_symbol_id;
604:
605: UPDATE Fv_Treasury_Symbols
606: SET federal_acct_symbol_id = l_federal_acct_symbol_id,
607: department_id = rec.aid
608: WHERE Treasury_Symbol_Id = rec.Treasury_Symbol_Id;
609:

Line 617: UPDATE fv_treasury_symbols

613: WHERE federal_acct_symbol_id = rec.federal_acct_symbol_id;
614:
615:
616: IF rec.treasury_symbol_id IS NOT NULL THEN
617: UPDATE fv_treasury_symbols
618: SET department_id = rec.aid
619: WHERE federal_acct_symbol_id = rec.federal_acct_symbol_id
620: AND treasury_symbol_id = rec.treasury_symbol_id;
621:

Line 628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');

624: END IF;
625: END LOOP;
626:
627: fnd_file.put_line(fnd_file.log, 'Updating fv_facts_federal_accounts with new agency id');
628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');
629: fnd_file.put_line(fnd_file.log, 'Updated: '||SQL%ROWCOUNT||' rows.');
630:
631: EXCEPTION WHEN OTHERS THEN
632: g_err_buff := 'When OTHERS ERROR in upgrade_fed_accounts_agency_id: '||sqlerrm;

Line 708: UPDATE fv_treasury_symbols

704: -- 2) Upgrade Fund Type in Define Treasury Account Symbols form
705: BEGIN
706:
707: BEGIN
708: UPDATE fv_treasury_symbols
709: SET fund_type = 'EG'
710: WHERE (fund_group_code BETWEEN 0000 AND 3499 OR
711: fund_group_code BETWEEN 3600 AND 3799)
712: AND (receipt_account_indicator = 'N' OR

Line 721: UPDATE fv_treasury_symbols

717: 'When others error: '||l_module||' F Fund Type 1 upgrade'||' '||SQLERRM);
718: END;
719:
720: BEGIN
721: UPDATE fv_treasury_symbols
722: SET fund_type = 'UG'
723: WHERE (fund_group_code BETWEEN 0000 AND 3499 OR
724: fund_group_code BETWEEN 3600 AND 3799)
725: AND receipt_account_indicator = 'Y';

Line 733: UPDATE fv_treasury_symbols

729: 'When others error: '||l_module||' Fund Type 2 upgrade'||' '||SQLERRM);
730: END;
731:
732: BEGIN
733: UPDATE fv_treasury_symbols
734: SET fund_type = 'ES'
735: WHERE fund_group_code BETWEEN 5000 AND 5999
736: AND (receipt_account_indicator = 'N' OR receipt_account_indicator IS NULL);
737: EXCEPTION

Line 744: UPDATE fv_treasury_symbols

740: 'When others error: '||l_module||' Fund Type 3 upgrade'||' '||SQLERRM);
741: END;
742:
743: BEGIN
744: UPDATE fv_treasury_symbols
745: SET fund_type = 'US'
746: WHERE fund_group_code BETWEEN 5000 AND 5999
747: AND receipt_account_indicator = 'Y';
748: EXCEPTION

Line 755: UPDATE fv_treasury_symbols

751: 'When others error: '||l_module||' Fund Type 4 upgrade'||' '||SQLERRM);
752: END;
753:
754: BEGIN
755: UPDATE fv_treasury_symbols
756: SET fund_type = 'EP'
757: WHERE fund_group_code BETWEEN 4000 AND 4499;
758: EXCEPTION
759: WHEN OTHERS THEN

Line 765: UPDATE fv_treasury_symbols

761: 'When others error: '||l_module||' Fund Type 5 upgrade'||' '||SQLERRM);
762: END;
763:
764: BEGIN
765: UPDATE fv_treasury_symbols
766: SET fund_type = 'ER'
767: WHERE fund_group_code BETWEEN 4500 AND 4999;
768: EXCEPTION
769: WHEN OTHERS THEN

Line 775: UPDATE fv_treasury_symbols

771: 'When others error: '||l_module||' Fund Type 6 upgrade'||' '||SQLERRM);
772: END;
773:
774: BEGIN
775: UPDATE fv_treasury_symbols
776: SET fund_type = 'EM'
777: WHERE fund_group_code BETWEEN 3900 AND 3959;
778: EXCEPTION
779: WHEN OTHERS THEN

Line 785: UPDATE fv_treasury_symbols

781: 'When others error: '||l_module||' Fund Type 7 upgrade'||' '||SQLERRM);
782: END;
783:
784: BEGIN
785: UPDATE fv_treasury_symbols
786: SET fund_type = 'EC'
787: WHERE fund_group_code BETWEEN 3960 AND 3999;
788: EXCEPTION
789: WHEN OTHERS THEN

Line 795: UPDATE fv_treasury_symbols

791: 'When others error: '||l_module||' Fund Type 8 upgrade'||' '||SQLERRM);
792: END;
793:
794: BEGIN
795: UPDATE fv_treasury_symbols
796: SET fund_type = 'DF'
797: WHERE fund_group_code BETWEEN 6000 AND 6999;
798: EXCEPTION
799: WHEN OTHERS THEN

Line 805: UPDATE fv_treasury_symbols

801: 'When others error: '||l_module||' Fund Type 9 upgrade'||' '||SQLERRM);
802: END;
803:
804: BEGIN
805: UPDATE fv_treasury_symbols
806: SET fund_type = 'ET'
807: WHERE (fund_group_code BETWEEN 8000 AND 8399)
808: OR (fund_group_code BETWEEN 8500 AND 8999)
809: AND (receipt_account_indicator = 'N' OR receipt_account_indicator IS NULL);

Line 817: UPDATE fv_treasury_symbols

813: 'When others error: '||l_module||' Fund Type 10 upgrade'||' '||SQLERRM);
814: END;
815:
816: BEGIN
817: UPDATE fv_treasury_symbols
818: SET fund_type = 'UT'
819: WHERE (fund_group_code BETWEEN 8000 AND 8399)
820: OR (fund_group_code BETWEEN 8500 AND 8999)
821: AND receipt_account_indicator = 'Y';

Line 829: UPDATE fv_treasury_symbols

825: 'When others error: '||l_module||' Fund Type 11 upgrade'||' '||SQLERRM);
826: END;
827:
828: BEGIN
829: UPDATE fv_treasury_symbols
830: SET fund_type = 'TR'
831: WHERE fund_group_code BETWEEN 8400 AND 8499;
832: EXCEPTION
833: WHEN OTHERS THEN

Line 839: UPDATE fv_treasury_symbols

835: 'When others error: '||l_module||' Fund Type 12 upgrade'||' '||SQLERRM);
836: END;
837:
838: BEGIN
839: UPDATE fv_treasury_symbols
840: SET fund_type = 'CF'
841: WHERE (fund_group_code BETWEEN 3500 AND 3599 OR
842: fund_group_code BETWEEN 3800 AND 3899);
843: EXCEPTION

Line 871: SELECT fv_treasury_symbols_s.nextval INTO tpTASSeq from dual;

867: FOR rec IN (SELECT TREASURY_SYMBOL
868: FROM FV_TP_TREASURY_SYMBOLS
869: WHERE treasury_symbol_id IS NULL)
870: LOOP
871: SELECT fv_treasury_symbols_s.nextval INTO tpTASSeq from dual;
872: --sob := to_number(fnd_profile.value('GL_SET_OF_BKS_ID'));
873:
874: log(l_module, 'TP TAS Id:'||tpTASSeq);
875: log(l_module, 'TP TAS:'||rec.treasury_symbol);

Line 997: UPDATE fv_treasury_symbols

993: -- 4) Upgrade Authority Duration Code and Availability Type in Define
994: -- Treasury Account Symbols form
995: BEGIN
996:
997: UPDATE fv_treasury_symbols
998: SET time_frame = 'R',
999: availability_type_code = NULL
1000: WHERE receipt_account_indicator = 'Y';
1001:

Line 1002: UPDATE fv_treasury_symbols

998: SET time_frame = 'R',
999: availability_type_code = NULL
1000: WHERE receipt_account_indicator = 'Y';
1001:
1002: UPDATE fv_treasury_symbols
1003: SET time_frame = 'F',
1004: availability_type_code = 'F'
1005: WHERE time_frame = 'NO_YEAR'
1006: AND (fund_group_code BETWEEN 3500 AND 3599 OR

Line 1009: UPDATE fv_treasury_symbols

1005: WHERE time_frame = 'NO_YEAR'
1006: AND (fund_group_code BETWEEN 3500 AND 3599 OR
1007: fund_group_code BETWEEN 3800 AND 3899);
1008:
1009: UPDATE fv_treasury_symbols
1010: SET time_frame = 'X',
1011: availability_type_code = 'X'
1012: WHERE (receipt_account_indicator = 'N' OR
1013: receipt_account_indicator IS NULL)

Line 1041: UPDATE fv_treasury_symbols

1037: END;
1038:
1039: --6)Update GTAS Reportable Indicator to Y for all old TASs
1040: BEGIN
1041: UPDATE fv_treasury_symbols
1042: SET gtas_reportable_indicator ='Y'
1043: WHERE FACTS_REPORTABLE_INDICATOR IS NOT NULL;
1044: EXCEPTION
1045: WHEN OTHERS THEN