APPS.HXC_TIMECARD_AUDIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 197: l_status hxc_time_building_blocks.approval_status%TYPE;

193: l_detail_ind PLS_INTEGER;
194:
195: l_blk_ind PLS_INTEGER;
196:
197: l_status hxc_time_building_blocks.approval_status%TYPE;
198:
199: l_org_id NUMBER;
200: l_bg_id NUMBER;
201:

Line 206: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;

202: -- Bug 8888801
203: -- Added the following datatypes and variables for
204: -- recording Apps specific details.
205:
206: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
207:
208: TYPE NUMTAB IS TABLE OF NUMBER;
209: TYPE VARCHARTAB IS TABLE OF VARCHAR2(2500);
210: TYPE DATETAB IS TABLE OF DATE;

Line 1584: -- Deleting tbb ids which are LOGICALLY DELETED in hxc_time_building_blocks

1580: AND OBJECT_VERSION_NUMBER = PAY_BUILDING_BLOCK_OVN(i);
1581:
1582:
1583: -- Bug 14543573
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

Line 1615: -- Deleting tbb ids which are LOGICALLY DELETED in hxc_time_building_blocks

1611: WHERE TIME_BUILDING_BLOCK_ID = PA_BUILDING_BLOCK_ID(i)
1612: AND OBJECT_VERSION_NUMBER = PA_BUILDING_BLOCK_OVN(i);
1613:
1614: -- Bug 14543573
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