APPS.JAI_PO_WF_UTIL_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 74: lv_req_conv_curr_rate_type po_requisition_lines_all.rate_type%TYPE;

70: ln_numerator_rate NUMBER;
71: ln_currency_rate NUMBER;
72:
73: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
74: lv_req_conv_curr_rate_type po_requisition_lines_all.rate_type%TYPE;
75: ld_req_conv_curr_rate_date po_requisition_lines_all.rate_date%TYPE;
76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;
77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:

Line 75: ld_req_conv_curr_rate_date po_requisition_lines_all.rate_date%TYPE;

71: ln_currency_rate NUMBER;
72:
73: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
74: lv_req_conv_curr_rate_type po_requisition_lines_all.rate_type%TYPE;
75: ld_req_conv_curr_rate_date po_requisition_lines_all.rate_date%TYPE;
76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;
77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:
79: lv_procedure_name VARCHAR2(40):='Get_Req_Curr_Conv_Rate';

Line 76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;

72:
73: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
74: lv_req_conv_curr_rate_type po_requisition_lines_all.rate_type%TYPE;
75: ld_req_conv_curr_rate_date po_requisition_lines_all.rate_date%TYPE;
76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;
77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:
79: lv_procedure_name VARCHAR2(40):='Get_Req_Curr_Conv_Rate';
80: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;

73: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
74: lv_req_conv_curr_rate_type po_requisition_lines_all.rate_type%TYPE;
75: ld_req_conv_curr_rate_date po_requisition_lines_all.rate_date%TYPE;
76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;
77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:
79: lv_procedure_name VARCHAR2(40):='Get_Req_Curr_Conv_Rate';
80: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
81: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 89: PO_REQUISITION_LINES_ALL

85: SELECT
86: currency_code
87: , rate
88: FROM
89: PO_REQUISITION_LINES_ALL
90: WHERE requisition_header_id = pn_req_header_id
91: AND requisition_line_id = pn_req_line_id ;
92:
93: BEGIN