DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 16: c_hours_uom CONSTANT hxc_time_building_blocks.unit_of_measure%TYPE

12: g_validate BOOLEAN;
13:
14: SUBTYPE mode_varchar2 IS VARCHAR2 (15);
15:
16: c_hours_uom CONSTANT hxc_time_building_blocks.unit_of_measure%TYPE
17: := 'HOURS';
18: c_migration CONSTANT mode_varchar2 := 'MIGRATION';
19: c_tk_save CONSTANT mode_varchar2 := 'FORCE_SAVE';
20: c_tk_submit CONSTANT mode_varchar2 := 'FORCE_SUBMIT';

Line 72: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

68: --
69: -- {End Of Comments}
70: --
71: PROCEDURE get_timecard_tables (
72: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
73: -- p_time_recipient_id IN NUMBER,
74: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
75: DEFAULT g_otl_deposit_process,
76: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,

Line 124: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

120: --
121: -- {End Of Comments}
122: --
123: PROCEDURE get_timecard_tables (
124: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
125: -- p_time_recipient_id IN NUMBER,
126: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
127: DEFAULT g_otl_deposit_process,
128: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,

Line 212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

208: --
209: -- {End Of Comments}
210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

Line 213: p_type IN hxc_time_building_blocks.TYPE%TYPE,

209: -- {End Of Comments}
210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,

Line 214: p_measure IN hxc_time_building_blocks.measure%TYPE

210: --
211: PROCEDURE create_bb (
212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE

Line 216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

212: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
213: p_type IN hxc_time_building_blocks.TYPE%TYPE,
214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 218: p_start_time IN hxc_time_building_blocks.start_time%TYPE

214: p_measure IN hxc_time_building_blocks.measure%TYPE
215: DEFAULT NULL,
216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

Line 220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

216: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
217: DEFAULT c_hours_uom,
218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,

Line 222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

218: p_start_time IN hxc_time_building_blocks.start_time%TYPE
219: DEFAULT NULL,
220: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

Line 225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

221: DEFAULT NULL,
222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,

Line 226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

222: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
223: DEFAULT NULL,
224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE

224: p_parent_is_new IN VARCHAR2,
225: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

Line 230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

226: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,

Line 231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

227: DEFAULT 1,
228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE

Line 232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

228: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,

Line 233: p_date_from IN hxc_time_building_blocks.date_from%TYPE

229: DEFAULT NULL,
230: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 235: p_date_to IN hxc_time_building_blocks.date_to%TYPE

231: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
232: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

233: p_date_from IN hxc_time_building_blocks.date_from%TYPE
234: DEFAULT SYSDATE,
235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
240: DEFAULT NULL,
241: p_new IN VARCHAR2 DEFAULT 'Y',

Line 239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

235: p_date_to IN hxc_time_building_blocks.date_to%TYPE
236: DEFAULT hr_general.end_of_time,
237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
238: DEFAULT NULL,
239: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
240: DEFAULT NULL,
241: p_new IN VARCHAR2 DEFAULT 'Y',
242: p_changed IN VARCHAR2 DEFAULT '',
243: p_app_blocks IN OUT NOCOPY hxc_block_table_type

Line 324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

320: --
321: -- {End Of Comments}
322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

Line 325: p_type IN hxc_time_building_blocks.TYPE%TYPE,

321: -- {End Of Comments}
322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,

Line 326: p_measure IN hxc_time_building_blocks.measure%TYPE

322: --
323: PROCEDURE create_bb (
324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE

Line 328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

324: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
325: p_type IN hxc_time_building_blocks.TYPE%TYPE,
326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 330: p_start_time IN hxc_time_building_blocks.start_time%TYPE

326: p_measure IN hxc_time_building_blocks.measure%TYPE
327: DEFAULT NULL,
328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

Line 332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

328: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
329: DEFAULT c_hours_uom,
330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,

Line 334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

330: p_start_time IN hxc_time_building_blocks.start_time%TYPE
331: DEFAULT NULL,
332: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

Line 337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

333: DEFAULT NULL,
334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,

Line 338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE

334: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
335: DEFAULT NULL,
336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE

336: p_parent_is_new IN VARCHAR2,
337: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

Line 342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

338: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE
339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,

Line 343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

339: DEFAULT 1,
340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE

Line 344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

340: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE
341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,

Line 345: p_date_from IN hxc_time_building_blocks.date_from%TYPE

341: DEFAULT NULL,
342: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 347: p_date_to IN hxc_time_building_blocks.date_to%TYPE

343: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
344: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

345: p_date_from IN hxc_time_building_blocks.date_from%TYPE
346: DEFAULT SYSDATE,
347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
352: DEFAULT NULL,
353: p_new IN VARCHAR2 DEFAULT 'Y',

Line 351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

347: p_date_to IN hxc_time_building_blocks.date_to%TYPE
348: DEFAULT hr_general.end_of_time,
349: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
350: DEFAULT NULL,
351: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
352: DEFAULT NULL,
353: p_new IN VARCHAR2 DEFAULT 'Y',
354: p_changed IN VARCHAR2 DEFAULT '',
355: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info

Line 412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

408: --
409: -- {End Of Comments}
410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.

Line 413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

409: -- {End Of Comments}
410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

Line 414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

410: --
411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,

Line 415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

411: PROCEDURE create_timecard_bb (
412: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.

Line 417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

413: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
414: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
415: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,

Line 420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE

416: -- default to person because there is no other resource type at the moment.
417: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

418: DEFAULT hxc_timecard.c_person_resource,
419: -- We cannot use approval_style_name because that is not unique.
420: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
425: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
426: );

Line 425: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

421: DEFAULT NULL,
422: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
423: DEFAULT NULL,
424: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
425: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
426: );
427:
428: --
429: -- ----------------------------------------------------------------------------

Line 481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

477: --
478: -- {End Of Comments}
479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.

Line 482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

478: -- {End Of Comments}
479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

Line 483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

479: --
480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,

Line 484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

480: PROCEDURE create_timecard_bb (
481: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.

Line 486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

482: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
483: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
484: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,

Line 489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE

485: -- default to person because there is no other resource type at the moment.
486: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

487: DEFAULT hxc_timecard.c_person_resource,
488: -- We cannot use approval_style_name because that is not unique.
489: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE
490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
494: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
495: );

Line 494: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

490: DEFAULT NULL,
491: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
492: DEFAULT NULL,
493: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
494: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
495: );
496:
497: --
498: -- ----------------------------------------------------------------------------

Line 549: p_day IN hxc_time_building_blocks.start_time%TYPE,

545: --
546: -- {End Of Comments}
547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

546: -- {End Of Comments}
547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,

Line 551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

547: --
548: PROCEDURE create_day_bb (
549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

549: p_day IN hxc_time_building_blocks.start_time%TYPE,
550: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE

551: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
552: DEFAULT hxc_timecard.c_person_resource,
553: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
554: DEFAULT NULL,
555: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
558: DEFAULT g_otl_deposit_process,
559: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 560: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

556: -- DEFAULT 1,
557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
558: DEFAULT g_otl_deposit_process,
559: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
560: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
561: );
562:
563: --
564: -- ----------------------------------------------------------------------------

Line 614: p_day IN hxc_time_building_blocks.start_time%TYPE,

610: --
611: -- {End Of Comments}
612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

611: -- {End Of Comments}
612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,

Line 616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

612: --
613: PROCEDURE create_day_bb (
614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

614: p_day IN hxc_time_building_blocks.start_time%TYPE,
615: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE

616: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
617: DEFAULT hxc_timecard.c_person_resource,
618: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
619: DEFAULT NULL,
620: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
623: DEFAULT g_otl_deposit_process,
624: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 625: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

621: -- DEFAULT 1,
622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
623: DEFAULT g_otl_deposit_process,
624: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
625: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
626: );
627:
628: --
629: -- ----------------------------------------------------------------------------

Line 681: p_day IN hxc_time_building_blocks.start_time%TYPE,

677: --
678: -- {End Of Comments}
679: --
680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,

Line 682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

678: -- {End Of Comments}
679: --
680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

680: PROCEDURE create_day_bb (
681: p_day IN hxc_time_building_blocks.start_time%TYPE,
682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

682: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
683: DEFAULT NULL,
684: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
685: DEFAULT NULL,
686: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
689: DEFAULT g_otl_deposit_process,
690: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 691: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

687: DEFAULT 1,
688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
689: DEFAULT g_otl_deposit_process,
690: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
691: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
692: );
693:
694: --
695: -- ----------------------------------------------------------------------------

Line 747: p_day IN hxc_time_building_blocks.start_time%TYPE,

743: --
744: -- {End Of Comments}
745: --
746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,

Line 748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE

744: -- {End Of Comments}
745: --
746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

746: PROCEDURE create_day_bb (
747: p_day IN hxc_time_building_blocks.start_time%TYPE,
748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

748: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE
749: DEFAULT NULL,
750: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
751: DEFAULT NULL,
752: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
755: DEFAULT g_otl_deposit_process,
756: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 757: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

753: DEFAULT 1,
754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
755: DEFAULT g_otl_deposit_process,
756: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
757: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

757: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,

Line 762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

758: );
759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 763: p_day IN hxc_time_building_blocks.start_time%TYPE,

759:
760: /* PROCEDURE auto_create_timecard (
761: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
762: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
763: p_day IN hxc_time_building_blocks.start_time%TYPE,
764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
767: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 768: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
765: DEFAULT g_otl_deposit_process,
766: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
767: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
768: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

768: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,

Line 773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

769: );
770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 774: p_day IN hxc_time_building_blocks.start_time%TYPE,

770:
771: PROCEDURE auto_create_timecard (
772: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
773: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
774: p_day IN hxc_time_building_blocks.start_time%TYPE,
775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
778: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 779: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
776: DEFAULT g_otl_deposit_process,
777: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
778: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
779: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
780: ); */
781:
782:
783: --

Line 847: p_type IN hxc_time_building_blocks.TYPE%TYPE,

843: --
844: -- {End Of Comments}
845: --
846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,

Line 848: p_measure IN hxc_time_building_blocks.measure%TYPE

844: -- {End Of Comments}
845: --
846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 850: p_start_time IN hxc_time_building_blocks.start_time%TYPE

846: PROCEDURE create_detail_bb (
847: p_type IN hxc_time_building_blocks.TYPE%TYPE,
848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

848: p_measure IN hxc_time_building_blocks.measure%TYPE
849: DEFAULT NULL,
850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.

Line 854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

850: p_start_time IN hxc_time_building_blocks.start_time%TYPE
851: DEFAULT NULL,
852: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

853: DEFAULT NULL,
854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

854: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,

Line 859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

855: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

856: -- the user cannot manipulate this.
857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,

Line 861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

857: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
858: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

859: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
860: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
861: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
862: DEFAULT NULL,
863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
866: DEFAULT g_otl_deposit_process,
867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

Line 867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

863: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
864: DEFAULT 1,
865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
866: DEFAULT g_otl_deposit_process,
867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
868: DEFAULT NULL,
869: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
870: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
871: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 871: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

867: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
868: DEFAULT NULL,
869: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
870: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
871: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
872: );
873:
874: --
875: -- ----------------------------------------------------------------------------

Line 937: p_type IN hxc_time_building_blocks.TYPE%TYPE,

933: --
934: -- {End Of Comments}
935: --
936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,

Line 938: p_measure IN hxc_time_building_blocks.measure%TYPE

934: -- {End Of Comments}
935: --
936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 940: p_start_time IN hxc_time_building_blocks.start_time%TYPE

936: PROCEDURE create_detail_bb (
937: p_type IN hxc_time_building_blocks.TYPE%TYPE,
938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

938: p_measure IN hxc_time_building_blocks.measure%TYPE
939: DEFAULT NULL,
940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.

Line 944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

940: p_start_time IN hxc_time_building_blocks.start_time%TYPE
941: DEFAULT NULL,
942: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

943: DEFAULT NULL,
944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

944: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,

Line 949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

945: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

Line 950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

946: -- the user cannot manipulate this.
947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,

Line 951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

947: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
948: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE

949: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
950: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
951: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
952: DEFAULT NULL,
953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
956: DEFAULT g_otl_deposit_process,
957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

Line 957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

953: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
954: DEFAULT 1,
955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
956: DEFAULT g_otl_deposit_process,
957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
958: DEFAULT NULL,
959: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
960: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
961: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 961: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

957: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
958: DEFAULT NULL,
959: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
960: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
961: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
962: );
963:
964: --
965: -- ----------------------------------------------------------------------------

Line 1021: p_measure IN hxc_time_building_blocks.measure%TYPE,

1017: --
1018: -- {End Of Comments}
1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,

Line 1022: p_day IN hxc_time_building_blocks.start_time%TYPE,

1018: -- {End Of Comments}
1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1019: --
1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,

Line 1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

1020: PROCEDURE create_time_entry (
1021: p_measure IN hxc_time_building_blocks.measure%TYPE,
1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,
1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1022: p_day IN hxc_time_building_blocks.start_time%TYPE,
1023: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1024: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1025: DEFAULT hxc_timecard.c_person_resource,
1026: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1027: DEFAULT NULL,
1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1029: DEFAULT g_otl_deposit_process,
1030: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1032: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1029: DEFAULT g_otl_deposit_process,
1030: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1031: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1032: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1033: );
1034:
1035: --
1036: -- ----------------------------------------------------------------------------

Line 1092: p_measure IN hxc_time_building_blocks.measure%TYPE,

1088: --
1089: -- {End Of Comments}
1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,

Line 1093: p_day IN hxc_time_building_blocks.start_time%TYPE,

1089: -- {End Of Comments}
1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1090: --
1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,

Line 1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

1091: PROCEDURE create_time_entry (
1092: p_measure IN hxc_time_building_blocks.measure%TYPE,
1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,
1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1093: p_day IN hxc_time_building_blocks.start_time%TYPE,
1094: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1095: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1096: DEFAULT hxc_timecard.c_person_resource,
1097: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1098: DEFAULT NULL,
1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1100: DEFAULT g_otl_deposit_process,
1101: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1103: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1100: DEFAULT g_otl_deposit_process,
1101: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1102: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1103: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1104: );
1105:
1106: --
1107: -- ----------------------------------------------------------------------------

Line 1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1158: --
1159: -- {End Of Comments}
1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,

Line 1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

1159: -- {End Of Comments}
1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1160: --
1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,

Line 1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

1161: PROCEDURE create_time_entry (
1162: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,
1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1163: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1164: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1165: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1166: DEFAULT hxc_timecard.c_person_resource,
1167: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1168: DEFAULT NULL,
1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1170: DEFAULT g_otl_deposit_process,
1171: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1173: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1170: DEFAULT g_otl_deposit_process,
1171: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1172: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1173: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1174: );
1175:
1176: --
1177: -- ----------------------------------------------------------------------------

Line 1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1229: --
1230: -- {End Of Comments}
1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,

Line 1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

1230: -- {End Of Comments}
1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1231: --
1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,

Line 1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE

1232: PROCEDURE create_time_entry (
1233: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,
1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1234: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1235: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1236: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1237: DEFAULT hxc_timecard.c_person_resource,
1238: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1239: DEFAULT NULL,
1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1241: DEFAULT g_otl_deposit_process,
1242: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1244: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1241: DEFAULT g_otl_deposit_process,
1242: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1243: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1244: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1245: );
1246:
1247: --
1248: -- ----------------------------------------------------------------------------

Line 1296: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1292: --
1293: -- {End Of Comments}
1294: --
1295: PROCEDURE create_attribute (
1296: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1297: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1298: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1299: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1300: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

Line 1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1358: --
1359: -- {End Of Comments}
1360: --
1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,

Line 1363: p_measure IN hxc_time_building_blocks.measure%TYPE

1359: -- {End Of Comments}
1360: --
1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE

Line 1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

1361: PROCEDURE update_building_block (
1362: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE

1363: p_measure IN hxc_time_building_blocks.measure%TYPE
1364: DEFAULT hr_api.g_number,
1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

1365: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1366: DEFAULT hr_api.g_varchar2,
1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1372: DEFAULT hr_api.g_varchar2,
1373: -- p_time_recipient_id IN NUMBER,

Line 1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1367: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1368: DEFAULT hr_api.g_date,
1369: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1370: DEFAULT hr_api.g_date,
1371: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1372: DEFAULT hr_api.g_varchar2,
1373: -- p_time_recipient_id IN NUMBER,
1374: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1375: DEFAULT g_otl_deposit_process,

Line 1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1429: --
1430: -- {End Of Comments}
1431: --
1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,

Line 1434: p_measure IN hxc_time_building_blocks.measure%TYPE

1430: -- {End Of Comments}
1431: --
1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE

Line 1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE

1432: PROCEDURE update_building_block (
1433: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE

1434: p_measure IN hxc_time_building_blocks.measure%TYPE
1435: DEFAULT hr_api.g_number,
1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

Line 1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

1436: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
1437: DEFAULT hr_api.g_varchar2,
1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1443: DEFAULT hr_api.g_varchar2,
1444: -- p_time_recipient_id IN NUMBER,

Line 1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE

1438: p_start_time IN hxc_time_building_blocks.start_time%TYPE
1439: DEFAULT hr_api.g_date,
1440: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1441: DEFAULT hr_api.g_date,
1442: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1443: DEFAULT hr_api.g_varchar2,
1444: -- p_time_recipient_id IN NUMBER,
1445: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1446: DEFAULT g_otl_deposit_process,

Line 1619: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1615: --
1616: -- {End Of Comments}
1617: --
1618: PROCEDURE delete_detail_bb (
1619: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1620: -- p_time_recipient_id IN NUMBER,
1621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1622: DEFAULT g_otl_deposit_process,
1623: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE

Line 1623: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE

1619: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1620: -- p_time_recipient_id IN NUMBER,
1621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1622: DEFAULT g_otl_deposit_process,
1623: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1624: DEFAULT SYSDATE,
1625: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1626: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1627: );

Line 1677: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1673: --
1674: -- {End Of Comments}
1675: --
1676: PROCEDURE delete_detail_bb (
1677: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1678: -- p_time_recipient_id IN NUMBER,
1679: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1680: DEFAULT g_otl_deposit_process,
1681: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE

Line 1681: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE

1677: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1678: -- p_time_recipient_id IN NUMBER,
1679: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1680: DEFAULT g_otl_deposit_process,
1681: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1682: DEFAULT SYSDATE,
1683: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1684: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1685: );

Line 1728: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1724: --
1725: -- {End Of Comments}
1726: --
1727: PROCEDURE delete_timecard (
1728: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1729: p_mode IN VARCHAR2 DEFAULT hxc_timecard.c_delete,
1730: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1731: DEFAULT g_otl_deposit_process,
1732: p_retrieval_process IN VARCHAR2 DEFAULT NULL,

Line 1733: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE

1729: p_mode IN VARCHAR2 DEFAULT hxc_timecard.c_delete,
1730: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1731: DEFAULT g_otl_deposit_process,
1732: p_retrieval_process IN VARCHAR2 DEFAULT NULL,
1733: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1734: DEFAULT SYSDATE,
1735: p_template IN VARCHAR2 DEFAULT hxc_timecard.c_no
1736: );
1737:

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

1806: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1807: -- hxc_self_service_time_deposit.timecard_info,
1808: p_messages OUT NOCOPY hxc_message_table_type,
1809: -- hxc_self_service_time_deposit.message_table,
1810: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1811: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1812: p_template IN VARCHAR2
1813: DEFAULT hxc_timecard.c_no,
1814: p_item_type IN wf_items.item_type%TYPE

Line 1811: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

1807: -- hxc_self_service_time_deposit.timecard_info,
1808: p_messages OUT NOCOPY hxc_message_table_type,
1809: -- hxc_self_service_time_deposit.message_table,
1810: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1811: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1812: p_template IN VARCHAR2
1813: DEFAULT hxc_timecard.c_no,
1814: p_item_type IN wf_items.item_type%TYPE
1815: DEFAULT 'HXCEMP',

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

1887: -- p_add_security IN BOOLEAN DEFAULT TRUE,
1888: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1889: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1890: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
1891: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1892: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1893: p_template IN VARCHAR2
1894: DEFAULT hxc_timecard.c_no,
1895: p_item_type IN wf_items.item_type%TYPE

Line 1892: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

1888: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1889: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1890: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
1891: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
1892: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
1893: p_template IN VARCHAR2
1894: DEFAULT hxc_timecard.c_no,
1895: p_item_type IN wf_items.item_type%TYPE
1896: DEFAULT 'HXCEMP',