DBA Data[Home] [Help]

APPS.HXC_TER_UPLOAD_PKG dependencies on HXC_APPROVAL_STYLES

Line 281: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

277: , p_custom_mode IN VARCHAR2 ) IS
278:
279: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;
280: l_time_entry_rule_id hxc_data_app_rule_usages.time_entry_rule_id%TYPE;
281: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
282: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
283: l_ovn hxc_deposit_processes.object_version_number%TYPE;
284: l_owner VARCHAR2(6);
285:

Line 311: FROM hxc_approval_styles

307: FUNCTION get_approval_style_id ( p_approval_style_name VARCHAR2 ) RETURN NUMBER IS
308:
309: CURSOR csr_get_as_id IS
310: SELECT approval_style_id
311: FROM hxc_approval_styles
312: WHERE name = p_approval_style_name;
313:
314: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
315:

Line 314: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

310: SELECT approval_style_id
311: FROM hxc_approval_styles
312: WHERE name = p_approval_style_name;
313:
314: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
315:
316: BEGIN
317:
318: OPEN csr_get_as_id;