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_APL_TRACK_PURGE_PKG dependencies on FND_FILE

Line 27: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');

23: --
24: l_underline := rpad('-',20,'-')||' '||
25: rpad('-',10,'-');
26: --
27: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');
28: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');
29: --
30: fnd_file.put_line(fnd_file.log,l_header);
31: fnd_file.put_line(fnd_file.log,l_underline);

Line 28: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');

24: l_underline := rpad('-',20,'-')||' '||
25: rpad('-',10,'-');
26: --
27: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');
28: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');
29: --
30: fnd_file.put_line(fnd_file.log,l_header);
31: fnd_file.put_line(fnd_file.log,l_underline);
32: --

Line 30: fnd_file.put_line(fnd_file.log,l_header);

26: --
27: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');
28: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');
29: --
30: fnd_file.put_line(fnd_file.log,l_header);
31: fnd_file.put_line(fnd_file.log,l_underline);
32: --
33: end;
34: elsif p_print_process = 'DOC' then

Line 31: fnd_file.put_line(fnd_file.log,l_underline);

27: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');
28: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');
29: --
30: fnd_file.put_line(fnd_file.log,l_header);
31: fnd_file.put_line(fnd_file.log,l_underline);
32: --
33: end;
34: elsif p_print_process = 'DOC' then
35: begin

Line 37: fnd_file.put_line(fnd_file.log,l_underline);

33: end;
34: elsif p_print_process = 'DOC' then
35: begin
36: l_underline := rpad('-',75,'-');
37: fnd_file.put_line(fnd_file.log,l_underline);
38: --
39: l_header := rpad('DOCUMENT_ID',20)||' '||
40: rpad('PERSON_ID',10);
41: --

Line 45: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');

41: --
42: l_underline := rpad('-',20,'-')||' '||
43: rpad('-',10,'-');
44: --
45: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');
46: fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');
47: --
48: fnd_file.put_line(fnd_file.log,l_header);
49: fnd_file.put_line(fnd_file.log,l_underline);

Line 46: fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');

42: l_underline := rpad('-',20,'-')||' '||
43: rpad('-',10,'-');
44: --
45: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');
46: fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');
47: --
48: fnd_file.put_line(fnd_file.log,l_header);
49: fnd_file.put_line(fnd_file.log,l_underline);
50: --

Line 48: fnd_file.put_line(fnd_file.log,l_header);

44: --
45: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');
46: fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');
47: --
48: fnd_file.put_line(fnd_file.log,l_header);
49: fnd_file.put_line(fnd_file.log,l_underline);
50: --
51: end;
52: elsif p_print_process = 'SRC' then

Line 49: fnd_file.put_line(fnd_file.log,l_underline);

45: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');
46: fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');
47: --
48: fnd_file.put_line(fnd_file.log,l_header);
49: fnd_file.put_line(fnd_file.log,l_underline);
50: --
51: end;
52: elsif p_print_process = 'SRC' then
53: begin

Line 55: fnd_file.put_line(fnd_file.log,l_underline);

51: end;
52: elsif p_print_process = 'SRC' then
53: begin
54: l_underline := rpad('-',75,'-');
55: fnd_file.put_line(fnd_file.log,l_underline);
56: --
57: l_header := rpad('SAVED_SEARCH_CRITERIA_ID',30)||' '||
58: rpad('VACANCY_ID',10);
59: --

Line 63: fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');

59: --
60: l_underline := rpad('-',30,'-')||' '||
61: rpad('-',10,'-');
62: --
63: fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');
64: fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');
65: --
66: fnd_file.put_line(fnd_file.log,l_header);
67: fnd_file.put_line(fnd_file.log,l_underline);

Line 64: fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');

60: l_underline := rpad('-',30,'-')||' '||
61: rpad('-',10,'-');
62: --
63: fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');
64: fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');
65: --
66: fnd_file.put_line(fnd_file.log,l_header);
67: fnd_file.put_line(fnd_file.log,l_underline);
68: --

Line 66: fnd_file.put_line(fnd_file.log,l_header);

62: --
63: fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');
64: fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');
65: --
66: fnd_file.put_line(fnd_file.log,l_header);
67: fnd_file.put_line(fnd_file.log,l_underline);
68: --
69: end;
70: elsif p_print_process = 'ACC' then

Line 67: fnd_file.put_line(fnd_file.log,l_underline);

63: fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');
64: fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');
65: --
66: fnd_file.put_line(fnd_file.log,l_header);
67: fnd_file.put_line(fnd_file.log,l_underline);
68: --
69: end;
70: elsif p_print_process = 'ACC' then
71: begin

Line 73: fnd_file.put_line(fnd_file.log,l_underline);

69: end;
70: elsif p_print_process = 'ACC' then
71: begin
72: l_underline := rpad('-',75,'-');
73: fnd_file.put_line(fnd_file.log,l_underline);
74: --
75: l_header := rpad('APL_PROFILE_ACCESS_ID',30)||' '||
76: rpad('PERSON_ID',10);
77: --

Line 81: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');

77: --
78: l_underline := rpad('-',30,'-')||' '||
79: rpad('-',10,'-');
80: --
81: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');
82: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');
83: --
84: fnd_file.put_line(fnd_file.log,l_header);
85: fnd_file.put_line(fnd_file.log,l_underline);

Line 82: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');

78: l_underline := rpad('-',30,'-')||' '||
79: rpad('-',10,'-');
80: --
81: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');
82: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');
83: --
84: fnd_file.put_line(fnd_file.log,l_header);
85: fnd_file.put_line(fnd_file.log,l_underline);
86: --

Line 84: fnd_file.put_line(fnd_file.log,l_header);

80: --
81: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');
82: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');
83: --
84: fnd_file.put_line(fnd_file.log,l_header);
85: fnd_file.put_line(fnd_file.log,l_underline);
86: --
87: end;
88: end if;

Line 85: fnd_file.put_line(fnd_file.log,l_underline);

81: fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');
82: fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');
83: --
84: fnd_file.put_line(fnd_file.log,l_header);
85: fnd_file.put_line(fnd_file.log,l_underline);
86: --
87: end;
88: end if;
89:

Line 156: fnd_file.put_line(fnd_file.log,l_print_info);

152: hr_utility.set_location('Print Delete Snapshot:'||l_proc,25);
153: l_print_info := rpad(nvl(to_char(rec_apl_profile_snapshot.profile_snapshot_id),' '),20) ||
154: rpad(nvl(to_char(rec_apl_profile_snapshot.person_id),' '),10);
155: --
156: fnd_file.put_line(fnd_file.log,l_print_info);
157:
158: End loop;
159: --
160:

Line 183: fnd_file.put_line(fnd_file.log,l_print_info);

179: hr_utility.set_location('Print Delete Document:'||l_proc,35);
180: l_print_info := rpad(nvl(to_char(rec_apl_doc_snapshot.document_id),' '),20) ||
181: rpad(nvl(to_char(rec_apl_doc_snapshot.person_id),' '),10);
182: --
183: fnd_file.put_line(fnd_file.log,l_print_info);
184: End loop;
185: --
186:
187: hr_utility.set_location('Delete Saved Search Criteria:'||l_proc, 40);

Line 204: fnd_file.put_line(fnd_file.log,l_print_info);

200: hr_utility.set_location('Print Delete Search Criteria:'||l_proc,45);
201: l_print_info := rpad(nvl(to_char(rec_saved_search_criteria.saved_search_criteria_id),' '),30) ||
202: rpad(nvl(to_char(rec_saved_search_criteria.vacancy_id),' '),10);
203: --
204: fnd_file.put_line(fnd_file.log,l_print_info);
205: End loop;
206: --
207:
208: hr_utility.set_location('Delete Applicant Profile Access:'||l_proc, 50);

Line 225: fnd_file.put_line(fnd_file.log,l_print_info);

221: hr_utility.set_location('Print Delete PROFILE ACCESS:'||l_proc,55);
222: l_print_info := rpad(nvl(to_char(rec_apl_profile_access.apl_profile_access_id),' '),30) ||
223: rpad(nvl(to_char(rec_apl_profile_access.person_id),' '),10);
224: --
225: fnd_file.put_line(fnd_file.log,l_print_info);
226: End loop;
227: --
228:
229: hr_utility.set_location('Leaving Purge Records:'||l_proc, 100);