APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_APPROVAL_STYLES

Line 2638: l_approval_style hxc_approval_styles.approval_style_id%TYPE;

2634:
2635: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2636: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2637:
2638: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
2639: l_assignment_periods hxc_timecard_utilities.periods;
2640:
2641:
2642: CURSOR c_approval_comp(

Line 2643: p_approval_style hxc_approval_styles.approval_style_id%TYPE

2639: l_assignment_periods hxc_timecard_utilities.periods;
2640:
2641:
2642: CURSOR c_approval_comp(
2643: p_approval_style hxc_approval_styles.approval_style_id%TYPE
2644: ,p_time_recipient hxc_time_recipients.time_recipient_id%TYPE
2645: )
2646: IS
2647: SELECT approval_comp_id

Line 3914: ) RETURN hxc_approval_styles.approval_style_id%TYPE

3910: /*
3911: FUNCTION get_approval_style(
3912: p_app_id IN hxc_time_building_blocks.time_building_block_id
3913: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
3914: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3915: IS
3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
3917:
3918: CURSOR c_approval_style(

Line 3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;

3912: p_app_id IN hxc_time_building_blocks.time_building_block_id
3913: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
3914: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3915: IS
3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
3917:
3918: CURSOR c_approval_style(
3919: p_app_id IN hxc_time_building_blocks.time_building_block_id
3920: )

Line 3947: ) RETURN hxc_approval_styles.approval_style_id%TYPE

3943:
3944: FUNCTION get_approval_style(
3945: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3946: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3947: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3948: IS
3949: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
3950: /*
3951: CURSOR c_approval_style(

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

3945: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3946: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3947: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3948: IS
3949: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
3950: /*
3951: CURSOR c_approval_style(
3952: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3953: )

Line 4323: hxc_approval_styles has,

4319: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
4320: is
4321: select hac.approval_comp_id
4322: from hxc_approval_comps hac,
4323: hxc_approval_styles has,
4324: hxc_time_building_blocks htb
4325: where htb.time_building_block_id =p_bb_id
4326: and htb.object_version_number = p_bb_ovn
4327: and htb.approval_style_id = has.approval_style_id