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_TRANSACTIONS

Line 7: p_transaction_code hxc_transactions.transaction_code%TYPE,

3:
4: -- global package data type and variables
5: TYPE r_parameters IS RECORD (
6: p_process hxc_retrieval_processes.NAME%TYPE,
7: p_transaction_code hxc_transactions.transaction_code%TYPE,
8: p_start_date DATE,
9: p_end_date DATE,
10: p_incremental VARCHAR2 (1),
11: p_rerun_flag VARCHAR2 (1),

Line 122: SELECT hxc_transactions_s.NEXTVAL

118:
119: -- package cursor
120: CURSOR csr_get_tx_id
121: IS
122: SELECT hxc_transactions_s.NEXTVAL
123: FROM SYS.DUAL;
124:
125: -- Bug 9346163
126: -- Rewrote the cursor to pick nextval(s) from the sequence.

Line 1267: FROM hxc_transactions tx

1263:
1264: CURSOR csr_chk_tx
1265: IS
1266: SELECT 'x'
1267: FROM hxc_transactions tx
1268: WHERE tx.status = 'IN PROGRESS'
1269: AND tx.TYPE = 'RETRIEVAL'
1270: AND tx.transaction_process_id = p_process_id
1271: AND EXISTS (SELECT 'y'

Line 1795: AND NOT EXISTS (select /*+ INDEX(tx HXC_TRANSACTIONS_PK)

1791: -- Removed the ORDERED hint
1792: -- and forced the index.
1793: l_not_exists VARCHAR2 (550)
1794: := '
1795: AND NOT EXISTS (select /*+ INDEX(tx HXC_TRANSACTIONS_PK)
1796: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)*/
1797: ''x''
1798: FROM hxc_transactions tx
1799: , hxc_transaction_details txd

Line 1798: FROM hxc_transactions tx

1794: := '
1795: AND NOT EXISTS (select /*+ INDEX(tx HXC_TRANSACTIONS_PK)
1796: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)*/
1797: ''x''
1798: FROM hxc_transactions tx
1799: , hxc_transaction_details txd
1800: WHERE tx.transaction_process_id = :p_process_id
1801: AND tx.type = ''RETRIEVAL''
1802: AND tx.status = ''SUCCESS''

Line 2185: INDEX(TX HXC_TRANSACTIONS_PK)

2181: CURSOR csr_get_max_ovn_rrb (p_retrieval_process_id NUMBER)
2182: IS
2183: SELECT /*+ ORDERED
2184: INDEX(TXD HXC_TRANSACTION_DETAILS_FK1)
2185: INDEX(TX HXC_TRANSACTIONS_PK)
2186: USE_NL(TXD, TX) */
2187: txd.time_building_block_id,
2188: NVL (MAX (txd.time_building_block_ovn), 0)
2189: FROM hxc_retrieval_range_blks rrb,

Line 2191: hxc_transactions tx

2187: txd.time_building_block_id,
2188: NVL (MAX (txd.time_building_block_ovn), 0)
2189: FROM hxc_retrieval_range_blks rrb,
2190: hxc_transaction_details txd,
2191: hxc_transactions tx
2192: WHERE tx.transaction_process_id = p_retrieval_process_id
2193: AND tx.TYPE = 'RETRIEVAL'
2194: AND tx.status = 'SUCCESS'
2195: AND tx.transaction_id = txd.transaction_id

Line 2210: FROM hxc_transaction_details txd, hxc_transactions tx

2206: )
2207: IS
2208: SELECT txd.time_building_block_id,
2209: NVL (MAX (txd.time_building_block_ovn), 0)
2210: FROM hxc_transaction_details txd, hxc_transactions tx
2211: WHERE tx.transaction_process_id = p_retrieval_process_id
2212: AND tx.TYPE = 'RETRIEVAL'
2213: AND tx.status = 'SUCCESS'
2214: AND tx.transaction_id = txd.transaction_id

Line 2234: FROM hxc_transaction_details txd, hxc_transactions tx

2230: CURSOR csr_get_max_ovn (p_retrieval_process_id NUMBER, p_since_date DATE)
2231: IS
2232: SELECT txd.time_building_block_id,
2233: NVL (MAX (txd.time_building_block_ovn), 0)
2234: FROM hxc_transaction_details txd, hxc_transactions tx
2235: WHERE tx.transaction_process_id = p_retrieval_process_id
2236: AND tx.TYPE = 'RETRIEVAL'
2237: AND tx.status = 'SUCCESS'
2238: AND tx.transaction_id = txd.transaction_id

Line 2443: l_tx_id hxc_transactions.transaction_id%TYPE;

2439: p_rollback IN BOOLEAN DEFAULT FALSE
2440: )
2441: IS
2442: PRAGMA AUTONOMOUS_TRANSACTION;
2443: l_tx_id hxc_transactions.transaction_id%TYPE;
2444: l_time_max INTEGER;
2445: l_day_max INTEGER;
2446: l_detail_max INTEGER;
2447: l_error_max INTEGER;

Line 2484: UPDATE hxc_transactions

2480: hr_utility.set_location ('Processing ' || l_proc, 7);
2481: END IF;
2482:
2483: -- already inserted - lets update it!
2484: UPDATE hxc_transactions
2485: SET status = p_status,
2486: exception_description = p_description
2487: WHERE transaction_id = hxc_generic_retrieval_pkg.g_transaction_id;
2488: ELSE

Line 2506: INSERT INTO hxc_transactions

2502: THEN
2503: hr_utility.set_location ('Processing ' || l_proc, 30);
2504: END IF;
2505:
2506: INSERT INTO hxc_transactions
2507: (transaction_id,
2508: transaction_process_id, transaction_date,
2509: transaction_code,
2510: TYPE, status, exception_description

Line 2600: INSERT INTO hxc_transactions

2596: INTO l_tx_id;
2597:
2598: CLOSE csr_get_tx_id;
2599:
2600: INSERT INTO hxc_transactions
2601: (transaction_id, transaction_process_id,
2602: transaction_date, TYPE, status,
2603: exception_description
2604: )

Line 2614: UPDATE hxc_transactions

2610: IF (p_description IS NULL OR p_description LIKE '%ORA-20001%')
2611: THEN
2612: -- insure we do not write over a meaningful excpetion already
2613: -- set within the retrieval
2614: UPDATE hxc_transactions
2615: SET status = p_status
2616: WHERE transaction_id = hxc_generic_retrieval_pkg.g_transaction_id;
2617: ELSE
2618: -- record the proper exception most likely thrown by the recipient

Line 2620: UPDATE hxc_transactions

2616: WHERE transaction_id = hxc_generic_retrieval_pkg.g_transaction_id;
2617: ELSE
2618: -- record the proper exception most likely thrown by the recipient
2619: -- application code
2620: UPDATE hxc_transactions
2621: SET status = p_status,
2622: exception_description = p_description
2623: WHERE transaction_id = hxc_generic_retrieval_pkg.g_transaction_id;
2624: END IF;

Line 7047: , hxc_transactions tx

7043: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7044: and tbb_latest.approval_status <> ''ERROR''
7045: AND NOT EXISTS (select ''x''
7046: FROM hxc_transaction_details txd
7047: , hxc_transactions tx
7048: WHERE tx.transaction_process_id = :p_process_id
7049: AND tx.type = ''RETRIEVAL''
7050: AND tx.status = ''SUCCESS''
7051: AND tx.transaction_id = txd.transaction_id

Line 7071: , hxc_transactions tx

7067: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7068: and tbb_latest.approval_status <> ''ERROR''
7069: AND NOT EXISTS (select ''x''
7070: FROM hxc_transaction_details txd
7071: , hxc_transactions tx
7072: WHERE tx.transaction_process_id = :p_process_id
7073: AND tx.type = ''RETRIEVAL''
7074: AND tx.status = ''SUCCESS''
7075: AND tx.transaction_id = txd.transaction_id

Line 7093: , hxc_transactions tx

7089: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7090: and tbb_latest.approval_status <> ''ERROR''
7091: AND NOT EXISTS (select ''x''
7092: FROM hxc_transaction_details txd
7093: , hxc_transactions tx
7094: WHERE tx.transaction_process_id = :p_process_id
7095: AND tx.type = ''RETRIEVAL''
7096: AND tx.status = ''SUCCESS''
7097: AND tx.transaction_id = txd.transaction_id

Line 7122: , hxc_transactions tx

7118: tbb_latest.last_update_date > :p_since_date
7119: AND tbb_latest.approval_status <> ''ERROR''
7120: AND NOT EXISTS (select ''x''
7121: FROM hxc_transaction_details txd
7122: , hxc_transactions tx
7123: WHERE tx.transaction_process_id = :p_process_id
7124: AND tx.type = ''RETRIEVAL''
7125: AND tx.status = ''SUCCESS''
7126: AND tx.transaction_id = txd.transaction_id

Line 7149: , hxc_transactions tx

7145: tbb_latest.last_update_date > :p_since_date
7146: AND tbb_latest.approval_status <> ''ERROR''
7147: AND NOT EXISTS (select ''x''
7148: FROM hxc_transaction_details txd
7149: , hxc_transactions tx
7150: WHERE tx.transaction_process_id = :p_process_id
7151: AND tx.type = ''RETRIEVAL''
7152: AND tx.status = ''SUCCESS''
7153: AND tx.transaction_id = txd.transaction_id

Line 7176: , hxc_transactions tx

7172: tbb_latest.last_update_date > :p_since_date
7173: AND tbb_latest.approval_status <> ''ERROR''
7174: AND NOT EXISTS (select ''x''
7175: FROM hxc_transaction_details txd
7176: , hxc_transactions tx
7177: WHERE tx.transaction_process_id = :p_process_id
7178: AND tx.type = ''RETRIEVAL''
7179: AND tx.status = ''SUCCESS''
7180: AND tx.transaction_id = txd.transaction_id

Line 7311: , hxc_transactions tx

7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att
7310: , hxc_transaction_details txd
7311: , hxc_transactions tx
7312: WHERE
7313: tx.transaction_code = :p_transaction_code
7314: AND
7315: txd.transaction_id = tx.transaction_id

Line 7529: FROM hxc_transactions tx

7525: IS
7526: CURSOR chk_transaction
7527: IS
7528: SELECT transaction_id
7529: FROM hxc_transactions tx
7530: WHERE transaction_process_id = p_process_id
7531: AND status = 'IN PROGRESS';
7532:
7533: CURSOR csr_chk_where_clause (

Line 7556: l_transaction_id hxc_transactions.transaction_id%TYPE;

7552: SELECT TO_CHAR (SYSDATE, 'HH24:MI:SS DD-MON-YY')
7553: FROM hxc_retrieval_ranges
7554: WHERE transaction_id = p_transaction_id;
7555:
7556: l_transaction_id hxc_transactions.transaction_id%TYPE;
7557: l_bee_ok VARCHAR2 (1);
7558: l_cnt PLS_INTEGER := 0;
7559: l_no_ranges BOOLEAN := TRUE;
7560: l_dummy VARCHAR2 (20);

Line 8885: PROCEDURE delete_retrieval_ranges (p_transaction_id IN hxc_transactions.transaction_id%TYPE)

8881: -- Gets called when the transaction is updated with either 'SUCESS' or 'DELETE'
8882: -- from update_transaction_status
8883: -- Deletes based on concurrent process id which is unique for each process
8884: -- Ref. Bug 5669202
8885: PROCEDURE delete_retrieval_ranges (p_transaction_id IN hxc_transactions.transaction_id%TYPE)
8886: IS
8887: PRAGMA AUTONOMOUS_TRANSACTION;
8888: BEGIN
8889:

Line 8925: p_status hxc_transactions.status%TYPE,

8921: -- p_exception_description - exception description
8922: -- p_rollback - is the retrieval being rolled back
8923: PROCEDURE update_transaction_status (
8924: p_process hxc_retrieval_processes.NAME%TYPE,
8925: p_status hxc_transactions.status%TYPE,
8926: p_exception_description hxc_transactions.exception_description%TYPE,
8927: p_rollback BOOLEAN DEFAULT FALSE
8928: )
8929: IS

Line 8926: p_exception_description hxc_transactions.exception_description%TYPE,

8922: -- p_rollback - is the retrieval being rolled back
8923: PROCEDURE update_transaction_status (
8924: p_process hxc_retrieval_processes.NAME%TYPE,
8925: p_status hxc_transactions.status%TYPE,
8926: p_exception_description hxc_transactions.exception_description%TYPE,
8927: p_rollback BOOLEAN DEFAULT FALSE
8928: )
8929: IS
8930: -- going to call the chk_retrieval_process procedure - do not need mapping id

Line 8933: l_tx_id hxc_transactions.transaction_id%TYPE;

8929: IS
8930: -- going to call the chk_retrieval_process procedure - do not need mapping id
8931: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
8932: l_mapping_id hxc_mappings.mapping_id%TYPE;
8933: l_tx_id hxc_transactions.transaction_id%TYPE;
8934: l_proc VARCHAR2 (72);
8935: l_time_max INTEGER;
8936: l_day_max INTEGER;
8937: l_detail_max INTEGER;

Line 9086: INSERT INTO hxc_transactions

9082: INTO l_tx_id;
9083:
9084: CLOSE csr_get_tx_id;
9085:
9086: INSERT INTO hxc_transactions
9087: (transaction_id, transaction_process_id,
9088: transaction_date, TYPE, status,
9089: exception_description
9090: )

Line 9096: UPDATE hxc_transactions

9092: SYSDATE, 'RETRIEVAL_STATUS_UPDATE', p_status,
9093: p_exception_description
9094: );
9095:
9096: UPDATE hxc_transactions
9097: SET status = p_status,
9098: exception_description = p_exception_description
9099: WHERE transaction_id = hxc_generic_retrieval_pkg.g_transaction_id;
9100: