DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_CURRENCIES

Line 275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;
275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
276: l_change_request_group_id number;
277:
278: l_old_req_amount VARCHAR2(30);
279: l_old_tax_amount VARCHAR2(30);

Line 453: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

449: l_org_id po_requisition_headers.org_id%TYPE;
450: l_document_subtype po_lookup_codes.displayed_field%TYPE;
451: l_document_type po_lookup_codes.displayed_field%TYPE;
452: l_document_number po_requisition_headers.segment1%TYPE;
453: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
454:
455: l_old_req_amount VARCHAR2(30);
456: l_old_tax_amount VARCHAR2(30);
457: l_new_req_amount VARCHAR2(30);

Line 623: l_currency_code fnd_currencies.currency_code%TYPE;

619: l_req_status po_requisition_headers.authorization_status%TYPE;
620:
621: l_req_line_msg VARCHAR2(2000) := '';
622:
623: l_currency_code fnd_currencies.currency_code%TYPE;
624:
625: NL VARCHAR2(1) := fnd_global.newline;
626:
627: i number := 0;

Line 1135: l_currency_code fnd_currencies.currency_code%TYPE;

1131: l_req_status po_requisition_headers.authorization_status%TYPE;
1132:
1133: l_req_line_msg VARCHAR2(2000) := '';
1134:
1135: l_currency_code fnd_currencies.currency_code%TYPE;
1136:
1137: NL VARCHAR2(1) := fnd_global.newline;
1138:
1139: i number := 0;

Line 1945: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

1941: l_old_req_amount VARCHAR2(40);
1942: l_old_tax_amount VARCHAR2(40);
1943: l_new_req_amount VARCHAR2(40);
1944: l_new_tax_amount VARCHAR2(40);
1945: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
1946:
1947: BEGIN
1948: begin
1949: l_currency_code := wf_engine.GetItemAttrText