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 725: -- present in hxc_time_attributes_ar

721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.

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

722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.

Line 727: -- insert into hxc_time_attributes_ar table.

723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.

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

724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the

Line 1548: FROM hxc_time_attributes_ar

1544: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1545:
1546: DELETE FROM hxc_archive_temp
1547: WHERE EXISTS ( SELECT 1
1548: FROM hxc_time_attributes_ar
1549: WHERE time_attribute_id = master_id )
1550: AND thread_id = p_thread_id ;
1551:
1552: INSERT INTO hxc_time_attributes_ar

Line 1552: INSERT INTO hxc_time_attributes_ar

1548: FROM hxc_time_attributes_ar
1549: WHERE time_attribute_id = master_id )
1550: AND thread_id = p_thread_id ;
1551:
1552: INSERT INTO hxc_time_attributes_ar
1553: (ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,
1554: ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,
1555: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1556: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,

Line 1566: FROM hxc_time_attributes bkupta

1562: ATTRIBUTE29,ATTRIBUTE30,BLD_BLK_INFO_TYPE_ID,OBJECT_VERSION_NUMBER,TIME_ATTRIBUTE_ID,
1563: ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,
1564: ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,
1565: ATTRIBUTE14,null,p_data_set_id
1566: FROM hxc_time_attributes bkupta
1567: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1568: master_id
1569: FROM hxc_archive_temp temp
1570: WHERE thread_id = p_thread_id );

Line 1575: FROM hxc_time_attributes bkupta

1571:
1572: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1573:
1574: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1575: FROM hxc_time_attributes bkupta
1576: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1577: master_id
1578: FROM hxc_archive_temp temp
1579: WHERE thread_id = p_thread_id ) ;