eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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