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

Line 11: g_exch_non_exch Fv_gtas_Attributes.Exch_Non_Exch1%type;

7: g_error_buf VARCHAR2(600);
8: g_error_code NUMBER := 0;
9: g_set_of_books_id NUMBER;
10: g_ccid NUMBER(15);
11: g_exch_non_exch Fv_gtas_Attributes.Exch_Non_Exch1%type;
12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;
13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);

Line 12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;

8: g_error_code NUMBER := 0;
9: g_set_of_books_id NUMBER;
10: g_ccid NUMBER(15);
11: g_exch_non_exch Fv_gtas_Attributes.Exch_Non_Exch1%type;
12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;
13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;

Line 13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;

9: g_set_of_books_id NUMBER;
10: g_ccid NUMBER(15);
11: g_exch_non_exch Fv_gtas_Attributes.Exch_Non_Exch1%type;
12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;
13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;

Line 14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;

10: g_ccid NUMBER(15);
11: g_exch_non_exch Fv_gtas_Attributes.Exch_Non_Exch1%type;
12: g_cust_non_cust Fv_gtas_Attributes.Cust_Non_Cust1%type;
13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;

Line 17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;

13: g_DIRECT_OR_REIMB_CODE Fv_gtas_Attributes.Dir_Reimb_Code1%type;
14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;
19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;
21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;

Line 18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;

14: g_APPOR_CAT_CODE Fv_gtas_Attributes.Apportionment_Category1%type;
15: g_APPOR_CAT_B_CODE VARCHAR2(4);
16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;
19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;
21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;
22: g_CREDIT_COHORT_YR Varchar(25);

Line 20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;

16: g_PROGRAM_REPT_CODE Fv_Facts_Prc_Dtl.reporting_code%type;
17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;
19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;
21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;
22: g_CREDIT_COHORT_YR Varchar(25);
23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;
24: g_exception_category Varchar2(100);

Line 21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;

17: g_BEA_CAT_CODE Fv_gtas_Attributes.Bea_Category1%type;
18: g_BORR_SRC_CODE Fv_gtas_Attributes.Borrowing_Source1%type;
19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;
21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;
22: g_CREDIT_COHORT_YR Varchar(25);
23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;
24: g_exception_category Varchar2(100);
25: g_end_bal_ind fv_gtas_attributes.balance_type%type;

Line 23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;

19: g_NEW_BAL_CODE VARCHAR2(3);
20: g_CUR_SUBSEQUENT_CODE Fv_gtas_Attributes.Cur_Sub_Code1%type;
21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;
22: g_CREDIT_COHORT_YR Varchar(25);
23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;
24: g_exception_category Varchar2(100);
25: g_end_bal_ind fv_gtas_attributes.balance_type%type;
26: --g_fund_value FV_FUND_PARAMETERS.fund_value%TYPE;
27: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

Line 25: g_end_bal_ind fv_gtas_attributes.balance_type%type;

21: g_PYA_CODE Fv_gtas_Attributes.Pya_Code1%type;
22: g_CREDIT_COHORT_YR Varchar(25);
23: g_PROGRAM_COST_IND Fv_gtas_Attributes.prog_cost_ind1%type;
24: g_exception_category Varchar2(100);
25: g_end_bal_ind fv_gtas_attributes.balance_type%type;
26: --g_fund_value FV_FUND_PARAMETERS.fund_value%TYPE;
27: g_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
28: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
29: g_period_year Gl_Balances.period_year%TYPE;

Line 1118: -- segment from FV_GTAS_ATTRIBUTES table and load them into global

1114: -- -------------------------------------------------------------------
1115: -- PROCEDURE LOAD_GTAS_ATTRIBUTES
1116: -- -------------------------------------------------------------------
1117: -- This procedure selects the attributes for the Account number
1118: -- segment from FV_GTAS_ATTRIBUTES table and load them into global
1119: -- variables for usage in the GTAS Main process. It also calculates
1120: -- one time pull up values for the account number that does not
1121: -- require drill down into GL transactions.
1122: -- ------------------------------------------------------------------

Line 1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;

1129: --L_Ussgl_Not_Found VARCHAR2(1);
1130:
1131: doesGTASAccountExist boolean default false;
1132: cnt number;
1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;

Line 1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;

1130:
1131: doesGTASAccountExist boolean default false;
1132: cnt number;
1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;

Line 1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;

1131: doesGTASAccountExist boolean default false;
1132: cnt number;
1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;

Line 1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;

1132: cnt number;
1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;

Line 1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;

1133: L_Exch_Non_Exch1 Fv_gtas_Attributes.Exch_Non_Exch1%type;
1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;

Line 1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;

1134: L_Pya_Code1 Fv_gtas_Attributes.Pya_Code1%type;
1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;

Line 1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;

1135: L_Cust_Non_Cust1 Fv_gtas_Attributes.Cust_Non_Cust1%type;
1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;

Line 1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;

1136: L_Cust_Non_Cust2 Fv_gtas_Attributes.Cust_Non_Cust2%type;
1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;

Line 1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;

1137: L_Borrowing_Source_flag Fv_gtas_Attributes.Borrowing_Source_flag%type;
1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;

Line 1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;

1138: L_Direct_or_Reimb_flag Fv_gtas_Attributes.Direct_or_Reimb_flag%type;
1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;

Line 1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;

1139: L_Apportionment_Category1 Fv_gtas_Attributes.Apportionment_Category1%type;
1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;

Line 1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;

1140: L_Apportionment_Category2 Fv_gtas_Attributes.Apportionment_Category1%type;
1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;

Line 1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;

1141: L_Apportionment_Category3 Fv_gtas_Attributes.Apportionment_Category1%type;
1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%type;

Line 1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;

1142: L_Bea_Category_Acct_Type Fv_gtas_Attributes.Bea_Category_Acct_Type%type;
1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%type;
1150: l_appor_cat fv_fund_parameters.fund_category%type;

Line 1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;

1143: l_Bea_Category_flag Fv_gtas_Attributes.Bea_Category_flag%type;
1144: L_prog_cost_ind1 Fv_gtas_Attributes.prog_cost_ind1%type;
1145: l_prog_cost_ind2 Fv_gtas_Attributes.prog_cost_ind2%type;
1146: l_New_or_Bal_flag Fv_gtas_Attributes.New_or_Bal_flag%type;
1147: l_Cur_Sub_Code1 Fv_gtas_Attributes.Cur_Sub_Code1%type;
1148: l_Outlays_Bea_Category_Code fv_fund_parameters.Outlays_Bea_Category_Code%type;
1149: l_Bea_Category fv_fund_parameters.Bea_Category%type;
1150: l_appor_cat fv_fund_parameters.fund_category%type;
1151: l_c_nc fv_fund_parameters.cust_non_cust%type;

Line 1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;

1153: l_drc fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1154: l_Financing_Account fv_Treasury_symbols.financing_account%type;
1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
1160: select_stmt VARCHAR2(10000);
1161: Vl_Cursor Integer;

Line 1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;

1154: l_Financing_Account fv_Treasury_symbols.financing_account%type;
1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
1160: select_stmt VARCHAR2(10000);
1161: Vl_Cursor Integer;
1162: I integer;

Line 1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;

1155: l_cohort_seg_name fv_pya_fiscalyear_segment.cohort_segment_name%type;
1156: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
1157: l_prog_rep_cat_flag fv_gtas_attributes.prog_rep_cat_flag%TYPE;
1158: l_program_cost_ind_flag fv_gtas_attributes.program_cost_ind_flag%TYPE;
1159: l_appor_cat_b_prog_flag fv_gtas_attributes.appor_cat_b_prog_flag%TYPE;
1160: select_stmt VARCHAR2(10000);
1161: Vl_Cursor Integer;
1162: I integer;
1163: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;

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

1192: g_treasury_symbol_id := l_treasury_symbol_id;
1193:
1194: -- Validate the Account number and return the corresponding SGL
1195: -- number or parent for getting attributes.
1196: -- Verify whether the account number exists in FV_GTAS_ATTRIBUTES table
1197: -- Validate the USSGL Account Number
1198: g_error_code := 0;
1199:
1200: Begin

Line 1203: From Fv_Gtas_Attributes

1199:
1200: Begin
1201: log(l_module, ' l_Acct_Num '||l_Acct_Num );
1202: Select count(*) into cnt
1203: From Fv_Gtas_Attributes
1204: Where GTAS_ACCT_NUMBER = l_Acct_Num;
1205: doesGTASAccountExist := TRUE;
1206: -- Account not reported in GTAS
1207: EXCEPTION

Line 1226: from FV_GTAS_ATTRIBUTES

1222:
1223: begin
1224: select decode(BALANCE_TYPE, 'BE','Y','E','Y','N')
1225: into g_end_bal_ind
1226: from FV_GTAS_ATTRIBUTES
1227: Where GTAS_ACCT_NUMBER = l_Acct_Num;
1228: exception
1229: when no_data_found then
1230: log(l_module, 'Begin 12'||SQLERRM );

Line 1262: From Fv_Gtas_Attributes

1258: l_new_or_bal_flag,
1259: l_Cur_Sub_Code1, l_prog_rep_cat_flag,
1260: l_appor_cat_b_prog_flag, l_program_cost_ind_flag,
1261: g_trading_partner_flag
1262: From Fv_Gtas_Attributes
1263: WHERE GTAS_ACCT_NUMBER = l_Acct_Num
1264: AND set_of_books_id = g_set_of_books_id;
1265: Exception
1266: when others then

Line 2366: FROM FV_GTAS_ATTRIBUTES

2362: -- Get the account or the parent account
2363: BEGIN
2364: SELECT 'X'
2365: INTO l_exists
2366: FROM FV_GTAS_ATTRIBUTES
2367: WHERE gtas_acct_number = l_account_number
2368: AND set_of_books_id = g_set_of_books_id;
2369:
2370: log(l_module,'LOADING GTAS ATTRIBUTES '||

Line 4758: -- Look for parent in FV_gtas_ATTRIBUTES table

4754: AND enabled_flag = 'Y'
4755: );
4756:
4757: BEGIN
4758: -- Look for parent in FV_gtas_ATTRIBUTES table
4759: SELECT 'X'
4760: INTO l_exists
4761: FROM fv_gtas_attributes
4762: WHERE gtas_acct_number = sgl_acct_num

Line 4761: FROM fv_gtas_attributes

4757: BEGIN
4758: -- Look for parent in FV_gtas_ATTRIBUTES table
4759: SELECT 'X'
4760: INTO l_exists
4761: FROM fv_gtas_attributes
4762: WHERE gtas_acct_number = sgl_acct_num
4763: AND set_of_books_id = g_set_of_books_id;
4764: -- Return the account Number
4765: log(l_module,'SGL Parent Account:'||

Line 5453: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

5449: IS
5450: l_module VARCHAR2(200) := g_module||'GET_FED_NONFED_CODE';
5451: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;
5452: l_code_exists VARCHAR2(1);
5453: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
5454: l_fednonfed_count NUMBER := 0;
5455: BEGIN
5456: log(l_module, 'Begin: ');
5457:

Line 5463: --Check if the account number exists in fv gtas attributes table.

5459: log(l_module,' p_account_number: '||p_account_number);
5460: log(l_module,' p_sgl_account_number: '||p_sgl_account_number);
5461: log(l_module,' p_party_fed_nonfed_code: '||p_party_fed_nonfed_code);
5462:
5463: --Check if the account number exists in fv gtas attributes table.
5464: --If it does not, then use the ussgl account for getting/checking
5465: --fed non fed code.
5466: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
5467:

Line 5477: FROM fv_gtas_attributes

5473: SELECT COUNT(*)
5474: INTO l_fednonfed_count
5475: FROM (
5476: SELECT fed_non_fed1
5477: FROM fv_gtas_attributes
5478: WHERE gtas_acct_number = l_account_number
5479: AND fed_non_fed1 IS NOT NULL
5480: AND set_of_books_id = g_set_of_books_id
5481: UNION

Line 5483: FROM fv_gtas_attributes

5479: AND fed_non_fed1 IS NOT NULL
5480: AND set_of_books_id = g_set_of_books_id
5481: UNION
5482: SELECT fed_non_fed2
5483: FROM fv_gtas_attributes
5484: WHERE gtas_acct_number = l_account_number
5485: AND fed_non_fed2 IS NOT NULL
5486: AND set_of_books_id = g_set_of_books_id
5487: UNION

Line 5489: FROM fv_gtas_attributes

5485: AND fed_non_fed2 IS NOT NULL
5486: AND set_of_books_id = g_set_of_books_id
5487: UNION
5488: SELECT fed_non_fed3
5489: FROM fv_gtas_attributes
5490: WHERE gtas_acct_number = l_account_number
5491: AND fed_non_fed3 IS NOT NULL
5492: AND set_of_books_id = g_set_of_books_id);
5493:

Line 5508: FROM fv_gtas_attributes

5504: SELECT COUNT(*)
5505: INTO l_fednonfed_count
5506: FROM (
5507: SELECT fed_non_fed1
5508: FROM fv_gtas_attributes
5509: WHERE gtas_acct_number = l_account_number
5510: AND fed_non_fed1 IS NOT NULL
5511: AND set_of_books_id = g_set_of_books_id
5512: UNION

Line 5514: FROM fv_gtas_attributes

5510: AND fed_non_fed1 IS NOT NULL
5511: AND set_of_books_id = g_set_of_books_id
5512: UNION
5513: SELECT fed_non_fed2
5514: FROM fv_gtas_attributes
5515: WHERE gtas_acct_number = l_account_number
5516: AND fed_non_fed2 IS NOT NULL
5517: AND set_of_books_id = g_set_of_books_id
5518: UNION

Line 5520: FROM fv_gtas_attributes

5516: AND fed_non_fed2 IS NOT NULL
5517: AND set_of_books_id = g_set_of_books_id
5518: UNION
5519: SELECT fed_non_fed3
5520: FROM fv_gtas_attributes
5521: WHERE gtas_acct_number = l_account_number
5522: AND fed_non_fed3 IS NOT NULL
5523: AND set_of_books_id = g_set_of_books_id);
5524:

Line 5619: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

5615: p_sgl_acct_num IN VARCHAR2,
5616: p_account_num OUT NOCOPY VARCHAR2)
5617: IS
5618: l_module VARCHAR2(80) := g_module||'GET_USSGL_ACCT';
5619: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
5620: BEGIN
5621: log(l_module, 'Begin ');
5622: SELECT gtas_acct_number
5623: INTO p_account_num

