227: (select * from table(cast(l_repair_line_ids as JTF_NUMBER_TABLE)))
228: and cr.customer_product_id = csi.instance_id(+);
229: end if;
230:
231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));
232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
228: and cr.customer_product_id = csi.instance_id(+);
229: end if;
230:
231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));
232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
229: end if;
230:
231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));
232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));
232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));
239:
232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));
239:
240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));
239:
240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
241:
234:
235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));
239:
240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
241:
242: for i in 1 ..l_repair_numbers.count
236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));
237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));
238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));
239:
240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
241:
242: for i in 1 ..l_repair_numbers.count
243: loop
244: fnd_file.put(fnd_file.output,rpad(l_incident_numbers(i),20,' '));
240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));
241:
242: for i in 1 ..l_repair_numbers.count
243: loop
244: fnd_file.put(fnd_file.output,rpad(l_incident_numbers(i),20,' '));
245: fnd_file.put(fnd_file.output,rpad(l_repair_numbers(i), 25,' '));
246: fnd_file.put(fnd_file.output,rpad(nvl(l_serial_numbers(i),' '), 25,' '));
247: fnd_file.put_line(fnd_file.output,rpad(nvl(l_instance_numbers(i),' '), 25,' '));
248: end loop;
241:
242: for i in 1 ..l_repair_numbers.count
243: loop
244: fnd_file.put(fnd_file.output,rpad(l_incident_numbers(i),20,' '));
245: fnd_file.put(fnd_file.output,rpad(l_repair_numbers(i), 25,' '));
246: fnd_file.put(fnd_file.output,rpad(nvl(l_serial_numbers(i),' '), 25,' '));
247: fnd_file.put_line(fnd_file.output,rpad(nvl(l_instance_numbers(i),' '), 25,' '));
248: end loop;
249:
242: for i in 1 ..l_repair_numbers.count
243: loop
244: fnd_file.put(fnd_file.output,rpad(l_incident_numbers(i),20,' '));
245: fnd_file.put(fnd_file.output,rpad(l_repair_numbers(i), 25,' '));
246: fnd_file.put(fnd_file.output,rpad(nvl(l_serial_numbers(i),' '), 25,' '));
247: fnd_file.put_line(fnd_file.output,rpad(nvl(l_instance_numbers(i),' '), 25,' '));
248: end loop;
249:
250: end write_cp_output;
243: loop
244: fnd_file.put(fnd_file.output,rpad(l_incident_numbers(i),20,' '));
245: fnd_file.put(fnd_file.output,rpad(l_repair_numbers(i), 25,' '));
246: fnd_file.put(fnd_file.output,rpad(nvl(l_serial_numbers(i),' '), 25,' '));
247: fnd_file.put_line(fnd_file.output,rpad(nvl(l_instance_numbers(i),' '), 25,' '));
248: end loop;
249:
250: end write_cp_output;
251: