DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 15: c_hours_uom CONSTANT hxc_time_building_blocks.unit_of_measure%TYPE

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';

Line 71: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 123: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 211: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 212: p_type IN hxc_time_building_blocks.TYPE%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,

Line 213: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 215: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%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

Line 217: p_start_time IN hxc_time_building_blocks.start_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

Line 219: p_stop_time IN hxc_time_building_blocks.stop_time%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,

Line 221: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

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

Line 224: p_scope IN hxc_time_building_blocks.SCOPE%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,

Line 225: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

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,

Line 227: p_approval_status IN hxc_time_building_blocks.approval_status%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,

Line 229: p_resource_id IN hxc_time_building_blocks.resource_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,

Line 230: p_resource_type IN hxc_time_building_blocks.resource_type%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,
234: p_date_to IN hxc_time_building_blocks.date_to%TYPE

Line 231: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%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,

Line 232: p_date_from IN hxc_time_building_blocks.date_from%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,
236: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 234: p_date_to IN hxc_time_building_blocks.date_to%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

Line 236: p_comment_text IN hxc_time_building_blocks.comment_text%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',

Line 238: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

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

Line 323: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%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

Line 324: p_type IN hxc_time_building_blocks.TYPE%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,

Line 325: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 327: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%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

Line 329: p_start_time IN hxc_time_building_blocks.start_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

Line 331: p_stop_time IN hxc_time_building_blocks.stop_time%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,

Line 333: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

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

Line 336: p_scope IN hxc_time_building_blocks.SCOPE%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,

Line 337: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

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,

Line 339: p_approval_status IN hxc_time_building_blocks.approval_status%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,

Line 341: p_resource_id IN hxc_time_building_blocks.resource_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,

Line 342: p_resource_type IN hxc_time_building_blocks.resource_type%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,
346: p_date_to IN hxc_time_building_blocks.date_to%TYPE

Line 343: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%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,

Line 344: p_date_from IN hxc_time_building_blocks.date_from%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,
348: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 346: p_date_to IN hxc_time_building_blocks.date_to%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

Line 348: p_comment_text IN hxc_time_building_blocks.comment_text%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',

Line 350: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

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

Line 411: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

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.

Line 412: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

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

Line 413: -- p_approval_status IN hxc_time_building_blocks.approval_status%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,

Line 414: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

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.

Line 416: p_resource_type IN hxc_time_building_blocks.resource_type%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.
419: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
420: DEFAULT NULL,

Line 419: p_approval_style_id IN hxc_time_building_blocks.approval_style_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,
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,

Line 421: p_comment_text IN hxc_time_building_blocks.comment_text%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: );

Line 424: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_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: );
426:
427: --
428: -- ----------------------------------------------------------------------------

Line 480: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

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.

Line 481: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

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

Line 482: -- p_approval_status IN hxc_time_building_blocks.approval_status%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,

Line 483: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

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.

Line 485: p_resource_type IN hxc_time_building_blocks.resource_type%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.
488: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
489: DEFAULT NULL,

Line 488: p_approval_style_id IN hxc_time_building_blocks.approval_style_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,
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,

Line 490: p_comment_text IN hxc_time_building_blocks.comment_text%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,
493: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
494: );

Line 493: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_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: );
495:
496: --
497: -- ----------------------------------------------------------------------------

Line 548: p_day IN hxc_time_building_blocks.start_time%TYPE,

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

Line 549: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 550: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 552: p_comment_text IN hxc_time_building_blocks.comment_text%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

Line 554: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%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,

Line 559: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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: -- ----------------------------------------------------------------------------

Line 613: p_day IN hxc_time_building_blocks.start_time%TYPE,

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

Line 614: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 615: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 617: p_comment_text IN hxc_time_building_blocks.comment_text%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

Line 619: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%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,

Line 624: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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,
624: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
625: );
626:
627: --
628: -- ----------------------------------------------------------------------------

Line 680: p_day IN hxc_time_building_blocks.start_time%TYPE,

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,

Line 681: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

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

Line 683: p_comment_text IN hxc_time_building_blocks.comment_text%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

Line 685: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%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,

Line 690: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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: -- ----------------------------------------------------------------------------

Line 746: p_day IN hxc_time_building_blocks.start_time%TYPE,

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,

Line 747: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

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

Line 749: p_comment_text IN hxc_time_building_blocks.comment_text%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

Line 751: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%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,

Line 756: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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,
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,

Line 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,

Line 761: p_resource_type IN hxc_time_building_blocks.resource_type%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,
765: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 762: p_day IN hxc_time_building_blocks.start_time%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,

Line 767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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,
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,

Line 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,

Line 772: p_resource_type IN hxc_time_building_blocks.resource_type%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,
776: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 773: p_day IN hxc_time_building_blocks.start_time%TYPE,

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,

Line 778: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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,
778: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
779: ); */
780:
781:
782: --

Line 846: p_type IN hxc_time_building_blocks.TYPE%TYPE,

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,

Line 847: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 849: p_start_time IN hxc_time_building_blocks.start_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,

Line 851: p_stop_time IN hxc_time_building_blocks.stop_time%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.

Line 853: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

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,

Line 856: -- p_approval_status IN hxc_time_building_blocks.approval_status%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

Line 857: -- p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 858: -- p_resource_type IN hxc_time_building_blocks.resource_type%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,
862: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 859: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%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,

Line 860: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

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

Line 862: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%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

Line 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

Line 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: -- ----------------------------------------------------------------------------

Line 936: p_type IN hxc_time_building_blocks.TYPE%TYPE,

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,

Line 937: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 939: p_start_time IN hxc_time_building_blocks.start_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,

Line 941: p_stop_time IN hxc_time_building_blocks.stop_time%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.

Line 943: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

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,

Line 946: -- p_approval_status IN hxc_time_building_blocks.approval_status%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

Line 947: -- p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 948: -- p_resource_type IN hxc_time_building_blocks.resource_type%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,
952: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 949: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%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,

Line 950: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

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

Line 952: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%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

Line 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

Line 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: -- ----------------------------------------------------------------------------

Line 1020: p_measure IN hxc_time_building_blocks.measure%TYPE,

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,

Line 1021: p_day IN hxc_time_building_blocks.start_time%TYPE,

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

Line 1022: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 1023: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 1025: p_comment_text IN hxc_time_building_blocks.comment_text%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,

Line 1031: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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: -- ----------------------------------------------------------------------------

Line 1091: p_measure IN hxc_time_building_blocks.measure%TYPE,

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,

Line 1092: p_day IN hxc_time_building_blocks.start_time%TYPE,

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

Line 1093: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 1094: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 1096: p_comment_text IN hxc_time_building_blocks.comment_text%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,

Line 1102: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 1161: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

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,

Line 1162: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

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

Line 1163: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 1164: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 1166: p_comment_text IN hxc_time_building_blocks.comment_text%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,

Line 1172: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%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: -- ----------------------------------------------------------------------------

Line 1232: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

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,

Line 1233: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

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

Line 1234: p_resource_id IN hxc_time_building_blocks.resource_id%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,

Line 1235: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

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

Line 1237: p_comment_text IN hxc_time_building_blocks.comment_text%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,

Line 1243: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 1295: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 1361: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%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,

Line 1362: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 1364: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%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

Line 1366: p_start_time IN hxc_time_building_blocks.start_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

Line 1368: p_stop_time IN hxc_time_building_blocks.stop_time%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,

Line 1370: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

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,

Line 1432: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 1433: p_measure IN hxc_time_building_blocks.measure%TYPE

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

Line 1435: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%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

Line 1437: p_start_time IN hxc_time_building_blocks.start_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

Line 1439: p_stop_time IN hxc_time_building_blocks.stop_time%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,

Line 1441: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

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,

Line 1618: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 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: );

Line 1676: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 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: );

Line 1727: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 1732: p_effective_date IN hxc_time_building_blocks.stop_time%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,
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:

Line 1809: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 1810: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%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',

Line 1890: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

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

Line 1891: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%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',