DBA Data[Home] [Help]

APPS.PAY_GB_UPGRADE_PKG dependencies on FND_FILE

Line 138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

134: for v_csr_details in csr_person_details
135: loop
136: hr_utility.set_location('Entering ' || l_proc,20);
137: if l_count = 1 then
138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
141: fnd_file.put_line(FND_FILE.OUTPUT,' ');
142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)

Line 139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');

135: loop
136: hr_utility.set_location('Entering ' || l_proc,20);
137: if l_count = 1 then
138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
141: fnd_file.put_line(FND_FILE.OUTPUT,' ');
142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
143: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));

Line 140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

136: hr_utility.set_location('Entering ' || l_proc,20);
137: if l_count = 1 then
138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
141: fnd_file.put_line(FND_FILE.OUTPUT,' ');
142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
143: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
144: end if;

Line 141: fnd_file.put_line(FND_FILE.OUTPUT,' ');

137: if l_count = 1 then
138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
141: fnd_file.put_line(FND_FILE.OUTPUT,' ');
142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
143: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
144: end if;
145:

Line 142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)

138: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
139: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
140: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
141: fnd_file.put_line(FND_FILE.OUTPUT,' ');
142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
143: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
144: end if;
145:
146: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_csr_details.person_id,10)

Line 146: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_csr_details.person_id,10)

142: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
143: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
144: end if;
145:
146: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_csr_details.person_id,10)
147: ||' '||rpad(v_csr_details.full_name,30)
148: ||' '||rpad(v_csr_details.ni_no,13)
149: ||' '||rpad(v_csr_details.old_category,25)
150: ||' '||rpad(v_csr_details.new_category,12)

Line 284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

280: loop
281:
282: hr_utility.set_location('Entering ' || l_proc,60);
283: if l_count = 1 then
284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
287: fnd_file.put_line(FND_FILE.OUTPUT,' ');
288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)

Line 285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');

281:
282: hr_utility.set_location('Entering ' || l_proc,60);
283: if l_count = 1 then
284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
287: fnd_file.put_line(FND_FILE.OUTPUT,' ');
288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
289: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));

Line 286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');

282: hr_utility.set_location('Entering ' || l_proc,60);
283: if l_count = 1 then
284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
287: fnd_file.put_line(FND_FILE.OUTPUT,' ');
288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
289: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
290: end if;

Line 287: fnd_file.put_line(FND_FILE.OUTPUT,' ');

283: if l_count = 1 then
284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
287: fnd_file.put_line(FND_FILE.OUTPUT,' ');
288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
289: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
290: end if;
291:

Line 288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)

284: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
285: fnd_file.put_line(FND_FILE.OUTPUT,' List of employees ');
286: fnd_file.put_line(FND_FILE.OUTPUT,'---------------------------------------------------------------------------------------------------------------------------------------');
287: fnd_file.put_line(FND_FILE.OUTPUT,' ');
288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
289: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
290: end if;
291:
292: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_dis_det.person_id,10)

Line 292: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_dis_det.person_id,10)

288: fnd_file.put_line(FND_FILE.OUTPUT, rpad('Person ID',10)||' '||rpad('Full Name',30)||' '||rpad('NI Number',13)
289: ||' '||rpad('Old Category',25)||' '||rpad('New Category',12)||' '||rpad('Effective Start Date',20)||' '||rpad('Effective End Date',20));
290: end if;
291:
292: fnd_file.put_line(FND_FILE.OUTPUT, rpad(v_dis_det.person_id,10)
293: ||' '||rpad(v_dis_det.full_name,30)
294: ||' '||rpad(v_dis_det.ni_no,13)
295: ||' '||rpad(v_dis_det.category,25)
296: ||' '||rpad('Yes',12)