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_APPROVAL_WF_PKG dependencies on HXC_ARCHIVE_TEMP

Line 3047: FROM hxc_archive_temp))

3043: WHERE parent_comp_id = p_comp_id
3044: AND parent_comp_ovn = p_comp_ovn
3045: AND ( time_category_id = 0
3046: OR time_category_id IN ( SELECT detail_id
3047: FROM hxc_archive_temp))
3048: ORDER BY time_category_id desc;
3049:
3050:
3051: -- Picks up the subset as required in the above cursor.

Line 3558: DELETE FROM hxc_archive_temp;

3554: IF NVL(FND_PROFILE.VALUE('HXC_ELA_RESTRUCTURED_TC'),'N') = 'Y'
3555: THEN
3556:
3557: -- Delete everything from the GTT, just in case a previous timecard left something.
3558: DELETE FROM hxc_archive_temp;
3559:
3560: -- Get the time categories that matter for this timecard.
3561: OPEN get_time_categories;
3562:

Line 3571: INSERT INTO hxc_archive_temp

3567: -- Insert these time categories to the temp table.
3568: IF l_cat_tab.COUNT > 0
3569: THEN
3570: FORALL i IN l_cat_tab.FIRST..l_cat_tab.LAST
3571: INSERT INTO hxc_archive_temp
3572: (detail_id)
3573: VALUES
3574: (l_cat_tab(i));
3575: