APPS.JAI_CMN_UTILS_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 129: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

125:
126: /* Bug 5243532. Added by Lakshmi Gopalsami.
127: Defined local variable for implementing caching logic.
128: */
129: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
130:
131: BEGIN
132: /* Bug 5243532. Added by Lakshmi Gopalsami
133: Removed the reference to cursor and implemented

Line 136: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

132: /* Bug 5243532. Added by Lakshmi Gopalsami
133: Removed the reference to cursor and implemented
134: caching logic.
135: */
136: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
137: (p_org_id => p_operating_unit_id );
138:
139: ln_set_of_books_id := l_func_curr_det.ledger_id;
140: lv_sob_currency_code := l_func_curr_det.currency_code;

Line 171: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

167:
168: /* Bug 5243235. Added by Lakshmi Gopalsami
169: Defined variable for implementing caching logic.
170: */
171: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
172:
173: BEGIN
174: /*
175: If the mandatory parameter p_calling_object is not passed, then returning false value so that no further processing needs

Line 209: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

205: Removed the existing code for deriving the SOB.
206: Implemented using caching logic.
207: */
208: IF p_org_id IS NOT NULL THEN
209: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
210: (p_org_id => p_org_id );
211:
212: ELSIF p_inventory_orgn_id IS NOT NULL THEN
213: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

Line 213: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

209: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
210: (p_org_id => p_org_id );
211:
212: ELSIF p_inventory_orgn_id IS NOT NULL THEN
213: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
214: (p_org_id => p_inventory_orgn_id );
215: END IF;
216: lv_sob_currency_code := l_func_curr_det.currency_code;
217: IF lv_sob_currency_code = 'INR' THEN

Line 803: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

799: and replaced with caching logic.
800: Defined variable for implementing caching logic.
801: */
802:
803: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
804:
805: BEGIN
806:
807: IF p_ledger_id IS NOT NULL AND p_bsv IS NOT NULL THEN

Line 846: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

842: cache logic.
843: */
844:
845: If nvl(ln_legal_entity_id,-1) = -1 THEN
846: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
847: (p_org_id => p_org_id);
848: ln_legal_entity_id := l_func_curr_det.legal_entity;
849:
850: END IF;