21: g_curr_set_of_books_id binary_integer := null;
22: g_curr_concat varchar2(40) := null;
23:
24: /***********************************************************/
25: /* GL_CODE_COMBINATIONS cache */
26: /***********************************************************/
27: g_cc_current_ccid number(15) := -1;
28: g_cc_current_segments varchar2(250);
29: g_local_instance varchar2(30);
156: rpad(nvl(segment25,'NA_EDW'), 25, ' ') || rpad(nvl(segment26,'NA_EDW'), 25, ' ') ||
157: rpad(nvl(segment27,'NA_EDW'), 25, ' ') || rpad(nvl(segment28,'NA_EDW'), 25, ' ') ||
158: rpad(nvl(segment29,'NA_EDW'), 25, ' ') || rpad(nvl(segment30,'NA_EDW'), 25, ' ')
159: segments
160: FROM gl_code_combinations
161: WHERE gl_code_combinations.code_combination_id = p_ccid;
162: l_buffer varchar2(250) := NULL;
163: w number(3);
164: x number(3);
157: rpad(nvl(segment27,'NA_EDW'), 25, ' ') || rpad(nvl(segment28,'NA_EDW'), 25, ' ') ||
158: rpad(nvl(segment29,'NA_EDW'), 25, ' ') || rpad(nvl(segment30,'NA_EDW'), 25, ' ')
159: segments
160: FROM gl_code_combinations
161: WHERE gl_code_combinations.code_combination_id = p_ccid;
162: l_buffer varchar2(250) := NULL;
163: w number(3);
164: x number(3);
165: y number(3);