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.PER_ES_SS_REP_ARCHIVE_PKG dependencies on FND_DATE

Line 201: p_effective_Date := fnd_date.canonical_to_date(l_effective_date);

197: ,p_assignment_set_id
198: ,p_business_group_id;
199: CLOSE csr_parameter_info;
200: --
201: p_effective_Date := fnd_date.canonical_to_date(l_effective_date);
202: p_test_flag := l_test_flag;
203: --
204: EXCEPTION
205: WHEN others THEN

Line 294: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date);

290: AND asg_extra.INFORMATION_TYPE = 'ES_SS_REP'
291: AND asg_extra.aei_information5 = 'Y'
292: AND asg_run.assignment_id = asg_extra.assignment_id
293: AND asg_run.business_group_id = g_business_group_id
294: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date);
295: --
296: l_unused_number NUMBER;
297: l_action_info_id pay_action_information.action_information_id%TYPE;
298: l_ovn pay_action_information.object_version_number%TYPE;

Line 330: ,p_action_information3 => fnd_date.date_to_canonical(g_effective_date)

326: ,p_object_version_number => l_ovn
327: ,p_action_information_category => 'ES_SS_REPORT_ETI'
328: ,p_action_information1 => header_details.Authorization_key
329: ,p_action_information2 => header_details.Silicon_key
330: ,p_action_information3 => fnd_date.date_to_canonical(g_effective_date)
331: ,p_action_information4 => '0000'
332: ,p_action_information5 => fnd_date.date_to_canonical(g_effective_end_date)
333: ,p_action_information6 => 'AFI'
334: ,p_action_information7 => 'N'

Line 332: ,p_action_information5 => fnd_date.date_to_canonical(g_effective_end_date)

328: ,p_action_information1 => header_details.Authorization_key
329: ,p_action_information2 => header_details.Silicon_key
330: ,p_action_information3 => fnd_date.date_to_canonical(g_effective_date)
331: ,p_action_information4 => '0000'
332: ,p_action_information5 => fnd_date.date_to_canonical(g_effective_end_date)
333: ,p_action_information6 => 'AFI'
334: ,p_action_information7 => 'N'
335: ,p_action_information8 => g_test_flag
336: ,p_action_information9 => header_details.Current_password

Line 414: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date

410: WHERE asg_extra.aei_information_category = 'ES_SS_REP'
411: AND asg_extra.aei_information5 = 'Y'
412: AND asg_run.business_group_id = g_business_group_id
413: AND asg_run.assignment_id = asg_extra.assignment_id
414: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date
415: AND asg_run.person_id BETWEEN stperson
416: AND endperson) paa
417: WHERE pap.person_id = paa.person_id
418: AND pap.business_group_id = g_business_group_id

Line 708: ,p_action_information12 => fnd_date.date_to_canonical(l_contract_start_date)

704: ,p_action_information8 => qualifying_assignments.second_last_name
705: ,p_action_information9 => qualifying_assignments.name
706: ,p_action_information10 => l_assignment_number
707: ,p_action_information11 => l_legal_employer
708: ,p_action_information12 => fnd_date.date_to_canonical(l_contract_start_date)
709: ,p_action_information13 => fnd_date.date_to_canonical(l_contract_start_date)
710: ,p_action_information14 => l_relationship_type
711: ,p_action_information15 => l_ss_identifier
712: ,p_action_information16 => l_replacement_reason_code

Line 709: ,p_action_information13 => fnd_date.date_to_canonical(l_contract_start_date)

705: ,p_action_information9 => qualifying_assignments.name
706: ,p_action_information10 => l_assignment_number
707: ,p_action_information11 => l_legal_employer
708: ,p_action_information12 => fnd_date.date_to_canonical(l_contract_start_date)
709: ,p_action_information13 => fnd_date.date_to_canonical(l_contract_start_date)
710: ,p_action_information14 => l_relationship_type
711: ,p_action_information15 => l_ss_identifier
712: ,p_action_information16 => l_replacement_reason_code
713: ,p_action_information17 => '0'

Line 746: AND fnd_date.canonical_to_date(aei_information7) <= c_effective_end_date

742: aei_information7 first_changed_date
743: FROM per_assignment_extra_info
744: WHERE assignment_id = c_assignment_id
745: AND aei_information5 = 'Y'
746: AND fnd_date.canonical_to_date(aei_information7) <= c_effective_end_date
747: ORDER BY aei_information3;
748: --
749: CURSOR csr_get_asg_values (c_assignment_id NUMBER
750: ,c_effective_start_date VARCHAR2) IS

Line 762: AND paa.effective_start_date = fnd_date.canonical_to_date(c_effective_start_date)

758: FROM per_all_assignments_f paa
759: ,per_all_people_f pap
760: WHERE paa.assignment_id = c_assignment_id
761: AND paa.person_id = pap.person_id
762: AND paa.effective_start_date = fnd_date.canonical_to_date(c_effective_start_date)
763: AND paa.effective_start_date BETWEEN pap.effective_start_date
764: AND pap.effective_end_date;
765: --
766: CURSOR csr_get_contribution_group(c_soft_coding_keyflex_id NUMBER) IS

Line 789: AND pev.effective_start_date = fnd_date.canonical_to_date(c_effective_start_date)

785: AND pet.element_type_id = pel.element_type_id
786: AND pel.element_link_id = pee.element_link_id
787: AND pet.element_name = 'Social Security Details'
788: AND pet.legislation_code = 'ES'
789: AND pev.effective_start_date = fnd_date.canonical_to_date(c_effective_start_date)
790: AND pev.effective_start_date BETWEEN piv.effective_start_date
791: AND piv.effective_end_date
792: AND pev.effective_start_date BETWEEN pet.effective_start_date
793: AND pet.effective_end_date

Line 944: ,p_effective_date => fnd_date.canonical_to_date(l_effective_report_date(1))

940: ,p_action_context_id => p_assignment_action_id
941: ,p_action_context_type => 'AAP'
942: ,p_object_version_number => l_ovn
943: ,p_action_information_category => 'ES_SS_REPORT_FAB'
944: ,p_effective_date => fnd_date.canonical_to_date(l_effective_report_date(1))
945: ,p_action_information1 => 'MA'
946: ,p_action_information2 => '0'
947: ,p_action_information3 => l_effective_report_date(1)
948: ,p_action_information4 => l_asg_status_type_id

Line 953: ,p_action_information9 => fnd_date.date_to_canonical(l_date_of_birth)

949: ,p_action_information5 => l_contract_key
950: ,p_action_information6 => l_epi_value
951: ,p_action_information7 => l_unemployment_status
952: ,p_action_information8 => l_under_repres_women
953: ,p_action_information9 => fnd_date.date_to_canonical(l_date_of_birth)
954: ,p_action_information10 => l_sex
955: ,p_action_information11 => l_rehired_disabled
956: ,p_action_information12 => l_first_contractor
957: ,p_action_information13 => l_disability_degree

Line 986: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

982: where paa.assignment_id = '||p_assignment_id||'
983: and paa.person_id = pap.person_id
984: and paa.assignment_status_type_id = pas.assignment_status_type_id
985: and pas.per_system_status = ''ACTIVE_ASSIGN''
986: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
987: between pap.effective_start_date
988: and pap.effective_end_date
989: and paa.effective_start_date
990: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

Line 990: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

986: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
987: between pap.effective_start_date
988: and pap.effective_end_date
989: and paa.effective_start_date
990: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
991: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
992: order by paa.effective_start_date';
993:
994: get_other_values(l_value(l_unused_number),

Line 991: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

987: between pap.effective_start_date
988: and pap.effective_end_date
989: and paa.effective_start_date
990: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
991: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
992: order by paa.effective_start_date';
993:
994: get_other_values(l_value(l_unused_number),
995: l_event(l_unused_number),

Line 1025: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1021: and piv.name = ''Contract Key''
1022: AND piv.legislation_code = ''ES''
1023: and pee.element_type_id = pet.element_type_id
1024: and pev.effective_start_date
1025: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1026: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1027: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1028: between pap.effective_start_date
1029: and pap.effective_end_date

Line 1026: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

1022: AND piv.legislation_code = ''ES''
1023: and pee.element_type_id = pet.element_type_id
1024: and pev.effective_start_date
1025: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1026: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1027: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1028: between pap.effective_start_date
1029: and pap.effective_end_date
1030: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

Line 1027: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1023: and pee.element_type_id = pet.element_type_id
1024: and pev.effective_start_date
1025: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1026: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1027: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1028: between pap.effective_start_date
1029: and pap.effective_end_date
1030: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1031: between paa.effective_start_date

Line 1030: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1026: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1027: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1028: between pap.effective_start_date
1029: and pap.effective_end_date
1030: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1031: between paa.effective_start_date
1032: and paa.effective_end_date
1033: AND pev.effective_start_date BETWEEN piv.effective_start_date AND piv.effective_end_date
1034: AND pev.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 1056: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

1052: ,hr_soft_coding_keyflex sck
1053: where paa.assignment_id = '||p_assignment_id||'
1054: and paa.person_id = pap.person_id
1055: and paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1056: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1057: between pap.effective_start_date
1058: and pap.effective_end_date
1059: and paa.effective_start_date
1060: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

Line 1060: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1056: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1057: between pap.effective_start_date
1058: and pap.effective_end_date
1059: and paa.effective_start_date
1060: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1061: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1062: order by paa.effective_start_date';
1063:
1064: get_other_values(l_value(l_unused_number),

Line 1061: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

1057: between pap.effective_start_date
1058: and pap.effective_end_date
1059: and paa.effective_start_date
1060: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1061: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1062: order by paa.effective_start_date';
1063:
1064: get_other_values(l_value(l_unused_number),
1065: l_event(l_unused_number),

Line 1085: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1081: and paa.person_id = pap.person_id
1082: and pps.person_id = pap.person_id
1083: and paa.period_of_service_id = pps.period_of_service_id
1084: and pps.actual_termination_date is not null
1085: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1086: between paa.effective_start_date
1087: and paa.effective_end_date
1088: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1089: between pap.effective_start_date

Line 1088: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1084: and pps.actual_termination_date is not null
1085: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1086: between paa.effective_start_date
1087: and paa.effective_end_date
1088: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1089: between pap.effective_start_date
1090: and pap.effective_end_date
1091: order by paa.effective_start_date';
1092:

Line 1124: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1120: and piv.name = ''SS Epigraph Code''
1121: and pee.element_type_id = pet.element_type_id
1122: AND piv.legislation_code = ''ES''
1123: and pev.effective_start_date
1124: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1125: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1126: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1127: between pap.effective_start_date
1128: and pap.effective_end_date

Line 1125: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

1121: and pee.element_type_id = pet.element_type_id
1122: AND piv.legislation_code = ''ES''
1123: and pev.effective_start_date
1124: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1125: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1126: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1127: between pap.effective_start_date
1128: and pap.effective_end_date
1129: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

Line 1126: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1122: AND piv.legislation_code = ''ES''
1123: and pev.effective_start_date
1124: between fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1125: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1126: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1127: between pap.effective_start_date
1128: and pap.effective_end_date
1129: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1130: between paa.effective_start_date

Line 1129: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')

1125: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')
1126: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1127: between pap.effective_start_date
1128: and pap.effective_end_date
1129: and fnd_date.canonical_to_date('''||l_first_changed_date(l_unused_number)||''')
1130: between paa.effective_start_date
1131: and paa.effective_end_date
1132: AND pev.effective_start_date BETWEEN piv.effective_start_date AND piv.effective_end_date
1133: AND pev.effective_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 1264: ,p_action_information3 => fnd_date.date_to_canonical(l_actual_date)

1260: ,p_action_information_category => 'ES_SS_REPORT_FAB'
1261: ,p_effective_date => l_actual_date
1262: ,p_action_information1 => 'MA'
1263: ,p_action_information2 => '0'
1264: ,p_action_information3 => fnd_date.date_to_canonical(l_actual_date)
1265: ,p_action_information4 => p_value
1266: ,p_action_information7 => l_unemployment_status
1267: ,p_action_information8 => l_under_repres_women
1268: ,p_action_information9 => fnd_date.date_to_canonical(l_date_of_birth)

Line 1268: ,p_action_information9 => fnd_date.date_to_canonical(l_date_of_birth)

1264: ,p_action_information3 => fnd_date.date_to_canonical(l_actual_date)
1265: ,p_action_information4 => p_value
1266: ,p_action_information7 => l_unemployment_status
1267: ,p_action_information8 => l_under_repres_women
1268: ,p_action_information9 => fnd_date.date_to_canonical(l_date_of_birth)
1269: ,p_action_information10 => l_sex
1270: ,p_action_information11 => l_rehired_disabled
1271: ,p_action_information12 => l_first_contractor
1272: ,p_action_information13 => l_disability_degree

Line 1325: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)

1321: ,p_action_information_category => 'ES_SS_REPORT_FAB'
1322: ,p_effective_date => l_actual_date
1323: ,p_action_information1 => 'MB'
1324: ,p_action_information2 => l_leave_reason_code
1325: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1326: ,p_action_information4 => p_value
1327: ,p_action_information7 => l_unemployment_status_ter
1328: ,p_action_information8 => l_under_repres_women_ter
1329: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

Line 1329: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

1325: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1326: ,p_action_information4 => p_value
1327: ,p_action_information7 => l_unemployment_status_ter
1328: ,p_action_information8 => l_under_repres_women_ter
1329: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)
1330: ,p_action_information10 => l_sex
1331: ,p_action_information11 => l_rehired_disabled_ter
1332: ,p_action_information12 => l_first_contractor_ter
1333: ,p_action_information13 => l_disability_degree_ter

Line 1357: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)

1353: ,p_action_information_category => 'ES_SS_REPORT_FAB'
1354: ,p_effective_date => l_actual_date
1355: ,p_action_information1 => 'MC'
1356: ,p_action_information2 => '0'
1357: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1358: ,p_action_information5 => l_unused_value
1359: ,p_action_information7 => l_unemployment_status
1360: ,p_action_information8 => l_under_repres_women
1361: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

Line 1361: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

1357: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1358: ,p_action_information5 => l_unused_value
1359: ,p_action_information7 => l_unemployment_status
1360: ,p_action_information8 => l_under_repres_women
1361: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)
1362: ,p_action_information10 => l_sex
1363: ,p_action_information11 => l_rehired_disabled
1364: ,p_action_information12 => l_first_contractor
1365: ,p_action_information13 => l_disability_degree

