8924: --avsingh: Bug 5710213: end
8925: FROM okc_k_lines_tl a,
8926: okc_k_lines_b b,
8927: okl_k_lines c,
8928: fnd_languages d
8929: --avsingh: Bug 5710213: start
8930: , okc_line_styles_b lsb
8931: --avsingh: Bug 5710213: end
8932: WHERE a.id = b.id
8942:
8943:
8944: CURSOR c6 IS
8945: SELECT language_code
8946: FROM fnd_languages
8947: WHERE installed_flag IN ('B', 'I');
8948:
8949: CURSOR c7(p_id NUMBER) IS
8950: SELECT DISTINCT a.name
17933:
17934:
17935: CURSOR c_base_language IS
17936: SELECT language_code
17937: FROM fnd_languages
17938: WHERE installed_flag = 'B';
17939:
17940: CURSOR c_languages IS
17941: SELECT language_code
17938: WHERE installed_flag = 'B';
17939:
17940: CURSOR c_languages IS
17941: SELECT language_code
17942: FROM fnd_languages
17943: WHERE installed_flag IN ('B','I');
17944:
17945: -- Bug# 5591618
17946: /*
17961: /*
17962: --CURSOR c_try_id IS
17963: --SELECT a.id
17964: --FROM okl_trx_types_tl a,
17965: --fnd_languages b
17966: --WHERE a.name = 'Internal Asset Creation'
17967: --AND a.LANGUAGE = b.language_code
17968: --AND b.installed_flag = 'B';
17969: */
18021: TYPE l_book_class_type IS TABLE OF fa_book_controls.book_class%TYPE INDEX BY BINARY_INTEGER;
18022: TYPE l_id_type IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
18023: TYPE l_cle_id_type IS TABLE OF okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
18024:
18025: TYPE l_lang_tab_type IS TABLE OF fnd_languages.language_code%TYPE INDEX BY BINARY_INTEGER;
18026:
18027: l_ID1_tab l_ID1_type;
18028: l_ID2_tab l_ID2_type;
18029: l_NAME_local_tab l_NAME_type;
18124: l_tl2language_tab l_tllanguage_type;
18125:
18126: l_txl_assets_tl_counter4 NUMBER := 1;
18127: l_lang_tab l_lang_tab_type;
18128: l_base_language fnd_languages.language_code%TYPE;
18129:
18130: l_orig_cost NUMBER;
18131: l_depreciable_cost NUMBER;
18132: l_deprn_rate fa_books.adjusted_rate%TYPE;