DBA Data[Home] [Help]

APPS.PAY_IE_WNU_EDI dependencies on PAY_IE_ARCHIVE_DETAIL_PKG

Line 241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));

237: hr_utility.set_location('Entering: '||l_proc,1);
238: --
239:
240: -- get parameter values from legislative parameters
241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
242: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
243: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
244: --Added for bug fix 3567562
245: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);

Line 242: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);

238: --
239:
240: -- get parameter values from legislative parameters
241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
242: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
243: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
244: --Added for bug fix 3567562
245: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
246:

Line 243: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;

239:
240: -- get parameter values from legislative parameters
241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
242: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
243: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
244: --Added for bug fix 3567562
245: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
246:
247:

Line 245: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);

241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
242: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
243: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
244: --Added for bug fix 3567562
245: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
246:
247:
248: --Bug 4369280
249: --commented the tax reference and the paye reference parameters as in the new legal employer

Line 253: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);

249: --commented the tax reference and the paye reference parameters as in the new legal employer
250: --classification they are not needed
251: --rather a new parameter is used for the legal employer reference .
252:
253: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);
254: --
255: BEGIN
256:
257: for asgrec in csr_state(l_payroll_id, l_emp_ref, l_assignment_set_id) loop

Line 405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));

401: --
402: hr_utility.set_location('Entering: '||l_proc,1);
403: --
404: -- get parameter values from legislative parameters
405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
408: --Added for Bug Fix 3567562
409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);

Line 406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);

402: hr_utility.set_location('Entering: '||l_proc,1);
403: --
404: -- get parameter values from legislative parameters
405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
408: --Added for Bug Fix 3567562
409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
410: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);

Line 407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;

403: --
404: -- get parameter values from legislative parameters
405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
408: --Added for Bug Fix 3567562
409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
410: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);
411: --

Line 409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);

405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
408: --Added for Bug Fix 3567562
409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
410: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);
411: --
412: --
413: BEGIN

Line 410: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);

406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);
407: l_assignment_set_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'ASSIGNMENT_SET_ID')) ;
408: --Added for Bug Fix 3567562
409: --l_paye_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYE_REF')),1,20);
410: l_emp_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'EMP_REF')),1,20);
411: --
412: --
413: BEGIN
414: for asgrec in csr_state(l_payroll_id, l_emp_ref,l_assignment_set_id) loop