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.PER_FR_BIAF_REPORT dependencies on PER_FR_BIAF_REPORT

Line 1: PACKAGE BODY PER_FR_BIAF_REPORT AS

1: PACKAGE BODY PER_FR_BIAF_REPORT AS
2: /* $Header: pefrbiaf.pkb 120.11 2006/09/20 20:08:01 aparkes noship $ */
3:
4: level_cnt NUMBER;
5: vCtr NUMBER;

Line 137: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'report_date';

133: begin
134:
135: ------hr_utility.trace('Into fill_table get_data emp no '||p_employee_number||' BG ID '||to_char(p_bg_id)||' Date '||to_char(p_effective_date));
136:
137: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'report_date';
138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');
139: vCtr:=vCtr+1;
140:
141: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'effective_date';

Line 138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');

134:
135: ------hr_utility.trace('Into fill_table get_data emp no '||p_employee_number||' BG ID '||to_char(p_bg_id)||' Date '||to_char(p_effective_date));
136:
137: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'report_date';
138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');
139: vCtr:=vCtr+1;
140:
141: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'effective_date';
142: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(p_effective_date

Line 141: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'effective_date';

137: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'report_date';
138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');
139: vCtr:=vCtr+1;
140:
141: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'effective_date';
142: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(p_effective_date
143: ,'YYYY-MM-DD');
144: vCtr:=vCtr+1;
145:

Line 142: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(p_effective_date

138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');
139: vCtr:=vCtr+1;
140:
141: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'effective_date';
142: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(p_effective_date
143: ,'YYYY-MM-DD');
144: vCtr:=vCtr+1;
145:
146: for l_cursor_get_data in c_get_data(p_employee_number,p_bg_id ,p_effective_date)----For each person Body of Template

Line 149: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';

145:
146: for l_cursor_get_data in c_get_data(p_employee_number,p_bg_id ,p_effective_date)----For each person Body of Template
147: loop
148:
149: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';
150: vCtr:=vCtr+1;
151:
152: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'FLAG';
153: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := '1';

Line 152: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'FLAG';

148:
149: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';
150: vCtr:=vCtr+1;
151:
152: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'FLAG';
153: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := '1';
154: vCtr:=vCtr+1;
155: ------hr_utility.trace('Into cursor '||p_employee_number);
156: for l_c_get_lookup in c_get_lookup ----From Lookup BIAF_LOOKUP_CODE --

Line 153: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := '1';

149: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';
150: vCtr:=vCtr+1;
151:
152: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'FLAG';
153: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := '1';
154: vCtr:=vCtr+1;
155: ------hr_utility.trace('Into cursor '||p_employee_number);
156: for l_c_get_lookup in c_get_lookup ----From Lookup BIAF_LOOKUP_CODE --
157: loop

Line 160: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := l_c_get_lookup.lookup_code;

156: for l_c_get_lookup in c_get_lookup ----From Lookup BIAF_LOOKUP_CODE --
157: loop
158:
159:
160: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := l_c_get_lookup.lookup_code;
161: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_c_get_lookup.meaning);
162: vCtr:=vCtr+1;
163:
164:

Line 161: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_c_get_lookup.meaning);

157: loop
158:
159:
160: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := l_c_get_lookup.lookup_code;
161: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_c_get_lookup.meaning);
162: vCtr:=vCtr+1;
163:
164:
165: end loop; ---Label of the template

Line 169: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'employee_number';

165: end loop; ---Label of the template
166:
167:
168: ------------hr_utility.trace('Into fill_table get_data emp no '||(p_employee_number));
169: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'employee_number';
170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;
171: vCtr:=vCtr+1;
172:
173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';

Line 170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;

166:
167:
168: ------------hr_utility.trace('Into fill_table get_data emp no '||(p_employee_number));
169: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'employee_number';
170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;
171: vCtr:=vCtr+1;
172:
173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';
174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);

Line 173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';

