[Home] [Help]
88: 11 18-MAY-2007 Bgowrava for Bug#6053352 , file version 120.8
89: Modified the date related codes to satisfy the GSCC compilance.
90:
91: *********************************************************************************************************/
92: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS
93: /* Bug 5243532. Added by Lakshmi Gopalsami.
94: Removed the cursor c_set_of_books and c_sob_currency
95: and implemented using caching logic.
96: */
118: END get_currency_code;
119:
120: FUNCTION check_jai_exists(p_calling_object VARCHAR2 ,
121: p_inventory_orgn_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
122: p_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE DEFAULT NULL ,
123: p_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL ,
124: p_value_string VARCHAR2 DEFAULT NULL ,
125: p_format_string VARCHAR2 DEFAULT NULL
126: ) RETURN BOOLEAN
126: ) RETURN BOOLEAN
127: IS
128: /* Bug 5243532. Added by Lakshmi Gopalsami
129: Removed the cursor c_set_of_books and c_operating_unit
130: which is referring to hr_operating_units
131: and org_organization_definitions. Replaced the same with caching logic.
132: Replaced gl_sets_of_books with gl_ledgers
133: */
134: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
705: SELECT XLE_UTILITIES_GRP.Get_DefaultLegalContext_OU(p_org_id)
706: FROM dual;
707:
708: /* Bug 4906958. Added by Lakshmi Gopalsami
709: Get the value of legal entity from hr_operating_units
710: if the above cursor is returning null.
711: */
712: /* Bug 5243532. Added by Lakshmi Gopalsami
713: Removed the cursor c_get_default_LE_id which
710: if the above cursor is returning null.
711: */
712: /* Bug 5243532. Added by Lakshmi Gopalsami
713: Removed the cursor c_get_default_LE_id which
714: is referring to hr_operating_units
715: and replaced with caching logic.
716: Defined variable for implementing caching logic.
717: */
718:
749: CLOSE c_get_le_info;
750:
751: /* Bug 4906958. Added by Lakshmi Gopalsami
752: If ln_legal_entity_id is null fetch the legal entity id
753: from the default_legal_context_id from hr_operating_units
754: */
755:
756: /* Bug 5243532. Added by Lakshmi Gopalsami
757: Removed the cursor c_get_default_LE_id and implemented using