5042: End IsEnhancedBurdeningEnabled;
5043:
5044: /* Bug 5374282 */
5045: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
5046: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
5047: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
5048: x_return_status OUT NOCOPY NUMBER,
5049: x_error_code OUT NOCOPY VARCHAR2,
5050: x_error_stage OUT NOCOPY VARCHAR2
5043:
5044: /* Bug 5374282 */
5045: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
5046: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
5047: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
5048: x_return_status OUT NOCOPY NUMBER,
5049: x_error_code OUT NOCOPY VARCHAR2,
5050: x_error_stage OUT NOCOPY VARCHAR2
5051: )
5049: x_error_code OUT NOCOPY VARCHAR2,
5050: x_error_stage OUT NOCOPY VARCHAR2
5051: )
5052: IS
5053: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5054: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5050: x_error_stage OUT NOCOPY VARCHAR2
5051: )
5052: IS
5053: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5054: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5058:
5051: )
5052: IS
5053: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5054: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5058:
5059: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5052: IS
5053: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5054: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5058:
5059: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5060: