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_ARCHIVE dependencies on HXC_TIME_ATTRIBUTES

Line 682: -- present in hxc_time_attributes_ar

678: -- Using the rowids, insert the attribute usage records into
679: -- hxc_attribute_usages_ar.
680: -- Delete the records from hxc_transaction_details_ar using the ROWID.
681: -- Delete all records from hxc_archive_temp if attribute_id is
682: -- present in hxc_time_attributes_ar
683: -- Select all attribute records from hxc_time_attributes table and
684: -- insert into hxc_time_attributes_ar table.
685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.

Line 683: -- Select all attribute records from hxc_time_attributes table and

679: -- hxc_attribute_usages_ar.
680: -- Delete the records from hxc_transaction_details_ar using the ROWID.
681: -- Delete all records from hxc_archive_temp if attribute_id is
682: -- present in hxc_time_attributes_ar
683: -- Select all attribute records from hxc_time_attributes table and
684: -- insert into hxc_time_attributes_ar table.
685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.

Line 684: -- insert into hxc_time_attributes_ar table.

680: -- Delete the records from hxc_transaction_details_ar using the ROWID.
681: -- Delete all records from hxc_archive_temp if attribute_id is
682: -- present in hxc_time_attributes_ar
683: -- Select all attribute records from hxc_time_attributes table and
684: -- insert into hxc_time_attributes_ar table.
685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.

Line 685: -- Delete all attribute records from hxc_time_attributes table, if the attribute

681: -- Delete all records from hxc_archive_temp if attribute_id is
682: -- present in hxc_time_attributes_ar
683: -- Select all attribute records from hxc_time_attributes table and
684: -- insert into hxc_time_attributes_ar table.
685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the

Line 1333: FROM hxc_time_attributes_ar

1329: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1330:
1331: DELETE FROM hxc_archive_temp
1332: WHERE EXISTS ( SELECT 1
1333: FROM hxc_time_attributes_ar
1334: WHERE time_attribute_id = master_id )
1335: AND thread_id = p_thread_id ;
1336:
1337: INSERT INTO hxc_time_attributes_ar

Line 1337: INSERT INTO hxc_time_attributes_ar

1333: FROM hxc_time_attributes_ar
1334: WHERE time_attribute_id = master_id )
1335: AND thread_id = p_thread_id ;
1336:
1337: INSERT INTO hxc_time_attributes_ar
1338: (ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,
1339: ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,
1340: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1341: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,

Line 1351: FROM hxc_time_attributes bkupta

1347: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1348: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,
1349: ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1350: ATTRIBUTE14,null,p_data_set_id
1351: FROM hxc_time_attributes bkupta
1352: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1353: master_id
1354: FROM hxc_archive_temp temp
1355: WHERE thread_id = p_thread_id );

Line 1360: FROM hxc_time_attributes bkupta

1356:
1357: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1358:
1359: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1360: FROM hxc_time_attributes bkupta
1361: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1362: master_id
1363: FROM hxc_archive_temp temp
1364: WHERE thread_id = p_thread_id ) ;