[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_seed_stage_util.insert_msg(p_debug);
fnd_seed_stage_util.insert_msg(p_text);
p_file_last_update_date IN VARCHAR2,
p_db_last_updated_by IN NUMBER,
p_db_last_update_date IN DATE,
x_file_who IN OUT nocopy who_type)
RETURN BOOLEAN
IS
l_func_name VARCHAR2(80);
x_file_who.last_updated_by := fnd_load_util.owner_id(l_file_owner);
x_file_who.last_update_date := Trunc(Nvl(To_date(p_file_last_update_date,
g_date_mask),
g_default_lud));
x_file_who.last_update_login := 0;
x_file_who.created_by := x_file_who.last_updated_by;
x_file_who.creation_date := x_file_who.last_update_date;
x_file_who.last_updated_by := fnd_load_util.owner_id(l_file_owner);
x_file_who.last_update_date := Trunc(g_default_lud);
x_file_who.last_update_login := 0;
x_file_who.created_by := x_file_who.last_updated_by;
x_file_who.creation_date := x_file_who.last_update_date;
l_db_who.last_updated_by := Nvl(p_db_last_updated_by,
x_file_who.last_updated_by);
l_db_owner := fnd_load_util.owner_name(l_db_who.last_updated_by);
l_db_who.last_update_date := Nvl(p_db_last_update_date,
x_file_who.last_update_date - 1);
l_db_who.last_update_login := 0;
l_db_who.created_by := l_db_who.last_updated_by;
l_db_who.creation_date := l_db_who.last_update_date;
(p_file_id => x_file_who.last_updated_by,
p_file_lud => x_file_who.last_update_date,
p_db_id => l_db_who.last_updated_by,
p_db_lud => l_db_who.last_update_date,
p_custom_mode => p_custom_mode);
('File LUB: ' || Rpad(x_file_who.last_updated_by ||
'/' || l_file_owner, 15) ||
' LUD: ' || To_char(x_file_who.last_update_date, g_date_mask)),
(' DB LUB: ' || Rpad(l_db_who.last_updated_by ||
'/' || l_db_owner, 15) ||
' LUD: ' || To_char(l_db_who.last_update_date, g_date_mask)));
SELECT 'Sample Template'
INTO x_value
FROM dual
WHERE 'KEY_COLUMN' = p_key;
SELECT *
INTO x_app
FROM fnd_application
WHERE application_short_name = p_application_short_name;
SELECT *
INTO x_app
FROM fnd_application
WHERE application_id = p_application_id;
SELECT *
INTO x_tbl
FROM fnd_tables
WHERE application_id = l_app.application_id
AND table_name = p_table_name;
SELECT *
INTO x_col
FROM fnd_columns
WHERE application_id = l_tbl.application_id
AND table_id = l_tbl.table_id
AND column_name = p_column_name;
SELECT *
INTO x_resp
FROM fnd_responsibility
WHERE application_id = l_app.application_id
AND responsibility_key = p_responsibility_key;
SELECT *
INTO x_vst_set
FROM fnd_flex_value_sets
WHERE flex_value_set_name = p_flex_value_set_name;
SELECT *
INTO x_vst_tbl
FROM fnd_flex_validation_tables
WHERE flex_value_set_id = p_vst_set.flex_value_set_id;
SELECT *
INTO x_vst_evt
FROM fnd_flex_validation_events
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND event_code = p_event_code;
SELECT *
INTO x_vst_scr
FROM fnd_flex_value_rules
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND parent_flex_value_low = p_parent_flex_value_low
AND flex_value_rule_name = p_flex_value_rule_name;
SELECT *
INTO x_vst_scr
FROM fnd_flex_value_rules
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND flex_value_rule_name = p_flex_value_rule_name;
SELECT *
INTO x_vst_scr_tl
FROM fnd_flex_value_rules_tl
WHERE flex_value_rule_id = p_vst_scr.flex_value_rule_id
AND language = p_language;
SELECT *
INTO x_vst_scl
FROM fnd_flex_value_rule_lines
WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
AND parent_flex_value_low = p_vst_scr.parent_flex_value_low
AND include_exclude_indicator = p_include_exclude_indicator
AND flex_value_low = p_flex_value_low
AND flex_value_high = p_flex_value_high;
SELECT *
INTO x_vst_scl
FROM fnd_flex_value_rule_lines
WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
AND include_exclude_indicator = p_include_exclude_indicator
AND flex_value_low = p_flex_value_low
AND flex_value_high = p_flex_value_high;
SELECT *
INTO x_vst_scu
FROM fnd_flex_value_rule_usages
WHERE application_id = p_resp.application_id
AND responsibility_id = p_resp.responsibility_id
AND flex_value_set_id = p_vst_scr.flex_value_set_id
AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
AND parent_flex_value_low = p_vst_scr.parent_flex_value_low;
SELECT *
INTO x_vst_scu
FROM fnd_flex_value_rule_usages
WHERE application_id = p_resp.application_id
AND responsibility_id = p_resp.responsibility_id
AND flex_value_set_id = p_vst_scr.flex_value_set_id
AND flex_value_rule_id = p_vst_scr.flex_value_rule_id;
SELECT *
INTO x_vst_rgr
FROM fnd_flex_hierarchies
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND hierarchy_code = p_hierarchy_code;
SELECT *
INTO x_vst_rgr_tl
FROM fnd_flex_hierarchies_tl
WHERE flex_value_set_id = p_vst_rgr.flex_value_set_id
AND hierarchy_id = p_vst_rgr.hierarchy_id
AND language = p_language;
SELECT *
INTO x_vst_val
FROM fnd_flex_values
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND (parent_flex_value_low = p_parent_flex_value_low OR
(parent_flex_value_low IS NULL AND
p_parent_flex_value_low IS NULL))
AND flex_value = p_flex_value;
SELECT *
INTO x_vst_val
FROM fnd_flex_values
WHERE flex_value_set_id = p_vst_set.flex_value_set_id
AND flex_value = p_flex_value;
SELECT *
INTO x_vst_val_tl
FROM fnd_flex_values_tl
WHERE flex_value_id = p_vst_val.flex_value_id
AND language = p_language;
SELECT *
INTO x_vst_vlh
FROM fnd_flex_value_norm_hierarchy
WHERE flex_value_set_id = p_vst_val.flex_value_set_id
AND parent_flex_value = p_vst_val.flex_value
AND range_attribute = p_range_attribute
AND child_flex_value_low = p_child_flex_value_low
AND child_flex_value_high = p_child_flex_value_high;
SELECT
fvq.id_flex_application_id,
fvq.id_flex_code,
fvq.segment_attribute_type,
fvq.value_attribute_type,
fvq.assignment_date,
vat.lookup_type,
vat.default_value,
NULL
FROM fnd_flex_validation_qualifiers fvq,
fnd_value_attribute_types vat
WHERE fvq.flex_value_set_id = p_flex_value_set_id
AND fvq.id_flex_application_id = vat.application_id(+)
AND fvq.id_flex_code = vat.id_flex_code(+)
AND fvq.segment_attribute_type = vat.segment_attribute_type(+)
AND fvq.value_attribute_type = vat.value_attribute_type(+)
ORDER BY fvq.assignment_date, fvq.value_attribute_type;
SELECT *
INTO x_dff_flx
FROM fnd_descriptive_flexs
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
SELECT *
INTO x_dff_flx_tl
FROM fnd_descriptive_flexs_tl
WHERE application_id = p_dff_flx.application_id
AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
AND language = p_language;
SELECT *
INTO x_dff_ref
FROM fnd_default_context_fields
WHERE application_id = p_dff_flx.application_id
AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
AND default_context_field_name = p_default_context_field_name;
SELECT *
INTO x_dff_ctx
FROM fnd_descr_flex_contexts
WHERE application_id = p_dff_flx.application_id
AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
AND descriptive_flex_context_code = p_descriptive_flex_context_cod;
SELECT *
INTO x_dff_ctx_tl
FROM fnd_descr_flex_contexts_tl
WHERE application_id = p_dff_ctx.application_id
AND descriptive_flexfield_name = p_dff_ctx.descriptive_flexfield_name
AND descriptive_flex_context_code = p_dff_ctx.descriptive_flex_context_code
AND language = p_language;
SELECT *
INTO x_dff_seg
FROM fnd_descr_flex_column_usages
WHERE application_id = p_dff_ctx.application_id
AND descriptive_flexfield_name = p_dff_ctx.descriptive_flexfield_name
AND descriptive_flex_context_code = p_dff_ctx.descriptive_flex_context_code
AND application_column_name = p_application_column_name;
SELECT *
INTO x_dff_seg_tl
FROM fnd_descr_flex_col_usage_tl
WHERE application_id = p_dff_seg.application_id
AND descriptive_flexfield_name = p_dff_seg.descriptive_flexfield_name
AND descriptive_flex_context_code = p_dff_seg.descriptive_flex_context_code
AND application_column_name = p_dff_seg.application_column_name
AND language = p_language;
SELECT *
INTO x_kff_flx
FROM fnd_id_flexs
WHERE application_id = l_app.application_id
AND id_flex_code = p_id_flex_code;
SELECT *
INTO x_kff_flq
FROM fnd_segment_attribute_types
WHERE application_id = p_kff_flx.application_id
AND id_flex_code = p_kff_flx.id_flex_code
AND segment_attribute_type = p_segment_attribute_type;
SELECT *
INTO x_kff_sgq
FROM fnd_value_attribute_types
WHERE application_id = p_kff_flq.application_id
AND id_flex_code = p_kff_flq.id_flex_code
AND segment_attribute_type = p_kff_flq.segment_attribute_type
AND value_attribute_type = p_value_attribute_type;
SELECT *
INTO x_kff_sgq_tl
FROM fnd_val_attribute_types_tl
WHERE application_id = p_kff_sgq.application_id
AND id_flex_code = p_kff_sgq.id_flex_code
AND segment_attribute_type = p_kff_sgq.segment_attribute_type
AND value_attribute_type = p_kff_sgq.value_attribute_type
AND language = p_language;
SELECT *
INTO x_kff_str
FROM fnd_id_flex_structures
WHERE application_id = p_kff_flx.application_id
AND id_flex_code = p_kff_flx.id_flex_code
AND id_flex_structure_code = p_id_flex_structure_code;
SELECT *
INTO x_kff_str
FROM fnd_id_flex_structures
WHERE application_id = p_kff_flx.application_id
AND id_flex_code = p_kff_flx.id_flex_code
AND id_flex_num = p_id_flex_num;
SELECT *
INTO x_kff_str_tl
FROM fnd_id_flex_structures_tl
WHERE application_id = p_kff_str.application_id
AND id_flex_code = p_kff_str.id_flex_code
AND id_flex_num = p_kff_str.id_flex_num
AND language = p_language;
SELECT *
INTO x_kff_wfp
FROM fnd_flex_workflow_processes
WHERE application_id = p_kff_str.application_id
AND id_flex_code = p_kff_str.id_flex_code
AND id_flex_num = p_kff_str.id_flex_num
AND wf_item_type = p_wf_item_type;
SELECT *
INTO x_kff_sha
FROM fnd_shorthand_flex_aliases
WHERE application_id = p_kff_str.application_id
AND id_flex_code = p_kff_str.id_flex_code
AND id_flex_num = p_kff_str.id_flex_num
AND alias_name = p_alias_name;
SELECT *
INTO x_kff_cvr
FROM fnd_flex_validation_rules
WHERE application_id = p_kff_str.application_id
AND id_flex_code = p_kff_str.id_flex_code
AND id_flex_num = p_kff_str.id_flex_num
AND flex_validation_rule_name = p_flex_validation_rule_name;
SELECT *
INTO x_kff_cvr_tl
FROM fnd_flex_vdation_rules_tl
WHERE application_id = p_kff_cvr.application_id
AND id_flex_code = p_kff_cvr.id_flex_code
AND id_flex_num = p_kff_cvr.id_flex_num
AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name
AND language = p_language;
SELECT *
INTO x_kff_cvl
FROM fnd_flex_validation_rule_lines
WHERE application_id = p_kff_cvr.application_id
AND id_flex_code = p_kff_cvr.id_flex_code
AND id_flex_num = p_kff_cvr.id_flex_num
AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name
AND include_exclude_indicator = p_include_exclude_indicator
AND concatenated_segments_low = p_concatenated_segments_low
AND concatenated_segments_high = p_concatenated_segments_high;
SELECT *
INTO x_kff_seg
FROM fnd_id_flex_segments
WHERE application_id = p_kff_str.application_id
AND id_flex_code = p_kff_str.id_flex_code
AND id_flex_num = p_kff_str.id_flex_num
AND application_column_name = p_application_column_name;
SELECT *
INTO x_kff_seg_tl
FROM fnd_id_flex_segments_tl
WHERE application_id = p_kff_seg.application_id
AND id_flex_code = p_kff_seg.id_flex_code
AND id_flex_num = p_kff_seg.id_flex_num
AND application_column_name = p_kff_seg.application_column_name
AND language = p_language;
SELECT *
INTO x_kff_fqa
FROM fnd_segment_attribute_values
WHERE application_id = p_kff_flq.application_id
AND id_flex_code = p_kff_flq.id_flex_code
AND segment_attribute_type = p_kff_flq.segment_attribute_type
AND id_flex_num = p_kff_seg.id_flex_num
AND application_column_name = p_kff_seg.application_column_name
AND p_kff_seg.application_id = p_kff_flq.application_id
AND p_kff_seg.id_flex_code = p_kff_flq.id_flex_code;
SELECT
ifsg.application_id,
ifsg.id_flex_code,
ifsg.id_flex_num,
ifsg.application_column_name,
sat.segment_attribute_type,
ifsg.created_by ifsg_created_by,
ifsg.creation_date ifsg_creation_date,
ifsg.last_updated_by ifsg_last_updated_by,
ifsg.last_update_date ifsg_last_update_date,
ifsg.last_update_login ifsg_last_update_login,
sat.created_by sat_created_by,
sat.creation_date sat_creation_date,
sat.last_updated_by sat_last_updated_by,
sat.last_update_date sat_last_update_date,
sat.last_update_login sat_last_update_login,
sat.global_flag
FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat
WHERE sat.application_id = ifsg.application_id
AND sat.id_flex_code = ifsg.id_flex_code
AND NOT exists
(SELECT NULL
FROM fnd_segment_attribute_values sav
WHERE sav.application_id = ifsg.application_id
AND sav.id_flex_code = ifsg.id_flex_code
AND sav.id_flex_num = ifsg.id_flex_num
AND sav.application_column_name = ifsg.application_column_name
AND sav.segment_attribute_type = sat.segment_attribute_type);
l_who.last_updated_by := missing_sav_rec.sat_last_updated_by;
l_who.last_update_date := missing_sav_rec.sat_last_update_date;
l_who.last_update_login := missing_sav_rec.sat_last_update_login;
l_who.last_updated_by := missing_sav_rec.ifsg_last_updated_by;
l_who.last_update_date := missing_sav_rec.ifsg_last_update_date;
l_who.last_update_login := missing_sav_rec.ifsg_last_update_login;
INSERT INTO fnd_segment_attribute_values
(
application_id,
id_flex_code,
id_flex_num,
application_column_name,
segment_attribute_type,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
attribute_value
)
SELECT
ifsg.application_id,
ifsg.id_flex_code,
ifsg.id_flex_num,
ifsg.application_column_name,
sat.segment_attribute_type,
l_who.created_by,
l_who.creation_date,
l_who.last_updated_by,
l_who.last_update_date,
l_who.last_update_login,
sat.global_flag
FROM fnd_id_flex_segments ifsg, fnd_segment_attribute_types sat
WHERE sat.application_id = ifsg.application_id
AND sat.id_flex_code = ifsg.id_flex_code
AND ifsg.application_id = missing_sav_rec.application_id
AND ifsg.id_flex_code = missing_sav_rec.id_flex_code
AND ifsg.id_flex_num = missing_sav_rec.id_flex_num
AND ifsg.application_column_name = missing_sav_rec.application_column_name
AND sat.segment_attribute_type = missing_sav_rec.segment_attribute_type
AND NOT exists
(SELECT NULL
FROM fnd_segment_attribute_values sav
WHERE sav.application_id = ifsg.application_id
AND sav.id_flex_code = ifsg.id_flex_code
AND sav.id_flex_num = ifsg.id_flex_num
AND sav.application_column_name = ifsg.application_column_name
AND sav.segment_attribute_type = sat.segment_attribute_type);
INSERT INTO fnd_flex_validation_qualifiers
(
flex_value_set_id,
id_flex_application_id,
id_flex_code,
segment_attribute_type,
value_attribute_type,
assignment_date
)
SELECT DISTINCT ifsg.flex_value_set_id,
ifsg.application_id,
ifsg.id_flex_code,
vat.segment_attribute_type,
vat.value_attribute_type,
l_sysdate
FROM
fnd_val_attribute_types_vl vat,
fnd_segment_attribute_values sav,
fnd_id_flex_segments_vl ifsg
WHERE sav.application_id = ifsg.application_id
AND sav.id_flex_code = ifsg.id_flex_code
AND sav.id_flex_num = ifsg.id_flex_num
AND sav.application_column_name = ifsg.application_column_name
AND sav.attribute_value = 'Y'
AND vat.application_id = sav.application_id
AND vat.id_flex_code = sav.id_flex_code
AND vat.segment_attribute_type = sav.segment_attribute_type
AND ifsg.enabled_flag = 'Y'
AND ifsg.flex_value_set_id IS NOT NULL
AND NOT exists
(SELECT NULL
FROM fnd_flex_validation_qualifiers fvq
WHERE fvq.flex_value_set_id = ifsg.flex_value_set_id
AND fvq.id_flex_application_id = ifsg.application_id
AND fvq.id_flex_code = ifsg.id_flex_code
AND fvq.segment_attribute_type = sav.segment_attribute_type
AND fvq.value_attribute_type = vat.value_attribute_type);
PROCEDURE delete_compiled_data(p_mode IN VARCHAR2,
p_application_id IN NUMBER,
p_descriptive_flexfield_name IN VARCHAR2 DEFAULT NULL,
p_id_flex_code IN VARCHAR2 DEFAULT NULL,
p_id_flex_num IN NUMBER DEFAULT NULL)
IS
l_func_name VARCHAR2(80);
l_func_name := g_api_name || 'delete_compiled_data()';
DELETE FROM fnd_compiled_descriptive_flexs fcdf
WHERE fcdf.application_id = p_application_id
AND fcdf.descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE FROM fnd_compiled_id_flex_structs fcifs
WHERE fcifs.application_id = p_application_id
AND fcifs.id_flex_code = p_id_flex_code
AND fcifs.id_flex_num = p_id_flex_num;
DELETE FROM fnd_compiled_id_flexs fcif
WHERE fcif.application_id = p_application_id
AND fcif.id_flex_code = p_id_flex_code;
END delete_compiled_data;
SELECT u.user_id
INTO l_user_id
FROM fnd_user u
WHERE u.user_name = 'SYSADMIN';
SELECT r.application_id, r.responsibility_id
INTO l_resp_appl_id, l_resp_id
FROM fnd_application a, fnd_responsibility r
WHERE r.application_id = a.application_id
AND a.application_short_name = 'SYSADMIN'
AND r.responsibility_key = 'SYSTEM_ADMINISTRATOR';
SELECT request_id
INTO l_request_id
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_application fa
WHERE fa.application_short_name = p_application_short_name
AND fcp.application_id = fa.application_id
AND fcp.concurrent_program_name = p_concurrent_program_name
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.status_code in ('I', -- ' Normal'
'Q', -- 'StandBy'
'R') -- ' Normal'
AND fcr.phase_code = 'P' -- 'Pending'
--
-- p_argument1 is mandatory and cannot be NULL
--
AND nvl(fcr.argument1, g_nvl_value) = p_argument1
--
-- Other arguments are optional and can be NULL
--
AND ((p_argument_count < 2) OR
(nvl(fcr.argument2, g_nvl_value) = nvl(l_argument2, g_nvl_value)))
AND ((p_argument_count < 3) OR
(nvl(fcr.argument3, g_nvl_value) = nvl(l_argument3, g_nvl_value)))
AND ((p_argument_count < 4) OR
(nvl(fcr.argument4, g_nvl_value) = nvl(l_argument4, g_nvl_value)))
AND ((p_argument_count < 5) OR
(nvl(fcr.argument5, g_nvl_value) = nvl(l_argument5, g_nvl_value)))
AND ROWNUM = 1;
delete_compiled_data(p_mode => p_mode,
p_application_id => l_dff_flx.application_id,
p_descriptive_flexfield_name => p_descriptive_flexfield_name);
delete_compiled_data(p_mode => p_mode,
p_application_id => l_kff_flx.application_id,
p_id_flex_code => p_id_flex_code,
p_id_flex_num => l_kff_str.id_flex_num);
p_last_update_date IN VARCHAR2,
p_compiled_value_attribute_val IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_val.last_updated_by,
p_db_last_update_date => l_vst_val.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_values SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
compiled_value_attributes = l_cva
WHERE flex_value_set_id = l_vst_set.flex_value_set_id
AND flex_value_id = l_vst_val.flex_value_id;
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_validation_type IN VARCHAR2,
p_protected_flag IN VARCHAR2,
p_security_enabled_flag IN VARCHAR2,
p_longlist_flag IN VARCHAR2,
p_format_type IN VARCHAR2,
p_maximum_size IN VARCHAR2,
p_number_precision IN VARCHAR2,
p_alphanumeric_allowed_flag IN VARCHAR2,
p_uppercase_only_flag IN VARCHAR2,
p_numeric_mode_enabled_flag IN VARCHAR2,
p_minimum_value IN VARCHAR2,
p_maximum_value IN VARCHAR2,
p_parent_flex_value_set_name IN VARCHAR2,
p_dependant_default_value IN VARCHAR2,
p_dependant_default_meaning IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_set.last_updated_by,
p_db_last_update_date => l_vst_set.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_value_sets SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = Nvl(p_description, description)
WHERE flex_value_set_name = p_flex_value_set_name
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_flex_value_sets SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = p_description,
validation_type = p_validation_type,
protected_flag = p_protected_flag,
security_enabled_flag = p_security_enabled_flag,
longlist_flag = p_longlist_flag,
format_type = p_format_type,
maximum_size = p_maximum_size,
number_precision = p_number_precision,
alphanumeric_allowed_flag = p_alphanumeric_allowed_flag,
uppercase_only_flag = p_uppercase_only_flag,
numeric_mode_enabled_flag = p_numeric_mode_enabled_flag,
minimum_value = p_minimum_value,
maximum_value = p_maximum_value,
parent_flex_value_set_id = l_parent_vst_set_id,
dependant_default_value = p_dependant_default_value,
dependant_default_meaning = p_dependant_default_meaning
WHERE flex_value_set_name = p_flex_value_set_name;
debug(l_func_name, 'Inserting VALUE_SET.(non-MLS)');
INSERT INTO fnd_flex_value_sets
(
flex_value_set_id,
flex_value_set_name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
description,
validation_type,
protected_flag,
security_enabled_flag,
longlist_flag,
format_type,
maximum_size,
number_precision,
alphanumeric_allowed_flag,
uppercase_only_flag,
numeric_mode_enabled_flag,
minimum_value,
maximum_value,
parent_flex_value_set_id,
dependant_default_value,
dependant_default_meaning
)
VALUES
(
fnd_flex_value_sets_s.NEXTVAL,
p_flex_value_set_name,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_description,
p_validation_type,
p_protected_flag,
p_security_enabled_flag,
p_longlist_flag,
p_format_type,
p_maximum_size,
p_number_precision,
p_alphanumeric_allowed_flag,
p_uppercase_only_flag,
p_numeric_mode_enabled_flag,
p_minimum_value,
p_maximum_value,
l_parent_vst_set_id,
p_dependant_default_value,
p_dependant_default_meaning
);
SELECT COUNT(*)
INTO l_count
FROM fnd_flex_value_norm_hierarchy
WHERE flex_value_set_id =
(SELECT flex_value_set_id
FROM fnd_flex_value_sets
WHERE flex_value_set_name = p_flex_value_set_name);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_ind_validation_type IN VARCHAR2,
p_dep_validation_type IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_table_application_short_name IN VARCHAR2,
p_application_table_name IN VARCHAR2,
p_summary_allowed_flag IN VARCHAR2,
p_value_column_name IN VARCHAR2,
p_value_column_type IN VARCHAR2,
p_value_column_size IN VARCHAR2,
p_id_column_name IN VARCHAR2,
p_id_column_type IN VARCHAR2,
p_id_column_size IN VARCHAR2,
p_meaning_column_name IN VARCHAR2,
p_meaning_column_type IN VARCHAR2,
p_meaning_column_size IN VARCHAR2,
p_enabled_column_name IN VARCHAR2,
p_compiled_attribute_column_na IN VARCHAR2,
p_hierarchy_level_column_name IN VARCHAR2,
p_start_date_column_name IN VARCHAR2,
p_end_date_column_name IN VARCHAR2,
p_summary_column_name IN VARCHAR2,
p_additional_where_clause IN VARCHAR2,
p_additional_quickpick_columns IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_tbl.last_updated_by,
p_db_last_update_date => l_vst_tbl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_validation_tables SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
table_application_id = l_table_app.application_id,
application_table_name = p_application_table_name,
summary_allowed_flag = p_summary_allowed_flag,
value_column_name = p_value_column_name,
value_column_type = p_value_column_type,
value_column_size = p_value_column_size,
id_column_name = p_id_column_name,
id_column_type = p_id_column_type,
id_column_size = p_id_column_size,
meaning_column_name = p_meaning_column_name,
meaning_column_type = p_meaning_column_type,
meaning_column_size = p_meaning_column_size,
enabled_column_name = p_enabled_column_name,
compiled_attribute_column_name = p_compiled_attribute_column_na,
hierarchy_level_column_name = p_hierarchy_level_column_name,
start_date_column_name = p_start_date_column_name,
end_date_column_name = p_end_date_column_name,
summary_column_name = p_summary_column_name,
additional_where_clause = p_additional_where_clause,
additional_quickpick_columns = p_additional_quickpick_columns
WHERE flex_value_set_id = l_vst_set.flex_value_set_id;
debug(l_func_name, 'Inserting VSET_TABLE.(no-TL)');
INSERT INTO fnd_flex_validation_tables
(
flex_value_set_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
table_application_id,
application_table_name,
summary_allowed_flag,
value_column_name,
value_column_type,
value_column_size,
id_column_name,
id_column_type,
id_column_size,
meaning_column_name,
meaning_column_type,
meaning_column_size,
enabled_column_name,
compiled_attribute_column_name,
hierarchy_level_column_name,
start_date_column_name,
end_date_column_name,
summary_column_name,
additional_where_clause,
additional_quickpick_columns
)
VALUES
(
l_vst_set.flex_value_set_id,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
l_table_app.application_id,
p_application_table_name,
p_summary_allowed_flag,
p_value_column_name,
p_value_column_type,
p_value_column_size,
p_id_column_name,
p_id_column_type,
p_id_column_size,
p_meaning_column_name,
p_meaning_column_type,
p_meaning_column_size,
p_enabled_column_name,
p_compiled_attribute_column_na,
p_hierarchy_level_column_name,
p_start_date_column_name,
p_end_date_column_name,
p_summary_column_name,
p_additional_where_clause,
p_additional_quickpick_columns
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_user_exit IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_evt.last_updated_by,
p_db_last_update_date => l_vst_evt.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_validation_events SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
user_exit = p_user_exit
WHERE flex_value_set_id = l_vst_set.flex_value_set_id
AND event_code = p_event_code;
debug(l_func_name, 'Inserting VSET_EVENT.(no-TL)');
INSERT INTO fnd_flex_validation_events
(
flex_value_set_id,
event_code,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
user_exit
)
VALUES
(
l_vst_set.flex_value_set_id,
p_event_code,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_user_exit
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2,
p_error_message IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_scr_tl.last_updated_by,
p_db_last_update_date => l_vst_scr_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_scr.last_updated_by,
p_db_last_update_date => l_vst_scr.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_scl.last_updated_by,
p_db_last_update_date => l_vst_scl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_value_rule_lines SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
parent_flex_value_high = p_parent_flex_value_high
WHERE flex_value_set_id = l_vst_set.flex_value_set_id
AND flex_value_rule_id = l_vst_scr.flex_value_rule_id
AND parent_flex_value_low = p_parent_flex_value_low
AND include_exclude_indicator = p_include_exclude_indicator
AND flex_value_low = p_flex_value_low
AND flex_value_high = p_flex_value_high;
UPDATE fnd_flex_value_rule_lines SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
parent_flex_value_low = p_parent_flex_value_low,
parent_flex_value_high = p_parent_flex_value_high
WHERE flex_value_set_id = l_vst_set.flex_value_set_id
AND flex_value_rule_id = l_vst_scr.flex_value_rule_id
AND include_exclude_indicator = p_include_exclude_indicator
AND flex_value_low = p_flex_value_low
AND flex_value_high = p_flex_value_high;
debug(l_func_name, 'Inserting VSET_SECURITY_LINE.(no-TL)');
INSERT INTO fnd_flex_value_rule_lines
(
flex_value_set_id,
flex_value_rule_id,
parent_flex_value_low,
include_exclude_indicator,
flex_value_low,
flex_value_high,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
parent_flex_value_high
)
VALUES
(
l_vst_set.flex_value_set_id,
l_vst_scr.flex_value_rule_id,
p_parent_flex_value_low,
p_include_exclude_indicator,
p_flex_value_low,
p_flex_value_high,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_parent_flex_value_high
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_scu.last_updated_by,
p_db_last_update_date => l_vst_scu.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_value_rule_usages SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
parent_flex_value_high = p_parent_flex_value_high
WHERE application_id = l_resp.application_id
AND responsibility_id = l_resp.responsibility_id
AND flex_value_set_id = l_vst_set.flex_value_set_id
AND flex_value_rule_id = l_vst_scr.flex_value_rule_id
AND parent_flex_value_low = p_parent_flex_value_low;
UPDATE fnd_flex_value_rule_usages SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
parent_flex_value_low = p_parent_flex_value_low,
parent_flex_value_high = p_parent_flex_value_high
WHERE application_id = l_resp.application_id
AND responsibility_id = l_resp.responsibility_id
AND flex_value_set_id = l_vst_set.flex_value_set_id
AND flex_value_rule_id = l_vst_scr.flex_value_rule_id;
debug(l_func_name, 'Inserting VSET_SECURITY_USAGE.(no-TL)');
INSERT INTO fnd_flex_value_rule_usages
(
application_id,
responsibility_id,
flex_value_set_id,
flex_value_rule_id,
parent_flex_value_low,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
parent_flex_value_high
)
VALUES
(
l_resp.application_id,
l_resp.responsibility_id,
l_vst_set.flex_value_set_id,
l_vst_scr.flex_value_rule_id,
p_parent_flex_value_low,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_parent_flex_value_high
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_hierarchy_name IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_rgr_tl.last_updated_by,
p_db_last_update_date => l_vst_rgr_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_rgr.last_updated_by,
p_db_last_update_date => l_vst_rgr.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_assignment_order IN VARCHAR2,
p_assignment_date IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_set.last_updated_by,
p_db_last_update_date => l_vst_set.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_enabled_flag IN VARCHAR2,
p_summary_flag IN VARCHAR2,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2,
p_parent_flex_value_high IN VARCHAR2,
p_rollup_hierarchy_code IN VARCHAR2,
p_hierarchy_level IN VARCHAR2,
p_compiled_value_attributes IN VARCHAR2,
p_value_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_attribute16 IN VARCHAR2,
p_attribute17 IN VARCHAR2,
p_attribute18 IN VARCHAR2,
p_attribute19 IN VARCHAR2,
p_attribute20 IN VARCHAR2,
p_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_attribute31 IN VARCHAR2,
p_attribute32 IN VARCHAR2,
p_attribute33 IN VARCHAR2,
p_attribute34 IN VARCHAR2,
p_attribute35 IN VARCHAR2,
p_attribute36 IN VARCHAR2,
p_attribute37 IN VARCHAR2,
p_attribute38 IN VARCHAR2,
p_attribute39 IN VARCHAR2,
p_attribute40 IN VARCHAR2,
p_attribute41 IN VARCHAR2,
p_attribute42 IN VARCHAR2,
p_attribute43 IN VARCHAR2,
p_attribute44 IN VARCHAR2,
p_attribute45 IN VARCHAR2,
p_attribute46 IN VARCHAR2,
p_attribute47 IN VARCHAR2,
p_attribute48 IN VARCHAR2,
p_attribute49 IN VARCHAR2,
p_attribute50 IN VARCHAR2,
p_attribute_sort_order IN VARCHAR2 DEFAULT NULL,
p_flex_value_meaning IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_val_tl.last_updated_by,
p_db_last_update_date => l_vst_val_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_val.last_updated_by,
p_db_last_update_date => l_vst_val.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_vlh.last_updated_by,
p_db_last_update_date => l_vst_vlh.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_value_norm_hierarchy SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
start_date_active = To_date(p_start_date_active, g_date_mask),
end_date_active = To_date(p_end_date_active, g_date_mask)
WHERE flex_value_set_id = l_vst_set.flex_value_set_id
AND parent_flex_value = l_vst_val.flex_value
AND range_attribute = p_range_attribute
AND child_flex_value_low = p_child_flex_value_low
AND child_flex_value_high = p_child_flex_value_high;
debug(l_func_name, 'Inserting VSET_VALUE_HIERARCHY.(no-TL)');
INSERT INTO fnd_flex_value_norm_hierarchy
(
flex_value_set_id,
parent_flex_value,
range_attribute,
child_flex_value_low,
child_flex_value_high,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
start_date_active,
end_date_active
)
VALUES
(
l_vst_set.flex_value_set_id,
l_vst_val.flex_value,
p_range_attribute,
p_child_flex_value_low,
p_child_flex_value_high,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
To_date(p_start_date_active, g_date_mask),
To_date(p_end_date_active, g_date_mask)
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_compiled_value_attribute_val IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_compiled_value_attribute_val => p_compiled_value_attribute_val);
SELECT '$SRS$.$FLEX$.$LOADER$.' || hash_value
INTO l_return
FROM fnd_flex_hash
WHERE hash_value = l_counter
FOR UPDATE NOWAIT;
PROCEDURE delete_srs_desc_flex(p_application_short_name IN VARCHAR2,
p_descriptive_flexfield_name IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
l_func_name := g_api_name || 'delete_srs_desc_flex()';
DELETE
FROM fnd_descriptive_flexs
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE
FROM fnd_descriptive_flexs_tl
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE
FROM fnd_descr_flex_contexts
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE
FROM fnd_descr_flex_contexts_tl
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE
FROM fnd_descr_flex_column_usages
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
DELETE
FROM fnd_descr_flex_col_usage_tl
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name;
END delete_srs_desc_flex;
UPDATE fnd_descriptive_flexs
SET descriptive_flexfield_name = p_descriptive_flexfield_name
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
UPDATE fnd_descriptive_flexs_tl
SET descriptive_flexfield_name = p_descriptive_flexfield_name,
title = p_title
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
UPDATE fnd_descr_flex_contexts
SET descriptive_flexfield_name = p_descriptive_flexfield_name
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
UPDATE fnd_descr_flex_contexts_tl
SET descriptive_flexfield_name = p_descriptive_flexfield_name
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
UPDATE fnd_descr_flex_column_usages
SET descriptive_flexfield_name = p_descriptive_flexfield_name
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
UPDATE fnd_descr_flex_col_usage_tl
SET descriptive_flexfield_name = p_descriptive_flexfield_name
WHERE application_id = l_app.application_id
AND descriptive_flexfield_name = g_srs_loader_flex_name;
SELECT *
FROM fnd_descr_flex_column_usages
WHERE application_id = p_application_id
AND descriptive_flexfield_name = p_descriptive_flexfield_name
AND descriptive_flex_context_code = p_descriptive_flex_context_cod
ORDER BY application_column_name;
l_dff_flx.last_updated_by,
l_dff_flx.last_update_date,
l_dff_flx.descriptive_flexfield_name);
l_dff_ctx.last_updated_by,
l_dff_ctx.last_update_date,
' ' || l_dff_ctx.descriptive_flex_context_code);
px_dff_seg_arr(i).last_updated_by,
px_dff_seg_arr(i).last_update_date,
' ' || px_dff_seg_arr(i).application_column_name ||
'.' || px_dff_seg_arr(i).end_user_column_name);
l_header1 := Rpad('Entity', 41) || Rpad('Owner', 21) || 'Last Update Date';
GOTO label_insert_ldt;
GOTO label_insert_ldt;
<>
BEGIN
--
-- Delete the existing DB SRS Desc Flex.
--
delete_srs_desc_flex(p_application_short_name,
p_descriptive_flexfield_name);
delete_srs_desc_flex(p_application_short_name,
g_srs_loader_flex_name);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_table_application_short_name IN VARCHAR2,
p_application_table_name IN VARCHAR2,
p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
p_context_column_name IN VARCHAR2,
p_context_required_flag IN VARCHAR2,
p_context_user_override_flag IN VARCHAR2,
p_concatenated_segment_delimit IN VARCHAR2,
p_freeze_flex_definition_flag IN VARCHAR2,
p_protected_flag IN VARCHAR2,
p_default_context_field_name IN VARCHAR2,
p_default_context_value IN VARCHAR2,
p_context_default_type IN VARCHAR2 DEFAULT NULL,
p_context_default_value IN VARCHAR2 DEFAULT NULL,
p_context_override_value_set_n IN VARCHAR2 DEFAULT NULL,
p_context_runtime_property_fun IN VARCHAR2 DEFAULT NULL,
p_context_synchronization_flag IN VARCHAR2 DEFAULT NULL,
p_title IN VARCHAR2,
p_form_context_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_flx_tl.last_updated_by,
p_db_last_update_date => l_dff_flx_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_flx.last_updated_by,
p_db_last_update_date => l_dff_flx.last_update_date,
x_file_who => l_file_who)) THEN
--
-- SRS DFFs are handled in upload_srs_desc_flex().
--
IF (l_descriptive_flexfield_name NOT LIKE '$SRS$.%') THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
delete_srs_desc_flex(p_application_short_name,
g_srs_loader_flex_name);
p_last_update_date => p_last_update_date,
p_flexfield_usage_code => 'C');
p_last_update_date => p_last_update_date,
p_enabled_flag => 'Y',
p_global_flag => 'Y',
p_descriptive_flex_context_nam => 'Global Data Elements',
p_description => 'Global Data Element Context');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_flexfield_usage_code IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_col.last_updated_by,
p_db_last_update_date => l_col.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_columns SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
flexfield_application_id = Decode(p_flexfield_usage_code,
'N', NULL,
l_dff_flx.application_id),
flexfield_name = Decode(p_flexfield_usage_code,
'N', NULL,
l_dff_flx.descriptive_flexfield_name),
flexfield_usage_code = p_flexfield_usage_code
WHERE application_id = l_col.application_id
AND table_id = l_col.table_id
AND column_name = l_col.column_name;
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_ref.last_updated_by,
p_db_last_update_date => l_dff_ref.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_default_context_fields SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = Nvl(p_description, description)
WHERE application_id = (SELECT application_id
FROM fnd_application
WHERE application_short_name = p_application_short_name)
AND descriptive_flexfield_name = p_descriptive_flexfield_name
AND default_context_field_name = p_default_context_field_name
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_default_context_fields SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = p_description
WHERE application_id = l_dff_flx.application_id
AND descriptive_flexfield_name = l_dff_flx.descriptive_flexfield_name
AND default_context_field_name = p_default_context_field_name;
debug(l_func_name, 'Inserting DFF_REF_FIELD.(non-MLS)');
INSERT INTO fnd_default_context_fields
(
application_id,
descriptive_flexfield_name,
default_context_field_name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
description
)
VALUES
(
l_dff_flx.application_id,
l_dff_flx.descriptive_flexfield_name,
p_default_context_field_name,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_description
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_enabled_flag IN VARCHAR2,
p_global_flag IN VARCHAR2,
p_descriptive_flex_context_nam IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_ctx_tl.last_updated_by,
p_db_last_update_date => l_dff_ctx_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_ctx.last_updated_by,
p_db_last_update_date => l_dff_ctx.last_update_date,
x_file_who => l_file_who)) THEN
--
-- SRS DFFs are handled in upload_srs_desc_flex().
--
IF (l_descriptive_flexfield_name NOT LIKE '$SRS$.%') THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_column_seq_num IN VARCHAR2,
p_enabled_flag IN VARCHAR2,
p_display_flag IN VARCHAR2,
p_required_flag IN VARCHAR2,
p_security_enabled_flag IN VARCHAR2,
p_flex_value_set_name IN VARCHAR2,
p_display_size IN VARCHAR2,
p_maximum_description_len IN VARCHAR2,
p_concatenation_description_le IN VARCHAR2,
p_range_code IN VARCHAR2,
p_default_type IN VARCHAR2,
p_default_value IN VARCHAR2,
p_runtime_property_function IN VARCHAR2 DEFAULT NULL,
p_srw_param IN VARCHAR2,
p_form_left_prompt IN VARCHAR2,
p_form_above_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_seg_tl.last_updated_by,
p_db_last_update_date => l_dff_seg_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_seg.last_updated_by,
p_db_last_update_date => l_dff_seg.last_update_date,
x_file_who => l_file_who)) THEN
--
-- SRS DFFs are handled in upload_srs_desc_flex().
--
IF (l_descriptive_flexfield_name NOT LIKE '$SRS$.%') THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
SELECT fdfc.descriptive_flex_context_code
INTO l_ctx_code
FROM fnd_descr_flex_column_usages fdfcu,
fnd_descr_flex_contexts fdfc
WHERE fdfcu.application_column_name = p_application_column_name
AND fdfcu.descriptive_flex_context_code = fdfc.descriptive_flex_context_code
AND fdfcu.descriptive_flexfield_name = fdfc.descriptive_flexfield_name
AND fdfcu.application_id = fdfc.application_id
AND fdfc.descriptive_flexfield_name = l_dff_ctx.descriptive_flexfield_name
AND fdfc.application_id = l_dff_ctx.application_id
AND fdfc.global_flag <> l_dff_ctx.global_flag
AND ROWNUM < 2;
UPDATE fnd_segment_attribute_values
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_id_flex_segments
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_id_flex_segments_tl
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_shorthand_flex_aliases
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_exclude_rule_lines
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_include_rule_lines
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_validation_rule_lines
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_validation_rules
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_vdation_rules_tl
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_validation_rule_stats
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_flex_workflow_processes
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_id_flex_structures
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
UPDATE fnd_id_flex_structures_tl
SET id_flex_num = p_id_flex_num_new
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
DELETE FROM fnd_compiled_id_flex_structs
WHERE application_id = p_application_id
AND id_flex_code = p_id_flex_code
AND id_flex_num = p_id_flex_num_old;
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_table_application_short_name IN VARCHAR2,
p_application_table_name IN VARCHAR2,
p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
p_allow_id_valuesets IN VARCHAR2,
p_dynamic_inserts_feasible_fla IN VARCHAR2,
p_index_flag IN VARCHAR2,
p_unique_id_column_name IN VARCHAR2,
p_application_table_type IN VARCHAR2,
p_set_defining_column_name IN VARCHAR2,
p_maximum_concatenation_len IN VARCHAR2,
p_concatenation_len_warning IN VARCHAR2,
p_id_flex_name IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_flx.last_updated_by,
p_db_last_update_date => l_kff_flx.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_id_flexs SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
id_flex_name = Nvl(p_id_flex_name, id_flex_name),
description = Nvl(p_description, description)
WHERE application_id = (SELECT application_id
FROM fnd_application
WHERE application_short_name = p_application_short_name)
AND id_flex_code = p_id_flex_code
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_id_flexs SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
table_application_id = l_tbl.application_id,
application_table_name = l_tbl.table_name,
concatenated_segs_view_name = l_concatenated_segs_view_name,
allow_id_valuesets = p_allow_id_valuesets,
dynamic_inserts_feasible_flag = p_dynamic_inserts_feasible_fla,
index_flag = p_index_flag,
unique_id_column_name = p_unique_id_column_name,
application_table_type = p_application_table_type,
set_defining_column_name = p_set_defining_column_name,
maximum_concatenation_len = p_maximum_concatenation_len,
concatenation_len_warning = p_concatenation_len_warning,
id_flex_name = p_id_flex_name,
description = p_description
WHERE application_id = l_app.application_id
AND id_flex_code = p_id_flex_code;
debug(l_func_name, 'Inserting KEY_FLEX.(non-MLS)');
INSERT INTO fnd_id_flexs
(
application_id,
id_flex_code,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
table_application_id,
application_table_name,
concatenated_segs_view_name,
allow_id_valuesets,
dynamic_inserts_feasible_flag,
index_flag,
unique_id_column_name,
application_table_type,
set_defining_column_name,
maximum_concatenation_len,
concatenation_len_warning,
id_flex_name,
description
)
VALUES
(
l_app.application_id,
p_id_flex_code,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
l_tbl.application_id,
l_tbl.table_name,
l_concatenated_segs_view_name,
p_allow_id_valuesets,
p_dynamic_inserts_feasible_fla,
p_index_flag,
p_unique_id_column_name,
p_application_table_type,
p_set_defining_column_name,
p_maximum_concatenation_len,
p_concatenation_len_warning,
p_id_flex_name,
p_description
);
p_last_update_date => p_last_update_date,
p_flexfield_usage_code => 'I');
p_last_update_date => p_last_update_date,
p_flexfield_usage_code => 'S');
SELECT COUNT(*)
INTO l_count
FROM fnd_id_flex_structures
WHERE application_id = l_app.application_id
AND id_flex_code = p_id_flex_code;
p_last_update_date => p_last_update_date,
p_concatenated_segment_delimit => '.',
p_cross_segment_validation_fla => 'N',
p_dynamic_inserts_allowed_flag => 'N',
p_enabled_flag => 'Y',
p_freeze_flex_definition_flag => 'N',
p_freeze_structured_hier_flag => 'N',
p_shorthand_enabled_flag => 'N',
p_shorthand_length => NULL,
p_structure_view_name => NULL,
p_id_flex_structure_name => p_id_flex_name,
p_description => NULL,
p_shorthand_prompt => NULL);
SELECT
ifst.id_flex_structure_code,
fwp.wf_item_type
FROM (SELECT DISTINCT
fwpx.application_id,
fwpx.id_flex_code,
fwpx.wf_item_type
FROM fnd_flex_workflow_processes fwpx
) fwp,
fnd_id_flex_structures ifst
WHERE ifst.application_id = p_application_id
AND ifst.id_flex_code = p_id_flex_code
AND fwp.application_id = ifst.application_id
AND fwp.id_flex_code = ifst.id_flex_code
AND NOT exists
(SELECT NULL
FROM fnd_flex_workflow_processes fwp2
WHERE fwp2.application_id = ifst.application_id
AND fwp2.id_flex_code = ifst.id_flex_code
AND fwp2.id_flex_num = ifst.id_flex_num
AND fwp2.wf_item_type = fwp.wf_item_type);
p_last_update_date => p_last_update_date,
p_wf_process_name => 'DEFAULT_ACCOUNT_GENERATION');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_flexfield_usage_code IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_col.last_updated_by,
p_db_last_update_date => l_col.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_columns SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
flexfield_application_id = NULL,
flexfield_name = NULL,
flexfield_usage_code = p_flexfield_usage_code
WHERE application_id = l_col.application_id
AND table_id = l_col.table_id
AND column_name = l_col.column_name;
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_global_flag IN VARCHAR2,
p_required_flag IN VARCHAR2,
p_unique_flag IN VARCHAR2,
p_segment_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_flq.last_updated_by,
p_db_last_update_date => l_kff_flq.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_segment_attribute_types SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
segment_prompt = Nvl(p_segment_prompt, segment_prompt),
description = Nvl(p_description, description)
WHERE application_id = (SELECT application_id
FROM fnd_application
WHERE application_short_name = p_application_short_name)
AND id_flex_code = p_id_flex_code
AND segment_attribute_type = p_segment_attribute_type
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_segment_attribute_types SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
global_flag = p_global_flag,
required_flag = p_required_flag,
unique_flag = p_unique_flag,
segment_prompt = p_segment_prompt,
description = p_description
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code
AND segment_attribute_type = p_segment_attribute_type;
debug(l_func_name, 'Inserting KFF_FLEX_QUAL.(non-MLS)');
INSERT INTO fnd_segment_attribute_types
(
application_id,
id_flex_code,
segment_attribute_type,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
global_flag,
required_flag,
unique_flag,
segment_prompt,
description
)
VALUES
(
l_kff_flx.application_id,
l_kff_flx.id_flex_code,
p_segment_attribute_type,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_global_flag,
p_required_flag,
p_unique_flag,
p_segment_prompt,
p_description
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_required_flag IN VARCHAR2,
p_application_column_name IN VARCHAR2,
p_default_value IN VARCHAR2,
p_lookup_type IN VARCHAR2,
p_derivation_rule_code IN VARCHAR2,
p_derivation_rule_value1 IN VARCHAR2,
p_derivation_rule_value2 IN VARCHAR2,
p_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_sgq_tl.last_updated_by,
p_db_last_update_date => l_kff_sgq_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_sgq.last_updated_by,
p_db_last_update_date => l_kff_sgq.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date => p_last_update_date,
p_flexfield_usage_code => 'Q');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_concatenated_segment_delimit IN VARCHAR2,
p_cross_segment_validation_fla IN VARCHAR2,
p_dynamic_inserts_allowed_flag IN VARCHAR2,
p_enabled_flag IN VARCHAR2,
p_freeze_flex_definition_flag IN VARCHAR2,
p_freeze_structured_hier_flag IN VARCHAR2,
p_shorthand_enabled_flag IN VARCHAR2,
p_shorthand_length IN VARCHAR2,
p_structure_view_name IN VARCHAR2,
p_id_flex_structure_name IN VARCHAR2,
p_description IN VARCHAR2,
p_shorthand_prompt IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_str_tl.last_updated_by,
p_db_last_update_date => l_kff_str_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_str.last_updated_by,
p_db_last_update_date => l_kff_str.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
SELECT COUNT(*)
INTO l_count
FROM fnd_id_flex_structures
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code;
SELECT *
INTO l_kff_str2
FROM fnd_id_flex_structures
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code;
x_dynamic_inserts_allowed_flag => p_dynamic_inserts_allowed_flag,
x_enabled_flag => p_enabled_flag,
x_freeze_flex_definition_flag => p_freeze_flex_definition_flag,
x_freeze_structured_hier_flag => p_freeze_structured_hier_flag,
x_shorthand_enabled_flag => p_shorthand_enabled_flag,
x_shorthand_length => p_shorthand_length,
x_structure_view_name => p_structure_view_name,
x_id_flex_structure_name => p_id_flex_structure_name,
x_description => p_description,
x_shorthand_prompt => p_shorthand_prompt);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_wf_process_name IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_wfp.last_updated_by,
p_db_last_update_date => l_kff_wfp.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
SELECT 1
INTO l_dummy
FROM wf_item_types_vl
WHERE name = p_wf_item_type;
SELECT 1
INTO l_dummy
FROM wf_runnable_processes_v
WHERE item_type = p_wf_item_type
AND process_name = p_wf_process_name;
UPDATE fnd_flex_workflow_processes SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
wf_process_name = p_wf_process_name
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code
AND id_flex_num = l_kff_str.id_flex_num
AND wf_item_type = p_wf_item_type;
debug(l_func_name, 'Inserting KFF_WF_PROCESS.(no-TL)');
INSERT INTO fnd_flex_workflow_processes
(
application_id,
id_flex_code,
id_flex_num,
wf_item_type,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
wf_process_name
)
VALUES
(
l_kff_flx.application_id,
l_kff_flx.id_flex_code,
l_kff_str.id_flex_num,
p_wf_item_type,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_wf_process_name
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_concatenated_segments IN VARCHAR2,
p_enabled_flag IN VARCHAR2,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2,
p_attribute_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_sha.last_updated_by,
p_db_last_update_date => l_kff_sha.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_shorthand_flex_aliases SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = Nvl(p_description, description)
WHERE ((application_id, id_flex_code, id_flex_num) =
(SELECT application_id, id_flex_code, id_flex_num
FROM fnd_id_flex_structures
WHERE application_id = (SELECT application_id
FROM fnd_application
WHERE application_short_name = p_application_short_name)
AND id_flex_code = p_id_flex_code
AND id_flex_structure_code = p_id_flex_structure_code))
AND alias_name = p_alias_name
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_shorthand_flex_aliases SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
concatenated_segments = p_concatenated_segments,
enabled_flag = p_enabled_flag,
start_date_active = To_date(p_start_date_active, g_date_mask),
end_date_active = To_date(p_end_date_active, g_date_mask),
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
description = p_description
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code
AND id_flex_num = l_kff_str.id_flex_num
AND alias_name = p_alias_name;
debug(l_func_name, 'Inserting KFF_SH_ALIAS.(non-MLS)');
INSERT INTO fnd_shorthand_flex_aliases
(
application_id,
id_flex_code,
id_flex_num,
alias_name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
concatenated_segments,
enabled_flag,
start_date_active,
end_date_active,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
description
)
VALUES
(
l_kff_flx.application_id,
l_kff_flx.id_flex_code,
l_kff_str.id_flex_num,
p_alias_name,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_concatenated_segments,
p_enabled_flag,
To_date(p_start_date_active, g_date_mask),
To_date(p_end_date_active, g_date_mask),
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_description
);
SELECT status
INTO l_status
FROM user_triggers
WHERE trigger_name = p_trigger_name;
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_enabled_flag IN VARCHAR2,
p_error_segment_column_name IN VARCHAR2,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2,
p_error_message_text IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_cvr_tl.last_updated_by,
p_db_last_update_date => l_kff_cvr_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_cvr.last_updated_by,
p_db_last_update_date => l_kff_cvr.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_enabled_flag IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_cvl.last_updated_by,
p_db_last_update_date => l_kff_cvl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_flex_validation_rule_lines SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
description = Nvl(p_description, description)
WHERE ((application_id, id_flex_code, id_flex_num) =
(SELECT application_id, id_flex_code, id_flex_num
FROM fnd_id_flex_structures
WHERE application_id = (SELECT application_id
FROM fnd_application
WHERE application_short_name = p_application_short_name)
AND id_flex_code = p_id_flex_code
AND id_flex_structure_code = p_id_flex_structure_code))
AND flex_validation_rule_name = p_flex_validation_rule_name
AND include_exclude_indicator = p_include_exclude_indicator
AND concatenated_segments_low = p_concatenated_segments_low
AND concatenated_segments_high = p_concatenated_segments_high
AND userenv('LANG') = (SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B');
UPDATE fnd_flex_validation_rule_lines SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
enabled_flag = p_enabled_flag,
description = p_description
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code
AND id_flex_num = l_kff_str.id_flex_num
AND flex_validation_rule_name = l_kff_cvr.flex_validation_rule_name
AND include_exclude_indicator = p_include_exclude_indicator
AND concatenated_segments_low = p_concatenated_segments_low
AND concatenated_segments_high = p_concatenated_segments_high;
debug(l_func_name, 'Inserting KFF_CVR_LINE.(non-MLS)');
INSERT INTO fnd_flex_validation_rule_lines
(
application_id,
id_flex_code,
id_flex_num,
flex_validation_rule_name,
include_exclude_indicator,
concatenated_segments_low,
concatenated_segments_high,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
enabled_flag,
description
)
VALUES
(
l_kff_flx.application_id,
l_kff_flx.id_flex_code,
l_kff_str.id_flex_num,
l_kff_cvr.flex_validation_rule_name,
p_include_exclude_indicator,
p_concatenated_segments_low,
p_concatenated_segments_high,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_enabled_flag,
p_description
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_segment_num IN VARCHAR2,
p_application_column_index_fla IN VARCHAR2,
p_enabled_flag IN VARCHAR2,
p_required_flag IN VARCHAR2,
p_display_flag IN VARCHAR2,
p_display_size IN VARCHAR2,
p_security_enabled_flag IN VARCHAR2,
p_maximum_description_len IN VARCHAR2,
p_concatenation_description_le IN VARCHAR2,
p_flex_value_set_name IN VARCHAR2,
p_range_code IN VARCHAR2,
p_default_type IN VARCHAR2,
p_default_value IN VARCHAR2,
p_runtime_property_function IN VARCHAR2 DEFAULT NULL,
p_additional_where_clause IN VARCHAR2 DEFAULT NULL,
p_form_left_prompt IN VARCHAR2,
p_form_above_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_seg_tl.last_updated_by,
p_db_last_update_date => l_kff_seg_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_seg.last_updated_by,
p_db_last_update_date => l_kff_seg.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_attribute_value IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_kff_fqa.last_updated_by,
p_db_last_update_date => l_kff_fqa.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
UPDATE fnd_segment_attribute_values SET
last_updated_by = l_file_who.last_updated_by,
last_update_date = l_file_who.last_update_date,
last_update_login = l_file_who.last_update_login,
attribute_value = p_attribute_value
WHERE application_id = l_kff_flx.application_id
AND id_flex_code = l_kff_flx.id_flex_code
AND id_flex_num = l_kff_str.id_flex_num
AND application_column_name = l_kff_seg.application_column_name
AND segment_attribute_type = l_kff_flq.segment_attribute_type;
debug(l_func_name, 'Inserting KFF_FLEXQ_ASSIGN.(no-TL)');
INSERT INTO fnd_segment_attribute_values
(
application_id,
id_flex_code,
id_flex_num,
application_column_name,
segment_attribute_type,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
attribute_value
)
VALUES
(
l_kff_flx.application_id,
l_kff_flx.id_flex_code,
l_kff_str.id_flex_num,
l_kff_seg.application_column_name,
l_kff_flq.segment_attribute_type,
l_file_who.created_by,
l_file_who.creation_date,
l_file_who.last_updated_by,
l_file_who.last_update_date,
l_file_who.last_update_login,
p_attribute_value
);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_assignment_order IN VARCHAR2,
p_assignment_date IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_assignment_order IN VARCHAR2,
p_assignment_date IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_vst_set.last_updated_by,
p_db_last_update_date => l_vst_set.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Upload is not allowed because of customization.');
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_compiled_value_attribute_val IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_compiled_value_attribute_val => p_compiled_value_attribute_val);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2,
p_error_message IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_parent_flex_value_high => p_parent_flex_value_high,
p_error_message => p_error_message,
p_description => p_description);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_parent_flex_value_high => p_parent_flex_value_high);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_parent_flex_value_high IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_parent_flex_value_high => p_parent_flex_value_high);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_hierarchy_name IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_hierarchy_name => p_hierarchy_name,
p_description => p_description);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_enabled_flag IN VARCHAR2,
p_summary_flag IN VARCHAR2,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2,
p_parent_flex_value_high IN VARCHAR2,
p_rollup_flex_value_set_name IN VARCHAR2,
p_rollup_hierarchy_code IN VARCHAR2,
p_hierarchy_level IN VARCHAR2,
p_compiled_value_attributes IN VARCHAR2,
p_value_category IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_attribute16 IN VARCHAR2,
p_attribute17 IN VARCHAR2,
p_attribute18 IN VARCHAR2,
p_attribute19 IN VARCHAR2,
p_attribute20 IN VARCHAR2,
p_attribute21 IN VARCHAR2,
p_attribute22 IN VARCHAR2,
p_attribute23 IN VARCHAR2,
p_attribute24 IN VARCHAR2,
p_attribute25 IN VARCHAR2,
p_attribute26 IN VARCHAR2,
p_attribute27 IN VARCHAR2,
p_attribute28 IN VARCHAR2,
p_attribute29 IN VARCHAR2,
p_attribute30 IN VARCHAR2,
p_attribute31 IN VARCHAR2,
p_attribute32 IN VARCHAR2,
p_attribute33 IN VARCHAR2,
p_attribute34 IN VARCHAR2,
p_attribute35 IN VARCHAR2,
p_attribute36 IN VARCHAR2,
p_attribute37 IN VARCHAR2,
p_attribute38 IN VARCHAR2,
p_attribute39 IN VARCHAR2,
p_attribute40 IN VARCHAR2,
p_attribute41 IN VARCHAR2,
p_attribute42 IN VARCHAR2,
p_attribute43 IN VARCHAR2,
p_attribute44 IN VARCHAR2,
p_attribute45 IN VARCHAR2,
p_attribute46 IN VARCHAR2,
p_attribute47 IN VARCHAR2,
p_attribute48 IN VARCHAR2,
p_attribute49 IN VARCHAR2,
p_attribute50 IN VARCHAR2,
p_flex_value_meaning IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_enabled_flag => p_enabled_flag,
p_summary_flag => p_summary_flag,
p_start_date_active => p_start_date_active,
p_end_date_active => p_end_date_active,
p_parent_flex_value_high => p_parent_flex_value_high,
p_rollup_hierarchy_code => p_rollup_hierarchy_code,
p_hierarchy_level => p_hierarchy_level,
p_compiled_value_attributes => p_compiled_value_attributes,
p_value_category => p_value_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
p_attribute21 => p_attribute21,
p_attribute22 => p_attribute22,
p_attribute23 => p_attribute23,
p_attribute24 => p_attribute24,
p_attribute25 => p_attribute25,
p_attribute26 => p_attribute26,
p_attribute27 => p_attribute27,
p_attribute28 => p_attribute28,
p_attribute29 => p_attribute29,
p_attribute30 => p_attribute30,
p_attribute31 => p_attribute31,
p_attribute32 => p_attribute32,
p_attribute33 => p_attribute33,
p_attribute34 => p_attribute34,
p_attribute35 => p_attribute35,
p_attribute36 => p_attribute36,
p_attribute37 => p_attribute37,
p_attribute38 => p_attribute38,
p_attribute39 => p_attribute39,
p_attribute40 => p_attribute40,
p_attribute41 => p_attribute41,
p_attribute42 => p_attribute42,
p_attribute43 => p_attribute43,
p_attribute44 => p_attribute44,
p_attribute45 => p_attribute45,
p_attribute46 => p_attribute46,
p_attribute47 => p_attribute47,
p_attribute48 => p_attribute48,
p_attribute49 => p_attribute49,
p_attribute50 => p_attribute50,
p_attribute_sort_order => NULL,
p_flex_value_meaning => p_flex_value_meaning,
p_description => p_description);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_start_date_active IN VARCHAR2,
p_end_date_active IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_start_date_active => p_start_date_active,
p_end_date_active => p_end_date_active);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_assignment_order IN VARCHAR2,
p_assignment_date IN VARCHAR2,
p_compiled_value_attribute_val IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_last_update_date => p_last_update_date,
p_compiled_value_attribute_val => p_compiled_value_attribute_val);
p_last_update_date IN VARCHAR2 DEFAULT NULL,
p_table_application_short_name IN VARCHAR2,
p_application_table_name IN VARCHAR2,
p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
p_context_column_name IN VARCHAR2,
p_context_required_flag IN VARCHAR2,
p_context_user_override_flag IN VARCHAR2,
p_concatenated_segment_delimit IN VARCHAR2,
p_freeze_flex_definition_flag IN VARCHAR2,
p_protected_flag IN VARCHAR2,
p_default_context_field_name IN VARCHAR2,
p_default_context_value IN VARCHAR2,
p_context_default_type IN VARCHAR2 DEFAULT NULL,
p_context_default_value IN VARCHAR2 DEFAULT NULL,
p_context_override_value_set_n IN VARCHAR2 DEFAULT NULL,
p_context_runtime_property_fun IN VARCHAR2 DEFAULT NULL,
p_context_synchronization_flag IN VARCHAR2 DEFAULT NULL,
p_title IN VARCHAR2,
p_form_context_prompt IN VARCHAR2,
p_description IN VARCHAR2)
IS
l_func_name VARCHAR2(80);
p_file_last_update_date => p_last_update_date,
p_db_last_updated_by => l_dff_flx_tl.last_updated_by,
p_db_last_update_date => l_dff_flx_tl.last_update_date,
x_file_who => l_file_who)) THEN
IF (g_debug_on) THEN
debug(l_func_name, 'Translating DESC_FLEX.(MLS)');