DBA Data[Home] [Help]

APPS.GML_RCV_DB_COMMON dependencies on PO_GML_DB_COMMON

Line 203: --Cannot use po_gml_db_common,get_opm_uom_code because this procedure expects

199:
200: l_progress := '001';
201:
202: --Fetch UOM of RMA if not passed and get the corresponding OPM UOM Code.
203: --Cannot use po_gml_db_common,get_opm_uom_code because this procedure expects
204: --a 25 character unit of measure and OM does not have it.OM has the 4 character
205: --uom_code - so derive the corresponding opm uom code.
206: IF p_rma_lot_uom IS NULL THEN
207:

Line 216: l_rma_lot_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(l_rma_lot_uom);

212: From oe_order_lines_all
213: Where header_id = p_oe_header_id
214: And line_id = p_oe_line_id;
215: --Get corresponding OPM UOM.
216: l_rma_lot_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(l_rma_lot_uom);
217: */
218: BEGIN
219: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
220: 2, uom.unit_of_measure, 3, uom.unit_of_measure,

Line 242: --l_rma_lot_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_rma_lot_uom);

238:
239: ELSE
240: l_progress := '003';
241: --Get corresponding OPM UOM Code.
242: --l_rma_lot_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_rma_lot_uom);
243: BEGIN
244: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
245: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
246: 4, uom.unit_of_measure, uom.uom_code)

Line 294: l_trx_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_trx_uom);

290: END IF;
291:
292: --Get the Transaction (receipt) OPM UOM CODE.
293: BEGIN
294: l_trx_opm_uom := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_trx_uom);
295:
296: EXCEPTION
297: WHEN OTHERS THEN
298: FND_MSG_PUB.ADD;

Line 688: l_trx_opm_uom_code := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_trx_uom);

684: END IF;
685:
686: --Get the Trx OPM UOM CODE.
687: BEGIN
688: l_trx_opm_uom_code := PO_GML_DB_COMMON.GET_OPM_UOM_CODE(p_trx_uom);
689:
690: EXCEPTION
691: WHEN OTHERS THEN
692: FND_MSG_PUB.ADD;