6: TYPE NUMTAB IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
7: TYPE VARCHARTAB IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
8: TYPE DATETAB IS TABLE OF DATE INDEX BY PLS_INTEGER;
9:
10: TYPE t_absences IS TABLE OF hxc_abs_ret_temp%ROWTYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE r_transactions IS RECORD (
13: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
14: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
9:
10: TYPE t_absences IS TABLE OF hxc_abs_ret_temp%ROWTYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE r_transactions IS RECORD (
13: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
14: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
15: );
16:
17: TYPE t_transactions IS TABLE OF r_transactions
10: TYPE t_absences IS TABLE OF hxc_abs_ret_temp%ROWTYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE r_transactions IS RECORD (
13: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
14: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
15: );
16:
17: TYPE t_transactions IS TABLE OF r_transactions
18: INDEX BY BINARY_INTEGER;
30: TYPE t_absences_details IS TABLE OF r_absences_details
31: INDEX BY BINARY_INTEGER;
32:
33: TYPE r_edited_days IS RECORD (
34: day_start hxc_abs_ret_temp.day_start%TYPE,
35: day_stop hxc_abs_ret_temp.day_stop%TYPE,
36: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
37: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
38: );
31: INDEX BY BINARY_INTEGER;
32:
33: TYPE r_edited_days IS RECORD (
34: day_start hxc_abs_ret_temp.day_start%TYPE,
35: day_stop hxc_abs_ret_temp.day_stop%TYPE,
36: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
37: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
38: );
39:
32:
33: TYPE r_edited_days IS RECORD (
34: day_start hxc_abs_ret_temp.day_start%TYPE,
35: day_stop hxc_abs_ret_temp.day_stop%TYPE,
36: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
37: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
38: );
39:
40: TYPE t_edited_days IS TABLE OF r_edited_days
33: TYPE r_edited_days IS RECORD (
34: day_start hxc_abs_ret_temp.day_start%TYPE,
35: day_stop hxc_abs_ret_temp.day_stop%TYPE,
36: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
37: object_version_number hxc_abs_ret_temp.object_version_number%TYPE
38: );
39:
40: TYPE t_edited_days IS TABLE OF r_edited_days
41: INDEX BY BINARY_INTEGER;
50:
51: g_tk_ret_messages t_tk_ret_messages;
52:
53: TYPE r_cost_attributes IS RECORD (
54: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
55: object_version_number hxc_abs_ret_temp.object_version_number%TYPE,
56: attribute1 hxc_time_attributes.attribute1%TYPE,
57: attribute2 hxc_time_attributes.attribute1%TYPE,
58: attribute3 hxc_time_attributes.attribute1%TYPE,
51: g_tk_ret_messages t_tk_ret_messages;
52:
53: TYPE r_cost_attributes IS RECORD (
54: time_building_block_id hxc_abs_ret_temp.time_building_block_id%TYPE,
55: object_version_number hxc_abs_ret_temp.object_version_number%TYPE,
56: attribute1 hxc_time_attributes.attribute1%TYPE,
57: attribute2 hxc_time_attributes.attribute1%TYPE,
58: attribute3 hxc_time_attributes.attribute1%TYPE,
59: attribute4 hxc_time_attributes.attribute1%TYPE,