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

Line 172: where pai.action_information1 = fnd_number.number_to_canonical(p_employer_id)

168:
169: cursor csr_get_max_sequence IS
170: select max(pai.action_information4)
171: from pay_action_information pai
172: where pai.action_information1 = fnd_number.number_to_canonical(p_employer_id)
173: and pai.action_information2 = fnd_number.number_to_canonical(p_si_provider_id)
174: and to_char(pai.effective_date,'YYYY') = to_char(p_reporting_date,'YYYY');
175:
176: l_max_sequence varchar2(30);

Line 173: and pai.action_information2 = fnd_number.number_to_canonical(p_si_provider_id)

169: cursor csr_get_max_sequence IS
170: select max(pai.action_information4)
171: from pay_action_information pai
172: where pai.action_information1 = fnd_number.number_to_canonical(p_employer_id)
173: and pai.action_information2 = fnd_number.number_to_canonical(p_si_provider_id)
174: and to_char(pai.effective_date,'YYYY') = to_char(p_reporting_date,'YYYY');
175:
176: l_max_sequence varchar2(30);
177: l_sequence number;

Line 183: l_sequence := fnd_number.canonical_to_number(l_max_Sequence);

179: -- hr_utility.set_location('Entering Get_er_Sequence',600);
180: open csr_get_max_sequence;
181: fetch csr_get_max_sequence into l_max_Sequence;
182: close csr_get_max_Sequence;
183: l_sequence := fnd_number.canonical_to_number(l_max_Sequence);
184: p_sequence := nvl(to_number(l_sequence),0) + 1;
185: -- hr_utility.set_location('Exiting Get_er_Sequence',600);
186: return 1;
187: END Get_er_sequence;

Line 585: p_dev_work_hours := fnd_number.canonical_to_number(l_temp_dev_work_hrs);

581: FETCH csr_get_dev_work_hrs into l_temp_dev_work_hrs,l_days;
582: CLOSE csr_get_dev_work_hrs;
583:
584: If l_temp_dev_work_hrs is not null then
585: p_dev_work_hours := fnd_number.canonical_to_number(l_temp_dev_work_hrs);
586: else
587: p_dev_work_hours :=0;
588: End if;
589: -- hr_utility.set_location('Leaving Get_dev_work_hours ',425);

Line 709: l_weekly_working_hours := fnd_number.canonical_to_number(l_outputs(1).value);

705: p_formula_name => g_working_hours_formula_name,
706: p_inputs => l_inputs,
707: p_outputs => l_outputs);
708:
709: l_weekly_working_hours := fnd_number.canonical_to_number(l_outputs(1).value);
710:
711: if l_weekly_working_hours is null then
712: l_weekly_working_hours := 0;
713: end if;

Line 720: l_ind_work_hours := fnd_number.canonical_to_number(l_ind_work_hours2);

716: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| p_assignment_id || p_reporting_date ,10);
717: OPEN csr_get_freq_ind_hours(p_assignment_id,p_reporting_date);
718: fetch csr_get_freq_ind_hours into l_ind_work_hours2,l_frequency;
719: close csr_get_freq_ind_hours;
720: l_ind_work_hours := fnd_number.canonical_to_number(l_ind_work_hours2);
721: weeks_per_month := pay_nl_general.get_global_value(p_reporting_date,'NL_TAX_WEEKS_PER_MONTH');
722: if l_frequency = 'M' then
723: l_weekly_working_hours := l_ind_work_hours/fnd_number.canonical_to_number(weeks_per_month);
724: else

Line 723: l_weekly_working_hours := l_ind_work_hours/fnd_number.canonical_to_number(weeks_per_month);

719: close csr_get_freq_ind_hours;
720: l_ind_work_hours := fnd_number.canonical_to_number(l_ind_work_hours2);
721: weeks_per_month := pay_nl_general.get_global_value(p_reporting_date,'NL_TAX_WEEKS_PER_MONTH');
722: if l_frequency = 'M' then
723: l_weekly_working_hours := l_ind_work_hours/fnd_number.canonical_to_number(weeks_per_month);
724: else
725: if l_frequency = 'D' then
726: l_weekly_working_hours := l_ind_work_hours * 5;
727: else l_weekly_working_hours := l_ind_work_hours;

Line 767: p_cao_code := fnd_number.canonical_to_number(l_cao_code);

763:
764: OPEN csr_get_cao_code(p_assignment_id);
765: FETCH csr_get_cao_code INTO l_cao_code;
766: CLOSE csr_get_cao_code;
767: p_cao_code := fnd_number.canonical_to_number(l_cao_code);
768:
769: -- hr_utility.set_location('Leaving GET_CAO_CODE ',425);
770:
771: END GET_CAO_CODE;

Line 1572: l_unpaid_hours1 := fnd_number.number_to_canonical(l_unpaid_hours);

1568: l_number:= get_employment_code(l_assignment_id,l_employment_code,l_reporting_start_date,l_reporting_end_date);
1569: l_public_sector := hr_nl_org_info.Get_Public_Sector_Org(l_employer_id);
1570: l_number := get_grade_salary_number(l_assignment_id,l_business_group_id,l_employer_id,l_grade_id,l_reporting_date
1571: ,l_public_sector,l_grade_number,l_salary_number);
1572: l_unpaid_hours1 := fnd_number.number_to_canonical(l_unpaid_hours);
1573: l_overtime_hours1 := fnd_number.number_to_canonical(l_overtime_hours);
1574:
1575: Mandatory_Check('PAY_NL_EE_REQUIRED_FIELD','NL_EMPLOY_TYPE',l_employment_code);
1576: Mandatory_Check('PAY_NL_EE_REQUIRED_FIELD','NL_GRADE_NUMBER',l_grade_number);

Line 1573: l_overtime_hours1 := fnd_number.number_to_canonical(l_overtime_hours);

1569: l_public_sector := hr_nl_org_info.Get_Public_Sector_Org(l_employer_id);
1570: l_number := get_grade_salary_number(l_assignment_id,l_business_group_id,l_employer_id,l_grade_id,l_reporting_date
1571: ,l_public_sector,l_grade_number,l_salary_number);
1572: l_unpaid_hours1 := fnd_number.number_to_canonical(l_unpaid_hours);
1573: l_overtime_hours1 := fnd_number.number_to_canonical(l_overtime_hours);
1574:
1575: Mandatory_Check('PAY_NL_EE_REQUIRED_FIELD','NL_EMPLOY_TYPE',l_employment_code);
1576: Mandatory_Check('PAY_NL_EE_REQUIRED_FIELD','NL_GRADE_NUMBER',l_grade_number);
1577: Mandatory_Check('PAY_NL_EE_REQUIRED_FIELD','NL_SALARY_NUMBER',l_salary_number);