APPS.ASO_UTILITY_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 5882: l_attribute_value APPS.HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

5878: -- Comments : The following functions are used for HR Extra Information Types
5879:
5880: FUNCTION GET_OU_ATTRIBUTE_VALUE(p_attribute IN VARCHAR2, p_organization_id IN NUMBER) RETURN VARCHAR2
5881: IS
5882: l_attribute_value APPS.HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
5883: BEGIN
5884: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5885: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
5886: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');

Line 5893: FROM hr_organization_information

5889: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN
5890: BEGIN
5891: SELECT ORG_INFORMATION1
5892: INTO l_attribute_value
5893: FROM hr_organization_information
5894: WHERE org_information_context = 'ASO_ORG_INFO'
5895: AND organization_id = p_organization_id ;
5896: EXCEPTION
5897: WHEN NO_DATA_FOUND THEN

Line 5904: FROM hr_organization_information

5900: ELSIF (p_attribute = G_DEFAULT_SALESREP) THEN
5901: BEGIN
5902: SELECT ORG_INFORMATION2
5903: INTO l_attribute_value
5904: FROM hr_organization_information
5905: WHERE org_information_context = 'ASO_ORG_INFO'
5906: AND organization_id = p_organization_id ;
5907: EXCEPTION
5908: WHEN NO_DATA_FOUND THEN

Line 5915: FROM hr_organization_information

5911: ELSIF (p_attribute = G_DEFAULT_SALES_GROUP) THEN
5912: BEGIN
5913: SELECT ORG_INFORMATION3
5914: INTO l_attribute_value
5915: FROM hr_organization_information
5916: WHERE org_information_context = 'ASO_ORG_INFO'
5917: AND organization_id = p_organization_id ;
5918: EXCEPTION
5919: WHEN NO_DATA_FOUND THEN

Line 5926: FROM hr_organization_information

5922: ELSIF (p_attribute = G_DEFAULT_SALES_ROLE) THEN
5923: BEGIN
5924: SELECT ORG_INFORMATION4
5925: INTO l_attribute_value
5926: FROM hr_organization_information
5927: WHERE org_information_context = 'ASO_ORG_INFO'
5928: AND organization_id = p_organization_id ;
5929: EXCEPTION
5930: WHEN NO_DATA_FOUND THEN

Line 5937: FROM hr_organization_information

5933: ELSIF (p_attribute = G_DEFAULT_CONTRACT_TEMPLATE) THEN
5934: BEGIN
5935: SELECT ORG_INFORMATION5
5936: INTO l_attribute_value
5937: FROM hr_organization_information
5938: WHERE org_information_context = 'ASO_ORG_INFO'
5939: AND organization_id = p_organization_id ;
5940: EXCEPTION
5941: WHEN NO_DATA_FOUND THEN

Line 5956: l_attribute_value APPS.HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

5952: END GET_OU_ATTRIBUTE_VALUE;
5953:
5954: FUNCTION GET_OU_ATTRIBUTE_VALUE(p_attribute IN VARCHAR2) RETURN VARCHAR2
5955: IS
5956: l_attribute_value APPS.HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
5957: l_organization_id NUMBER ;
5958: BEGIN
5959:
5960: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;