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_FACTS_EDIT_CHECK dependencies on FV_FACTS_TEMP

Line 19: v_sgl_acct_number fv_facts_temp.sgl_acct_number%TYPE;

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

Line 60: -- from FV_FACTS_TEMP for budgetary accounts

56: l_total_credit NUMBER := 0;
57: l_total_debit NUMBER := 0;
58:
59: -- Cursor to fetch Credit/Debit Ending balance
60: -- from FV_FACTS_TEMP for budgetary accounts
61: CURSOR check1 IS
62: SELECT nvl(amount,0) amount, debit_credit,
63: sgl_acct_number
64: FROM fv_facts_temp

Line 64: FROM fv_facts_temp

60: -- from FV_FACTS_TEMP for budgetary accounts
61: CURSOR check1 IS
62: SELECT nvl(amount,0) amount, debit_credit,
63: sgl_acct_number
64: FROM fv_facts_temp
65: WHERE treasury_symbol_id = g_treasury_symbol_id
66: AND fct_int_record_category = 'REPORTED_NEW'
67: AND fct_int_record_type = 'BLK_DTL'
68: AND sgl_acct_number like '4%'

Line 113: -- existing in FV_FACTS_TEMP

109: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_2';
110:
111: -- Cursor to fetch SGL account and associated attributes from
112: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts
113: -- existing in FV_FACTS_TEMP
114: CURSOR fv_facts_ussgl_accounts_c IS
115: SELECT ffa.ussgl_account,
116: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
117: ffa.resource_status_be_flag, ffa.resource_status_dc_flag

Line 122: FROM fv_facts_temp fft

118: FROM fv_facts_ussgl_accounts ffa
119: WHERE ffa.ussgl_account like '4%'
120: AND EXISTS
121: (SELECT 'x'
122: FROM fv_facts_temp fft
123: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
124: AND fft.sgl_acct_number = ffa.ussgl_account);
125:
126: l_ussgl_account varchar2(30);

Line 168: FROM fv_facts_temp

164: BEGIN
165:
166: SELECT nvl(sum(amount),0)
167: INTO l_begin_bal
168: FROM fv_facts_temp
169: WHERE treasury_symbol_id = g_treasury_symbol_id
170: AND fct_int_record_category = 'REPORTED_NEW'
171: AND fct_int_record_type = 'BLK_DTL'
172: AND sgl_acct_number = l_ussgl_account

Line 193: FROM fv_facts_temp

189: BEGIN
190:
191: SELECT nvl(sum(amount),0)
192: INTO l_end_bal
193: FROM fv_facts_temp
194: WHERE treasury_symbol_id = g_treasury_symbol_id
195: AND fct_int_record_category = 'REPORTED_NEW'
196: AND fct_int_record_type = 'BLK_DTL'
197: AND sgl_acct_number = l_ussgl_account

Line 323: -- from FV_FACTS_TEMP for budgetary accounts

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

Line 326: FROM fv_facts_temp

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

Line 378: FROM fv_facts_temp fft,

374: -- Cursor to fetch ending balance, account number for all accounts
375: -- where YE_ANTICIPATED_FLAG = 'Y'
376: CURSOR anticipated_items_c is
377: SELECT nvl(sum(fft.amount),0), fft.sgl_acct_number
378: FROM fv_facts_temp fft,
379: fv_facts_ussgl_accounts ffa
380: WHERE treasury_symbol_id = g_treasury_symbol_id
381: AND fct_int_record_category = 'REPORTED_NEW'
382: 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 545: FROM fv_facts_temp fft,

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

Line 602: FROM fv_facts_temp fft,

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

Line 673: FROM fv_facts_temp fft,

669: p_treasury_symbol_id NUMBER
670: )
671: IS
672: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) obligations_incurred_s_amt
673: FROM fv_facts_temp fft,
674: fv_facts_ussgl_accounts ffa
675: WHERE ffa.obligations_incurred_flag = 'Y'
676: AND ffa.ussgl_account = fft.sgl_acct_number
677: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 691: FROM fv_facts_temp fft,

687: p_treasury_symbol_id NUMBER
688: )
689: IS
690: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) spndng_from_coll_and_pya_s_amt
691: FROM fv_facts_temp fft,
692: fv_facts_ussgl_accounts ffa
693: WHERE ffa.spndng_from_coll_and_pya_flag = 'Y'
694: AND ffa.ussgl_account = fft.sgl_acct_number
695: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 708: FROM fv_facts_temp fft,

704: p_treasury_symbol_id NUMBER
705: )
706: IS
707: SELECT SUM(NVL(amount,0)) obligations_as_of_10_1_amt
708: FROM fv_facts_temp fft,
709: fv_facts_ussgl_accounts ffa
710: WHERE ffa.obligations_as_of_10_1_flag = 'Y'
711: AND ffa.ussgl_account = fft.sgl_acct_number
712: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 726: FROM fv_facts_temp fft,

722: )
723: IS
724: SELECT NVL(SUM(DECODE(ffa.obligations_transferred_flag, 'Y', NVL(amount,0), 0)),0) obligations_transferred_amt,
725: NVL(SUM(DECODE(ffa.obligations_period_end_flag, 'Y', NVL(amount,0), 0)),0) obligations_period_end_amt
726: FROM fv_facts_temp fft,
727: fv_facts_ussgl_accounts ffa
728: WHERE (
729: ffa.obligations_transferred_flag = 'Y' OR
730: ffa.obligations_period_end_flag = 'Y'

Line 747: FROM fv_facts_temp fft,

743: )
744: IS
745: SELECT NVL(SUM(DECODE(ffa.disbursements_flag, 'Y', NVL(amount,0), 0)),0) disbursements_amt,
746: NVL(SUM(DECODE(ffa.collections_flag, 'Y', NVL(amount,0), 0)),0) collections_amt
747: FROM fv_facts_temp fft,
748: fv_facts_ussgl_accounts ffa
749: WHERE (
750: ffa.disbursements_flag = 'Y' OR
751: ffa.collections_flag = 'Y'

Line 770: FROM fv_facts_temp fft,

766: IS
767: --SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) beg_disbursements_amt
768: -- above line commnted out by ks for bug bug 5328107
769: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0),0)), 0) beg_disbursements_amt
770: FROM fv_facts_temp fft,
771: fv_facts_ussgl_accounts ffa
772: WHERE ffa.disbursements_flag = 'Y'
773: AND ffa.ussgl_account = fft.sgl_acct_number
774: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 788: FROM fv_facts_temp fft,

784: )
785: IS
786: -- ks for bug bug 5328107
787: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), 0)), 0) beg_collections_amt
788: FROM fv_facts_temp fft,
789: fv_facts_ussgl_accounts ffa
790: WHERE ffa.collections_flag = 'Y'
791: AND ffa.ussgl_account = fft.sgl_acct_number
792: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 949: FROM fv_facts_temp fft,

945:
946: CURSOR check10 IS
947: SELECT fft.sgl_acct_number,
948: SUM(NVL(fft.amount,0)) amount
949: FROM fv_facts_temp fft,
950: fv_facts_ussgl_accounts ffacc
951: WHERE ffacc.ussgl_account = fft.sgl_acct_number
952: AND fft.treasury_symbol_id = g_treasury_symbol_id
953: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 995: FROM fv_facts_temp fft,

991: SELECT ffacc.ussgl_account,
992: NVL(sum(fft.amount),0),
993: ffacc.ye_neg_receivables_flag,
994: ffacc.natural_balance
995: FROM fv_facts_temp fft,
996: fv_facts_ussgl_accounts ffacc
997: WHERE (ffacc.ye_neg_receivables_flag = 'Y'
998: OR ffacc.ye_neg_payables_flag = 'Y')
999: AND ffacc.ussgl_account = fft.sgl_acct_number

Line 1009: FROM fv_facts_temp fft,

1005:
1006: CURSOR general_acc_c IS
1007: SELECT ffacc.ussgl_account, nvl(sum(fft.amount),0),
1008: ffacc.natural_balance
1009: FROM fv_facts_temp fft,
1010: fv_facts_ussgl_accounts ffacc
1011: WHERE ffacc.ye_general_flag = 'Y'
1012: AND ffacc.ussgl_account = fft.sgl_acct_number
1013: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 1069: update fv_facts_temp

1065:
1066: l_count := l_count +1;
1067:
1068: --LGOEL: Update temp table if Edit check 11 failed
1069: update fv_facts_temp
1070: set document_number = 'Y'
1071: where sgl_acct_number = l_ussgl_account
1072: and treasury_symbol_id = g_treasury_symbol_id
1073: and fct_int_record_category = 'REPORTED_NEW'

Line 1124: update fv_facts_temp

1120:
1121: l_count := l_count +1;
1122:
1123: --LGOEL: Update temp table if Edit check 11 failed
1124: update fv_facts_temp
1125: set document_number = 'Y'
1126: where sgl_acct_number = l_ussgl_account
1127: and treasury_symbol_id = g_treasury_symbol_id
1128: and fct_int_record_category = 'REPORTED_NEW'

Line 1179: FROM fv_facts_temp fft,

1175: ffa.disbursements_flag,
1176: ffa.collections_flag,
1177: ffa.edck12_balance_type,
1178: sum(nvl(amount,0)) amount
1179: FROM fv_facts_temp fft,
1180: fv_facts_ussgl_accounts ffa
1181: WHERE (ffa.disbursements_flag = 'Y' or ffa.collections_flag = 'Y')
1182: AND ffa.ussgl_account = fft.sgl_acct_number
1183: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 1235: FROM fv_facts_temp fft

1231:
1232: IF check12_rec.edck12_balance_type = 'S' THEN
1233: SELECT sum(nvl(fft.amount,0))
1234: INTO v_begin_amount
1235: FROM fv_facts_temp fft
1236: WHERE fft.sgl_acct_number = check12_rec.sgl_acct_number
1237: AND fft.treasury_symbol_id = g_treasury_symbol_id
1238: AND fft.fct_int_record_category = 'REPORTED_NEW'
1239: AND fft.fct_int_record_type = 'BLK_DTL'

Line 1458: Insert into FV_FACTS_TEMP

1454: l_module_name VARCHAR2(200) := g_module_name || 'CREATE_LOG_RECORD';
1455: Begin
1456: v_log_counter := v_log_counter + 1 ;
1457:
1458: Insert into FV_FACTS_TEMP
1459: (FCT_INT_RECORD_CATEGORY ,
1460: TREASURY_SYMBOL_ID ,
1461: TBAL_ACCT_NUM ,
1462: FACTS_REPORT_INFO ,