413: WHERE crl.processing_group_id = p_group_id
414: AND crl.recall_id = crh.recall_id
415: AND rownum < 2;
416:
417: fnd_file.put_line(fnd_file.output,l_recall||' : '||l_recall_number);
418: fnd_file.put_line(fnd_file.output,' ');
419:
420: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
421: l_serial_label := fnd_message.get;
414: AND crl.recall_id = crh.recall_id
415: AND rownum < 2;
416:
417: fnd_file.put_line(fnd_file.output,l_recall||' : '||l_recall_number);
418: fnd_file.put_line(fnd_file.output,' ');
419:
420: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
421: l_serial_label := fnd_message.get;
422: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
430: fnd_message.set_name('GMO', 'GMO_INSTANCE_NUMBER_FIELD_NAME');
431: l_instance_label := fnd_message.get;
432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
431: l_instance_label := fnd_message.get;
432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.
443: FOR i IN recall_details
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.
443: FOR i IN recall_details
444: LOOP
441:
442: -- write the data.
443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
442: -- write the data.
443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:
453: END write_to_conc_out;
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:
453: END write_to_conc_out;
454: