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_INTERFACE dependencies on FV_GTAS_ATTRIBUTES

Line 683: l_ussgl_acct_num fv_gtas_attributes.USSGL_ACCT_NUMBER%type;

679: p_end_bal_ind OUT NOCOPY VARCHAR2)
680:
681: IS
682: l_module_name VARCHAR2(200):= g_module_name||'GET_USSGL_ACCT_NUM';
683: l_ussgl_acct_num fv_gtas_attributes.USSGL_ACCT_NUMBER%type;
684: l_ussgl_enabled VARCHAR2(1);
685: L_Ussgl_Not_Found VARCHAR2(1);
686:
687: --L_Exists VARCHAR2(1);

Line 690: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;

686:
687: --L_Exists VARCHAR2(1);
688: doesGTASAccountExist boolean default false;
689: cnt number;
690: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;
692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:

Line 691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;

687: --L_Exists VARCHAR2(1);
688: doesGTASAccountExist boolean default false;
689: cnt number;
690: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;
692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;

Line 692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;

688: doesGTASAccountExist boolean default false;
689: cnt number;
690: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;
692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;

Line 693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;

689: cnt number;
690: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;
692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:

Line 695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;

691: L_Exch_Non_Exch2 Fv_gtas_Attributes.Exch_Non_Exch2%type;
692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;

Line 696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;

692: L_Exch_Non_Exch3 Fv_gtas_Attributes.Exch_Non_Exch3%type;
693: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;

Line 698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;

694:
695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:

Line 699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;

695: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;

Line 700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;

696: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:

Line 701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;

697:
698: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;

Line 703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;

699: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
700: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
701: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
702:
703: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
704:
705: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
706: l_Bea_Category fv_fund_parameters.Bea_Category%type;
707: l_appor_cat fv_fund_parameters.fund_category%type;

Line 720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;

716: Vl_Prc_Val Varchar2(4);
717: I integer;
718: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
719: l_Acct_Num Varchar2(8);
720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;

Line 721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;

717: I integer;
718: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
719: l_Acct_Num Varchar2(8);
720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;

Line 722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;

718: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
719: l_Acct_Num Varchar2(8);
720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;

Line 723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;

719: l_Acct_Num Varchar2(8);
720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;

Line 724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;

720: l_temp_acct_num fv_gtas_attributes.gtas_acct_number%TYPE;
721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;
728:

Line 725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;

721: l_dir_or_reimb_flag fv_gtas_attributes.direct_or_reimb_flag%TYPE;
722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;
728:
729: --l_prc_map_val VARCHAR2(30);

Line 726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;

722: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;
728:
729: --l_prc_map_val VARCHAR2(30);
730: BEGIN

Line 727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;

723: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
724: l_bea_category_flag fv_gtas_attributes.bea_category_flag%TYPE;
725: l_borrowing_source_flag fv_gtas_attributes.borrowing_source_flag%TYPE;
726: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
727: l_new_or_bal_flag fv_gtas_attributes.new_or_bal_flag%TYPE;
728:
729: --l_prc_map_val VARCHAR2(30);
730: BEGIN
731: log(l_module_name, 'Begin');

Line 779: -- Verify whether the account number exists in FV_GTAS_ATTRIBUTES table

775: p_treasury_symbol_id := l_treasury_symbol_id;
776:
777: -- Validate the Account number and return the corresponding SGL
778: -- number or parent for getting attributes.
779: -- Verify whether the account number exists in FV_GTAS_ATTRIBUTES table
780: -- Validate the USSGL Account Number
781: Gbl_Error_Code := 0;
782: --Check if USSGL account is defined and enabled in FV_FACTS_USSGL_ACCOUNTS
783: GET_USSGL_INFO(p_acct_num, l_ussgl_enabled,l_ussgl_not_found);

Line 868: Select count(*) into cnt From Fv_Gtas_Attributes Where

864: End If;
865: End If;
866:
867: Begin
868: Select count(*) into cnt From Fv_Gtas_Attributes Where
869: GTAS_ACCT_NUMBER = l_Acct_Num;
870: doesGTASAccountExist := TRUE;
871: -- Account not reported in GTAS
872: EXCEPTION

Line 901: from FV_GTAS_ATTRIBUTES

897:
898: begin
899: select decode(BALANCE_TYPE, 'BE','S',BALANCE_TYPE )
900: into p_end_bal_ind
901: from FV_GTAS_ATTRIBUTES
902: Where GTAS_ACCT_NUMBER = l_Acct_Num
903: AND set_of_books_id = gbl_set_of_books_id;
904: exception
905: when no_data_found then

Line 949: FROM fv_gtas_attributes

945: --use ussgl account
946: BEGIN
947: SELECT gtas_acct_number
948: INTO l_temp_acct_num
949: FROM fv_gtas_attributes
950: WHERE gtas_acct_number = p_acct_num;
951:
952: EXCEPTION WHEN NO_DATA_FOUND THEN
953: log(l_module_name, 'GTAS attributes not found with: '||p_acct_num);

Line 985: From Fv_Gtas_Attributes

981: L_Bea_Category_Acct_Type,
982: l_program_cost_ind_flag,
983: l_new_or_bal_flag,
984: l_Cur_Sub_Code1
985: From Fv_Gtas_Attributes
986: --WHERE GTAS_ACCT_NUMBER = l_Acct_Num
987: WHERE GTAS_ACCT_NUMBER = l_temp_acct_num
988: AND set_of_books_id = gbl_set_of_books_id;
989: Exception

Line 2696: -- FV_GTAS_ATTRIBUTES Table.

2692: --------------------------------------------------------------------------------
2693: --------------------------------------------------------------------------------
2694: -- Called from the concurrent program Federal Account Creation Process
2695: -- Purpose of this procedure is to process all Federal accounts in
2696: -- FV_GTAS_ATTRIBUTES Table.
2697: -- For each such account, find if it is a child account. If yes, insert
2698: -- this account along with its parent and fed_nonfed, authority_type,
2699: -- bud_impact_ind and trading_partner attributes into
2700: -- FV_GTAS_FED_ACCOUNTS table.

Line 2722: FROM fv_gtas_attributes

2718: SELECT gtas_acct_number, fed_non_fed1, fed_non_fed2, fed_non_fed3,
2719: authority_type1, authority_type2, authority_type3,
2720: authority_type4, authority_type5, authority_type6,
2721: bud_impact_ind1, bud_impact_ind2, trading_partner_flag
2722: FROM fv_gtas_attributes
2723: WHERE set_of_books_id = p_sob_id
2724: AND (
2725: (fed_non_fed1 IS NOT NULL OR fed_non_fed2 IS NOT NULL OR fed_non_fed3 IS NOT NULL)
2726: OR

Line 2776: -- Loop through records in FV_GTAS_ATTRIBUTES

2772: --before populating
2773: DELETE_FED_ACCOUNTS(p_sob_id, p_run_year) ;
2774:
2775:
2776: -- Loop through records in FV_GTAS_ATTRIBUTES
2777: FOR gtas_attributes_rec IN gtas_attributes_cur
2778: LOOP
2779:
2780: log(l_module_name, 'LOOP gtas_attributes_rec Begins.... ');