169: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'employee_number';
170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;
171: vCtr:=vCtr+1;
172:
173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';
174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);
175: vCtr:=vCtr+1;
176:
177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';

Line 174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);

170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;
171: vCtr:=vCtr+1;
172:
173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';
174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);
175: vCtr:=vCtr+1;
176:
177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';
178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);

Line 177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';

173: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'last_name';
174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);
175: vCtr:=vCtr+1;
176:
177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';
178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);
179: vCtr:=vCtr+1;
180:
181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';

Line 178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);

174: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.last_name);
175: vCtr:=vCtr+1;
176:
177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';
178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);
179: vCtr:=vCtr+1;
180:
181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';
182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);

Line 181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';

177: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'first_name';
178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);
179: vCtr:=vCtr+1;
180:
181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';
182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);
183: vCtr:=vCtr+1;
184:
185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';

Line 182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);

178: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.first_name);
179: vCtr:=vCtr+1;
180:
181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';
182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);
183: vCtr:=vCtr+1;
184:
185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';
186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);

Line 185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';

181: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'full_name';
182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);
183: vCtr:=vCtr+1;
184:
185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';
186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);
187: vCtr:=vCtr+1;
188:
189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';

Line 186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);

182: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.full_name);
183: vCtr:=vCtr+1;
184:
185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';
186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);
187: vCtr:=vCtr+1;
188:
189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';
190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');

Line 189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';

185: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'maiden';
186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);
187: vCtr:=vCtr+1;
188:
189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';
190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');
191: vCtr:=vCtr+1;
192:
193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';

Line 190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');

186: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.maiden);
187: vCtr:=vCtr+1;
188:
189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';
190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');
191: vCtr:=vCtr+1;
192:
193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';
194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);

Line 193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';

189: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'date_of_birth';
190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');
191: vCtr:=vCtr+1;
192:
193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';
194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);
195: vCtr:=vCtr+1;
196:
197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';

Line 194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);

190: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.date_of_birth,'YYYY-MM-DD');
191: vCtr:=vCtr+1;
192:
193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';
194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);
195: vCtr:=vCtr+1;
196:
197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';
198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');

Line 197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';

193: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'national_identifier';
194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);
195: vCtr:=vCtr+1;
196:
197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';
198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');
199: vCtr:=vCtr+1;
200:
201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';

Line 198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');

194: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.national_identifier);
195: vCtr:=vCtr+1;
196:
197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';
198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');
199: vCtr:=vCtr+1;
200:
201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';
202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');

Line 201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';

197: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'original_date_of_hire';
198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');
199: vCtr:=vCtr+1;
200:
201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';
202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
203: vCtr:=vCtr+1;
204:
205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';

Line 202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');

198: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(get_contract_start_date(l_cursor_get_data.person_id),'YYYY-MM-DD');
199: vCtr:=vCtr+1;
200:
201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';
202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
203: vCtr:=vCtr+1;
204:
205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';
206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');

Line 205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';

201: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_start_date';
202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
203: vCtr:=vCtr+1;
204:
205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';
206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
207: vCtr:=vCtr+1;
208:
209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';

Line 206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');

202: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_start_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
203: vCtr:=vCtr+1;
204:
205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';
206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
207: vCtr:=vCtr+1;
208:
209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';
210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');

Line 209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';

205: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'contract_end_date';
206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
207: vCtr:=vCtr+1;
208:
209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';
210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');
211: vCtr:=vCtr+1;
212:
213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';

Line 210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');

206: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(hr_contract_api.get_active_end_date(l_cursor_get_data.contract_id,p_effective_date,l_cursor_get_data.status),'YYYY-MM-DD');
207: vCtr:=vCtr+1;
208:
209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';
210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');
211: vCtr:=vCtr+1;
212:
213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';
214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);

Line 213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';

209: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'proposed_end_date';
210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');
211: vCtr:=vCtr+1;
212:
213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';
214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);
215: vCtr:=vCtr+1;
216:
217: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'unit';

Line 214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);

