--select * from
fnd_descr_flex_contexts where
descriptive_flex_context_code = 'XXHR_XXX_EDUCATION'-- EIT Details
--select * from fnd_descr_flex_col_usage_vl where
descriptive_flex_context_code = 'XXHR_XXX_EDUCATION' - EIT Column Details
DECLARE
CURSOR c1
IS
SELECT *
FROM
fnd_descr_flex_contexts
WHERE descriptive_flex_context_code =
'XXHR_XXX_EDUCATION';
BEGIN
FOR
i IN c1
LOOP
BEGIN
fnd_flex_dsc_api.delete_context
(
appl_short_name => 'PER', --
HR
flexfield_name => i.descriptive_flexfield_name,
context => i.descriptive_flex_context_code);
DBMS_OUTPUT.put_line
(
i.descriptive_flex_context_code
||
' has been deleted
Successfully!');
EXCEPTION
WHEN
OTHERS
THEN
DBMS_OUTPUT.put_line
(
' Inner Exception: '
||
i.descriptive_flex_context_code
||
' - '
||
SQLERRM);
END;
END
LOOP;
EXCEPTION
WHEN
OTHERS
THEN
DBMS_OUTPUT.put_line
(' Main Exception: ' || SQLERRM);
END;
No comments:
Post a Comment