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.FVFCCHKB_PKG dependencies on FV_FACTS_TEMP

Line 18: v_sgl_acct_number fv_facts_temp.sgl_acct_number%TYPE;

14: v_edit_check_status VARCHAR2(25);
15: v_amount NUMBER := 0;
16: v_amount1 NUMBER := 0;
17: v_amount2 NUMBER := 0;
18: v_sgl_acct_number fv_facts_temp.sgl_acct_number%TYPE;
19: v_dummy_var VARCHAR2(3);
20: v_row_count NUMBER := 0;
21:
22:

Line 51: -- from FV_FACTS_TEMP for budgetary accounts

47: l_total_credit NUMBER := 0;
48: l_total_debit NUMBER := 0;
49:
50: -- Cursor to fetch Credit/Debit Ending balance
51: -- from FV_FACTS_TEMP for budgetary accounts
52: CURSOR check1 IS
53: SELECT nvl(amount,0) amount, debit_credit,
54: sgl_acct_number
55: FROM fv_facts_temp

Line 55: FROM fv_facts_temp

51: -- from FV_FACTS_TEMP for budgetary accounts
52: CURSOR check1 IS
53: SELECT nvl(amount,0) amount, debit_credit,
54: sgl_acct_number
55: FROM fv_facts_temp
56: WHERE treasury_symbol_id = g_treasury_symbol_id
57: AND fct_int_record_category = 'REPORTED_NEW'
58: AND fct_int_record_type = 'BLK_DTL'
59: AND sgl_acct_number like '4%'

Line 106: -- existing in FV_FACTS_TEMP

102: PROCEDURE edit_check_2 IS
103:
104: -- Cursor to fetch SGL account and associated attributes from
105: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts
106: -- existing in FV_FACTS_TEMP
107: CURSOR fv_facts_ussgl_accounts_c IS
108: SELECT ffa.ussgl_account,
109: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
110: ffa.resource_status_be_flag, ffa.resource_status_dc_flag

Line 115: FROM fv_facts_temp fft

111: FROM fv_facts_ussgl_accounts ffa
112: WHERE ffa.ussgl_account like '4%'
113: AND EXISTS
114: (SELECT 'x'
115: FROM fv_facts_temp fft
116: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
117: AND fft.sgl_acct_number = ffa.ussgl_account);
118:
119: l_ussgl_account varchar2(30);

Line 161: FROM fv_facts_temp

157: BEGIN
158:
159: SELECT nvl(sum(amount),0)
160: INTO l_begin_bal
161: FROM fv_facts_temp
162: WHERE treasury_symbol_id = g_treasury_symbol_id
163: AND fct_int_record_category = 'REPORTED_NEW'
164: AND fct_int_record_type = 'BLK_DTL'
165: AND sgl_acct_number = l_ussgl_account

Line 186: FROM fv_facts_temp

182: BEGIN
183:
184: SELECT nvl(sum(amount),0)
185: INTO l_end_bal
186: FROM fv_facts_temp
187: WHERE treasury_symbol_id = g_treasury_symbol_id
188: AND fct_int_record_category = 'REPORTED_NEW'
189: AND fct_int_record_type = 'BLK_DTL'
190: AND sgl_acct_number = l_ussgl_account

Line 318: -- from FV_FACTS_TEMP for budgetary accounts

314: l_budget_credit NUMBER := 0;
315: l_budget_debit NUMBER := 0;
316:
317: -- Cursor to fetch Credit and Debit Beginning balance
318: -- from FV_FACTS_TEMP for budgetary accounts
319: CURSOR check3 IS
320: SELECT nvl(amount,0) amount, debit_credit, sgl_acct_number
321: FROM fv_facts_temp
322: WHERE treasury_symbol_id = g_treasury_symbol_id

Line 321: FROM fv_facts_temp

317: -- Cursor to fetch Credit and Debit Beginning balance
318: -- from FV_FACTS_TEMP for budgetary accounts
319: CURSOR check3 IS
320: SELECT nvl(amount,0) amount, debit_credit, sgl_acct_number
321: FROM fv_facts_temp
322: WHERE treasury_symbol_id = g_treasury_symbol_id
323: AND fct_int_record_category = 'REPORTED_NEW'
324: AND fct_int_record_type = 'BLK_DTL'
325: AND sgl_acct_number like '4%'

Line 375: FROM fv_facts_temp fft,

371: -- Cursor to fetch ending balance, account number for all accounts
372: -- where YE_ANTICIPATED_FLAG = 'Y'
373: CURSOR anticipated_items_c is
374: SELECT nvl(sum(fft.amount),0), fft.sgl_acct_number
375: FROM fv_facts_temp fft,
376: fv_facts_ussgl_accounts ffa
377: WHERE treasury_symbol_id = g_treasury_symbol_id
378: AND fct_int_record_category = 'REPORTED_NEW'
379: AND fct_int_record_type = 'BLK_DTL'

Line 445: FROM fv_facts_temp fft,

