eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_audit AS

1: PACKAGE BODY hxc_timecard_audit AS
2: /* $Header: hxctcaudit.pkb 120.18.12020000.4 2012/10/17 07:30:17 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 7: (p_transaction_info in hxc_timecard.transaction_info

3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Function find_overall_status
7: (p_transaction_info in hxc_timecard.transaction_info
8: ) return varchar2 is
9:
10: l_index NUMBER;
11: l_status varchar2(20);

Line 22: (l_status <> hxc_timecard.c_trans_success)

18: EXIT WHEN
19: (
20: (NOT p_transaction_info.exists(l_index))
21: OR
22: (l_status <> hxc_timecard.c_trans_success)
23: );
24:
25: l_status := p_transaction_info(l_index).status;
26:

Line 37: ,p_transaction_info in hxc_timecard.transaction_info

33: End find_overall_status;
34:
35: Procedure insert_audit_header
36: (p_overall_status in varchar2
37: ,p_transaction_info in hxc_timecard.transaction_info
38: ,p_messages in out nocopy hxc_message_table_type
39: ,p_transaction_id out nocopy hxc_transactions.transaction_id%type
40: ) is
41:

Line 98: (p_transaction_info in out nocopy hxc_timecard.transaction_info

94:
95: End insert_audit_header;
96:
97: Procedure insert_audit_details
98: (p_transaction_info in out nocopy hxc_timecard.transaction_info
99: ,p_messages in out nocopy hxc_message_table_type
100: ,p_transaction_id in hxc_transactions.transaction_id%type
101: ) is
102:

Line 158: (p_transaction_info in out nocopy hxc_timecard.transaction_info

154:
155: End insert_audit_details;
156:
157: Procedure audit_deposit
158: (p_transaction_info in out nocopy hxc_timecard.transaction_info
159: ,p_messages in out nocopy hxc_message_table_type
160: ) is
161:
162: PRAGMA AUTONOMOUS_TRANSACTION;

Line 189: l_timecard_blocks hxc_timecard.block_list;

185: Procedure maintain_latest_details
186: (p_blocks in hxc_block_table_type
187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;

Line 190: l_day_blocks hxc_timecard.block_list;

186: (p_blocks in hxc_block_table_type
187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;
194:

Line 191: l_detail_blocks hxc_timecard.block_list;

187: ) IS
188:
189: l_timecard_blocks hxc_timecard.block_list;
190: l_day_blocks hxc_timecard.block_list;
191: l_detail_blocks hxc_timecard.block_list;
192:
193: l_detail_ind PLS_INTEGER;
194:
195: l_blk_ind PLS_INTEGER;

Line 335: FROM hxc_timecard_summary sum

331: CURSOR get_row
332: IS
333: SELECT transferred_to,
334: ROWIDTOCHAR(sum.ROWID)
335: FROM hxc_timecard_summary sum
336: WHERE timecard_id = p_timecard_id;
337:
338: CURSOR get_application
339: IS SELECT time_recipient_name

Line 392: UPDATE hxc_timecard_summary

388: hr_utility.trace('l_transferred_to = '||l_transferred_to);
389: END IF;
390:
391: -- Update the table.
392: UPDATE hxc_timecard_summary
393: SET transferred_to = l_transferred_to
394: WHERE ROWID = CHARTOROWID(l_rowid);
395:
396: END update_transferred_to;

Line 455: hxc_timecard_block_utils.sort_blocks

451: if g_debug then
452: hr_utility.trace('In maintain details 1');
453: end if;
454:
455: hxc_timecard_block_utils.sort_blocks
456: (p_blocks => p_blocks
457: ,p_timecard_blocks => l_timecard_blocks
458: ,p_day_blocks => l_day_blocks
459: ,p_detail_blocks => l_detail_blocks

Line 541: hxc_timecard_block_utils.date_value(

537: p_blocks(l_blk_ind).resource_id,
538: p_blocks(l_blk_ind).time_building_block_id,
539: p_blocks(l_blk_ind).object_version_number,
540: l_status,
541: hxc_timecard_block_utils.date_value(
542: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
543: hxc_timecard_block_utils.date_value(
544: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
545: p_blocks(l_blk_ind).application_set_id,

Line 543: hxc_timecard_block_utils.date_value(

539: p_blocks(l_blk_ind).object_version_number,
540: l_status,
541: hxc_timecard_block_utils.date_value(
542: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
543: hxc_timecard_block_utils.date_value(
544: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
545: p_blocks(l_blk_ind).application_set_id,
546: sysdate,
547: p_blocks(l_blk_ind).comment_text,

Line 569: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

565: pay_business_group_id_tab(l_pay_index) := l_bg_id;
566: -- Bug 9684373
567: --pay_timecard_id_tab(l_pay_index) := l_timecard_id;
568: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
569: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
570: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
571: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
572: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
573: pay_last_update_date_tab(l_pay_index) := SYSDATE;

Line 571: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

567: --pay_timecard_id_tab(l_pay_index) := l_timecard_id;
568: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
569: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
570: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
571: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
572: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
573: pay_last_update_date_tab(l_pay_index) := SYSDATE;
574: pay_approval_status_tab(l_pay_index) := l_status;
575: pay_comment_text_tab(l_pay_index) := p_blocks(l_blk_ind).comment_text;

Line 597: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

593: pa_business_group_id_tab(l_pa_index) := l_bg_id;
594: -- Bug 9684373
595: -- pa_timecard_id_tab(l_pa_index) := l_timecard_id;
596: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
597: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
598: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
599: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
600: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
601: pa_last_update_date_tab(l_pa_index) := SYSDATE;

Line 599: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

595: -- pa_timecard_id_tab(l_pa_index) := l_timecard_id;
596: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
597: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
598: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
599: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
600: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
601: pa_last_update_date_tab(l_pa_index) := SYSDATE;
602: pa_approval_status_tab(l_pa_index) := l_status;
603: pa_comment_text_tab(l_pa_index) := p_blocks(l_blk_ind).comment_text;

Line 650: hxc_timecard_block_utils.date_value(

646: p_blocks(l_blk_ind).resource_id,
647: p_blocks(l_blk_ind).time_building_block_id,
648: p_blocks(l_blk_ind).object_version_number,
649: l_status,
650: hxc_timecard_block_utils.date_value(
651: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
652: hxc_timecard_block_utils.date_value(
653: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
654: p_blocks(l_blk_ind).application_set_id,

Line 652: hxc_timecard_block_utils.date_value(

648: p_blocks(l_blk_ind).object_version_number,
649: l_status,
650: hxc_timecard_block_utils.date_value(
651: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time),
652: hxc_timecard_block_utils.date_value(
653: p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time),
654: p_blocks(l_blk_ind).application_set_id,
655: sysdate,
656: p_blocks(l_blk_ind).comment_text,

Line 678: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

674: pay_org_id_tab(l_pay_index) := l_org_id;
675: pay_business_group_id_tab(l_pay_index) := l_bg_id;
676: -- Bug 9684373
677: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
678: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
679: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
680: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
681: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
682: pay_last_update_date_tab(l_pay_index) := SYSDATE;

Line 680: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

676: -- Bug 9684373
677: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
678: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
679: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
680: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
681: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
682: pay_last_update_date_tab(l_pay_index) := SYSDATE;
683: pay_approval_status_tab(l_pay_index) := l_status;
684: pay_comment_text_tab(l_pay_index) := p_blocks(l_blk_ind).comment_text;

Line 705: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

701: pa_org_id_tab(l_pa_index) := l_org_id;
702: pa_business_group_id_tab(l_pa_index) := l_bg_id;
703: -- Bug 9684373
704: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
705: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
706: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
707: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
708: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
709: pa_last_update_date_tab(l_pa_index) := SYSDATE;

Line 707: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

703: -- Bug 9684373
704: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
705: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
706: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
707: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
708: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
709: pa_last_update_date_tab(l_pa_index) := SYSDATE;
710: pa_approval_status_tab(l_pa_index) := l_status;
711: pa_comment_text_tab(l_pa_index) := p_blocks(l_blk_ind).comment_text;

Line 733: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

729: pay_org_id_tab(l_pay_index) := l_org_id;
730: pay_business_group_id_tab(l_pay_index) := l_bg_id;
731: -- Bug 9684373
732: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
733: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
734: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
735: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
736: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
737: pay_last_update_date_tab(l_pay_index) := SYSDATE;

Line 735: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value

731: -- Bug 9684373
732: pay_timecard_id_tab(l_pay_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
733: pay_start_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
734: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
735: pay_stop_time_tab(l_pay_index) := hxc_timecard_block_utils.date_value
736: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
737: pay_last_update_date_tab(l_pay_index) := SYSDATE;
738: pay_approval_status_tab(l_pay_index) := l_status;
739: pay_comment_text_tab(l_pay_index) := p_blocks(l_blk_ind).comment_text;

Line 760: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

756: pa_org_id_tab(l_pa_index) := l_org_id;
757: pa_business_group_id_tab(l_pa_index) := l_bg_id;
758: -- Bug 9684373
759: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
760: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
761: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
762: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
763: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
764: pa_last_update_date_tab(l_pa_index) := SYSDATE;

Line 762: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value

758: -- Bug 9684373
759: pa_timecard_id_tab(l_pa_index) := l_day_scope(p_blocks(l_blk_ind).parent_building_block_id);
760: pa_start_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
761: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).start_time);
762: pa_stop_time_tab(l_pa_index) := hxc_timecard_block_utils.date_value
763: (p_blocks(l_day_blocks(p_blocks(l_blk_ind).parent_building_block_id)).stop_time);
764: pa_last_update_date_tab(l_pa_index) := SYSDATE;
765: pa_approval_status_tab(l_pa_index) := l_status;
766: pa_comment_text_tab(l_pa_index) := p_blocks(l_blk_ind).comment_text;

Line 1644: End hxc_timecard_audit;

1640: end if;
1641:
1642: END maintain_rdb_snapshot;
1643:
1644: End hxc_timecard_audit;