APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_TRANSACTIONS

Line 1749: hxc_transactions ht

1745: det.detail_bb_ovn
1746: FROM hxc_rpt_tc_details_all det,
1747: hxc_rpt_tc_resource_temp gt,
1748: hxc_transaction_details htd,
1749: hxc_transactions ht
1750: WHERE gt.tc_start_time = det.tc_start_time
1751: AND gt.tc_stop_time = det.tc_stop_time
1752: AND gt.resource_id = det.resource_id
1753: AND det.detail_bb_id = htd.time_building_block_id

Line 1835: -- and HXC_TRANSACTIONS to pick up all the transactions and

1831: BEGIN
1832:
1833: -- Public Procedure update_transaction_ids
1834: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1835: -- and HXC_TRANSACTIONS to pick up all the transactions and
1836: -- transaction_details for a successful deposit.
1837: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1838: -- If p_record_save is set to Y, we need to give pseudo transaction_ids
1839: -- to the working status timecards. Do it in the following way.

Line 1867: -- records in hxc_transactions, and have a transaction_id.

1863: -- Saved NULL
1864: -- Submitted 436
1865: --
1866: -- If you observe the above table, all actions except Save creates transaction
1867: -- records in hxc_transactions, and have a transaction_id.
1868: --
1869: -- We need to populate some pseudo transaction_id to the Save actions, and this
1870: -- can be done in the following way.
1871: --