12: g_validate BOOLEAN;
13:
14: SUBTYPE mode_varchar2 IS VARCHAR2 (15);
15:
16: c_hours_uom CONSTANT hxc_time_building_blocks.unit_of_measure%TYPE
17: := 'HOURS';
18: c_migration CONSTANT mode_varchar2 := 'MIGRATION';
19: c_tk_save CONSTANT mode_varchar2 := 'FORCE_SAVE';
20: c_tk_submit CONSTANT mode_varchar2 := 'FORCE_SUBMIT';
68: --
69: -- {End Of Comments}
70: --
71: PROCEDURE get_timecard_tables (
72: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
73: -- p_time_recipient_id IN NUMBER,
74: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
75: DEFAULT g_otl_deposit_process,
76: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
120: --
121: -- {End Of Comments}
122: --
123: PROCEDURE get_timecard_tables (
124: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
125: -- p_time_recipient_id IN NUMBER,
126: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
127: DEFAULT g_otl_deposit_process,
128: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
208: --
209: -- {End Of Comments}
210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
209: -- {End Of Comments}
210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
240: DEFAULT NULL,
241: p_new IN VARCHAR2 DEFAULT 'Y',
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
240: DEFAULT NULL,
241: p_new IN VARCHAR2 DEFAULT 'Y',
242: p_changed IN VARCHAR2 DEFAULT '',
243: p_app_blocks IN OUT NOCOPY hxc_block_table_type
320: --
321: -- {End Of Comments}
322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
321: -- {End Of Comments}
322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
352: DEFAULT NULL,
353: p_new IN VARCHAR2 DEFAULT 'Y',
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
352: DEFAULT NULL,
353: p_new IN VARCHAR2 DEFAULT 'Y',
354: p_changed IN VARCHAR2 DEFAULT '',
355: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
408: --
409: -- {End Of Comments}
410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
409: -- {End Of Comments}
410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
425: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
426: );
421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
425: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
426: );
427:
428: --
429: -- ----------------------------------------------------------------------------
477: --
478: -- {End Of Comments}
479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
478: -- {End Of Comments}
479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
494: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
495: );
490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
494: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
495: );
496:
497: --
498: -- ----------------------------------------------------------------------------
545: --
546: -- {End Of Comments}
547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
546: -- {End Of Comments}
547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
558: DEFAULT g_otl_deposit_process,
559: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
558: DEFAULT g_otl_deposit_process,
559: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
560: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
561: );
562:
563: --
564: -- ----------------------------------------------------------------------------
610: --
611: -- {End Of Comments}
612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
611: -- {End Of Comments}
612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
623: DEFAULT g_otl_deposit_process,
624: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
623: DEFAULT g_otl_deposit_process,
624: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
625: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
626: );
627:
628: --
629: -- ----------------------------------------------------------------------------
677: --
678: -- {End Of Comments}
679: --
680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
678: -- {End Of Comments}
679: --
680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
689: DEFAULT g_otl_deposit_process,
690: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
689: DEFAULT g_otl_deposit_process,
690: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
691: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
692: );
693:
694: --
695: -- ----------------------------------------------------------------------------
743: --
744: -- {End Of Comments}
745: --
746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
744: -- {End Of Comments}
745: --
746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
755: DEFAULT g_otl_deposit_process,
756: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
755: DEFAULT g_otl_deposit_process,
756: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
757: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
757: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
767: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
767: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
768: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
768: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
778: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
778: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
779: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
780: ); */
781:
782:
783: --
843: --
844: -- {End Of Comments}
845: --
846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
844: -- {End Of Comments}
845: --
846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
866: DEFAULT g_otl_deposit_process,
867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
866: DEFAULT g_otl_deposit_process,
867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
868: DEFAULT NULL,
869: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
870: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
871: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
868: DEFAULT NULL,
869: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
870: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
871: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
872: );
873:
874: --
875: -- ----------------------------------------------------------------------------
933: --
934: -- {End Of Comments}
935: --
936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
934: -- {End Of Comments}
935: --
936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
956: DEFAULT g_otl_deposit_process,
957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
956: DEFAULT g_otl_deposit_process,
957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
958: DEFAULT NULL,
959: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
960: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
961: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
958: DEFAULT NULL,
959: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
960: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
961: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
962: );
963:
964: --
965: -- ----------------------------------------------------------------------------
1017: --
1018: -- {End Of Comments}
1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1018: -- {End Of Comments}
1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,
1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,
1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1029: DEFAULT g_otl_deposit_process,
1030: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1029: DEFAULT g_otl_deposit_process,
1030: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1031: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1032: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1033: );
1034:
1035: --
1036: -- ----------------------------------------------------------------------------
1088: --
1089: -- {End Of Comments}
1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1089: -- {End Of Comments}
1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,
1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,
1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1100: DEFAULT g_otl_deposit_process,
1101: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1100: DEFAULT g_otl_deposit_process,
1101: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1102: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1103: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1104: );
1105:
1106: --
1107: -- ----------------------------------------------------------------------------
1158: --
1159: -- {End Of Comments}
1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1159: -- {End Of Comments}
1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,
1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,
1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1170: DEFAULT g_otl_deposit_process,
1171: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1170: DEFAULT g_otl_deposit_process,
1171: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1172: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1173: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1174: );
1175:
1176: --
1177: -- ----------------------------------------------------------------------------
1229: --
1230: -- {End Of Comments}
1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1230: -- {End Of Comments}
1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,
1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,
1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1241: DEFAULT g_otl_deposit_process,
1242: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1241: DEFAULT g_otl_deposit_process,
1242: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1243: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1244: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1245: );
1246:
1247: --
1248: -- ----------------------------------------------------------------------------
1292: --
1293: -- {End Of Comments}
1294: --
1295: PROCEDURE create_attribute (
1296: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1297: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1298: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1299: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1300: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1358: --
1359: -- {End Of Comments}
1360: --
1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1359: -- {End Of Comments}
1360: --
1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1372: DEFAULT hr_api.g_varchar2,
1373: -- p_time_recipient_id IN NUMBER,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1372: DEFAULT hr_api.g_varchar2,
1373: -- p_time_recipient_id IN NUMBER,
1374: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1375: DEFAULT g_otl_deposit_process,
1429: --
1430: -- {End Of Comments}
1431: --
1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1430: -- {End Of Comments}
1431: --
1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1443: DEFAULT hr_api.g_varchar2,
1444: -- p_time_recipient_id IN NUMBER,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1443: DEFAULT hr_api.g_varchar2,
1444: -- p_time_recipient_id IN NUMBER,
1445: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1446: DEFAULT g_otl_deposit_process,
1615: --
1616: -- {End Of Comments}
1617: --
1618: PROCEDURE delete_detail_bb (
1619: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1620: -- p_time_recipient_id IN NUMBER,
1621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1622: DEFAULT g_otl_deposit_process,
1623: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1619: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1620: -- p_time_recipient_id IN NUMBER,
1621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1622: DEFAULT g_otl_deposit_process,
1623: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1624: DEFAULT SYSDATE,
1625: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1626: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1627: );
1673: --
1674: -- {End Of Comments}
1675: --
1676: PROCEDURE delete_detail_bb (
1677: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1678: -- p_time_recipient_id IN NUMBER,
1679: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1680: DEFAULT g_otl_deposit_process,
1681: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1677: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1678: -- p_time_recipient_id IN NUMBER,
1679: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1680: DEFAULT g_otl_deposit_process,
1681: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1682: DEFAULT SYSDATE,
1683: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1684: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1685: );
1724: --
1725: -- {End Of Comments}
1726: --
1727: PROCEDURE delete_timecard (
1728: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1729: p_mode IN VARCHAR2 DEFAULT hxc_timecard.c_delete,
1730: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1731: DEFAULT g_otl_deposit_process,
1732: p_retrieval_process IN VARCHAR2 DEFAULT NULL,
1729: p_mode IN VARCHAR2 DEFAULT hxc_timecard.c_delete,
1730: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1731: DEFAULT g_otl_deposit_process,
1732: p_retrieval_process IN VARCHAR2 DEFAULT NULL,
1733: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1734: DEFAULT SYSDATE,
1735: p_template IN VARCHAR2 DEFAULT hxc_timecard.c_no
1736: );
1737:
1806: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1807: -- hxc_self_service_time_deposit.timecard_info,
1808: p_messages OUT NOCOPY hxc_message_table_type,
1809: -- hxc_self_service_time_deposit.message_table,
1810: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1811: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1812: p_template IN VARCHAR2
1813: DEFAULT hxc_timecard.c_no,
1814: p_item_type IN wf_items.item_type%TYPE
1807: -- hxc_self_service_time_deposit.timecard_info,
1808: p_messages OUT NOCOPY hxc_message_table_type,
1809: -- hxc_self_service_time_deposit.message_table,
1810: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1811: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1812: p_template IN VARCHAR2
1813: DEFAULT hxc_timecard.c_no,
1814: p_item_type IN wf_items.item_type%TYPE
1815: DEFAULT 'HXCEMP',
1887: -- p_add_security IN BOOLEAN DEFAULT TRUE,
1888: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1889: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1890: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
1891: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1892: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1893: p_template IN VARCHAR2
1894: DEFAULT hxc_timecard.c_no,
1895: p_item_type IN wf_items.item_type%TYPE
1888: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1889: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1890: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
1891: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1892: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1893: p_template IN VARCHAR2
1894: DEFAULT hxc_timecard.c_no,
1895: p_item_type IN wf_items.item_type%TYPE
1896: DEFAULT 'HXCEMP',