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:
135: l_event_status varchar2(30);
136: l_valuation_method varchar2(30);
137: l_book_type_code varchar2(30);
138: l_revaluation_date date;
139: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
140: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
141: l_currency_code gl_sets_of_books.currency_code%TYPE;
142: l_precision fnd_currencies.precision%TYPE;
143: invalid_ledger exception;
136: l_valuation_method varchar2(30);
137: l_book_type_code varchar2(30);
138: l_revaluation_date date;
139: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
140: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
141: l_currency_code gl_sets_of_books.currency_code%TYPE;
142: l_precision fnd_currencies.precision%TYPE;
143: invalid_ledger exception;
144: l_event_id number;
137: l_book_type_code varchar2(30);
138: l_revaluation_date date;
139: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
140: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
141: l_currency_code gl_sets_of_books.currency_code%TYPE;
142: l_precision fnd_currencies.precision%TYPE;
143: invalid_ledger exception;
144: l_event_id number;
145: l_path_name varchar2(150) := g_path || 'update_revaluation_event';
207: l_event_status varchar2(30);
208: l_valuation_method varchar2(30);
209: l_book_type_code varchar2(30);
210: l_revaluation_date date;
211: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
212: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
213: l_currency_code gl_sets_of_books.currency_code%TYPE;
214: l_precision fnd_currencies.precision%TYPE;
215: invalid_ledger exception;
208: l_valuation_method varchar2(30);
209: l_book_type_code varchar2(30);
210: l_revaluation_date date;
211: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
212: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
213: l_currency_code gl_sets_of_books.currency_code%TYPE;
214: l_precision fnd_currencies.precision%TYPE;
215: invalid_ledger exception;
216: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
209: l_book_type_code varchar2(30);
210: l_revaluation_date date;
211: l_ledger_id gl_sets_of_books.set_of_books_id%TYPE;
212: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
213: l_currency_code gl_sets_of_books.currency_code%TYPE;
214: l_precision fnd_currencies.precision%TYPE;
215: invalid_ledger exception;
216: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
217: