107: l_debug_info varchar2(200);
108:
109: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
110: l_cost_center_seg_num NUMBER;
111: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
112: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
113: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
114: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
115:
108:
109: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
110: l_cost_center_seg_num NUMBER;
111: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
112: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
113: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
114: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
115:
116: BEGIN
109: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
110: l_cost_center_seg_num NUMBER;
111: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
112: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
113: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
114: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
115:
116: BEGIN
117:
230: l_flex_segment_delimiter varchar2(1);
231: l_cost_center_seg_num number;
232: l_num_segments number;
233: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
234: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
235: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
236: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
237: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
238: l_dependent_seg_num number := 0;
231: l_cost_center_seg_num number;
232: l_num_segments number;
233: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
234: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
235: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
236: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
237: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
238: l_dependent_seg_num number := 0;
239: l_concatenated_segments varchar2(2000);
232: l_num_segments number;
233: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
234: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;
235: l_seg_name fnd_id_flex_segments_vl.segment_name%type;
236: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
237: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
238: l_dependent_seg_num number := 0;
239: l_concatenated_segments varchar2(2000);
240: