109: l_fin_year_end := to_date('30-06-' || p_financial_year_end, 'dd-mm-yyyy');
110:
111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
110:
111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
111: l_asg_tab.delete;
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
112:
113: fnd_file.put_line(fnd_file.output, ' Listing of Assignments who have changed Legal Employer in Financial Year');
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
114: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
115: fnd_file.put_line(fnd_file.output, ' ');
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
116: fnd_file.put_line(fnd_file.output, 'Report Date : ' ||
117: to_char(l_today, 'dd-MON-yyyy' ));
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
118: fnd_file.put_line(fnd_file.output, ' ');
119: fnd_file.put_line(fnd_file.output, 'Parameters : ');
120: fnd_file.put_line(fnd_file.output, ' Business Group Id : ' ||
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
121: l_business_group_name );
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
127:
128: for asg_rec in c_select_assignments(p_business_group_id,
129: l_fin_year_start,
122: fnd_file.put_line(fnd_file.output, ' Financial Year : ' ||
123: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
124: to_char(l_fin_year_end, 'dd-MON-yyyy') );
125: fnd_file.put_line(fnd_file.output, ' ');
126: fnd_file.put_line(fnd_file.output, '---------------------------------------------------------------------------- ');
127:
128: for asg_rec in c_select_assignments(p_business_group_id,
129: l_fin_year_start,
130: l_fin_year_end)
154: l_prev_legal_emp := asg_rec.segment1;
155:
156: end loop;
157:
158: fnd_file.put_line(fnd_file.output, ' ');
159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
155:
156: end loop;
157:
158: fnd_file.put_line(fnd_file.output, ' ');
159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');
159: fnd_file.put_line(fnd_file.output, 'Assignments that have changed legal employer in ' ||
160: 'financial year ' ||
161: to_char(l_fin_year_start, 'dd-MON-yyyy') || ' to ' ||
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');
162: to_char(l_fin_year_end, 'dd-MON-yyyy') );
163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');
168: end if;
169:
170: if l_asg_tab.count > 0 then
163: fnd_file.put_line(fnd_file.output, ' ');
164:
165: if l_asg_tab.count > 0 then
166: fnd_file.put_line(fnd_file.output, ' Full Name Assignment Number Date of New LE New Legal Employer Previous Legal Employer');
167: fnd_file.put_line(fnd_file.output, ' ');
168: end if;
169:
170: if l_asg_tab.count > 0 then
171: for i in 1..l_asg_tab.last
194: and l_fin_year_end between per.effective_start_date and per.effective_end_date;
195:
196: -- Output the line.
197:
198: fnd_file.put_line(fnd_file.output,
199: ' ' || rpad(l_asg_tab(i).full_name, 30, ' ') ||
200: ' ' || rpad(l_asg_tab(i).assignment_number, 15, ' ') ||
201: ' ' || to_char(l_asg_tab(i).effective_start_date, 'dd-MON-yyyy') ||
202: ' ' || rpad(l_asg_tab(i).seg1_name, 30, ' ') ||
203: ' ' || rpad(l_asg_tab(i).seg1_prev_name, 30, ' ')
204: );
205: end loop;
206: else
207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
206: else
207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
207: fnd_file.put_line(fnd_file.output, 'No assignments have had a legal employer change in the specified financial year');
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
208: end if;
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION
209:
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION
217: WHEN OTHERS THEN
210: fnd_file.put_line(fnd_file.output, ' ');
211: fnd_file.put_line(fnd_file.output, ' ');
212: fnd_file.put_line(fnd_file.output, ' ');
213: fnd_file.put_line(fnd_file.output, ' ');
214: fnd_file.put_line(fnd_file.output, ' E N D O F R E P O R T ');
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: hr_utility.trace('AU : Exception, Leaving: '|| l_proc_name);