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.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_PURGE_OLD_DATA_PKG

Line 1: package body irc_purge_old_data_pkg as

1: package body irc_purge_old_data_pkg as
2: /* $Header: ircpurge.pkb 120.15.12020000.2 2012/07/04 13:22:17 amnaraya ship $ */
3: -- ----------------------------------------------------------------------------
4: -- |--------------------------< anonymize_candidate_data >--------------------|
5: -- ----------------------------------------------------------------------------

Line 585: irc_purge_old_data_pkg.delete_person

581: --
582: -- Call a procedure to delete the person,asignment and the related records
583: --
584: hr_utility.set_location(l_proc, 120);
585: irc_purge_old_data_pkg.delete_person
586: (p_party_id => p_party_id
587: ,p_root_person_id => p_root_person_id
588: ,p_effective_date => p_effective_date
589: );

Line 596: irc_purge_old_data_pkg.anonymize_candidate_data

592: --
593: -- Call a procedure to update the person record
594: --
595: hr_utility.set_location(l_proc, 130);
596: irc_purge_old_data_pkg.anonymize_candidate_data
597: (p_party_id => p_party_id
598: ,p_effective_date => p_effective_date
599: );
600: --

Line 640: irc_purge_old_data_pkg.send_notification_to_person

636: --
637: if(p_process_type = 'NOTIFY') then
638: --
639: hr_utility.set_location(l_proc, 20);
640: irc_purge_old_data_pkg.send_notification_to_person
641: (p_person_id => p_root_person_id
642: );
643: elsif(p_process_type = 'UPD') then
644: --

Line 646: irc_purge_old_data_pkg.anonymize_candidate_data

642: );
643: elsif(p_process_type = 'UPD') then
644: --
645: hr_utility.set_location(l_proc, 30);
646: irc_purge_old_data_pkg.anonymize_candidate_data
647: (p_party_id => p_party_id
648: ,p_effective_date => p_effective_date
649: );
650: elsif(p_process_type = 'DEL' or p_process_type = 'DELUPD') then

Line 653: irc_purge_old_data_pkg.delete_person_child_data

649: );
650: elsif(p_process_type = 'DEL' or p_process_type = 'DELUPD') then
651: --
652: hr_utility.set_location(l_proc, 40);
653: irc_purge_old_data_pkg.delete_person_child_data
654: (p_party_id => p_party_id
655: ,p_root_person_id => p_root_person_id
656: ,p_effective_date => p_effective_date
657: ,p_process_type => p_process_type

Line 839: ,irc_purge_old_data_pkg.get_max_updated_date(inp.person_id));

835: where is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
836: and p_months < months_between(p_effective_date
837: ,inp.last_update_date)
838: and p_months < months_between(p_effective_date
839: ,irc_purge_old_data_pkg.get_max_updated_date(inp.person_id));
840: --
841: cursor csr_last_application_date is
842: select inp.person_id,
843: inp.party_id

Line 860: and irc_purge_old_data_pkg.is_free_to_purge(inp.party_id,p_effective_date)='TRUE'

856: and ptu.effective_end_date
857: and ptu.person_type_id=ppt.person_type_id
858: and ppt.system_person_type = 'EX_APL'
859: )
860: and irc_purge_old_data_pkg.is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
861: and p_months < months_between(p_effective_date,
862: irc_purge_old_data_pkg.last_application_date
863: (inp.party_id,p_effective_date)) ;
864: --

Line 862: irc_purge_old_data_pkg.last_application_date

858: and ppt.system_person_type = 'EX_APL'
859: )
860: and irc_purge_old_data_pkg.is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
861: and p_months < months_between(p_effective_date,
862: irc_purge_old_data_pkg.last_application_date
863: (inp.party_id,p_effective_date)) ;
864: --
865: begin
866: --

Line 884: irc_purge_old_data_pkg.notify_or_purge

880: if(p_measure_type = 'LOGINDATE') then
881: --
882: hr_utility.set_location(l_proc, 20);
883: for rec_last_login_date in csr_last_login_date loop
884: irc_purge_old_data_pkg.notify_or_purge
885: (p_effective_date => p_effective_date
886: ,p_process_type => p_process_type
887: ,p_party_id => rec_last_login_date.party_id
888: ,p_root_person_id => rec_last_login_date.person_id

Line 895: irc_purge_old_data_pkg.notify_or_purge

891: elsif(p_measure_type = 'UPDATEDATE') then
892: --
893: hr_utility.set_location(l_proc, 30);
894: for rec_last_update_date in csr_last_update_date loop
895: irc_purge_old_data_pkg.notify_or_purge
896: (p_effective_date => p_effective_date
897: ,p_process_type => p_process_type
898: ,p_party_id => rec_last_update_date.party_id
899: ,p_root_person_id => rec_last_update_date.person_id

Line 906: irc_purge_old_data_pkg.notify_or_purge

902: elsif(p_measure_type = 'APPLDATE') then
903: --
904: hr_utility.set_location(l_proc, 40);
905: for rec_last_appl_date in csr_last_application_date loop
906: irc_purge_old_data_pkg.notify_or_purge
907: (p_effective_date => p_effective_date
908: ,p_process_type => p_process_type
909: ,p_party_id => rec_last_appl_date.party_id
910: ,p_root_person_id => rec_last_appl_date.person_id

Line 959: irc_purge_old_data_pkg.purge_records

955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
959: irc_purge_old_data_pkg.purge_records
960: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
961: ,p_process_type => p_process_type
962: ,p_months => p_months
963: ,p_measure_type => p_measure_type

Line 1012: end irc_purge_old_data_pkg;

1008: end loop;
1009: p_rows_processed := l_rows_processed;
1010: end clean_employee_data;
1011: --
1012: end irc_purge_old_data_pkg;