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_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 416: from hxc_time_building_blocks

412: cursor c_approval_status
413: (p_r_id in NUMBER
414: ,p_date in DATE) is
415: select approval_status
416: from hxc_time_building_blocks
417: where resource_id = p_r_id
418: and scope = 'APPLICATION_PERIOD'
419: and approval_status = 'APPROVED'
420: and p_date between start_time and stop_time

Line 423: from hxc_time_building_blocks

419: and approval_status = 'APPROVED'
420: and p_date between start_time and stop_time
421: and NOT exists
422: (select 'Y'
423: from hxc_time_building_blocks
424: where resource_id = p_r_id
425: and scope = 'APPLICATION_PERIOD'
426: and date_to = hr_general.end_of_time
427: and approval_status = 'REJECTED'

Line 431: l_return HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;

427: and approval_status = 'REJECTED'
428: and p_date between start_time and stop_time
429: );
430:
431: l_return HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
432:
433: BEGIN
434:
435: open c_approval_status(p_resource_id, p_day_date);

Line 505: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE) is

501: FUNCTION is_working_status
502: (p_block_number in NUMBER) RETURN BOOLEAN IS
503:
504: cursor csr_working
505: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE) is
506: select approval_status
507: from hxc_time_building_blocks
508: where time_building_block_id = p_time_building_block_id
509: and date_to = hr_general.end_of_time

Line 507: from hxc_time_building_blocks

503:
504: cursor csr_working
505: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE) is
506: select approval_status
507: from hxc_time_building_blocks
508: where time_building_block_id = p_time_building_block_id
509: and date_to = hr_general.end_of_time
510: and approval_status = 'WORKING';
511:

Line 512: l_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;

508: where time_building_block_id = p_time_building_block_id
509: and date_to = hr_general.end_of_time
510: and approval_status = 'WORKING';
511:
512: l_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
513:
514: BEGIN
515:
516: open csr_working(g_timecard(p_block_number).time_building_block_id);

Line 603: l_previous_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;

599: l_resource_start_date DATE;
600: l_resource_end_date DATE;
601: l_pref_val HXC_PREF_HIERARCHIES.ATTRIBUTE16%TYPE;
602: l_pref_detail_val HXC_PREF_HIERARCHIES.ATTRIBUTE17%TYPE;
603: l_previous_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
604: l_proc VARCHAR2(32) := 'CHECK_APPROVAL_LOCKED';
605:
606: BEGIN
607:

Line 732: from hxc_time_building_blocks

728: cursor csr_old_block
729: (p_time_building_block_id in number
730: ,p_ovn in number) is
731: select *
732: from hxc_time_building_blocks
733: where time_building_block_id = p_time_building_block_id
734: and object_version_number = p_ovn;
735:
736: block_rec HXC_TIME_BUILDING_BLOCKS%ROWTYPE;

Line 736: block_rec HXC_TIME_BUILDING_BLOCKS%ROWTYPE;

732: from hxc_time_building_blocks
733: where time_building_block_id = p_time_building_block_id
734: and object_version_number = p_ovn;
735:
736: block_rec HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
737:
738: l_process BOOLEAN := false;
739: l_not_just_approval_status BOOLEAN := false;
740: l_pref_val HXC_PREF_HIERARCHIES.ATTRIBUTE16%TYPE;

Line 1043: from hxc_time_building_blocks tbb

1039: ,p_resoure_id in number
1040: ,p_time_building_block_id in number
1041: ) is
1042: select 'Y'
1043: from hxc_time_building_blocks tbb
1044: ,hxc_time_attribute_usages tau
1045: ,hxc_time_attributes ta
1046: where ta.time_attribute_id = tau.time_attribute_id
1047: and tau.time_building_block_id = tbb.time_building_block_id

Line 1061: from hxc_time_building_blocks tbb

1057: cursor c_is_public_template
1058: (p_name_to_check in varchar2
1059: ,p_time_building_block_id in number) is
1060: select 'Y'
1061: from hxc_time_building_blocks tbb
1062: ,hxc_time_attribute_usages tau
1063: ,hxc_time_attributes ta
1064: where ta.time_attribute_id = tau.time_attribute_id
1065: and tau.time_building_block_id = tbb.time_building_block_id

Line 2029: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

2025: END get_bld_blk_type_id;
2026:
2027: FUNCTION attribute_check
2028: (p_to_check IN VARCHAR2
2029: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2030: ) RETURN BOOLEAN IS
2031:
2032: l_doesnt_exist BOOLEAN := TRUE;
2033: l_attribute_count NUMBER;

Line 3875: (p_timecard_id out nocopy HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

3871:
3872: end;
3873:
3874: procedure deposit_blocks
3875: (p_timecard_id out nocopy HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3876: ,p_timecard_ovn out nocopy HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3877: ,p_mode varchar2
3878: ,p_deposit_process varchar2
3879: ,p_retrieval_process varchar2 default null

Line 3876: ,p_timecard_ovn out nocopy HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

3872: end;
3873:
3874: procedure deposit_blocks
3875: (p_timecard_id out nocopy HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3876: ,p_timecard_ovn out nocopy HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3877: ,p_mode varchar2
3878: ,p_deposit_process varchar2
3879: ,p_retrieval_process varchar2 default null
3880: ,p_validate_session boolean default TRUE --AI8

Line 3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;

3881: ,p_add_security boolean default TRUE --AI8
3882: ,p_allow_error_tc boolean default FALSE -- GPM v115.87
3883: ) IS
3884: --
3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

Line 3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;

3883: ) IS
3884: --
3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;

Line 3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

3884: --
3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;
3892: l_time_source_name hxc_time_sources.name%TYPE;

Line 3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;
3892: l_time_source_name hxc_time_sources.name%TYPE;
3893: l_timecard hxc_time_attributes_api.timecard;

Line 3925: l_approval_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;

3921: l_transaction_tab hxc_deposit_wrapper_utilities.t_transaction;
3922: l_overall_status varchar2(7) := 'SUCCESS';
3923: l_approval_style_id HXC_APPROVAL_STYLES.APPROVAL_STYLE_ID%TYPE;
3924:
3925: l_approval_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;
3926: l_approval_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE := null;
3927:
3928: l_block_processed boolean :=false;
3929:

Line 3926: l_approval_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE := null;

3922: l_overall_status varchar2(7) := 'SUCCESS';
3923: l_approval_style_id HXC_APPROVAL_STYLES.APPROVAL_STYLE_ID%TYPE;
3924:
3925: l_approval_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;
3926: l_approval_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE := null;
3927:
3928: l_block_processed boolean :=false;
3929:
3930: l_attributes_cp building_block_attribute_info;

Line 3940: from hxc_time_building_blocks

3936: --
3937: CURSOR csr_time_building_block(p_building_block_id NUMBER
3938: ,p_bb_ovn NUMBER) IS
3939: select *
3940: from hxc_time_building_blocks
3941: where time_building_block_id = p_building_block_id
3942: and object_version_number = p_bb_ovn;
3943: --
3944: CURSOR csr_time_recipients(p_application_set_id IN NUMBER) IS

Line 3961: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

3957: -- Removed cursor c_code_chk - No usage reference found
3958: -- Refer to TMSTask12613 for further analysis.
3959: --
3960: CURSOR csr_resubmitted
3961: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3962: ,p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3963: ) IS
3964: SELECT 'YES'
3965: FROM hxc_time_building_blocks

Line 3962: ,p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

3958: -- Refer to TMSTask12613 for further analysis.
3959: --
3960: CURSOR csr_resubmitted
3961: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3962: ,p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3963: ) IS
3964: SELECT 'YES'
3965: FROM hxc_time_building_blocks
3966: WHERE time_building_block_id = p_timecard_id

Line 3965: FROM hxc_time_building_blocks

3961: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3962: ,p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3963: ) IS
3964: SELECT 'YES'
3965: FROM hxc_time_building_blocks
3966: WHERE time_building_block_id = p_timecard_id
3967: AND object_version_number < p_max_ovn
3968: AND approval_status = 'SUBMITTED';
3969: --

Line 5100: from hxc_time_building_blocks tbb_tim

5096: tbb_tim.approval_style_id tbb_tim_approval_style,
5097: tbb_tim.date_from tbb_tim_date_from,
5098: tbb_tim.date_to tbb_tim_date_to,
5099: tbb_tim.comment_text tbb_tim_comment_text
5100: from hxc_time_building_blocks tbb_tim
5101: where tbb_tim.time_building_block_id = p_timecard_block
5102: and tbb_tim.date_to = hr_general.end_of_time
5103: and (tbb_tim.scope='TIMECARD' or tbb_tim.scope='TIMECARD_TEMPLATE');
5104:

Line 5123: from hxc_time_building_blocks tbb_day

5119: tbb_day.approval_style_id tbb_day_approval_style,
5120: tbb_day.date_from tbb_day_date_from,
5121: tbb_day.date_to tbb_day_date_to,
5122: tbb_day.comment_text tbb_day_comment_text
5123: from hxc_time_building_blocks tbb_day
5124: where tbb_day.parent_building_block_ovn = p_timecard_ovn
5125: and tbb_day.parent_building_block_id = p_timecard_block
5126: and tbb_day.date_to = hr_general.end_of_time
5127: and tbb_day.scope='DAY';

Line 5149: from hxc_time_building_blocks tbb_day,

5145: tbb_det.approval_style_id tbb_det_approval_style,
5146: tbb_det.date_from tbb_det_date_from,
5147: tbb_det.date_to tbb_det_date_to,
5148: tbb_det.comment_text tbb_det_comment_text
5149: from hxc_time_building_blocks tbb_day,
5150: hxc_time_building_blocks tbb_det
5151: where tbb_day.parent_building_block_ovn = p_timecard_ovn
5152: and tbb_day.parent_building_block_id = p_timecard_block
5153: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number

Line 5150: hxc_time_building_blocks tbb_det

5146: tbb_det.date_from tbb_det_date_from,
5147: tbb_det.date_to tbb_det_date_to,
5148: tbb_det.comment_text tbb_det_comment_text
5149: from hxc_time_building_blocks tbb_day,
5150: hxc_time_building_blocks tbb_det
5151: where tbb_day.parent_building_block_ovn = p_timecard_ovn
5152: and tbb_day.parent_building_block_id = p_timecard_block
5153: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number
5154: and tbb_det.parent_building_block_id = tbb_day.time_building_block_id

Line 5175: l_scope hxc_time_building_blocks.scope%TYPE;

5171: l_timecard_ovn number;
5172: l_timecard_block number;
5173: l_returned_timecard_id number;
5174: l_returned_timecard_ovn number;
5175: l_scope hxc_time_building_blocks.scope%TYPE;
5176:
5177: e_no_such_timecard exception;
5178: e_not_timecard_scope exception;
5179:

Line 5613: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

5609: p_retrieval_process_id IN NUMBER
5610: )
5611: IS
5612: CURSOR c_time_building_blocks (
5613: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
5614: p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5615: )
5616: IS
5617: SELECT htbb.time_building_block_id, htbb.TYPE, htbb.measure,

Line 5614: p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE

5610: )
5611: IS
5612: CURSOR c_time_building_blocks (
5613: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
5614: p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5615: )
5616: IS
5617: SELECT htbb.time_building_block_id, htbb.TYPE, htbb.measure,
5618: htbb.unit_of_measure, htbb.start_time, htbb.stop_time,

Line 5625: FROM hxc_time_building_blocks htbb

5621: htbb.resource_id, htbb.resource_type, htbb.approval_style_id,
5622: htbb.date_from, htbb.date_to, htbb.comment_text,
5623: htbb.parent_building_block_ovn, 'N' NEW, 'N' changed, 'N' process,
5624: htbb.application_set_id, htbb.translation_display_key
5625: FROM hxc_time_building_blocks htbb
5626: WHERE SYSDATE BETWEEN htbb.date_from AND htbb.date_to
5627: START WITH ( htbb.time_building_block_id = p_timecard_id
5628: AND htbb.object_version_number = p_timecard_ovn
5629: )

Line 5637: p_build_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

5633: htbb.parent_building_block_ovn
5634: ORDER BY htbb.time_building_block_id ASC;
5635:
5636: CURSOR c_block_attributes (
5637: p_build_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
5638: p_build_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5639: )
5640: IS
5641: SELECT hta.time_attribute_id, htau.time_building_block_id,

Line 5638: p_build_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

5634: ORDER BY htbb.time_building_block_id ASC;
5635:
5636: CURSOR c_block_attributes (
5637: p_build_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
5638: p_build_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5639: )
5640: IS
5641: SELECT hta.time_attribute_id, htau.time_building_block_id,
5642: hbbit.bld_blk_info_type, hta.attribute_category, hta.attribute1,