1: PACKAGE BODY PAY_NL_TAXOFFICE_FILE as
2: /* $Header: pynltosf.pkb 120.0.12000000.1 2007/01/17 23:04:56 appldev noship $ */
3: g_package varchar2(33) := ' PAY_NL_TAXOFFICE_FILE.';
4:
5:
1: PACKAGE BODY PAY_NL_TAXOFFICE_FILE as
2: /* $Header: pynltosf.pkb 120.0.12000000.1 2007/01/17 23:04:56 appldev noship $ */
3: g_package varchar2(33) := ' PAY_NL_TAXOFFICE_FILE.';
4:
5:
6: g_error_flag varchar2(30);
7: g_warning_flag varchar2(30);
74: ,p_employer OUT NOCOPY number
75: ,p_org_struct_id OUT NOCOPY number) IS
76: --
77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT fnd_date.canonical_to_date(pay_nl_taxoffice_file.get_parameter(legislative_parameters,'REPORT_YEAR'))
79: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'EMPLOYER_ID')
80: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'ORG_HIERARCHY')
81: ,effective_date
82: ,business_group_id
75: ,p_org_struct_id OUT NOCOPY number) IS
76: --
77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT fnd_date.canonical_to_date(pay_nl_taxoffice_file.get_parameter(legislative_parameters,'REPORT_YEAR'))
79: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'EMPLOYER_ID')
80: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'ORG_HIERARCHY')
81: ,effective_date
82: ,business_group_id
83: FROM pay_payroll_actions
76: --
77: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
78: SELECT fnd_date.canonical_to_date(pay_nl_taxoffice_file.get_parameter(legislative_parameters,'REPORT_YEAR'))
79: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'EMPLOYER_ID')
80: ,pay_nl_taxoffice_file.get_parameter(legislative_parameters,'ORG_HIERARCHY')
81: ,effective_date
82: ,business_group_id
83: FROM pay_payroll_actions
84: WHERE payroll_action_id = p_payroll_action_id;
533:
534: END Get_TOS_Sender_Details;
535:
536:
537: END PAY_NL_TAXOFFICE_FILE ;