APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_TRANSACTION_DETAILS

Line 1631: hxc_transaction_details htd,

1627: htd.transaction_detail_id,
1628: ht.transaction_id
1629: FROM hxc_ret_pay_latest_details latest,
1630: hxc_ret_pay_details det,
1631: hxc_transaction_details htd,
1632: hxc_transactions ht
1633: WHERE det.timecard_id = p_timecard_id
1634: AND det.batch_id = p_batch_id
1635: AND det.retro_batch_id = p_retro_batch_id

Line 1682: hxc_transaction_details htd,

1678: htd.transaction_detail_id,
1679: ht.transaction_id
1680: FROM hxc_ret_pay_latest_details latest,
1681: hxc_ret_pay_details det,
1682: hxc_transaction_details htd,
1683: hxc_transactions ht
1684: WHERE det.timecard_id = p_timecard_id
1685: AND det.batch_id = p_batch_id
1686: AND det.retro_batch_id IS NULL

Line 1733: hxc_transaction_details htd,

1729: htd.transaction_detail_id,
1730: ht.transaction_id
1731: FROM hxc_ret_pay_latest_details latest,
1732: hxc_ret_pay_details det,
1733: hxc_transaction_details htd,
1734: hxc_transactions ht
1735: WHERE det.timecard_id = p_timecard_id
1736: AND det.batch_id IS NULL
1737: AND det.retro_batch_id = p_retro_batch_id

Line 2040: UPDATE hxc_transaction_details

2036: THEN
2037:
2038: display_numtab('Transaction Details',l_lines_trans_id);
2039: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2040: UPDATE hxc_transaction_details
2041: SET status = 'ROLLEDBACK',
2042: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2043: WHERE transaction_detail_id = l_lines_trans_id(i);
2044:

Line 2194: UPDATE hxc_transaction_details

2190:
2191:
2192: display_numtab('Transaction Details',l_lines_trans_id);
2193: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2194: UPDATE hxc_transaction_details
2195: SET status = 'ROLLEDBACK',
2196: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2197: WHERE transaction_detail_id = l_lines_td_id(i);
2198:

Line 2331: UPDATE hxc_transaction_details

2327: THEN
2328:
2329: display_numtab('Transaction Details',l_lines_trans_id);
2330: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2331: UPDATE hxc_transaction_details
2332: SET status = 'ROLLEDBACK',
2333: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
2334: WHERE transaction_detail_id = l_lines_td_id(i);
2335:

Line 2658: hxc_transaction_details htd,

2654: det.retro_pbl_id,
2655: det.timecard_id,
2656: htd.transaction_detail_id
2657: FROM hxc_ret_pay_details det,
2658: hxc_transaction_details htd,
2659: hxc_transactions ht
2660: WHERE det.timecard_id = p_timecard_id
2661: AND det.time_building_block_id = htd.time_building_block_id
2662: AND det.object_version_number = htd.time_building_block_ovn

Line 3047: UPDATE hxc_transaction_details

3043:
3044:
3045: display_numtab('Transaction Details',l_tc_data_td_id);
3046: FORALL i IN l_tc_data_td_id.FIRST..l_tc_data_td_id.LAST
3047: UPDATE hxc_transaction_details
3048: SET status = 'ROLLEDBACK',
3049: exception_description = 'Rollback Request:'||FND_GLOBAL.conc_request_id
3050: WHERE transaction_detail_id = l_tc_data_td_id(i);
3051: