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_DATA_SET dependencies on HXC_TEMP_TIMECARD_CHUNKS

Line 187: -- HXC_TEMP_TIMECARD_CHUNKS is a global temporary table now

183:
184:
185: -- Bug 7358756
186: -- Archive/Restore process re-architecture.
187: -- HXC_TEMP_TIMECARD_CHUNKS is a global temporary table now
188: -- No need to update any other table except HXC_TIME_BUILDING_BLOCKS ( scope : timecard )
189: -- since the Archive/Restore process drives it from there.
190: -- Removed all unwanted logging, and comments.
191:

Line 219: DELETE FROM hxc_temp_timecard_chunks

215: /* Removed the following since this is a GTT henceforth
216: -- before starting let's DELETE all the data of the data_set_id in the
217: -- temporary table
218:
219: DELETE FROM hxc_temp_timecard_chunks
220: WHERE data_set_id = p_data_set_id;
221: */
222:
223:

Line 232: INSERT INTO hxc_temp_timecard_chunks

228: -- TIMECARD SCOPE BUILDING BLOCK
229: ---------------------------------
230: -- first get the chunk of timecard
231: -- to work on in the temp chunk table
232: INSERT INTO hxc_temp_timecard_chunks
233: (data_set_id,id, scope)
234: VALUES
235: (p_data_set_id,l_tbb_id_tab(x),'TIMECARD');
236:

Line 248: FROM hxc_temp_timecard_chunks temp

244: SET data_set_id = p_data_set_id
245: WHERE scope ='TIMECARD'
246: AND time_building_block_id in
247: (SELECT temp.id
248: FROM hxc_temp_timecard_chunks temp
249: WHERE temp.data_set_id = p_data_set_id
250: AND temp.scope = 'TIMECARD');
251:
252: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD UPDATE for this chunk: '||sql%rowcount);

Line 257: /* INSERT INTO hxc_temp_timecard_chunks (id,data_set_id,scope)

253:
254: -- Bug 7358756
255: -- The following lines of code commented out, we no longer need it.
256:
257: /* INSERT INTO hxc_temp_timecard_chunks (id,data_set_id,scope)
258: SELECT distinct day.time_building_block_id, p_data_set_id,'DAY'
259: FROM hxc_time_building_blocks day
260: WHERE day.scope = 'DAY'
261: AND day.parent_building_block_id in

Line 263: FROM hxc_temp_timecard_chunks temp

259: FROM hxc_time_building_blocks day
260: WHERE day.scope = 'DAY'
261: AND day.parent_building_block_id in
262: (SELECT temp.id
263: FROM hxc_temp_timecard_chunks temp
264: WHERE temp.scope = 'TIMECARD'
265: AND temp.data_set_id = p_data_set_id);
266: --AND day.data_set_id = p_data_set_id;
267:

Line 274: FROM hxc_temp_timecard_chunks temp

270: SET data_set_id = p_data_set_id
271: WHERE scope ='DAY'
272: AND time_building_block_id in
273: (SELECT temp.id
274: FROM hxc_temp_timecard_chunks temp
275: WHERE temp.data_set_id = p_data_set_id
276: AND temp.scope = 'DAY');
277:
278:

Line 279: INSERT INTO hxc_temp_timecard_chunks (id,data_set_id, scope)

275: WHERE temp.data_set_id = p_data_set_id
276: AND temp.scope = 'DAY');
277:
278:
279: INSERT INTO hxc_temp_timecard_chunks (id,data_set_id, scope)
280: SELECT distinct det.time_building_block_id,p_data_set_id,'DETAIL'
281: FROM hxc_time_building_blocks det
282: WHERE det.scope = 'DETAIL'
283: AND det.parent_building_block_id IN

Line 285: FROM hxc_temp_timecard_chunks temp

281: FROM hxc_time_building_blocks det
282: WHERE det.scope = 'DETAIL'
283: AND det.parent_building_block_id IN
284: (SELECT temp.id
285: FROM hxc_temp_timecard_chunks temp
286: WHERE temp.scope = 'DAY'
287: AND temp.data_set_id = p_data_set_id);
288: --AND det.data_set_id = p_data_set_id;
289:

Line 296: FROM hxc_temp_timecard_chunks temp

292: SET data_set_id = p_data_set_id
293: WHERE scope ='DETAIL'
294: AND time_building_block_id in
295: (SELECT ID
296: FROM hxc_temp_timecard_chunks temp
297: WHERE temp.data_set_id = p_data_set_id
298: AND temp.scope = 'DETAIL');
299:
300: UPDATE hxc_time_attribute_usages

Line 304: FROM hxc_temp_timecard_chunks temp

300: UPDATE hxc_time_attribute_usages
301: SET data_set_id = p_data_set_id
302: WHERE time_building_block_id in
303: (SELECT temp.id
304: FROM hxc_temp_timecard_chunks temp
305: WHERE temp.data_set_id = p_data_set_id
306: AND temp.scope in ('TIMECARD','DAY','DETAIL'));
307:
308:

Line 322: FROM hxc_temp_timecard_chunks temp

318: UPDATE hxc_transaction_details htd
319: SET htd.data_set_id = p_data_set_id
320: where htd.time_building_block_id in
321: (SELECT temp.id
322: FROM hxc_temp_timecard_chunks temp
323: WHERE temp.data_set_id = p_data_set_id
324: AND temp.scope in ('TIMECARD','DAY','DETAIL'));
325:
326: UPDATE hxc_transactions

Line 331: hxc_temp_timecard_chunks temp

327: SET data_set_id = p_data_set_id
328: WHERE transaction_id in
329: (SELECT distinct transaction_id
330: FROM hxc_transaction_details txnd,
331: hxc_temp_timecard_chunks temp
332: WHERE txnd.time_building_block_id = temp.id
333: AND temp.data_set_id = p_data_set_id
334: AND temp.scope in ('TIMECARD','DAY','DETAIL'))
335: AND type = 'DEPOSIT';

Line 343: FROM hxc_temp_timecard_chunks temp

339: UPDATE hxc_timecard_summary hts
340: SET data_set_id = p_data_set_id
341: where timecard_id in
342: (SELECT temp.id
343: FROM hxc_temp_timecard_chunks temp
344: WHERE temp.data_set_id = p_data_set_id
345: AND temp.scope = 'TIMECARD');
346:
347: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');