APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_APPROVAL_STYLES

Line 10: return hxc_approval_styles.admin_role%type

6: -- This will determine the error admin role
7: FUNCTION find_admin_role(
8: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
9: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
10: return hxc_approval_styles.admin_role%type
11: is
12:
13: l_admin_role hxc_approval_styles.admin_role%type;
14: l_proc constant varchar2(61) := g_pkg ||'find_admin_role';

Line 13: l_admin_role hxc_approval_styles.admin_role%type;

9: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
10: return hxc_approval_styles.admin_role%type
11: is
12:
13: l_admin_role hxc_approval_styles.admin_role%type;
14: l_proc constant varchar2(61) := g_pkg ||'find_admin_role';
15:
16: CURSOR c_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
17: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

Line 23: hxc_approval_styles has

19: SELECT
20: has.admin_role
21: FROM
22: hxc_time_building_blocks htbb,
23: hxc_approval_styles has
24: WHERE
25: htbb.time_building_block_id = p_timecard_id and
26: htbb.object_version_number = p_timecard_ovn and
27: htbb.approval_style_id = has.approval_style_id;

Line 74: return hxc_approval_styles.error_admin_role%type

70:
71: FUNCTION find_error_admin_role(
72: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
73: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
74: return hxc_approval_styles.error_admin_role%type
75: is
76:
77: l_error_admin_role hxc_approval_styles.error_admin_role%type;
78: l_proc constant varchar2(61) := g_pkg ||'find_error_admin_role';

Line 77: l_error_admin_role hxc_approval_styles.error_admin_role%type;

73: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
74: return hxc_approval_styles.error_admin_role%type
75: is
76:
77: l_error_admin_role hxc_approval_styles.error_admin_role%type;
78: l_proc constant varchar2(61) := g_pkg ||'find_error_admin_role';
79:
80: CURSOR c_error_admin_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
81: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

Line 87: hxc_approval_styles has

83: SELECT
84: has.error_admin_role
85: FROM
86: hxc_time_building_blocks htbb,
87: hxc_approval_styles has
88: WHERE
89: htbb.time_building_block_id = p_timecard_id and
90: htbb.object_version_number = p_timecard_ovn and
91: htbb.approval_style_id = has.approval_style_id;

Line 496: hxc_approval_styles has,

492: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
493: is
494: select hac.approval_comp_id
495: from hxc_approval_comps hac,
496: hxc_approval_styles has,
497: hxc_time_building_blocks htb
498: where htb.time_building_block_id =p_bb_id
499: and htb.object_version_number = p_bb_ovn
500: and htb.approval_style_id = has.approval_style_id