7085: (
7086: p_absence_type_id in number
7087: ) is
7088: l_route_name varchar2(50) := 'ABSENCE_SUM_OF_ELEMENT_ENTRY_VALUES';
7089: l_absence_name per_absence_attendance_types.name%type;
7090: l_business_group_id number;
7091: l_created_by number;
7092: l_last_login number;
7093: l_record_inserted boolean;
7105: into l_absence_name,
7106: l_business_group_id,
7107: l_created_by,
7108: l_last_login
7109: from per_absence_attendance_types
7110: where absence_attendance_type_id = p_absence_type_id;
7111: --
7112: -- create the user entity for the route
7113: --
7180: exist.
7181: */
7182: procedure refresh_absence_types is
7183: cursor c1 is select absence_attendance_type_id type_id
7184: from per_absence_attendance_types;
7185: begin
7186: for c1rec in c1 loop
7187: hrrbdeib_trace_on;
7188: hr_utility.trace ('creating database item absence type id: '||
7207: exist.
7208: */
7209: procedure delete_absence_types is
7210: cursor c1 is select absence_attendance_type_id type_id
7211: from per_absence_attendance_types;
7212: begin
7213: --
7214: -- delete the absence types
7215: --