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_NL_RETRO_SETUP_REPORT dependencies on PAY_NL_XDO_REPORT

Line 173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';

169: FETCH csr_bg_name INTO l_bg_name;
170: CLOSE csr_bg_name;
171:
172: -- Setting PL/SQL table for tags and values of data be reported once.
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_effec_date);
175: vCtr := vCtr + 1;
176:
177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

Line 174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_effec_date);

170: CLOSE csr_bg_name;
171:
172: -- Setting PL/SQL table for tags and values of data be reported once.
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_effec_date);
175: vCtr := vCtr + 1;
176:
177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;

Line 177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_effec_date);
175: vCtr := vCtr + 1;
176:
177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;
179: vCtr := vCtr + 1;
180:
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';

Line 178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;

174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_effec_date);
175: vCtr := vCtr + 1;
176:
177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;
179: vCtr := vCtr + 1;
180:
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);

Line 181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';

177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;
179: vCtr := vCtr + 1;
180:
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);
183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);

Line 182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);

178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;
179: vCtr := vCtr + 1;
180:
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);
183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);

Line 194: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';

190:
191: FOR v_get_ele_class IN csr_get_ele_class(p_business_group_id,p_ele_records)
192: LOOP
193:
194: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';
195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
196: vCtr := vCtr + 1;
197:
198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';

Line 195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

191: FOR v_get_ele_class IN csr_get_ele_class(p_business_group_id,p_ele_records)
192: LOOP
193:
194: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';
195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
196: vCtr := vCtr + 1;
197:
198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';
199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;

Line 198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';

194: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';
195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
196: vCtr := vCtr + 1;
197:
198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';
199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;
200: vCtr := vCtr + 1;
201:
202: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',660);

Line 199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;

195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
196: vCtr := vCtr + 1;
197:
198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';
199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;
200: vCtr := vCtr + 1;
201:
202: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',660);
203: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_class.classification_name,'NULL'),680);

Line 237: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';

233:
234: END IF;
235: END IF;
236:
237: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
238: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
239: vCtr := vCtr + 1;
240:
241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';

Line 238: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

234: END IF;
235: END IF;
236:
237: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
238: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
239: vCtr := vCtr + 1;
240:
241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;

Line 241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';

237: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
238: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
239: vCtr := vCtr + 1;
240:
241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;
243: vCtr := vCtr + 1;
244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;

Line 242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;

238: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
239: vCtr := vCtr + 1;
240:
241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;
243: vCtr := vCtr + 1;
244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;
246: vCtr := vCtr + 1;

Line 244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';

240:
241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;
243: vCtr := vCtr + 1;
244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;
246: vCtr := vCtr + 1;
247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;

Line 245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;

241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_element ;
243: vCtr := vCtr + 1;
244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;
246: vCtr := vCtr + 1;
247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;
249: vCtr := vCtr + 1;

Line 247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';

243: vCtr := vCtr + 1;
244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;
246: vCtr := vCtr + 1;
247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;
249: vCtr := vCtr + 1;
250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;

Line 248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;

244: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'COMPONENT';
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_show_component;
246: vCtr := vCtr + 1;
247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;
249: vCtr := vCtr + 1;
250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;
252: vCtr := vCtr + 1;

Line 250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';

246: vCtr := vCtr + 1;
247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;
249: vCtr := vCtr + 1;
250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;
252: vCtr := vCtr + 1;
253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;

Line 251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;

247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPROCESS_TYPE';
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_reprocess_type;
249: vCtr := vCtr + 1;
250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;
252: vCtr := vCtr + 1;
253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;
255: vCtr := vCtr + 1;

Line 253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';

249: vCtr := vCtr + 1;
250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;
252: vCtr := vCtr + 1;
253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;
255: vCtr := vCtr + 1;
256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;

Line 254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;

250: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DEFAULT_COMP';
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_default_comp;
252: vCtr := vCtr + 1;
253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;
255: vCtr := vCtr + 1;
256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;
258: vCtr := vCtr + 1;

Line 256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';

252: vCtr := vCtr + 1;
253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;
255: vCtr := vCtr + 1;
256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;
258: vCtr := vCtr + 1;
259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;

Line 257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;

253: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REPLACE_RUN';
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_replace_run;
255: vCtr := vCtr + 1;
256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;
258: vCtr := vCtr + 1;
259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;
261: vCtr := vCtr + 1;

Line 259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';

255: vCtr := vCtr + 1;
256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;
258: vCtr := vCtr + 1;
259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;
261: vCtr := vCtr + 1;
262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;

Line 260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;

256: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'OVERRIDE_DATE';
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_override_dates;
258: vCtr := vCtr + 1;
259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;
261: vCtr := vCtr + 1;
262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;
264: vCtr := vCtr + 1;

