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_RETRIEVAL_RANGES

Line 530: FROM hxc_retrieval_ranges rr

526:
527: CURSOR csr_get_next_range
528: IS
529: SELECT rr.retrieval_range_id, rr.range_start, rr.range_stop
530: FROM hxc_retrieval_ranges rr
531: WHERE rr.retrieval_process_id = p_process_id
532: AND rr.transaction_id = 0
533: AND ( rr.where_clause = g_params.p_where_clause
534: OR rr.where_clause IS NULL

Line 549: TYPE tab_rr_id IS TABLE OF hxc_retrieval_ranges.retrieval_range_id%TYPE

545: l_dynamic_sql VARCHAR2 (32000);
546: l_range_start NUMBER;
547: l_range_stop NUMBER;
548:
549: TYPE tab_rr_id IS TABLE OF hxc_retrieval_ranges.retrieval_range_id%TYPE
550: INDEX BY BINARY_INTEGER;
551:
552: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
553: INDEX BY BINARY_INTEGER;

Line 552: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE

548:
549: TYPE tab_rr_id IS TABLE OF hxc_retrieval_ranges.retrieval_range_id%TYPE
550: INDEX BY BINARY_INTEGER;
551:
552: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
553: INDEX BY BINARY_INTEGER;
554:
555: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
556: INDEX BY BINARY_INTEGER;

Line 555: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE

551:
552: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
553: INDEX BY BINARY_INTEGER;
554:
555: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
556: INDEX BY BINARY_INTEGER;
557:
558: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
559: INDEX BY BINARY_INTEGER;

Line 558: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE

554:
555: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
556: INDEX BY BINARY_INTEGER;
557:
558: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
559: INDEX BY BINARY_INTEGER;
560:
561: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
562: INDEX BY BINARY_INTEGER;

Line 561: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE

557:
558: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
559: INDEX BY BINARY_INTEGER;
560:
561: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
562: INDEX BY BINARY_INTEGER;
563:
564: TYPE tab_where_clause IS TABLE OF hxc_retrieval_ranges.where_clause%TYPE
565: INDEX BY BINARY_INTEGER;

Line 564: TYPE tab_where_clause IS TABLE OF hxc_retrieval_ranges.where_clause%TYPE

560:
561: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
562: INDEX BY BINARY_INTEGER;
563:
564: TYPE tab_where_clause IS TABLE OF hxc_retrieval_ranges.where_clause%TYPE
565: INDEX BY BINARY_INTEGER;
566:
567: TYPE r_resource_id IS RECORD (
568: resource_id NUMBER (15)

Line 1211: SELECT hxc_retrieval_ranges_s.NEXTVAL

1207: )
1208: IS
1209: CURSOR csr_get_rr_id
1210: IS
1211: SELECT hxc_retrieval_ranges_s.NEXTVAL
1212: FROM DUAL;
1213:
1214: l_rr_id NUMBER (15);
1215: l_proc VARCHAR2 (72);

Line 1257: FROM hxc_retrieval_ranges rr

1253: IS
1254: CURSOR csr_chk_rr
1255: IS
1256: SELECT 'x'
1257: FROM hxc_retrieval_ranges rr
1258: WHERE rr.retrieval_process_id = p_process_id
1259: AND ( rr.where_clause IS NULL
1260: OR rr.where_clause = g_params.p_where_clause
1261: )

Line 1272: FROM hxc_retrieval_ranges rr

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'
1272: FROM hxc_retrieval_ranges rr
1273: WHERE rr.transaction_id = tx.transaction_id
1274: AND ( rr.where_clause IS NULL
1275: OR rr.where_clause = g_params.p_where_clause)
1276: );

Line 1343: LOCK TABLE hxc_retrieval_ranges

1339:
1340: IF NOT hxc_generic_retrieval_pkg.g_in_loop
1341: THEN
1342: -- LOCK the table
1343: LOCK TABLE hxc_retrieval_ranges
1344: IN EXCLUSIVE MODE NOWAIT;
1345:
1346: IF g_debug
1347: THEN

Line 1490: INSERT INTO hxc_retrieval_ranges

1486:
1487: DBMS_SQL.close_cursor (l_csr);
1488: -- now insert retrieval ranges
1489: FORALL rrx IN 1 .. x
1490: INSERT INTO hxc_retrieval_ranges
1491: (retrieval_range_id,
1492: retrieval_process_id,
1493: range_start, range_stop,
1494: seq, transaction_id, where_clause,

Line 1539: UPDATE hxc_retrieval_ranges rr

1535: hr_utility.TRACE ('FOUND range value');
1536: END IF;
1537:
1538: -- maintain range
1539: UPDATE hxc_retrieval_ranges rr
1540: SET rr.transaction_id =
1541: hxc_generic_retrieval_pkg.g_transaction_id,
1542: rr.conc_request_id = g_conc_request_id
1543: WHERE rr.retrieval_range_id = r_range.retrieval_range_id;

Line 1739: FROM hxc_retrieval_ranges rr

1735: := '
1736: SELECT /*+ ordered */
1737: tbb_latest.time_building_block_id,
1738: tbb_latest.object_version_number insert_latest
1739: FROM hxc_retrieval_ranges rr
1740: , hxc_retrieval_range_resources rrr
1741: , hxc_latest_details tbb_latest ';
1742:
1743: -- Bug 9394444

Line 1751: FROM hxc_retrieval_ranges rr

1747: := '
1748: SELECT /*+ ordered */
1749: tbb_latest.time_building_block_id,
1750: tbb_latest.object_version_number insert_latest
1751: FROM hxc_retrieval_ranges rr
1752: , hxc_retrieval_range_resources rrr
1753: , hxc_pa_latest_details tbb_latest ';
1754:
1755: l_select_from_pay VARCHAR2 (250)

Line 1760: FROM hxc_retrieval_ranges rr

1756: := '
1757: SELECT /*+ ordered */
1758: tbb_latest.time_building_block_id,
1759: tbb_latest.object_version_number insert_latest
1760: FROM hxc_retrieval_ranges rr
1761: , hxc_retrieval_range_resources rrr
1762: , hxc_pay_latest_details tbb_latest ';
1763:
1764:

Line 7112: from hxc_retrieval_ranges rr,

7108: FROM
7109: (select /*+ no_merge ordered */
7110: tbb_latest.time_building_block_id,
7111: tbb_latest.object_version_number
7112: from hxc_retrieval_ranges rr,
7113: hxc_retrieval_range_resources rrr,
7114: hxc_latest_details tbb_latest
7115: where rr.retrieval_range_id = :p_rr_id AND
7116: rr.retrieval_range_id = rrr.retrieval_range_id AND

Line 7139: from hxc_retrieval_ranges rr,

7135: FROM
7136: (select /*+ no_merge ordered */
7137: tbb_latest.time_building_block_id,
7138: tbb_latest.object_version_number
7139: from hxc_retrieval_ranges rr,
7140: hxc_retrieval_range_resources rrr,
7141: hxc_pa_latest_details tbb_latest
7142: where rr.retrieval_range_id = :p_rr_id AND
7143: rr.retrieval_range_id = rrr.retrieval_range_id AND

Line 7166: from hxc_retrieval_ranges rr,

7162: FROM
7163: (select /*+ no_merge ordered */
7164: tbb_latest.time_building_block_id,
7165: tbb_latest.object_version_number
7166: from hxc_retrieval_ranges rr,
7167: hxc_retrieval_range_resources rrr,
7168: hxc_pay_latest_details tbb_latest
7169: where rr.retrieval_range_id = :p_rr_id AND
7170: rr.retrieval_range_id = rrr.retrieval_range_id AND

Line 7540: FROM hxc_retrieval_ranges rr

7536: p_unique_params VARCHAR2
7537: )
7538: IS
7539: SELECT 'x'
7540: FROM hxc_retrieval_ranges rr
7541: WHERE rr.transaction_id = p_transaction_id
7542: AND ( rr.where_clause = p_where_clause
7543: OR (p_where_clause IS NULL AND rr.where_clause IS NULL)
7544: )

Line 7553: FROM hxc_retrieval_ranges

7549:
7550: CURSOR csr_chk_range_exists (p_transaction_id NUMBER)
7551: IS
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);

Line 8893: FROM HXC_RETRIEVAL_RANGES

8889:
8890: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES
8891: WHERE RETRIEVAL_RANGE_ID IN
8892: ( SELECT RETRIEVAL_RANGE_ID
8893: FROM HXC_RETRIEVAL_RANGES
8894: WHERE CONC_REQUEST_ID = g_conc_request_id
8895: AND TRANSACTION_ID = p_transaction_id);
8896:
8897: DELETE FROM HXC_RETRIEVAL_RANGES

Line 8897: DELETE FROM HXC_RETRIEVAL_RANGES

8893: FROM HXC_RETRIEVAL_RANGES
8894: WHERE CONC_REQUEST_ID = g_conc_request_id
8895: AND TRANSACTION_ID = p_transaction_id);
8896:
8897: DELETE FROM HXC_RETRIEVAL_RANGES
8898: WHERE CONC_REQUEST_ID = g_conc_request_id
8899: AND TRANSACTION_ID = p_transaction_id;
8900:
8901: COMMIT;

Line 10043: -- need to clean up the hxc retrieval ranges table if the process

10039: THEN
10040: hr_utility.set_location ('Processing ' || l_proc, 170);
10041: END IF;
10042:
10043: -- need to clean up the hxc retrieval ranges table if the process
10044: -- has errored.
10045: IF (p_status = 'ERRORS')
10046: THEN
10047: UPDATE hxc_retrieval_ranges

Line 10047: UPDATE hxc_retrieval_ranges

10043: -- need to clean up the hxc retrieval ranges table if the process
10044: -- has errored.
10045: IF (p_status = 'ERRORS')
10046: THEN
10047: UPDATE hxc_retrieval_ranges
10048: SET transaction_id = -1
10049: WHERE retrieval_process_id = l_process_id AND transaction_id = -1;
10050: END IF;
10051: END IF; -- p_status = 'ERRORS'