5004: End IsEnhancedBurdeningEnabled;
5005:
5006: /* Bug 5374282 */
5007: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
5008: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
5009: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
5010: x_return_status OUT NOCOPY NUMBER,
5011: x_error_code OUT NOCOPY VARCHAR2,
5012: x_error_stage OUT NOCOPY VARCHAR2
5005:
5006: /* Bug 5374282 */
5007: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
5008: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
5009: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
5010: x_return_status OUT NOCOPY NUMBER,
5011: x_error_code OUT NOCOPY VARCHAR2,
5012: x_error_stage OUT NOCOPY VARCHAR2
5013: )
5011: x_error_code OUT NOCOPY VARCHAR2,
5012: x_error_stage OUT NOCOPY VARCHAR2
5013: )
5014: IS
5015: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5016: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5012: x_error_stage OUT NOCOPY VARCHAR2
5013: )
5014: IS
5015: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5016: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5020:
5013: )
5014: IS
5015: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5016: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5020:
5021: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5014: IS
5015: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5016: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5020:
5021: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5022: