APPS.FV_SF224_TRANSACTIONS dependencies on GL_PERIOD_STATUSES

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

289: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_run_mode = '||p_run_mode);
290: END IF;
291:
292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'SELECT FROM gl_period_statuses');
294: END IF;
295: BEGIN
296: SELECT start_date,
297: end_date,

Line 302: FROM gl_period_statuses glp

298: year_start_date
299: INTO l_start_date,
300: l_end_date,
301: l_yr_start_date
302: FROM gl_period_statuses glp
303: WHERE glp.period_name = p_gl_period
304: AND glp.ledger_id = p_set_of_books_id
305: AND glp.application_id = 101;
306: p_end_period_date := l_end_date;

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

317: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
318: WHEN OTHERS THEN
319: p_error_code := g_FAILURE;
320: p_error_desc := SQLERRM;
321: l_location := l_module_name||'select_gl_period_statuses1';
322: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
323: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
324: END ;
325:

Line 382: FROM gl_period_statuses glp

378: SELECT start_date,
379: end_date
380: INTO l_start_date_2,
381: l_end_date_2
382: FROM gl_period_statuses glp
383: WHERE glp.period_name = l_gl_period(i)
384: AND glp.ledger_id = p_set_of_books_id
385: AND glp.application_id = 101;
386: EXCEPTION

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

391: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
392: WHEN OTHERS THEN
393: p_error_code := g_FAILURE;
394: p_error_desc := SQLERRM;
395: l_location := l_module_name||'select_gl_period_statuses2';
396: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
397: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
398: END;
399:

Line 1479: FROM gl_period_statuses

1475: WHEN NO_DATA_FOUND THEN
1476: /* Commented out to get the old data
1477: SELECT min(start_date)
1478: INTO g_lo_date
1479: FROM gl_period_statuses
1480: WHERE ledger_id = sob
1481: AND application_id = 101
1482: AND period_year = to_char(sysdate, 'YYYY');
1483: */

Line 2970: FROM gl_period_statuses glp

2966: SELECT start_date,
2967: end_date
2968: INTO l_txn_start_date,
2969: l_txn_end_date
2970: FROM gl_period_statuses glp
2971: WHERE glp.period_name = l_gl_period
2972: AND glp.ledger_id = sob
2973: AND glp.application_id = 101;
2974: EXCEPTION WHEN OTHERS THEN

Line 5335: FROM gl_period_statuses

5331: -- Get the start Date GL_PERIOD_LOW and End Date of GL_PERIOD_HIGH
5332: BEGIN
5333: SELECT start_date
5334: INTO l_gl_start_date
5335: FROM gl_period_statuses
5336: WHERE ledger_id = l_set_of_books_id
5337: AND application_id = 101
5338: AND period_name = p_gl_period_low;
5339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5352: FROM gl_period_statuses

5348: END;
5349: BEGIN
5350: SELECT end_date
5351: INTO l_gl_end_date
5352: FROM gl_period_statuses
5353: WHERE ledger_id = l_set_of_books_id
5354: AND application_id = 101
5355: AND period_name = p_gl_period_high;
5356: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN