DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on FND_GLOBAL

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

212:
213:
214: -- 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
215: l_shipped_lines := ' Quantites';
216: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
217: l_shipped_lines := l_shipped_lines|| 'Part Number Part Description Ship Date Shipped Waybill ';
218: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
219: l_shipped_lines := l_shipped_lines|| '------------------- --------------------------------- --------- ------------ ------------';
220:

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

214: -- 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
215: l_shipped_lines := ' Quantites';
216: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
217: l_shipped_lines := l_shipped_lines|| 'Part Number Part Description Ship Date Shipped Waybill ';
218: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
219: l_shipped_lines := l_shipped_lines|| '------------------- --------------------------------- --------- ------------ ------------';
220:
221: l_shipped := FALSE;
222: open c_shipped_lines(p_source_header_id, p_source_code, p_contact_type, p_contact_id, p_last_notif_date);

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

229: l_ship_qty;
230: exit when c_shipped_lines%NOTFOUND;
231: l_shipped := TRUE;
232:
233: l_shipped_lines := l_shipped_lines|| fnd_global.newline;
234: l_shipped_lines := l_shipped_lines
235: || rpad(substr(l_part_number,1,19) ,19) ||' '
236: || rpad(substr(l_part_desc,1,33) ,33) ||' '
237: || lpad(substr(to_char(l_ship_qty),1,9),9) ||' '

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

308:
309: BEGIN
310: -- 12345678901234567890123456789012345678901234567890123456789012345678901234567890
311: l_backordered_lines := ' Quantity';
312: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
313: l_backordered_lines := l_backordered_lines|| 'Part Number Part Description Backordered';
314: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
315: l_backordered_lines := l_backordered_lines|| '------------------- --------------------------------- -----------';
316:

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

310: -- 12345678901234567890123456789012345678901234567890123456789012345678901234567890
311: l_backordered_lines := ' Quantity';
312: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
313: l_backordered_lines := l_backordered_lines|| 'Part Number Part Description Backordered';
314: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
315: l_backordered_lines := l_backordered_lines|| '------------------- --------------------------------- -----------';
316:
317: l_backordered := FALSE;
318: open c_backordered_lines(p_source_header_id, p_source_code, p_contact_type, p_contact_id, p_last_notif_date);

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

323: l_backorder_qty;
324: exit when c_backordered_lines%NOTFOUND;
325: l_backordered := TRUE;
326:
327: l_backordered_lines := l_backordered_lines|| fnd_global.newline;
328: l_backordered_lines := l_backordered_lines
329: || rpad(substr(l_part_number,1,19) ,19) ||' '
330: || rpad(substr(l_part_desc,1,33) ,33) ||' '
331: || lpad(substr(to_char(l_backorder_qty),1,11),11);