DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on FND_PROFILE

Line 624: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');

620:
621: x_item_quantity NUMBER;
622: l_puom VARCHAR2(240);
623: x_Conv_quantity NUMBER;
624: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
625: l_inv_precision NUMBER := 40;
626:
627: BEGIN
628:

Line 681: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');

677:
678: x_item_quantity NUMBER;
679: l_puom VARCHAR2(240);
680: x_Conv_quantity NUMBER;
681: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
682: l_inv_precision NUMBER := 40;
683:
684: BEGIN
685:

Line 735: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');

731:
732: x_item_quantity NUMBER;
733: l_puom VARCHAR2(240);
734: x_Conv_quantity NUMBER;
735: --l_inv_precision NUMBER := FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION');
736: l_inv_precision NUMBER := 40;
737:
738: BEGIN
739:

Line 810: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

806: return 0;
807: end if;
808: END;
809:
810: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
811:
812: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency, l_err_buff);
813: -- Replaced with following select statement per bug 4537515 (sfiresto)
814: BEGIN

Line 896: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

892: end if;
893:
894: END;
895:
896: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
897:
898: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
899: -- Replaced with following select statement per bug 4537515 (sfiresto)
900: BEGIN

Line 980: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

976: return 0;
977: end if;
978: END;
979:
980: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
981:
982: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency, l_err_buff);
983: -- Replaced with following select statement per bug 4537515 (sfiresto)
984: BEGIN

Line 1074: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

1070: return 0;
1071: end if;
1072: END;
1073:
1074: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1075:
1076: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1077: -- Replaced with following select statement per bug 4537515 (sfiresto)
1078: BEGIN

Line 1157: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

1153: return 0;
1154: end if;
1155: END;
1156:
1157: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1158:
1159: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1160: -- Replaced with following select statement per bug 4537515 (sfiresto)
1161: BEGIN

Line 1239: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');

1235: return 0;
1236: end if;
1237: END;
1238:
1239: l_sob_id := FND_PROFILE.Value('OE_SET_OF_BOOKS_ID');
1240:
1241: -- gl_info.gl_get_set_of_books_info(l_sob_id,l_coa_id,l_sob_name,l_sob_currency,l_err_buff);
1242: -- Replaced with following select statement per bug 4537515 (sfiresto)
1243: BEGIN

Line 1391: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');

1387: RETURN NULL;
1388: END IF;
1389:
1390: IF p_uom_class = 'Weight' THEN
1391: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1392: ELSE
1393: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1394: END IF;
1395:

Line 1393: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');

1389:
1390: IF p_uom_class = 'Weight' THEN
1391: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1392: ELSE
1393: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1394: END IF;
1395:
1396: IF l_uom_code IS NULL THEN
1397: IF l_debug = FND_API.G_TRUE THEN

Line 1452: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');

1448: RETURN NULL;
1449: END IF;
1450:
1451: IF p_uom_class = 'Weight' THEN
1452: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1453: ELSE
1454: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1455: END IF;
1456:

Line 1454: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');

1450:
1451: IF p_uom_class = 'Weight' THEN
1452: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
1453: ELSE
1454: l_uom_code := FND_PROFILE.VALUE('QP_LINE_VOLUME_UOM_CODE');
1455: END IF;
1456:
1457: IF l_uom_code IS NULL THEN
1458: IF l_debug = FND_API.G_TRUE THEN