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 698: fnd_date.date_to_canonical (hr_general.end_of_time)

694: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
695: AND p_block_array (l_index_day).start_time =
696: fnd_date.date_to_canonical (l_first_day)
697: AND p_block_array (l_index_day).date_to =
698: fnd_date.date_to_canonical (hr_general.end_of_time)
699: )
700: THEN
701: -- Store the info in local variables
702: l_day_one_time_bb_id :=p_block_array (l_index_day).TIME_BUILDING_BLOCK_ID;

Line 726: fnd_date.date_to_canonical (hr_general.end_of_time)

722: WHILE l_index_detail IS NOT NULL
723: LOOP
724: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
725: AND p_block_array (l_index_detail).date_to =
726: fnd_date.date_to_canonical (hr_general.end_of_time)
727: AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_ID <>
728: l_day_one_time_bb_id
729: -- AND p_block_array (l_index_detail).PARENT_BUILDING_BLOCK_OVN <>
730: -- l_day_one_ovn

Line 815: fnd_date.date_to_canonical (hr_general.end_of_time)

811: WHILE l_index_detail IS NOT NULL -- (Main Processing)
812: LOOP
813: IF ( p_block_array (l_index_detail).SCOPE = 'DETAIL'
814: AND p_block_array (l_index_detail).date_to =
815: fnd_date.date_to_canonical (hr_general.end_of_time)
816: )
817: THEN
818:
819: -- Get all the ATTRIBUTES for this DETAIL Building Block into a Temp Table

Line 874: fnd_date.date_to_canonical (hr_general.end_of_time)

870: WHILE l_sub_index_detail IS NOT NULL -- (Sub Processing)
871: LOOP
872: IF ( p_block_array (l_sub_index_detail).SCOPE = 'DETAIL'
873: AND p_block_array (l_sub_index_detail).date_to =
874: fnd_date.date_to_canonical (hr_general.end_of_time)
875: AND p_block_array(l_sub_index_detail).time_building_block_id <>
876: p_block_array(l_index_detail).time_building_block_id
877:
878: )

Line 1216: AND p_block_array(l_index_detail).DATE_TO = fnd_date.date_to_canonical (hr_general.end_of_time)

1212: LOOP
1213: EXIT WHEN NOT p_block_array.exists(l_index_detail);
1214:
1215: IF p_block_array(l_index_detail).SCOPE = 'DETAIL'
1216: AND p_block_array(l_index_detail).DATE_TO = fnd_date.date_to_canonical (hr_general.end_of_time)
1217: THEN
1218:
1219: IF g_debug THEN
1220: hr_utility.trace('p_block_array(l_index_detail).TIME_BUILDING_BLOCK_ID ::'||p_block_array(l_index_detail).TIME_BUILDING_BLOCK_ID );

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

2015: p_blocks(l_block_index).RESOURCE_ID := p_resource_id;
2016: p_blocks(l_block_index).RESOURCE_TYPE := 'PERSON';
2017: p_blocks(l_block_index).APPROVAL_STYLE_ID := p_approval_style;
2018: p_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
2019: p_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
2020: p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN := 1;
2021: p_blocks(l_block_index).NEW := 'Y';
2022:
2023: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'

Line 2064: l_date_to := hr_general.end_of_time;

2060: EXIT WHEN NOT p_blocks.exists(l_block_index);
2061:
2062: IF p_blocks(l_block_index).DATE_TO IS NULL
2063: THEN
2064: l_date_to := hr_general.end_of_time;
2065: ELSE
2066: l_date_to := fnd_date.canonical_to_date(p_blocks(l_block_index).DATE_TO);
2067: END IF;
2068:

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

2068:
2069: IF p_new_block.SCOPE = 'TIMECARD'
2070: THEN
2071: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'
2072: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2073: AND l_date_to = hr_general.end_of_time
2074: THEN
2075: p_index := l_block_index;
2076: p_found := TRUE;

