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

Line 21: g_transaction_id hxc_transactions.transaction_id%TYPE := NULL;

17: g_success_delete_msg VARCHAR2 (100):= 'This absence detail was successfully deleted in Absences module';
18: g_fail_create_msg VARCHAR2 (50) := ' (Online Retrieval Failed)';
19: g_business_group_id NUMBER := NULL;
20: g_error_message VARCHAR2(50) := NULL;
21: g_transaction_id hxc_transactions.transaction_id%TYPE := NULL;
22:
23: PROCEDURE post_absences (p_resource_id IN NUMBER,
24: p_tc_start IN DATE,
25: p_tc_stop IN DATE,

Line 113: INDEX(ht HXC_TRANSACTIONS_PK)

109: AND TRUNC (absco.stop_time) <= TRUNC (g_tc_stop)
110: AND absco.stage <> 'RET'
111: AND
112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
113: INDEX(ht HXC_TRANSACTIONS_PK)
114: INDEX(ht HXC_TRANSACTIONS_N3) */
115: 1
116: FROM hxc_transaction_details htd, hxc_transactions ht
117: WHERE absco.time_building_block_id = htd.time_building_block_id

Line 114: INDEX(ht HXC_TRANSACTIONS_N3) */

110: AND absco.stage <> 'RET'
111: AND
112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
113: INDEX(ht HXC_TRANSACTIONS_PK)
114: INDEX(ht HXC_TRANSACTIONS_N3) */
115: 1
116: FROM hxc_transaction_details htd, hxc_transactions ht
117: WHERE absco.time_building_block_id = htd.time_building_block_id
118: AND htd.transaction_id = ht.transaction_id

Line 116: FROM hxc_transaction_details htd, hxc_transactions ht

112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
113: INDEX(ht HXC_TRANSACTIONS_PK)
114: INDEX(ht HXC_TRANSACTIONS_N3) */
115: 1
116: FROM hxc_transaction_details htd, hxc_transactions ht
117: WHERE absco.time_building_block_id = htd.time_building_block_id
118: AND htd.transaction_id = ht.transaction_id
119: AND ht.transaction_process_id = g_retrieval_process_id
120: AND ht.TYPE = 'RETRIEVAL'

Line 295: -- Added hxc_transactions and details in the below query to

291: -- Added the following code to delete Absences prepopulated
292: -- earlier from the retrieval table.
293:
294: -- Bug 9688040
295: -- Added hxc_transactions and details in the below query to
296: -- avoid issues with prepop and edited(or from SS) absences.
297:
298: IF g_abs_integ_enabled = 'Y'
299: THEN

Line 306: hxc_transactions ht

302: IN ( SELECT co.time_building_block_id,
303: co.object_version_number
304: FROM hxc_abs_co_details co,
305: hxc_transaction_details htd,
306: hxc_transactions ht
307: WHERE co.resource_id = g_resource_id
308: AND co.start_time = g_tc_start
309: AND TRUNC(co.stop_time) = TRUNC(g_tc_stop)
310: AND htd.time_building_block_id = co.time_building_block_id

Line 411: INDEX(ht HXC_TRANSACTIONS_PK)

407: AND hta.attribute_category like 'ELEMENT - %'
408: AND to_number(SUBSTR(hta.attribute_category, 11)) = hate.element_type_id
409: AND NOT EXISTS (
410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
411: INDEX(ht HXC_TRANSACTIONS_PK)
412: INDEX(ht HXC_TRANSACTIONS_N3) */
413: 1
414: FROM hxc_transaction_details htd, hxc_transactions ht
415: WHERE latest.time_building_block_id = htd.time_building_block_id

Line 412: INDEX(ht HXC_TRANSACTIONS_N3) */

408: AND to_number(SUBSTR(hta.attribute_category, 11)) = hate.element_type_id
409: AND NOT EXISTS (
410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
411: INDEX(ht HXC_TRANSACTIONS_PK)
412: INDEX(ht HXC_TRANSACTIONS_N3) */
413: 1
414: FROM hxc_transaction_details htd, hxc_transactions ht
415: WHERE latest.time_building_block_id = htd.time_building_block_id
416: AND latest.object_version_number = htd.time_building_block_ovn

Line 414: FROM hxc_transaction_details htd, hxc_transactions ht

410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
411: INDEX(ht HXC_TRANSACTIONS_PK)
412: INDEX(ht HXC_TRANSACTIONS_N3) */
413: 1
414: FROM hxc_transaction_details htd, hxc_transactions ht
415: WHERE latest.time_building_block_id = htd.time_building_block_id
416: AND latest.object_version_number = htd.time_building_block_ovn
417: AND htd.transaction_id = ht.transaction_id
418: AND ht.transaction_process_id = g_retrieval_process_id

Line 462: INDEX(ht HXC_TRANSACTIONS_PK)

458: AND absco.absence_attendance_id IS NOT NULL
459: AND detail.time_building_block_id = absco.time_building_block_id
460: AND detail.object_version_number =
461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
462: INDEX(ht HXC_TRANSACTIONS_PK)
463: INDEX(ht HXC_TRANSACTIONS_N3) */
464: MAX (htd.time_building_block_ovn)
465: FROM hxc_transactions ht, hxc_transaction_details htd
466: WHERE ht.transaction_process_id = g_retrieval_process_id

Line 463: INDEX(ht HXC_TRANSACTIONS_N3) */

459: AND detail.time_building_block_id = absco.time_building_block_id
460: AND detail.object_version_number =
461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
462: INDEX(ht HXC_TRANSACTIONS_PK)
463: INDEX(ht HXC_TRANSACTIONS_N3) */
464: MAX (htd.time_building_block_ovn)
465: FROM hxc_transactions ht, hxc_transaction_details htd
466: WHERE ht.transaction_process_id = g_retrieval_process_id
467: AND htd.time_building_block_id = absco.time_building_block_id

Line 465: FROM hxc_transactions ht, hxc_transaction_details htd

461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
462: INDEX(ht HXC_TRANSACTIONS_PK)
463: INDEX(ht HXC_TRANSACTIONS_N3) */
464: MAX (htd.time_building_block_ovn)
465: FROM hxc_transactions ht, hxc_transaction_details htd
466: WHERE ht.transaction_process_id = g_retrieval_process_id
467: AND htd.time_building_block_id = absco.time_building_block_id
468: AND htd.transaction_id = ht.transaction_id
469: AND htd.status = 'SUCCESS'

Line 2363: p_transaction_id OUT NOCOPY hxc_transactions.transaction_id%TYPE

2359:
2360: PROCEDURE insert_audit_header (
2361: p_status IN VARCHAR2,
2362: p_description IN VARCHAR2,
2363: p_transaction_id OUT NOCOPY hxc_transactions.transaction_id%TYPE
2364: )
2365: IS
2366: CURSOR c_transaction_sequence
2367: IS

Line 2368: SELECT hxc_transactions_s.NEXTVAL

2364: )
2365: IS
2366: CURSOR c_transaction_sequence
2367: IS
2368: SELECT hxc_transactions_s.NEXTVAL
2369: FROM DUAL;
2370:
2371: BEGIN
2372: OPEN c_transaction_sequence;

Line 2379: INSERT INTO hxc_transactions

2375: INTO g_transaction_id;
2376:
2377: CLOSE c_transaction_sequence;
2378:
2379: INSERT INTO hxc_transactions
2380: (transaction_id,
2381: transaction_date,
2382: TYPE,
2383: transaction_process_id,

Line 2418: p_transaction_id IN hxc_transactions.transaction_id%TYPE

2414: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,
2415: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,
2416: p_status IN VARCHAR2 DEFAULT NULL,
2417: p_description IN VARCHAR2 DEFAULT NULL,
2418: p_transaction_id IN hxc_transactions.transaction_id%TYPE
2419: )
2420: IS
2421: CURSOR c_transaction_detail_sequence
2422: IS