APPS.PO_ADVANCED_PRICE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 411: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

407: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
408: l_progress VARCHAR2(3) := '000';
409: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
410: l_qp_license VARCHAR2(30) := NULL;
411: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
412:
413: l_line_id NUMBER := nvl(p_order_line_id, 1);
414: l_return_status_text VARCHAR2(2000);
415: l_control_rec QP_PREQ_GRP.control_record_type;

Line 588: FROM mtl_units_of_measure mum

584: BEGIN
585: -- Make sure we pass uom_code instead of unit_of_measure.
586: SELECT mum.uom_code
587: INTO l_uom_code
588: FROM mtl_units_of_measure mum
589: WHERE mum.unit_of_measure = p_uom;
590: EXCEPTION
591: WHEN OTHERS THEN
592: l_uom_code := p_uom;

Line 1024: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

1020: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
1021: d_pos NUMBER;
1022: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
1023: l_qp_license VARCHAR2(30) := NULL;
1024: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1025: l_return_status_text VARCHAR2(2000);
1026: l_control_rec QP_PREQ_GRP.control_record_type;
1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

Line 1311: FROM mtl_units_of_measure mum

1307: BEGIN
1308: -- Make sure we pass uom_code instead of unit_of_measure.
1309: SELECT mum.uom_code
1310: INTO l_uom_code
1311: FROM mtl_units_of_measure mum
1312: WHERE mum.unit_of_measure = p_line_rec_tbl(j).unit_of_measure;
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: l_uom_code := p_line_rec_tbl(j).unit_of_measure;