[Home] [Help]
94: l_functional_currency fnd_currencies_vl.NAME%TYPE;
95:
96: ld_start_date DATE;
97: ld_end_date DATE;
98: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;
99: ld_current_start_date DATE;
100: ln_current_period_num NUMBER;
101: ln_row_count NUMBER := 0;
102: lv_je_category VARCHAR2(200);
306: WHERE legal_entity_id = pn_legal_entity_id
307: AND chart_of_accounts_id = pn_coa_id)
308: AND period_name IN
309: (SELECT period_name
310: FROM GL_PERIOD_STATUSES
311: WHERE ledger_id = pn_ledger_id
312: AND application_id = 101
313: AND ((start_date BETWEEN ld_start_date AND ld_end_date) AND
314: (end_date BETWEEN ld_start_date AND ld_end_date)))
320:
321: CURSOR c_in_closed_periods
322: IS
323: SELECT period_name
324: FROM GL_PERIOD_STATUSES
325: WHERE ledger_id = pn_ledger_id
326: AND application_id = 101
327: AND ((start_date BETWEEN ld_start_date AND ld_end_date) AND
328: (end_date BETWEEN ld_start_date AND ld_end_date))
374: --Fetch start data and end date
375: IF pv_period_from IS NOT NULL THEN
376: SELECT start_date
377: INTO ld_start_date
378: FROM GL_PERIOD_STATUSES
379: WHERE ledger_id = pn_ledger_id
380: AND application_id = 101
381: AND period_name = pv_period_from
382: AND TO_CHAR(period_year) = pv_accounting_year;
386:
387: IF pv_period_to IS NOT NULL THEN
388: SELECT end_date
389: INTO ld_end_date
390: FROM GL_PERIOD_STATUSES
391: WHERE ledger_id = pn_ledger_id
392: AND application_id = 101
393: AND period_name = pv_period_to
394: AND TO_CHAR(period_year) = pv_accounting_year;
484:
485: --fetch start date of current period
486: SELECT start_date,period_num
487: INTO ld_current_start_date, ln_current_period_num
488: FROM GL_PERIOD_STATUSES
489: WHERE ledger_id = pn_ledger_id
490: AND application_id = 101
491: AND period_name = l_current_period;
492: