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_TIMECARD dependencies on HR_GENERAL

Line 201: fnd_date.date_to_canonical (hr_general.end_of_time)

197: WHILE l_index_detail IS NOT NULL -- (While Loop)
198: LOOP
199: IF (p_timecard_blocks (l_index_detail).SCOPE = 'DETAIL'
200: AND p_timecard_blocks (l_index_detail).date_to =
201: fnd_date.date_to_canonical (hr_general.end_of_time)
202: )
203: THEN
204:
205: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 235: fnd_date.date_to_canonical (hr_general.end_of_time)

231: WHILE l_zero_hrs_index_detail IS NOT NULL -- (While Loop)
232: LOOP
233: IF (p_zero_template_blocks (l_zero_hrs_index_detail).SCOPE = 'DETAIL'
234: AND p_zero_template_blocks (l_zero_hrs_index_detail).date_to =
235: fnd_date.date_to_canonical (hr_general.end_of_time)
236: ) AND (NOT l_del_bb_ids.EXISTS(p_zero_template_blocks (l_zero_hrs_index_detail).TIME_BUILDING_BLOCK_ID))
237: THEN
238: -- Initialize the Temp Attribute Table
239: if(l_zero_hrs_temp_dtl_attr.count>0) then

Line 649: fnd_date.date_to_canonical (hr_general.end_of_time)

645: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
646: AND p_block_array (l_index_day).start_time =
647: fnd_date.date_to_canonical (l_first_day)
648: AND p_block_array (l_index_day).date_to =
649: fnd_date.date_to_canonical (hr_general.end_of_time)
650: )
651: THEN
652: -- Store the info in local variables
653: l_day_one_time_bb_id :=p_block_array (l_index_day).TIME_BUILDING_BLOCK_ID;

Line 673: fnd_date.date_to_canonical (hr_general.end_of_time)

669: WHILE l_index_detail IS NOT NULL
670: LOOP
671: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
672: AND p_block_array (l_index_detail).date_to =
673: fnd_date.date_to_canonical (hr_general.end_of_time)
674: AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_ID <>
675: l_day_one_time_bb_id
676: -- AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_OVN <>
677: -- l_day_one_ovn

Line 731: fnd_date.date_to_canonical (hr_general.end_of_time)

727: WHILE l_index_detail IS NOT NULL -- (Main Processing)
728: LOOP
729: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
730: AND p_block_array (l_index_detail).date_to =
731: fnd_date.date_to_canonical (hr_general.end_of_time)
732: )
733: THEN
734:
735: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 790: fnd_date.date_to_canonical (hr_general.end_of_time)

786: WHILE l_sub_index_detail IS NOT NULL -- (Sub Processing)
787: LOOP
788: IF ( p_block_array (l_sub_index_detail).SCOPE = 'DETAIL'
789: AND p_block_array (l_sub_index_detail).date_to =
790: fnd_date.date_to_canonical (hr_general.end_of_time)
791: AND p_block_array(l_sub_index_detail).time_building_block_id <>
792: p_block_array(l_index_detail).time_building_block_id
793:
794: )

Line 1721: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);

1717: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
1718: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
1719: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
1720: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
1721: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
1722: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
1723: p_blocks(l_block_index).NEW := 'Y';
1724:
1725: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'

Line 1766: l_date_to := hr_general.end_of_time;

1762: EXIT WHEN NOT p_blocks.exists(l_block_index);
1763:
1764: IF p_blocks(l_block_index).DATE_TO IS NULL
1765: THEN
1766: l_date_to := hr_general.end_of_time;
1767: ELSE
1768: l_date_to := fnd_date.canonical_to_date(p_blocks(l_block_index).DATE_TO);
1769: END IF;
1770:

Line 1774: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time

1770:
1771: IF p_new_block.SCOPE = 'TIMECARD'
1772: THEN
1773: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'
1774: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1775: AND l_date_to = hr_general.end_of_time
1776: THEN
1777: p_index := l_block_index;
1778: p_found := TRUE;

Line 1775: AND l_date_to = hr_general.end_of_time

1771: IF p_new_block.SCOPE = 'TIMECARD'
1772: THEN
1773: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'
1774: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1775: AND l_date_to = hr_general.end_of_time
1776: THEN
1777: p_index := l_block_index;
1778: p_found := TRUE;
1779: RETURN;

Line 1784: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time

1780: END IF;
1781: ELSIF p_new_block.SCOPE = 'DAY'
1782: THEN
1783: IF p_blocks(l_block_index).SCOPE = 'DAY'
1784: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1785: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
1786: AND l_date_to = hr_general.end_of_time
1787: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
1788: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))

Line 1786: AND l_date_to = hr_general.end_of_time

1782: THEN
1783: IF p_blocks(l_block_index).SCOPE = 'DAY'
1784: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
1785: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
1786: AND l_date_to = hr_general.end_of_time
1787: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
1788: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
1789: THEN
1790: p_index := l_block_index;

Line 2004: fnd_date.date_to_canonical (hr_general.end_of_time)

2000: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2001: AND p_block_array (l_index_day).start_time =
2002: fnd_date.date_to_canonical (l_new_start_time)
2003: AND p_block_array (l_index_day).date_to =
2004: fnd_date.date_to_canonical (hr_general.end_of_time)
2005: AND p_block_array (l_index_day).object_version_number <> -99999
2006: )
2007: THEN
2008: l_day_exists := TRUE ;

Line 2028: fnd_date.date_to_canonical (hr_general.end_of_time)

2024: WHILE l_cache_index IS NOT NULL
2025: LOOP
2026: IF ( p_block_array (l_cache_index).SCOPE = 'DAY'
2027: AND p_block_array (l_cache_index).date_to =
2028: fnd_date.date_to_canonical (hr_general.end_of_time)
2029: )
2030: THEN
2031: l_blocks.EXTEND;
2032: l_blocks (1) := p_block_array (l_cache_index);

Line 2859: AND date_to = hr_general.end_of_time

2855: WHERE tbb1.resource_id = p_resource_id
2856: AND tbb1.resource_type = p_resource_type
2857: AND tbb1.scope = 'TIMECARD'
2858: AND to_char(tbb1.stop_time,'YYYY/MM/DD') < p_start_time
2859: AND date_to = hr_general.end_of_time
2860: ORDER BY tbb1.stop_time desc
2861: )
2862: WHERE rownum = 1;
2863:

Line 3172: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);

3168:
3169: FOR l_block_index IN 1..l_blocks.count LOOP
3170: IF l_blocks.exists(l_block_index) THEN
3171: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3172: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3173: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3174: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3175: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3176: l_blocks(l_block_index).new := hxc_timecard.c_yes;

Line 3660: where tbb1.date_to = hr_general.end_of_time

3656: ,tbb1.application_set_id
3657: ,tbb1.translation_display_key
3658: from hxc_time_building_blocks tbb1
3659: ,hxc_time_building_blocks tc
3660: where tbb1.date_to = hr_general.end_of_time
3661: and tbb1.resource_id = p_resource_id
3662: and tbb1.resource_type = p_resource_type
3663: and tbb1.scope = 'DAY'
3664: and tbb1.parent_building_block_id = tc.time_building_block_id

Line 3667: and tc.date_to = hr_general.end_of_time

3663: and tbb1.scope = 'DAY'
3664: and tbb1.parent_building_block_id = tc.time_building_block_id
3665: and tbb1.parent_building_block_ovn = tc.object_version_number
3666: and tc.scope = 'TIMECARD'
3667: and tc.date_to = hr_general.end_of_time
3668: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time
3669: and to_char(tbb1.start_time,'YYYY/MM/DD') <= p_stop_time
3670: and tbb1.date_to = hr_general.end_of_time
3671: order by tbb1.start_time asc;

Line 3670: and tbb1.date_to = hr_general.end_of_time

3666: and tc.scope = 'TIMECARD'
3667: and tc.date_to = hr_general.end_of_time
3668: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time
3669: and to_char(tbb1.start_time,'YYYY/MM/DD') <= p_stop_time
3670: and tbb1.date_to = hr_general.end_of_time
3671: order by tbb1.start_time asc;
3672:
3673: CURSOR c_detail_blocks(
3674: p_resource_id IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE

Line 3707: where tbb1.date_to = hr_general.end_of_time

3703: ,tbb1.translation_display_key
3704: from hxc_time_building_blocks tbb1
3705: ,hxc_time_building_blocks tc
3706: ,hxc_time_building_blocks days
3707: where tbb1.date_to = hr_general.end_of_time
3708: and tbb1.resource_id = p_resource_id
3709: and tbb1.resource_type = p_resource_type
3710: and tbb1.scope = 'DETAIL'
3711: and tbb1.parent_building_block_id = days.time_building_block_id

Line 3716: and days.date_to = hr_general.end_of_time

3712: and tbb1.parent_building_block_ovn = days.object_version_number
3713: and days.scope = 'DAY'
3714: and to_char(days.start_time,'YYYY/MM/DD') >= p_start_time
3715: and to_char(days.start_time,'YYYY/MM/DD') <= p_stop_time
3716: and days.date_to = hr_general.end_of_time
3717: and days.parent_building_block_id = tc.time_building_block_id
3718: and days.parent_building_block_ovn = tc.object_version_number
3719: and tc.date_to = hr_general.end_of_time
3720: and tc.scope = 'TIMECARD'

Line 3719: and tc.date_to = hr_general.end_of_time

3715: and to_char(days.start_time,'YYYY/MM/DD') <= p_stop_time
3716: and days.date_to = hr_general.end_of_time
3717: and days.parent_building_block_id = tc.time_building_block_id
3718: and days.parent_building_block_ovn = tc.object_version_number
3719: and tc.date_to = hr_general.end_of_time
3720: and tc.scope = 'TIMECARD'
3721: order by tbb1.start_time asc;
3722:
3723: CURSOR c_timecard_block(

Line 3755: where tbb1.date_to = hr_general.end_of_time

3751: ,'N' PROCESS
3752: ,tbb1.application_set_id
3753: ,tbb1.translation_display_key
3754: from hxc_time_building_blocks tbb1
3755: where tbb1.date_to = hr_general.end_of_time
3756: and tbb1.resource_id = p_resource_id
3757: and tbb1.resource_type = p_resource_type
3758: and tbb1.scope = 'TIMECARD'
3759: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time

Line 3889: and date_to = hr_general.end_of_time;

3885: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
3886: select object_version_number
3887: from hxc_time_building_blocks
3888: where time_building_block_id = p_timecard_id
3889: and date_to = hr_general.end_of_time;
3890:
3891: l_process_locker_type varchar2(80) := hxc_lock_util.c_ss_timecard_action;
3892: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
3893:

Line 3952: RETURN hr_general.decode_lookup('HXC_APPROVAL_MECHANISM','AUTO_APPROVE');

3948:
3949: BEGIN
3950: IF p_person_id IS NULL
3951: THEN
3952: RETURN hr_general.decode_lookup('HXC_APPROVAL_MECHANISM','AUTO_APPROVE');
3953: END IF;
3954:
3955: OPEN c_person_name(p_person_id);
3956: FETCH c_person_name INTO l_person_name;

Line 3977: AND timecards.date_to = hr_general.end_of_time;

3973: FROM hxc_tc_ap_links links
3974: ,hxc_time_building_blocks timecards
3975: WHERE links.application_period_id = p_app_period_id
3976: AND links.timecard_id = timecards.time_building_block_id
3977: AND timecards.date_to = hr_general.end_of_time;
3978:
3979: l_comment hxc_time_building_blocks.comment_text%TYPE := '';
3980: l_combined_comment hxc_time_building_blocks.comment_text%TYPE := '';
3981: l_extra number := 0;

Line 4109: where tbb1.date_to = hr_general.end_of_time

4105: ,tbb1.application_set_id
4106: ,tbb1.translation_display_key
4107: from hxc_time_building_blocks tbb1
4108: ,hxc_time_building_blocks tc
4109: where tbb1.date_to = hr_general.end_of_time
4110: and tbb1.resource_id = p_resource_id
4111: and tbb1.resource_type = p_resource_type
4112: and tbb1.scope = 'DAY'
4113: and tbb1.start_time >= p_start_time

Line 4118: and tc.date_to = hr_general.end_of_time

4114: and tbb1.start_time <= p_stop_time
4115: and tbb1.parent_building_block_id = tc.time_building_block_id
4116: and tbb1.parent_building_block_ovn = tc.object_version_number
4117: and tc.scope = 'TIMECARD'
4118: and tc.date_to = hr_general.end_of_time
4119: order by tbb1.start_time asc;
4120:
4121: CURSOR c_app_period(
4122: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 4151: and tbb1.date_to = hr_general.end_of_time;

4147: ,tbb1.application_set_id
4148: ,tbb1.translation_display_key
4149: from hxc_time_building_blocks tbb1
4150: where tbb1.time_building_block_id = p_app_period_id
4151: and tbb1.date_to = hr_general.end_of_time;
4152:
4153: CURSOR c_timecard_block(
4154: p_resource_id IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
4155: ,p_resource_type IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE

Line 4185: where tbb1.date_to = hr_general.end_of_time

4181: ,'N' PROCESS
4182: ,tbb1.application_set_id
4183: ,tbb1.translation_display_key
4184: from hxc_time_building_blocks tbb1
4185: where tbb1.date_to = hr_general.end_of_time
4186: and tbb1.resource_id = p_resource_id
4187: and tbb1.resource_type = p_resource_type
4188: and tbb1.scope = 'TIMECARD'
4189: and p_start_time <= tbb1.stop_time

Line 4225: AND tbb1.date_to = hr_general.end_of_time;

4221: ,hxc_time_building_blocks tbb1
4222: WHERE adlinks.application_period_id = p_app_period_id
4223: AND adlinks.time_building_block_id = tbb1.time_building_block_id
4224: AND adlinks.time_building_block_ovn = tbb1.object_version_number
4225: AND tbb1.date_to = hr_general.end_of_time;
4226:
4227: CURSOR c_detail_blocks_sup(
4228: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE,
4229: p_start_time date,

Line 4268: and details.date_to = hr_general.end_of_time

4264: and hal.APPLICATION_PERIOD_ID = p_app_period_id
4265: and hal.timecard_id = timecard.time_building_block_id
4266: and days.parent_building_block_id = timecard.time_building_block_id
4267: and days.parent_building_block_ovn = timecard.object_version_number
4268: and details.date_to = hr_general.end_of_time
4269: and days.start_time <= p_stop_time
4270: and days.stop_time >= p_start_time
4271: order by details.translation_display_key;
4272:

Line 4278: SELECT hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)

4274: CURSOR c_app_attribute(
4275: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
4276: )
4277: IS
4278: SELECT hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
4279: ,favtl.application_name
4280: ,apsum.approver_id
4281: ,apsum.time_category_id
4282: FROM hxc_app_period_summary apsum