Line 1389: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)

1385: ,p_action_information_category => 'ES_SS_REPORT_FAB'
1386: ,p_effective_date => l_actual_date
1387: ,p_action_information1 => 'MG'
1388: ,p_action_information2 => '0'
1389: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1390: ,p_action_information7 => l_unemployment_status
1391: ,p_action_information8 => l_under_repres_women
1392: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)
1393: ,p_action_information10 => l_sex

Line 1392: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

1388: ,p_action_information2 => '0'
1389: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1390: ,p_action_information7 => l_unemployment_status
1391: ,p_action_information8 => l_under_repres_women
1392: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)
1393: ,p_action_information10 => l_sex
1394: ,p_action_information11 => l_rehired_disabled
1395: ,p_action_information12 => l_first_contractor
1396: ,p_action_information13 => l_disability_degree

Line 1421: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)

1417: ,p_action_information_category => 'ES_SS_REPORT_FAB'
1418: ,p_effective_date => l_actual_date
1419: ,p_action_information1 => 'MT'
1420: ,p_action_information2 => '0'
1421: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1422: ,p_action_information6 => l_unused_value
1423: ,p_action_information7 => l_unemployment_status
1424: ,p_action_information8 => l_under_repres_women
1425: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

Line 1425: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)

1421: ,p_action_information3 => fnd_date.Date_to_canonical(l_actual_date)
1422: ,p_action_information6 => l_unused_value
1423: ,p_action_information7 => l_unemployment_status
1424: ,p_action_information8 => l_under_repres_women
1425: ,p_action_information9 => fnd_date.Date_to_canonical(l_date_of_birth)
1426: ,p_action_information10 => '1'
1427: ,p_action_information11 => l_rehired_disabled
1428: ,p_action_information12 => l_first_contractor
1429: ,p_action_information13 => l_disability_degree

Line 1573: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1569: IF l_unused_number = 0 THEN
1570: UPDATE per_assignment_extra_info
1571: SET aei_information4 = l_assignment_status_type_id
1572: ,aei_information6 = 'U'
1573: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1574: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1575: ,aei_information5 = 'N'
1576: WHERE assignment_id = qualifying_assignments.assignment_id
1577: AND aei_information3 = 'AS';

Line 1574: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1570: UPDATE per_assignment_extra_info
1571: SET aei_information4 = l_assignment_status_type_id
1572: ,aei_information6 = 'U'
1573: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1574: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1575: ,aei_information5 = 'N'
1576: WHERE assignment_id = qualifying_assignments.assignment_id
1577: AND aei_information3 = 'AS';
1578: ELSE

Line 1582: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1578: ELSE
1579: UPDATE per_assignment_extra_info
1580: SET aei_information4 = l_assignment_status_type_id
1581: ,aei_information6 = 'U'
1582: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1583: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1584: WHERE assignment_id = qualifying_assignments.assignment_id
1585: AND aei_information3 = 'AS';
1586: END IF;

Line 1583: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1579: UPDATE per_assignment_extra_info
1580: SET aei_information4 = l_assignment_status_type_id
1581: ,aei_information6 = 'U'
1582: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1583: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1584: WHERE assignment_id = qualifying_assignments.assignment_id
1585: AND aei_information3 = 'AS';
1586: END IF;
1587:

Line 1622: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1618: IF l_unused_number = 0 THEN
1619: UPDATE per_assignment_extra_info
1620: SET aei_information4 = l_employment_category
1621: ,aei_information6 = 'U'
1622: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1623: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1624: ,aei_information5 = 'N'
1625: WHERE assignment_id = qualifying_assignments.assignment_id
1626: AND aei_information3 = 'EC';

Line 1623: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1619: UPDATE per_assignment_extra_info
1620: SET aei_information4 = l_employment_category
1621: ,aei_information6 = 'U'
1622: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1623: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1624: ,aei_information5 = 'N'
1625: WHERE assignment_id = qualifying_assignments.assignment_id
1626: AND aei_information3 = 'EC';
1627: ELSE

Line 1631: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1627: ELSE
1628: UPDATE per_assignment_extra_info
1629: SET aei_information4 = l_employment_category
1630: ,aei_information6 = 'U'
1631: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1632: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1633: WHERE assignment_id = qualifying_assignments.assignment_id
1634: AND aei_information3 = 'EC';
1635: END IF;

Line 1632: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1628: UPDATE per_assignment_extra_info
1629: SET aei_information4 = l_employment_category
1630: ,aei_information6 = 'U'
1631: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1632: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1633: WHERE assignment_id = qualifying_assignments.assignment_id
1634: AND aei_information3 = 'EC';
1635: END IF;
1636:

Line 1650: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1646: IF l_unused_number = 0 THEN
1647: UPDATE per_assignment_extra_info
1648: SET aei_information4 = l_contribution_group
1649: ,aei_information6 = 'U'
1650: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1651: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1652: ,aei_information5 = 'N'
1653: WHERE assignment_id = qualifying_assignments.assignment_id
1654: AND aei_information3 = 'CG';

Line 1651: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1647: UPDATE per_assignment_extra_info
1648: SET aei_information4 = l_contribution_group
1649: ,aei_information6 = 'U'
1650: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1651: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1652: ,aei_information5 = 'N'
1653: WHERE assignment_id = qualifying_assignments.assignment_id
1654: AND aei_information3 = 'CG';
1655: ELSE

Line 1659: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1655: ELSE
1656: UPDATE per_assignment_extra_info
1657: SET aei_information4 = l_contribution_group
1658: ,aei_information6 = 'U'
1659: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1660: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1661: WHERE assignment_id = qualifying_assignments.assignment_id
1662: AND aei_information3 = 'CG';
1663: END IF;

Line 1660: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1656: UPDATE per_assignment_extra_info
1657: SET aei_information4 = l_contribution_group
1658: ,aei_information6 = 'U'
1659: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1660: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1661: WHERE assignment_id = qualifying_assignments.assignment_id
1662: AND aei_information3 = 'CG';
1663: END IF;
1664:

