DBA Data[Home] [Help]

APPS.HXC_ARCHIVE dependencies on HXC_TIME_ATTRIBUTES_AR

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 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 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,