APPS.PAY_PYCAROEP_XMLP_PKG dependencies on FND_NUMBER

Line 39: If fnd_number.canonical_to_number(P_PERSON_ID) is not NULL then

35: null;
36: c_business_group_name := hr_reports.get_business_group(p_business_group_id);
37:
38:
39: If fnd_number.canonical_to_number(P_PERSON_ID) is not NULL then
40:
41: Open csr_get_person(fnd_number.canonical_to_number(P_PERSON_ID));
42: Fetch csr_get_person into l_person;
43: If csr_get_person%notfound then

Line 41: Open csr_get_person(fnd_number.canonical_to_number(P_PERSON_ID));

37:
38:
39: If fnd_number.canonical_to_number(P_PERSON_ID) is not NULL then
40:
41: Open csr_get_person(fnd_number.canonical_to_number(P_PERSON_ID));
42: Fetch csr_get_person into l_person;
43: If csr_get_person%notfound then
44: close csr_get_person;
45: End if;

Line 51: IF fnd_number.canonical_to_number(P_ASSIGNMENT_SET) is not NULL then

47: CP_PERSON := l_person;
48:
49: End if;
50:
51: IF fnd_number.canonical_to_number(P_ASSIGNMENT_SET) is not NULL then
52:
53: open csr_get_asg_set(fnd_number.canonical_to_number(P_ASSIGNMENT_SET));
54: Fetch csr_get_asg_set into l_asg_set;
55: If csr_get_asg_set%notfound then

Line 53: open csr_get_asg_set(fnd_number.canonical_to_number(P_ASSIGNMENT_SET));

49: End if;
50:
51: IF fnd_number.canonical_to_number(P_ASSIGNMENT_SET) is not NULL then
52:
53: open csr_get_asg_set(fnd_number.canonical_to_number(P_ASSIGNMENT_SET));
54: Fetch csr_get_asg_set into l_asg_set;
55: If csr_get_asg_set%notfound then
56: close csr_get_asg_set;
57: Else