APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_APPROVAL_STYLES

Line 2986: l_approval_style hxc_approval_styles.approval_style_id%TYPE;

2982:
2983: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2984: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2985:
2986: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
2987: l_assignment_periods hxc_timecard_utilities.periods;
2988:
2989:
2990: CURSOR c_approval_comp(

Line 2991: p_approval_style hxc_approval_styles.approval_style_id%TYPE

2987: l_assignment_periods hxc_timecard_utilities.periods;
2988:
2989:
2990: CURSOR c_approval_comp(
2991: p_approval_style hxc_approval_styles.approval_style_id%TYPE
2992: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE
2993: )
2994: IS
2995: SELECT approval_comp_id

Line 4566: ) RETURN hxc_approval_styles.approval_style_id%TYPE

4562: /*
4563: FUNCTION get_approval_style(
4564: p_app_id IN hxc_time_building_blocks.time_building_block_id
4565: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
4566: ) RETURN hxc_approval_styles.approval_style_id%TYPE
4567: IS
4568: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
4569:
4570: CURSOR c_approval_style(

Line 4568: l_approval_style hxc_approval_styles.approval_style_id%TYPE;

4564: p_app_id IN hxc_time_building_blocks.time_building_block_id
4565: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
4566: ) RETURN hxc_approval_styles.approval_style_id%TYPE
4567: IS
4568: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
4569:
4570: CURSOR c_approval_style(
4571: p_app_id IN hxc_time_building_blocks.time_building_block_id
4572: )

Line 4599: ) RETURN hxc_approval_styles.approval_style_id%TYPE

4595:
4596: FUNCTION get_approval_style(
4597: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4598: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4599: ) RETURN hxc_approval_styles.approval_style_id%TYPE
4600: IS
4601: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
4602: /*
4603: CURSOR c_approval_style(

Line 4601: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;

4597: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4598: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4599: ) RETURN hxc_approval_styles.approval_style_id%TYPE
4600: IS
4601: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
4602: /*
4603: CURSOR c_approval_style(
4604: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4605: )

Line 5010: hxc_approval_styles has,

5006: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
5007: is
5008: select hac.approval_comp_id
5009: from hxc_approval_comps hac,
5010: hxc_approval_styles has,
5011: hxc_time_building_blocks htb
5012: where htb.time_building_block_id =p_bb_id
5013: and htb.object_version_number = p_bb_ovn
5014: and htb.approval_style_id = has.approval_style_id