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.3.12010000.3 2008/08/28 13:35:13 prasashe ship $ */
3: -- ----------------------------------------------------------------------------
4: -- |--------------------------< anonymize_candidate_data >--------------------|
5: -- ----------------------------------------------------------------------------

Line 458: irc_purge_old_data_pkg.delete_person

454: --
455: -- Call a procedure to delete the person,asignment and the related records
456: --
457: hr_utility.set_location(l_proc, 120);
458: irc_purge_old_data_pkg.delete_person
459: (p_party_id => p_party_id
460: ,p_root_person_id => p_root_person_id
461: ,p_effective_date => p_effective_date
462: );

Line 469: irc_purge_old_data_pkg.anonymize_candidate_data

465: --
466: -- Call a procedure to update the person record
467: --
468: hr_utility.set_location(l_proc, 130);
469: irc_purge_old_data_pkg.anonymize_candidate_data
470: (p_party_id => p_party_id
471: ,p_effective_date => p_effective_date
472: );
473: --

Line 513: irc_purge_old_data_pkg.send_notification_to_person

509: --
510: if(p_process_type = 'NOTIFY') then
511: --
512: hr_utility.set_location(l_proc, 20);
513: irc_purge_old_data_pkg.send_notification_to_person
514: (p_person_id => p_root_person_id
515: );
516: elsif(p_process_type = 'UPD') then
517: --

Line 519: irc_purge_old_data_pkg.anonymize_candidate_data

515: );
516: elsif(p_process_type = 'UPD') then
517: --
518: hr_utility.set_location(l_proc, 30);
519: irc_purge_old_data_pkg.anonymize_candidate_data
520: (p_party_id => p_party_id
521: ,p_effective_date => p_effective_date
522: );
523: elsif(p_process_type = 'DEL' or p_process_type = 'DELUPD') then

Line 526: irc_purge_old_data_pkg.delete_person_child_data

522: );
523: elsif(p_process_type = 'DEL' or p_process_type = 'DELUPD') then
524: --
525: hr_utility.set_location(l_proc, 40);
526: irc_purge_old_data_pkg.delete_person_child_data
527: (p_party_id => p_party_id
528: ,p_root_person_id => p_root_person_id
529: ,p_effective_date => p_effective_date
530: ,p_process_type => p_process_type

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

708: where is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
709: and p_months < months_between(p_effective_date
710: ,inp.last_update_date)
711: and p_months < months_between(p_effective_date
712: ,irc_purge_old_data_pkg.get_max_updated_date(inp.person_id));
713: --
714: cursor csr_last_application_date is
715: select inp.person_id,
716: inp.party_id

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

729: and ptu.effective_end_date
730: and ptu.person_type_id=ppt.person_type_id
731: and ppt.system_person_type = 'EX_APL'
732: )
733: and irc_purge_old_data_pkg.is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
734: and p_months < months_between(p_effective_date,
735: irc_purge_old_data_pkg.last_application_date
736: (inp.party_id,p_effective_date)) ;
737: --

Line 735: irc_purge_old_data_pkg.last_application_date

731: and ppt.system_person_type = 'EX_APL'
732: )
733: and irc_purge_old_data_pkg.is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
734: and p_months < months_between(p_effective_date,
735: irc_purge_old_data_pkg.last_application_date
736: (inp.party_id,p_effective_date)) ;
737: --
738: begin
739: --

Line 757: irc_purge_old_data_pkg.notify_or_purge

753: if(p_measure_type = 'LOGINDATE') then
754: --
755: hr_utility.set_location(l_proc, 20);
756: for rec_last_login_date in csr_last_login_date loop
757: irc_purge_old_data_pkg.notify_or_purge
758: (p_effective_date => p_effective_date
759: ,p_process_type => p_process_type
760: ,p_party_id => rec_last_login_date.party_id
761: ,p_root_person_id => rec_last_login_date.person_id

Line 768: irc_purge_old_data_pkg.notify_or_purge

764: elsif(p_measure_type = 'UPDATEDATE') then
765: --
766: hr_utility.set_location(l_proc, 30);
767: for rec_last_update_date in csr_last_update_date loop
768: irc_purge_old_data_pkg.notify_or_purge
769: (p_effective_date => p_effective_date
770: ,p_process_type => p_process_type
771: ,p_party_id => rec_last_update_date.party_id
772: ,p_root_person_id => rec_last_update_date.person_id

Line 779: irc_purge_old_data_pkg.notify_or_purge

775: elsif(p_measure_type = 'APPLDATE') then
776: --
777: hr_utility.set_location(l_proc, 40);
778: for rec_last_appl_date in csr_last_application_date loop
779: irc_purge_old_data_pkg.notify_or_purge
780: (p_effective_date => p_effective_date
781: ,p_process_type => p_process_type
782: ,p_party_id => rec_last_appl_date.party_id
783: ,p_root_person_id => rec_last_appl_date.person_id

Line 832: irc_purge_old_data_pkg.purge_records

828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
832: irc_purge_old_data_pkg.purge_records
833: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
834: ,p_process_type => p_process_type
835: ,p_months => p_months
836: ,p_measure_type => p_measure_type

Line 885: end irc_purge_old_data_pkg;

881: end loop;
882: p_rows_processed := l_rows_processed;
883: end clean_employee_data;
884: --
885: end irc_purge_old_data_pkg;