APPS.HXC_TIMECARD_AUDIT dependencies on HXC_PA_LATEST_DETAILS

Line 800: -- Updating hxc_pa_latest_details

796: END LOOP;
797: end if;
798:
799: -- Bug 8888801
800: -- Updating hxc_pa_latest_details
801: -- with details specific for the application.
802: FORALL i IN pa_resource_id_tab.FIRST..pa_resource_id_tab.LAST
803: UPDATE hxc_pa_latest_details
804: SET object_version_number = pa_object_version_number_tab(i),

Line 803: UPDATE hxc_pa_latest_details

799: -- Bug 8888801
800: -- Updating hxc_pa_latest_details
801: -- with details specific for the application.
802: FORALL i IN pa_resource_id_tab.FIRST..pa_resource_id_tab.LAST
803: UPDATE hxc_pa_latest_details
804: SET object_version_number = pa_object_version_number_tab(i),
805: approval_status = pa_approval_status_tab(i),
806: application_set_id = pa_application_set_id_tab(i),
807: last_update_date = pa_last_update_date_tab(i),

Line 831: -- Inserting into hxc_pa_latest_details and hxc_pay_latest_details

827: WHERE time_building_block_id = pay_time_building_block_id_tab(i);
828:
829:
830: -- Bug 8888801
831: -- Inserting into hxc_pa_latest_details and hxc_pay_latest_details
832: -- the respective details. Save Exceptions will see to it that
833: -- any exception is raised only at the end.
834: -- with details specific for the application.
835: BEGIN

Line 880: INSERT INTO hxc_pa_latest_details

876:
877: BEGIN
878:
879: FORALL i IN pa_resource_id_tab.FIRST..pa_resource_id_tab.LAST SAVE EXCEPTIONS
880: INSERT INTO hxc_pa_latest_details
881: (
882: resource_id,
883: time_building_block_id,
884: object_version_number,

Line 1601: UPDATE hxc_pa_latest_details

1597:
1598:
1599:
1600: FORALL i IN PA_TIME_ATTRIBUTE_ID.FIRST..PA_TIME_ATTRIBUTE_ID.LAST
1601: UPDATE hxc_pa_latest_details
1602: SET ATTRIBUTE_CATEGORY = PA_ATTRIBUTE_CATEGORY(i),
1603: ATTRIBUTE1 = PA_ATTRIBUTE1(i),
1604: ATTRIBUTE2 = PA_ATTRIBUTE2(i),
1605: ATTRIBUTE3 = PA_ATTRIBUTE3(i),

Line 1619: DELETE FROM hxc_pa_latest_details pre

1615: -- Deleting tbb ids which are LOGICALLY DELETED in hxc_time_building_blocks
1616: -- and never retrieved. Such bb ids need not be considered for retrieval.
1617: -- and can be removed from the HXC_PA table for upgraded retrieval.
1618: FORALL i IN PA_TIME_ATTRIBUTE_ID.FIRST..PA_TIME_ATTRIBUTE_ID.LAST
1619: DELETE FROM hxc_pa_latest_details pre
1620: WHERE TIME_BUILDING_BLOCK_ID = PA_BUILDING_BLOCK_ID(i)
1621: AND OBJECT_VERSION_NUMBER = PA_BUILDING_BLOCK_OVN(i)
1622: AND pa_measure(i) = 0
1623: AND pa_deleted(i) = 'Y'