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

Line 210: p_report_date := fnd_date.canonical_to_date (lr_parameter_info.report_date);

206: p_div_code := lr_parameter_info.division;
207: p_request_for_div := lr_parameter_info.request_for_div;
208: p_agreement_area := lr_parameter_info.agreement_area;
209: p_request_for_agreement := lr_parameter_info.request_for_agreement;
210: p_report_date := fnd_date.canonical_to_date (lr_parameter_info.report_date);
211: p_precedence_end_date := fnd_date.canonical_to_date (lr_parameter_info.precedence_end_date);
212: p_emp_catg := lr_parameter_info.emp_catg;
213: p_asg_catg := lr_parameter_info.asg_catg;
214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);

Line 211: p_precedence_end_date := fnd_date.canonical_to_date (lr_parameter_info.precedence_end_date);

207: p_request_for_div := lr_parameter_info.request_for_div;
208: p_agreement_area := lr_parameter_info.agreement_area;
209: p_request_for_agreement := lr_parameter_info.request_for_agreement;
210: p_report_date := fnd_date.canonical_to_date (lr_parameter_info.report_date);
211: p_precedence_end_date := fnd_date.canonical_to_date (lr_parameter_info.precedence_end_date);
212: p_emp_catg := lr_parameter_info.emp_catg;
213: p_asg_catg := lr_parameter_info.asg_catg;
214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);
215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);

Line 214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);

210: p_report_date := fnd_date.canonical_to_date (lr_parameter_info.report_date);
211: p_precedence_end_date := fnd_date.canonical_to_date (lr_parameter_info.precedence_end_date);
212: p_emp_catg := lr_parameter_info.emp_catg;
213: p_asg_catg := lr_parameter_info.asg_catg;
214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);
215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);
216: p_emp_sec := lr_parameter_info.requesting_emp_sec;
217: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
218: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);

Line 215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);

211: p_precedence_end_date := fnd_date.canonical_to_date (lr_parameter_info.precedence_end_date);
212: p_emp_catg := lr_parameter_info.emp_catg;
213: p_asg_catg := lr_parameter_info.asg_catg;
214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);
215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);
216: p_emp_sec := lr_parameter_info.requesting_emp_sec;
217: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
218: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
219: p_effective_date := lr_parameter_info.effective_date;

Line 217: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);

213: p_asg_catg := lr_parameter_info.asg_catg;
214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);
215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);
216: p_emp_sec := lr_parameter_info.requesting_emp_sec;
217: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
218: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
219: p_effective_date := lr_parameter_info.effective_date;
220: p_business_group_id := lr_parameter_info.bg_id;
221: p_sort_order := lr_parameter_info.sort_order;

Line 218: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);

214: p_start_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.start_date_of_birth);
215: p_end_date_of_birth := fnd_date.canonical_to_date (lr_parameter_info.end_date_of_birth);
216: p_emp_sec := lr_parameter_info.requesting_emp_sec;
217: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
218: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
219: p_effective_date := lr_parameter_info.effective_date;
220: p_business_group_id := lr_parameter_info.bg_id;
221: p_sort_order := lr_parameter_info.sort_order;
222:

Line 324: p_action_information5 => fnd_date.date_to_canonical (g_start_date),

320: p_action_information1 => 'PYSETRNA',
321: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
322: p_action_information3 => g_legal_employer_id,
323: p_action_information4 => l_legal_employer_details.legal_employer_name,
324: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
325: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
326: p_action_information7 => hr_general.decode_lookup ('SE_REQUEST_LEVEL', g_request_for_div),
327: p_action_information8 => g_div_code,
328: p_action_information9 => hr_general.decode_lookup ('SE_DIVISION_CODE', g_div_code),

Line 325: p_action_information6 => fnd_date.date_to_canonical (g_end_date),

321: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
322: p_action_information3 => g_legal_employer_id,
323: p_action_information4 => l_legal_employer_details.legal_employer_name,
324: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
325: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
326: p_action_information7 => hr_general.decode_lookup ('SE_REQUEST_LEVEL', g_request_for_div),
327: p_action_information8 => g_div_code,
328: p_action_information9 => hr_general.decode_lookup ('SE_DIVISION_CODE', g_div_code),
329: p_action_information10 => hr_general.decode_lookup ('SE_REQUEST_LEVEL', g_request_for_agreement),

Line 335: p_action_information16 => fnd_date.date_to_canonical (g_start_date_of_birth),

