APPS.HXC_TIMECARD_AUDIT dependencies on HXC_PAY_LATEST_DETAILS

Line 815: -- Updating hxc_pay_latest_details

811: business_group_id = pa_business_group_id_tab(i)
812: WHERE time_building_block_id = pa_time_building_block_id_tab(i);
813:
814: -- Bug 8888801
815: -- Updating hxc_pay_latest_details
816: -- with details specific for the application.
817: FORALL i IN pay_resource_id_tab.FIRST..pay_resource_id_tab.LAST
818: UPDATE hxc_pay_latest_details
819: SET object_version_number = pay_object_version_number_tab(i),

Line 818: UPDATE hxc_pay_latest_details

814: -- Bug 8888801
815: -- Updating hxc_pay_latest_details
816: -- with details specific for the application.
817: FORALL i IN pay_resource_id_tab.FIRST..pay_resource_id_tab.LAST
818: UPDATE hxc_pay_latest_details
819: SET object_version_number = pay_object_version_number_tab(i),
820: approval_status = pay_approval_status_tab(i),
821: application_set_id = pay_application_set_id_tab(i),
822: last_update_date = pay_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 838: INSERT INTO hxc_pay_latest_details

834: -- with details specific for the application.
835: BEGIN
836:
837: FORALL i IN pay_resource_id_tab.FIRST..pay_resource_id_tab.LAST SAVE EXCEPTIONS
838: INSERT INTO hxc_pay_latest_details
839: (
840: resource_id,
841: time_building_block_id,
842: object_version_number,

Line 1569: UPDATE hxc_pay_latest_details

1565: end if; --g_debug
1566:
1567:
1568: FORALL i IN PAY_TIME_ATTRIBUTE_ID.FIRST..PAY_TIME_ATTRIBUTE_ID.LAST
1569: UPDATE hxc_pay_latest_details
1570: SET ATTRIBUTE_CATEGORY = PAY_ATTRIBUTE_CATEGORY(i),
1571: ATTRIBUTE1 = PAY_ATTRIBUTE1(i),
1572: ATTRIBUTE2 = PAY_ATTRIBUTE2(i),
1573: ATTRIBUTE3 = PAY_ATTRIBUTE3(i),

Line 1588: DELETE FROM hxc_pay_latest_details pre

1584: -- Deleting tbb ids which are LOGICALLY DELETED in hxc_time_building_blocks
1585: -- and never retrieved. Such bb ids need not be considered for retrieval.
1586: -- and can be removed from the HXC_PAY table for upgraded retrieval.
1587: FORALL i IN PAY_TIME_ATTRIBUTE_ID.FIRST..PAY_TIME_ATTRIBUTE_ID.LAST
1588: DELETE FROM hxc_pay_latest_details pre
1589: WHERE TIME_BUILDING_BLOCK_ID = PAY_BUILDING_BLOCK_ID(i)
1590: AND OBJECT_VERSION_NUMBER = PAY_BUILDING_BLOCK_OVN(i)
1591: AND pay_measure(i) = 0
1592: AND pay_deleted(i) = 'Y'