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 515: FROM hxc_retrieval_ranges rr

511:
512: CURSOR csr_get_next_range
513: IS
514: SELECT rr.retrieval_range_id, rr.range_start, rr.range_stop
515: FROM hxc_retrieval_ranges rr
516: WHERE rr.retrieval_process_id = p_process_id
517: AND rr.transaction_id = 0
518: AND ( rr.where_clause = g_params.p_where_clause
519: OR rr.where_clause IS NULL

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

530: l_dynamic_sql VARCHAR2 (32000);
531: l_range_start NUMBER;
532: l_range_stop NUMBER;
533:
534: TYPE tab_rr_id IS TABLE OF hxc_retrieval_ranges.retrieval_range_id%TYPE
535: INDEX BY BINARY_INTEGER;
536:
537: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
538: INDEX BY BINARY_INTEGER;

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

533:
534: TYPE tab_rr_id IS TABLE OF hxc_retrieval_ranges.retrieval_range_id%TYPE
535: INDEX BY BINARY_INTEGER;
536:
537: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
538: INDEX BY BINARY_INTEGER;
539:
540: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
541: INDEX BY BINARY_INTEGER;

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

536:
537: TYPE tab_retrieval_process_id IS TABLE OF hxc_retrieval_ranges.retrieval_process_id%TYPE
538: INDEX BY BINARY_INTEGER;
539:
540: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
541: INDEX BY BINARY_INTEGER;
542:
543: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
544: INDEX BY BINARY_INTEGER;

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

539:
540: TYPE tab_range_start IS TABLE OF hxc_retrieval_ranges.range_start%TYPE
541: INDEX BY BINARY_INTEGER;
542:
543: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
544: INDEX BY BINARY_INTEGER;
545:
546: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
547: INDEX BY BINARY_INTEGER;

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

542:
543: TYPE tab_range_stop IS TABLE OF hxc_retrieval_ranges.range_stop%TYPE
544: INDEX BY BINARY_INTEGER;
545:
546: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
547: INDEX BY BINARY_INTEGER;
548:
549: TYPE tab_where_clause IS TABLE OF hxc_retrieval_ranges.where_clause%TYPE
550: INDEX BY BINARY_INTEGER;

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

545:
546: TYPE tab_seq IS TABLE OF hxc_retrieval_ranges.seq%TYPE
547: INDEX BY BINARY_INTEGER;
548:
549: TYPE tab_where_clause IS TABLE OF hxc_retrieval_ranges.where_clause%TYPE
550: INDEX BY BINARY_INTEGER;
551:
552: TYPE r_resource_id IS RECORD (
553: resource_id NUMBER (15)

Line 798: SELECT hxc_retrieval_ranges_s.NEXTVAL

794: )
795: IS
796: CURSOR csr_get_rr_id
797: IS
798: SELECT hxc_retrieval_ranges_s.NEXTVAL
799: FROM DUAL;
800:
801: l_rr_id NUMBER (15);
802: l_proc VARCHAR2 (72);

Line 837: FROM hxc_retrieval_ranges rr

833: IS
834: CURSOR csr_chk_rr
835: IS
836: SELECT 'x'
837: FROM hxc_retrieval_ranges rr
838: WHERE rr.retrieval_process_id = p_process_id
839: AND ( rr.where_clause IS NULL
840: OR rr.where_clause = g_params.p_where_clause
841: )

Line 852: FROM hxc_retrieval_ranges rr

848: WHERE tx.status = 'IN PROGRESS'
849: AND tx.TYPE = 'RETRIEVAL'
850: AND tx.transaction_process_id = p_process_id
851: AND EXISTS (SELECT 'y'
852: FROM hxc_retrieval_ranges rr
853: WHERE rr.transaction_id = tx.transaction_id
854: AND ( rr.where_clause IS NULL
855: OR rr.where_clause = g_params.p_where_clause)
856: );

Line 923: LOCK TABLE hxc_retrieval_ranges

919:
920: IF NOT hxc_generic_retrieval_pkg.g_in_loop
921: THEN
922: -- LOCK the table
923: LOCK TABLE hxc_retrieval_ranges
924: IN EXCLUSIVE MODE NOWAIT;
925:
926: IF g_debug
927: THEN

Line 1064: INSERT INTO hxc_retrieval_ranges

1060:
1061: DBMS_SQL.close_cursor (l_csr);
1062: -- now insert retrieval ranges
1063: FORALL rrx IN 1 .. x
1064: INSERT INTO hxc_retrieval_ranges
1065: (retrieval_range_id,
1066: retrieval_process_id,
1067: range_start, range_stop,
1068: seq, transaction_id, where_clause,

Line 1113: UPDATE hxc_retrieval_ranges rr

1109: hr_utility.TRACE ('FOUND range value');
1110: END IF;
1111:
1112: -- maintain range
1113: UPDATE hxc_retrieval_ranges rr
1114: SET rr.transaction_id =
1115: hxc_generic_retrieval_pkg.g_transaction_id,
1116: rr.conc_request_id = g_conc_request_id
1117: WHERE rr.retrieval_range_id = r_range.retrieval_range_id;

Line 1311: FROM hxc_retrieval_ranges rr

1307: := '
1308: SELECT /*+ ordered */
1309: tbb_latest.time_building_block_id,
1310: tbb_latest.object_version_number insert_latest
1311: FROM hxc_retrieval_ranges rr
1312: , hxc_retrieval_range_resources rrr
1313: , hxc_latest_details tbb_latest ';
1314:
1315: l_where VARCHAR2 (1500)

Line 6328: from hxc_retrieval_ranges rr,

6324: FROM
6325: (select /*+ no_merge ordered */
6326: tbb_latest.time_building_block_id,
6327: tbb_latest.object_version_number
6328: from hxc_retrieval_ranges rr,
6329: hxc_retrieval_range_resources rrr,
6330: hxc_latest_details tbb_latest
6331: where rr.retrieval_range_id = :p_rr_id AND
6332: rr.retrieval_range_id = rrr.retrieval_range_id AND

Line 6657: FROM hxc_retrieval_ranges rr

6653: p_unique_params VARCHAR2
6654: )
6655: IS
6656: SELECT 'x'
6657: FROM hxc_retrieval_ranges rr
6658: WHERE rr.transaction_id = p_transaction_id
6659: AND ( rr.where_clause = p_where_clause
6660: OR (p_where_clause IS NULL AND rr.where_clause IS NULL)
6661: )

Line 6670: FROM hxc_retrieval_ranges

6666:
6667: CURSOR csr_chk_range_exists (p_transaction_id NUMBER)
6668: IS
6669: SELECT TO_CHAR (SYSDATE, 'HH24:MI:SS DD-MON-YY')
6670: FROM hxc_retrieval_ranges
6671: WHERE transaction_id = p_transaction_id;
6672:
6673: l_transaction_id hxc_transactions.transaction_id%TYPE;
6674: l_bee_ok VARCHAR2 (1);

Line 7788: FROM HXC_RETRIEVAL_RANGES

7784:
7785: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES
7786: WHERE RETRIEVAL_RANGE_ID IN
7787: ( SELECT RETRIEVAL_RANGE_ID
7788: FROM HXC_RETRIEVAL_RANGES
7789: WHERE CONC_REQUEST_ID = g_conc_request_id
7790: AND TRANSACTION_ID = p_transaction_id);
7791:
7792: DELETE FROM HXC_RETRIEVAL_RANGES

Line 7792: DELETE FROM HXC_RETRIEVAL_RANGES

7788: FROM HXC_RETRIEVAL_RANGES
7789: WHERE CONC_REQUEST_ID = g_conc_request_id
7790: AND TRANSACTION_ID = p_transaction_id);
7791:
7792: DELETE FROM HXC_RETRIEVAL_RANGES
7793: WHERE CONC_REQUEST_ID = g_conc_request_id
7794: AND TRANSACTION_ID = p_transaction_id;
7795:
7796: COMMIT;

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

8128: THEN
8129: hr_utility.set_location ('Processing ' || l_proc, 170);
8130: END IF;
8131:
8132: -- need to clean up the hxc retrieval ranges table if the process
8133: -- has errored.
8134: IF (p_status = 'ERRORS')
8135: THEN
8136: UPDATE hxc_retrieval_ranges

Line 8136: UPDATE hxc_retrieval_ranges

8132: -- need to clean up the hxc retrieval ranges table if the process
8133: -- has errored.
8134: IF (p_status = 'ERRORS')
8135: THEN
8136: UPDATE hxc_retrieval_ranges
8137: SET transaction_id = -1
8138: WHERE retrieval_process_id = l_process_id AND transaction_id = -1;
8139: END IF;
8140: END IF; -- p_status = 'ERRORS'