APPS.JAI_CMN_UTILS_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 104: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

100:
101: /* Bug 5243532. Added by Lakshmi Gopalsami.
102: Defined local variable for implementing caching logic.
103: */
104: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
105:
106: BEGIN
107: /* Bug 5243532. Added by Lakshmi Gopalsami
108: Removed the reference to cursor and implemented

Line 111: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

107: /* Bug 5243532. Added by Lakshmi Gopalsami
108: Removed the reference to cursor and implemented
109: caching logic.
110: */
111: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
112: (p_org_id => p_operating_unit_id );
113:
114: ln_set_of_books_id := l_func_curr_det.ledger_id;
115: lv_sob_currency_code := l_func_curr_det.currency_code;

Line 146: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

142:
143: /* Bug 5243235. Added by Lakshmi Gopalsami
144: Defined variable for implementing caching logic.
145: */
146: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
147:
148: BEGIN
149: /*
150: If the mandatory parameter p_calling_object is not passed, then returning false value so that no further processing needs

Line 179: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

175: Removed the existing code for deriving the SOB.
176: Implemented using caching logic.
177: */
178: IF p_org_id IS NOT NULL THEN
179: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
180: (p_org_id => p_org_id );
181:
182: ELSIF p_inventory_orgn_id IS NOT NULL THEN
183: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

Line 183: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

179: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
180: (p_org_id => p_org_id );
181:
182: ELSIF p_inventory_orgn_id IS NOT NULL THEN
183: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
184: (p_org_id => p_inventory_orgn_id );
185: END IF;
186: lv_sob_currency_code := l_func_curr_det.currency_code;
187: IF lv_sob_currency_code = 'INR' THEN

Line 719: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

715: and replaced with caching logic.
716: Defined variable for implementing caching logic.
717: */
718:
719: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
720:
721: BEGIN
722:
723: IF p_ledger_id IS NOT NULL AND p_bsv IS NOT NULL THEN

Line 762: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

758: cache logic.
759: */
760:
761: If nvl(ln_legal_entity_id,-1) = -1 THEN
762: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
763: (p_org_id => p_org_id);
764: ln_legal_entity_id := l_func_curr_det.legal_entity;
765:
766: END IF;