APPS.PO_ADVANCED_PRICE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 420: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

416: l_progress VARCHAR2(3) := '000';
417: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
418: l_qp_license VARCHAR2(30) := NULL;
419: l_qp_license_product VARCHAR2(30) := NULL; /*Added for bug 8762015*/
420: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
421:
422: --Enhanced Pricing Start:
423: l_order_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
424: l_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 618: FROM mtl_units_of_measure mum

614: BEGIN
615: -- Make sure we pass uom_code instead of unit_of_measure.
616: SELECT mum.uom_code
617: INTO l_uom_code
618: FROM mtl_units_of_measure mum
619: WHERE mum.unit_of_measure = p_uom;
620: EXCEPTION
621: WHEN OTHERS THEN
622: l_uom_code := p_uom;

Line 1109: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

1105: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1106: d_pos NUMBER;
1107: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
1108: l_qp_license VARCHAR2(30) := NULL;
1109: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1110: l_return_status_text VARCHAR2(2000);
1111: l_control_rec QP_PREQ_GRP.control_record_type;
1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

Line 1398: FROM mtl_units_of_measure mum

1394: BEGIN
1395: -- Make sure we pass uom_code instead of unit_of_measure.
1396: SELECT mum.uom_code
1397: INTO l_uom_code
1398: FROM mtl_units_of_measure mum
1399: WHERE mum.unit_of_measure = p_line_rec_tbl(j).unit_of_measure;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: l_uom_code := p_line_rec_tbl(j).unit_of_measure;

Line 1838: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

1834: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1835: l_progress VARCHAR2(3) := '000';
1836: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
1837: l_qp_license VARCHAR2(30) := NULL;
1838: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1839:
1840:
1841: l_line_id NUMBER := nvl(p_order_line_id, 1);
1842: l_return_status_text VARCHAR2(2000);

Line 2011: FROM mtl_units_of_measure mum

2007: BEGIN
2008: -- Make sure we pass uom_code instead of unit_of_measure.
2009: SELECT mum.uom_code
2010: INTO l_uom_code
2011: FROM mtl_units_of_measure mum
2012: WHERE mum.unit_of_measure = p_uom;
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: l_uom_code := p_uom;