139: g_profile_value varchar2(2);
140:
141:
142: /* Bug 5374282 */
143: g_gl_dt_period_str_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
144: g_gl_dt_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
145: g_gl_dt_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
146:
147: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
140:
141:
142: /* Bug 5374282 */
143: g_gl_dt_period_str_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
144: g_gl_dt_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
145: g_gl_dt_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
146:
147: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
148: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
141:
142: /* Bug 5374282 */
143: g_gl_dt_period_str_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
144: g_gl_dt_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
145: g_gl_dt_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
146:
147: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
148: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
149: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
144: g_gl_dt_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
145: g_gl_dt_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
146:
147: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
148: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
149: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
150: x_return_status OUT NOCOPY NUMBER,
151: x_error_code OUT NOCOPY VARCHAR2,
152: x_error_stage OUT NOCOPY VARCHAR2
145: g_gl_dt_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
146:
147: PROCEDURE get_gl_dt_period (p_reference_date IN DATE,
148: x_gl_period_name OUT NOCOPY pa_draft_revenues_all.gl_period_name%TYPE,
149: x_gl_dt OUT NOCOPY pa_draft_revenues_all.gl_date%TYPE,
150: x_return_status OUT NOCOPY NUMBER,
151: x_error_code OUT NOCOPY VARCHAR2,
152: x_error_stage OUT NOCOPY VARCHAR2
153: );