Line 262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';

258: vCtr := vCtr + 1;
259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;
261: vCtr := vCtr + 1;
262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;
264: vCtr := vCtr + 1;
265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;

Line 263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;

259: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_FROM';
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_From;
261: vCtr := vCtr + 1;
262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;
264: vCtr := vCtr + 1;
265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;
267: vCtr := vCtr + 1;

Line 265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';

261: vCtr := vCtr + 1;
262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;
264: vCtr := vCtr + 1;
265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;
267: vCtr := vCtr + 1;
268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;

Line 266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;

262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TIME_TO';
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Time_To;
264: vCtr := vCtr + 1;
265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;
267: vCtr := vCtr + 1;
268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;
270: vCtr := vCtr + 1;

Line 268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';

264: vCtr := vCtr + 1;
265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;
267: vCtr := vCtr + 1;
268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;
270: vCtr := vCtr + 1;
271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;

265: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELEMENT';
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.Retro_Element;
267: vCtr := vCtr + 1;
268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;
270: vCtr := vCtr + 1;
271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
273: vCtr := vCtr + 1;

Line 271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';

267: vCtr := vCtr + 1;
268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;
270: vCtr := vCtr + 1;
271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
273: vCtr := vCtr + 1;
274:
275: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',700);

Line 272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_ELE_CLASS';
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_element_record.classification_name;
270: vCtr := vCtr + 1;
271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
273: vCtr := vCtr + 1;
274:
275: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',700);
276: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_element_record.element_name,'NULL'),720);

Line 284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';

280: IF p_ele_records = 'A' THEN
281: FOR v_get_ele_without_ret
282: IN csr_get_ele_without_ret(p_business_group_id,l_effec_date,v_get_ele_class.classification_id)
283: LOOP
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
286: vCtr := vCtr + 1;
287:
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';

Line 285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

281: FOR v_get_ele_without_ret
282: IN csr_get_ele_without_ret(p_business_group_id,l_effec_date,v_get_ele_class.classification_id)
283: LOOP
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
286: vCtr := vCtr + 1;
287:
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;

Line 288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';

284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
286: vCtr := vCtr + 1;
287:
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;
290: vCtr := vCtr + 1;
291:
292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';

Line 289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;

285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
286: vCtr := vCtr + 1;
287:
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;
290: vCtr := vCtr + 1;
291:
292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';

288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELEMENT_NAME';
289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;
290: vCtr := vCtr + 1;
291:
292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
294: vCtr := vCtr + 1;
295:
296: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',740);

Line 293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

289: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_without_ret.element_name ;
290: vCtr := vCtr + 1;
291:
292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
294: vCtr := vCtr + 1;
295:
296: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',740);
297: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_without_ret.element_name,'NULL'),760);

Line 301: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';

297: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_without_ret.element_name,'NULL'),760);
298: END LOOP;
299: END IF;
300:
301: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
303: vCtr := vCtr + 1;
304:
305: END LOOP;

Line 302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

298: END LOOP;
299: END IF;
300:
301: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
303: vCtr := vCtr + 1;
304:
305: END LOOP;
306:

Line 323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then

319:
320: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
321: dbms_lob.writeAppend( l_xml, length(l_str11), l_str11 );
322:
323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);

Line 326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP

322:
323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);
328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;
329: l_str9 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagValue;
330: if (substr(l_str8,1,11) = 'G_CONTAINER') then

Line 327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);

323: if PAY_NL_XDO_REPORT.vXMLTable.count > 0 then
324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);
328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;
329: l_str9 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagValue;
330: if (substr(l_str8,1,11) = 'G_CONTAINER') then
331: if (l_str9 is null) then

Line 328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;

324: dbms_lob.writeAppend( l_xml, length(l_str1), l_str1 );
325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);
328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;
329: l_str9 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagValue;
330: if (substr(l_str8,1,11) = 'G_CONTAINER') then
331: if (l_str9 is null) then
332: l_str := l_str2||l_str8||l_str3;

Line 329: l_str9 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagValue;

325: hr_utility.set_location('Before Procedure Write to clob: before loop',102);
326: FOR ctr_table IN PAY_NL_XDO_REPORT.vXMLTable.FIRST .. PAY_NL_XDO_REPORT.vXMLTable.LAST LOOP
327: hr_utility.set_location('Before Procedure Write to clob: Inside loop'||PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName,104);
328: l_str8 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagName;
329: l_str9 := PAY_NL_XDO_REPORT.vXMLTable(ctr_table).TagValue;
330: if (substr(l_str8,1,11) = 'G_CONTAINER') then
331: if (l_str9 is null) then
332: l_str := l_str2||l_str8||l_str3;
333: