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 nvl(fnd_date.canonical_to_date (hsck.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy')) <= nvl (

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 nvl(fnd_date.canonical_to_date (hsck.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy')) <= nvl (
421: g_precedence_end_date,
422: TO_DATE ('31/12/4712', 'dd/mm/yyyy')
423: );
424: /*AND fnd_date.canonical_to_date (nvl('2001/01/01 00:00:00','2001/01/01 00:00:00')) <=

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

420: AND nvl(fnd_date.canonical_to_date (hsck.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy')) <= nvl (
421: g_precedence_end_date,
422: TO_DATE ('31/12/4712', 'dd/mm/yyyy')
423: );
424: /*AND fnd_date.canonical_to_date (nvl('2001/01/01 00:00:00','2001/01/01 00:00:00')) <=
425: nvl(g_precedence_end_date,
426: fnd_date.canonical_to_date ('4712/12/31 00:00:00')
427: ); */
428:

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

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

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

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

Line 446: fnd_date.canonical_to_date (hsck.segment16)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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