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