210: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(l_cursor_get_data.proposed_end_date),'YYYY-MM-DD');
211: vCtr:=vCtr+1;
212:
213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';
214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);
215: vCtr:=vCtr+1;
216:
217: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'unit';
218: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (hr_contract_api.get_meaning(l_cursor_get_data.units,'QUALIFYING_UNITS'));

Line 217: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'unit';

213: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'duration';
214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);
215: vCtr:=vCtr+1;
216:
217: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'unit';
218: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (hr_contract_api.get_meaning(l_cursor_get_data.units,'QUALIFYING_UNITS'));
219: vCtr:=vCtr+1;
220:
221:

Line 218: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (hr_contract_api.get_meaning(l_cursor_get_data.units,'QUALIFYING_UNITS'));

214: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(l_cursor_get_data.duration);
215: vCtr:=vCtr+1;
216:
217: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'unit';
218: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (hr_contract_api.get_meaning(l_cursor_get_data.units,'QUALIFYING_UNITS'));
219: vCtr:=vCtr+1;
220:
221:
222: -----Person Address Section-------------

Line 226: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP1';

222: -----Person Address Section-------------
223:
224:
225:
226: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP1';
227: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PNumber_Road);
228: vCtr:=vCtr+1;
229:
230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';

Line 227: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PNumber_Road);

223:
224:
225:
226: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP1';
227: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PNumber_Road);
228: vCtr:=vCtr+1;
229:
230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';
231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);

Line 230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';

226: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP1';
227: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PNumber_Road);
228: vCtr:=vCtr+1;
229:
230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';
231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);
232: vCtr:=vCtr+1;
233:
234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';

Line 231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);

227: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PNumber_Road);
228: vCtr:=vCtr+1;
229:
230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';
231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);
232: vCtr:=vCtr+1;
233:
234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';
235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);

Line 234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';

230: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP2';
231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);
232: vCtr:=vCtr+1;
233:
234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';
235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);
236: vCtr:=vCtr+1;
237:
238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';

Line 235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);

231: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PComplement);
232: vCtr:=vCtr+1;
233:
234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';
235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);
236: vCtr:=vCtr+1;
237:
238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';
239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);

Line 238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';

234: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP3';
235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);
236: vCtr:=vCtr+1;
237:
238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';
239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);
240: vCtr:=vCtr+1;
241:
242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';

Line 239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);

235: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.POther);
236: vCtr:=vCtr+1;
237:
238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';
239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);
240: vCtr:=vCtr+1;
241:
242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';
243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);

Line 242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';

238: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP4';
239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);
240: vCtr:=vCtr+1;
241:
242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';
243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);
244: vCtr:=vCtr+1;
245:
246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';

Line 243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);

239: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PINSEE_Code);
240: vCtr:=vCtr+1;
241:
242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';
243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);
244: vCtr:=vCtr+1;
245:
246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';
247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);

Line 246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';

242: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP5';
243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);
244: vCtr:=vCtr+1;
245:
246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';
247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);
248: vCtr:=vCtr+1;
249:
250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';

Line 247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);

243: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PSmall_Town);
244: vCtr:=vCtr+1;
245:
246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';
247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);
248: vCtr:=vCtr+1;
249:
250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';
251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);

Line 250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';

246: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP6';
247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);
248: vCtr:=vCtr+1;
249:
250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';
251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);
252: vCtr:=vCtr+1;
253:
254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';

Line 251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);

247: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PPostal_Code);
248: vCtr:=vCtr+1;
249:
250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';
251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);
252: vCtr:=vCtr+1;
253:
254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';
255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);

Line 254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';

250: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP7';
251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);
252: vCtr:=vCtr+1;
253:
254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';
255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);
256: vCtr:=vCtr+1;
257:
258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';

Line 255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);

251: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCity);
252: vCtr:=vCtr+1;
253:
254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';
255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);
256: vCtr:=vCtr+1;
257:
258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';
259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);

Line 258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';

254: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP8';
255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);
256: vCtr:=vCtr+1;
257:
258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';
259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);
260: vCtr:=vCtr+1;
261:
262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';

Line 259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);

255: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PDepartment);
256: vCtr:=vCtr+1;
257:
258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';
259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);
260: vCtr:=vCtr+1;
261:
262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';
263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);

Line 262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';

258: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP9';
259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);
260: vCtr:=vCtr+1;
261:
262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';
263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);
264: vCtr:=vCtr+1;
265:
266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';

Line 263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);

259: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PCountry);
260: vCtr:=vCtr+1;
261:
262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';
263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);
264: vCtr:=vCtr+1;
265:
266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';
267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);

Line 266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';

262: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP10';
263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);
264: vCtr:=vCtr+1;
265:
266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';
267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);
268: vCtr:=vCtr+1;
269:
270: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP12';

Line 267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);

263: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone);
264: vCtr:=vCtr+1;
265:
266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';
267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);
268: vCtr:=vCtr+1;
269:
270: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP12';
271: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone3);

Line 270: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP12';

266: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP11';
267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);
268: vCtr:=vCtr+1;
269:
270: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP12';
271: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone3);
272: vCtr:=vCtr+1;
273:
274: -----------END OF PERSONAL ADDRESS--------------------------------------------------------

Line 271: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone3);

267: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.PFax);
268: vCtr:=vCtr+1;
269:
270: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADP12';
271: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.PTelephone3);
272: vCtr:=vCtr+1;
273:
274: -----------END OF PERSONAL ADDRESS--------------------------------------------------------
275:

Line 278: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'siret';

274: -----------END OF PERSONAL ADDRESS--------------------------------------------------------
275:
276:
277:
278: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'siret';
279: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.siret);
280: vCtr:=vCtr+1;
281:
282: select meaning into l_naf_meaning from fnd_common_lookups where lookup_type='FR_NAF_CODE'

Line 279: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.siret);

275:
276:
277:
278: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'siret';
279: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.siret);
280: vCtr:=vCtr+1;
281:
282: select meaning into l_naf_meaning from fnd_common_lookups where lookup_type='FR_NAF_CODE'
283: and lookup_code=l_cursor_get_data.NAF;

Line 285: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ape';

281:
282: select meaning into l_naf_meaning from fnd_common_lookups where lookup_type='FR_NAF_CODE'
283: and lookup_code=l_cursor_get_data.NAF;
284:
285: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ape';
286: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_naf_meaning);
287: vCtr:=vCtr+1;
288:
289:

Line 286: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_naf_meaning);

282: select meaning into l_naf_meaning from fnd_common_lookups where lookup_type='FR_NAF_CODE'
283: and lookup_code=l_cursor_get_data.NAF;
284:
285: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ape';
286: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_naf_meaning);
287: vCtr:=vCtr+1;
288:
289:
290:

Line 292: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_headcount';

288:
289:
290:
291:
292: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_headcount';
293: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=to_char( get_emp_total(lp_effective_date =>l_cursor_get_data.actual_termination_date, --get_contract_start_date(l_cursor_get_data.person_id),
294: lp_est_id =>l_cursor_get_data.est_id ,
295: -- lp_ent_id =>null,
296: -- lp_sex =>null,

Line 293: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=to_char( get_emp_total(lp_effective_date =>l_cursor_get_data.actual_termination_date, --get_contract_start_date(l_cursor_get_data.person_id),

289:
290:
291:
292: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_headcount';
293: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=to_char( get_emp_total(lp_effective_date =>l_cursor_get_data.actual_termination_date, --get_contract_start_date(l_cursor_get_data.person_id),
294: lp_est_id =>l_cursor_get_data.est_id ,
295: -- lp_ent_id =>null,
296: -- lp_sex =>null,
297: lp_udt_column => 'INCLUDE_DUE'

Line 303: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_name';

299: ));
300: vCtr:=vCtr+1;
301: hr_utility.trace('Establishment Headcount ');
302:
303: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_name';
304: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.establishment_name);
305: vCtr:=vCtr+1;
306:
307: ------ESTABLISHMENT ADDRESS SECTION---------------------------------------

Line 304: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.establishment_name);

300: vCtr:=vCtr+1;
301: hr_utility.trace('Establishment Headcount ');
302:
303: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_name';
304: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.establishment_name);
305: vCtr:=vCtr+1;
306:
307: ------ESTABLISHMENT ADDRESS SECTION---------------------------------------
308:

Line 309: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE1';

305: vCtr:=vCtr+1;
306:
307: ------ESTABLISHMENT ADDRESS SECTION---------------------------------------
308:
309: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE1';
310: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Number_Road);
311: vCtr:=vCtr+1;
312:
313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';

Line 310: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Number_Road);

306:
307: ------ESTABLISHMENT ADDRESS SECTION---------------------------------------
308:
309: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE1';
310: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Number_Road);
311: vCtr:=vCtr+1;
312:
313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';
314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);

Line 313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';

309: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE1';
310: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Number_Road);
311: vCtr:=vCtr+1;
312:
313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';
314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);
315: vCtr:=vCtr+1;
316:
317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';

Line 314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);

310: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Number_Road);
311: vCtr:=vCtr+1;
312:
313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';
314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);
315: vCtr:=vCtr+1;
316:
317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';
318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);

Line 317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';

313: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE2';
314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);
315: vCtr:=vCtr+1;
316:
317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';
318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);
319: vCtr:=vCtr+1;
320:
321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';

Line 318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);

314: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Complement);
315: vCtr:=vCtr+1;
316:
317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';
318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);
319: vCtr:=vCtr+1;
320:
321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';
322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);

Line 321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';

317: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE3';
318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);
319: vCtr:=vCtr+1;
320:
321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';
322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);
323: vCtr:=vCtr+1;
324:
325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';

Line 322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);

318: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Other);
319: vCtr:=vCtr+1;
320:
321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';
322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);
323: vCtr:=vCtr+1;
324:
325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';
326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);

Line 325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';

321: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE4';
322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);
323: vCtr:=vCtr+1;
324:
325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';
326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);
327: vCtr:=vCtr+1;
328:
329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';

Line 326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);

322: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.INSEE_Code);
323: vCtr:=vCtr+1;
324:
325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';
326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);
327: vCtr:=vCtr+1;
328:
329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';
330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);

Line 329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';

325: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE5';
326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);
327: vCtr:=vCtr+1;
328:
329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';
330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);
331: vCtr:=vCtr+1;
332:
333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';

Line 330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);

326: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Small_Town);
327: vCtr:=vCtr+1;
328:
329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';
330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);
331: vCtr:=vCtr+1;
332:
333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';
334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);

Line 333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';

329: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE6';
330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);
331: vCtr:=vCtr+1;
332:
333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';
334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);
335: vCtr:=vCtr+1;
336:
337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';

Line 334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);

330: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Postal_Code);
331: vCtr:=vCtr+1;
332:
333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';
334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);
335: vCtr:=vCtr+1;
336:
337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';
338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);

Line 337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';

333: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE7';
334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);
335: vCtr:=vCtr+1;
336:
337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';
338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);
339: vCtr:=vCtr+1;
340:
341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';

Line 338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);

334: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.City);
335: vCtr:=vCtr+1;
336:
337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';
338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);
339: vCtr:=vCtr+1;
340:
341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';
342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);

Line 341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';

337: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE8';
338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);
339: vCtr:=vCtr+1;
340:
341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';
342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);
343: vCtr:=vCtr+1;
344:
345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';

Line 342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);

338: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Department);
339: vCtr:=vCtr+1;
340:
341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';
342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);
343: vCtr:=vCtr+1;
344:
345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';
346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);

Line 345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';

341: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE9';
342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);
343: vCtr:=vCtr+1;
344:
345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';
346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);
347: vCtr:=vCtr+1;
348:
349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';

Line 346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);

342: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Country);
343: vCtr:=vCtr+1;
344:
345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';
346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);
347: vCtr:=vCtr+1;
348:
349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';
350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);

Line 349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';

345: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE10';
346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);
347: vCtr:=vCtr+1;
348:
349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';
350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);
351: vCtr:=vCtr+1;
352:
353: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE12';

Line 350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);

346: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone);
347: vCtr:=vCtr+1;
348:
349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';
350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);
351: vCtr:=vCtr+1;
352:
353: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE12';
354: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone3);

Line 353: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE12';

349: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE11';
350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);
351: vCtr:=vCtr+1;
352:
353: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE12';
354: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone3);
355: vCtr:=vCtr+1;
356:
357: -----------------------END OF ESTABLISHMENT ADDRESS--------------------

Line 354: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone3);

350: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(l_cursor_get_data.Fax);
351: vCtr:=vCtr+1;
352:
353: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADE12';
354: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.Telephone3);
355: vCtr:=vCtr+1;
356:
357: -----------------------END OF ESTABLISHMENT ADDRESS--------------------
358:

Line 360: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_address';

356:
357: -----------------------END OF ESTABLISHMENT ADDRESS--------------------
358:
359: /*
360: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_address';
361: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_establishment_address);
362: vCtr:=vCtr+1; */
363:
364: -----------------------TRAINING BODY ADDRESS SECTION---------------------

Line 361: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_establishment_address);

357: -----------------------END OF ESTABLISHMENT ADDRESS--------------------
358:
359: /*
360: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_address';
361: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_establishment_address);
362: vCtr:=vCtr+1; */
363:
364: -----------------------TRAINING BODY ADDRESS SECTION---------------------
365:

Line 371: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'tax_paid_to';

367: fetch c_trg_addr into lc_trg_addr;
368:
369: hr_utility.trace('Training Address ');
370:
371: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'tax_paid_to';
372: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.trg_bd_name);
373: vCtr:=vCtr+1;
374:
375:

Line 372: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.trg_bd_name);

368:
369: hr_utility.trace('Training Address ');
370:
371: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'tax_paid_to';
372: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.trg_bd_name);
373: vCtr:=vCtr+1;
374:
375:
376: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT1';

Line 376: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT1';

372: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.trg_bd_name);
373: vCtr:=vCtr+1;
374:
375:
376: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT1';
377: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Number_Road);
378: vCtr:=vCtr+1;
379:
380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';

Line 377: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Number_Road);

373: vCtr:=vCtr+1;
374:
375:
376: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT1';
377: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Number_Road);
378: vCtr:=vCtr+1;
379:
380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';
381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);

Line 380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';

376: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT1';
377: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Number_Road);
378: vCtr:=vCtr+1;
379:
380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';
381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);
382: vCtr:=vCtr+1;
383:
384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';

Line 381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);

377: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Number_Road);
378: vCtr:=vCtr+1;
379:
380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';
381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);
382: vCtr:=vCtr+1;
383:
384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';
385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);

Line 384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';

380: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT2';
381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);
382: vCtr:=vCtr+1;
383:
384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';
385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);
386: vCtr:=vCtr+1;
387:
388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';

Line 385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);

381: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Complement);
382: vCtr:=vCtr+1;
383:
384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';
385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);
386: vCtr:=vCtr+1;
387:
388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';
389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);

Line 388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';

384: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT3';
385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);
386: vCtr:=vCtr+1;
387:
388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';
389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);
390: vCtr:=vCtr+1;
391:
392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';

Line 389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);

385: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Other);
386: vCtr:=vCtr+1;
387:
388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';
389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);
390: vCtr:=vCtr+1;
391:
392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';
393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);

Line 392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';

388: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT4';
389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);
390: vCtr:=vCtr+1;
391:
392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';
393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);
394: vCtr:=vCtr+1;
395:
396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';

Line 393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);

389: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.INSEE_Code);
390: vCtr:=vCtr+1;
391:
392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';
393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);
394: vCtr:=vCtr+1;
395:
396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';
397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);

Line 396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';

392: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT5';
393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);
394: vCtr:=vCtr+1;
395:
396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';
397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);
398: vCtr:=vCtr+1;
399:
400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';

Line 397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);

393: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Small_Town);
394: vCtr:=vCtr+1;
395:
396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';
397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);
398: vCtr:=vCtr+1;
399:
400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';
401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);

Line 400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';

396: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT6';
397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);
398: vCtr:=vCtr+1;
399:
400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';
401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);
402: vCtr:=vCtr+1;
403:
404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';

Line 401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);

397: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Postal_Code);
398: vCtr:=vCtr+1;
399:
400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';
401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);
402: vCtr:=vCtr+1;
403:
404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';
405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);

Line 404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';

400: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT7';
401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);
402: vCtr:=vCtr+1;
403:
404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';
405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);
406: vCtr:=vCtr+1;
407:
408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';

Line 405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);

401: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.City);
402: vCtr:=vCtr+1;
403:
404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';
405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);
406: vCtr:=vCtr+1;
407:
408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';
409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);

Line 408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';

404: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT8';
405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);
406: vCtr:=vCtr+1;
407:
408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';
409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);
410: vCtr:=vCtr+1;
411:
412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';

Line 409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);

405: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Department);
406: vCtr:=vCtr+1;
407:
408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';
409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);
410: vCtr:=vCtr+1;
411:
412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';
413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);

Line 412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';

408: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT9';
409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);
410: vCtr:=vCtr+1;
411:
412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';
413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);
414: vCtr:=vCtr+1;
415:
416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';

Line 413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);

409: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Country);
410: vCtr:=vCtr+1;
411:
412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';
413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);
414: vCtr:=vCtr+1;
415:
416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';
417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);

Line 416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';

412: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT10';
413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);
414: vCtr:=vCtr+1;
415:
416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';
417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);
418: vCtr:=vCtr+1;
419:
420: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT12';

Line 417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);

413: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone);
414: vCtr:=vCtr+1;
415:
416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';
417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);
418: vCtr:=vCtr+1;
419:
420: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT12';
421: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone3);

Line 420: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT12';

416: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT11';
417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);
418: vCtr:=vCtr+1;
419:
420: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT12';
421: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone3);
422: vCtr:=vCtr+1;
423: close c_trg_addr; --Cursor for each person Traning Body Address
424:

Line 421: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone3);

417: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue :=(lc_trg_addr.Fax);
418: vCtr:=vCtr+1;
419:
420: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'ADT12';
421: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone3);
422: vCtr:=vCtr+1;
423: close c_trg_addr; --Cursor for each person Traning Body Address
424:
425: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';

Line 425: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';

421: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.Telephone3);
422: vCtr:=vCtr+1;
423: close c_trg_addr; --Cursor for each person Traning Body Address
424:
425: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'L_REPORT';
426: vCtr:=vCtr+1;
427:
428: end loop;----For each Person
429: end fill_table;

Line 659: PER_FR_BIAF_REPORT.vXMLTable.DELETE;

655:
656:
657:
658: --hr_utility.trace_on(null,'BIAF1');
659: PER_FR_BIAF_REPORT.vXMLTable.DELETE;
660: vCtr:=0;
661:
662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));
663: ------hr_utility.TRACE('Business Group ID ' || p_bg_id);

Line 719: PER_FR_BIAF_REPORT.WritetoCLOB (p_xfdf_blob );

715: end if;
716:
717: --hr_utility.TRACE('Counter ' || (vCtr));
718:
719: PER_FR_BIAF_REPORT.WritetoCLOB (p_xfdf_blob );
720:
721:
722:
723: end POPULATE_REPORT_DATA;

Line 861: end PER_FR_BIAF_REPORT;

857: hr_utility.set_location('Finished Procedure clob to blob ',130);
858: end;
859:
860:
861: end PER_FR_BIAF_REPORT;
862:
863: