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.

[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TRANSACTION_DETAILS

Line 135: SELECT /+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK)

131:
132: /*
133: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
134: IS
135: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) *
136: hxc_transaction_details_s.NEXTVAL
137: FROM hxc_transaction_details txd
138: WHERE ROWNUM <= p_max;
139: */

Line 136: hxc_transaction_details_s.NEXTVAL

132: /*
133: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
134: IS
135: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) *
136: hxc_transaction_details_s.NEXTVAL
137: FROM hxc_transaction_details txd
138: WHERE ROWNUM <= p_max;
139: */
140:

Line 137: FROM hxc_transaction_details txd

133: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
134: IS
135: SELECT /*+ INDEX_FFS(TXD HXC_TRANSACTION_DETAILS_PK) *
136: hxc_transaction_details_s.NEXTVAL
137: FROM hxc_transaction_details txd
138: WHERE ROWNUM <= p_max;
139: */
140:
141: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)

Line 143: SELECT hxc_transaction_details_s.NEXTVAL

139: */
140:
141: CURSOR csr_get_tx_detail_id (p_max BINARY_INTEGER)
142: IS
143: SELECT hxc_transaction_details_s.NEXTVAL
144: FROM SYS.DUAL
145: CONNECT BY LEVEL <= p_max ;
146:
147: g_conc_request_id NUMBER (15);

Line 1796: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)*/

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
1800: WHERE tx.transaction_process_id = :p_process_id

Line 1799: , hxc_transaction_details txd

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''
1803: AND tx.transaction_id = txd.transaction_id

Line 2184: INDEX(TXD HXC_TRANSACTION_DETAILS_FK1)

2180: -- Modified the hints below to point to the right indexes.
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)

Line 2190: hxc_transaction_details txd,

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,
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'

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 2550: INSERT INTO hxc_transaction_details

2546: hr_utility.set_location ('Processing ' || l_proc, 90);
2547: END IF;
2548:
2549: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
2550: INSERT INTO hxc_transaction_details
2551: (transaction_detail_id,
2552: time_building_block_id,
2553: time_building_block_ovn,
2554: transaction_id,

Line 2651: INSERT INTO hxc_transaction_details

2647: hr_utility.set_location ('Processing ' || l_proc, 50);
2648: END IF;
2649:
2650: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_time_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_time_transaction_id.LAST
2651: INSERT INTO hxc_transaction_details
2652: (transaction_detail_id,
2653: time_building_block_id,
2654: time_building_block_ovn,
2655: transaction_id,

Line 2693: INSERT INTO hxc_transaction_details

2689: hr_utility.set_location ('Processing ' || l_proc, 60);
2690: END IF;
2691:
2692: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_day_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_day_transaction_id.LAST
2693: INSERT INTO hxc_transaction_details
2694: (transaction_detail_id,
2695: time_building_block_id,
2696: time_building_block_ovn,
2697: transaction_id,

Line 2735: INSERT INTO hxc_transaction_details

2731: hr_utility.set_location ('Processing ' || l_proc, 70);
2732: END IF;
2733:
2734: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
2735: INSERT INTO hxc_transaction_details
2736: (transaction_detail_id,
2737: time_building_block_id,
2738: time_building_block_ovn,
2739: transaction_id,

Line 2791: INSERT INTO hxc_transaction_details

2787: hr_utility.set_location ('Processing ' || l_proc, 90);
2788: END IF;
2789:
2790: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
2791: INSERT INTO hxc_transaction_details
2792: (transaction_detail_id,
2793: time_building_block_id,
2794: time_building_block_ovn,
2795: transaction_id,

Line 7046: FROM hxc_transaction_details txd

7042: from Hxc_latest_details tbb_latest
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''

Line 7070: FROM hxc_transaction_details txd

7066: from Hxc_pa_latest_details tbb_latest
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''

Line 7092: FROM hxc_transaction_details txd

7088: from Hxc_pay_latest_details tbb_latest
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''

Line 7121: FROM hxc_transaction_details txd

7117: tbb_latest.resource_id = rrr.resource_id AND
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''

Line 7148: FROM hxc_transaction_details txd

7144: tbb_latest.resource_id = rrr.resource_id AND
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''

Line 7175: FROM hxc_transaction_details txd

7171: tbb_latest.resource_id = rrr.resource_id AND
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''

Line 7310: , hxc_transaction_details txd

7306: , hxc_time_attribute_usages detail_usage
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

Line 9128: INSERT INTO hxc_transaction_details

9124: hr_utility.set_location ('Processing ' || l_proc, 50);
9125: END IF;
9126:
9127: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_time_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_time_transaction_id.LAST
9128: INSERT INTO hxc_transaction_details
9129: (transaction_detail_id,
9130: time_building_block_id,
9131: time_building_block_ovn,
9132: transaction_id,

Line 9170: INSERT INTO hxc_transaction_details

9166: hr_utility.set_location ('Processing ' || l_proc, 60);
9167: END IF;
9168:
9169: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_day_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_day_transaction_id.LAST
9170: INSERT INTO hxc_transaction_details
9171: (transaction_detail_id,
9172: time_building_block_id,
9173: time_building_block_ovn,
9174: transaction_id,

Line 9212: INSERT INTO hxc_transaction_details

9208: hr_utility.set_location ('Processing ' || l_proc, 70);
9209: END IF;
9210:
9211: FORALL tx_detail IN hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_detail_transaction_id.LAST
9212: INSERT INTO hxc_transaction_details
9213: (transaction_detail_id,
9214: time_building_block_id,
9215: time_building_block_ovn,
9216: transaction_id,

Line 10003: INSERT INTO hxc_transaction_details

9999: hr_utility.set_location ('Processing ' || l_proc, 90);
10000: END IF;
10001:
10002: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_error_transaction_id.FIRST .. hxc_generic_retrieval_pkg.t_tx_error_transaction_id.LAST
10003: INSERT INTO hxc_transaction_details
10004: (transaction_detail_id,
10005: time_building_block_id,
10006: time_building_block_ovn,
10007: transaction_id,