218:
219:
220: -- 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
221: l_shipped_lines := ' Quantites';
222: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
223: l_shipped_lines := l_shipped_lines|| 'Part Number Part Description Ship Date Shipped Waybill ';
224: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
225: l_shipped_lines := l_shipped_lines|| '------------------- --------------------------------- --------- ------------ ------------';
226:
220: -- 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
221: l_shipped_lines := ' Quantites';
222: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
223: l_shipped_lines := l_shipped_lines|| 'Part Number Part Description Ship Date Shipped Waybill ';
224: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
225: l_shipped_lines := l_shipped_lines|| '------------------- --------------------------------- --------- ------------ ------------';
226:
227: l_shipped := FALSE;
228: open c_shipped_lines(p_source_header_id, p_source_code, p_contact_type, p_contact_id, p_last_notif_date);
235: l_ship_qty;
236: exit when c_shipped_lines%NOTFOUND;
237: l_shipped := TRUE;
238:
239: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
240: l_shipped_lines := l_shipped_lines
241: || rpad(substr(l_part_number,1,19) ,19) ||' '
242: || rpad(substr(l_part_desc,1,33) ,33) ||' '
243: || lpad(substr(to_char(l_ship_qty),1,9),9) ||' '
314:
315: BEGIN
316: -- 12345678901234567890123456789012345678901234567890123456789012345678901234567890
317: l_backordered_lines := ' Quantity';
318: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
319: l_backordered_lines := l_backordered_lines|| 'Part Number Part Description Backordered';
320: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
321: l_backordered_lines := l_backordered_lines|| '------------------- --------------------------------- -----------';
322:
316: -- 12345678901234567890123456789012345678901234567890123456789012345678901234567890
317: l_backordered_lines := ' Quantity';
318: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
319: l_backordered_lines := l_backordered_lines|| 'Part Number Part Description Backordered';
320: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
321: l_backordered_lines := l_backordered_lines|| '------------------- --------------------------------- -----------';
322:
323: l_backordered := FALSE;
324: open c_backordered_lines(p_source_header_id, p_source_code, p_contact_type, p_contact_id, p_last_notif_date);
329: l_backorder_qty;
330: exit when c_backordered_lines%NOTFOUND;
331: l_backordered := TRUE;
332:
333: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
334: l_backordered_lines := l_backordered_lines
335: || rpad(substr(l_part_number,1,19) ,19) ||' '
336: || rpad(substr(l_part_desc,1,33) ,33) ||' '
337: || lpad(substr(to_char(l_backorder_qty),1,11),11);