DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on FND_GLOBAL

Line 222: l_shipped_lines := l_shipped_lines|| fnd_global.newline;

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:

Line 224: l_shipped_lines := l_shipped_lines|| fnd_global.newline;

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

Line 239: l_shipped_lines := l_shipped_lines|| fnd_global.newline;

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

Line 318: l_backordered_lines := l_backordered_lines|| fnd_global.newline;

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:

Line 320: l_backordered_lines := l_backordered_lines|| fnd_global.newline;

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

Line 333: l_backordered_lines := l_backordered_lines|| fnd_global.newline;

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