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_USSGL_ACCOUNTS

Line 121: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts

117: PROCEDURE edit_check_2 IS
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,

Line 123: CURSOR fv_facts_ussgl_accounts_c IS

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
127: FROM fv_facts_ussgl_accounts ffa

Line 127: FROM fv_facts_ussgl_accounts ffa

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
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

Line 156: OPEN fv_facts_ussgl_accounts_c;

152: BEGIN
153: init_vars;
154: v_edit_check_number := 2;
155:
156: OPEN fv_facts_ussgl_accounts_c;
157:
158: LOOP
159:
160: FETCH fv_facts_ussgl_accounts_c

Line 160: FETCH fv_facts_ussgl_accounts_c

156: OPEN fv_facts_ussgl_accounts_c;
157:
158: LOOP
159:
160: FETCH fv_facts_ussgl_accounts_c
161: INTO l_ussgl_account,
162: l_total_resource_be_flag,
163: l_total_resource_dc_flag,
164: l_resource_status_be_flag,

Line 167: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND

163: l_total_resource_dc_flag,
164: l_resource_status_be_flag,
165: l_resource_status_dc_flag;
166:
167: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND
168: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;
169:
170: -- Fetch beginning balance and set debit_credit
171: -- indicator for the SGL account

Line 168: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;

164: l_resource_status_be_flag,
165: l_resource_status_dc_flag;
166:
167: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND
168: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;
169:
170: -- Fetch beginning balance and set debit_credit
171: -- indicator for the SGL account
172:

Line 304: CLOSE fv_facts_ussgl_accounts_c;

300: create_log_record(v_log_text);
301:
302: END LOOP;
303:
304: CLOSE fv_facts_ussgl_accounts_c;
305:
306: l_st_total := -1*l_st_total;
307:
308: IF (l_to_total = l_st_total) THEN

Line 388: fv_facts_ussgl_accounts ffa

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'
392: AND ffa.ussgl_account = fft.sgl_acct_number

Line 455: fv_facts_ussgl_accounts ffa

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'
459: AND ffa.ussgl_account = fft.sgl_acct_number

Line 612: fv_facts_ussgl_accounts ffa

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
616: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 685: fv_facts_ussgl_accounts ffa

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
689: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 703: fv_facts_ussgl_accounts ffa

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
707: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 720: fv_facts_ussgl_accounts ffa

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
724: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 738: fv_facts_ussgl_accounts ffa

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'
742: )

Line 759: fv_facts_ussgl_accounts ffa

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'
763: )

Line 782: fv_facts_ussgl_accounts ffa

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
786: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 800: fv_facts_ussgl_accounts ffa

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
804: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 1057: fv_facts_ussgl_accounts ffacc

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'
1061: AND fft.fct_int_record_type = 'BLK_DTL'

Line 1103: fv_facts_ussgl_accounts ffacc

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
1107: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 1117: fv_facts_ussgl_accounts ffacc

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
1121: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 1131: l_natural_balance FV_FACTS_USSGL_ACCOUNTS.NATURAL_BALANCE%TYPE;

1127: l_amount number;
1128: l_acc_type varchar2(25);
1129: l_count number;
1130: l_neg_receivables_flag varchar2(1);
1131: l_natural_balance FV_FACTS_USSGL_ACCOUNTS.NATURAL_BALANCE%TYPE;
1132: l_dc_ind varchar2(1);
1133:
1134: BEGIN
1135:

Line 1287: fv_facts_ussgl_accounts ffa

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
1291: AND fft.fct_int_record_category = 'REPORTED_NEW'

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 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