APPS.HXC_HAC_UPLOAD_PKG dependencies on HXC_APPROVAL_STYLES

Line 19: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

15: , p_custom_mode VARCHAR2 ) IS
16:
17:
18: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
19: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
20: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
21: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
22: l_ovn hxc_approval_styles.object_version_number%TYPE := NULL;
23: l_owner VARCHAR2(6);

Line 22: l_ovn hxc_approval_styles.object_version_number%TYPE := NULL;

18: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
19: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
20: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
21: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
22: l_ovn hxc_approval_styles.object_version_number%TYPE := NULL;
23: l_owner VARCHAR2(6);
24:
25: FUNCTION get_approval_style_id ( p_name VARCHAR2 ) RETURN NUMBER IS
26:

Line 29: FROM hxc_approval_styles

25: FUNCTION get_approval_style_id ( p_name VARCHAR2 ) RETURN NUMBER IS
26:
27: CURSOR csr_get_as_id IS
28: SELECT approval_style_id
29: FROM hxc_approval_styles
30: WHERE name = p_name;
31:
32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
33:

Line 32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

28: SELECT approval_style_id
29: FROM hxc_approval_styles
30: WHERE name = p_name;
31:
32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
33:
34: BEGIN
35:
36: OPEN csr_get_as_id;

Line 82: , hxc_approval_styles has

78: INTO l_approval_comp_id
79: , l_ovn
80: , l_owner
81: FROM hxc_approval_comps hac
82: , hxc_approval_styles has
83: WHERE has.name = P_AS_NAME
84: AND hac.approval_style_id = has.approval_style_id
85: AND hac.time_recipient_id = l_time_recipient_id
86: AND hac.approval_mechanism = p_approval_mechanism;