50: g_step VARCHAR2(30);
51: g_user_je_category_name GL_INTERFACE.USER_JE_CATEGORY_NAME%TYPE;
52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;
53: g_calendar_type FA_CALENDAR_TYPES.CALENDAR_TYPE%TYPE;
54: g_je_retirement_category FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY%TYPE;
55: g_last_period_counter FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER%TYPE;
56: g_distribution_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
57: g_reserve_acct NUMBER(15);
58: g_ccid_deprn_exp_co VARCHAR2(150);
51: g_user_je_category_name GL_INTERFACE.USER_JE_CATEGORY_NAME%TYPE;
52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;
53: g_calendar_type FA_CALENDAR_TYPES.CALENDAR_TYPE%TYPE;
54: g_je_retirement_category FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY%TYPE;
55: g_last_period_counter FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER%TYPE;
56: g_distribution_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
57: g_reserve_acct NUMBER(15);
58: g_ccid_deprn_exp_co VARCHAR2(150);
59: g_ccid_deprn_mon_co VARCHAR2(150);
52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;
53: g_calendar_type FA_CALENDAR_TYPES.CALENDAR_TYPE%TYPE;
54: g_je_retirement_category FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY%TYPE;
55: g_last_period_counter FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER%TYPE;
56: g_distribution_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
57: g_reserve_acct NUMBER(15);
58: g_ccid_deprn_exp_co VARCHAR2(150);
59: g_ccid_deprn_mon_co VARCHAR2(150);
60: g_gl_je_source XLA_SUBLEDGERS.JE_SOURCE_NAME%TYPE; -- Bug 5136047
167: /* Bug 5136047:
168: In R12 due to SLA uptake, core FA no longer allows "GL journal entry source"
169: to be entered using Book Controls window.
170: "GL journal entry source" is set at the application level in SLA.
171: Though, gl_je_source value is available in fa_book_controls
172: for books upgraded from R11i, the source of truth is always as follows.
173: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
174: XLA_SUBLEDGERS for application_id = 140.
175: Hence, there is no need to look at fa_book_controls for books upgraded
171: Though, gl_je_source value is available in fa_book_controls
172: for books upgraded from R11i, the source of truth is always as follows.
173: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
174: XLA_SUBLEDGERS for application_id = 140.
175: Hence, there is no need to look at fa_book_controls for books upgraded
176: from R1i.
177:
178: SELECT a.set_of_books_id ,
179: a.global_attribute6,
190: g_chart_of_accounts_id,
191: g_calendar_type,
192: g_last_period_counter,
193: g_distribution_source_book
194: FROM fa_book_controls a,
195: gl_sets_of_books b
196: WHERE a.book_type_code = p_book_type_code
197: AND a.set_of_books_id = b.set_of_books_id;
198: */
210: g_chart_of_accounts_id,
211: g_calendar_type,
212: g_last_period_counter,
213: g_distribution_source_book
214: FROM fa_book_controls a,
215: gl_sets_of_books b
216: WHERE a.book_type_code = p_book_type_code
217: AND a.set_of_books_id = b.set_of_books_id;
218: