[Home] [Help]
385: /* Need to confirm these 2 Queries as these can be merged */
386:
387: /* Bug 5243532. Added by Lakshmi Gopalsami
388: * Removed cursor c_fetch_org_information and removed
389: * org_organization_definitions from the cursor c_period_name
390: * and passed set_of_books_id to the cursor. Also removed
391: * gl_sets_of_books and included gl_ledgers.
392: */
393:
425: r_trx c_trx%ROWTYPE;
426: r_base_trx c_base_trx%ROWTYPE;
427:
428: ln_acct_count number; --File.Sql.35 Cbabu := 0 ;
429: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
430: ln_precision number;
431: ln_entered_cr number;
432: ln_entered_dr number;
433: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
431: ln_entered_cr number;
432: ln_entered_dr number;
433: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
434:
435: lv_organization_code org_organization_definitions.organization_code%type;
436: lv_period_name gl_periods.period_name%type;
437: lv_debit_credit_flag varchar2(1);
438: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
439:
520: /* Fetch Period Information */
521:
522: /* Bug 5243532. Added by Lakshmi Gopalsami
523: * Passed set_of_books_id instead of r_trx.organization_id
524: * as org_organization_definitions has been removed
525: * from the cursor c_period_name,
526: */
527: /*Added by nprashar for FP bug # 9304844*/
528: open c_period_name(ln_set_of_books_id, lv_accounting_date); --Commented p_accounting_date added lv_accounting_date by nprashar;
1551: /* Bug 5243532. Added by Lakshmi Gopalsami
1552: * Defined variable for implementing caching logic.
1553: */
1554: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1555: lv_org_code org_organization_definitions.organization_code%TYPE;
1556: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;
1557: -- End for bug 5243532
1558:
1559: