[Home] [Help]
401: and bc.book_type_code = cb.book_type_code;
402:
403: CURSOR c_mc_books (l_book_type_code varchar2) IS
404: select set_of_books_id
405: from fa_mc_book_controls
406: where book_type_code = l_book_type_code
407: and enabled_flag = 'Y';
408:
409: CURSOR c_mc_adj (l_book_type_code varchar2,
448: nvl(adj.je_line_num, 0),
449: adj.distribution_id
450: from fa_mc_adjustments adj,
451: gl_sets_of_books glsob,
452: fa_mc_book_controls bc,
453: fa_lookups_tl lk,
454: gl_je_headers gljh
455: where bc.book_type_code = l_book_type_code
456: and bc.set_of_books_id = l_set_of_books_id
509: nvl(dd.deprn_reserve_je_line_num, 0),
510: adj.distribution_id
511: from fa_mc_adjustments adj,
512: gl_sets_of_books glsob,
513: fa_mc_book_controls bc,
514: fa_lookups_tl lk,
515: gl_je_headers gljh,
516: fa_mc_deprn_detail dd,
517: gl_je_lines gljl,
588: nvl(dd.deprn_reserve_je_line_num, 0),
589: adj.distribution_id
590: from fa_mc_adjustments adj,
591: gl_sets_of_books glsob,
592: fa_mc_book_controls bc,
593: fa_lookups_tl lk,
594: gl_je_headers gljh,
595: fa_mc_deprn_detail dd,
596: gl_je_lines gljl,
2863: and bc.book_type_code = cb.book_type_code;
2864:
2865: CURSOR c_mc_books (l_book_type_code varchar2) IS
2866: select set_of_books_id
2867: from fa_mc_book_controls
2868: where book_type_code = l_book_type_code
2869: and enabled_flag = 'Y';
2870:
2871: CURSOR c_mc_adj (l_book_type_code varchar2,
2911: adj.distribution_id
2912: from fa_mc_adjustments adj,
2913: fa_lookups_tl lk,
2914: gl_je_headers gljh,
2915: fa_mc_book_controls bc,
2916: gl_sets_of_books glsob
2917: where bc.book_type_code = l_book_type_code
2918: and bc.set_of_books_id = l_set_of_books_id
2919: and bc.enabled_flag = 'Y'
2971: nvl(dd.deprn_reserve_je_line_num, 0),
2972: adj.distribution_id
2973: from fa_mc_adjustments adj,
2974: gl_sets_of_books glsob,
2975: fa_mc_book_controls bc,
2976: fa_lookups_tl lk,
2977: gl_je_headers gljh,
2978: fa_mc_deprn_detail dd,
2979: gl_je_lines gljl,
3050: nvl(dd.deprn_reserve_je_line_num, 0),
3051: adj.distribution_id
3052: from fa_mc_adjustments adj,
3053: gl_sets_of_books glsob,
3054: fa_mc_book_controls bc,
3055: fa_lookups_tl lk,
3056: gl_je_headers gljh,
3057: fa_mc_deprn_detail dd,
3058: gl_je_lines gljl,
5446: (source_type_code = 'DEPRECIATION')));
5447:
5448: select count(*)
5449: into l_mc_books
5450: from fa_mc_book_controls
5451: where enabled_flag = 'Y'
5452: and rownum = 1;
5453:
5454: if (l_mc_books > 0) then
5573: faev.period_name period_name,
5574: faev.je_category_name je_category_name,
5575: faev.description description
5576: from fa_xla_upg_events_gt faev,
5577: fa_mc_book_controls mc
5578: where mc.book_type_code = faev.book_type_code
5579: and mc.enabled_flag = 'Y';
5580:
5581: insert all
6301: fa_mc_deprn_detail dd,
6302: gl_je_headers gljh2,
6303: gl_je_lines gljl2,
6304: gl_je_lines gljl3,
6305: fa_mc_book_controls bc,
6306: gl_sets_of_books glsob,
6307: fa_distribution_accounts da,
6308: fa_asset_history ah,
6309: fa_category_books cb,
6485: and userenv('LANG') = lk_rr.language;
6486:
6487: select count(*)
6488: into l_mc_books
6489: from fa_mc_book_controls
6490: where enabled_flag = 'Y'
6491: and rownum = 1;
6492:
6493: if (p_mode = 'downtime') then
7715: faev.period_name period_name,
7716: faev.je_category_name je_category_name,
7717: faev.description description
7718: from fa_xla_upg_events_gt faev,
7719: fa_mc_book_controls mc
7720: where mc.book_type_code = faev.ds_book_type_code
7721: and mc.enabled_flag = 'Y';
7722:
7723: insert all
8072: gl_je_lines jl_br,
8073: gl_je_lines jl_ra,
8074: gl_je_lines jl_rr,
8075: gl_je_headers gljh,
8076: fa_mc_book_controls bc,
8077: gl_sets_of_books glsob,
8078: gl_row_multipliers mult
8079: where ev.event_id = he.event_id
8080: and bc.book_type_code = ev.ds_book_type_code
8288: and df.je_header_id = gljh.je_header_id (+);
8289:
8290: CURSOR c_mc_books (l_book_type_code varchar2) IS
8291: select set_of_books_id
8292: from fa_mc_book_controls
8293: where book_type_code = l_book_type_code
8294: and enabled_flag = 'Y';
8295:
8296: CURSOR c_mc_detail (l_corp_book_type_code varchar2,