eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RDB_PROCESS_DETAILS

Line 1899: INSERT INTO hxc_rdb_process_details

1895: g_temp_tc_list.DELETE;
1896:
1897:
1898: FORALL i IN l_skipped_tc_id.FIRST..l_skipped_tc_id.LAST
1899: INSERT INTO hxc_rdb_process_details
1900: ( timecard_id,
1901: detail_id,
1902: detail_ovn,
1903: skipped_reason,

Line 2819: UPDATE hxc_rdb_process_details

2815:
2816: -- Bug : 9948863
2817: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST ..
2818: hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
2819: UPDATE hxc_rdb_process_details
2820: SET skipped_reason = SUBSTR(hxc_generic_retrieval_pkg.t_tx_error_exception
2821: (tx_error),1,149),
2822: skip_level = 'REC_PROC'
2823: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_error_bb_id

Line 8677: INSERT INTO hxc_rdb_process_details

8673:
8674: g_temp_tc_list.DELETE;
8675:
8676: FORALL i IN l_skipped_tc_id.FIRST..l_skipped_tc_id.LAST
8677: INSERT INTO hxc_rdb_process_details
8678: ( timecard_id,
8679: detail_id,
8680: detail_ovn,
8681: skipped_reason,

Line 8804: INSERT INTO hxc_rdb_process_details

8800: 'PROCESSING_PARTIAL');
8801: g_temp_tc_list.DELETE;
8802:
8803: FORALL i IN l_skipped_tc_id.FIRST..l_skipped_tc_id.LAST
8804: INSERT INTO hxc_rdb_process_details
8805: ( timecard_id,
8806: detail_id,
8807: detail_ovn,
8808: skipped_reason,

Line 9440: DELETE FROM hxc_rdb_process_details

9436:
9437:
9438: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9439: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9440: DELETE FROM hxc_rdb_process_details
9441: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9442: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9443: (tx_error) = 'SUCCESS'
9444: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 9458: UPDATE hxc_rdb_process_details

9454:
9455: -- Bug : 9948863
9456: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9457: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9458: UPDATE hxc_rdb_process_details
9459: SET skip_level = 'REC_PROC',
9460: skipped_reason = SUBSTR(hxc_generic_retrieval_pkg.t_tx_detail_exception
9461: (tx_error),1,149)
9462: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)

Line 9877: DELETE FROM hxc_rdb_process_details

9873: -- Follows the same logic as Projects Application above.
9874:
9875: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9876: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9877: DELETE FROM hxc_rdb_process_details
9878: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9879: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9880: (tx_error) = 'SUCCESS'
9881: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 9916: UPDATE hxc_rdb_process_details

9912:
9913: -- Bug : 9948863
9914: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9915: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9916: UPDATE hxc_rdb_process_details
9917: SET skip_level = 'REC_PROC',
9918: skipped_reason = SUBSTR(hxc_generic_retrieval_pkg.t_tx_detail_exception
9919: (tx_error),1,149)
9920: WHERE detail_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)