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_closing_grp fv_facts_temp.closing_grp%TYPE;
21: v_dummy_var VARCHAR2(3);
22: v_row_count NUMBER := 0;
23: g_ledger_id NUMBER(15);

Line 20: v_closing_grp fv_facts_temp.closing_grp%TYPE;

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_closing_grp fv_facts_temp.closing_grp%TYPE;
21: v_dummy_var VARCHAR2(3);
22: v_row_count NUMBER := 0;
23: g_ledger_id NUMBER(15);
24: g_period_num NUMBER(15);

Line 26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;

22: v_row_count NUMBER := 0;
23: g_ledger_id NUMBER(15);
24: g_period_num NUMBER(15);
25: g_period_year NUMBER(15);
26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;
27: v_transaction_partner fv_facts_temp.transaction_partner%type;
28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;
29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;
30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;

Line 27: v_transaction_partner fv_facts_temp.transaction_partner%type;

23: g_ledger_id NUMBER(15);
24: g_period_num NUMBER(15);
25: g_period_year NUMBER(15);
26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;
27: v_transaction_partner fv_facts_temp.transaction_partner%type;
28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;
29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;
30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;
31:

Line 28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;

24: g_period_num NUMBER(15);
25: g_period_year NUMBER(15);
26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;
27: v_transaction_partner fv_facts_temp.transaction_partner%type;
28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;
29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;
30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;
31:
32: PROCEDURE populate_bal_ret_tbl ;

Line 29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;

25: g_period_year NUMBER(15);
26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;
27: v_transaction_partner fv_facts_temp.transaction_partner%type;
28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;
29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;
30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;
31:
32: PROCEDURE populate_bal_ret_tbl ;
33: PROCEDURE Create_log_record(text varchar2) ;

Line 30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;

26: v_beg_bal_sggl_acc fv_facts_temp.SGL_BEG_BAL_ACCT_NUM%type;
27: v_transaction_partner fv_facts_temp.transaction_partner%type;
28: v_aid fv_facts_temp.TRANSFER_DEPT_ID%type;
29: v_main fv_facts_temp.TRANSFER_MAIN_ACCT%type;
30: v_non_fed_exc_flag fv_facts_temp.non_fed_exc_flag%type;
31:
32: PROCEDURE populate_bal_ret_tbl ;
33: PROCEDURE Create_log_record(text varchar2) ;
34:

Line 69: -- from FV_FACTS_TEMP for budgetary accounts

65: l_total_credit NUMBER := 0;
66: l_total_debit NUMBER := 0;
67:
68: -- Cursor to fetch Credit/Debit Ending balance
69: -- from FV_FACTS_TEMP for budgetary accounts
70: CURSOR check1 IS
71: SELECT nvl(amount,0) amount, debit_credit,
72: sgl_acct_number
73: FROM fv_facts_temp

Line 73: FROM fv_facts_temp

69: -- from FV_FACTS_TEMP for budgetary accounts
70: CURSOR check1 IS
71: SELECT nvl(amount,0) amount, debit_credit,
72: sgl_acct_number
73: FROM fv_facts_temp
74: WHERE treasury_symbol_id = g_treasury_symbol_id
75: AND fct_int_record_category = 'REPORTED_NEW'
76: AND fct_int_record_type = 'BLK_DTL'
77: AND sgl_acct_number like '4%'

Line 122: -- existing in FV_FACTS_TEMP

118: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_2';
119:
120: -- Cursor to fetch SGL account and associated attributes from
121: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts
122: -- existing in FV_FACTS_TEMP
123: CURSOR fv_facts_ussgl_accounts_c IS
124: SELECT ffa.ussgl_account,
125: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
126: ffa.resource_status_be_flag, ffa.resource_status_dc_flag

Line 131: FROM fv_facts_temp fft

127: FROM fv_facts_ussgl_accounts ffa
128: WHERE ffa.ussgl_account like '4%'
129: AND EXISTS
130: (SELECT 'x'
131: FROM fv_facts_temp fft
132: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
133: AND fft.sgl_acct_number = ffa.ussgl_account);
134:
135: l_ussgl_account varchar2(30);

Line 177: FROM fv_facts_temp

173: BEGIN
174:
175: SELECT nvl(sum(amount),0)
176: INTO l_begin_bal
177: FROM fv_facts_temp
178: WHERE treasury_symbol_id = g_treasury_symbol_id
179: AND fct_int_record_category = 'REPORTED_NEW'
180: AND fct_int_record_type = 'BLK_DTL'
181: AND sgl_acct_number = l_ussgl_account

Line 202: FROM fv_facts_temp

198: BEGIN
199:
200: SELECT nvl(sum(amount),0)
201: INTO l_end_bal
202: FROM fv_facts_temp
203: WHERE treasury_symbol_id = g_treasury_symbol_id
204: AND fct_int_record_category = 'REPORTED_NEW'
205: AND fct_int_record_type = 'BLK_DTL'
206: AND sgl_acct_number = l_ussgl_account

Line 332: -- from FV_FACTS_TEMP for budgetary accounts

328: l_budget_credit NUMBER := 0;
329: l_budget_debit NUMBER := 0;
330:
331: -- Cursor to fetch Credit and Debit Beginning balance
332: -- from FV_FACTS_TEMP for budgetary accounts
333: CURSOR check3 IS
334: SELECT nvl(amount,0) amount, debit_credit, sgl_acct_number
335: FROM fv_facts_temp
336: WHERE treasury_symbol_id = g_treasury_symbol_id

Line 335: FROM fv_facts_temp

331: -- Cursor to fetch Credit and Debit Beginning balance
332: -- from FV_FACTS_TEMP for budgetary accounts
333: CURSOR check3 IS
334: SELECT nvl(amount,0) amount, debit_credit, sgl_acct_number
335: FROM fv_facts_temp
336: WHERE treasury_symbol_id = g_treasury_symbol_id
337: AND fct_int_record_category = 'REPORTED_NEW'
338: AND fct_int_record_type = 'BLK_DTL'
339: AND sgl_acct_number like '4%'

Line 387: FROM fv_facts_temp fft,

383: -- Cursor to fetch ending balance, account number for all accounts
384: -- where YE_ANTICIPATED_FLAG = 'Y'
385: CURSOR anticipated_items_c is
386: SELECT nvl(sum(fft.amount),0), fft.sgl_acct_number
387: FROM fv_facts_temp fft,
388: fv_facts_ussgl_accounts ffa
389: WHERE treasury_symbol_id = g_treasury_symbol_id
390: AND fct_int_record_category = 'REPORTED_NEW'
391: AND fct_int_record_type = 'BLK_DTL'

Line 454: FROM fv_facts_temp fft,

450: --Cursor to fetch Resource and Equity flags and amounts
451: CURSOR check5 IS
452: SELECT fft.sgl_acct_number, nvl(amount,0) amount,
453: ffa.ye_resource_equity_flag
454: FROM fv_facts_temp fft,
455: fv_facts_ussgl_accounts ffa
456: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
457: AND fft.fct_int_record_category = 'REPORTED_NEW'
458: AND fft.fct_int_record_type = 'BLK_DTL'

Line 554: FROM fv_facts_temp fft,

550: BEGIN
551:
552: SELECT NVL(sum(fft.amount),0)
553: INTO l_accounts_balance
554: FROM fv_facts_temp fft,
555: fv_facts_rt7_accounts rta
556: WHERE rta.rt7_code_id = l_rt7_code_id
557: AND rta.rt7_ussgl_account = fft.sgl_acct_number
558: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 611: FROM fv_facts_temp fft,

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

Line 684: FROM fv_facts_temp fft,

680: p_treasury_symbol_id NUMBER
681: )
682: IS
683: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) obligations_incurred_s_amt
684: FROM fv_facts_temp fft,
685: fv_facts_ussgl_accounts ffa
686: WHERE ffa.obligations_incurred_flag = 'Y'
687: AND ffa.ussgl_account = fft.sgl_acct_number
688: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 702: FROM fv_facts_temp fft,

698: p_treasury_symbol_id NUMBER
699: )
700: IS
701: 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
702: FROM fv_facts_temp fft,
703: fv_facts_ussgl_accounts ffa
704: WHERE ffa.spndng_from_coll_and_pya_flag = 'Y'
705: AND ffa.ussgl_account = fft.sgl_acct_number
706: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 719: FROM fv_facts_temp fft,

715: p_treasury_symbol_id NUMBER
716: )
717: IS
718: SELECT SUM(NVL(amount,0)) obligations_as_of_10_1_amt
719: FROM fv_facts_temp fft,
720: fv_facts_ussgl_accounts ffa
721: WHERE ffa.obligations_as_of_10_1_flag = 'Y'
722: AND ffa.ussgl_account = fft.sgl_acct_number
723: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 737: FROM fv_facts_temp fft,

733: )
734: IS
735: SELECT NVL(SUM(DECODE(ffa.obligations_transferred_flag, 'Y', NVL(amount,0), 0)),0) obligations_transferred_amt,
736: NVL(SUM(DECODE(ffa.obligations_period_end_flag, 'Y', NVL(amount,0), 0)),0) obligations_period_end_amt
737: FROM fv_facts_temp fft,
738: fv_facts_ussgl_accounts ffa
739: WHERE (
740: ffa.obligations_transferred_flag = 'Y' OR
741: ffa.obligations_period_end_flag = 'Y'

Line 758: FROM fv_facts_temp fft,

754: )
755: IS
756: SELECT NVL(SUM(DECODE(ffa.disbursements_flag, 'Y', NVL(amount,0), 0)),0) disbursements_amt,
757: NVL(SUM(DECODE(ffa.collections_flag, 'Y', NVL(amount,0), 0)),0) collections_amt
758: FROM fv_facts_temp fft,
759: fv_facts_ussgl_accounts ffa
760: WHERE (
761: ffa.disbursements_flag = 'Y' OR
762: ffa.collections_flag = 'Y'

Line 781: FROM fv_facts_temp fft,

777: IS
778: --SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), NVL(fft.amount,0))), 0) beg_disbursements_amt
779: -- above line commnted out by ks for bug bug 5328107
780: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0),0)), 0) beg_disbursements_amt
781: FROM fv_facts_temp fft,
782: fv_facts_ussgl_accounts ffa
783: WHERE ffa.disbursements_flag = 'Y'
784: AND ffa.ussgl_account = fft.sgl_acct_number
785: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 799: FROM fv_facts_temp fft,

795: )
796: IS
797: -- ks for bug bug 5328107
798: SELECT NVL(SUM(DECODE(fft.begin_end, 'B', -1*NVL(fft.amount,0), 0)), 0) beg_collections_amt
799: FROM fv_facts_temp fft,
800: fv_facts_ussgl_accounts ffa
801: WHERE ffa.collections_flag = 'Y'
802: AND ffa.ussgl_account = fft.sgl_acct_number
803: AND fft.treasury_symbol_id = p_treasury_symbol_id

Line 986: FROM fv_facts_temp fft,

982:
983: BEGIN
984: SELECT NVL(sum(fft.amount),0)
985: INTO l_accounts_balance
986: FROM fv_facts_temp fft,
987: fv_facts_rt7_accounts rta,
988: fv_facts_rt7_codes rtc
989: WHERE rtc.factsII_edit_code = 'Subclass 43'
990: AND rta.rt7_code_id = rtc.rt7_code_id

Line 1056: FROM fv_facts_temp fft,

1052:
1053: CURSOR check10 IS
1054: SELECT fft.sgl_acct_number,
1055: SUM(NVL(fft.amount,0)) amount
1056: FROM fv_facts_temp fft,
1057: fv_facts_ussgl_accounts ffacc
1058: WHERE ffacc.ussgl_account = fft.sgl_acct_number
1059: AND fft.treasury_symbol_id = g_treasury_symbol_id
1060: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 1102: FROM fv_facts_temp fft,

1098: SELECT ffacc.ussgl_account,
1099: NVL(sum(fft.amount),0),
1100: ffacc.ye_neg_receivables_flag,
1101: ffacc.natural_balance
1102: FROM fv_facts_temp fft,
1103: fv_facts_ussgl_accounts ffacc
1104: WHERE (ffacc.ye_neg_receivables_flag = 'Y'
1105: OR ffacc.ye_neg_payables_flag = 'Y')
1106: AND ffacc.ussgl_account = fft.sgl_acct_number

Line 1116: FROM fv_facts_temp fft,

1112:
1113: CURSOR general_acc_c IS
1114: SELECT ffacc.ussgl_account, nvl(sum(fft.amount),0),
1115: ffacc.natural_balance
1116: FROM fv_facts_temp fft,
1117: fv_facts_ussgl_accounts ffacc
1118: WHERE ffacc.ye_general_flag = 'Y'
1119: AND ffacc.ussgl_account = fft.sgl_acct_number
1120: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 1176: update fv_facts_temp

1172:
1173: l_count := l_count +1;
1174:
1175: --LGOEL: Update temp table if Edit check 11 failed
1176: update fv_facts_temp
1177: set document_number = 'Y'
1178: where sgl_acct_number = l_ussgl_account
1179: and treasury_symbol_id = g_treasury_symbol_id
1180: and fct_int_record_category = 'REPORTED_NEW'

Line 1231: update fv_facts_temp

1227:
1228: l_count := l_count +1;
1229:
1230: --LGOEL: Update temp table if Edit check 11 failed
1231: update fv_facts_temp
1232: set document_number = 'Y'
1233: where sgl_acct_number = l_ussgl_account
1234: and treasury_symbol_id = g_treasury_symbol_id
1235: and fct_int_record_category = 'REPORTED_NEW'

Line 1286: FROM fv_facts_temp fft,

1282: ffa.disbursements_flag,
1283: ffa.collections_flag,
1284: ffa.edck12_balance_type,
1285: sum(nvl(amount,0)) amount
1286: FROM fv_facts_temp fft,
1287: fv_facts_ussgl_accounts ffa
1288: WHERE (ffa.disbursements_flag = 'Y' or ffa.collections_flag = 'Y')
1289: AND ffa.ussgl_account = fft.sgl_acct_number
1290: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 1342: FROM fv_facts_temp fft

1338:
1339: IF check12_rec.edck12_balance_type = 'S' THEN
1340: SELECT sum(nvl(fft.amount,0))
1341: INTO v_begin_amount
1342: FROM fv_facts_temp fft
1343: WHERE fft.sgl_acct_number = check12_rec.sgl_acct_number
1344: AND fft.treasury_symbol_id = g_treasury_symbol_id
1345: AND fft.fct_int_record_category = 'REPORTED_NEW'
1346: AND fft.fct_int_record_type = 'BLK_DTL'

Line 1432: FROM fv_facts_temp tmp,

1428: CURSOR closing_acct_c(p_closing_grp VARCHAR2)
1429: IS
1430: SELECT SUM(tmp.amount) amt,
1431: clos.authority_code auth_type
1432: FROM fv_facts_temp tmp,
1433: fv_facts2_closing_validation clos
1434: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
1435: and tmp.fct_int_record_category='REPORTED_NEW'
1436: and tmp.fct_int_record_type='BLK_DTL'

Line 1517: FROM fv_facts_temp tmp,

1513: END IF;
1514:
1515: SELECT COUNT(*)
1516: INTO l_temp_count
1517: FROM fv_facts_temp tmp,
1518: fv_facts2_closing_validation clos
1519: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
1520: AND tmp.fct_int_record_category='REPORTED_NEW'
1521: AND tmp.fct_int_record_type ='BLK_DTL'

Line 1546: * Also populating the FV_FACTS_TEMP table.

1542: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Is hard edit 13 flag on Federal financial options form selected ? '||flg);
1543: END IF;
1544: --fnd_file.put_line(fnd_file.log , 'flg ::' || flg);
1545: /* Iterating over the closing_act_c and calculating the begining bal and end balance
1546: * Also populating the FV_FACTS_TEMP table.
1547: * Report will use this table to show data.
1548: */
1549: FOR get_all_closing_rec IN get_all_closing_acct
1550: LOOP

Line 1634: -- in to fv_facts_temp table.

1630: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1631: '::'||sum_ending_bal);
1632: END IF;
1633: -- To display layout when no value inserted
1634: -- in to fv_facts_temp table.
1635: SELECT count(*) into l_has_data_count
1636: FROM fv_facts_temp
1637: WHERE treasury_symbol_id =g_treasury_symbol_id
1638: AND edit_check_number=13

Line 1636: FROM fv_facts_temp

1632: END IF;
1633: -- To display layout when no value inserted
1634: -- in to fv_facts_temp table.
1635: SELECT count(*) into l_has_data_count
1636: FROM fv_facts_temp
1637: WHERE treasury_symbol_id =g_treasury_symbol_id
1638: AND edit_check_number=13
1639: AND closing_grp =l_closing_gp;
1640:

Line 1680: FROM fv_facts_temp facts, fv_facts_ussgl_accounts uss

1676: flg varchar2(1);
1677:
1678: CURSOR control_check1 IS
1679: SELECT nvl(amount,0) amt, facts.sgl_acct_number control_acct
1680: FROM fv_facts_temp facts, fv_facts_ussgl_accounts uss
1681: WHERE facts.treasury_symbol_id = g_treasury_symbol_id
1682: AND uss.ussgl_account = facts.sgl_acct_number
1683: AND uss.reclassification_ctrl_flag = 'Y' AND begin_end = 'E'
1684: AND amount <> 0 and facts.fct_int_record_category = 'REPORTED_NEW'

Line 1689: FROM fv_facts_temp facts, fv_facts_ussgl_accounts uss

1685: AND facts.fct_int_record_type = 'BLK_DTL' ORDER BY sgl_acct_number;
1686:
1687: CURSOR sum_check1 IS
1688: SELECT nvl(amount,0) amt, facts.sgl_acct_number summation_acct
1689: FROM fv_facts_temp facts, fv_facts_ussgl_accounts uss
1690: WHERE facts.treasury_symbol_id = g_treasury_symbol_id
1691: AND uss.ussgl_account = facts.sgl_acct_number
1692: AND uss.reclassification_sum_acc_flag = 'Y' AND begin_end = 'E'
1693: AND amount <> 0 and facts.fct_int_record_category = 'REPORTED_NEW'

Line 1770: FROM fv_facts_temp

1766: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_15';
1767:
1768: CURSOR check_4157 IS
1769: SELECT nvl(amount,0) amt, sgl_acct_number acct
1770: FROM fv_facts_temp
1771: WHERE treasury_symbol_id = g_treasury_symbol_id
1772: AND sgl_acct_number = '4157'
1773: AND begin_end = 'E'
1774: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 1779: FROM fv_facts_temp

1775: AND fct_int_record_type = 'BLK_DTL';
1776:
1777: CURSOR check_4397 IS
1778: SELECT nvl(amount,0) amt, sgl_acct_number acct
1779: FROM fv_facts_temp
1780: WHERE treasury_symbol_id = g_treasury_symbol_id
1781: AND sgl_acct_number = '4397'
1782: AND begin_end = 'E'
1783: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 1860: FROM fv_facts_temp

1856: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_16';
1857:
1858: CURSOR check_4158 IS
1859: SELECT nvl(amount,0) amt, sgl_acct_number acct
1860: FROM fv_facts_temp
1861: WHERE treasury_symbol_id = g_treasury_symbol_id
1862: AND sgl_acct_number = '4158'
1863: AND begin_end = 'E'
1864: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 1869: FROM fv_facts_temp

1865: AND fct_int_record_type = 'BLK_DTL';
1866:
1867: CURSOR check_4398 IS
1868: SELECT nvl(amount,0) amt, sgl_acct_number acct
1869: FROM fv_facts_temp
1870: WHERE treasury_symbol_id = g_treasury_symbol_id
1871: AND sgl_acct_number = '4398'
1872: AND begin_end = 'E'
1873: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 1950: FROM fv_facts_temp

1946: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_17';
1947:
1948: CURSOR chk17_1_4871_4971 IS
1949: SELECT nvl(amount,0) amt , sgl_acct_number
1950: FROM fv_facts_temp
1951: WHERE treasury_symbol_id = g_treasury_symbol_id
1952: AND sgl_acct_number in (4871, 4971)
1953: AND begin_end = 'E'
1954: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 1959: FROM fv_facts_temp

1955: AND fct_int_record_type = 'BLK_DTL' ORDER BY sgl_acct_number;
1956:
1957: CURSOR chk17_2_4134_4144 IS
1958: SELECT nvl(amount,0) amt , sgl_acct_number
1959: FROM fv_facts_temp
1960: WHERE treasury_symbol_id = g_treasury_symbol_id
1961: AND sgl_acct_number in (4134, 4144)
1962: AND begin_end = 'E'
1963: AND amount <> 0 and fct_int_record_category = 'REPORTED_NEW'

Line 2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts

2052:
2053: CURSOR check_18 IS
2054: SELECT nvl(amount,0) amt , sgl_acct_number, transaction_partner,
2055: treasury_dept_code, treasury_acct_code, decode(fffa.non_fed_exc_flag,'Y', 'Allowed','Not Allowed')non_fed_exc_flag_desc
2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts
2057: WHERE facts.treasury_symbol_id = g_treasury_symbol_id
2058: AND facts.treasury_symbol_id = fts.treasury_symbol_id
2059: AND fts.federal_Acct_symbol_id = fffa.federal_Acct_symbol_id
2060: AND ((transaction_partner = 'E'

Line 2147: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl

2143: v_edit_check_number := 18.1;
2144: v_amount1 := NULL;
2145:
2146: SELECT sum(amount) amt INTO v_amount1
2147: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl
2148: WHERE treasury_symbol_id = g_treasury_symbol_id
2149: AND trim(bea_category) = 'D'
2150: AND pya_flag = 'X'
2151: AND temp.sgl_acct_number = ussgl.ussgl_account

Line 2188: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl

2184: */
2185: v_edit_check_number := 18.2;
2186:
2187: SELECT sum(amount) amt INTO v_amount1
2188: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl
2189: WHERE treasury_symbol_id = g_treasury_symbol_id
2190: AND trim(bea_category) = 'M'
2191: AND pya_flag = 'X'
2192: AND temp.sgl_acct_number = ussgl.ussgl_account

Line 2231: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl

2227: */
2228: v_edit_check_number := 18.3;
2229:
2230: SELECT sum(amount) amt INTO v_amount1
2231: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl
2232: WHERE treasury_symbol_id = g_treasury_symbol_id
2233: AND trim(REIMBURSEABLE_FLAG) = 'D'
2234: AND pya_flag = 'X'
2235: AND temp.sgl_acct_number = ussgl.ussgl_account

Line 2275: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl

2271: */
2272: v_edit_check_number := 18.4;
2273:
2274: SELECT sum(amount) amt INTO v_amount1
2275: FROM fv_facts_temp temp, fv_facts_ussgl_accounts ussgl
2276: WHERE treasury_symbol_id = g_treasury_symbol_id
2277: AND trim(REIMBURSEABLE_FLAG) = 'R'
2278: AND pya_flag = 'X'
2279: AND temp.sgl_acct_number = ussgl.ussgl_account

Line 2360: FROM fv_facts_temp

2356: l_combined_status NUMBER := 0;
2357:
2358: CURSOR check19_bud(pya_val VARCHAR2) IS
2359: SELECT sgl_acct_number, amount
2360: FROM fv_facts_temp
2361: WHERE treasury_symbol_id = g_treasury_symbol_id
2362: AND fct_int_record_category = 'REPORTED_NEW'
2363: AND fct_int_record_type = 'BLK_DTL'
2364: AND pya_flag = pya_val

Line 2372: FROM fv_facts_temp

2368: ORDER BY sgl_acct_number;
2369:
2370: CURSOR check19_prop(pya_val VARCHAR2) IS
2371: SELECT sgl_acct_number, amount
2372: FROM fv_facts_temp
2373: WHERE treasury_symbol_id = g_treasury_symbol_id
2374: AND fct_int_record_category = 'REPORTED_NEW'
2375: AND fct_int_record_type = 'BLK_DTL'
2376: AND pya_flag = pya_val

Line 2568: p_acct_number FV_FACTS_TEMP.SGL_ACCT_NUMBER%TYPE;

2564: l_status_4149 NUMBER := 0;
2565: l_combined_sum NUMBER := 0;
2566:
2567: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_20';
2568: p_acct_number FV_FACTS_TEMP.SGL_ACCT_NUMBER%TYPE;
2569:
2570: CURSOR chk20 IS
2571: SELECT SUM(nvl(tempbeg.amount,0)) begamt , SUM( nvl(tempend.amount,0)) endamt,
2572: tempbeg.sgl_acct_number begsgl_acct_number, tempend.sgl_acct_number endsgl_acct_number

Line 2574: FROM fv_facts_temp

2570: CURSOR chk20 IS
2571: SELECT SUM(nvl(tempbeg.amount,0)) begamt , SUM( nvl(tempend.amount,0)) endamt,
2572: tempbeg.sgl_acct_number begsgl_acct_number, tempend.sgl_acct_number endsgl_acct_number
2573: FROM (SELECT amount, sgl_acct_number
2574: FROM fv_facts_temp
2575: WHERE treasury_symbol_id = g_treasury_symbol_id
2576: AND fct_int_record_category = 'REPORTED_NEW'
2577: AND fct_int_record_type = 'BLK_DTL'
2578: AND sgl_acct_number IN('4201','4139','4149')

Line 2581: FROM fv_facts_temp

2577: AND fct_int_record_type = 'BLK_DTL'
2578: AND sgl_acct_number IN('4201','4139','4149')
2579: AND begin_end = 'B') tempbeg FULL OUTER JOIN
2580: (SELECT amount, sgl_acct_number
2581: FROM fv_facts_temp
2582: WHERE treasury_symbol_id = g_treasury_symbol_id
2583: AND fct_int_record_category = 'REPORTED_NEW'
2584: AND fct_int_record_type = 'BLK_DTL'
2585: AND sgl_acct_number IN('4201','4139','4149')

Line 2929: Insert into FV_FACTS_TEMP

2925: l_module_name VARCHAR2(200) := g_module_name || 'CREATE_LOG_RECORD';
2926: Begin
2927: v_log_counter := v_log_counter + 1 ;
2928:
2929: Insert into FV_FACTS_TEMP
2930: (FCT_INT_RECORD_CATEGORY ,
2931: TREASURY_SYMBOL_ID ,
2932: TBAL_ACCT_NUM ,
2933: FACTS_REPORT_INFO ,

Line 2984: FROM fv_facts_temp tmp,

2980: tmp.sgl_acct_number ,
2981: tmp.treasury_symbol_id,
2982: att.authority_type,
2983: clos.closing_grp
2984: FROM fv_facts_temp tmp,
2985: fv_facts_attributes att,
2986: fv_facts2_closing_validation clos
2987: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
2988: AND tmp.begin_end = 'E'

Line 3006: FROM fv_facts_temp tmp,

3002: tmp.sgl_acct_number ,
3003: tmp.treasury_symbol_id,
3004: att.authority_type,
3005: clos.closing_grp
3006: FROM fv_facts_temp tmp,
3007: fv_facts_attributes att,
3008: fv_facts2_closing_validation clos
3009: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3010: AND tmp.begin_end = 'E'

Line 3027: FROM fv_facts_temp tmp,

3023: tmp.sgl_acct_number ,
3024: tmp.treasury_symbol_id,
3025: tmp.authority_type,
3026: clos.closing_grp
3027: FROM fv_facts_temp tmp,
3028: fv_facts2_closing_validation clos
3029: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3030: AND tmp.begin_end = 'E'
3031: AND tmp.fct_int_record_category='REPORTED_NEW'

Line 3079: FROM fv_facts_temp tmp,

3075: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for treasury symbol id '||g_treasury_symbol_id,v_log_text);
3076: END;
3077: /* SELECT COUNT(*)
3078: INTO l_count
3079: FROM fv_facts_temp tmp,
3080: fv_facts_attributes att,
3081: fv_facts2_closing_validation clos
3082: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3083: AND tmp.begin_end = 'E'