DBA Data[Home] [Help]

APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on FND_DATE

Line 154: p_pei_information2 => fnd_date.date_to_canonical(f_date_of_issue),

150: hr_person_extra_info_api.update_person_extra_info(
151: p_person_extra_info_id => l_extra_info_id,
152: p_pei_information_category => 'RTI_NINO',
153: p_pei_information1 => f_nino_verifed,
154: p_pei_information2 => fnd_date.date_to_canonical(f_date_of_issue),
155: p_pei_information3 => f_nvrep_status,
156: p_pei_information4 => f_nino_ver_type,
157: p_object_version_number => l_object_version_number
158: );

Line 205: p_pei_information2 => fnd_date.date_to_canonical(f_date_of_issue),

201: p_person_id =>f_person_id,
202: p_information_type => 'RTI_NINO',
203: p_pei_information_category => 'RTI_NINO',
204: p_pei_information1 => f_nino_verifed,
205: p_pei_information2 => fnd_date.date_to_canonical(f_date_of_issue),
206: p_pei_information3 => f_nvrep_status,
207: p_pei_information4 => f_nino_ver_type,
208: p_object_version_number => l_object_version_number,
209: p_person_extra_info_id => l_extra_info_id

Line 623: report_output_header(header) := 'Date Of Message Received: ' || fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_date_of_msg));

619: if l_date_of_msg_format = '102' then
620: l_date_of_msg_format := 'YYYYMMDD';
621: end if;
622: header := header + 1;
623: report_output_header(header) := 'Date Of Message Received: ' || fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_date_of_msg));
624: elsif l_record_name = 'LIN1' then
625: l_employee_count := l_employee_count + 1;
626: l_employee_number := rtrim(ltrim(substr(l_present_line,7,6)));
627: elsif l_record_name = 'ATT2' and l_qualifier = '222' then -- NINO verification / Reply value

Line 708: || rpad(nvl(l_nino_to_use,' '),14) || ' ' || rpad(l_msg_ident,18)|| ' ' || rpad(l_nino_reply_type,10)|| ' ' || fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_date_issued));

704: if l_updated_flag then
705: l_processed_success := l_processed_success + 1;
706: success := success+1;
707: report_output_success(success) := rpad(l_emp_number,15) || ' ' || rpad(l_first_name,20) || ' ' || rpad(l_last_name,18) || ' ' || rpad(nvl(l_nino_provided,' '),16) || ' '
708: || rpad(nvl(l_nino_to_use,' '),14) || ' ' || rpad(l_msg_ident,18)|| ' ' || rpad(l_nino_reply_type,10)|| ' ' || fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_date_issued));
709: l_updated_flag := false;
710: end if;
711: else
712: errbuf := 'Multiple records present for the matching criteria