eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on DBMS_LOB

Line 102: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);

98:
99: begin
100:
101:
102: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
103: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
104:
105: open cur_get_input_time(p_period,p_payroll);
106: fetch cur_get_input_time into l_period ;

Line 103: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);

99: begin
100:
101:
102: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
103: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
104:
105: open cur_get_input_time(p_period,p_payroll);
106: fetch cur_get_input_time into l_period ;
107: close cur_get_input_time;

Line 130: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

126: l_string := l_string || ''||l_period.end_date||''||EOL;
127: l_string := l_string || ''||0||''||EOL;
128: l_string := l_string || ''||l_payroll_name.payroll_name||''||EOL;
129: l_string := l_string || ''||l_period.period_name||''||EOL;
130: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
131: l_string := null;
132:
133: OPEN cur_element_entry_assignment(l_period.end_date,p_payroll);
134:

Line 175: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

171: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.opt_out_period_end_date))||''||EOL;
172: l_string := l_string || ''||l_input_id_value.qualifying_scheme_name||''||EOL;
173: l_string := l_string || ''||EOL;
174:
175: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
176: l_string := null;
177: END IF;
178: END LOOP;
179: l_string := l_string || ''||EOL;

Line 181: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

177: END IF;
178: END LOOP;
179: l_string := l_string || ''||EOL;
180:
181: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
182: l_string := null;
183:
184:
185: elsif (p_template_name='PYGBPAEQE') then

Line 197: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

193: l_string := l_string || ''||0||''||EOL;
194: l_string := l_string || ''||l_payroll_name.payroll_name||''||EOL;
195: l_string := l_string || ''||l_period.period_name||''||EOL;
196:
197: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
198: l_string := null;
199:
200: OPEN cur_element_entry_assignment(l_period.end_date,p_payroll);
201:

Line 237: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

233: l_string := l_string || ''||l_input_id_value.qualifying_scheme_name||''||EOL;
234: --l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date))||''||EOL;
235: l_string := l_string || ''||EOL;
236:
237: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
238: l_string := null;
239: END IF;
240: END LOOP;
241: l_string := l_string || ''||EOL;

Line 243: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

239: END IF;
240: END LOOP;
241: l_string := l_string || ''||EOL;
242:
243: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
244: l_string := null;
245:
246:
247: elsif (p_template_name='PYGBPAENRE') then

Line 259: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

255: l_string := l_string || ''||0||''||EOL;
256: l_string := l_string || ''||l_payroll_name.payroll_name||''||EOL;
257: l_string := l_string || ''||l_period.period_name||''||EOL;
258:
259: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
260: l_string := null;
261:
262:
263: OPEN cur_element_entry_assignment(l_period.end_date,p_payroll);

Line 303: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

299: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.first_found_elig_date))||''||EOL;
300: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||EOL;
301: l_string := l_string || ''||EOL;
302:
303: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
304: l_string := null;
305: end if ;
306:
307: if (l_input_id_value.pension_classification IN ('NON ELIGIBLE JOB HOLDER','WORKER'))

Line 317: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

313: l_string := l_string || ''||NVL(l_input_id_value.total_earning_PRP,'N/A')||''||EOL;
314: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
315: l_string := l_string || ''||EOL;
316:
317: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
318: l_string := null;
319: end if;
320:
321: if (

Line 334: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

330: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||EOL;
331: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
332: l_string := l_string || ''||EOL;
333:
334: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
335: l_string := null;
336: end if;
337:
338: END LOOP;

Line 340: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

336: end if;
337:
338: END LOOP;
339: l_string := l_string || ''||EOL;
340: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
341: l_string := null;
342:
343:
344:

Line 357: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

353: l_string := l_string || ''||0||''||EOL;
354: l_string := l_string || ''||l_payroll_name.payroll_name||''||EOL;
355: l_string := l_string || ''||l_period.period_name||''||EOL;
356:
357: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
358: l_string := null;
359:
360: OPEN cur_element_entry_assignment(l_period.end_date,p_payroll);
361:

Line 396: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

392: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
393: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.opt_in_Date))||''||EOL;
394: l_string := l_string || ''||EOL;
395:
396: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
397: l_string := null;
398: END IF;
399: END LOOP;
400: l_string := l_string || ''||EOL;

Line 402: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

398: END IF;
399: END LOOP;
400: l_string := l_string || ''||EOL;
401:
402: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
403: l_string := null;
404: end if;
405:
406:

Line 407: -- dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);

403: l_string := null;
404: end if;
405:
406:
407: -- dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
408: -- dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
409: -- dbms_lob.writeAppend( l_xml, length(l_string), l_string);
410: p_xml := l_xml;
411: dbms_lob.freeTemporary(l_xml);

Line 408: -- dbms_lob.open(l_xml,dbms_lob.lob_readwrite);

404: end if;
405:
406:
407: -- dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
408: -- dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
409: -- dbms_lob.writeAppend( l_xml, length(l_string), l_string);
410: p_xml := l_xml;
411: dbms_lob.freeTemporary(l_xml);
412:

Line 409: -- dbms_lob.writeAppend( l_xml, length(l_string), l_string);

405:
406:
407: -- dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
408: -- dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
409: -- dbms_lob.writeAppend( l_xml, length(l_string), l_string);
410: p_xml := l_xml;
411: dbms_lob.freeTemporary(l_xml);
412:
413: end generate;

Line 411: dbms_lob.freeTemporary(l_xml);

407: -- dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
408: -- dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
409: -- dbms_lob.writeAppend( l_xml, length(l_string), l_string);
410: p_xml := l_xml;
411: dbms_lob.freeTemporary(l_xml);
412:
413: end generate;
414: END PAY_GB_ENROLL_PEN_REPORTING;