APPS.JAI_PO_WF_UTIL_PUB dependencies on PO_HEADERS

Line 219: lv_currency_code PO_HEADERS_ALL.currency_code%TYPE;

215: ln_denominator_rate NUMBER;
216: ln_numerator_rate NUMBER;
217: ln_currency_rate NUMBER;
218:
219: lv_currency_code PO_HEADERS_ALL.currency_code%TYPE;
220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;
221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;
222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;
223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;

Line 220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;

216: ln_numerator_rate NUMBER;
217: ln_currency_rate NUMBER;
218:
219: lv_currency_code PO_HEADERS_ALL.currency_code%TYPE;
220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;
221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;
222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;
223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;

Line 221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;

217: ln_currency_rate NUMBER;
218:
219: lv_currency_code PO_HEADERS_ALL.currency_code%TYPE;
220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;
221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;
222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;
223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;
225:

Line 222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;

218:
219: lv_currency_code PO_HEADERS_ALL.currency_code%TYPE;
220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;
221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;
222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;
223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;
225:
226: lv_procedure_name VARCHAR2(40):='Get_Currency_Convertion_Rate';

Line 224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;

220: lv_po_currency_rate_type PO_HEADERS_ALL.rate_type%TYPE;
221: ld_po_currency_rate_date PO_HEADERS_ALL.rate_date%TYPE;
222: ln_po_currency_rate PO_HEADERS_ALL.rate%TYPE;
223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;
225:
226: lv_procedure_name VARCHAR2(40):='Get_Currency_Convertion_Rate';
227: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
228: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 1587: FROM po_headers poh

1583: , DECODE(nvl(pol.closed_code, 'OPEN')
1584: , 'OPEN'
1585: , NVL(poll.closed_code, 'OPEN')
1586: , pol.closed_code)
1587: FROM po_headers poh
1588: , po_lines pol
1589: , po_line_locations poll
1590: , po_distributions pod
1591: WHERE poh.po_header_id = p_document_id