Line 5624: FROM fv_gtas_attributes

5620: BEGIN
5621: log(l_module, 'Begin ');
5622: SELECT gtas_acct_number
5623: INTO p_account_num
5624: FROM fv_gtas_attributes
5625: WHERE set_of_books_id = g_set_of_books_id
5626: AND gtas_acct_number = p_gtas_acct_num;
5627:
5628: log(l_module, 'End: ');

Line 5641: --Checks whether a passed value exists in fv_gtas_attributes.fed_non_fed1

5637: g_error_buf := l_module||'-When others error: '||SQLERRM;
5638: FV_UTILITY.LOG_MESG(g_error_buf);
5639: END GET_USSGL_ACCT;
5640: --------------------------------------------------------------------------------
5641: --Checks whether a passed value exists in fv_gtas_attributes.fed_non_fed1
5642: --2 or 3 columns
5643: PROCEDURE CHECK_FED_NONFED_CODE(p_account_number IN VARCHAR2,
5644: p_fed_nonfed_type IN VARCHAR2,
5645: --p_je_source IN VARCHAR2,

Line 5649: --l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;

5645: --p_je_source IN VARCHAR2,
5646: p_code_exists OUT NOCOPY VARCHAR2)
5647: IS
5648: l_module VARCHAR2(80) := g_module||'CHECK_FED_NONFED_CODE';
5649: --l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
5650: --l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;
5651: --l_fednonfed_select VARCHAR2(200);
5652: --l_fednonfed_code_count NUMBER;
5653: BEGIN

Line 5650: --l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;

5646: p_code_exists OUT NOCOPY VARCHAR2)
5647: IS
5648: l_module VARCHAR2(80) := g_module||'CHECK_FED_NONFED_CODE';
5649: --l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
5650: --l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;
5651: --l_fednonfed_select VARCHAR2(200);
5652: --l_fednonfed_code_count NUMBER;
5653: BEGIN
5654:

Line 5660: FROM fv_gtas_attributes

5656: log(l_module, 'p_account_number: '||p_account_number);
5657:
5658: SELECT 'Y'
5659: INTO p_code_exists
5660: FROM fv_gtas_attributes
5661: WHERE gtas_acct_number = p_account_number
5662: AND set_of_books_id = g_set_of_books_id
5663: AND (fed_non_fed1 = p_fed_nonfed_type OR
5664: fed_non_fed2 = p_fed_nonfed_type OR

Line 5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;

5765:
5766: l_be_trx_id NUMBER;
5767: l_trx_type_id NUMBER;
5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
5773: --l_authority_type_found VARCHAR2(1);

Line 5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;

5766: l_be_trx_id NUMBER;
5767: l_trx_type_id NUMBER;
5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
5773: --l_authority_type_found VARCHAR2(1);
5774: --l_exception_category fv_gtas_exceptions.exception_category%TYPE;

Line 5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;

5767: l_trx_type_id NUMBER;
5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
5773: --l_authority_type_found VARCHAR2(1);
5774: --l_exception_category fv_gtas_exceptions.exception_category%TYPE;
5775: l_module VARCHAR2(200) := g_module||'GET_AUTHORITY_TYPE_CODE';

Line 5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;

5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
5773: --l_authority_type_found VARCHAR2(1);
5774: --l_exception_category fv_gtas_exceptions.exception_category%TYPE;
5775: l_module VARCHAR2(200) := g_module||'GET_AUTHORITY_TYPE_CODE';
5776: --l_auth_select VARCHAR2(200);

Line 5779: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

5775: l_module VARCHAR2(200) := g_module||'GET_AUTHORITY_TYPE_CODE';
5776: --l_auth_select VARCHAR2(200);
5777: --l_auth_type_code_count NUMBER;
5778: l_be_doc_num xla_transaction_entities.transaction_number%TYPE;
5779: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
5780:
5781:
5782: BEGIN
5783: log(l_module,'Begin: ');

Line 5856: FROM fv_gtas_attributes

5852: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
5853:
5854: SELECT authority_type1
5855: INTO l_authority_type_code_tmp
5856: FROM fv_gtas_attributes
5857: WHERE gtas_acct_number = l_account_number; --p_account_number;
5858: log(l_module,'Returning Authority Type: '||p_authority_type_code);
5859:
5860: IF l_authority_type_code_tmp IS NOT NULL THEN

Line 5879: FROM fv_gtas_attributes

5875: log(l_module,'Trying to find Authority type from gtas attributes');
5876:
5877: SELECT authority_type1
5878: INTO p_authority_type_code
5879: FROM fv_gtas_attributes
5880: WHERE gtas_acct_number = l_account_number; --p_account_number;
5881: log(l_module,'Returning Authority Type: '||p_authority_type_code);
5882:
5883: END IF;

Line 5902: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

5898: IS
5899: l_module VARCHAR2(200) := g_module||'GET_BUDGET_IMPACT_IND';
5900: l_account_type VARCHAR2(1);
5901: l_bud_imp_count NUMBER := 0;
5902: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
5903: TYPE acct_type_cur IS REF CURSOR;
5904: l_acct_type_cur acct_type_cur;
5905:
5906: l_acct_select VARCHAR2(1000);

Line 5955: --Check if the account number exists in fv gtas attributes table.

5951:
5952: --get_account_type(l_temp_acct_num, l_account_type);
5953: --get_account_type(p_account_number, l_account_type);
5954:
5955: --Check if the account number exists in fv gtas attributes table.
5956: --If it does not, then use the ussgl account for getting/checking
5957: --bud impact ind
5958: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
5959:

Line 5963: FROM fv_gtas_attributes

5959:
5960: IF l_account_type IN ('D','C') THEN
5961: SELECT COUNT(*)
5962: INTO l_bud_imp_count
5963: FROM fv_gtas_attributes
5964: WHERE gtas_acct_number = l_account_number--p_account_number
5965: AND (NVL(bud_impact_ind1,'-X') = 'D'
5966: OR NVL(bud_impact_ind2,'-X') = 'D');
5967:

Line 5974: FROM fv_gtas_attributes

5970: END IF;
5971: ELSE
5972: SELECT COUNT(*)
5973: INTO l_bud_imp_count
5974: FROM fv_gtas_attributes
5975: WHERE gtas_acct_number = l_account_number--p_account_number
5976: AND (NVL(bud_impact_ind1,'-X') = 'E'
5977: OR NVL(bud_impact_ind2,'-X') = 'E');
5978: