DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_CURRENCIES

Line 209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);
213: l_tax_amount VARCHAR2(30);

Line 454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);
458: l_tax_amount VARCHAR2(30);

Line 724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);
728: l_tax_amount VARCHAR2(30);

Line 949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);
953: l_tax_amount VARCHAR2(30);

Line 1178: l_currency_code fnd_currencies.currency_code%TYPE;

1174: l_line line_record;
1175:
1176: l_document VARCHAR2(32000) := '';
1177:
1178: l_currency_code fnd_currencies.currency_code%TYPE;
1179:
1180: NL VARCHAR2(1) := fnd_global.newline;
1181:
1182: i number := 0;

Line 1423: l_currency_code fnd_currencies.currency_code%TYPE;

1419: l_document_pre_lmt VARCHAR2(4000) := '';
1420: l_document_post_lmt VARCHAR2(4000) := '';
1421: l_document_Summary VARCHAR2(32000) := '';
1422:
1423: l_currency_code fnd_currencies.currency_code%TYPE;
1424:
1425: NL VARCHAR2(1) := fnd_global.newline;
1426:
1427: i number := 0;