67: , p_approval_period_set_name IN VARCHAR2
68: , p_owner IN VARCHAR2
69: , p_custom_mode IN VARCHAR2 ) IS
70:
71: l_approval_period_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
72: l_time_recipient_id hxc_entity_group_comps.entity_id%TYPE;
73: l_recurring_period_id hxc_entity_group_comps.entity_id%TYPE;
74: l_approval_period_set_id hxc_entity_group_comps.entity_group_id%TYPE;
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
68: , p_owner IN VARCHAR2
69: , p_custom_mode IN VARCHAR2 ) IS
70:
71: l_approval_period_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
72: l_time_recipient_id hxc_entity_group_comps.entity_id%TYPE;
73: l_recurring_period_id hxc_entity_group_comps.entity_id%TYPE;
74: l_approval_period_set_id hxc_entity_group_comps.entity_group_id%TYPE;
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
76: l_owner VARCHAR2(6);
69: , p_custom_mode IN VARCHAR2 ) IS
70:
71: l_approval_period_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
72: l_time_recipient_id hxc_entity_group_comps.entity_id%TYPE;
73: l_recurring_period_id hxc_entity_group_comps.entity_id%TYPE;
74: l_approval_period_set_id hxc_entity_group_comps.entity_group_id%TYPE;
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
76: l_owner VARCHAR2(6);
77:
70:
71: l_approval_period_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
72: l_time_recipient_id hxc_entity_group_comps.entity_id%TYPE;
73: l_recurring_period_id hxc_entity_group_comps.entity_id%TYPE;
74: l_approval_period_set_id hxc_entity_group_comps.entity_group_id%TYPE;
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
76: l_owner VARCHAR2(6);
77:
78: BEGIN
71: l_approval_period_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
72: l_time_recipient_id hxc_entity_group_comps.entity_id%TYPE;
73: l_recurring_period_id hxc_entity_group_comps.entity_id%TYPE;
74: l_approval_period_set_id hxc_entity_group_comps.entity_group_id%TYPE;
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
76: l_owner VARCHAR2(6);
77:
78: BEGIN
79: g_debug:=hr_utility.debug_enabled;