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_JP_PAYSLIP_ARCHIVE dependencies on FND_NUMBER

Line 324: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_element_info_rec.element_type_id);

320: -- Stack information into global variable
321: --
322: l_act_info_rec.assignment_id := l_element_info_rec.assignment_id;
323: l_act_info_rec.action_info_category := c_action_information_category;
324: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_element_info_rec.element_type_id);
325: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_element_info_rec.input_value_id);
326: l_act_info_rec.act_info3 := l_element_info_rec.reporting_name;
327: l_act_info_rec.act_info4 := l_element_info_rec.payment_type;
328: l_act_info_rec.act_info5 := 'M';

Line 325: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_element_info_rec.input_value_id);

321: --
322: l_act_info_rec.assignment_id := l_element_info_rec.assignment_id;
323: l_act_info_rec.action_info_category := c_action_information_category;
324: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_element_info_rec.element_type_id);
325: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_element_info_rec.input_value_id);
326: l_act_info_rec.act_info3 := l_element_info_rec.reporting_name;
327: l_act_info_rec.act_info4 := l_element_info_rec.payment_type;
328: l_act_info_rec.act_info5 := 'M';
329: l_act_info_rec.act_info6 := l_element_info_rec.result_value;

Line 425: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_rec.org_payment_method_id);

421: -- Stack information into global variable
422: --
423: l_act_info_rec.assignment_id := l_assact_rec.prepay_assignment_id;
424: l_act_info_rec.action_info_category := c_action_information_category;
425: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_rec.org_payment_method_id);
426: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_rec.personal_payment_method_id);
427: -- l_act_info_rec.act_info4 := null;
428: l_act_info_rec.act_info5 := l_rec.bank_code;
429: l_act_info_rec.act_info6 := l_rec.bank_name;

Line 426: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_rec.personal_payment_method_id);

422: --
423: l_act_info_rec.assignment_id := l_assact_rec.prepay_assignment_id;
424: l_act_info_rec.action_info_category := c_action_information_category;
425: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_rec.org_payment_method_id);
426: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_rec.personal_payment_method_id);
427: -- l_act_info_rec.act_info4 := null;
428: l_act_info_rec.act_info5 := l_rec.bank_code;
429: l_act_info_rec.act_info6 := l_rec.bank_name;
430: l_act_info_rec.act_info7 := l_rec.branch_name;

Line 438: -- l_act_info_rec.act_info15 := fnd_number.number_to_canonical(l_rec.pre_payment_id);

434: l_act_info_rec.act_info11 := l_rec.account_type;
435: l_act_info_rec.act_info12 := l_rec.account_number;
436: l_act_info_rec.act_info13 := l_rec.account_name;
437: l_act_info_rec.act_info14 := l_rec.description1;
438: -- l_act_info_rec.act_info15 := fnd_number.number_to_canonical(l_rec.pre_payment_id);
439: l_act_info_rec.act_info16 := fnd_number.number_to_canonical(l_rec.value);
440: -- l_act_info_rec.act_info17 := fnd_number.number_to_canonical(l_assact_rec.prepay_assignment_action_id);
441: l_act_info_rec.act_info18 := l_rec.org_payment_method_name;
442: -- Note the index starts from "0".

Line 439: l_act_info_rec.act_info16 := fnd_number.number_to_canonical(l_rec.value);

435: l_act_info_rec.act_info12 := l_rec.account_number;
436: l_act_info_rec.act_info13 := l_rec.account_name;
437: l_act_info_rec.act_info14 := l_rec.description1;
438: -- l_act_info_rec.act_info15 := fnd_number.number_to_canonical(l_rec.pre_payment_id);
439: l_act_info_rec.act_info16 := fnd_number.number_to_canonical(l_rec.value);
440: -- l_act_info_rec.act_info17 := fnd_number.number_to_canonical(l_assact_rec.prepay_assignment_action_id);
441: l_act_info_rec.act_info18 := l_rec.org_payment_method_name;
442: -- Note the index starts from "0".
443: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

Line 440: -- l_act_info_rec.act_info17 := fnd_number.number_to_canonical(l_assact_rec.prepay_assignment_action_id);

436: l_act_info_rec.act_info13 := l_rec.account_name;
437: l_act_info_rec.act_info14 := l_rec.description1;
438: -- l_act_info_rec.act_info15 := fnd_number.number_to_canonical(l_rec.pre_payment_id);
439: l_act_info_rec.act_info16 := fnd_number.number_to_canonical(l_rec.value);
440: -- l_act_info_rec.act_info17 := fnd_number.number_to_canonical(l_assact_rec.prepay_assignment_action_id);
441: l_act_info_rec.act_info18 := l_rec.org_payment_method_name;
442: -- Note the index starts from "0".
443: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
444: end loop;

