[Home] [Help]
73: | 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
74: | and the procedure. |
75: | 29-MAR-2204 K.Boussema Changed based on bug 3528667 |
76: | - added get_period_name function to retrieve|
77: | the period_name from gl_period_statuses |
78: | - added the cache of period_name |
79: | - changed the insert into xla_ae_headers_gt |
80: | 11-MAY-2004 K.Boussema Removed the call to XLA trace routine from |
81: | trace() procedure |
573: WHEN 'XLA_FIRST_DAY_NEXT_GL_PERIOD' THEN start_date
574: WHEN 'XLA_LAST_DAY_NEXT_GL_PERIOD' THEN end_date
575: ELSE p_gl_date + 1
576: END GL_DATE
577: FROM gl_period_statuses gps
578: WHERE gps.application_id = 101
579: AND gps.ledger_id = p_ledger_id
580: AND gps.adjustment_period_flag = 'N'
581: AND p_gl_date < gps.start_date
581: AND p_gl_date < gps.start_date
582: ORDER BY gps.start_date ASC;
583:
584:
585: l_period_name gl_period_statuses.period_name%TYPE;
586: l_accrev_date DATE;
587: l_log_module VARCHAR2(240);
588:
589:
671: WHEN 'FIRST_DAY_GL_PERIOD' THEN start_date
672: WHEN 'LAST_DAY_GL_PERIOD' THEN end_date
673: ELSE ADD_MONTHS(p_start_date, ROUND(MONTHS_BETWEEN(start_date, p_start_date))) -- originating_day
674: END GL_DATE
675: FROM gl_period_statuses gps
676: WHERE gps.application_id = 101
677: AND gps.ledger_id = p_ledger_id
678: AND gps.adjustment_period_flag = 'N'
679: AND p_end_date BETWEEN gps.start_date AND gps.end_date
701: CASE p_proration_code
702: WHEN '360_DAYS' THEN least(p_end_date-start_date+1,30)
703: ELSE p_end_date-start_date+1
704: END DAYS_IN_LAST_PERIOD -- only valid for last period
705: FROM gl_period_statuses
706: WHERE application_id = 101
707: AND ledger_id = p_ledger_id
708: AND adjustment_period_flag = 'N'
709: AND end_date > p_start_date