APPS.AP_WEB_ACCTG_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 111: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;

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:

Line 112: l_seg_name fnd_id_flex_segments_vl.segment_name%type;

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

Line 113: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

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:

Line 188: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

184:
185: IF (l_parent_flex_value_set_id IS NOT NULL) THEN
186:
187: SELECT s.segment_num into p_dependent_seg_num
188: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
189: fnd_segment_attribute_types sat
190: WHERE s.application_id = 101
191: AND s.id_flex_code = 'GL#'
192: AND s.id_flex_num = p_chart_of_accounts_id

Line 234: l_appcol_name fnd_id_flex_segments_vl.application_column_name%type;

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;

Line 235: l_seg_name fnd_id_flex_segments_vl.segment_name%type;

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);

Line 236: l_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

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:

Line 568: colname fnd_id_flex_segments.application_column_name%type;

564: --------------------------------------------------------------------------------
565:
566: l_debug_info VARCHAR2(1000);
567: sqlstmt varchar2(2000);
568: colname fnd_id_flex_segments.application_column_name%type;
569: c integer;
570: l_concat_segments VARCHAR2(1000);
571: rows integer;
572: l_num_segments NUMBER;

Line 578: FROM fnd_id_flex_segments flex

574: l_flex_segment_delimiter varchar2(1);
575:
576: cursor cflex(p_chart_accounts_id IN NUMBER) is
577: SELECT flex.application_column_name
578: FROM fnd_id_flex_segments flex
579: WHERE flex.application_id = 101
580: AND flex.id_flex_code = 'GL#'
581: AND flex.id_flex_num = p_chart_accounts_id
582: AND flex.enabled_flag='Y'