[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 |
597: WHEN 'XLA_FIRST_DAY_NEXT_GL_PERIOD' THEN start_date
598: WHEN 'XLA_LAST_DAY_NEXT_GL_PERIOD' THEN end_date
599: ELSE p_gl_date + 1
600: END GL_DATE
601: FROM gl_period_statuses gps
602: WHERE gps.application_id = 101
603: AND gps.ledger_id = p_ledger_id
604: AND gps.adjustment_period_flag = 'N'
605: AND p_gl_date < gps.start_date
605: AND p_gl_date < gps.start_date
606: ORDER BY gps.start_date ASC;
607:
608:
609: l_period_name gl_period_statuses.period_name%TYPE;
610: l_accrev_date DATE;
611: l_log_module VARCHAR2(240);
612:
613:
699: -- ELSE ADD_MONTHS(p_start_date, ROUND(MONTHS_BETWEEN(start_date, p_start_date))) -- originating_day
700: ELSE ADD_MONTHS(p_start_date, CEIL(MONTHS_BETWEEN(start_date, p_start_date))) -- originating_day
701: -- changed from ROUND to CEIL for bug: 8214450
702: END GL_DATE
703: FROM gl_period_statuses gps
704: WHERE gps.application_id = 101
705: AND gps.ledger_id = p_ledger_id
706: AND gps.adjustment_period_flag = 'N'
707: AND p_end_date BETWEEN gps.start_date AND gps.end_date
735: THEN ADD_MONTHS(p_start_date, CEIL(MONTHS_BETWEEN(gps_orig.start_date, p_start_date)))
736: ELSE ADD_MONTHS(p_start_date, CEIL(MONTHS_BETWEEN(gps_mpa.start_date, p_start_date)))
737: END
738: END GL_DATE
739: FROM gl_period_statuses gps_mpa
740: , gl_period_statuses gps_orig
741: WHERE gps_mpa.application_id = 101
742: AND gps_mpa.ledger_id = p_ledger_id
743: AND gps_mpa.adjustment_period_flag = 'N'
736: ELSE ADD_MONTHS(p_start_date, CEIL(MONTHS_BETWEEN(gps_mpa.start_date, p_start_date)))
737: END
738: END GL_DATE
739: FROM gl_period_statuses gps_mpa
740: , gl_period_statuses gps_orig
741: WHERE gps_mpa.application_id = 101
742: AND gps_mpa.ledger_id = p_ledger_id
743: AND gps_mpa.adjustment_period_flag = 'N'
744: AND p_end_date BETWEEN gps_mpa.start_date AND gps_mpa.end_date
773: CASE p_proration_code
774: WHEN '360_DAYS' THEN least(p_end_date-start_date+1,30)
775: ELSE p_end_date-start_date+1
776: END DAYS_IN_LAST_PERIOD -- only valid for last period
777: FROM gl_period_statuses
778: WHERE application_id = 101
779: AND ledger_id = p_ledger_id
780: AND adjustment_period_flag = 'N'
781: AND end_date >= p_start_date -- included boundary conditions for bug12939974
821: CASE p_proration_code
822: WHEN '360_DAYS' THEN least(p_end_date-gps_mpa.start_date+1,30)
823: ELSE p_end_date-gps_mpa.start_date+1
824: END DAYS_IN_LAST_PERIOD -- only valid for last period
825: FROM gl_period_statuses gps_mpa
826: ,gl_period_statuses gps_orig
827: WHERE gps_mpa.application_id = 101
828: AND gps_mpa.ledger_id = p_ledger_id
829: AND gps_mpa.adjustment_period_flag = 'N'
822: WHEN '360_DAYS' THEN least(p_end_date-gps_mpa.start_date+1,30)
823: ELSE p_end_date-gps_mpa.start_date+1
824: END DAYS_IN_LAST_PERIOD -- only valid for last period
825: FROM gl_period_statuses gps_mpa
826: ,gl_period_statuses gps_orig
827: WHERE gps_mpa.application_id = 101
828: AND gps_mpa.ledger_id = p_ledger_id
829: AND gps_mpa.adjustment_period_flag = 'N'
830: AND gps_mpa.end_date >= p_start_date -- included boundary conditions for bug12939974
3440: --added U1 hint for bug#10229047
3441: , d.transaction_date
3442: FROM xla_ae_headers_gt xah2
3443: , gl_transaction_dates d
3444: , gl_period_statuses gps
3445: WHERE d.transaction_calendar_id = l_transaction_calendar_id
3446: AND d.business_day_flag = 'Y'
3447: AND d.transaction_date >= xah2.period_start_date
3448: AND gps.application_id = 101