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_TRANSACTION_DETAILS

Line 127: SELECT /+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) /

123: FROM SYS.DUAL;
124:
125: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
126: IS
127: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) */
128: hxc_transaction_details_s.NEXTVAL
129: FROM hxc_transaction_details txd
130: WHERE ROWNUM <= p_max;
131:

Line 128: hxc_transaction_details_s.NEXTVAL

124:
125: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
126: IS
127: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) */
128: hxc_transaction_details_s.NEXTVAL
129: FROM hxc_transaction_details txd
130: WHERE ROWNUM <= p_max;
131:
132: g_conc_request_id NUMBER (15);

Line 129: FROM hxc_transaction_details txd

125: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
126: IS
127: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) */
128: hxc_transaction_details_s.NEXTVAL
129: FROM hxc_transaction_details txd
130: WHERE ROWNUM <= p_max;
131:
132: g_conc_request_id NUMBER (15);
133:

Line 1340: FROM hxc_transaction_details txd

1336: :p_end_date >= tbb_latest.start_time ';
1337: l_not_exists VARCHAR2 (450)
1338: := '
1339: AND NOT EXISTS (select ''x''
1340: FROM hxc_transaction_details txd
1341: , hxc_transactions tx
1342: WHERE tx.transaction_process_id = :p_process_id
1343: AND tx.type = ''RETRIEVAL''
1344: AND tx.status = ''SUCCESS''

Line 1591: hxc_transaction_details txd,

1587: SELECT /*+ ORDERED INDEX(TXD) INDEX(TX) USE_NL(TXD, TX) */
1588: txd.time_building_block_id,
1589: NVL (MAX (txd.time_building_block_ovn), 0)
1590: FROM hxc_retrieval_range_blks rrb,
1591: hxc_transaction_details txd,
1592: hxc_transactions tx
1593: WHERE tx.transaction_process_id = p_retrieval_process_id
1594: AND tx.TYPE = 'RETRIEVAL'
1595: AND tx.status = 'SUCCESS'

Line 1611: FROM hxc_transaction_details txd, hxc_transactions tx

1607: )
1608: IS
1609: SELECT txd.time_building_block_id,
1610: NVL (MAX (txd.time_building_block_ovn), 0)
1611: FROM hxc_transaction_details txd, hxc_transactions tx
1612: WHERE tx.transaction_process_id = p_retrieval_process_id
1613: AND tx.TYPE = 'RETRIEVAL'
1614: AND tx.status = 'SUCCESS'
1615: AND tx.transaction_id = txd.transaction_id

Line 1635: FROM hxc_transaction_details txd, hxc_transactions tx

1631: CURSOR csr_get_max_ovn (p_retrieval_process_id NUMBER, p_since_date DATE)
1632: IS
1633: SELECT txd.time_building_block_id,
1634: NVL (MAX (txd.time_building_block_ovn), 0)
1635: FROM hxc_transaction_details txd, hxc_transactions tx
1636: WHERE tx.transaction_process_id = p_retrieval_process_id
1637: AND tx.TYPE = 'RETRIEVAL'
1638: AND tx.status = 'SUCCESS'
1639: AND tx.transaction_id = txd.transaction_id

Line 1951: INSERT INTO hxc_transaction_details

1947: hr_utility.set_location ('Processing ' || l_proc, 90);
1948: END IF;
1949:
1950: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
1951: INSERT INTO hxc_transaction_details
1952: (transaction_detail_id,
1953: time_building_block_id,
1954: time_building_block_ovn,
1955: transaction_id,

Line 2049: INSERT INTO hxc_transaction_details

2045: hr_utility.set_location ('Processing ' || l_proc, 50);
2046: END IF;
2047:
2048: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_time_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_time_transaction_id.LAST
2049: INSERT INTO hxc_transaction_details
2050: (transaction_detail_id,
2051: time_building_block_id,
2052: time_building_block_ovn,
2053: transaction_id,

Line 2091: INSERT INTO hxc_transaction_details

2087: hr_utility.set_location ('Processing ' || l_proc, 60);
2088: END IF;
2089:
2090: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_day_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_day_transaction_id.LAST
2091: INSERT INTO hxc_transaction_details
2092: (transaction_detail_id,
2093: time_building_block_id,
2094: time_building_block_ovn,
2095: transaction_id,

Line 2133: INSERT INTO hxc_transaction_details

2129: hr_utility.set_location ('Processing ' || l_proc, 70);
2130: END IF;
2131:
2132: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
2133: INSERT INTO hxc_transaction_details
2134: (transaction_detail_id,
2135: time_building_block_id,
2136: time_building_block_ovn,
2137: transaction_id,

Line 2189: INSERT INTO hxc_transaction_details

2185: hr_utility.set_location ('Processing ' || l_proc, 90);
2186: END IF;
2187:
2188: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
2189: INSERT INTO hxc_transaction_details
2190: (transaction_detail_id,
2191: time_building_block_id,
2192: time_building_block_ovn,
2193: transaction_id,

Line 6311: FROM hxc_transaction_details txd

6307: from Hxc_latest_details tbb_latest
6308: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
6309: and tbb_latest.approval_status <> ''ERROR''
6310: AND NOT EXISTS (select ''x''
6311: FROM hxc_transaction_details txd
6312: , hxc_transactions tx
6313: WHERE tx.transaction_process_id = :p_process_id
6314: AND tx.type = ''RETRIEVAL''
6315: AND tx.status = ''SUCCESS''

Line 6337: FROM hxc_transaction_details txd

6333: tbb_latest.resource_id = rrr.resource_id AND
6334: tbb_latest.last_update_date > :p_since_date
6335: AND tbb_latest.approval_status <> ''ERROR''
6336: AND NOT EXISTS (select ''x''
6337: FROM hxc_transaction_details txd
6338: , hxc_transactions tx
6339: WHERE tx.transaction_process_id = :p_process_id
6340: AND tx.type = ''RETRIEVAL''
6341: AND tx.status = ''SUCCESS''

Line 6443: , hxc_transaction_details txd

6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att
6443: , hxc_transaction_details txd
6444: , hxc_transactions tx
6445: WHERE
6446: tx.transaction_code = :p_transaction_code
6447: AND

Line 7952: INSERT INTO hxc_transaction_details

7948: hr_utility.set_location ('Processing ' || l_proc, 50);
7949: END IF;
7950:
7951: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_time_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_time_transaction_id.LAST
7952: INSERT INTO hxc_transaction_details
7953: (transaction_detail_id,
7954: time_building_block_id,
7955: time_building_block_ovn,
7956: transaction_id,

Line 7994: INSERT INTO hxc_transaction_details

7990: hr_utility.set_location ('Processing ' || l_proc, 60);
7991: END IF;
7992:
7993: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_day_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_day_transaction_id.LAST
7994: INSERT INTO hxc_transaction_details
7995: (transaction_detail_id,
7996: time_building_block_id,
7997: time_building_block_ovn,
7998: transaction_id,

Line 8036: INSERT INTO hxc_transaction_details

8032: hr_utility.set_location ('Processing ' || l_proc, 70);
8033: END IF;
8034:
8035: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
8036: INSERT INTO hxc_transaction_details
8037: (transaction_detail_id,
8038: time_building_block_id,
8039: time_building_block_ovn,
8040: transaction_id,

Line 8092: INSERT INTO hxc_transaction_details

8088: hr_utility.set_location ('Processing ' || l_proc, 90);
8089: END IF;
8090:
8091: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
8092: INSERT INTO hxc_transaction_details
8093: (transaction_detail_id,
8094: time_building_block_id,
8095: time_building_block_ovn,
8096: transaction_id,