APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_APPROVAL_STYLES

Line 117: -- Returns: hxc_approval_styles.approval_style_id

113: -----------------------------------------------------------------------------
114: -- Type: Function
115: -- Scope: Public
116: -- Name: approval_style_id
117: -- Returns: hxc_approval_styles.approval_style_id
118: -- IN Parameters: p_approval_style_name -> Name of the approval style for which
119: -- you want to find the ID
120: --
121: -- Description: Private Function that return the ID of the 'OTL Auto Approve'

Line 126: p_approval_style_name hxc_approval_styles.NAME%TYPE

122: -- approval.
123: --
124: -----------------------------------------------------------------------------
125: FUNCTION approval_style_id (
126: p_approval_style_name hxc_approval_styles.NAME%TYPE
127: )
128: RETURN hxc_approval_styles.approval_style_id%TYPE
129: IS
130: l_proc VARCHAR2 (72);

Line 128: RETURN hxc_approval_styles.approval_style_id%TYPE

124: -----------------------------------------------------------------------------
125: FUNCTION approval_style_id (
126: p_approval_style_name hxc_approval_styles.NAME%TYPE
127: )
128: RETURN hxc_approval_styles.approval_style_id%TYPE
129: IS
130: l_proc VARCHAR2 (72);
131: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
132:

Line 131: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

127: )
128: RETURN hxc_approval_styles.approval_style_id%TYPE
129: IS
130: l_proc VARCHAR2 (72);
131: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
132:
133: CURSOR csr_approval_style_id (p_name hxc_approval_styles.NAME%TYPE)
134: IS
135: SELECT has.approval_style_id

Line 133: CURSOR csr_approval_style_id (p_name hxc_approval_styles.NAME%TYPE)

129: IS
130: l_proc VARCHAR2 (72);
131: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
132:
133: CURSOR csr_approval_style_id (p_name hxc_approval_styles.NAME%TYPE)
134: IS
135: SELECT has.approval_style_id
136: FROM hxc_approval_styles has
137: WHERE has.NAME = p_name;

Line 136: FROM hxc_approval_styles has

132:
133: CURSOR csr_approval_style_id (p_name hxc_approval_styles.NAME%TYPE)
134: IS
135: SELECT has.approval_style_id
136: FROM hxc_approval_styles has
137: WHERE has.NAME = p_name;
138: BEGIN
139: g_debug := hr_utility.debug_enabled;
140: