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