[Home] [Help]
371: /* Need to confirm these 2 Queries as these can be merged */
372:
373: /* Bug 5243532. Added by Lakshmi Gopalsami
374: * Removed cursor c_fetch_org_information and removed
375: * org_organization_definitions from the cursor c_period_name
376: * and passed set_of_books_id to the cursor. Also removed
377: * gl_sets_of_books and included gl_ledgers.
378: */
379:
390: r_trx c_trx%ROWTYPE;
391: r_base_trx c_base_trx%ROWTYPE;
392:
393: ln_acct_count number; --File.Sql.35 Cbabu := 0 ;
394: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
395: ln_precision number;
396: ln_entered_cr number;
397: ln_entered_dr number;
398: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
396: ln_entered_cr number;
397: ln_entered_dr number;
398: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
399:
400: lv_organization_code org_organization_definitions.organization_code%type;
401: lv_period_name gl_periods.period_name%type;
402: lv_debit_credit_flag varchar2(1);
403: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
404:
465: /* Fetch Period Information */
466:
467: /* Bug 5243532. Added by Lakshmi Gopalsami
468: * Passed set_of_books_id instead of r_trx.organization_id
469: * as org_organization_definitions has been removed
470: * from the cursor c_period_name,
471: */
472: open c_period_name(ln_set_of_books_id,p_accounting_date);
473: fetch c_period_name into lv_period_name;
1491: /* Bug 5243532. Added by Lakshmi Gopalsami
1492: * Defined variable for implementing caching logic.
1493: */
1494: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1495: lv_org_code org_organization_definitions.organization_code%TYPE;
1496: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;
1497: -- End for bug 5243532
1498:
1499: