67: -----------------------------------------------------------------------------
68: -- Book and period parameters --
69: -----------------------------------------------------------------------------
70:
71: x_chart_of_accounts_id fa_book_controls.accounting_flex_structure%TYPE;
72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
68: -- Book and period parameters --
69: -----------------------------------------------------------------------------
70:
71: x_chart_of_accounts_id fa_book_controls.accounting_flex_structure%TYPE;
72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;
69: -----------------------------------------------------------------------------
70:
71: x_chart_of_accounts_id fa_book_controls.accounting_flex_structure%TYPE;
72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;
77:
70:
71: x_chart_of_accounts_id fa_book_controls.accounting_flex_structure%TYPE;
72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;
77:
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
846: x_je_cip_infln_adjustment,
847: x_period_name,
848: x_deprn_date,
849: x_currency_code
850: FROM fa_book_controls bc,
851: fa_deprn_periods dp,
852: gl_sets_of_books sb
853: WHERE bc.book_type_code = p_tax_book
854: AND dp.book_type_code = bc.book_type_code
4778: -----------------------------------------------------------------------------
4779: -- Update globalization close period counter --
4780: -----------------------------------------------------------------------------
4781:
4782: UPDATE fa_book_controls
4783: SET global_attribute5 = x_period_counter
4784: WHERE book_type_code = p_tax_book;
4785:
4786: COMMIT WORK;
4852: -- p_account_segment Natural account segment --
4853: ----------------------------------------------------------------------------
4854: -- LER, 18-Jun-99 Procedure is not more used in Release 11.5 --
4855: -- because natural account segment will be --
4856: -- directly stored in FA_BOOK_CONTROLS.GDF --
4857: ----------------------------------------------------------------------------
4858:
4859: PROCEDURE extract_account (p_chart_of_accounts_id IN NUMBER,
4860: p_apps_short_name IN VARCHAR2,