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 HR_UTILITY

Line 42: hr_utility.set_location('Entering Anonymize Candidate Data:'||l_proc, 10);

38: begin
39: --
40: -- Update all the person records to Anonymous
41: --
42: hr_utility.set_location('Entering Anonymize Candidate Data:'||l_proc, 10);
43: for rec_person in csr_update_person loop
44: hr_utility.set_location(l_proc, 20);
45: l_person_ovn := rec_person.object_version_number;
46: l_employee_number := rec_person.employee_number;

Line 44: hr_utility.set_location(l_proc, 20);

40: -- Update all the person records to Anonymous
41: --
42: hr_utility.set_location('Entering Anonymize Candidate Data:'||l_proc, 10);
43: for rec_person in csr_update_person loop
44: hr_utility.set_location(l_proc, 20);
45: l_person_ovn := rec_person.object_version_number;
46: l_employee_number := rec_person.employee_number;
47: l_last_name := rec_person.last_name;
48: --

Line 80: hr_utility.set_location(l_proc, 40);

76: -- non-searchable
77: --
78: open csr_update_notif_pref;
79: fetch csr_update_notif_pref into l_notif_pref_ovn,l_notif_pref_id;
80: hr_utility.set_location(l_proc, 40);
81: irc_notification_prefs_api.update_notification_prefs
82: (
83: p_notification_preference_id => l_notif_pref_id
84: ,p_effective_date => p_effective_date

Line 91: hr_utility.set_location('Leaving Anonymize Candidate Data:'||l_proc, 100);

87: ,p_matching_jobs => 'N'
88: ,p_object_version_number => l_notif_pref_ovn
89: );
90: close csr_update_notif_pref;
91: hr_utility.set_location('Leaving Anonymize Candidate Data:'||l_proc, 100);
92: end anonymize_candidate_data;
93: --
94: --
95: -- ----------------------------------------------------------------------------

Line 126: hr_utility.set_location('Entering Send Notification to Person:'||l_proc, 10);

122: where employee_id = l_personIdIn;
123: --
124: begin
125: --
126: hr_utility.set_location('Entering Send Notification to Person:'||l_proc, 10);
127: open csr_name;
128: fetch csr_name into l_name,l_last_name;
129: close csr_name;
130: if l_last_name = fnd_message.get_string('PER','IRC_412172_ANONYMOUS_NAME') then

Line 155: hr_utility.set_location('Leaving Send Notification to Person:'||l_proc, 100);

151: ,p_subject => l_subject
152: ,p_html_body => l_message_conc_html
153: ,p_text_body => l_message_conc_text
154: );
155: hr_utility.set_location('Leaving Send Notification to Person:'||l_proc, 100);
156: --
157: end send_notification_to_person;
158: -- ----------------------------------------------------------------------------
159: -- |--------------------------< delete_person >-------------------------------|

Line 401: hr_utility.set_location('Entering Purge Person Info:'||l_proc, 10);

397: where paf1.assignment_id = paf.assignment_id )
398: and ic.object_id = paf.assignment_id;
399: --
400: begin
401: hr_utility.set_location('Entering Purge Person Info:'||l_proc, 10);
402: --
403: -- Delete from IRC_DOCUMENTS
404: --
405:

Line 425: hr_utility.set_location(l_proc, 20);

421:
422: --
423: -- Delete from PER_QUALIFICATIONS
424: --
425: hr_utility.set_location(l_proc, 20);
426: for rec_per_qual in csr_per_qual loop
427: per_qualifications_api.delete_qualification
428: (p_qualification_id => rec_per_qual.qualification_id
429: ,p_object_version_number => rec_per_qual.object_version_number

Line 437: hr_utility.set_location(l_proc, 30);

433: -- Delete from PER_ESTABLISHMENT_ATTENDANCES
434: -- There should not be a child record in Per Qualification table mapped
435: -- by Attendance ID
436: --
437: hr_utility.set_location(l_proc, 30);
438: for rec_per_est_att in csr_per_est_att loop
439: per_estab_attendances_api.delete_attended_estab
440: (p_attendance_id => rec_per_est_att.attendance_id
441: ,p_object_version_number => rec_per_est_att.object_version_number

Line 448: hr_utility.set_location(l_proc, 40);

444: --
445: -- Delete from Per_Previous_Employers
446: -- This deletes data from Per_Previous_jobs an per_previous_job_usages also
447: --
448: hr_utility.set_location(l_proc, 40);
449: for rec_per_prev_empl in csr_per_prev_empl loop
450: hr_previous_employment_api.delete_previous_employer
451: (p_previous_employer_id => rec_per_prev_empl.previous_employer_id
452: ,p_object_version_number => rec_per_prev_empl.object_version_number

Line 459: hr_utility.set_location(l_proc, 50);

455: --
456: -- Api checks for competence_element_id being a parent.
457: -- Delete from Per_Competence_Elements
458: --
459: hr_utility.set_location(l_proc, 50);
460: for rec_per_comps in csr_per_comps loop
461: hr_competence_element_api.delete_competence_element
462: (p_competence_element_id => rec_per_comps.competence_element_id
463: ,p_object_version_number => rec_per_comps.object_version_number

Line 469: hr_utility.set_location(l_proc, 60);

465: end loop;
466: --
467: --Delete from Per_Addresses
468: --
469: hr_utility.set_location(l_proc, 60);
470: for rec_per_addr in csr_per_addr loop
471: per_add_del.del
472: (p_address_id => rec_per_addr.address_id
473: ,p_object_version_number => rec_per_addr.object_version_number

Line 479: hr_utility.set_location(l_proc, 80);

475: end loop;
476: --
477: -- Delete from IRC_JOB_BASKET_ITEMS
478: --
479: hr_utility.set_location(l_proc, 80);
480: for rec_jbi in csr_jbi loop
481: irc_job_basket_items_api.delete_job_basket_item
482: (p_job_basket_item_id => rec_jbi.job_basket_item_id
483: ,p_object_version_number => rec_jbi.object_version_number

Line 489: hr_utility.set_location(l_proc, 90);

485: end loop;
486: --
487: -- Delete the work preferences
488: --
489: hr_utility.set_location(l_proc, 90);
490: for rec_isc_work in csr_isc_work loop
491: irc_search_criteria_api.delete_work_choices
492: (p_search_criteria_id => rec_isc_work.search_criteria_id
493: ,p_object_version_number => rec_isc_work.object_version_number

Line 499: hr_utility.set_location(l_proc, 100);

495: end loop;
496: --
497: -- Delete the Job Saved Searches
498: --
499: hr_utility.set_location(l_proc, 100);
500: for rec_isc_party in csr_isc_person loop
501: irc_search_criteria_api.delete_saved_search
502: (p_search_criteria_id => rec_isc_party.search_criteria_id
503: ,p_object_version_number => rec_isc_party.object_version_number

Line 509: hr_utility.set_location(l_proc, 110);

505: end loop;
506: --
507: -- Delete from PER_PHONES
508: --
509: hr_utility.set_location(l_proc, 110);
510: for rec_phn in csr_phn_party loop
511: hr_phone_api.delete_phone
512: (p_phone_id => rec_phn.phone_id
513: ,p_object_version_number => rec_phn.object_version_number

Line 519: hr_utility.set_location(l_proc, 112);

515: end loop;
516: --
517: -- Delete from IRC_VACANCY_CONSIDERATIONS
518: --
519: hr_utility.set_location(l_proc, 112);
520: for rec_ivc in csr_ivc_cons loop
521: irc_vacancy_considerations_api.delete_vacancy_consideration
522: (p_vacancy_consideration_id => rec_ivc.vacancy_consideration_id
523: ,p_object_version_number => rec_ivc.object_version_number

Line 574: hr_utility.set_location(l_proc, 115);

570: if(p_process_type='DEL') then
571: --
572: -- Delete from IRC_NOTIFICATION_PREFERENCES
573: --
574: hr_utility.set_location(l_proc, 115);
575: for rec_irc_notif in csr_irc_notif loop
576: irc_notification_prefs_api.delete_notification_prefs
577: (p_notification_preference_id => rec_irc_notif.notification_preference_id
578: ,p_object_version_number => rec_irc_notif.object_version_number

Line 584: hr_utility.set_location(l_proc, 120);

580: end loop;
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

Line 595: hr_utility.set_location(l_proc, 130);

591: elsif(p_process_type ='DELUPD') then
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: );

Line 603: hr_utility.set_location('Leaving Purge Person Info:'||l_proc,200);

599: );
600: --
601: end if ;
602: --
603: hr_utility.set_location('Leaving Purge Person Info:'||l_proc,200);
604: end delete_person_child_data;
605: --
606: -- ----------------------------------------------------------------------------
607: -- |--------------------------< notify_or_purge >-----------------------------|

Line 630: hr_utility.set_location('Entering Notify or Purge:'||l_proc, 10);

626: and effective_end_date;
627: --
628: begin
629: --
630: hr_utility.set_location('Entering Notify or Purge:'||l_proc, 10);
631: -- Fetch the person full name
632: --
633: open csr_full_name;
634: fetch csr_full_name into l_person_full_name;

Line 639: hr_utility.set_location(l_proc, 20);

635: close csr_full_name;
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

Line 645: hr_utility.set_location(l_proc, 30);

641: (p_person_id => p_root_person_id
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: );

Line 652: hr_utility.set_location(l_proc, 40);

648: ,p_effective_date => p_effective_date
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

Line 670: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);

666: rpad(nvl(to_char(p_party_id),' '),10)||' '||
667: rpad(nvl('SUCCESS',' '),10);
668: --
669: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
670: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
671: exception
672: when others then
673: l_print_element_info := rpad(nvl(l_person_full_name,' '),60)||' '||
674: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||

Line 679: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);

675: rpad(nvl(to_char(p_party_id),' '),10)||' '||
676: rpad(nvl('FAILURE',' '),10);
677: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
678: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);
679: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
680: rollback;
681: end notify_or_purge;
682: --
683: -- ----------------------------------------------------------------------------

Line 867: hr_utility.set_location('Entering Purge Records:'||l_proc, 10);

863: (inp.party_id,p_effective_date)) ;
864: --
865: begin
866: --
867: hr_utility.set_location('Entering Purge Records:'||l_proc, 10);
868: l_header := rpad('FULL_NAME',60)||' '||
869: rpad('PERSON_ID',10)||' '||
870: rpad('PARTY_ID',10)||' '||
871: rpad('RESULT',10);

Line 882: hr_utility.set_location(l_proc, 20);

878: Fnd_file.put_line(FND_FILE.LOG,l_header);
879: Fnd_file.put_line(FND_FILE.LOG,l_underline);
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

Line 893: hr_utility.set_location(l_proc, 30);

889: );
890: end loop;
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

Line 904: hr_utility.set_location(l_proc, 40);

900: );
901: end loop;
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

Line 914: hr_utility.set_location('Leaving Purge Records:'||l_proc, 100);

910: ,p_root_person_id => rec_last_appl_date.person_id
911: );
912: end loop;
913: end if;
914: hr_utility.set_location('Leaving Purge Records:'||l_proc, 100);
915: end purge_records;
916: -- ----------------------------------------------------------------------------
917: -- |--------------------------< purge_record_process >------------------------|
918: -- ----------------------------------------------------------------------------

Line 944: hr_utility.set_location('Entering Purge Record Process:'||l_proc, 10);

940: where lookup_type = 'IRC_MEASURE_TYPE'
941: and lookup_code = l_msrCodeIn;
942: begin
943: --
944: hr_utility.set_location('Entering Purge Record Process:'||l_proc, 10);
945: --
946: open getprstype(p_process_type);
947: fetch getprstype into l_process_type;
948: close getprstype;

Line 966: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 70);

962: ,p_months => p_months
963: ,p_measure_type => p_measure_type
964: );
965: retcode := 0;
966: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 70);
967: exception
968: when others then
969: --
970: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 80);

Line 970: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 80);

966: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 70);
967: exception
968: when others then
969: --
970: hr_utility.set_location('Leaving Purge Record Process:'||l_proc, 80);
971: rollback;
972: --
973: -- Set the return parameters to indicate failure
974: --