APPS.JL_CO_FA_POST_PKG dependencies on FA_BOOK_CONTROLS

Line 49: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;

45: PROCEDURE post(ERRBUF OUT NOCOPY VARCHAR2,
46: RETCODE OUT NOCOPY VARCHAR2,
47: p_book VARCHAR2) IS
48:
49: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
50: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
51: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
52: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
53: x_period_counter VARCHAR2(150);

Line 50: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;

46: RETCODE OUT NOCOPY VARCHAR2,
47: p_book VARCHAR2) IS
48:
49: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
50: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
51: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
52: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
53: x_period_counter VARCHAR2(150);
54: x_period_closed VARCHAR2(150);

Line 52: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;

48:
49: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
50: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
51: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
52: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
53: x_period_counter VARCHAR2(150);
54: x_period_closed VARCHAR2(150);
55: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;
56: x_currency_code gl_sets_of_books.currency_code%TYPE;

Line 79: fa_book_controls b

75: CURSOR c_category IS
76: SELECT c.je_category_name,
77: c.user_je_category_name
78: FROM gl_je_categories c,
79: fa_book_controls b
80: WHERE b.book_type_code = p_book
81: AND c.je_category_name IN ( b.global_attribute6,
82: b.global_attribute7,
83: b.global_attribute8,

Line 148: Though, gl_je_source value is available in fa_book_controls

144: /* Bug 5136047:
145: In R12 due to SLA uptake, core FA no longer allows "GL journal entry source"
146: to be entered using Book Controls window.
147: "GL journal entry source" is set at the application level in SLA.
148: Though, gl_je_source value is available in fa_book_controls
149: for books upgraded from R11i, the source of truth is always as follows.
150: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
151: XLA_SUBLEDGERS for application_id = 140.
152: Hence, there is no need to look at fa_book_controls for books upgraded

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

148: Though, gl_je_source value is available in fa_book_controls
149: for books upgraded from R11i, the source of truth is always as follows.
150: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
151: XLA_SUBLEDGERS for application_id = 140.
152: Hence, there is no need to look at fa_book_controls for books upgraded
153: from R1i.
154:
155: SELECT bc.set_of_books_id,
156: bc.deprn_calendar,

Line 169: FROM fa_book_controls bc,

165: x_distribution_source_book,
166: x_period_counter,
167: x_period_closed,
168: x_user_je_source_name
169: FROM fa_book_controls bc,
170: gl_je_sources js
171: WHERE book_type_code = p_book
172: AND js.je_source_name = bc.gl_je_source;
173: */

Line 185: FROM fa_book_controls bc

181: x_deprn_calendar,
182: x_distribution_source_book,
183: x_period_counter,
184: x_period_closed
185: FROM fa_book_controls bc
186: WHERE book_type_code = p_book;
187:
188: SELECT xs.je_source_name,
189: js.user_je_source_name

Line 433: UPDATE fa_book_controls

429: END LOOP;
430:
431: END LOOP;
432:
433: UPDATE fa_book_controls
434: SET global_attribute19 = x_period_counter,
435: last_update_date = x_sysdate,
436: last_updated_by = x_last_updated_by
437: WHERE book_type_code = p_book;