5: g_package CONSTANT VARCHAR2 (33) := 'hxc_timestore_deposit.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7:
8: PROCEDURE get_timecard_tables (
9: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
10: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
11: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
12: p_app_blocks OUT NOCOPY hxc_block_table_type,
13: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
22: );
23: END get_timecard_tables;
24:
25: PROCEDURE get_timecard_tables (
26: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
27: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
28: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
29: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
30: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
89: -- first and start afresh
90: --
91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: --
91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
113: p_app_blocks IN OUT NOCOPY hxc_block_table_type
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
113: p_app_blocks IN OUT NOCOPY hxc_block_table_type
114: )
114: )
115: IS
116: l_proc VARCHAR2 (72);
117: l_count_building_block PLS_INTEGER;
118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
120: BEGIN
121: g_debug := hr_utility.debug_enabled;
122:
115: IS
116: l_proc VARCHAR2 (72);
117: l_count_building_block PLS_INTEGER;
118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
120: BEGIN
121: g_debug := hr_utility.debug_enabled;
122:
123: IF g_debug
175: -- call the create_bb procedure that accepts the new TYPE
176: -- and then convert it back to the old PL/SQL table.
177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
176: -- and then convert it back to the old PL/SQL table.
177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
199: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
199: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
200: )
270: -- first and start afresh
271: --
272: -----------------------------------------------------------------------------
273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
271: --
272: -----------------------------------------------------------------------------
273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
288: IS
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
288: IS
289: l_proc VARCHAR2 (72);
290: l_count_building_block PLS_INTEGER;
288: IS
289: l_proc VARCHAR2 (72);
290: l_count_building_block PLS_INTEGER;
291: -- l_tc_days PLS_INTEGER;
292: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
293: -- l_building_block_index PLS_INTEGER;
294: BEGIN
295: g_debug := hr_utility.debug_enabled;
296:
389: -- the new TYPE and then convert it back to the old PL/SQL table.
390: --
391: -----------------------------------------------------------------------------
392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
390: --
391: -----------------------------------------------------------------------------
392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
407: IS
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
407: IS
408: l_proc VARCHAR2 (72);
409: l_blocks hxc_block_table_type;
466: -- clear it first and start afresh.
467: --
468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
467: --
468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:
477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:
485: IF g_debug
535: -- the new TYPE and then convert it back to the old PL/SQL table.
536: --
537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
536: --
537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
546: )
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
546: )
547: IS
548: l_proc VARCHAR2 (72);
549: l_blocks hxc_block_table_type;
611: -- clear it first and start afresh.
612: --
613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
612: --
613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
622: )
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
622: )
623: IS
624: l_proc VARCHAR2 (72);
625: l_count_building_block PLS_INTEGER;
625: l_count_building_block PLS_INTEGER;
626: -- l_building_block_index PLS_INTEGER;
627: l_parent_building_block_index PLS_INTEGER;
628: l_parent_is_new VARCHAR2 (1);
629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;
626: -- l_building_block_index PLS_INTEGER;
627: l_parent_building_block_index PLS_INTEGER;
628: l_parent_is_new VARCHAR2 (1);
629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;
634:
757: -- the new TYPE and then convert it back to the old PL/SQL table.
758: --
759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
758: --
759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
768: )
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
768: )
769: IS
770: l_proc VARCHAR2 (72);
771: l_blocks hxc_block_table_type;
830: -- TBB, with a start date = the day passed in.
831: --
832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
831: --
832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;
845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;
850: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
851: BEGIN
852: IF g_debug
853: THEN
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;
850: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
851: BEGIN
852: IF g_debug
853: THEN
854: l_proc := g_package || 'auto_create_timecard';
952: -- clear it first and start afresh.
953: --
954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
953: --
954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
974: )
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
974: )
975: IS
976: l_proc VARCHAR2 (72);
977: l_count_building_block PLS_INTEGER;
976: l_proc VARCHAR2 (72);
977: l_count_building_block PLS_INTEGER;
978: l_parent_building_block_index PLS_INTEGER;
979: l_parent_is_new VARCHAR2 (1);
980: l_unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE;
981: BEGIN
982: g_debug := hr_utility.debug_enabled;
983:
984: IF g_debug
1107: -- the new TYPE and then convert it back to the old PL/SQL table.
1108: --
1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1108: --
1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )
1130: IS
1131: l_proc VARCHAR2 (72);
1132: l_blocks hxc_block_table_type;
1205: -- clear it first and start afresh.
1206: --
1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1206: --
1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225:
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225:
1226: IF g_debug
1298: -- the new TYPE and then convert it back to the old PL/SQL table.
1299: --
1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1299: --
1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1311: )
1312: IS
1313: l_proc VARCHAR2 (72);
1314: l_blocks hxc_block_table_type;
1378: -- clear it first and start afresh.
1379: --
1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1379: --
1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1396: BEGIN
1397: g_debug := hr_utility.debug_enabled;
1398:
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1396: BEGIN
1397: g_debug := hr_utility.debug_enabled;
1398:
1399: IF g_debug
1471: -- the new TYPE and then convert it back to the old PL/SQL table.
1472: --
1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1472: --
1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1484: )
1485: IS
1486: l_proc VARCHAR2 (72);
1487: l_blocks hxc_block_table_type;
1553: -- belongs to the same group, this needs to be the same id.
1554: --
1555: -----------------------------------------------------------------------------
1556: PROCEDURE create_attribute (
1557: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1558: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1560: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1561: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1681: -- on another timecard, please clear it first and start afresh.
1682: --
1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1682: --
1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1694: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1832: -- the new TYPE and then convert it back to the old PL/SQL table.
1833: --
1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1833: --
1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1845: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1902: -- have to perform a deposit to get the delete through.
1903: --
1904: -----------------------------------------------------------------------------
1905: PROCEDURE delete_detail_bb (
1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1907: -- p_time_recipient_id IN NUMBER,
1908: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1905: PROCEDURE delete_detail_bb (
1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1907: -- p_time_recipient_id IN NUMBER,
1908: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1911: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1912: )
1913: IS
1971: -- the new TYPE and then convert it back to the old PL/SQL table.
1972: --
1973: -----------------------------------------------------------------------------
1974: PROCEDURE delete_detail_bb (
1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1974: PROCEDURE delete_detail_bb (
1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1980: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1981: )
1982: IS
2034: -- in this case).
2035: --
2036: -----------------------------------------------------------------------------
2037: PROCEDURE delete_timecard (
2038: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2039: p_mode IN VARCHAR2,
2040: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2041: -- Not used anymore, left in for backwards compatibility
2042: p_retrieval_process IN VARCHAR2,
2040: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2041: -- Not used anymore, left in for backwards compatibility
2042: p_retrieval_process IN VARCHAR2,
2043: -- Not used anymore, left in for backwards compatibility
2044: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
2045: -- Not used anymore, left in for backwards compatibility
2046: p_template IN VARCHAR2
2047: )
2048: IS
2097: --
2098: -----------------------------------------------------------------------------
2099: PROCEDURE update_attribute (
2100: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2101: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2102: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2104: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2105: -- p_time_recipient_id IN NUMBER,
2120: SELECT time_building_block_id
2121: FROM hxc_time_attribute_usages
2122: WHERE time_attribute_id = v_time_attribute_id;
2123:
2124: l_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2125: --csr_tbb_id%ROWTYPE;
2126: BEGIN
2127: g_debug := hr_utility.debug_enabled;
2128:
2266: --
2267: -----------------------------------------------------------------------------
2268: PROCEDURE update_attribute (
2269: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2270: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2271: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2274: -- p_time_recipient_id IN NUMBER,
2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2345: p_template IN VARCHAR2,
2346: p_item_type IN wf_items.item_type%TYPE,
2347: p_approval_prc IN wf_process_activities.process_name%TYPE,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2345: p_template IN VARCHAR2,
2346: p_item_type IN wf_items.item_type%TYPE,
2347: p_approval_prc IN wf_process_activities.process_name%TYPE,
2348: p_process_terminated_employees IN BOOLEAN,
2630: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2637: p_item_type IN wf_items.item_type%TYPE,
2638: p_approval_prc IN wf_process_activities.process_name%TYPE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2637: p_item_type IN wf_items.item_type%TYPE,
2638: p_approval_prc IN wf_process_activities.process_name%TYPE,
2639: p_process_terminated_employees IN BOOLEAN,