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_ABP_REPORT dependencies on FND_DATE

Line 161: l_string_value := fnd_date.date_to_chardate(l_start_date);

157: l_string_value := get_lookup_value('NL_ABP_REPORT_TYPE',l_report_type,l_lang);
158:
159: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
160:
161: l_string_value := fnd_date.date_to_chardate(l_start_date);
162: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
163:
164: l_string_value := fnd_date.date_to_chardate(l_end_date);
165: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

Line 164: l_string_value := fnd_date.date_to_chardate(l_end_date);

160:
161: l_string_value := fnd_date.date_to_chardate(l_start_date);
162: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
163:
164: l_string_value := fnd_date.date_to_chardate(l_end_date);
165: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
166:
167: IF l_org_struct_id IS NOT NULL THEN
168: OPEN csr_get_hierarchy(l_org_struct_id);

Line 278: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') asg_start_date

274:
275: CURSOR csr_asg_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
276: SELECT pai.action_information1 emp_num
277: ,pai.action_information2 asg_num
278: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') asg_start_date
279: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') asg_end_date
280: ,pai.action_information5 term_reason
281: ,decode (pai.action_information5
282: ,'R', 'A'

Line 279: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') asg_end_date

275: CURSOR csr_asg_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
276: SELECT pai.action_information1 emp_num
277: ,pai.action_information2 asg_num
278: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') asg_start_date
279: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') asg_end_date
280: ,pai.action_information5 term_reason
281: ,decode (pai.action_information5
282: ,'R', 'A'
283: ,'A', 'R'

Line 299: ,to_char(fnd_date.canonical_to_date(pai.action_information7),'RRRR-MM-DD') date_of_birth

295: ,pai.action_information3 sofi_number
296: ,pai.action_information4 last_name
297: ,pai.action_information5 init
298: ,pai.action_information6 prefix
299: ,to_char(fnd_date.canonical_to_date(pai.action_information7),'RRRR-MM-DD') date_of_birth
300: ,pai.action_information8 nationality
301: ,pai.action_information9 gender
302: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') date_of_death
303: ,pai.action_information11 p_last_name

Line 302: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') date_of_death

298: ,pai.action_information6 prefix
299: ,to_char(fnd_date.canonical_to_date(pai.action_information7),'RRRR-MM-DD') date_of_birth
300: ,pai.action_information8 nationality
301: ,pai.action_information9 gender
302: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') date_of_death
303: ,pai.action_information11 p_last_name
304: ,pai.action_information12 p_prefix
305: ,pai.action_information13 p_init
306: ,pai.action_information14 street

Line 316: ,to_char(fnd_date.canonical_to_date(pai.action_information24),'RRRR-MM-DD') marital_status_sd

312: ,pai.action_information20 region
313: ,pai.action_information21 iso
314: ,pai.action_information22 style
315: ,pai.action_information23 marital_status
316: ,to_char(fnd_date.canonical_to_date(pai.action_information24),'RRRR-MM-DD') marital_status_sd
317: ,pai.action_information25 indv_exe
318: ,to_char(fnd_date.canonical_to_date(pai.action_information26),'RRRR-MM-DD') start_date
319: ,to_char(fnd_date.canonical_to_date(pai.action_information27),'RRRR-MM-DD') end_date
320: ,pai.action_information28 person_data_flag

Line 318: ,to_char(fnd_date.canonical_to_date(pai.action_information26),'RRRR-MM-DD') start_date

314: ,pai.action_information22 style
315: ,pai.action_information23 marital_status
316: ,to_char(fnd_date.canonical_to_date(pai.action_information24),'RRRR-MM-DD') marital_status_sd
317: ,pai.action_information25 indv_exe
318: ,to_char(fnd_date.canonical_to_date(pai.action_information26),'RRRR-MM-DD') start_date
319: ,to_char(fnd_date.canonical_to_date(pai.action_information27),'RRRR-MM-DD') end_date
320: ,pai.action_information28 person_data_flag
321: FROM pay_action_information pai
322: WHERE pai.action_context_id = c_assignment_action_id

Line 319: ,to_char(fnd_date.canonical_to_date(pai.action_information27),'RRRR-MM-DD') end_date

315: ,pai.action_information23 marital_status
316: ,to_char(fnd_date.canonical_to_date(pai.action_information24),'RRRR-MM-DD') marital_status_sd
317: ,pai.action_information25 indv_exe
318: ,to_char(fnd_date.canonical_to_date(pai.action_information26),'RRRR-MM-DD') start_date
319: ,to_char(fnd_date.canonical_to_date(pai.action_information27),'RRRR-MM-DD') end_date
320: ,pai.action_information28 person_data_flag
321: FROM pay_action_information pai
322: WHERE pai.action_context_id = c_assignment_action_id
323: AND pai.action_information_category = 'NL_ABP_EMP_INFO'

Line 327: SELECT to_char(fnd_date.canonical_to_date(pai.action_information1),'RRRR-MM-DD') start_date

323: AND pai.action_information_category = 'NL_ABP_EMP_INFO'
324: AND pai.action_context_type = 'AAP';
325: --=============================================================================
326: CURSOR csr_pay_period_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
327: SELECT to_char(fnd_date.canonical_to_date(pai.action_information1),'RRRR-MM-DD') start_date
328: ,to_char(fnd_date.canonical_to_date(pai.action_information2),'RRRR-MM-DD') end_date
329: ,pai.action_information3 kop
330: ,pai.action_information4 income_code
331: ,fnd_number.canonical_to_number(pai.action_information5) ptp

Line 328: ,to_char(fnd_date.canonical_to_date(pai.action_information2),'RRRR-MM-DD') end_date

324: AND pai.action_context_type = 'AAP';
325: --=============================================================================
326: CURSOR csr_pay_period_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
327: SELECT to_char(fnd_date.canonical_to_date(pai.action_information1),'RRRR-MM-DD') start_date
328: ,to_char(fnd_date.canonical_to_date(pai.action_information2),'RRRR-MM-DD') end_date
329: ,pai.action_information3 kop
330: ,pai.action_information4 income_code
331: ,fnd_number.canonical_to_number(pai.action_information5) ptp
332: ,pai.action_information6 code_inc

Line 342: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') pension_type_sdate

338: --=============================================================================
339: CURSOR csr_pension_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,c_effective_date VARCHAR2) IS
340: SELECT pai.action_information1 pension_type
341: ,pai.action_information2 pension_type_variant
342: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') pension_type_sdate
343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate
344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base

Line 343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate

339: CURSOR csr_pension_details(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,c_effective_date VARCHAR2) IS
340: SELECT pai.action_information1 pension_type
341: ,pai.action_information2 pension_type_variant
342: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') pension_type_sdate
343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate
344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt

Line 349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893

345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893
350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate
351: FROM pay_action_information pai
352: WHERE pai.action_context_id = c_assignment_action_id
353: AND pai.action_information_category = 'NL_ABP_PENSION_INFO'

Line 350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate

346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893
350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate
351: FROM pay_action_information pai
352: WHERE pai.action_context_id = c_assignment_action_id
353: AND pai.action_information_category = 'NL_ABP_PENSION_INFO'
354: AND action_context_type = 'AAP'

Line 355: AND to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') <= c_effective_date; --Bug 16301893

351: FROM pay_action_information pai
352: WHERE pai.action_context_id = c_assignment_action_id
353: AND pai.action_information_category = 'NL_ABP_PENSION_INFO'
354: AND action_context_type = 'AAP'
355: AND to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') <= c_effective_date; --Bug 16301893
356: --=============================================================================
357: CURSOR csr_get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
358: SELECT ppa.payroll_action_id
359: FROM pay_payroll_actions ppa

Line 458: Tag(x,'datumAanvangA',fnd_date.date_to_chardate(

454: Tag(x,'datumEinde',l_asg_details.asg_end_date); -- asg end date
455: Tag(x,'redenEinde',l_asg_details.term_reason); -- end of participation reason
456: Tag(x,'aard',l_asg_details.kind_emp); -- kind of emp*
457: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
458: Tag(x,'datumAanvangA',fnd_date.date_to_chardate(
459: to_date(l_asg_details.asg_start_date,'YYYY-MM-DD')));
460: Tag(x,'datumEindeA',fnd_date.date_to_chardate(
461: to_date(l_asg_details.asg_end_date,'YYYY-MM-DD')));
462: Tag(x,'redenEinde',get_lookup_value('PQP_NL_OVERRIDE_REASON',l_asg_details.term_reason_pdf,l_lang));

Line 460: Tag(x,'datumEindeA',fnd_date.date_to_chardate(

456: Tag(x,'aard',l_asg_details.kind_emp); -- kind of emp*
457: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
458: Tag(x,'datumAanvangA',fnd_date.date_to_chardate(
459: to_date(l_asg_details.asg_start_date,'YYYY-MM-DD')));
460: Tag(x,'datumEindeA',fnd_date.date_to_chardate(
461: to_date(l_asg_details.asg_end_date,'YYYY-MM-DD')));
462: Tag(x,'redenEinde',get_lookup_value('PQP_NL_OVERRIDE_REASON',l_asg_details.term_reason_pdf,l_lang));
463: END IF;
464:

Line 478: Tag(x,'datumAanvang',fnd_date.date_to_chardate(

474: Tag(x,'soortInkomstenverhouding',report_data(i).income_code); -- income code
475: Tag(x,'deeltijdfactor',to_char(report_data(i).ptp,'FM0.0000')); -- parttime factor*
476: Tag(x,'codeMeetelling',report_data(i).code_inc); -- code included*
477: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
478: Tag(x,'datumAanvang',fnd_date.date_to_chardate(
479: to_date(report_data(i).start_date,'YYYY-MM-DD')));
480: Tag(x,'datumEinde',fnd_date.date_to_chardate(
481: to_date(report_data(i).end_date,'YYYY-MM-DD')));
482: Tag(x,'verbijzonderingInkomstenverhouding',get_lookup_value('PQP_NL_KIND_OF_PARTICIPATION'

Line 480: Tag(x,'datumEinde',fnd_date.date_to_chardate(

476: Tag(x,'codeMeetelling',report_data(i).code_inc); -- code included*
477: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
478: Tag(x,'datumAanvang',fnd_date.date_to_chardate(
479: to_date(report_data(i).start_date,'YYYY-MM-DD')));
480: Tag(x,'datumEinde',fnd_date.date_to_chardate(
481: to_date(report_data(i).end_date,'YYYY-MM-DD')));
482: Tag(x,'verbijzonderingInkomstenverhouding',get_lookup_value('PQP_NL_KIND_OF_PARTICIPATION'
483: ,report_data(i).kop,l_lang));
484: Tag(x,'deeltijdfactor',to_char(report_data(i).ptp*100,'FM990D00'));

Line 602: Tag(x,'geboortedatum',fnd_date.date_to_chardate(

598: Tag(x,'datumOverlijden',l_emp_details.date_of_death); -- date of decease
599: Tag(x,'codeBurgerlijkeStaat',l_emp_details.marital_status); -- marital status
600: Tag(x,'datumIngangBurgerlijkeStaat',l_emp_details.marital_status_sd); -- start date marital status
601: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
602: Tag(x,'geboortedatum',fnd_date.date_to_chardate(
603: to_date(l_emp_details.date_of_birth,'YYYY-MM-DD')));
604: Tag(x,'nationaliteit',l_nationality);
605: Tag(x,'geslacht',get_lookup_value('SEX',REPLACE(REPLACE(l_emp_details.gender
606: ,'1','M'),'2','F'),l_lang));

Line 607: Tag(x,'datumOverlijden',fnd_date.date_to_chardate(

603: to_date(l_emp_details.date_of_birth,'YYYY-MM-DD')));
604: Tag(x,'nationaliteit',l_nationality);
605: Tag(x,'geslacht',get_lookup_value('SEX',REPLACE(REPLACE(l_emp_details.gender
606: ,'1','M'),'2','F'),l_lang));
607: Tag(x,'datumOverlijden',fnd_date.date_to_chardate(
608: to_date(l_emp_details.date_of_death,'YYYY-MM-DD')));
609: END IF;
610: Tag(x,'naamPartner',l_emp_details.p_last_name); -- last name partner
611: Tag(x,'voorlettersPartner',l_emp_details.p_init); -- initials partner*

Line 666: ,to_char(fnd_date.canonical_to_date(action_information2),'YYYYMM') period

662:
663: CURSOR csr_get_file_details(c_payroll_action_id IN NUMBER)
664: IS
665: SELECT action_information1 reg_num_sender
666: ,to_char(fnd_date.canonical_to_date(action_information2),'YYYYMM') period
667: ,action_information3 seq_num
668: ,action_information4 version
669: ,action_information5 creation_date
670: ,action_information6 period_type

Line 674: ,to_char(fnd_date.canonical_to_date(action_information10),'MM YYYY') ref_file

670: ,action_information6 period_type
671: ,action_information7 prod_test
672: ,action_information8 name_sender
673: ,action_information9 release
674: ,to_char(fnd_date.canonical_to_date(action_information10),'MM YYYY') ref_file
675: FROM pay_action_information pai
676: WHERE pai.action_context_id = c_payroll_action_id
677: AND pai.action_information_category = 'NL_ABP_SENDER_INFO'
678: AND pai.action_context_type = 'PA';

Line 684: ,to_char(fnd_date.canonical_to_date(action_information3),'RRRR-MM-DD') start_date

680: CURSOR csr_get_employer_det(c_payroll_action_id IN NUMBER)
681: IS
682: SELECT action_information1 er_num
683: ,action_information2 freq
684: ,to_char(fnd_date.canonical_to_date(action_information3),'RRRR-MM-DD') start_date
685: ,to_char(fnd_date.canonical_to_date(action_information4),'RRRR-MM-DD') end_date
686: ,action_information5 ref_er
687: ,action_information6 org_id
688: FROM pay_action_information pai

Line 685: ,to_char(fnd_date.canonical_to_date(action_information4),'RRRR-MM-DD') end_date

681: IS
682: SELECT action_information1 er_num
683: ,action_information2 freq
684: ,to_char(fnd_date.canonical_to_date(action_information3),'RRRR-MM-DD') start_date
685: ,to_char(fnd_date.canonical_to_date(action_information4),'RRRR-MM-DD') end_date
686: ,action_information5 ref_er
687: ,action_information6 org_id
688: FROM pay_action_information pai
689: WHERE pai.action_context_id = c_payroll_action_id

Line 767: , to_char (fnd_date.canonical_to_date (pai.action_information3), 'RRRR-MM-DD') start_date

763: --=============================================================================
764: CURSOR csr_asg_withdrawal(c_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE) IS
765: SELECT pai.action_information1 emp_num
766: , pai.action_information2 asg_num
767: , to_char (fnd_date.canonical_to_date (pai.action_information3), 'RRRR-MM-DD') start_date
768: , pai.action_information4 sofi_num
769: , pai.action_information5 code_withdrawal
770: FROM pay_action_information pai
771: WHERE pai.action_context_id IN

Line 831: Tag(x,'datumAanvangTijdvak',fnd_date.date_to_chardate(

827: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
828: Tag(x,'periodiciteit',get_lookup_value('NL_WR_PERIOD_TYPE',
829: REPLACE(REPLACE(l_employer_det.freq,'MND','MONTH'),
830: 'VWK','LMONTH'),l_lang));
831: Tag(x,'datumAanvangTijdvak',fnd_date.date_to_chardate(
832: to_date(l_employer_det.start_date,'YYYY-MM-DD')));
833: Tag(x,'datumEindeTijdvak',fnd_date.date_to_chardate(
834: to_date(l_employer_det.end_date,'YYYY-MM-DD')));
835: END IF;

Line 833: Tag(x,'datumEindeTijdvak',fnd_date.date_to_chardate(

829: REPLACE(REPLACE(l_employer_det.freq,'MND','MONTH'),
830: 'VWK','LMONTH'),l_lang));
831: Tag(x,'datumAanvangTijdvak',fnd_date.date_to_chardate(
832: to_date(l_employer_det.start_date,'YYYY-MM-DD')));
833: Tag(x,'datumEindeTijdvak',fnd_date.date_to_chardate(
834: to_date(l_employer_det.end_date,'YYYY-MM-DD')));
835: END IF;
836: Tag(x,'referentieAansluiting',l_employer_det.ref_er); -- ref employer
837: -- Generate xml for Employer details end

Line 873: Tag(x,'datumAanvangInkomstenperiode',fnd_date.date_to_chardate(

869: Tag(x,'datumAanvangInkomstenperiode',v_csr_asg_withdrawal.start_date); -- start date pay period*
870: Tag(x,'bsn',v_csr_asg_withdrawal.sofi_num); -- BSN/Sofi no.*
871: Tag(x,'indicatieIntrekkingIkv',v_csr_asg_withdrawal.code_withdrawal); -- code withdrawal asg
872: ELSIF p_abp_output_type = 'NLABP_PDF' THEN
873: Tag(x,'datumAanvangInkomstenperiode',fnd_date.date_to_chardate(
874: to_date(v_csr_asg_withdrawal.start_date,'YYYY-MM-DD')));
875: Tag(x,'bsn',v_csr_asg_withdrawal.sofi_num);
876: Tag(x,'indicatieIntrekkingIkv',get_lookup_value('HR_NL_YES_NO',
877: REPLACE(REPLACE(v_csr_asg_withdrawal.code_withdrawal