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.PAY_GB_REP dependencies on FND_FILE

Line 67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));

63: OPEN header_details;
64: FETCH header_details into l_bg_name, l_date, l_payroll_name;
65: CLOSE header_details;
66:
67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));
68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);

Line 68: fnd_file.put_line(fnd_file.output,' ');

64: FETCH header_details into l_bg_name, l_date, l_payroll_name;
65: CLOSE header_details;
66:
67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));
68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');

Line 69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);

65: CLOSE header_details;
66:
67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));
68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:

Line 70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);

66:
67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));
68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:
74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));

Line 71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);

67: fnd_file.put_line(fnd_file.output,lpad('NI Arrears Report',42));
68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:
74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));
75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));

Line 72: fnd_file.put_line(fnd_file.output,' ');

68: fnd_file.put_line(fnd_file.output,' ');
69: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:
74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));
75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));
76: l_total_arrears := 0;

Line 74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));

70: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:
74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));
75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));
76: l_total_arrears := 0;
77:
78: for l_body in body_details loop

Line 75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));

71: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
72: fnd_file.put_line(fnd_file.output,' ');
73:
74: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('NI Arrears YTD',15,' '));
75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));
76: l_total_arrears := 0;
77:
78: for l_body in body_details loop
79: l_ni_arrears := nvl(hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date),

Line 83: fnd_file.put_line(fnd_file.output,rpad(l_body.assignment_number,15,' ') || ' ' || rpad(l_body.full_name,35,' ') ||

79: l_ni_arrears := nvl(hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date),
80: l_body.assignment_id,
81: p_def_bal_id),0);
82: if (l_ni_arrears > 0) then
83: fnd_file.put_line(fnd_file.output,rpad(l_body.assignment_number,15,' ') || ' ' || rpad(l_body.full_name,35,' ') ||
84: ' ' || lpad(to_char(l_ni_arrears,'999,999,999.90'),15,' '));
85: l_total_arrears := l_total_arrears + l_ni_arrears;
86: end if;
87: end loop;

Line 89: fnd_file.put_line(fnd_file.output,lpad(lpad('-',15,'-'),67,' '));

85: l_total_arrears := l_total_arrears + l_ni_arrears;
86: end if;
87: end loop;
88:
89: fnd_file.put_line(fnd_file.output,lpad(lpad('-',15,'-'),67,' '));
90: fnd_file.put_line(fnd_file.output,'Report Total' || lpad(to_char(l_total_arrears,'999,999,999.90'),55,' '));
91:
92: END ni_arrears_report;
93:

Line 90: fnd_file.put_line(fnd_file.output,'Report Total' || lpad(to_char(l_total_arrears,'999,999,999.90'),55,' '));

86: end if;
87: end loop;
88:
89: fnd_file.put_line(fnd_file.output,lpad(lpad('-',15,'-'),67,' '));
90: fnd_file.put_line(fnd_file.output,'Report Total' || lpad(to_char(l_total_arrears,'999,999,999.90'),55,' '));
91:
92: END ni_arrears_report;
93:
94: PROCEDURE p45_issued_active_asg_report(

Line 189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);

185: OPEN csr_header_details(p_business_group_id, p_payroll_id, p_effective_date);
186: FETCH csr_header_details into l_bg_name, l_date, l_payroll_name;
187: CLOSE csr_header_details;
188:
189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);
190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);

Line 190: fnd_file.put_line(fnd_file.output,' ');

186: FETCH csr_header_details into l_bg_name, l_date, l_payroll_name;
187: CLOSE csr_header_details;
188:
189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);
190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');

Line 191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);

187: CLOSE csr_header_details;
188:
189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);
190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:

Line 192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);

188:
189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);
190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:
196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');

Line 193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);

189: fnd_file.put_line(fnd_file.output,lpad('P45 Issued for Active Assignments Report',80) || lpad(' ', 37, ' ') || sysdate);
190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:
196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');
197: fnd_file.put_line(fnd_file.output,' ');

Line 194: fnd_file.put_line(fnd_file.output,' ');

190: fnd_file.put_line(fnd_file.output,' ');
191: fnd_file.put_line(fnd_file.output,'Business Group : ' || l_bg_name);
192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:
196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');
197: fnd_file.put_line(fnd_file.output,' ');
198:

Line 196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');

