3: --
4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_ltax_efile_pkg.';
7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_ltax_efile_pkg.';
7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_PAYMENT';
5: --
6: c_package constant varchar2(31) := 'pay_jp_ltax_efile_pkg.';
7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_PAYMENT';
13: --
6: c_package constant varchar2(31) := 'pay_jp_ltax_efile_pkg.';
7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_PAYMENT';
13: --
14: -- Global Variables
7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_PAYMENT';
13: --
14: -- Global Variables
15: --
8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_PAYMENT';
9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_PAYMENT';
10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';
11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';
12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_PAYMENT';
13: --
14: -- Global Variables
15: --
16: type t_parameter is record(
184: begin
185: select min(f.formula_id)
186: into l_formula_id
187: from ff_formula_types t,
188: ff_formulas_f f
189: where f.formula_name = p_formula_name
190: and f.legislation_code = 'JP'
191: and f.business_group_id is null
192: and t.formula_type_id = f.formula_type_id