DBA Data[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on FND_FILE

Line 231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));

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,' '));

Line 232: fnd_file.put_line(fnd_file.output,rpad('Group: '||p_group_id,30,' '));

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,' '));

Line 233: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));

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,' '));

Line 235: fnd_file.put(fnd_file.output,rpad('Service Request',20,' '));

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:

Line 236: fnd_file.put(fnd_file.output,rpad('Repair Number', 25,' '));

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,'-'));

Line 237: fnd_file.put(fnd_file.output,rpad('Serial Number', 25,' '));

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:

Line 238: fnd_file.put_line(fnd_file.output,rpad('Instance Number', 25,' '));

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

Line 240: fnd_file.put_line(fnd_file.output,rpad('-',150,'-'));

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,' '));

Line 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;

Line 245: fnd_file.put(fnd_file.output,rpad(l_repair_numbers(i), 25,' '));

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:

Line 246: fnd_file.put(fnd_file.output,rpad(nvl(l_serial_numbers(i),' '), 25,' '));

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;

Line 247: fnd_file.put_line(fnd_file.output,rpad(nvl(l_instance_numbers(i),' '), 25,' '));

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: