DBA Data[Home] [Help]

APPS.BOM_RESOURCES_PKG dependencies on GL_SETS_OF_BOOKS

Line 878: FUNCTION Get_UOM_From_GL_Sets_Of_Books(X_Organization_Id NUMBER) RETURN VARCHAR2 IS

874: WHEN NO_DATA_FOUND THEN
875: X_unique_flag := 0;
876: END Check_Unique;
877:
878: FUNCTION Get_UOM_From_GL_Sets_Of_Books(X_Organization_Id NUMBER) RETURN VARCHAR2 IS
879: currency_code VARCHAR2(3);
880: book_id NUMBER;
881: BEGIN
882: SELECT SET_OF_BOOKS_ID INTO book_id FROM ORG_ORGANIZATION_DEFINITIONS

Line 884: SELECT SUBSTR(CURRENCY_CODE,1,3) INTO currency_code FROM GL_SETS_OF_BOOKS

880: book_id NUMBER;
881: BEGIN
882: SELECT SET_OF_BOOKS_ID INTO book_id FROM ORG_ORGANIZATION_DEFINITIONS
883: WHERE ORGANIZATION_ID = X_Organization_Id;
884: SELECT SUBSTR(CURRENCY_CODE,1,3) INTO currency_code FROM GL_SETS_OF_BOOKS
885: WHERE SET_OF_BOOKS_ID = book_id;
886: RETURN(currency_code);
887:
888: EXCEPTION

Line 893: END Get_UOM_From_GL_Sets_Of_Books;

889: WHEN NO_DATA_FOUND THEN
890: FND_MESSAGE.SET_NAME('BOM', 'MFG_NOT_FOUND');
891: FND_MESSAGE.SET_TOKEN('ENTITY', 'CURRENCY CODE-CAP', TRUE);
892: APP_EXCEPTION.RAISE_EXCEPTION;
893: END Get_UOM_From_GL_Sets_Of_Books;
894:
895: FUNCTION Check_Valid_UOM(X_Unit_Of_Measure VARCHAR2) RETURN NUMBER IS
896: uom_value NUMBER;
897: BEGIN