eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_NL_WAGE_REPORT_PKG

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

420: l_legal_emplr_id NUMBER(15);
421: --
422: BEGIN
423: --
424: l_legal_emplr_id := pay_nl_wage_report_pkg.get_parameters(p_payroll_action_id, 'Legal_Employer');
425: --
426: OPEN csr_get_name(l_legal_emplr_id);
427: FETCH csr_get_name INTO l_name;
428: CLOSE csr_get_name;

Line 1414: --10100628 l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),-9999); --10100628

1410: FETCH csr_inc_exc INTO l_inc_exc;
1411: CLOSE csr_inc_exc;
1412: END IF;
1413: --
1414: --10100628 l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),-9999); --10100628
1415: l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),'N'); --10100628
1416: l_ER_ONLY := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'ER_ONLY'),'N');
1417:
1418: OPEN get_year(p_action_context_id);

Line 1415: l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),'N'); --10100628

1411: CLOSE csr_inc_exc;
1412: END IF;
1413: --
1414: --10100628 l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),-9999); --10100628
1415: l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),'N'); --10100628
1416: l_ER_ONLY := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'ER_ONLY'),'N');
1417:
1418: OPEN get_year(p_action_context_id);
1419: FETCH get_year INTO g_year;

Line 1416: l_ER_ONLY := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'ER_ONLY'),'N');

1412: END IF;
1413: --
1414: --10100628 l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),-9999); --10100628
1415: l_prev_corr_year := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'CORR_YR'),'N'); --10100628
1416: l_ER_ONLY := NVL(pay_nl_wage_report_pkg.get_parameters(p_action_context_id, 'ER_ONLY'),'N');
1417:
1418: OPEN get_year(p_action_context_id);
1419: FETCH get_year INTO g_year;
1420: CLOSE get_year;

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

1462: --g_xml_nwr (g_xml_nwr.count() + 1) := '';
1463: g_xml_nwr (g_xml_nwr.count() + 1) := '';
1464: -- START
1465: --# 0
1466: l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
1467: g_payroll_type := l_payroll_type; --8552196
1468: IF p_nwr_report_type = 'NLNWR_XML' THEN
1469: -- l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
1470: IF l_payroll_type = 'YEARLY' and g_year >= '2008' THEN -- Bug# 8459982

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

1465: --# 0
1466: l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
1467: g_payroll_type := l_payroll_type; --8552196
1468: IF p_nwr_report_type = 'NLNWR_XML' THEN
1469: -- l_payroll_type := TO_CHAR(pay_nl_wage_report_pkg.get_parameters(p_action_context_id,'Payroll_Type'));
1470: IF l_payroll_type = 'YEARLY' and g_year >= '2008' THEN -- Bug# 8459982
1471: g_xml_nwr (g_xml_nwr.count() + 1) := ''||EOL ;
1472: ELSIF l_payroll_type = 'YEARLY' and g_year = '2007' THEN -- Enh# 6968464
1473: g_xml_nwr (g_xml_nwr.count() + 1) := ''||EOL ;