DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_CURRENCY

Line 363: /(prl.unit_price*prd.req_line_quantity))), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

359: end if;
360:
361: select to_char(sum(decode(pcr1.action_type, 'CANCELLATION', 0, nvl(pcr1.new_price, prl.unit_price)*
362: nvl(pcr2.new_quantity,prd.req_line_quantity)*prd.nonrecoverable_tax
363: /(prl.unit_price*prd.req_line_quantity))), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
364: into l_new_tax_amount
365: from po_requisition_lines_all prl,
366: po_req_distributions_all prd,
367: po_change_requests pcr1,

Line 382: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

378: and NVL(prl.cancel_flag, 'N')='N';
379:
380: select to_char(sum(decode(pcr1.action_type, 'CANCELLATION', 0, nvl(pcr1.new_price, prl.unit_price)*
381: nvl(pcr2.new_quantity,prd.req_line_quantity))),
382: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
383: into l_new_req_amount
384: from po_requisition_lines_all prl,
385: po_req_distributions_all prd,
386: po_change_requests pcr1,

Line 527: SELECT to_char(nvl(sum(nonrecoverable_tax), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

523: aname => 'NOTE');
524:
525: end if;
526:
527: SELECT to_char(nvl(sum(nonrecoverable_tax), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
528: INTO l_new_tax_amount
529: FROM po_requisition_lines rl,
530: po_req_distributions rd
531: WHERE rl.requisition_header_id = l_document_id

Line 536: SELECT to_char(nvl(SUM(quantity * unit_price), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

532: AND rd.requisition_line_id = rl.requisition_line_id
533: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'
534: and NVL(rl.cancel_flag, 'N')='N';
535:
536: SELECT to_char(nvl(SUM(quantity * unit_price), 0), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
537: into l_new_req_amount
538: FROM po_requisition_lines
539: WHERE requisition_header_id = l_document_id
540: AND NVL(cancel_flag,'N') = 'N'

Line 1002: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||

998: l_currency_code <> l_line.txn_curr_code) then
999:
1000: if (l_is_price_changed = 'YES') then
1001: l_document := l_document || '' ||
1002: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||
1003: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1004: '' || NL;
1005: elsif(l_is_price_changed='DERIVED') then
1006: l_document := l_document || '' ||

Line 1003: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

999:
1000: if (l_is_price_changed = 'YES') then
1001: l_document := l_document || '' ||
1002: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||
1003: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1004: '' || NL;
1005: elsif(l_is_price_changed='DERIVED') then
1006: l_document := l_document || '' ||
1007: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

Line 1007: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

1003: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1004: '' || NL;
1005: elsif(l_is_price_changed='DERIVED') then
1006: l_document := l_document || '' ||
1007: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1008: '' || NL;
1009: else
1010: l_document := l_document || '' ||
1011: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

Line 1011: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

1007: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1008: '' || NL;
1009: else
1010: l_document := l_document || '' ||
1011: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1012: '' || NL;
1013:
1014: end if;
1015: else --display a blank cell

Line 1023: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||

1019: END IF;
1020:
1021: if (l_is_price_changed = 'YES') then
1022: l_document := l_document || '' ||
1023: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1024: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1025: '' || NL;
1026: elsif(l_is_price_changed='DERIVED') then
1027: l_document := l_document || '' ||

Line 1024: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1020:
1021: if (l_is_price_changed = 'YES') then
1022: l_document := l_document || '' ||
1023: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1024: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1025: '' || NL;
1026: elsif(l_is_price_changed='DERIVED') then
1027: l_document := l_document || '' ||
1028: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1028: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1024: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1025: '' || NL;
1026: elsif(l_is_price_changed='DERIVED') then
1027: l_document := l_document || '' ||
1028: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1029: '' || NL;
1030: else
1031: l_document := l_document || '' ||
1032: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1032: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1028: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1029: '' || NL;
1030: else
1031: l_document := l_document || '' ||
1032: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1033: '' || NL;
1034: end if;
1035:
1036: l_old_line_amount:=l_line.line_amount;

Line 1046: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||

1042: else
1043: l_new_line_amount:=l_line.unit_price*l_new_quantity;
1044: end if;
1045: l_document := l_document || '' ||
1046: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1047: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1048: '' || NL;
1049: else
1050: l_document := l_document || '' ||

Line 1047: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1043: l_new_line_amount:=l_line.unit_price*l_new_quantity;
1044: end if;
1045: l_document := l_document || '' ||
1046: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1047: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1048: '' || NL;
1049: else
1050: l_document := l_document || '' ||
1051: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1051: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1047: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1048: '' || NL;
1049: else
1050: l_document := l_document || '' ||
1051: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1052: '' || NL;
1053: end if;
1054:
1055: if(l_cancel=true) then

Line 1511: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||

1507: l_currency_code <> l_line.txn_curr_code) then
1508:
1509: if (l_is_price_changed = 'YES') then
1510: l_document := l_document || '' ||
1511: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||
1512: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1513: '' || NL;
1514: elsif(l_is_price_changed = 'DERIVED') then
1515: l_document := l_document || '' ||

Line 1512: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

1508:
1509: if (l_is_price_changed = 'YES') then
1510: l_document := l_document || '' ||
1511: to_char(l_old_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code || '
' ||
1512: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1513: '' || NL;
1514: elsif(l_is_price_changed = 'DERIVED') then
1515: l_document := l_document || '' ||
1516: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

Line 1516: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

1512: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1513: '' || NL;
1514: elsif(l_is_price_changed = 'DERIVED') then
1515: l_document := l_document || '' ||
1516: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1517: '' || NL;
1518: else
1519: l_document := l_document || '' ||
1520: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

Line 1520: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||

1516: to_char(l_new_currency_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1517: '' || NL;
1518: else
1519: l_document := l_document || '' ||
1520: to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30)) || ' ' || l_line.txn_curr_code ||
1521: '' || NL;
1522:
1523: end if;
1524: else --display a blank cell

Line 1532: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||

1528: END IF;
1529:
1530: if (l_is_price_changed = 'YES') then
1531: l_document := l_document || '' ||
1532: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1533: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1534: '' || NL;
1535: elsif(l_is_price_changed = 'DERIVED') then
1536: l_document := l_document || '' ||

Line 1533: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1529:
1530: if (l_is_price_changed = 'YES') then
1531: l_document := l_document || '' ||
1532: to_char(l_old_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1533: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1534: '' || NL;
1535: elsif(l_is_price_changed = 'DERIVED') then
1536: l_document := l_document || '' ||
1537: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1537: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1533: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1534: '' || NL;
1535: elsif(l_is_price_changed = 'DERIVED') then
1536: l_document := l_document || '' ||
1537: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1538: '' || NL;
1539: else
1540: l_document := l_document || '' ||
1541: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1541: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1537: to_char(l_new_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1538: '' || NL;
1539: else
1540: l_document := l_document || '' ||
1541: to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1542: '' || NL;
1543: end if;
1544:
1545: if(l_cancel=true) then

Line 1547: TO_CHAR(0, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1543: end if;
1544:
1545: if(l_cancel=true) then
1546: l_document := l_document || '' ||
1547: TO_CHAR(0, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1548: '' || NL;
1549: elsif (l_is_price_changed in('DERIVED', 'YES') or l_is_quantity_changed = true) then
1550: if(l_is_price_changed in('DERIVED', 'YES') and l_is_quantity_changed = true) then
1551: l_new_line_amount:=l_new_price*l_new_quantity;

Line 1561: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||

1557: l_new_line_amount:=l_line.unit_price*l_new_quantity;
1558: l_old_line_amount:=l_line.unit_price*l_old_quantity;
1559: end if;
1560: l_document := l_document || '' ||
1561: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1562: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1563: '' || NL;
1564: else
1565: l_document := l_document || '' ||

Line 1562: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1558: l_old_line_amount:=l_line.unit_price*l_old_quantity;
1559: end if;
1560: l_document := l_document || '' ||
1561: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '
' ||
1562: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1563: '' || NL;
1564: else
1565: l_document := l_document || '' ||
1566: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

Line 1566: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1562: TO_CHAR(l_new_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1563: '' || NL;
1564: else
1565: l_document := l_document || '' ||
1566: TO_CHAR(l_old_line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1567: '' || NL;
1568: end if;
1569:
1570: if(l_cancel=true) then

Line 1997: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

1993: nvl(pcr2.new_quantity, prl.quantity)*
1994: por_view_reqs_pkg.get_line_nonrec_tax_total(
1995: prl.requisition_line_id)/
1996: (prl.unit_price*prl.quantity))),0)),0),
1997: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
1998: ||' '|| l_currency_code,
1999: to_char(nvl(sum(decode(pcr3.action_type, 'CANCELLATION', 0,
2000: nvl(pcr1.new_price, prl.unit_price)*
2001: nvl(pcr2.new_quantity, prl.quantity))), 0),

Line 2002: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

1998: ||' '|| l_currency_code,
1999: to_char(nvl(sum(decode(pcr3.action_type, 'CANCELLATION', 0,
2000: nvl(pcr1.new_price, prl.unit_price)*
2001: nvl(pcr2.new_quantity, prl.quantity))), 0),
2002: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2003: ||' '|| l_currency_code
2004: into l_new_tax_amount, l_new_req_amount
2005: from po_requisition_lines_all prl,
2006: po_change_requests pcr1,

Line 2030: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

2026:
2027: end;
2028: else
2029: SELECT to_char(nvl(sum(nvl(nonrecoverable_tax, 0)), 0),
2030: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2031: ||' '|| l_currency_code
2032: INTO l_new_tax_amount
2033: FROM po_requisition_lines rl,
2034: po_req_distributions_all rd --

Line 2041: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))

2037: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'
2038: and NVL(rl.cancel_flag, 'N')='N';
2039:
2040: SELECT to_char(nvl(SUM(nvl(quantity * unit_price, 0)), 0),
2041: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2042: ||' '|| l_currency_code
2043: into l_new_req_amount
2044: FROM po_requisition_lines
2045: WHERE requisition_header_id = l_document_id

Line 2572: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;

2568:
2569: if(l_new_amount is null) then
2570: l_document := l_document || ' 2571: || ' headers="Amount_1">'
2572: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;
2573: else
2574: l_document := l_document || ' 2575: || ' headers="Amount_1">'
2576: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

Line 2576: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2572: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;
2573: else
2574: l_document := l_document || ' 2575: || ' headers="Amount_1">'
2576: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2577: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2578: || ''
2579: ||'' || NL;
2580: end if;

Line 2577: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2573: else
2574: l_document := l_document || ' 2575: || ' headers="Amount_1">'
2576: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2577: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2578: || ''
2579: ||'' || NL;
2580: end if;
2581:

Line 2598: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;

2594:
2595: if(l_new_amount is null) then
2596: l_document := l_document || ' 2597: || ' headers="Amount_1">'
2598: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;
2599: else
2600: l_document := l_document || ' 2601: || ' headers="Amount_1">'
2602: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

Line 2602: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2598: ||to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||'' || NL;
2599: else
2600: l_document := l_document || ' 2601: || ' headers="Amount_1">'
2602: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2603: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2604: || ''
2605: ||'' || NL;
2606: end if;

Line 2603: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2599: else
2600: l_document := l_document || ' 2601: || ' headers="Amount_1">'
2602: || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2603: || '
'|| to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2604: || ''
2605: ||'' || NL;
2606: end if;
2607:

Line 2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;
2677: end if;
2678:
2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;

Line 2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2678:
2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;
2685:
2686: else

Line 2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;
2685:
2686: else
2687: if(l_new_qty is null or l_new_qty=l_old_qty) then

Line 2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2693:
2694: end if;
2695:
2696: if(l_new_amount is null) then
2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

Line 2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2696: if(l_new_amount is null) then
2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2702: end if;
2703:
2704: if(l_new_need_by_date is null) then

Line 2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2702: end if;
2703:
2704: if(l_new_need_by_date is null) then
2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;

Line 3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3379: l_document := l_document || NL || ''|| NL || NL || '

';
3380:
3381: if(l_release_id is null) then
3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

Line 3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3458: else --text
3459:
3460: if(l_release_id is null) then
3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||