DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_NL_WAGE_REPORT_PKG

Line 370: l_legal_emplr_id := pay_nl_wage_report_pkg.get_parameters(p_payroll_action_id, 'Legal_Employer');

366: l_legal_emplr_id NUMBER(15);
367: --
368: BEGIN
369: --
370: l_legal_emplr_id := pay_nl_wage_report_pkg.get_parameters(p_payroll_action_id, 'Legal_Employer');
371: --
372: OPEN csr_get_name(l_legal_emplr_id);
373: FETCH csr_get_name INTO l_name;
374: CLOSE csr_get_name;

Line 945: l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));

941: --g_xml_nwr (g_xml_nwr.count() + 1) := '';
942: g_xml_nwr (g_xml_nwr.count() + 1) := '';
943: -- START
944: --# 0
945: l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
946:
947: IF p_nwr_report_type = 'NLNWR_XML' THEN
948: -- l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
949:

Line 948: -- l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));

944: --# 0
945: l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
946:
947: IF p_nwr_report_type = 'NLNWR_XML' THEN
948: -- l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
949:
950: IF l_payroll_type = 'YEARLY' and g_year >= '2007' THEN -- Enh# 6968464
951: g_xml_nwr (g_xml_nwr.count() + 1) := ''||EOL ;
952: ELSIF l_payroll_type = 'YEARLY' THEN