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

Line 1552: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)

1548:
1549: hxc_lock_api.request_lock
1550: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1551: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1552: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1553: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1554: ,p_time_building_block_id=> null
1555: ,p_time_building_block_ovn=> null
1556: ,p_transaction_lock_id=> null

Line 1553: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)

1549: hxc_lock_api.request_lock
1550: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1551: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1552: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1553: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1554: ,p_time_building_block_id=> null
1555: ,p_time_building_block_ovn=> null
1556: ,p_transaction_lock_id=> null
1557: ,p_expiration_time=> 10

Line 1567: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)

1563:
1564: hxc_lock_api.request_lock
1565: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1566: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1567: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1568: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1569: ,p_time_building_block_id=> p_blocks(l_timecard_index).time_building_block_id
1570: ,p_time_building_block_ovn=> p_blocks(l_timecard_index).object_version_number
1571: ,p_transaction_lock_id=> null

Line 1568: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)

1564: hxc_lock_api.request_lock
1565: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1566: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1567: ,p_start_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1568: ,p_stop_time=> fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
1569: ,p_time_building_block_id=> p_blocks(l_timecard_index).time_building_block_id
1570: ,p_time_building_block_ovn=> p_blocks(l_timecard_index).object_version_number
1571: ,p_transaction_lock_id=> null
1572: ,p_expiration_time=> 10

Line 1587: hxc_retrieve_absences.g_start_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).start_time);

1583: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1584:
1585: hxc_retrieve_absences.g_lock_row_id := p_lock_rowid;
1586: hxc_retrieve_absences.g_person_id := p_blocks(l_timecard_index).resource_id;
1587: hxc_retrieve_absences.g_start_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).start_time);
1588: hxc_retrieve_absences.g_stop_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).stop_time);
1589:
1590: -- Added for OTL ABS Integration 8888902
1591: -- OTL-ABS START

Line 1588: hxc_retrieve_absences.g_stop_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).stop_time);

1584:
1585: hxc_retrieve_absences.g_lock_row_id := p_lock_rowid;
1586: hxc_retrieve_absences.g_person_id := p_blocks(l_timecard_index).resource_id;
1587: hxc_retrieve_absences.g_start_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).start_time);
1588: hxc_retrieve_absences.g_stop_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).stop_time);
1589:
1590: -- Added for OTL ABS Integration 8888902
1591: -- OTL-ABS START
1592: IF g_debug THEN

Line 1700: l_blocks(l_block_count).date_to := fnd_date.date_to_canonical(sysdate);

1696: if(p_load_mode = c_delete) then
1697: --
1698: -- Date effectively end date the block
1699: --
1700: l_blocks(l_block_count).date_to := fnd_date.date_to_canonical(sysdate);
1701: end if;
1702:
1703: l_block_count := l_block_count +1;
1704:

Line 1854: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value

1850: fnd_attached_documents fad
1851: where fad.entity_name = 'HXC_TIMECARD_SUMMARY'
1852: and hts.timecard_id = p_timecard_id
1853: and hts.resource_id = fad.pk1_value
1854: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
1855: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
1856: ;
1857:
1858: --l_timecard_attachment_exists varchar2(5) := 'N';

Line 1855: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value

1851: where fad.entity_name = 'HXC_TIMECARD_SUMMARY'
1852: and hts.timecard_id = p_timecard_id
1853: and hts.resource_id = fad.pk1_value
1854: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.start_time)),' .*') = fad.pk2_value
1855: and regexp_replace(fnd_date.date_to_canonical(trunc(hts.stop_time)),' .*') = fad.pk3_value
1856: ;
1857:
1858: --l_timecard_attachment_exists varchar2(5) := 'N';
1859: l_pk1_value fnd_attached_documents.pk1_value%type;