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_TIME_BUILDING_BLOCKS

Line 170: SELECT /+ INDEX( hxc hxc_time_building_blocks_n1) /

166: p_stop_date in DATE)
167: IS
168:
169: CURSOR c_tbb_id(p_data_set_id number) is
170: SELECT /*+ INDEX( hxc hxc_time_building_blocks_n1) */
171: distinct time_building_block_id
172: FROM hxc_time_building_blocks hxc
173: WHERE scope ='TIMECARD'
174: AND (data_set_id <> p_data_set_id OR data_set_id IS NULL)

Line 172: FROM hxc_time_building_blocks hxc

168:
169: CURSOR c_tbb_id(p_data_set_id number) is
170: SELECT /*+ INDEX( hxc hxc_time_building_blocks_n1) */
171: distinct time_building_block_id
172: FROM hxc_time_building_blocks hxc
173: WHERE scope ='TIMECARD'
174: AND (data_set_id <> p_data_set_id OR data_set_id IS NULL)
175: AND stop_time BETWEEN p_start_date AND p_stop_date;
176:

Line 188: -- No need to update any other table except HXC_TIME_BUILDING_BLOCKS ( scope : timecard )

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:
192:

Line 243: UPDATE hxc_time_building_blocks tbb

239:
240: -- after just DELETE the bulk table
241: l_tbb_id_tab.DELETE;
242:
243: UPDATE hxc_time_building_blocks tbb
244: SET data_set_id = p_data_set_id
245: WHERE scope ='TIMECARD'
246: AND time_building_block_id in
247: (SELECT temp.id

Line 259: FROM hxc_time_building_blocks day

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
262: (SELECT temp.id
263: FROM hxc_temp_timecard_chunks temp

Line 269: UPDATE hxc_time_building_blocks tbb

265: AND temp.data_set_id = p_data_set_id);
266: --AND day.data_set_id = p_data_set_id;
267:
268:
269: UPDATE hxc_time_building_blocks tbb
270: SET data_set_id = p_data_set_id
271: WHERE scope ='DAY'
272: AND time_building_block_id in
273: (SELECT temp.id

Line 281: FROM hxc_time_building_blocks det

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
284: (SELECT temp.id
285: FROM hxc_temp_timecard_chunks temp

Line 291: UPDATE hxc_time_building_blocks tbb

287: AND temp.data_set_id = p_data_set_id);
288: --AND det.data_set_id = p_data_set_id;
289:
290:
291: UPDATE hxc_time_building_blocks tbb
292: SET data_set_id = p_data_set_id
293: WHERE scope ='DETAIL'
294: AND time_building_block_id in
295: (SELECT ID

Line 470: undo_define_table(p_table_name => 'HXC_TIME_BUILDING_BLOCKS',

466:
467: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
468: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),25);
469:
470: undo_define_table(p_table_name => 'HXC_TIME_BUILDING_BLOCKS',
471: p_data_set_id => p_data_set_id,
472: p_chunk_size => l_chunk_size);
473:
474: undo_define_table(p_table_name => 'HXC_TIME_ATTRIBUTE_USAGES',

Line 533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks

529: -- is no point in stopping it from getting archived.
530:
531: -- Bug 14028697
532: -- Modified the below cursor to have a better access path.
533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks
534: --
535:
536: /*
537:

Line 540: SELECT /+ NO_INDEX(day HXC_TIME_BUILDING_BLOCKS_N2) NO_INDEX(det HXC_TIME_BUILDING_BLOCKS_N2)

536: /*
537:
538: CURSOR c_get_unretrieved_tcs(p_data_set_id number,l_bee_retrieval number)
539: IS
540: SELECT /*+ NO_INDEX(day HXC_TIME_BUILDING_BLOCKS_N2) NO_INDEX(det HXC_TIME_BUILDING_BLOCKS_N2) *
541: DISTINCT
542: tsum.resource_id,
543: tsum.start_time,
544: tsum.stop_time,

Line 549: hxc_time_building_blocks day,

545: tsum.approval_status,
546: nvl(per.employee_number,'Employee Number Unkown') employee_number,
547: nvl(per.full_name,'Full Name Unknown') full_name
548: FROM
549: hxc_time_building_blocks day,
550: hxc_time_building_blocks det,
551: hxc_latest_details hld,
552: hxc_data_sets hds,
553: hxc_timecard_summary tsum,

Line 550: hxc_time_building_blocks det,

546: nvl(per.employee_number,'Employee Number Unkown') employee_number,
547: nvl(per.full_name,'Full Name Unknown') full_name
548: FROM
549: hxc_time_building_blocks day,
550: hxc_time_building_blocks det,
551: hxc_latest_details hld,
552: hxc_data_sets hds,
553: hxc_timecard_summary tsum,
554: hxc_application_sets_v has,

Line 618: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)

614: CURSOR c_get_unretrieved_tcs(p_data_set_id number,l_bee_retrieval number)
615: IS
616: SELECT/*+ INDEX(hds HXC_DATA_SETS_PK)
617: INDEX(tsum HXC_TIMECARD_SUMMARY_N1)
618: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)
619: INDEX(det HXC_TIME_BUILDING_BLOCKS_FK3)
620: INDEX(per PER_PEOPLE_F_PK) */
621: DISTINCT
622: tsum.resource_id,

Line 619: INDEX(det HXC_TIME_BUILDING_BLOCKS_FK3)

615: IS
616: SELECT/*+ INDEX(hds HXC_DATA_SETS_PK)
617: INDEX(tsum HXC_TIMECARD_SUMMARY_N1)
618: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)
619: INDEX(det HXC_TIME_BUILDING_BLOCKS_FK3)
620: INDEX(per PER_PEOPLE_F_PK) */
621: DISTINCT
622: tsum.resource_id,
623: tsum.start_time,

Line 630: hxc_time_building_blocks day,

626: nvl(per.employee_number,'Employee Number Unkown') employee_number,
627: nvl(per.full_name,'Full Name Unknown') full_name
628: FROM hxc_data_sets hds,
629: hxc_timecard_summary tsum,
630: hxc_time_building_blocks day,
631: hxc_time_building_blocks det,
632: hxc_latest_details hld,
633: hxc_application_sets_v has,
634: hxc_application_set_comps_v hasv,

Line 631: hxc_time_building_blocks det,

627: nvl(per.full_name,'Full Name Unknown') full_name
628: FROM hxc_data_sets hds,
629: hxc_timecard_summary tsum,
630: hxc_time_building_blocks day,
631: hxc_time_building_blocks det,
632: hxc_latest_details hld,
633: hxc_application_sets_v has,
634: hxc_application_set_comps_v hasv,
635: per_all_people_f per

Line 1043: FROM hxc_time_building_blocks

1039: IS
1040:
1041: CURSOR c_lock_resource is
1042: SELECT distinct resource_id
1043: FROM hxc_time_building_blocks
1044: WHERE data_set_id = p_data_set_id
1045: AND scope = 'TIMECARD';
1046:
1047: l_row_lock_id ROWID;