628:
629: x_item_quantity NUMBER;
630: l_puom VARCHAR2(240);
631: x_Conv_quantity NUMBER;
632: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
633: l_inv_precision NUMBER := 40;
634:
635: BEGIN
636:
685:
686: x_item_quantity NUMBER;
687: l_puom VARCHAR2(240);
688: x_Conv_quantity NUMBER;
689: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
690: l_inv_precision NUMBER := 40;
691:
692: BEGIN
693:
739:
740: x_item_quantity NUMBER;
741: l_puom VARCHAR2(240);
742: x_Conv_quantity NUMBER;
743: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
744: l_inv_precision NUMBER := 40;
745:
746: BEGIN
747:
814: return 0;
815: end if;
816: END;
817:
818: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
819:
820: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency, l_err_buff);
821: -- Replaced with following select statement per bug 4537515 (sfiresto)
822: BEGIN
900: end if;
901:
902: END;
903:
904: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
905:
906: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
907: -- Replaced with following select statement per bug 4537515 (sfiresto)
908: BEGIN
984: return 0;
985: end if;
986: END;
987:
988: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
989:
990: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency, l_err_buff);
991: -- Replaced with following select statement per bug 4537515 (sfiresto)
992: BEGIN
1078: return 0;
1079: end if;
1080: END;
1081:
1082: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1083:
1084: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1085: -- Replaced with following select statement per bug 4537515 (sfiresto)
1086: BEGIN
1161: return 0;
1162: end if;
1163: END;
1164:
1165: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1166:
1167: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1168: -- Replaced with following select statement per bug 4537515 (sfiresto)
1169: BEGIN
1243: return 0;
1244: end if;
1245: END;
1246:
1247: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1248:
1249: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1250: -- Replaced with following select statement per bug 4537515 (sfiresto)
1251: BEGIN
1395: RETURN NULL;
1396: END IF;
1397:
1398: IF p_uom_class = 'Weight' THEN
1399: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1400: ELSE
1401: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1402: END IF;
1403:
1397:
1398: IF p_uom_class = 'Weight' THEN
1399: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1400: ELSE
1401: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1402: END IF;
1403:
1404: IF l_uom_code IS NULL THEN
1405: IF l_debug = FND_API.G_TRUE THEN
1456: RETURN NULL;
1457: END IF;
1458:
1459: IF p_uom_class = 'Weight' THEN
1460: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1461: ELSE
1462: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1463: END IF;
1464:
1458:
1459: IF p_uom_class = 'Weight' THEN
1460: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1461: ELSE
1462: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1463: END IF;
1464:
1465: IF l_uom_code IS NULL THEN
1466: IF l_debug = FND_API.G_TRUE THEN