APPS.PQH_FR_UTILITY dependencies on FND_NUMBER

Line 858: ,p_normal_hours => fnd_number.canonical_to_number(l_bg_hours.working_hours)

854: p_effective_date => hr_general.effective_date
855: ,p_datetrack_update_mode => 'CORRECTION'
856: ,p_assignment_id => l_asg_id
857: ,p_object_version_number => l_asg_ovn
858: ,p_normal_hours => fnd_number.canonical_to_number(l_bg_hours.working_hours)
859: ,p_frequency => l_bg_hours.frequency
860: ,p_segment9 => '100'
861: ,p_segment2 => p_emp_type
862: ,p_soft_coding_keyflex_id => l_scl_id

Line 1093: l_step_rate := pqh_corps_utility.get_salary_rate(fnd_number.canonical_to_number(l_asg_dtls.pgi),p_effective_Date,null,l_gl_currency);

1089: FETCH csr_gl_currency INTO l_gl_currency;
1090: CLOSE csr_gl_currency;
1091: END IF;
1092: IF l_asg_dtls.pgi IS NOT NULL THEN
1093: l_step_rate := pqh_corps_utility.get_salary_rate(fnd_number.canonical_to_number(l_asg_dtls.pgi),p_effective_Date,null,l_gl_currency);
1094: ELSE
1095: l_step_rate := get_step_rate(l_asg_dtls.step_id, p_effective_date,l_gl_currency);
1096: END IF;
1097:

Line 1107: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100);

1103: CLOSE csr_sts_dtls;
1104: END IF;
1105:
1106: IF NVL(l_sts_dtls.situation_type,'IA') = 'IA' AND NVL(l_sts_dtls.sub_type,'IA_N') = 'IA_N' THEN -- for inactivity-normal situation pay fully
1107: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100);
1108: ELSE
1109:
1110: IF NVL(l_sts_dtls.remuneration_paid,'Y') = 'N' THEN -- if the situation doesn't entitle the civil servant for pay
1111: l_asg_salary := 0;

Line 1113: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100)*nvl(l_sts_dtls.pay_share,0);

1109:
1110: IF NVL(l_sts_dtls.remuneration_paid,'Y') = 'N' THEN -- if the situation doesn't entitle the civil servant for pay
1111: l_asg_salary := 0;
1112: ELSE -- situation allows the civil servant for pay
1113: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100)*nvl(l_sts_dtls.pay_share,0);
1114: END IF;
1115:
1116: END IF;
1117:

Line 1119: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100);

1115:
1116: END IF;
1117:
1118: ELSIF l_agent_type = '02' THEN -- for non-titulaires, no stat.sit.. so pay by salary share.
1119: l_asg_salary := l_step_rate*nvl(fnd_number.canonical_to_number(l_asg_dtls.salary_share),100);
1120: END IF;
1121: RETURN NVL(l_asg_salary,0);
1122: END get_salary_rate;
1123: --

Line 1604: SELECT FND_NUMBER.canonical_to_number(org_information4) hours, 'M' frequency

1600: p_effective_date IN DATE)
1601: RETURN VARCHAR2 IS
1602: --
1603: CURSOR csr_working_hours(p_estab_id NUMBER) IS
1604: SELECT FND_NUMBER.canonical_to_number(org_information4) hours, 'M' frequency
1605: FROM hr_organization_information_v
1606: WHERE org_information_context = 'FR_ESTAB_INFO'
1607: AND organization_id = p_estab_id;
1608: --