1513: ) is
1514:
1515: cursor crs_approval_extensions is select
1516: run_recipient_extensions from
1517: hxc_approval_styles
1518: where
1519: approval_style_id=p_approval_style_id;
1520: approval_style_extensions hxc_approval_styles.run_recipient_extensions%type;
1521: Begin
1516: run_recipient_extensions from
1517: hxc_approval_styles
1518: where
1519: approval_style_id=p_approval_style_id;
1520: approval_style_extensions hxc_approval_styles.run_recipient_extensions%type;
1521: Begin
1522: if not(p_run_recipient_extensions is null or p_run_recipient_extensions in ('Y','N'))
1523: then
1524: hr_utility.set_message(809,'HXC_VALUE_RECIPIENT_EXTENSIONS');