APPS.FV_SF224_TRANSACTIONS dependencies on GL_PERIOD_STATUSES

Line 302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'SELECT FROM gl_period_statuses');

298: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_run_mode = '||p_run_mode);
299: END IF;
300:
301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'SELECT FROM gl_period_statuses');
303: END IF;
304: BEGIN
305: SELECT start_date,
306: end_date,

Line 311: FROM gl_period_statuses glp

307: year_start_date
308: INTO l_start_date,
309: l_end_date,
310: l_yr_start_date
311: FROM gl_period_statuses glp
312: WHERE glp.period_name = p_gl_period
313: AND glp.ledger_id = p_set_of_books_id
314: AND glp.application_id = 101;
315: p_end_period_date := l_end_date;

Line 330: l_location := l_module_name||'select_gl_period_statuses1';

326: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
327: WHEN OTHERS THEN
328: p_error_code := g_FAILURE;
329: p_error_desc := SQLERRM;
330: l_location := l_module_name||'select_gl_period_statuses1';
331: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
332: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
333: END ;
334:

Line 392: FROM gl_period_statuses glp

388: SELECT start_date,
389: end_date
390: INTO l_start_date_2,
391: l_end_date_2
392: FROM gl_period_statuses glp
393: WHERE glp.period_name = l_gl_period(i)
394: AND glp.ledger_id = p_set_of_books_id
395: AND glp.application_id = 101;
396: EXCEPTION

Line 405: l_location := l_module_name||'select_gl_period_statuses2';

401: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
402: WHEN OTHERS THEN
403: p_error_code := g_FAILURE;
404: p_error_desc := SQLERRM;
405: l_location := l_module_name||'select_gl_period_statuses2';
406: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
407: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
408: END;
409:

Line 1500: FROM gl_period_statuses

1496: WHEN NO_DATA_FOUND THEN
1497: /* Commented out to get the old data
1498: SELECT min(start_date)
1499: INTO g_lo_date
1500: FROM gl_period_statuses
1501: WHERE ledger_id = sob
1502: AND application_id = 101
1503: AND period_year = to_char(sysdate, 'YYYY');
1504: */

Line 3098: FROM gl_period_statuses glp

3094: SELECT start_date,
3095: end_date
3096: INTO l_txn_start_date,
3097: l_txn_end_date
3098: FROM gl_period_statuses glp
3099: WHERE glp.period_name = l_gl_period
3100: AND glp.ledger_id = sob
3101: AND glp.application_id = 101;
3102: EXCEPTION WHEN OTHERS THEN

Line 5479: FROM gl_period_statuses

5475: -- Get the start Date GL_PERIOD_LOW and End Date of GL_PERIOD_HIGH
5476: BEGIN
5477: SELECT start_date
5478: INTO l_gl_start_date
5479: FROM gl_period_statuses
5480: WHERE ledger_id = l_set_of_books_id
5481: AND application_id = 101
5482: AND period_name = p_gl_period_low;
5483: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5496: FROM gl_period_statuses

5492: END;
5493: BEGIN
5494: SELECT end_date
5495: INTO l_gl_end_date
5496: FROM gl_period_statuses
5497: WHERE ledger_id = l_set_of_books_id
5498: AND application_id = 101
5499: AND period_name = p_gl_period_high;
5500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN