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 445: -- of the closing year in Fv_Facts1_Period_Balances_v for

441: -- ------------------------------------------------------------------
442: -- Get_Closing_Fyr_Details procedure is called from Main procedure.
443: -- It gets the start_date,end_date,last_period of the closing fyr.
444: -- It also checks to see if there are any records for the last period
445: -- of the closing year in Fv_Facts1_Period_Balances_v for
446: -- FACTS I processing.
447: -- ------------------------------------------------------------------
448: PROCEDURE Get_Closing_Fyr_Details IS
449: l_module_name VARCHAR2(200) ;

Line 3163: vl_trading_partner Fv_Facts1_Period_Balances_v.eliminations_dept%TYPE;

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:
3165: vl_stmt VARCHAR2(5000);
3166: vl_line_amount NUMBER;
3167: vl_attribute_cols VARCHAR2(2500);

Line 3212: FROM Fv_Facts1_Period_Balances_v

3208: ORDER BY report_sequence;
3209:
3210: CURSOR ccid_cnt_csr IS
3211: SELECT COUNT(*),SUM(NVL(amount,0))
3212: FROM Fv_Facts1_Period_Balances_v
3213: WHERE set_of_books_id = vg_sob_id
3214: AND period_num <= vg_closing_period_num
3215: AND period_year = vp_closing_fyr
3216: AND ccid = vl_ccid;

Line 3221: FROM Fv_Facts1_Period_Balances_v

3217:
3218:
3219: CURSOR factsi_bal_csr IS
3220: SELECT SUM(NVL(amount,0)) amount,eliminations_dept,g_ng_indicator
3221: FROM Fv_Facts1_Period_Balances_v
3222: WHERE set_of_books_id = vg_sob_id
3223: AND period_num <= vg_closing_period_num
3224: AND period_year = vp_closing_fyr
3225: AND ccid = vl_ccid

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

3379: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCES WILL NOT BE CLOSED BY '||
3380:
3381: 'the FACTS I F/N and trading partner attributes for the '||
3382: 'code combination id '||vl_ccid||', since the code '||
3383: 'combination id does not exist in Fv_Facts1_Period_Balances_v.');
3384: END IF;
3385: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3386: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TO CLOSE BY FACTS I F/N AND '||
3387:

Line 3407: 'Fv_Facts1_Period_Balances_v.');

3403: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCES WILL NOT BE CLOSED BY '||
3404: 'the FACTS I F/N and trading partner attributes for the '||
3405: 'code combination id '||vl_ccid||', since the balances '||
3406: 'in GL does not equal to the balances in '||
3407: 'Fv_Facts1_Period_Balances_v.');
3408: END IF;
3409: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3410: 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, '||
3411: 'delete the journal entries created by this process, '||