DBA Data[Home] [Help]

APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 118: hxc_time_entry_rules hte

114: p_time_recipient_id number) IS
115: SELECT 'Y'
116: FROM hxc_entity_groups heg,
117: hxc_entity_group_comps hec,
118: hxc_time_entry_rules hte
119: WHERE heg.entity_type = 'TIME_ENTRY_RULES' and
120: heg.entity_group_id = p_elp_terg_id and
121: hec.ENTITY_GROUP_ID =heg.entity_group_id and
122: hec.entity_id = hte.TIME_ENTRY_RULE_ID and

Line 174: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

170:
171: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
172: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
173:
174: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
175:
176: TYPE r_time_recipient IS RECORD ( DUMMY VARCHAR2(1) );
177:
178: TYPE t_time_recipient IS TABLE OF r_time_recipient INDEX BY BINARY_INTEGER;

Line 764: hxc_time_entry_rules_utils_pkg.tc_edit_allowed

760:
761: IF (to_char(l_timecard_info_rec.start_date,'YYYY/MM/DD') <= l_futur_limit_date and
762: to_char(l_timecard_info_rec.end_date,'YYYY/MM/DD') >= l_past_limit_date )
763: THEN
764: hxc_time_entry_rules_utils_pkg.tc_edit_allowed
765: (p_timecard_id => l_timecard_info_rec.timecard_bb_id
766: ,p_timecard_ovn => l_timecard_info_rec.timecard_ovn
767: ,p_timecard_status => l_tc_approval_status
768: ,p_edit_allowed_preference => l_status_allowing_edits