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_INTERFACE dependencies on FV_GTAS1_REPORT_T2

Line 18: gbl_prev_acct fv_gtas1_report_t2.account_number%TYPE;

14: gbl_bal_segment_name VARCHAR2(10);
15: gbl_acc_segment_name VARCHAR2(10);
16: gbl_acc_value_set_id NUMBER;
17: gbl_currency_code gl_sets_of_books.currency_code%TYPE;
18: gbl_prev_acct fv_gtas1_report_t2.account_number%TYPE;
19: gbl_bal_segment fv_gtas1_report_t2.fund_value%TYPE;
20:
21: gbl_exception_exists varchar2(1) := 'N';
22: gbl_header_printed BOOLEAN := FALSE;

Line 19: gbl_bal_segment fv_gtas1_report_t2.fund_value%TYPE;

15: gbl_acc_segment_name VARCHAR2(10);
16: gbl_acc_value_set_id NUMBER;
17: gbl_currency_code gl_sets_of_books.currency_code%TYPE;
18: gbl_prev_acct fv_gtas1_report_t2.account_number%TYPE;
19: gbl_bal_segment fv_gtas1_report_t2.fund_value%TYPE;
20:
21: gbl_exception_exists varchar2(1) := 'N';
22: gbl_header_printed BOOLEAN := FALSE;
23: gbl_exception_occurred BOOLEAN := FALSE;

Line 584: INSERT INTO fv_gtas1_report_t2

580: 'Inserting a record in T2 for record_category :'||
581: p_record_category||' for ccid: '||p_ccid);
582: END IF;
583:
584: INSERT INTO fv_gtas1_report_t2
585: (account_number ,
586: amount ,
587: d_c_indicator ,
588: fiscal_year ,

Line 1754: DELETE FROM fv_gtas1_report_t2

1750:
1751: log(l_module_name, 'Begin');
1752:
1753:
1754: DELETE FROM fv_gtas1_report_t2
1755: WHERE set_of_books_id = gbl_set_of_books_id;
1756:
1757: /** cleanup the line balance differrence records */
1758: FV_UTILITY.LOG_MESG('Deleting from fv_gtas_diff_balances for Period Year: '||

Line 1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;

1794: l_acct_type_condition VARCHAR2(2500);
1795:
1796: l_bal_segment VARCHAR2(30);
1797: l_bal_segment_prv VARCHAR2(30);
1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;
1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;

Line 1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;

1795:
1796: l_bal_segment VARCHAR2(30);
1797: l_bal_segment_prv VARCHAR2(30);
1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;
1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;

Line 1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;

1796: l_bal_segment VARCHAR2(30);
1797: l_bal_segment_prv VARCHAR2(30);
1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;
1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;
1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;

Line 1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;

1797: l_bal_segment_prv VARCHAR2(30);
1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;
1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;
1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;
1805:

Line 1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;

1798: l_period_begin_bal fv_gtas1_report_t2.amount%TYPE;
1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;
1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;
1805:
1806: l_exists VARCHAR2(1);

Line 1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;

1799: l_period_cy_bal fv_gtas1_report_t2.amount%TYPE;
1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;
1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;
1805:
1806: l_exists VARCHAR2(1);
1807: l_stage VARCHAR2(25);

Line 1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;

1800: l_period_cy_cr_bal fv_gtas1_report_t2.amount%TYPE;
1801: l_begin_bal fv_gtas1_report_t2.amount%TYPE;
1802: l_curr_year_balance fv_gtas1_report_t2.amount%TYPE;
1803: l_t2_deail_amount fv_gtas1_report_t2.amount%TYPE;
1804: l_ending_amount fv_gtas1_report_t2.amount%TYPE;
1805:
1806: l_exists VARCHAR2(1);
1807: l_stage VARCHAR2(25);
1808: --l_fg_null VARCHAR2(1);

Line 1971: log(l_module_name, 'Deleting records from fv_gtas1_report_t2.');

1967: when no_data_found then
1968: l_populate_flag := 'Y';
1969: End;
1970:
1971: log(l_module_name, 'Deleting records from fv_gtas1_report_t2.');
1972: DELETE FROM fv_gtas1_report_t2
1973: WHERE set_of_books_id = gbl_set_of_books_id;
1974:
1975: GET_SEGMENT_NAMES;

Line 1972: DELETE FROM fv_gtas1_report_t2

1968: l_populate_flag := 'Y';
1969: End;
1970:
1971: log(l_module_name, 'Deleting records from fv_gtas1_report_t2.');
1972: DELETE FROM fv_gtas1_report_t2
1973: WHERE set_of_books_id = gbl_set_of_books_id;
1974:
1975: GET_SEGMENT_NAMES;
1976:

Line 2555: FROM fv_gtas1_report_t2

2551:
2552: -- Count the exception records
2553: SELECT COUNT(*)
2554: INTO l_exception_count
2555: FROM fv_gtas1_report_t2
2556: WHERE set_of_books_id = gbl_set_of_books_id
2557: AND reported_status = 'E'
2558: AND amount <> 0 ;
2559:

Line 2634: --Count exceptions in fv_gtas1_report_t2

2630: xml_layout boolean;
2631: BEGIN
2632: log(l_module_name, 'Begin');
2633:
2634: --Count exceptions in fv_gtas1_report_t2
2635: --and submit exception report if there are any exceptions
2636: SELECT count(*)
2637: INTO l_exception_count
2638: FROM fv_gtas1_report_t2

Line 2638: FROM fv_gtas1_report_t2

2634: --Count exceptions in fv_gtas1_report_t2
2635: --and submit exception report if there are any exceptions
2636: SELECT count(*)
2637: INTO l_exception_count
2638: FROM fv_gtas1_report_t2
2639: WHERE set_of_books_id = gbl_set_of_books_id
2640: AND fiscal_year = gbl_fiscal_year;
2641:
2642: IF l_exception_count > 0 THEN