DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on FND_CURRENCY

Line 951: TO_CHAR(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(

947: l_document := l_document || '' || nvl(to_char(l_line.quantity), ' ') || '' || NL;
948:
949: /*
950: l_document := l_document || '' ||
951: TO_CHAR(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(
952: l_currency_code, 30)) || '' || NL;
953: */
954: l_document := l_document || '' ||
955: TO_CHAR(l_line.unit_price) || '' || NL;

Line 960: l_document := l_document || '' || TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '' || NL;

956:
957:
958: l_document := l_document || '' || nvl(l_line.sugg_supplier, ' ') || '' || NL;
959:
960: l_document := l_document || '' || TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '' || NL;
961:
962: l_document := l_document || '' || NL;
963:
964: exit when i = 5;

Line 991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;

987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
994:
995: exit when i = 5;

Line 993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;

989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
994:
995: exit when i = 5;
996: end loop;
997:

Line 1211: TO_CHAR(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(

1207: l_document := l_document || '' || nvl(l_line.uom, ' ') || '' || NL;
1208: l_document := l_document || '' || nvl(to_char(l_line.quantity), ' ') || '' || NL;
1209: /*
1210: l_document := l_document || '' ||
1211: TO_CHAR(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(
1212: l_currency_code, 30)) || '' || NL;
1213: */
1214: l_document := l_document || '' || TO_CHAR(l_line.unit_price) || '' || NL;
1215:

Line 1219: l_document := l_document || '' || TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '' || NL;

1215:
1216: l_document := l_document || '' || nvl(l_line.sugg_supplier, ' ') || '' || NL;
1217:
1218:
1219: l_document := l_document || '' || TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || '' || NL;
1220:
1221:
1222: l_document := l_document || '' || NL;
1223:

Line 1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;

1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
1254:
1255: exit when i = 5;

Line 1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;

1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
1254:
1255: exit when i = 5;
1256: end loop;
1257: