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_RETRIEVE_ABSENCES dependencies on HXC_TRANSACTIONS

Line 2389: IS SELECT hxc_transactions_s.NEXTVAL

2385: l_transaction_id NUMBER;
2386: l_retrieval_process_id NUMBER;
2387:
2388: CURSOR c_transaction_sequence
2389: IS SELECT hxc_transactions_s.NEXTVAL
2390: FROM DUAL;
2391:
2392: BEGIN
2393:

Line 2404: INSERT INTO hxc_transactions

2400: FETCH c_transaction_sequence INTO l_transaction_id;
2401: CLOSE c_transaction_sequence;
2402:
2403:
2404: INSERT INTO hxc_transactions
2405: (transaction_id
2406: ,transaction_date
2407: ,type
2408: ,transaction_process_id

Line 2820: hxc_transactions ht

2816: CURSOR get_transactions( p_bb_id IN NUMBER,
2817: p_bb_ovn IN NUMBER)
2818: IS SELECT htd.time_building_block_ovn
2819: FROM hxc_transaction_details htd,
2820: hxc_transactions ht
2821: WHERE htd.time_building_block_id = p_bb_id
2822: AND htd.time_building_block_ovn <= p_bb_ovn
2823: AND htd.transaction_id = ht.transaction_id
2824: AND ht.type = 'RETRIEVAL'