Line 491: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_allowance_ytd);

487: -- Stack information into global variable
488: --
489: l_act_info_rec.assignment_id := p_run_assignment_id;
490: l_act_info_rec.action_info_category := c_action_information_category;
491: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_allowance_ytd);
492: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_taxable_ytd);
493: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);
494: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);
495: l_act_info_rec.act_info5 := fnd_date.date_to_canonical(p_run_effective_date); -- Not used

Line 492: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_taxable_ytd);

488: --
489: l_act_info_rec.assignment_id := p_run_assignment_id;
490: l_act_info_rec.action_info_category := c_action_information_category;
491: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_allowance_ytd);
492: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_taxable_ytd);
493: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);
494: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);
495: l_act_info_rec.act_info5 := fnd_date.date_to_canonical(p_run_effective_date); -- Not used
496: -- Note the index starts from "0".

Line 493: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);

489: l_act_info_rec.assignment_id := p_run_assignment_id;
490: l_act_info_rec.action_info_category := c_action_information_category;
491: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_allowance_ytd);
492: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_taxable_ytd);
493: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);
494: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);
495: l_act_info_rec.act_info5 := fnd_date.date_to_canonical(p_run_effective_date); -- Not used
496: -- Note the index starts from "0".
497: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;

Line 494: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);

490: l_act_info_rec.action_info_category := c_action_information_category;
491: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_allowance_ytd);
492: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_taxable_ytd);
493: l_act_info_rec.act_info3 := fnd_number.number_to_canonical(l_si_prem_ytd);
494: l_act_info_rec.act_info4 := fnd_number.number_to_canonical(l_itax_ytd);
495: l_act_info_rec.act_info5 := fnd_date.date_to_canonical(p_run_effective_date); -- Not used
496: -- Note the index starts from "0".
497: pay_emp_action_arch.lrr_act_tab(pay_emp_action_arch.lrr_act_tab.count) := l_act_info_rec;
498: --

Line 566: AND fnd_number.canonical_to_number(hoi.org_information2) = prr.element_type_id

562: AND prr.status IN ('P', 'PA')
563: AND hoi.organization_id = cp_organization_id
564: AND hoi.org_information_context = cp_org_information_context
565: AND hoi.org_information1 = 'ELEMENT'
566: AND fnd_number.canonical_to_number(hoi.org_information2) = prr.element_type_id
567: and pet.element_type_id = prr.element_type_id
568: and rppa.effective_date
569: between pet.effective_start_date and pet.effective_end_date
570: AND pettl.element_type_id = pet.element_type_id

Line 572: AND piv.input_value_id = fnd_number.canonical_to_number(hoi.org_information3)

568: and rppa.effective_date
569: between pet.effective_start_date and pet.effective_end_date
570: AND pettl.element_type_id = pet.element_type_id
571: AND pettl.language = userenv('LANG')
572: AND piv.input_value_id = fnd_number.canonical_to_number(hoi.org_information3)
573: AND rppa.effective_date
574: between piv.effective_start_date and piv.effective_end_date
575: AND prrv.input_value_id = piv.input_value_id
576: AND prrv.run_result_id = prr.run_result_id;

Line 625: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_eit_element_rec.element_type_id);

621: -- Stack information into global variable
622: --
623: l_act_info_rec.assignment_id := l_eit_element_rec.assignment_id;
624: l_act_info_rec.action_info_category := c_action_information_category;
625: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_eit_element_rec.element_type_id);
626: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_eit_element_rec.input_value_id);
627: l_act_info_rec.act_info3 := l_eit_element_rec.reporting_name;
628: l_act_info_rec.act_info4 := c_payment_type;
629: l_act_info_rec.act_info5 := l_eit_element_rec.uom;

Line 626: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_eit_element_rec.input_value_id);

622: --
623: l_act_info_rec.assignment_id := l_eit_element_rec.assignment_id;
624: l_act_info_rec.action_info_category := c_action_information_category;
625: l_act_info_rec.act_info1 := fnd_number.number_to_canonical(l_eit_element_rec.element_type_id);
626: l_act_info_rec.act_info2 := fnd_number.number_to_canonical(l_eit_element_rec.input_value_id);
627: l_act_info_rec.act_info3 := l_eit_element_rec.reporting_name;
628: l_act_info_rec.act_info4 := c_payment_type;
629: l_act_info_rec.act_info5 := l_eit_element_rec.uom;
630: l_act_info_rec.act_info6 := l_eit_element_rec.result_value;