441: --Cursor to fetch Resource and Equity flags and amounts
442: CURSOR check5 IS
443: SELECT fft.sgl_acct_number, nvl(amount,0) amount,
444: ffa.ye_resource_equity_flag
445: FROM fv_facts_temp fft,
446: fv_facts_ussgl_accounts ffa
447: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
448: AND fft.fct_int_record_category = 'REPORTED_NEW'
449: AND fft.fct_int_record_type = 'BLK_DTL'

Line 548: FROM fv_facts_temp fft,

544: BEGIN
545:
546: SELECT NVL(sum(fft.amount),0)
547: INTO l_accounts_balance
548: FROM fv_facts_temp fft,
549: fv_facts_rt7_accounts rta
550: WHERE rta.rt7_code_id = l_rt7_code_id
551: AND rta.rt7_ussgl_account = fft.sgl_acct_number
552: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 606: FROM fv_facts_temp fft,

602: -- Cursor to fetch ending balance for accounts where
603: -- fund_balance_account_flag is 'Y'
604: CURSOR check7 IS
605: SELECT nvl(fft.amount,0) amount, fft.sgl_acct_number
606: FROM fv_facts_temp fft,
607: fv_facts_ussgl_accounts ffa
608: WHERE ffa.fund_balance_account_flag = 'Y'
609: AND fft.sgl_acct_number = ffa.ussgl_account
610: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 676: FROM fv_facts_temp fft,

672:
673: CURSOR check10 IS
674: SELECT fft.sgl_acct_number,
675: SUM(NVL(fft.amount,0)) amount
676: FROM fv_facts_temp fft,
677: fv_facts_ussgl_accounts ffacc
678: WHERE ffacc.ussgl_account = fft.sgl_acct_number
679: AND fft.treasury_symbol_id = g_treasury_symbol_id
680: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 725: FROM fv_facts_temp fft,

721: SELECT ffacc.ussgl_account,
722: NVL(sum(fft.amount),0),
723: ffacc.ye_neg_receivables_flag,
724: ffacc.natural_balance
725: FROM fv_facts_temp fft,
726: fv_facts_ussgl_accounts ffacc
727: WHERE (ffacc.ye_neg_receivables_flag = 'Y'
728: OR ffacc.ye_neg_payables_flag = 'Y')
729: AND ffacc.ussgl_account = fft.sgl_acct_number

Line 739: FROM fv_facts_temp fft,

735:
736: CURSOR general_acc_c IS
737: SELECT ffacc.ussgl_account, nvl(sum(fft.amount),0),
738: ffacc.natural_balance
739: FROM fv_facts_temp fft,
740: fv_facts_ussgl_accounts ffacc
741: WHERE ffacc.ye_general_flag = 'Y'
742: AND ffacc.ussgl_account = fft.sgl_acct_number
743: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 798: update fv_facts_temp

794:
795: l_count := l_count +1;
796:
797: --LGOEL: Update temp table if Edit check 11 failed
798: update fv_facts_temp
799: set document_number = 'Y'
800: where sgl_acct_number = l_ussgl_account
801: and treasury_symbol_id = g_treasury_symbol_id
802: and fct_int_record_category = 'REPORTED_NEW'

Line 852: update fv_facts_temp

848:
849: l_count := l_count +1;
850:
851: --LGOEL: Update temp table if Edit check 11 failed
852: update fv_facts_temp
853: set document_number = 'Y'
854: where sgl_acct_number = l_ussgl_account
855: and treasury_symbol_id = g_treasury_symbol_id
856: and fct_int_record_category = 'REPORTED_NEW'

Line 911: FROM fv_facts_temp fft,

907: ffa.disbursements_flag,
908: ffa.collections_flag,
909: ffa.edck12_balance_type,
910: nvl(amount,0) amount
911: FROM fv_facts_temp fft,
912: fv_facts_ussgl_accounts ffa
913: WHERE (ffa.disbursements_flag = 'Y' or ffa.collections_flag = 'Y')
914: AND ffa.ussgl_account = fft.sgl_acct_number
915: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 962: FROM fv_facts_temp fft

958:
959: IF check12_rec.edck12_balance_type = 'S' THEN
960: SELECT fft.amount
961: INTO v_begin_amount
962: FROM fv_facts_temp fft
963: WHERE fft.sgl_acct_number = check12_rec.sgl_acct_number
964: AND fft.treasury_symbol_id = g_treasury_symbol_id
965: AND fft.fct_int_record_category = 'REPORTED_NEW'
966: AND fft.fct_int_record_type = 'BLK_DTL'

Line 1169: Insert into FV_FACTS_TEMP

1165: is
1166: Begin
1167: v_log_counter := v_log_counter + 1 ;
1168:
1169: Insert into FV_FACTS_TEMP
1170: (FCT_INT_RECORD_CATEGORY ,
1171: TREASURY_SYMBOL_ID ,
1172: TBAL_ACCT_NUM ,
1173: FACTS_REPORT_INFO ,