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_FACTS1_PERIOD_BALANCES_V

Line 421: -- of the closing year in Fv_Facts1_Period_Balances_v for

417: -- ------------------------------------------------------------------
418: -- Get_Closing_Fyr_Details procedure is called from Main procedure.
419: -- It gets the start_date,end_date,last_period of the closing fyr.
420: -- It also checks to see if there are any records for the last period
421: -- of the closing year in Fv_Facts1_Period_Balances_v for
422: -- FACTS I processing.
423: -- ------------------------------------------------------------------
424: PROCEDURE Get_Closing_Fyr_Details IS
425: l_module_name VARCHAR2(200) ;

Line 3110: vl_trading_partner Fv_Facts1_Period_Balances_v.eliminations_dept%TYPE;

3106: vl_ccid_cnt NUMBER;
3107: vl_ptype Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;
3108: vl_factsi_amount NUMBER;
3109: vl_factsi_tempamt NUMBER;
3110: vl_trading_partner Fv_Facts1_Period_Balances_v.eliminations_dept%TYPE;
3111:
3112: vl_stmt VARCHAR2(5000);
3113: vl_line_amount NUMBER;
3114: vl_attribute_cols VARCHAR2(2500);

Line 3154: FROM Fv_Facts1_Period_Balances_v

3150: ORDER BY report_sequence;
3151:
3152: CURSOR ccid_cnt_csr IS
3153: SELECT COUNT(*),SUM(NVL(amount,0))
3154: FROM Fv_Facts1_Period_Balances_v
3155: WHERE set_of_books_id = vg_sob_id
3156: AND period_num <= vg_closing_period_num
3157: AND period_year = vp_closing_fyr
3158: AND ccid = vl_ccid;

Line 3163: FROM Fv_Facts1_Period_Balances_v

3159:
3160:
3161: CURSOR factsi_bal_csr IS
3162: SELECT SUM(NVL(amount,0)) amount,eliminations_dept,g_ng_indicator
3163: FROM Fv_Facts1_Period_Balances_v
3164: WHERE set_of_books_id = vg_sob_id
3165: AND period_num <= vg_closing_period_num
3166: AND period_year = vp_closing_fyr
3167: AND ccid = vl_ccid

Line 3294: 'combination id does not exist in Fv_Facts1_Period_Balances_v.');

3290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCES WILL NOT BE CLOSED BY '||
3291:
3292: 'the FACTS I F/N and trading partner attributes for the '||
3293: 'code combination id '||vl_ccid||', since the code '||
3294: 'combination id does not exist in Fv_Facts1_Period_Balances_v.');
3295: END IF;
3296: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TO CLOSE BY FACTS I F/N AND '||
3298:

Line 3318: 'Fv_Facts1_Period_Balances_v.');

3314: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCES WILL NOT BE CLOSED BY '||
3315: 'the FACTS I F/N and trading partner attributes for the '||
3316: 'code combination id '||vl_ccid||', since the balances '||
3317: 'in GL does not equal to the balances in '||
3318: 'Fv_Facts1_Period_Balances_v.');
3319: END IF;
3320: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3321: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TO CLOSE BY FACTS I F/N AND '|| 'trading partner attributes for this code combination id, '||
3322: 'delete the journal entries created by this process, '||