APPS.PAY_GB_PRE_RTI_NINO dependencies on FND_GLOBAL

Line 34: fnd_global.local_chr(10) || 'f_nino_verifed varchar2' || f_nino_verifed

30: open get_emp_extra_info;
31: fetch get_emp_extra_info into l_extra_info_id, l_object_version_number, l_nino_verified_flag;
32: close get_emp_extra_info;
33: fnd_file.put_line(fnd_file.LOG,'f_person_id: ' ||to_char(f_person_id) ||
34: fnd_global.local_chr(10) || 'f_nino_verifed varchar2' || f_nino_verifed
35: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
36: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
37: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
38:

Line 35: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)

31: fetch get_emp_extra_info into l_extra_info_id, l_object_version_number, l_nino_verified_flag;
32: close get_emp_extra_info;
33: fnd_file.put_line(fnd_file.LOG,'f_person_id: ' ||to_char(f_person_id) ||
34: fnd_global.local_chr(10) || 'f_nino_verifed varchar2' || f_nino_verifed
35: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
36: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
37: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
38:
39: -- Update the extra info record using update API only when the RTI_NINO record exists

Line 36: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)

32: close get_emp_extra_info;
33: fnd_file.put_line(fnd_file.LOG,'f_person_id: ' ||to_char(f_person_id) ||
34: fnd_global.local_chr(10) || 'f_nino_verifed varchar2' || f_nino_verifed
35: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
36: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
37: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
38:
39: -- Update the extra info record using update API only when the RTI_NINO record exists
40: if l_extra_info_id is not null then

Line 37: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));

33: fnd_file.put_line(fnd_file.LOG,'f_person_id: ' ||to_char(f_person_id) ||
34: fnd_global.local_chr(10) || 'f_nino_verifed varchar2' || f_nino_verifed
35: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
36: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
37: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
38:
39: -- Update the extra info record using update API only when the RTI_NINO record exists
40: if l_extra_info_id is not null then
41: -- Check if the NINO is verified already