APPS.ASO_UTILITY_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106

6329: -- Comments : The following functions are used for HR Extra Information Types
6330:
6331: FUNCTION GET_OU_ATTRIBUTE_VALUE(p_attribute IN VARCHAR2, p_organization_id IN NUMBER) RETURN VARCHAR2
6332: IS
6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');

Line 6344: FROM hr_organization_information

6340: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN
6341: BEGIN
6342: SELECT ORG_INFORMATION1
6343: INTO l_attribute_value
6344: FROM hr_organization_information
6345: WHERE org_information_context = 'ASO_ORG_INFO'
6346: AND organization_id = p_organization_id ;
6347: EXCEPTION
6348: WHEN NO_DATA_FOUND THEN

Line 6355: FROM hr_organization_information

6351: ELSIF (p_attribute = G_DEFAULT_SALESREP) THEN
6352: BEGIN
6353: SELECT ORG_INFORMATION2
6354: INTO l_attribute_value
6355: FROM hr_organization_information
6356: WHERE org_information_context = 'ASO_ORG_INFO'
6357: AND organization_id = p_organization_id ;
6358: EXCEPTION
6359: WHEN NO_DATA_FOUND THEN

Line 6366: FROM hr_organization_information

6362: ELSIF (p_attribute = G_DEFAULT_SALES_GROUP) THEN
6363: BEGIN
6364: SELECT ORG_INFORMATION3
6365: INTO l_attribute_value
6366: FROM hr_organization_information
6367: WHERE org_information_context = 'ASO_ORG_INFO'
6368: AND organization_id = p_organization_id ;
6369: EXCEPTION
6370: WHEN NO_DATA_FOUND THEN

Line 6377: FROM hr_organization_information

6373: ELSIF (p_attribute = G_DEFAULT_SALES_ROLE) THEN
6374: BEGIN
6375: SELECT ORG_INFORMATION4
6376: INTO l_attribute_value
6377: FROM hr_organization_information
6378: WHERE org_information_context = 'ASO_ORG_INFO'
6379: AND organization_id = p_organization_id ;
6380: EXCEPTION
6381: WHEN NO_DATA_FOUND THEN

Line 6388: FROM hr_organization_information

6384: ELSIF (p_attribute = G_DEFAULT_CONTRACT_TEMPLATE) THEN
6385: BEGIN
6386: SELECT ORG_INFORMATION5
6387: INTO l_attribute_value
6388: FROM hr_organization_information
6389: WHERE org_information_context = 'ASO_ORG_INFO'
6390: AND organization_id = p_organization_id ;
6391: EXCEPTION
6392: WHEN NO_DATA_FOUND THEN

Line 6407: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106

6403: END GET_OU_ATTRIBUTE_VALUE;
6404:
6405: FUNCTION GET_OU_ATTRIBUTE_VALUE(p_attribute IN VARCHAR2) RETURN VARCHAR2
6406: IS
6407: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6408: l_organization_id NUMBER ;
6409: BEGIN
6410:
6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;