DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on FND_CURRENCY

Line 1874: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

1870: '
1871: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
1872: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
1873: l_po_currency||') '||
1874: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
1875: ||')


';
1876: else
1877: l_document := l_base_url_tag||
1878: '

Line 1882: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

1878: '
1879: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
1880: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
1881: l_po_currency||') '||
1882: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
1883: ||')


';
1884: end if;
1885:
1886: l_document := l_document||'

Line 2706: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2702: '
2703: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
2704: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
2705: l_po_currency||') '||
2706: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2707: ||')


';
2708: else
2709: l_document :=l_base_url_tag||
2710: '

Line 2714: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

2710: '
2711: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
2712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
2713: l_po_currency||') '||
2714: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2715: ||')


';
2716: end if;
2717:
2718: l_document := l_document||'

Line 3635: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

3631: '
3632: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3633: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3634: l_po_currency||') '||
3635: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
3636: ||')


'; */
3637: /*
3638: if(l_acc_req_flag <> 'Y') then
3639: l_document := l_document ||

Line 3650: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30))

3646: '
3647: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3648: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3649: l_rel_currency||') '||
3650: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30))
3651: ||')


'; */
3652: /*
3653: if(l_acc_req_flag <> 'Y') then
3654: l_document := l_document ||

Line 4548: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))

4544: l_document :=l_base_url_tag|| '
4545: '||l_doc_hdr_info||' '||
4546: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
4547: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'||
4548: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
4549: ||')


';
4550:
4551: else
4552: if(l_type_lookup_code = 'BLANKET') then

Line 4562: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30))

4558: '||l_doc_hdr_info||
4559: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
4560: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
4561: l_rel_currency||')'||
4562: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30))
4563: ||')


';
4564:
4565: end if;
4566: l_progress := '004';

Line 5100: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

5096: --fnd_message.set_token('PO_NUMBER', l_po_num);
5097: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message
5098: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' ||
5099: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' '
5100: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
5101: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG');
5102: ELSE
5103: IF(l_type_lookup_code = 'BLANKET') THEN
5104: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total

Line 5107: ||' '||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))

5103: IF(l_type_lookup_code = 'BLANKET') THEN
5104: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total
5105: ELSE
5106: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')
5107: ||' '||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))
5108: || ' ' || l_currency_code || ') ';
5109: END IF;
5110: END IF;
5111:

Line 5150: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG');

5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num);
5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num);
5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved
5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'('
5150: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG');
5151: ELSE
5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'('
5153: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')';
5154: END IF;

Line 5153: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')';

5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'('
5150: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG');
5151: ELSE
5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'('
5153: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')';
5154: END IF;
5155:
5156: END IF;
5157: