[Home] [Help]
207: g_org_id pn_leases.org_id%TYPE;
208: g_period_date pn_var_periods.start_date%TYPE;
209:
210: /* Uncomment for multi-org support */
211: /*l_gt pn_mo_cache_utils.GlobalsTable; */
212:
213:
214: -------------------------------------------------------------------------------
215: -- PROCEDURE : process_variable_rent
2268: -- 23-Jan-03 DThota o Removed comparison of pn_periods_all.end_date
2269: -- to p_period_date from the predicate of the
2270: -- cursor csr_get_per. Fix for bug # 2766223
2271: -- 14-JUL-05 Hrodda o Bug 4284035 - Replaced pn_leases with _ALL table.
2272: -- 23-NOV-05 pikhar o Passed org_id in pn_mo_cache_utils.get_profile_value
2273: -------------------------------------------------------------------------------
2274: PROCEDURE process_rent_batch (
2275: errbuf OUT NOCOPY VARCHAR2,
2276: retcode OUT NOCOPY VARCHAR2,
2369: CURSOR csr_currency_code(p_org_ID IN NUMBER) is
2370: SELECT currency_code,
2371: set_of_books_id
2372: FROM gl_sets_of_books
2373: WHERE set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',p_org_ID);
2374:
2375: ---- end ---
2376:
2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;
2384: l_min_acct_unit NUMBER;
2385:
2386: /* Uncomment for multi-org support */
2387:
2388: /* l_global_rec pn_mo_cache_utils.GlobalsRecord; */
2389:
2390:
2391: BEGIN
2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2422: /* Remove for multi-org support */
2423:
2424: ---- begin ----
2425:
2426: l_org_id := pn_mo_cache_utils.get_current_org_id;
2427:
2428: OPEN csr_currency_code(l_org_id);
2429: FETCH csr_currency_code into g_currency_code,g_set_of_books_id;
2430: CLOSE csr_currency_code;