Line 1691: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1687: IF l_unused_number = 0 THEN
1688: UPDATE per_assignment_extra_info
1689: SET aei_information4 = l_epigraph_code
1690: ,aei_information6 = 'U'
1691: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1692: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1693: ,aei_information5 = 'N'
1694: WHERE assignment_id = qualifying_assignments.assignment_id
1695: AND aei_information3 = 'EP';

Line 1692: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1688: UPDATE per_assignment_extra_info
1689: SET aei_information4 = l_epigraph_code
1690: ,aei_information6 = 'U'
1691: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1692: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1693: ,aei_information5 = 'N'
1694: WHERE assignment_id = qualifying_assignments.assignment_id
1695: AND aei_information3 = 'EP';
1696: ELSE

Line 1700: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1696: ELSE
1697: UPDATE per_assignment_extra_info
1698: SET aei_information4 = l_epigraph_code
1699: ,aei_information6 = 'U'
1700: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1701: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1702: WHERE assignment_id = qualifying_assignments.assignment_id
1703: AND aei_information3 = 'EP';
1704: END IF;

Line 1701: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1697: UPDATE per_assignment_extra_info
1698: SET aei_information4 = l_epigraph_code
1699: ,aei_information6 = 'U'
1700: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1701: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1702: WHERE assignment_id = qualifying_assignments.assignment_id
1703: AND aei_information3 = 'EP';
1704: END IF;
1705: ELSIF qualifying_assignments.action_status = 'MA' THEN

Line 1716: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1712: AND assignment_id = qualifying_assignments.assignment_id;
1713: IF l_unused_number = 0 THEN
1714: UPDATE per_assignment_extra_info
1715: SET aei_information4 = l_assignment_status_type_id
1716: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1717: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1718: ,aei_information5 = 'N'
1719: WHERE assignment_id = qualifying_assignments.assignment_id
1720: AND aei_information3 = 'AS';

Line 1717: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1713: IF l_unused_number = 0 THEN
1714: UPDATE per_assignment_extra_info
1715: SET aei_information4 = l_assignment_status_type_id
1716: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1717: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1718: ,aei_information5 = 'N'
1719: WHERE assignment_id = qualifying_assignments.assignment_id
1720: AND aei_information3 = 'AS';
1721: ELSE

Line 1724: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1720: AND aei_information3 = 'AS';
1721: ELSE
1722: UPDATE per_assignment_extra_info
1723: SET aei_information4 = l_assignment_status_type_id
1724: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1725: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1726: WHERE assignment_id = qualifying_assignments.assignment_id
1727: AND aei_information3 = 'AS';
1728: END IF;

Line 1725: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1721: ELSE
1722: UPDATE per_assignment_extra_info
1723: SET aei_information4 = l_assignment_status_type_id
1724: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1725: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1726: WHERE assignment_id = qualifying_assignments.assignment_id
1727: AND aei_information3 = 'AS';
1728: END IF;
1729: ELSIF qualifying_assignments.action_status = 'MB' THEN

Line 1737: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1733: updated back to N*/
1734: --
1735: UPDATE per_assignment_extra_info
1736: SET aei_information4 = l_assignment_status_type_id
1737: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1738: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1739: ,aei_information5 = 'N'
1740: WHERE assignment_id = qualifying_assignments.assignment_id
1741: AND aei_information3 IN ('TS','AS');

Line 1738: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1734: --
1735: UPDATE per_assignment_extra_info
1736: SET aei_information4 = l_assignment_status_type_id
1737: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1738: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1739: ,aei_information5 = 'N'
1740: WHERE assignment_id = qualifying_assignments.assignment_id
1741: AND aei_information3 IN ('TS','AS');
1742: --

Line 1777: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1773: --
1774: IF l_unused_number = 0 THEN
1775: UPDATE per_assignment_extra_info
1776: SET aei_information4 = l_employment_category
1777: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1778: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1779: ,aei_information5 = 'N'
1780: WHERE assignment_id = qualifying_assignments.assignment_id
1781: AND aei_information3 = 'EC';

Line 1778: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1774: IF l_unused_number = 0 THEN
1775: UPDATE per_assignment_extra_info
1776: SET aei_information4 = l_employment_category
1777: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1778: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1779: ,aei_information5 = 'N'
1780: WHERE assignment_id = qualifying_assignments.assignment_id
1781: AND aei_information3 = 'EC';
1782: ELSE

Line 1785: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1781: AND aei_information3 = 'EC';
1782: ELSE
1783: UPDATE per_assignment_extra_info
1784: SET aei_information4 = l_employment_category
1785: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1786: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1787: WHERE assignment_id = qualifying_assignments.assignment_id
1788: AND aei_information3 = 'EC';
1789: END IF;

Line 1786: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1782: ELSE
1783: UPDATE per_assignment_extra_info
1784: SET aei_information4 = l_employment_category
1785: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1786: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1787: WHERE assignment_id = qualifying_assignments.assignment_id
1788: AND aei_information3 = 'EC';
1789: END IF;
1790: ELSIF qualifying_assignments.action_status = 'MG' THEN

Line 1805: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1801: --
1802: IF l_unused_number = 0 THEN
1803: UPDATE per_assignment_extra_info
1804: SET aei_information4 = l_contribution_group
1805: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1806: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1807: ,aei_information5 = 'N'
1808: WHERE assignment_id = qualifying_assignments.assignment_id
1809: AND aei_information3 = 'CG';

Line 1806: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1802: IF l_unused_number = 0 THEN
1803: UPDATE per_assignment_extra_info
1804: SET aei_information4 = l_contribution_group
1805: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1806: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1807: ,aei_information5 = 'N'
1808: WHERE assignment_id = qualifying_assignments.assignment_id
1809: AND aei_information3 = 'CG';
1810: ELSE

Line 1813: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1809: AND aei_information3 = 'CG';
1810: ELSE
1811: UPDATE per_assignment_extra_info
1812: SET aei_information4 = l_contribution_group
1813: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1814: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1815: WHERE assignment_id = qualifying_assignments.assignment_id
1816: AND aei_information3 = 'CG';
1817: END IF;

Line 1814: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1810: ELSE
1811: UPDATE per_assignment_extra_info
1812: SET aei_information4 = l_contribution_group
1813: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1814: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1815: WHERE assignment_id = qualifying_assignments.assignment_id
1816: AND aei_information3 = 'CG';
1817: END IF;
1818: ELSIF qualifying_assignments.action_status = 'MT' THEN

Line 1844: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1840: --
1841: IF l_unused_number = 0 THEN
1842: UPDATE per_assignment_extra_info
1843: SET aei_information4 = l_epigraph_code
1844: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1845: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1846: ,aei_information5 = 'N'
1847: WHERE assignment_id = qualifying_assignments.assignment_id
1848: AND aei_information3 = 'EP';

Line 1845: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)

1841: IF l_unused_number = 0 THEN
1842: UPDATE per_assignment_extra_info
1843: SET aei_information4 = l_epigraph_code
1844: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1845: ,aei_information7 = fnd_date.date_to_canonical(g_effective_end_date)
1846: ,aei_information5 = 'N'
1847: WHERE assignment_id = qualifying_assignments.assignment_id
1848: AND aei_information3 = 'EP';
1849: ELSE

Line 1852: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)

1848: AND aei_information3 = 'EP';
1849: ELSE
1850: UPDATE per_assignment_extra_info
1851: SET aei_information4 = l_epigraph_code
1852: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1853: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1854: WHERE assignment_id = qualifying_assignments.assignment_id
1855: AND aei_information3 = 'EP';
1856: END IF;

Line 1853: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)

1849: ELSE
1850: UPDATE per_assignment_extra_info
1851: SET aei_information4 = l_epigraph_code
1852: ,aei_information2 = fnd_date.date_to_canonical(g_effective_end_date)
1853: ,aei_information7 = fnd_date.date_to_canonical(l_effective_start_date)
1854: WHERE assignment_id = qualifying_assignments.assignment_id
1855: AND aei_information3 = 'EP';
1856: END IF;
1857: END IF;