APPS.HXC_DATA_SET dependencies on HR_GENERAL

Line 193: hr_general.g_data_migrator_mode := 'Y';

189: -- since the Archive/Restore process drives it from there.
190: -- Removed all unwanted logging, and comments.
191:
192:
193: hr_general.g_data_migrator_mode := 'Y';
194:
195: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
196: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
197:

Line 465: hr_general.g_data_migrator_mode := 'Y';

461: l_fnd_logging VARCHAR2(10);
462:
463: BEGIN
464:
465: hr_general.g_data_migrator_mode := 'Y';
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:

Line 516: -- Added condition to compare det.date_to to hr_general.end_of_time.

512: --Cursor to fetch all the non-errord status unreterived Timecards.
513:
514:
515: -- Bug 6744917
516: -- Added condition to compare det.date_to to hr_general.end_of_time.
517: -- The query just pulled out all timecards which has details without
518: -- transaction details of type RETRIEVAL.
519: -- For a detail which is overwritten or deleted and where the original
520: -- entry was never retrieved, there neednt be retrieval happening

Line 581: AND ( ( det.date_to = hr_general.end_of_time

577: AND hld.time_building_block_id = det.time_building_block_id
578: AND hld.object_version_number = det.object_version_number
579: AND det.parent_building_block_id = day.time_building_block_id
580: AND det.parent_building_block_ovn = day.object_version_number
581: AND ( ( det.date_to = hr_general.end_of_time
582: )
583: OR ( det.date_to <> hr_general.end_of_time
584: AND EXISTS (SELECT 1
585: FROM hxc_transaction_details txnd1,

Line 583: OR ( det.date_to <> hr_general.end_of_time

579: AND det.parent_building_block_id = day.time_building_block_id
580: AND det.parent_building_block_ovn = day.object_version_number
581: AND ( ( det.date_to = hr_general.end_of_time
582: )
583: OR ( det.date_to <> hr_general.end_of_time
584: AND EXISTS (SELECT 1
585: FROM hxc_transaction_details txnd1,
586: hxc_transactions txn1,
587: hxc_retrieval_processes rp1

Line 664: AND ( ( det.date_to = hr_general.end_of_time

660: AND hld.time_building_block_id = det.time_building_block_id
661: AND hld.object_version_number = det.object_version_number
662: AND det.parent_building_block_id = day.time_building_block_id
663: AND det.parent_building_block_ovn = day.object_version_number
664: AND ( ( det.date_to = hr_general.end_of_time
665: )
666: OR ( det.date_to <> hr_general.end_of_time
667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */
668: 1

Line 666: OR ( det.date_to <> hr_general.end_of_time

662: AND det.parent_building_block_id = day.time_building_block_id
663: AND det.parent_building_block_ovn = day.object_version_number
664: AND ( ( det.date_to = hr_general.end_of_time
665: )
666: OR ( det.date_to <> hr_general.end_of_time
667: AND EXISTS (SELECT /*+ INDEX(rp1 HXC_RETRIEVAL_PROCESSES_PK) */
668: 1
669: FROM hxc_transaction_details txnd1,
670: hxc_transactions txn1,