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

Line 387: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;

383: l_module_name VARCHAR2(200);
384: l_select_stmt VARCHAR2(20000);
385: l_last_fetch BOOLEAN;
386: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
387: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
388: l_budget_impact_indicator VARCHAR2(1);
389: l_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
390: l_dummy_num NUMBER;
391: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

Line 389: l_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;

385: l_last_fetch BOOLEAN;
386: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
387: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
388: l_budget_impact_indicator VARCHAR2(1);
389: l_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
390: l_dummy_num NUMBER;
391: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
392: --l_project_accounting VARCHAR2(50):='Project Accounting';
393: TYPE t_ref_cur IS REF CURSOR ;

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

387: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
388: l_budget_impact_indicator VARCHAR2(1);
389: l_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
390: l_dummy_num NUMBER;
391: --l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
392: --l_project_accounting VARCHAR2(50):='Project Accounting';
393: TYPE t_ref_cur IS REF CURSOR ;
394: l_gl_lines_cur t_ref_cur ;
395: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;

Line 412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;

408: TYPE party_id_t IS TABLE OF fv_gtas_activity_balances.trading_partner_id%TYPE;
409: TYPE party_type_t IS TABLE OF fv_gtas_activity_balances.trading_partner_type%TYPE;
410: TYPE party_name_t IS TABLE OF fv_gtas_activity_balances.trading_partner_name%TYPE;
411: TYPE agency_id_t IS TABLE OF VARCHAR2(3);
412: TYPE fed_nonfed_code_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%TYPE;
415: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
416: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);

Line 423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;

419: TYPE fed_nonfed_flag_list_t IS TABLE OF VARCHAR2(1);
420: TYPE budget_impact_ind_flag_list_t IS TABLE OF VARCHAR2(1);
421: TYPE trading_partner_flag_list_t IS TABLE OF VARCHAR2(1);
422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;
423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;
425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;
426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;
427: TYPE main_account_t IS TABLE OF

Line 424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;

420: TYPE budget_impact_ind_flag_list_t IS TABLE OF VARCHAR2(1);
421: TYPE trading_partner_flag_list_t IS TABLE OF VARCHAR2(1);
422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;
423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;
425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;
426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;
427: TYPE main_account_t IS TABLE OF
428: fv_gtas_activity_balances.trading_partner_main_account%TYPE;

Line 425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;

421: TYPE trading_partner_flag_list_t IS TABLE OF VARCHAR2(1);
422: TYPE sgl_account_number_list_t IS TABLE OF fv_gtas_fed_accounts.sgl_account_number%TYPE;
423: --TYPE fed_nonfed_code_list_t IS TABLE OF fv_gtas_attributes.fed_non_fed1%TYPE;
424: TYPE authority_type_code_t IS TABLE OF fv_gtas_attributes.authority_type1%TYPE;
425: TYPE budget_impact_ind_t IS TABLE OF fv_gtas_attributes.bud_impact_ind1%TYPE;
426: TYPE doc_num_t IS TABLE OF fv_gtas_exceptions.doc_num%TYPE;
427: TYPE main_account_t IS TABLE OF
428: fv_gtas_activity_balances.trading_partner_main_account%TYPE;
429:

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

737: l_budget_impact_indicator := NULL;
738: l_party_info_tab.delete();
739: --l_account_number := NULL;
740: /*
741: --Check if the account number exists in fv gtas attributes table.
742: --If it does not, then use the ussgl account for getting/checking
743: --all gtas attributes
744: BEGIN
745:

Line 748: FROM fv_gtas_attributes

744: BEGIN
745:
746: SELECT gtas_acct_number
747: INTO l_account_number
748: FROM fv_gtas_attributes
749: WHERE gtas_acct_number = account_number_list(i);
750:
751: EXCEPTION WHEN NO_DATA_FOUND THEN
752: log(l_module_name,account_number_list(i)||' not found in gtas attributes,

Line 1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;

1094:
1095: l_be_trx_id NUMBER;
1096: l_trx_type_id NUMBER;
1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
1102: l_authority_type_found VARCHAR2(1);

Line 1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;

1095: l_be_trx_id NUMBER;
1096: l_trx_type_id NUMBER;
1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
1102: l_authority_type_found VARCHAR2(1);
1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;

Line 1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;

1096: l_trx_type_id NUMBER;
1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
1102: l_authority_type_found VARCHAR2(1);
1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
1104: l_module_name VARCHAR2(200) := g_module_name||'GET_AUTHORITY_TYPE_CODE';

Line 1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;

1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;
1102: l_authority_type_found VARCHAR2(1);
1103: l_exception_category fv_gtas_exceptions.exception_category%TYPE;
1104: l_module_name VARCHAR2(200) := g_module_name||'GET_AUTHORITY_TYPE_CODE';
1105: l_auth_select VARCHAR2(200);

Line 1108: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

1104: l_module_name VARCHAR2(200) := g_module_name||'GET_AUTHORITY_TYPE_CODE';
1105: l_auth_select VARCHAR2(200);
1106: l_auth_type_code_count NUMBER;
1107: l_be_doc_num xla_transaction_entities.transaction_number%TYPE;
1108: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
1109:
1110:
1111: BEGIN
1112: log(l_module_name,'Begin: '||l_module_name);

Line 1183: --The authority type code must match one value in fv gtas attributes

1179: --IF account number does not exist in gtas attributes, then
1180: --we have to check for attributes of the sgl account
1181: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
1182:
1183: --The authority type code must match one value in fv gtas attributes
1184: --If it does not, then insert exception row
1185: IF (p_je_source = 'Budgetary Transaction' AND
1186: l_authority_type_code IS NOT NULL) THEN
1187: BEGIN

Line 1190: FROM fv_gtas_attributes

1186: l_authority_type_code IS NOT NULL) THEN
1187: BEGIN
1188: SELECT 'Y'
1189: INTO l_authority_type_found
1190: FROM fv_gtas_attributes
1191: WHERE set_of_books_id = gbl_sob_id
1192: AND gtas_acct_number = l_account_number --p_account_number
1193: AND (authority_type1 = l_authority_type_code
1194: OR authority_type2 = l_authority_type_code

Line 1237: ' from fv_gtas_attributes

1233: FOR i in 1..6 LOOP
1234: begin
1235:
1236: l_auth_select := 'SELECT authority_type'||i||
1237: ' from fv_gtas_attributes
1238: where gtas_acct_number = '||l_account_number; --p_account_number;
1239:
1240: EXECUTE IMMEDIATE l_auth_select INTO l_authority_type_code_tmp;
1241: log(l_module_name,'l_authority_type_code_tmp: '||l_authority_type_code_tmp);

Line 1374: --l_tp_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;

1370: l_module_name VARCHAR2(200) := g_module_name||'GET_TP_ATTRIBUTES';
1371: --l_fund_type fv_treasury_symbols.fund_type%TYPE;
1372: l_tp_type VARCHAR2(1);
1373: --l_tp_id NUMBER;
1374: --l_tp_fed_nonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
1375: l_tp_name po_vendors.vendor_name%TYPE;
1376: --l_tp_agency_id VARCHAR2(3);
1377: --l_tp_main_acct VARCHAR2(4);
1378: --l_fed_nonfed_code_exists VARCHAR2(1);

Line 2271: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

2267: l_module_name VARCHAR2(200) := g_module_name||'GET_BUDGET_IMPACT_IND';
2268: --l_budget_impact_indicator VARCHAR2(1);
2269: l_account_type VARCHAR2(1);
2270: l_bud_imp_count NUMBER := 0;
2271: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
2272: TYPE acct_type_cur IS REF CURSOR;
2273: l_acct_type_cur acct_type_cur;
2274:
2275: l_acct_select VARCHAR2(1000);

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

2345:
2346: --get_account_type(l_temp_acct_num, l_account_type);
2347: --get_account_type(p_account_number, l_account_type);
2348:
2349: --Check if the account number exists in fv gtas attributes table.
2350: --If it does not, then use the ussgl account for getting/checking
2351: --bud impact ind
2352: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
2353:

Line 2357: FROM fv_gtas_attributes

2353:
2354: IF l_account_type IN ('D','C') THEN
2355: SELECT COUNT(*)
2356: INTO l_bud_imp_count
2357: FROM fv_gtas_attributes
2358: WHERE gtas_acct_number = l_account_number--p_account_number
2359: AND (NVL(bud_impact_ind1,'-X') = 'D'
2360: OR NVL(bud_impact_ind2,'-X') = 'D');
2361:

Line 2376: FROM fv_gtas_attributes

2372: END IF;
2373: ELSE
2374: SELECT COUNT(*)
2375: INTO l_bud_imp_count
2376: FROM fv_gtas_attributes
2377: WHERE gtas_acct_number = l_account_number--p_account_number
2378: AND (NVL(bud_impact_ind1,'-X') = 'E'
2379: OR NVL(bud_impact_ind2,'-X') = 'E');
2380:

Line 2441: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

2437: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;
2438: --l_dummy NUMBER;
2439: --l_account_type VARCHAR2(1);
2440: l_code_exists VARCHAR2(1);
2441: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
2442: l_fednonfed_count NUMBER := 0;
2443: BEGIN
2444: log(l_module_name, 'Begin: '||l_module_name);
2445:

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

2447: log(l_module_name,' p_account_number: '||p_account_number);
2448: log(l_module_name,' p_sgl_account_number: '||p_sgl_account_number);
2449: log(l_module_name,' p_party_fed_nonfed_code: '||p_party_fed_nonfed_code);
2450:
2451: --Check if the account number exists in fv gtas attributes table.
2452: --If it does not, then use the ussgl account for getting/checking
2453: --fed non fed code.
2454: GET_USSGL_ACCT(p_account_number, p_sgl_account_number, l_account_number);
2455:

Line 2465: FROM fv_gtas_attributes

2461: SELECT COUNT(*)
2462: INTO l_fednonfed_count
2463: FROM (
2464: SELECT fed_non_fed1
2465: FROM fv_gtas_attributes
2466: WHERE gtas_acct_number = l_account_number
2467: AND fed_non_fed1 IS NOT NULL
2468: AND set_of_books_id = gbl_sob_id
2469: UNION

Line 2471: FROM fv_gtas_attributes

2467: AND fed_non_fed1 IS NOT NULL
2468: AND set_of_books_id = gbl_sob_id
2469: UNION
2470: SELECT fed_non_fed2
2471: FROM fv_gtas_attributes
2472: WHERE gtas_acct_number = l_account_number
2473: AND fed_non_fed2 IS NOT NULL
2474: AND set_of_books_id = gbl_sob_id
2475: UNION

Line 2477: FROM fv_gtas_attributes

2473: AND fed_non_fed2 IS NOT NULL
2474: AND set_of_books_id = gbl_sob_id
2475: UNION
2476: SELECT fed_non_fed3
2477: FROM fv_gtas_attributes
2478: WHERE gtas_acct_number = l_account_number
2479: AND fed_non_fed3 IS NOT NULL
2480: AND set_of_books_id = gbl_sob_id);
2481:

Line 2496: FROM fv_gtas_attributes

2492: SELECT COUNT(*)
2493: INTO l_fednonfed_count
2494: FROM (
2495: SELECT fed_non_fed1
2496: FROM fv_gtas_attributes
2497: WHERE gtas_acct_number = l_account_number
2498: AND fed_non_fed1 IS NOT NULL
2499: AND set_of_books_id = gbl_sob_id
2500: UNION

Line 2502: FROM fv_gtas_attributes

2498: AND fed_non_fed1 IS NOT NULL
2499: AND set_of_books_id = gbl_sob_id
2500: UNION
2501: SELECT fed_non_fed2
2502: FROM fv_gtas_attributes
2503: WHERE gtas_acct_number = l_account_number
2504: AND fed_non_fed2 IS NOT NULL
2505: AND set_of_books_id = gbl_sob_id
2506: UNION

Line 2508: FROM fv_gtas_attributes

2504: AND fed_non_fed2 IS NOT NULL
2505: AND set_of_books_id = gbl_sob_id
2506: UNION
2507: SELECT fed_non_fed3
2508: FROM fv_gtas_attributes
2509: WHERE gtas_acct_number = l_account_number
2510: AND fed_non_fed3 IS NOT NULL
2511: AND set_of_books_id = gbl_sob_id);
2512:

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

2779: FV_UTILITY.LOG_MESG(gbl_err_buff);
2780: END UPDATE_GTAS_RUN;
2781: --------------------------------------------------------------------------------
2782: --Modified for change request 12
2783: --Checks whether a passed value exists in fv_gtas_attributes.fed_non_fed1
2784: --2 or 3 columns
2785: PROCEDURE CHECK_FED_NONFED_CODE(p_account_number IN VARCHAR2,
2786: p_fed_nonfed_type IN VARCHAR2,
2787: p_je_source IN VARCHAR2,

Line 2791: l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;

2787: p_je_source IN VARCHAR2,
2788: p_code_exists OUT NOCOPY VARCHAR2)
2789: IS
2790: l_module_name VARCHAR2(80) := g_module_name||'CHECK_FED_NONFED_CODE';
2791: l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
2792: l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;
2793: l_fednonfed_select VARCHAR2(200);
2794: l_fednonfed_code_count NUMBER;
2795: BEGIN

Line 2792: l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;

2788: p_code_exists OUT NOCOPY VARCHAR2)
2789: IS
2790: l_module_name VARCHAR2(80) := g_module_name||'CHECK_FED_NONFED_CODE';
2791: l_fednonfed_code fv_gtas_attributes.fed_non_fed1%TYPE;
2792: l_fednonfed_code_tmp fv_gtas_attributes.fed_non_fed1%TYPE;
2793: l_fednonfed_select VARCHAR2(200);
2794: l_fednonfed_code_count NUMBER;
2795: BEGIN
2796:

Line 2802: FROM fv_gtas_attributes

2798: log(l_module_name, 'p_account_number: '||p_account_number);
2799:
2800: SELECT 'Y'
2801: INTO p_code_exists
2802: FROM fv_gtas_attributes
2803: WHERE gtas_acct_number = p_account_number
2804: AND set_of_books_id = gbl_sob_id
2805: AND (fed_non_fed1 = p_fed_nonfed_type OR
2806: fed_non_fed2 = p_fed_nonfed_type OR

Line 2900: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;

2896: p_sgl_acct_num IN VARCHAR2,
2897: p_account_num OUT NOCOPY VARCHAR2)
2898: IS
2899: l_module_name VARCHAR2(80) := g_module_name||'GET_USSGL_ACCT';
2900: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
2901: BEGIN
2902: log(l_module_name, 'Begin '||l_module_name);
2903: SELECT gtas_acct_number
2904: INTO p_account_num

Line 2905: FROM fv_gtas_attributes

2901: BEGIN
2902: log(l_module_name, 'Begin '||l_module_name);
2903: SELECT gtas_acct_number
2904: INTO p_account_num
2905: FROM fv_gtas_attributes
2906: WHERE set_of_books_id = gbl_sob_id
2907: AND gtas_acct_number = p_gtas_acct_num;
2908:
2909: log(l_module_name, 'End: '||l_module_name);