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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on FND_GLOBAL

Line 155: AND request_id = FND_GLOBAL.CONC_request_id;

151: UPDATE hxc_ret_pay_latest_details
152: SET batch_id = l_ret_tab(i)
153: WHERE time_building_block_id = l_bb_tab(i)
154: AND object_version_number = l_ovn_tab(i)
155: AND request_id = FND_GLOBAL.CONC_request_id;
156:
157: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST
158: UPDATE hxc_ret_pay_details
159: SET batch_id = l_ret_tab(i)

Line 162: AND request_id = FND_GLOBAL.CONC_request_id;

158: UPDATE hxc_ret_pay_details
159: SET batch_id = l_ret_tab(i)
160: WHERE time_building_block_id = l_bb_tab(i)
161: AND object_version_number = l_ovn_tab(i)
162: AND request_id = FND_GLOBAL.CONC_request_id;
163:
164: -- Updating records touched in an earlier retrieval process
165: -- but having un transferred retro batches.
166: -- We just move them to this retro batch.

Line 171: request_id = FND_GLOBAL.conc_request_id

167:
168: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST
169: UPDATE hxc_ret_pay_latest_details
170: SET batch_id = l_ret_tab(i),
171: request_id = FND_GLOBAL.conc_request_id
172: WHERE time_building_block_id = l_bb_tab(i)
173: AND object_version_number = l_ovn_tab(i)
174: AND request_id <> FND_GLOBAL.CONC_request_id
175: AND batch_id = l_old_ret_tab(i)

Line 174: AND request_id <> FND_GLOBAL.CONC_request_id

170: SET batch_id = l_ret_tab(i),
171: request_id = FND_GLOBAL.conc_request_id
172: WHERE time_building_block_id = l_bb_tab(i)
173: AND object_version_number = l_ovn_tab(i)
174: AND request_id <> FND_GLOBAL.CONC_request_id
175: AND batch_id = l_old_ret_tab(i)
176: AND pbl_id IS NULL;
177:
178: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST

Line 181: request_id = FND_GLOBAL.conc_request_id

177:
178: FORALL i IN l_bb_tab.FIRST..l_bb_tab.LAST
179: UPDATE hxc_ret_pay_details
180: SET batch_id = l_ret_tab(i),
181: request_id = FND_GLOBAL.conc_request_id
182: WHERE time_building_block_id = l_bb_tab(i)
183: AND object_version_number = l_ovn_tab(i)
184: AND request_id <> FND_GLOBAL.CONC_request_id
185: AND batch_id = l_old_ret_tab(i)

Line 184: AND request_id <> FND_GLOBAL.CONC_request_id

180: SET batch_id = l_ret_tab(i),
181: request_id = FND_GLOBAL.conc_request_id
182: WHERE time_building_block_id = l_bb_tab(i)
183: AND object_version_number = l_ovn_tab(i)
184: AND request_id <> FND_GLOBAL.CONC_request_id
185: AND batch_id = l_old_ret_tab(i)
186: AND pbl_id IS NULL;
187:
188: