DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_EFILE_PKG dependencies on FF_FORMULAS_F

Line 7: c_header_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_HEADER_PAYMENT';

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';

Line 8: c_data_record_init constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_HEADER_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';

Line 9: c_data_record_detail constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_FOOTER_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: --

Line 10: c_data_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_LTX_BODY_PAYMENT';

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

Line 11: c_trailer_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_WITHHOLD_AGENT_FOOTER_PAYMENT';

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: --

Line 12: c_end_record_formatter constant ff_formulas_f.formula_name%type := 'LTX_EFILE_END_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: --
16: type t_parameter is record(

Line 188: ff_formulas_f f

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