331: p_action_information12 => hr_general.decode_lookup ('SE_AGREEMENT_CODE', g_agreement_area),
332: p_action_information13 => hr_general.decode_lookup ('EMPLOYEE_CATG', g_emp_catg),
333: p_action_information14 => hr_general.decode_lookup ('EMP_CAT', g_asg_catg),
334: p_action_information15 => hr_general.decode_lookup ('HR_SE_EMP_SECTION', g_emp_sec),
335: p_action_information16 => fnd_date.date_to_canonical (g_start_date_of_birth),
336: p_action_information17 => fnd_date.date_to_canonical (g_end_date_of_birth),
337: p_action_information18 => fnd_date.date_to_canonical (g_precedence_end_date),
338: p_action_information19 => fnd_date.date_to_canonical (g_report_date),
339: p_action_information20 => g_sort_order

Line 336: p_action_information17 => fnd_date.date_to_canonical (g_end_date_of_birth),

332: p_action_information13 => hr_general.decode_lookup ('EMPLOYEE_CATG', g_emp_catg),
333: p_action_information14 => hr_general.decode_lookup ('EMP_CAT', g_asg_catg),
334: p_action_information15 => hr_general.decode_lookup ('HR_SE_EMP_SECTION', g_emp_sec),
335: p_action_information16 => fnd_date.date_to_canonical (g_start_date_of_birth),
336: p_action_information17 => fnd_date.date_to_canonical (g_end_date_of_birth),
337: p_action_information18 => fnd_date.date_to_canonical (g_precedence_end_date),
338: p_action_information19 => fnd_date.date_to_canonical (g_report_date),
339: p_action_information20 => g_sort_order
340: );

Line 337: p_action_information18 => fnd_date.date_to_canonical (g_precedence_end_date),

333: p_action_information14 => hr_general.decode_lookup ('EMP_CAT', g_asg_catg),
334: p_action_information15 => hr_general.decode_lookup ('HR_SE_EMP_SECTION', g_emp_sec),
335: p_action_information16 => fnd_date.date_to_canonical (g_start_date_of_birth),
336: p_action_information17 => fnd_date.date_to_canonical (g_end_date_of_birth),
337: p_action_information18 => fnd_date.date_to_canonical (g_precedence_end_date),
338: p_action_information19 => fnd_date.date_to_canonical (g_report_date),
339: p_action_information20 => g_sort_order
340: );
341:

Line 338: p_action_information19 => fnd_date.date_to_canonical (g_report_date),

334: p_action_information15 => hr_general.decode_lookup ('HR_SE_EMP_SECTION', g_emp_sec),
335: p_action_information16 => fnd_date.date_to_canonical (g_start_date_of_birth),
336: p_action_information17 => fnd_date.date_to_canonical (g_end_date_of_birth),
337: p_action_information18 => fnd_date.date_to_canonical (g_precedence_end_date),
338: p_action_information19 => fnd_date.date_to_canonical (g_report_date),
339: p_action_information20 => g_sort_order
340: );
341:
342: FOR rec_legal_employer_details IN csr_legal_employer_details (g_legal_employer_id)

Line 420: AND (SELECT nvl(fnd_date.canonical_to_date (hs.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy'))

416: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
417: AND hoi.organization_id = nvl (p_legal_employer_id, hoi.organization_id)
418: AND hoi.org_information_context = 'SE_LOCAL_UNITS'
419: AND hoi.org_information1 = hsck.segment2
420: AND (SELECT nvl(fnd_date.canonical_to_date (hs.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy'))
421: FROM hr_soft_coding_keyflex hs
422: WHERE hs.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id) <= nvl (
423: g_precedence_end_date,
424: TO_DATE ('31/12/4712', 'dd/mm/yyyy')

Line 426: /*AND fnd_date.canonical_to_date (nvl('2001/01/01 00:00:00','2001/01/01 00:00:00')) <=

422: WHERE hs.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id) <= nvl (
423: g_precedence_end_date,
424: TO_DATE ('31/12/4712', 'dd/mm/yyyy')
425: ); -- Inner Query for 7162312
426: /*AND fnd_date.canonical_to_date (nvl('2001/01/01 00:00:00','2001/01/01 00:00:00')) <=
427: nvl(g_precedence_end_date,
428: fnd_date.canonical_to_date ('4712/12/31 00:00:00')
429: ); */
430:

Line 428: fnd_date.canonical_to_date ('4712/12/31 00:00:00')

424: TO_DATE ('31/12/4712', 'dd/mm/yyyy')
425: ); -- Inner Query for 7162312
426: /*AND fnd_date.canonical_to_date (nvl('2001/01/01 00:00:00','2001/01/01 00:00:00')) <=
427: nvl(g_precedence_end_date,
428: fnd_date.canonical_to_date ('4712/12/31 00:00:00')
429: ); */
430:
431: /* Cursor to get the Start Date of the Assignment */
432: CURSOR csr_start_date (

Line 447: SELECT fnd_date.canonical_to_date (hsck.segment6) termination_date,

443: CURSOR csr_emp_details (
444: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
445: p_effective_date DATE
446: ) IS
447: SELECT fnd_date.canonical_to_date (hsck.segment6) termination_date,
448: fnd_date.canonical_to_date (hsck.segment16)
449: precedence_date
450: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
451: WHERE paaf.assignment_id = p_assignment_id

Line 448: fnd_date.canonical_to_date (hsck.segment16)

444: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
445: p_effective_date DATE
446: ) IS
447: SELECT fnd_date.canonical_to_date (hsck.segment6) termination_date,
448: fnd_date.canonical_to_date (hsck.segment16)
449: precedence_date
450: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
451: WHERE paaf.assignment_id = p_assignment_id
452: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 603: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),

599: p_action_information3 => person_assignments_rec.person_id,
600: p_action_information4 => person_assignments_rec.national_identifier,
601: p_action_information5 => person_assignments_rec.assignment_number,
602: p_action_information6 => person_assignments_rec.full_name,
603: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
604: p_action_information8 => fnd_number.number_to_canonical (l_total_emp_time),
605: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),
606: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),
607: p_action_information11 => l_emp_type,

Line 605: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),

601: p_action_information5 => person_assignments_rec.assignment_number,
602: p_action_information6 => person_assignments_rec.full_name,
603: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
604: p_action_information8 => fnd_number.number_to_canonical (l_total_emp_time),
605: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),
606: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),
607: p_action_information11 => l_emp_type,
608: p_action_information12 => g_emp_sec,
609: p_action_information13 => rec_legal_employer_details.legal_id,

Line 606: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),

602: p_action_information6 => person_assignments_rec.full_name,
603: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
604: p_action_information8 => fnd_number.number_to_canonical (l_total_emp_time),
605: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),
606: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),
607: p_action_information11 => l_emp_type,
608: p_action_information12 => g_emp_sec,
609: p_action_information13 => rec_legal_employer_details.legal_id,
610: p_action_information14 => person_assignments_rec.div_code,

Line 637: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),

633: p_action_information3 => person_assignments_rec.person_id,
634: p_action_information4 => person_assignments_rec.national_identifier,
635: p_action_information5 => person_assignments_rec.assignment_number,
636: p_action_information6 => person_assignments_rec.full_name,
637: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
638: p_action_information8 => l_total_emp_time,
639: p_action_information9 => NULL,
640: p_action_information10 => NULL,
641: p_action_information11 => l_emp_type,

Line 671: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),

667: p_action_information3 => person_assignments_rec.person_id,
668: p_action_information4 => person_assignments_rec.national_identifier,
669: p_action_information5 => person_assignments_rec.assignment_number,
670: p_action_information6 => person_assignments_rec.full_name,
671: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
672: p_action_information8 => l_total_emp_time,
673: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),
674: p_action_information10 => NULL,
675: p_action_information11 => l_emp_type,

Line 673: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),

669: p_action_information5 => person_assignments_rec.assignment_number,
670: p_action_information6 => person_assignments_rec.full_name,
671: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
672: p_action_information8 => l_total_emp_time,
673: p_action_information9 => fnd_date.date_to_canonical (l_precedence_date),
674: p_action_information10 => NULL,
675: p_action_information11 => l_emp_type,
676: p_action_information12 => g_emp_sec,
677: p_action_information13 => rec_legal_employer_details.legal_id,

Line 705: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),

701: p_action_information3 => person_assignments_rec.person_id,
702: p_action_information4 => person_assignments_rec.national_identifier,
703: p_action_information5 => person_assignments_rec.assignment_number,
704: p_action_information6 => person_assignments_rec.full_name,
705: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
706: p_action_information8 => l_total_emp_time,
707: p_action_information9 => NULL,
708: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),
709: p_action_information11 => l_emp_type,

Line 708: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),

704: p_action_information6 => person_assignments_rec.full_name,
705: p_action_information7 => fnd_date.date_to_canonical (l_hire_date),
706: p_action_information8 => l_total_emp_time,
707: p_action_information9 => NULL,
708: p_action_information10 => fnd_date.date_to_canonical (l_termination_date),
709: p_action_information11 => l_emp_type,
710: p_action_information12 => g_emp_sec,
711: p_action_information13 => rec_legal_employer_details.legal_id,
712: p_action_information14 => person_assignments_rec.div_code,