Line 2073: AND l_date_to = hr_general.end_of_time

2069: IF p_new_block.SCOPE = 'TIMECARD'
2070: THEN
2071: IF p_blocks(l_block_index).SCOPE = 'TIMECARD'
2072: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2073: AND l_date_to = hr_general.end_of_time
2074: THEN
2075: p_index := l_block_index;
2076: p_found := TRUE;
2077: RETURN;

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

2078: END IF;
2079: ELSIF p_new_block.SCOPE = 'DAY'
2080: THEN
2081: IF p_blocks(l_block_index).SCOPE = 'DAY'
2082: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2083: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
2084: AND l_date_to = hr_general.end_of_time
2085: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
2086: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))

Line 2084: AND l_date_to = hr_general.end_of_time

2080: THEN
2081: IF p_blocks(l_block_index).SCOPE = 'DAY'
2082: --array AND NVL(p_blocks(l_block_index).DATE_TO, hr_general.end_of_time) = hr_general.end_of_time
2083: --array AND TRUNC(p_blocks(l_block_index).START_TIME) = TRUNC(p_new_block.START_TIME)
2084: AND l_date_to = hr_general.end_of_time
2085: AND TRUNC(fnd_date.canonical_to_date(p_blocks(l_block_index).START_TIME))
2086: = TRUNC(fnd_date.canonical_to_date(p_new_block.START_TIME))
2087: THEN
2088: p_index := l_block_index;

Line 2302: fnd_date.date_to_canonical (hr_general.end_of_time)

2298: IF ( p_block_array (l_index_day).SCOPE = 'DAY'
2299: AND p_block_array (l_index_day).start_time =
2300: fnd_date.date_to_canonical (l_new_start_time)
2301: AND p_block_array (l_index_day).date_to =
2302: fnd_date.date_to_canonical (hr_general.end_of_time)
2303: AND p_block_array (l_index_day).object_version_number <> -99999
2304: )
2305: THEN
2306: l_day_exists := TRUE ;

Line 2326: fnd_date.date_to_canonical (hr_general.end_of_time)

2322: WHILE l_cache_index IS NOT NULL
2323: LOOP
2324: IF ( p_block_array (l_cache_index).SCOPE = 'DAY'
2325: AND p_block_array (l_cache_index).date_to =
2326: fnd_date.date_to_canonical (hr_general.end_of_time)
2327: )
2328: THEN
2329: l_blocks.EXTEND;
2330: l_blocks (1) := p_block_array (l_cache_index);

Line 3159: AND date_to = hr_general.end_of_time

3155: WHERE tbb1.resource_id = p_resource_id
3156: AND tbb1.resource_type = p_resource_type
3157: AND tbb1.scope = 'TIMECARD'
3158: AND to_char(tbb1.stop_time,'YYYY/MM/DD') < p_start_time
3159: AND date_to = hr_general.end_of_time
3160: ORDER BY tbb1.stop_time desc
3161: )
3162: WHERE rownum = 1;
3163:

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

3487:
3488: FOR l_block_index IN 1..l_blocks.count LOOP
3489: IF l_blocks.exists(l_block_index) THEN
3490: l_blocks(l_block_index).DATE_FROM := fnd_date.date_to_canonical(SYSDATE);
3491: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3492: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3493: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3494: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3495: l_blocks(l_block_index).new := hxc_timecard.c_yes;

Line 3996: where tbb1.date_to = hr_general.end_of_time

3992: ,tbb1.application_set_id
3993: ,tbb1.translation_display_key
3994: from hxc_time_building_blocks tbb1
3995: ,hxc_time_building_blocks tc
3996: where tbb1.date_to = hr_general.end_of_time
3997: and tbb1.resource_id = p_resource_id
3998: and tbb1.resource_type = p_resource_type
3999: and tbb1.scope = 'DAY'
4000: and tbb1.parent_building_block_id = tc.time_building_block_id

Line 4003: and tc.date_to = hr_general.end_of_time

3999: and tbb1.scope = 'DAY'
4000: and tbb1.parent_building_block_id = tc.time_building_block_id
4001: and tbb1.parent_building_block_ovn = tc.object_version_number
4002: and tc.scope = 'TIMECARD'
4003: and tc.date_to = hr_general.end_of_time
4004: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time
4005: and to_char(tbb1.start_time,'YYYY/MM/DD') <= p_stop_time
4006: and tbb1.date_to = hr_general.end_of_time
4007: order by tbb1.start_time asc;

Line 4006: and tbb1.date_to = hr_general.end_of_time

4002: and tc.scope = 'TIMECARD'
4003: and tc.date_to = hr_general.end_of_time
4004: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time
4005: and to_char(tbb1.start_time,'YYYY/MM/DD') <= p_stop_time
4006: and tbb1.date_to = hr_general.end_of_time
4007: order by tbb1.start_time asc;
4008:
4009: CURSOR c_detail_blocks(
4010: p_resource_id IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE

Line 4043: where tbb1.date_to = hr_general.end_of_time

4039: ,tbb1.translation_display_key
4040: from hxc_time_building_blocks tbb1
4041: ,hxc_time_building_blocks tc
4042: ,hxc_time_building_blocks days
4043: where tbb1.date_to = hr_general.end_of_time
4044: and tbb1.resource_id = p_resource_id
4045: and tbb1.resource_type = p_resource_type
4046: and tbb1.scope = 'DETAIL'
4047: and tbb1.parent_building_block_id = days.time_building_block_id

Line 4052: and days.date_to = hr_general.end_of_time

4048: and tbb1.parent_building_block_ovn = days.object_version_number
4049: and days.scope = 'DAY'
4050: and to_char(days.start_time,'YYYY/MM/DD') >= p_start_time
4051: and to_char(days.start_time,'YYYY/MM/DD') <= p_stop_time
4052: and days.date_to = hr_general.end_of_time
4053: and days.parent_building_block_id = tc.time_building_block_id
4054: and days.parent_building_block_ovn = tc.object_version_number
4055: and tc.date_to = hr_general.end_of_time
4056: and tc.scope = 'TIMECARD'

Line 4055: and tc.date_to = hr_general.end_of_time

4051: and to_char(days.start_time,'YYYY/MM/DD') <= p_stop_time
4052: and days.date_to = hr_general.end_of_time
4053: and days.parent_building_block_id = tc.time_building_block_id
4054: and days.parent_building_block_ovn = tc.object_version_number
4055: and tc.date_to = hr_general.end_of_time
4056: and tc.scope = 'TIMECARD'
4057: order by tbb1.start_time asc;
4058:
4059: CURSOR c_timecard_block(

Line 4091: where tbb1.date_to = hr_general.end_of_time

4087: ,'N' PROCESS
4088: ,tbb1.application_set_id
4089: ,tbb1.translation_display_key
4090: from hxc_time_building_blocks tbb1
4091: where tbb1.date_to = hr_general.end_of_time
4092: and tbb1.resource_id = p_resource_id
4093: and tbb1.resource_type = p_resource_type
4094: and tbb1.scope = 'TIMECARD'
4095: and to_char(tbb1.start_time,'YYYY/MM/DD') >= p_start_time

Line 4225: and date_to = hr_general.end_of_time;

4221: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
4222: select object_version_number
4223: from hxc_time_building_blocks
4224: where time_building_block_id = p_timecard_id
4225: and date_to = hr_general.end_of_time;
4226:
4227: l_process_locker_type varchar2(80) := hxc_lock_util.c_ss_timecard_action;
4228: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
4229:

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

4284:
4285: BEGIN
4286: IF p_person_id IS NULL
4287: THEN
4288: RETURN hr_general.decode_lookup('HXC_APPROVAL_MECHANISM','AUTO_APPROVE');
4289: END IF;
4290:
4291: OPEN c_person_name(p_person_id);
4292: FETCH c_person_name INTO l_person_name;

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

4309: FROM hxc_tc_ap_links links
4310: ,hxc_time_building_blocks timecards
4311: WHERE links.application_period_id = p_app_period_id
4312: AND links.timecard_id = timecards.time_building_block_id
4313: AND timecards.date_to = hr_general.end_of_time;
4314:
4315: l_comment hxc_time_building_blocks.comment_text%TYPE := '';
4316: l_combined_comment hxc_time_building_blocks.comment_text%TYPE := '';
4317: l_extra number := 0;

Line 4445: where tbb1.date_to = hr_general.end_of_time

4441: ,tbb1.application_set_id
4442: ,tbb1.translation_display_key
4443: from hxc_time_building_blocks tbb1
4444: ,hxc_time_building_blocks tc
4445: where tbb1.date_to = hr_general.end_of_time
4446: and tbb1.resource_id = p_resource_id
4447: and tbb1.resource_type = p_resource_type
4448: and tbb1.scope = 'DAY'
4449: and tbb1.start_time >= p_start_time

Line 4454: and tc.date_to = hr_general.end_of_time

4450: and tbb1.start_time <= p_stop_time
4451: and tbb1.parent_building_block_id = tc.time_building_block_id
4452: and tbb1.parent_building_block_ovn = tc.object_version_number
4453: and tc.scope = 'TIMECARD'
4454: and tc.date_to = hr_general.end_of_time
4455: order by tbb1.start_time asc;
4456:
4457: CURSOR c_app_period(
4458: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE

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

4483: ,tbb1.application_set_id
4484: ,tbb1.translation_display_key
4485: from hxc_time_building_blocks tbb1
4486: where tbb1.time_building_block_id = p_app_period_id
4487: and tbb1.date_to = hr_general.end_of_time;
4488:
4489: CURSOR c_timecard_block(
4490: p_resource_id IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
4491: ,p_resource_type IN HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE

Line 4521: where tbb1.date_to = hr_general.end_of_time

4517: ,'N' PROCESS
4518: ,tbb1.application_set_id
4519: ,tbb1.translation_display_key
4520: from hxc_time_building_blocks tbb1
4521: where tbb1.date_to = hr_general.end_of_time
4522: and tbb1.resource_id = p_resource_id
4523: and tbb1.resource_type = p_resource_type
4524: and tbb1.scope = 'TIMECARD'
4525: and p_start_time <= tbb1.stop_time

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

4557: ,hxc_time_building_blocks tbb1
4558: WHERE adlinks.application_period_id = p_app_period_id
4559: AND adlinks.time_building_block_id = tbb1.time_building_block_id
4560: AND adlinks.time_building_block_ovn = tbb1.object_version_number
4561: AND tbb1.date_to = hr_general.end_of_time;
4562:
4563: CURSOR c_detail_blocks_sup(
4564: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE,
4565: p_start_time date,

Line 4604: and details.date_to = hr_general.end_of_time

4600: and hal.APPLICATION_PERIOD_ID = p_app_period_id
4601: and hal.timecard_id = timecard.time_building_block_id
4602: and days.parent_building_block_id = timecard.time_building_block_id
4603: and days.parent_building_block_ovn = timecard.object_version_number
4604: and details.date_to = hr_general.end_of_time
4605: and days.start_time <= p_stop_time
4606: and days.stop_time >= p_start_time
4607: order by details.translation_display_key;
4608:

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

4610: CURSOR c_app_attribute(
4611: p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
4612: )
4613: IS
4614: SELECT hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
4615: ,favtl.application_name
4616: ,apsum.approver_id
4617: ,apsum.time_category_id
4618: FROM hxc_app_period_summary apsum