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.

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 50: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

46: ----------------------------------------------------------------------------
47: -- Timekeeper Audit Workflow Notification
48: ----------------------------------------------------------------------------
49: Function begin_audit_process
50: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
51: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
52: ,p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type
54: ,p_tk_audit_enabled in VARCHAR2

Line 51: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

47: -- Timekeeper Audit Workflow Notification
48: ----------------------------------------------------------------------------
49: Function begin_audit_process
50: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
51: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
52: ,p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type
54: ,p_tk_audit_enabled in VARCHAR2
55: ,p_tk_notify_to in VARCHAR2

Line 52: ,p_resource_id in hxc_time_building_blocks.resource_id%type

48: ----------------------------------------------------------------------------
49: Function begin_audit_process
50: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
51: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
52: ,p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type
54: ,p_tk_audit_enabled in VARCHAR2
55: ,p_tk_notify_to in VARCHAR2
56: ,p_tk_notify_type in VARCHAR2

Line 53: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type

49: Function begin_audit_process
50: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
51: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
52: ,p_resource_id in hxc_time_building_blocks.resource_id%type
53: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type
54: ,p_tk_audit_enabled in VARCHAR2
55: ,p_tk_notify_to in VARCHAR2
56: ,p_tk_notify_type in VARCHAR2
57: ,p_property_table hxc_timecard_prop_table_type

Line 123: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;

119: l_period_end_date date;
120:
121: l_timeouts NUMBER ;
122:
123: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
124: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
125: l_error_id NUMBER;
126: l_ovn NUMBER;
127: l_approver_type VARCHAR2(30);

Line 124: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;

120:
121: l_timeouts NUMBER ;
122:
123: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
124: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
125: l_error_id NUMBER;
126: l_ovn NUMBER;
127: l_approver_type VARCHAR2(30);
128: l_message_name VARCHAR2(250);

Line 215: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

211: return varchar2
212: is
213:
214: cursor c_updated_by
215: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
216: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
217: ) is
218: select u.user_name
219: from fnd_user u, hxc_time_building_blocks tbb

Line 216: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

212: is
213:
214: cursor c_updated_by
215: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
216: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
217: ) is
218: select u.user_name
219: from fnd_user u, hxc_time_building_blocks tbb
220: where tbb.time_building_block_id = p_tc_id

Line 219: from fnd_user u, hxc_time_building_blocks tbb

215: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
216: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
217: ) is
218: select u.user_name
219: from fnd_user u, hxc_time_building_blocks tbb
220: where tbb.time_building_block_id = p_tc_id
221: and tbb.object_version_number = p_tc_ovn
222: and tbb.last_updated_by = u.user_id;
223:

Line 633: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

629: IS
630:
631:
632: CURSOR c_tc_info(
633: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
634: ,p_tc_ovn hxc_time_building_blocks.object_version_number%TYPE
635: )
636: IS
637: SELECT tcsum.resource_id,

Line 634: ,p_tc_ovn hxc_time_building_blocks.object_version_number%TYPE

630:
631:
632: CURSOR c_tc_info(
633: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
634: ,p_tc_ovn hxc_time_building_blocks.object_version_number%TYPE
635: )
636: IS
637: SELECT tcsum.resource_id,
638: tcsum.start_time,

Line 640: FROM hxc_time_building_blocks tcsum

636: IS
637: SELECT tcsum.resource_id,
638: tcsum.start_time,
639: tcsum.stop_time
640: FROM hxc_time_building_blocks tcsum
641: WHERE tcsum.time_building_block_id = p_tc_bbid
642: AND tcsum.object_version_number = p_tc_ovn ;
643:
644:

Line 646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

642: AND tcsum.object_version_number = p_tc_ovn ;
643:
644:
645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';
646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);

Line 647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

643:
644:
645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';
646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);
651: l_ntf_to VARCHAR2(150);

Line 648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

644:
645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';
646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);
651: l_ntf_to VARCHAR2(150);
652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;

Line 649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';
646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);
651: l_ntf_to VARCHAR2(150);
652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;
653: l_child_item_key wf_items.item_key%type;

Line 652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;

648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);
651: l_ntf_to VARCHAR2(150);
652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;
653: l_child_item_key wf_items.item_key%type;
654: l_process_name varchar2(150);
655: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
656:

Line 655: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

651: l_ntf_to VARCHAR2(150);
652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;
653: l_child_item_key wf_items.item_key%type;
654: l_process_name varchar2(150);
655: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
656:
657: BEGIN
658:
659: l_tc_bb_id := wf_engine.GetItemAttrNumber(

Line 802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

798: p_funcmode in varchar2,
799: p_result in out nocopy varchar2)
800: IS
801:
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_login fnd_user.user_name%type;
804: l_fyi_login fnd_user.user_name%type;
805: l_start_date DATE;
806: l_stop_date DATE;

Line 807: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

803: l_login fnd_user.user_name%type;
804: l_fyi_login fnd_user.user_name%type;
805: l_start_date DATE;
806: l_stop_date DATE;
807: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
808: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
809: l_ntf_type VARCHAR2(150);
810: l_proc varchar2(61);
811: l_title VARCHAR2(2000);

Line 808: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

804: l_fyi_login fnd_user.user_name%type;
805: l_start_date DATE;
806: l_stop_date DATE;
807: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
808: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
809: l_ntf_type VARCHAR2(150);
810: l_proc varchar2(61);
811: l_title VARCHAR2(2000);
812: l_otl_appr_id VARCHAR2(2000);

Line 813: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;

809: l_ntf_type VARCHAR2(150);
810: l_proc varchar2(61);
811: l_title VARCHAR2(2000);
812: l_otl_appr_id VARCHAR2(2000);
813: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;
814: l_tc_url varchar2(1000);
815: BEGIN
816:
817: g_debug := hr_utility.debug_enabled;

Line 991: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

987: p_result in out nocopy varchar2)
988: IS
989:
990: cursor c_updated_by
991: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
992: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
993: ) is
994: select u.user_name
995: from fnd_user u, hxc_time_building_blocks tbb

Line 992: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

988: IS
989:
990: cursor c_updated_by
991: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
992: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
993: ) is
994: select u.user_name
995: from fnd_user u, hxc_time_building_blocks tbb
996: where tbb.time_building_block_id = p_tc_id

Line 995: from fnd_user u, hxc_time_building_blocks tbb

991: (p_tc_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
992: ,p_tc_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
993: ) is
994: select u.user_name
995: from fnd_user u, hxc_time_building_blocks tbb
996: where tbb.time_building_block_id = p_tc_id
997: and tbb.object_version_number = p_tc_ovn
998: and tbb.last_updated_by = u.user_id;
999:

Line 1000: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

996: where tbb.time_building_block_id = p_tc_id
997: and tbb.object_version_number = p_tc_ovn
998: and tbb.last_updated_by = u.user_id;
999:
1000: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1001: l_login fnd_user.user_name%type;
1002: l_start_date DATE;
1003: l_stop_date DATE;
1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;

Line 1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;

1000: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1001: l_login fnd_user.user_name%type;
1002: l_start_date DATE;
1003: l_stop_date DATE;
1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;
1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1006: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1007: l_ntf_type VARCHAR2(150);
1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';

Line 1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

1001: l_login fnd_user.user_name%type;
1002: l_start_date DATE;
1003: l_stop_date DATE;
1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;
1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1006: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1007: l_ntf_type VARCHAR2(150);
1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';
1009: l_title VARCHAR2(2000);

Line 1006: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

1002: l_start_date DATE;
1003: l_stop_date DATE;
1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;
1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1006: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1007: l_ntf_type VARCHAR2(150);
1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';
1009: l_title VARCHAR2(2000);
1010: l_otl_appr_id VARCHAR2(2000);

Line 1011: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;

1007: l_ntf_type VARCHAR2(150);
1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';
1009: l_title VARCHAR2(2000);
1010: l_otl_appr_id VARCHAR2(2000);
1011: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;
1012: l_total_hours number;
1013: l_premium_hours number;
1014: l_non_worked_hours number;
1015: l_description varchar2(100);

Line 1208: l_approval_status hxc_time_building_blocks.approval_status%type;

1204: l_tx_id NUMBER := NULL;
1205: l_tc_resource_id number;
1206: l_period_start_date date;
1207: l_period_end_date date;
1208: l_approval_status hxc_time_building_blocks.approval_status%type;
1209: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
1210: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
1211: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
1212: l_approver_type VARCHAR2(250);

Line 1209: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;

1205: l_tc_resource_id number;
1206: l_period_start_date date;
1207: l_period_end_date date;
1208: l_approval_status hxc_time_building_blocks.approval_status%type;
1209: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
1210: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
1211: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
1212: l_approver_type VARCHAR2(250);
1213: l_message_name VARCHAR2(250);

Line 1210: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;

1206: l_period_start_date date;
1207: l_period_end_date date;
1208: l_approval_status hxc_time_building_blocks.approval_status%type;
1209: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
1210: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
1211: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
1212: l_approver_type VARCHAR2(250);
1213: l_message_name VARCHAR2(250);
1214: l_error_id NUMBER;

Line 1211: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;

1207: l_period_end_date date;
1208: l_approval_status hxc_time_building_blocks.approval_status%type;
1209: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
1210: l_tbb_id hxc_time_building_blocks.time_building_block_id%type;
1211: l_tbb_ovn hxc_time_building_blocks.time_building_block_id%type;
1212: l_approver_type VARCHAR2(250);
1213: l_message_name VARCHAR2(250);
1214: l_error_id NUMBER;
1215: l_ovn NUMBER;