192: fnd_file.put_line(fnd_file.output,'Effective Date : ' || l_date);
193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:
196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');
197: fnd_file.put_line(fnd_file.output,' ');
198:
199: l_total_count := 0;
200: for p_rec in csr_payroll_details(p_business_group_id, p_payroll_id, l_effective_date) loop

Line 197: fnd_file.put_line(fnd_file.output,' ');

193: fnd_file.put_line(fnd_file.output,'Payroll : ' || l_payroll_name);
194: fnd_file.put_line(fnd_file.output,' ');
195:
196: fnd_file.put_line(fnd_file.output,'P45 Manually Issued for Assignments active or suspended as at '|| l_effective_date || ' :');
197: fnd_file.put_line(fnd_file.output,' ');
198:
199: l_total_count := 0;
200: for p_rec in csr_payroll_details(p_business_group_id, p_payroll_id, l_effective_date) loop
201: l_count := 0;

Line 207: fnd_file.put_line(fnd_file.output,' ');

203: l_issue_date := pay_p45_pkg.get_p45_eit_manual_issue_dt(b_rec.assignment_id);
204: if l_issue_date is not null then
205: l_total_count := l_total_count + 1;
206: if l_count = 0 then
207: fnd_file.put_line(fnd_file.output,' ');
208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
209: fnd_file.put_line(fnd_file.output,' ');
210:
211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));

Line 208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);

204: if l_issue_date is not null then
205: l_total_count := l_total_count + 1;
206: if l_count = 0 then
207: fnd_file.put_line(fnd_file.output,' ');
208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
209: fnd_file.put_line(fnd_file.output,' ');
210:
211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));
212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));

Line 209: fnd_file.put_line(fnd_file.output,' ');

205: l_total_count := l_total_count + 1;
206: if l_count = 0 then
207: fnd_file.put_line(fnd_file.output,' ');
208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
209: fnd_file.put_line(fnd_file.output,' ');
210:
211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));
212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));
213: l_count := 1;

Line 211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));

207: fnd_file.put_line(fnd_file.output,' ');
208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
209: fnd_file.put_line(fnd_file.output,' ');
210:
211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));
212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));
213: l_count := 1;
214: end if;
215: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

Line 212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));

208: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
209: fnd_file.put_line(fnd_file.output,' ');
210:
211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));
212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));
213: l_count := 1;
214: end if;
215: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
216: rpad(b_rec.full_name,35,' ') ||' ' ||

Line 215: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

211: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' || rpad('Full Name',35,' ') || ' ' || rpad('Manual Issue Date',20,' '));
212: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',20,'-'));
213: l_count := 1;
214: end if;
215: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
216: rpad(b_rec.full_name,35,' ') ||' ' ||
217: rpad(l_issue_date,20,' '));
218: end if;
219: end loop;

Line 222: fnd_file.put_line(fnd_file.output,' ');

218: end if;
219: end loop;
220: end loop;
221:
222: fnd_file.put_line(fnd_file.output,' ');
223: fnd_file.put_line(fnd_file.output,' ');
224: fnd_file.put_line(fnd_file.output,'Total Number of active or suspended assignments issued P45 manually: ' || l_total_count);
225:
226:

Line 223: fnd_file.put_line(fnd_file.output,' ');

219: end loop;
220: end loop;
221:
222: fnd_file.put_line(fnd_file.output,' ');
223: fnd_file.put_line(fnd_file.output,' ');
224: fnd_file.put_line(fnd_file.output,'Total Number of active or suspended assignments issued P45 manually: ' || l_total_count);
225:
226:
227: --

Line 224: fnd_file.put_line(fnd_file.output,'Total Number of active or suspended assignments issued P45 manually: ' || l_total_count);

220: end loop;
221:
222: fnd_file.put_line(fnd_file.output,' ');
223: fnd_file.put_line(fnd_file.output,' ');
224: fnd_file.put_line(fnd_file.output,'Total Number of active or suspended assignments issued P45 manually: ' || l_total_count);
225:
226:
227: --
228: -- P45 Issued Assignments and P45 issued for

Line 231: fnd_file.put_line(fnd_file.output,' ');

227: --
228: -- P45 Issued Assignments and P45 issued for
229: -- Aggregated Assignments
230: --
231: fnd_file.put_line(fnd_file.output,' ');
232: fnd_file.put_line(fnd_file.output,' ');
233: fnd_file.put_line(fnd_file.output,'P45 Issued for Assignments/Aggregated Assignments active or suspended as at ' || l_effective_date || ' :');
234: fnd_file.put_line(fnd_file.output,' ');
235: l_total_count := 0;

Line 232: fnd_file.put_line(fnd_file.output,' ');

228: -- P45 Issued Assignments and P45 issued for
229: -- Aggregated Assignments
230: --
231: fnd_file.put_line(fnd_file.output,' ');
232: fnd_file.put_line(fnd_file.output,' ');
233: fnd_file.put_line(fnd_file.output,'P45 Issued for Assignments/Aggregated Assignments active or suspended as at ' || l_effective_date || ' :');
234: fnd_file.put_line(fnd_file.output,' ');
235: l_total_count := 0;
236: for p_rec in csr_payroll_details(p_business_group_id, p_payroll_id, l_effective_date) loop

Line 233: fnd_file.put_line(fnd_file.output,'P45 Issued for Assignments/Aggregated Assignments active or suspended as at ' || l_effective_date || ' :');

229: -- Aggregated Assignments
230: --
231: fnd_file.put_line(fnd_file.output,' ');
232: fnd_file.put_line(fnd_file.output,' ');
233: fnd_file.put_line(fnd_file.output,'P45 Issued for Assignments/Aggregated Assignments active or suspended as at ' || l_effective_date || ' :');
234: fnd_file.put_line(fnd_file.output,' ');
235: l_total_count := 0;
236: for p_rec in csr_payroll_details(p_business_group_id, p_payroll_id, l_effective_date) loop
237: l_count := 0;

Line 234: fnd_file.put_line(fnd_file.output,' ');

230: --
231: fnd_file.put_line(fnd_file.output,' ');
232: fnd_file.put_line(fnd_file.output,' ');
233: fnd_file.put_line(fnd_file.output,'P45 Issued for Assignments/Aggregated Assignments active or suspended as at ' || l_effective_date || ' :');
234: fnd_file.put_line(fnd_file.output,' ');
235: l_total_count := 0;
236: for p_rec in csr_payroll_details(p_business_group_id, p_payroll_id, l_effective_date) loop
237: l_count := 0;
238: for b_rec in csr_body_details(p_business_group_id, p_rec.payroll_id, l_effective_date) loop

Line 247: fnd_file.put_line(fnd_file.output,' ');

243:
244: if l_assignment_action_id is not null then
245: l_total_count := l_total_count + 1;
246: if l_count = 0 then
247: fnd_file.put_line(fnd_file.output,' ');
248: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
249: fnd_file.put_line(fnd_file.output,' ');
250: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
251: rpad('Full Name',35,' ') || ' ' ||

Line 248: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);

244: if l_assignment_action_id is not null then
245: l_total_count := l_total_count + 1;
246: if l_count = 0 then
247: fnd_file.put_line(fnd_file.output,' ');
248: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
249: fnd_file.put_line(fnd_file.output,' ');
250: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
251: rpad('Full Name',35,' ') || ' ' ||
252: rpad('Agg Assignment',15,' ') || ' ' ||

Line 249: fnd_file.put_line(fnd_file.output,' ');

245: l_total_count := l_total_count + 1;
246: if l_count = 0 then
247: fnd_file.put_line(fnd_file.output,' ');
248: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
249: fnd_file.put_line(fnd_file.output,' ');
250: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
251: rpad('Full Name',35,' ') || ' ' ||
252: rpad('Agg Assignment',15,' ') || ' ' ||
253: rpad('Issue Date',10,' ') || ' ' ||

Line 250: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||

246: if l_count = 0 then
247: fnd_file.put_line(fnd_file.output,' ');
248: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
249: fnd_file.put_line(fnd_file.output,' ');
250: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
251: rpad('Full Name',35,' ') || ' ' ||
252: rpad('Agg Assignment',15,' ') || ' ' ||
253: rpad('Issue Date',10,' ') || ' ' ||
254: lpad('Asg Action ID', 15,' ') || ' ' ||

Line 257: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' ||

253: rpad('Issue Date',10,' ') || ' ' ||
254: lpad('Asg Action ID', 15,' ') || ' ' ||
255: lpad('Locking Action ID',17,' ') || ' ' ||
256: rpad('Action Eff.Date',15,' '));
257: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' ||
258: rpad('-',35,'-') || ' ' ||
259: rpad('-',15,'-') || ' ' ||
260: rpad('-',10,'-') || ' ' ||
261: lpad('-',15,'-') || ' ' ||

Line 274: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

270: --
271: open csr_locked_act_dtls(l_assignment_action_id);
272: fetch csr_locked_act_dtls into l_locking_action_id, l_lock_effective_date;
273: if csr_locked_act_dtls%notfound then
274: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
275: rpad(b_rec.full_name,35,' ') || ' ' ||
276: rpad(' ',15,' ') || ' ' ||
277: rpad(l_issue_date,10,' ') || ' ' ||
278: lpad(l_assignment_action_id, 15,' ') || ' '||

Line 282: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

278: lpad(l_assignment_action_id, 15,' ') || ' '||
279: lpad(' ',17,' ') || ' ' ||
280: rpad(' ',15,' '));
281: else
282: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
283: rpad(b_rec.full_name,35,' ') || ' ' ||
284: rpad(' ',15,' ') || ' ' ||
285: rpad(l_issue_date,10,' ') || ' ' ||
286: lpad(l_assignment_action_id, 15,' ') || ' '||

Line 294: fnd_file.put_line(fnd_file.output,rpad(' ',15,' ') || ' ' ||

290: fetch csr_locked_act_dtls into l_locking_action_id, l_lock_effective_date;
291: if csr_locked_act_dtls%notfound then
292: exit;
293: end if;
294: fnd_file.put_line(fnd_file.output,rpad(' ',15,' ') || ' ' ||
295: rpad(' ',35,' ') || ' ' ||
296: rpad(' ',15,' ') || ' ' ||
297: rpad(' ',10,' ') || ' ' ||
298: lpad(' ',15,' ') || ' ' ||

Line 318: fnd_file.put_line(fnd_file.output,' ');

314: p_p45_agg_asg_action_id => l_p45_agg_asg_action_id);
315: if l_agg_assignment_id is not null then
316: l_total_count := l_total_count + 1;
317: if l_count = 0 then
318: fnd_file.put_line(fnd_file.output,' ');
319: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
320: fnd_file.put_line(fnd_file.output,' ');
321: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
322: rpad('Full Name',35,' ') || ' ' ||

Line 319: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);

315: if l_agg_assignment_id is not null then
316: l_total_count := l_total_count + 1;
317: if l_count = 0 then
318: fnd_file.put_line(fnd_file.output,' ');
319: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
320: fnd_file.put_line(fnd_file.output,' ');
321: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
322: rpad('Full Name',35,' ') || ' ' ||
323: rpad('Agg Assignment',15,' ') || ' ' ||

Line 320: fnd_file.put_line(fnd_file.output,' ');

316: l_total_count := l_total_count + 1;
317: if l_count = 0 then
318: fnd_file.put_line(fnd_file.output,' ');
319: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
320: fnd_file.put_line(fnd_file.output,' ');
321: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
322: rpad('Full Name',35,' ') || ' ' ||
323: rpad('Agg Assignment',15,' ') || ' ' ||
324: rpad('Issue Date',10,' ') || ' ' ||

Line 321: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||

317: if l_count = 0 then
318: fnd_file.put_line(fnd_file.output,' ');
319: fnd_file.put_line(fnd_file.output,'Payroll Name : ' || p_rec.payroll_name);
320: fnd_file.put_line(fnd_file.output,' ');
321: fnd_file.put_line(fnd_file.output,rpad('Assignment',15,' ') || ' ' ||
322: rpad('Full Name',35,' ') || ' ' ||
323: rpad('Agg Assignment',15,' ') || ' ' ||
324: rpad('Issue Date',10,' ') || ' ' ||
325: lpad('Asg Action ID', 15,' ') || ' ' ||

Line 328: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' ||

324: rpad('Issue Date',10,' ') || ' ' ||
325: lpad('Asg Action ID', 15,' ') || ' ' ||
326: lpad('Locking Action ID',17,' ') || ' ' ||
327: rpad('Action Eff.Date',15,' '));
328: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' ||
329: rpad('-',35,'-') || ' ' ||
330: rpad('-',15,'-') || ' ' ||
331: rpad('-',10,'-') || ' ' ||
332: lpad('-',15,'-') || ' ' ||

Line 337: --fnd_file.put_line(fnd_file.output,' l_final_payment_date '|| l_final_payment_date);

333: lpad('-',17,'-') || ' ' ||
334: rpad('-',15,'-'));
335: l_count := 1;
336: end if;
337: --fnd_file.put_line(fnd_file.output,' l_final_payment_date '|| l_final_payment_date);
338: --fnd_file.put_line(fnd_file.output,' l_agg_assignment_id ' || l_agg_assignment_id );
339: --
340: -- fetching the Assignment number for the agg.assignment id
341: --

Line 338: --fnd_file.put_line(fnd_file.output,' l_agg_assignment_id ' || l_agg_assignment_id );

334: rpad('-',15,'-'));
335: l_count := 1;
336: end if;
337: --fnd_file.put_line(fnd_file.output,' l_final_payment_date '|| l_final_payment_date);
338: --fnd_file.put_line(fnd_file.output,' l_agg_assignment_id ' || l_agg_assignment_id );
339: --
340: -- fetching the Assignment number for the agg.assignment id
341: --
342: open csr_asg_dtls(l_agg_assignment_id);

Line 353: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

349: --
350: open csr_locked_act_dtls(l_p45_agg_asg_action_id);
351: fetch csr_locked_act_dtls into l_locking_action_id, l_lock_effective_date;
352: if csr_locked_act_dtls%notfound then
353: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
354: rpad(b_rec.full_name,35,' ') || ' ' ||
355: rpad(l_agg_assignment_number,15,' ') || ' ' ||
356: rpad(l_p45_issue_date,10,' ') || ' ' ||
357: lpad(l_p45_agg_asg_action_id, 15,' ') || ' ' ||

Line 361: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||

357: lpad(l_p45_agg_asg_action_id, 15,' ') || ' ' ||
358: lpad(' ',17,' ') || ' ' ||
359: rpad(' ',15,' '));
360: else
361: fnd_file.put_line(fnd_file.output,rpad(b_rec.assignment_number,15,' ') || ' ' ||
362: rpad(b_rec.full_name,35,' ') || ' ' ||
363: rpad(l_agg_assignment_number,15,' ') || ' ' ||
364: rpad(l_p45_issue_date,10,' ') || ' ' ||
365: lpad(l_p45_agg_asg_action_id, 15,' ') || ' ' ||

Line 373: fnd_file.put_line(fnd_file.output,rpad(' ',15,' ') || ' ' ||

369: fetch csr_locked_act_dtls into l_locking_action_id, l_lock_effective_date;
370: if csr_locked_act_dtls%notfound then
371: exit;
372: end if;
373: fnd_file.put_line(fnd_file.output,rpad(' ',15,' ') || ' ' ||
374: rpad(' ',35,' ') || ' ' ||
375: rpad(' ',15,' ') || ' ' ||
376: rpad(' ',10,' ') || ' ' ||
377: lpad(' ',15,' ') || ' ' ||

Line 388: fnd_file.put_line(fnd_file.output,' ');

384:
385: end loop;
386: end loop;
387:
388: fnd_file.put_line(fnd_file.output,' ');
389: fnd_file.put_line(fnd_file.output,' ');
390: fnd_file.put_line(fnd_file.output,'Total number of active or suspended assignments/aggregated assignments issued P45: ' || l_total_count);
391:
392: END p45_issued_active_asg_report;

Line 389: fnd_file.put_line(fnd_file.output,' ');

385: end loop;
386: end loop;
387:
388: fnd_file.put_line(fnd_file.output,' ');
389: fnd_file.put_line(fnd_file.output,' ');
390: fnd_file.put_line(fnd_file.output,'Total number of active or suspended assignments/aggregated assignments issued P45: ' || l_total_count);
391:
392: END p45_issued_active_asg_report;
393:

Line 390: fnd_file.put_line(fnd_file.output,'Total number of active or suspended assignments/aggregated assignments issued P45: ' || l_total_count);

386: end loop;
387:
388: fnd_file.put_line(fnd_file.output,' ');
389: fnd_file.put_line(fnd_file.output,' ');
390: fnd_file.put_line(fnd_file.output,'Total number of active or suspended assignments/aggregated assignments issued P45: ' || l_total_count);
391:
392: END p45_issued_active_asg_report;
393:
394: END;