[Home] [Help]
2: /* $Header: iexvmtrb.pls 120.9.12010000.2 2008/08/05 07:04:51 snuthala ship $ */
3: PG_DEBUG NUMBER;
4: --BEGIN-FIX BUG#4375831-05/18/2005-JYPARK-fix error ORA-06521 because x_metric_value_tbl has charater value so convert to numeric value
5: TYPE curr_rec_type IS RECORD (
6: set_of_books_id ar_system_parameters.set_of_books_id%TYPE ,
7: base_currency gl_sets_of_books.currency_code%TYPE ,
8: base_precision fnd_currencies.precision%type ,
9: base_min_acc_unit fnd_currencies.minimum_accountable_unit%type ,
10: past_year_from DATE,
73: c.precision,
74: c.minimum_accountable_unit,
75: TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
76: TRUNC(sysdate) pastYearTo
77: FROM ar_system_parameters sp,
78: gl_ledgers_public_v gll,
79: fnd_currencies c
80: WHERE gll.ledger_id = sp.set_of_books_id
81: AND gll.currency_code = c.currency_code;
554: c.minimum_accountable_unit
555: INTO g_curr_rec.base_currency,
556: g_curr_rec.base_precision,
557: g_curr_rec.base_min_acc_unit
558: FROM ar_system_parameters sysp,
559: gl_ledgers_public_v gll,
560: fnd_currencies c
561: WHERE gll.ledger_id = sysp.set_of_books_id
562: AND gll.currency_code = c.currency_code;*/
566: c.minimum_accountable_unit
567: INTO g_curr_rec.base_currency,
568: g_curr_rec.base_precision,
569: g_curr_rec.base_min_acc_unit
570: FROM ar_system_parameters sysp,
571: gl_sets_of_books sob,
572: fnd_currencies c
573: WHERE sob.set_of_books_id = sysp.set_of_books_id
574: AND sob.currency_code = c.currency_code;*/