APPS.POR_CHANGE_REQUEST_PKG dependencies on PO_HEADERS

Line 44: l_rate_type po_headers_all.rate_type%TYPE;

40: p_rate_date IN DATE) RETURN NUMBER
41: IS
42: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
43: l_rate NUMBER := 1;
44: l_rate_type po_headers_all.rate_type%TYPE;
45: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
46: l_display_rate NUMBER;
47: l_api_name VARCHAR2(30) := 'get_conversion_rate';
48: l_progress VARCHAR2(3) := '000';

Line 123: l_po_cur_code po_headers.currency_code%TYPE;

119: p_precision NUMBER ) RETURN NUMBER
120: IS
121: l_conversion_rate NUMBER := 1;
122: l_req_cur_code po_requisition_lines.currency_code%TYPE;
123: l_po_cur_code po_headers.currency_code%TYPE;
124: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
125: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
126: l_api_name VARCHAR2(30) := 'calculate_price_diff';
127: l_progress VARCHAR2(3) := '000';

Line 229: l_po_cur_code po_headers.currency_code%TYPE;

225: p_precision NUMBER ) RETURN NUMBER
226: IS
227: l_conversion_rate NUMBER := 1;
228: l_req_cur_code po_requisition_lines.currency_code%TYPE;
229: l_po_cur_code po_headers.currency_code%TYPE;
230: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
231: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
232: l_api_name VARCHAR2(30) := 'calculate_amount_diff';
233: l_progress VARCHAR2(3) := '000';

Line 348: po_cur_code po_headers.currency_code%TYPE;

344: po_ou NUMBER;
345: req_ou NUMBER;
346: req_cur_code po_requisition_lines.currency_code%TYPE;
347: req_price NUMBER;
348: po_cur_code po_headers.currency_code%TYPE;
349: po_rate NUMBER;
350: po_rate_type po_headers.rate_type%TYPE;
351: po_rate_date DATE;
352: line_location_price NUMBER;

Line 350: po_rate_type po_headers.rate_type%TYPE;

346: req_cur_code po_requisition_lines.currency_code%TYPE;
347: req_price NUMBER;
348: po_cur_code po_headers.currency_code%TYPE;
349: po_rate NUMBER;
350: po_rate_type po_headers.rate_type%TYPE;
351: po_rate_date DATE;
352: line_location_price NUMBER;
353: po_line_price NUMBER;
354: req_amount NUMBER;

Line 406: po_headers_all poh,

402: FROM
403: po_requisition_lines prl,
404: po_req_distributions prd,
405: po_line_locations_all pll,
406: po_headers_all poh,
407: po_lines_all pol,
408: po_distributions_all pod
409: WHERE
410: prl.requisition_line_id = reqlineid AND