APPS.AP_WEB_ACCTG_PKG dependencies on FND_FLEX_VALUE_SETS

Line 114: l_value_set_name fnd_flex_value_sets.flex_value_set_name%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:
118: -----------------------------------------------------

Line 157: from fnd_flex_value_sets

153: l_debug_info := 'Get Cost Center Approval rules';
154: -----------------------------------------------------
155: select alphanumeric_allowed_flag, uppercase_only_flag, numeric_mode_enabled_flag, maximum_size
156: into p_alphanumeric_allowed_flag, p_uppercase_only_flag ,p_numeric_mode_enabled_flag, p_maximum_size
157: from fnd_flex_value_sets
158: where flex_value_set_name like l_value_set_name;
159:
160: EXCEPTION
161: WHEN OTHERS THEN

Line 172: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,

168: /*Bug 2690715 : Declared a function to get the dependent segment
169: of cost center segment.
170: */
171: FUNCTION GetDependentSegment(
172: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
173: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID,
174: p_dependent_seg_num OUT NOCOPY NUMBER) RETURN BOOLEAN IS
175:
176: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;

Line 176: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;

172: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
173: p_chart_of_accounts_id IN AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID,
174: p_dependent_seg_num OUT NOCOPY NUMBER) RETURN BOOLEAN IS
175:
176: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
177:
178: BEGIN
179:
180: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id

Line 181: from fnd_flex_value_sets

177:
178: BEGIN
179:
180: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
181: from fnd_flex_value_sets
182: where flex_value_set_name like p_value_set_name
183: and PARENT_FLEX_VALUE_SET_ID is not null;
184:
185: IF (l_parent_flex_value_set_id IS NOT NULL) THEN

Line 237: l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;

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:
241: BEGIN