APPS.JAI_CMN_UTILS_PKG dependencies on HR_OPERATING_UNITS

Line 117: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS

113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
116: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_CMN_UTILS_PKG.';
117: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS
118: /* Bug 5243532. Added by Lakshmi Gopalsami.
119: Removed the cursor c_set_of_books and c_sob_currency
120: and implemented using caching logic.
121: */

Line 147: p_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,

143: END get_currency_code;
144:
145: FUNCTION check_jai_exists(p_calling_object VARCHAR2 ,
146: p_inventory_orgn_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
147: p_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
148: p_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL ,
149: p_value_string VARCHAR2 DEFAULT NULL ,
150: p_format_string VARCHAR2 DEFAULT NULL
151: ) RETURN BOOLEAN

Line 155: which is referring to hr_operating_units

151: ) RETURN BOOLEAN
152: IS
153: /* Bug 5243532. Added by Lakshmi Gopalsami
154: Removed the cursor c_set_of_books and c_operating_unit
155: which is referring to hr_operating_units
156: and org_organization_definitions. Replaced the same with caching logic.
157: Replaced gl_sets_of_books with gl_ledgers
158: */
159: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS

Line 793: Get the value of legal entity from hr_operating_units

789: SELECT XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_org_id)
790: FROM dual;
791:
792: /* Bug 4906958. Added by Lakshmi Gopalsami
793: Get the value of legal entity from hr_operating_units
794: if the above cursor is returning null.
795: */
796: /* Bug 5243532. Added by Lakshmi Gopalsami
797: Removed the cursor c_get_default_LE_id which

Line 798: is referring to hr_operating_units

794: if the above cursor is returning null.
795: */
796: /* Bug 5243532. Added by Lakshmi Gopalsami
797: Removed the cursor c_get_default_LE_id which
798: is referring to hr_operating_units
799: and replaced with caching logic.
800: Defined variable for implementing caching logic.
801: */
802:

Line 837: from the default_legal_context_id from hr_operating_units

833: CLOSE c_get_le_info;
834:
835: /* Bug 4906958. Added by Lakshmi Gopalsami
836: If ln_legal_entity_id is null fetch the legal entity id
837: from the default_legal_context_id from hr_operating_units
838: */
839:
840: /* Bug 5243532. Added by Lakshmi Gopalsami
841: Removed the cursor c_get_default_LE_id and implemented using