25: l_event_status varchar2(30);
26: l_valuation_method varchar2(30);
27: l_book_type_code varchar2(30);
28: l_revaluation_date date;
29: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
30: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
31: l_currency_code gl_sets_of_books.currency_code%TYPE;
32: l_precision fnd_currencies.precision%TYPE;
33: invalid_ledger exception;
26: l_valuation_method varchar2(30);
27: l_book_type_code varchar2(30);
28: l_revaluation_date date;
29: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
30: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
31: l_currency_code gl_sets_of_books.currency_code%TYPE;
32: l_precision fnd_currencies.precision%TYPE;
33: invalid_ledger exception;
34: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
27: l_book_type_code varchar2(30);
28: l_revaluation_date date;
29: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
30: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
31: l_currency_code gl_sets_of_books.currency_code%TYPE;
32: l_precision fnd_currencies.precision%TYPE;
33: invalid_ledger exception;
34: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
35:
129: l_event_status varchar2(30);
130: l_valuation_method varchar2(30);
131: l_book_type_code varchar2(30);
132: l_revaluation_date date;
133: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
134: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
135: l_currency_code gl_sets_of_books.currency_code%TYPE;
136: l_precision fnd_currencies.precision%TYPE;
137: invalid_ledger exception;
130: l_valuation_method varchar2(30);
131: l_book_type_code varchar2(30);
132: l_revaluation_date date;
133: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
134: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
135: l_currency_code gl_sets_of_books.currency_code%TYPE;
136: l_precision fnd_currencies.precision%TYPE;
137: invalid_ledger exception;
138: l_event_id number;
131: l_book_type_code varchar2(30);
132: l_revaluation_date date;
133: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
134: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
135: l_currency_code gl_sets_of_books.currency_code%TYPE;
136: l_precision fnd_currencies.precision%TYPE;
137: invalid_ledger exception;
138: l_event_id number;
139: l_path_name varchar2(150) := g_path || 'update_revaluation_event';
199: l_event_status varchar2(30);
200: l_valuation_method varchar2(30);
201: l_book_type_code varchar2(30);
202: l_revaluation_date date;
203: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
204: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
205: l_currency_code gl_sets_of_books.currency_code%TYPE;
206: l_precision fnd_currencies.precision%TYPE;
207: invalid_ledger exception;
200: l_valuation_method varchar2(30);
201: l_book_type_code varchar2(30);
202: l_revaluation_date date;
203: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
204: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
205: l_currency_code gl_sets_of_books.currency_code%TYPE;
206: l_precision fnd_currencies.precision%TYPE;
207: invalid_ledger exception;
208: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
201: l_book_type_code varchar2(30);
202: l_revaluation_date date;
203: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
204: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
205: l_currency_code gl_sets_of_books.currency_code%TYPE;
206: l_precision fnd_currencies.precision%TYPE;
207: invalid_ledger exception;
208: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
209: