[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fa.*
INTO l_application
FROM fnd_application fa
WHERE fa.application_short_name = p_application_short_name;
SELECT fif.*
INTO l_kff_flx
FROM fnd_id_flexs fif
WHERE fif.application_id = l_application.application_id
AND fif.id_flex_code = p_id_flex_code;
SELECT fifst.id_flex_num
BULK COLLECT INTO l_structure_numbers
FROM fnd_id_flex_structures fifst
WHERE fifst.application_id = p_kff_flx.application_id
AND fifst.id_flex_code = p_kff_flx.id_flex_code
AND fifst.enabled_flag = 'Y'
AND fifst.freeze_flex_definition_flag = 'Y'
ORDER BY fifst.id_flex_num;
SELECT fifst.*
INTO l_kff_str
FROM fnd_id_flex_structures fifst
WHERE fifst.application_id = p_kff_flx.application_id
AND fifst.id_flex_code = p_kff_flx.id_flex_code
AND fifst.id_flex_num = p_id_flex_num;
SELECT application_column_name, enabled_flag, display_flag, flex_value_set_id
FROM fnd_id_flex_segments
WHERE application_id = c_application_id
AND id_flex_code = c_id_flex_code
AND id_flex_num = c_id_flex_num
ORDER BY segment_num, segment_name;
SELECT count(*)
INTO l_cnt
FROM fnd_segment_attribute_types
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND segment_attribute_type = p_segment_attribute_type;
SELECT s.segment_num
INTO this_segment_num
FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
fnd_segment_attribute_types sat
WHERE s.application_id = appl_id
AND s.id_flex_code = key_flex_code
AND s.id_flex_num = structure_number
AND s.enabled_flag = 'Y'
AND s.application_column_name = sav.application_column_name
AND sav.application_id = appl_id
AND sav.id_flex_code = key_flex_code
AND sav.id_flex_num = structure_number
AND sav.attribute_value = 'Y'
AND sav.segment_attribute_type = sat.segment_attribute_type
AND sat.application_id = appl_id
AND sat.id_flex_code = key_flex_code
--AND sat.unique_flag = 'Y' -- We need to look for non-unique qual. also.
AND sat.segment_attribute_type = flex_qual_name
AND ROWNUM < 2
AND '$Header: AFFFXPAB.pls 120.8.12000000.1 2007/01/18 13:19:33 appldev ship $' IS NOT NULL
ORDER BY s.segment_num; -- Order By and rownum < 2 ensures we get first segment.
SELECT count(segment_num)
INTO l_segment_number
FROM fnd_id_flex_segments
WHERE application_id = appl_id
AND id_flex_code = key_flex_code
AND id_flex_num = structure_number
AND enabled_flag = 'Y'
AND segment_num <= this_segment_num
AND '$Header: AFFFXPAB.pls 120.8.12000000.1 2007/01/18 13:19:33 appldev ship $' IS NOT NULL;
SELECT parent_flex_value_set_id INTO l_parent_value_set_id
FROM fnd_flex_value_sets
WHERE flex_value_set_id = l_segment_info_array(i).flex_value_set_id;
SELECT fifsg.*
INTO l_kff_seg
FROM fnd_id_flex_segments fifsg
WHERE fifsg.application_id = p_kff_str.application_id
AND fifsg.id_flex_code = p_kff_str.id_flex_code
AND fifsg.id_flex_num = p_kff_str.id_flex_num
AND fifsg.application_column_name = p_application_column_name;
SELECT fifsgtl.*
INTO l_kff_seg_tl
FROM fnd_id_flex_segments_tl fifsgtl
WHERE fifsgtl.application_id = p_kff_seg.application_id
AND fifsgtl.id_flex_code = p_kff_seg.id_flex_code
AND fifsgtl.id_flex_num = p_kff_seg.id_flex_num
AND fifsgtl.application_column_name = p_kff_seg.application_column_name
AND fifsgtl.language = userenv('LANG');
select_comb_from_view => NULL);
PROCEDURE kff_select
(p_lexical_name IN VARCHAR2,
p_application_short_name IN fnd_application.application_short_name%TYPE,
p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,
p_multiple_id_flex_num IN VARCHAR2 DEFAULT 'N',
p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
p_segments IN VARCHAR2 DEFAULT 'ALL',
p_show_parent_segments IN VARCHAR2 DEFAULT 'Y',
p_output_type IN VARCHAR2,
x_select_expression OUT nocopy VARCHAR2)
IS
l_kff_flx kff_flx_type;
x_select_expression := 'fnd_flex_xml_publisher_apis.process_kff_combination_1(' ||
'''' || p_lexical_name || ''', ' ||
'''' || p_application_short_name || ''', ' ||
'''' || p_id_flex_code || ''', ' ||
l_structure_column_name || ', ' ||
l_data_set_column_name || ', ' ||
l_alias_prefix || l_kff_flx.unique_id_column_name || ', ' ||
'''' || p_segments || ''', ' ||
'''' || p_show_parent_segments || ''', ' ||
'''' || p_output_type || ''')';
raise_others('kff_select',
p_lexical_name,
p_application_short_name,
p_id_flex_code,
p_id_flex_num,
p_multiple_id_flex_num,
p_code_combination_table_alias,
p_segments,
p_show_parent_segments,
p_output_type);
END kff_select;
SELECT fnd_columns.column_type
INTO l_datatype
FROM fnd_columns,fnd_tables,fnd_id_flexs
WHERE fnd_columns.column_name = p_column_name
AND fnd_columns.table_id = fnd_tables.table_id
AND fnd_columns.application_id = fnd_tables.application_id
AND fnd_tables.table_name = fnd_id_flexs.application_table_name
AND fnd_tables.application_id = fnd_id_flexs.table_application_id
AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
AND fnd_id_flexs.application_id = l_kff_flx.application_id;
SELECT flex_value_set_id
INTO l_flex_value_set_id
FROM fnd_id_flex_segments fifs
WHERE fifs.application_id = l_kff_flx.application_id
AND fifs.id_flex_code = l_kff_flx.id_flex_code
AND fifs.id_flex_num = p_id_flex_num
AND fifs.application_column_name = p_column_name;
SELECT format_type, maximum_size
INTO l_format_type, l_maximum_size
FROM fnd_flex_value_sets ffvs
WHERE ffvs.flex_value_set_id = l_flex_value_set_id;