eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_BOOK_CONTROLS

Line 68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;

64: RETCODE OUT NOCOPY VARCHAR2,
65: p_book VARCHAR2,
66: p_appraisal_id NUMBER) IS
67:
68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;

Line 69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;

65: p_book VARCHAR2,
66: p_appraisal_id NUMBER) IS
67:
68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;

Line 70: x_book_class fa_book_controls.book_class%TYPE;

66: p_appraisal_id NUMBER) IS
67:
68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047

Line 71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;

67:
68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;

Line 72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;

68: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;

Line 73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;

69: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;
77: x_je_category_name fa_book_controls.global_attribute13%TYPE;

Line 75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;

71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;
77: x_je_category_name fa_book_controls.global_attribute13%TYPE;
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_period_name fa_deprn_periods.period_name%TYPE;

Line 76: x_deprn_status fa_book_controls.deprn_status%TYPE;

72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;
77: x_je_category_name fa_book_controls.global_attribute13%TYPE;
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_period_name fa_deprn_periods.period_name%TYPE;
80: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;

Line 77: x_je_category_name fa_book_controls.global_attribute13%TYPE;

73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%TYPE;
74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;
77: x_je_category_name fa_book_controls.global_attribute13%TYPE;
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_period_name fa_deprn_periods.period_name%TYPE;
80: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;
81: x_period_counter fa_book_controls.last_period_counter%TYPE;

Line 81: x_period_counter fa_book_controls.last_period_counter%TYPE;

77: x_je_category_name fa_book_controls.global_attribute13%TYPE;
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_period_name fa_deprn_periods.period_name%TYPE;
80: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;
81: x_period_counter fa_book_controls.last_period_counter%TYPE;
82: x_count1 NUMBER;
83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;

Line 215: Though, gl_je_source value is available in fa_book_controls

211: /* Bug 5136047:
212: In R12 due to SLA uptake, core FA no longer allows "GL journal entry source"
213: to be entered using Book Controls window.
214: "GL journal entry source" is set at the application level in SLA.
215: Though, gl_je_source value is available in fa_book_controls
216: for books upgraded from R11i, the source of truth is always as follows.
217: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
218: XLA_SUBLEDGERS for application_id = 140.
219: Hence, there is no need to look at fa_book_controls for books upgraded

Line 219: Hence, there is no need to look at fa_book_controls for books upgraded

215: Though, gl_je_source value is available in fa_book_controls
216: for books upgraded from R11i, the source of truth is always as follows.
217: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
218: XLA_SUBLEDGERS for application_id = 140.
219: Hence, there is no need to look at fa_book_controls for books upgraded
220: from R1i.
221:
222: SELECT bc.set_of_books_id,
223: bc.deprn_calendar,

Line 252: FROM fa_book_controls bc,

248: x_currency_code,
249: x_user_je_source_name,
250: x_period_name,
251: x_end_date
252: FROM fa_book_controls bc,
253: gl_sets_of_books sb,
254: gl_je_sources js,
255: fa_deprn_periods dp,
256: fa_calendar_periods cp

Line 292: FROM fa_book_controls bc,

288: x_je_category_name,
289: x_currency_code,
290: x_period_name,
291: x_end_date
292: FROM fa_book_controls bc,
293: gl_sets_of_books sb,
294: fa_deprn_periods dp,
295: fa_calendar_periods cp
296: WHERE bc.book_type_code = p_book