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_YE_CLOSE dependencies on FV_YE_SEQ_BAL_TEMP

Line 62: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;

58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;
60: -- Bug 10399298
61: treasury_closing_method fv_fund_parameters.close_requisitions%TYPE;
62: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;
63: vg_bal_seq_amt NUMBER;
64: vg_gl_bal_amt NUMBER;
65: vg_coy_dr NUMBER;
66: vg_coy_cr NUMBER;

Line 209: -- Purging the Fv_Ye_Seq_Bal_Temp Table

205: Chk_To_Accounts;
206: END IF;
207:
208: IF (vp_retcode = 0) THEN
209: -- Purging the Fv_Ye_Seq_Bal_Temp Table
210: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PURGING THE FV_YE_SEQ_BAL_TEMP TABLE.');
212: END IF;
213: Purge_Bal_Temp_Table;

Line 211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PURGING THE FV_YE_SEQ_BAL_TEMP TABLE.');

207:
208: IF (vp_retcode = 0) THEN
209: -- Purging the Fv_Ye_Seq_Bal_Temp Table
210: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PURGING THE FV_YE_SEQ_BAL_TEMP TABLE.');
212: END IF;
213: Purge_Bal_Temp_Table;
214: END IF;
215:

Line 766: DELETE FROM Fv_Ye_Seq_Bal_Temp WHERE set_of_books_id = vg_sob_id;

762: BEGIN
763:
764: l_module_name := g_module_name ||'Purge_Bal_Temp_Table ';
765:
766: DELETE FROM Fv_Ye_Seq_Bal_Temp WHERE set_of_books_id = vg_sob_id;
767:
768: COMMIT;
769: EXCEPTION
770: WHEN OTHERS THEN

Line 799: FROM Fv_Ye_Seq_Bal_Temp

795:
796:
797: SELECT COUNT(*)
798: INTO vl_reccnt
799: FROM Fv_Ye_Seq_Bal_Temp
800: WHERE set_of_books_id = vg_sob_id;
801:
802: IF (vl_reccnt = 0) THEN
803: RAISE e_no_gldata;

Line 1890: FROM Fv_Ye_Seq_Bal_Temp

1886: vg_balance_read_flag := 'N';
1887:
1888: SELECT DISTINCT balance_read_flag
1889: INTO vg_balance_read_flag
1890: FROM Fv_Ye_Seq_Bal_Temp
1891: WHERE account_seg = vg_child_acct
1892: AND balance_seg = vg_fund_value
1893: AND set_of_books_id = vg_sob_id
1894: AND fiscal_year = vp_closing_fyr

Line 1937: FROM Fv_Ye_Seq_Bal_Temp

1933: vl_exists VARCHAR2(1) ;
1934:
1935: CURSOR get_sumtemp_cur IS
1936: SELECT NVL(SUM(bal_seq_amt),0) amt,code_combination_id
1937: FROM Fv_Ye_Seq_Bal_Temp
1938: WHERE account_seg = vg_child_acct
1939: AND balance_seg = vg_fund_value
1940: AND set_of_books_id = vg_sob_id
1941: AND group_id = vg_group_id

Line 1948: FROM Fv_Ye_Seq_Bal_Temp

1944: GROUP BY code_combination_id;
1945:
1946: CURSOR get_sumtemp_seqcur IS
1947: SELECT NVL(SUM(bal_seq_amt),0) amt,code_combination_id
1948: FROM Fv_Ye_Seq_Bal_Temp
1949: WHERE account_seg = vg_child_acct
1950: AND balance_seg = vg_fund_value
1951: AND set_of_books_id = vg_sob_id
1952: AND group_id = vg_group_id

Line 1956: FROM Fv_Ye_Seq_Bal_Temp g

1952: AND group_id = vg_group_id
1953: AND fiscal_year = vp_closing_fyr
1954: AND balance_read_flag = 'Y'
1955: AND SEQUENCE IN (SELECT MAX(SEQUENCE)
1956: FROM Fv_Ye_Seq_Bal_Temp g
1957: WHERE g.account_seg = vg_from_acct
1958: AND g.balance_seg = vg_fund_value
1959: AND g.set_of_books_id = vg_sob_id
1960: AND g.group_id = vg_group_id

Line 1966: FROM Fv_Ye_Seq_Bal_Temp

1962: GROUP BY code_combination_id;
1963:
1964: CURSOR get_addccid_cur IS
1965: SELECT NVL(SUM(bal_seq_amt),0) amt,code_combination_id
1966: FROM Fv_Ye_Seq_Bal_Temp
1967: WHERE account_seg = vg_child_acct
1968: AND balance_seg = vg_fund_value
1969: AND set_of_books_id = vg_sob_id
1970: AND group_id = vg_group_id

Line 1993: /* If there are no records defined in the Fv_Ye_Seq_Bal_Temp table *

1989: END IF;
1990: -- Purge the Pl/Sql table
1991: vt_ccid.DELETE;
1992:
1993: /* If there are no records defined in the Fv_Ye_Seq_Bal_Temp table *
1994: * for the fund and the from acct within the group that is being *
1995: * processed. This is the scenario when vg_balance_read_flag = N */
1996: IF (vg_balance_read_flag = 'N') THEN -- vg_balance_read_flag
1997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2048: FROM Fv_Ye_Seq_Bal_Temp

2044:
2045: BEGIN
2046: SELECT NVL(SUM(bal_seq_amt),0)
2047: INTO vg_bal_seq_amt
2048: FROM Fv_Ye_Seq_Bal_Temp
2049: WHERE account_seg = vg_child_acct
2050: AND balance_seg = vg_fund_value
2051: AND set_of_books_id = vg_sob_id
2052: AND group_id = vg_group_id

Line 2279: vl_processing_type Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;

2275: vl_remaining_bal NUMBER;
2276: vl_drcr_flag VARCHAR2(1);
2277: vl_read_flag VARCHAR2(1);
2278: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
2279: vl_processing_type Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;
2280: vl_acct_combi VARCHAR2(2000);
2281: vl_delimeter VARCHAR2(1);
2282: v_cross_val_msg VARCHAR2(2000);
2283: l_ccid_select varchar2(2048);

Line 2681: -- This proc inserts into the Fv_Ye_Seq_Bal_Temp table.

2677: -- ------------------------------------------------------------------
2678: -- Procedure Insert_Balances
2679: -- ------------------------------------------------------------------
2680: -- Insert_Balances procedure is called from Determine_DrCr procedure.
2681: -- This proc inserts into the Fv_Ye_Seq_Bal_Temp table.
2682: -- ------------------------------------------------------------------
2683: PROCEDURE Insert_Balances(ccid NUMBER,
2684: acct VARCHAR2,
2685: bal_amt NUMBER,

Line 2744: SELECT Fv_Ye_Seq_Bal_Temp_S.NEXTVAL

2740: END IF;
2741:
2742: -- Get the report sequence
2743: BEGIN
2744: SELECT Fv_Ye_Seq_Bal_Temp_S.NEXTVAL
2745: INTO vl_report_seq
2746: FROM DUAL;
2747: EXCEPTION
2748: WHEN OTHERS THEN

Line 2780: INSERT INTO Fv_Ye_Seq_Bal_Temp(

2776:
2777:
2778:
2779: -- Insert into the Temp table.
2780: INSERT INTO Fv_Ye_Seq_Bal_Temp(
2781: code_combination_id,
2782: group_id,
2783: SEQUENCE,
2784: account_seg,

Line 3160: vl_ptype Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;

3156: vl_amount_dr NUMBER;
3157: vl_amount_cr NUMBER;
3158: vl_ccid NUMBER(15);
3159: vl_ccid_cnt NUMBER;
3160: vl_ptype Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;
3161: vl_factsi_amount NUMBER;
3162: vl_factsi_tempamt NUMBER;
3163: vl_trading_partner Fv_Facts1_Period_Balances_v.eliminations_dept%TYPE;
3164:

Line 3205: FROM Fv_Ye_Seq_Bal_Temp

3201: period_net_cr,
3202: period_name ,
3203: balance_read_flag,
3204: processing_type
3205: FROM Fv_Ye_Seq_Bal_Temp
3206: WHERE period_net_dr + period_net_cr > 0
3207: AND set_of_books_id = vg_sob_id
3208: ORDER BY report_sequence;
3209: