632: fnd_number.number_to_canonical(p_organization_id),
633: fnd_number.number_to_canonical(p_job_id),
634: fnd_number.number_to_canonical(p_payroll_id),
635: fnd_number.number_to_canonical(p_location_id),
636: fnd_date.date_to_canonical(p_termination_date),
637: p_leaving_reason,
638: fnd_number.number_to_canonical(p_arch_assignment_action_id_o));
639: --
640: if g_debug then
742: nvl(fnd_number.number_to_canonical(p_location_id),'X'),
743: action_information6,
744: fnd_number.number_to_canonical(p_location_id)),
745: action_information7 = decode(nvl(action_information7,'X'),
746: nvl(fnd_date.date_to_canonical(p_termination_date),'X'),
747: action_information7,
748: fnd_date.date_to_canonical(p_termination_date)),
749: action_information8 = decode(nvl(action_information8,'X'),
750: nvl(p_leaving_reason,'X'),
744: fnd_number.number_to_canonical(p_location_id)),
745: action_information7 = decode(nvl(action_information7,'X'),
746: nvl(fnd_date.date_to_canonical(p_termination_date),'X'),
747: action_information7,
748: fnd_date.date_to_canonical(p_termination_date)),
749: action_information8 = decode(nvl(action_information8,'X'),
750: nvl(p_leaving_reason,'X'),
751: action_information8,
752: p_leaving_reason)
765: <> nvl(fnd_number.number_to_canonical(p_payroll_id),'X')
766: or nvl(action_information6,'X')
767: <> nvl(fnd_number.number_to_canonical(p_location_id),'X')
768: or nvl(action_information7,'X')
769: <> nvl(fnd_date.date_to_canonical(p_termination_date),'X')
770: or nvl(action_information8,'X')
771: <> nvl(p_leaving_reason,'X'));
772: --
773: end if;
910: p_first_name,
911: p_last_name_kana,
912: p_first_name_kana,
913: p_sex,
914: fnd_date.date_to_canonical(p_birth_date));
915: --
916: if g_debug then
917: hr_utility.set_location(l_proc,1000);
918: end if;
1010: nvl(p_sex,'X'),
1011: action_information7,
1012: p_sex),
1013: action_information8 = decode(nvl(action_information8,'X'),
1014: nvl(fnd_date.date_to_canonical(p_birth_date),'X'),
1015: action_information8,
1016: fnd_date.date_to_canonical(p_birth_date))
1017: where action_information_id = p_action_information_id
1018: and object_version_number < p_object_version_number
1012: p_sex),
1013: action_information8 = decode(nvl(action_information8,'X'),
1014: nvl(fnd_date.date_to_canonical(p_birth_date),'X'),
1015: action_information8,
1016: fnd_date.date_to_canonical(p_birth_date))
1017: where action_information_id = p_action_information_id
1018: and object_version_number < p_object_version_number
1019: and action_context_id = p_assignment_action_id
1020: and action_context_type = 'AAP'
1033: <> nvl(p_first_name_kana,'X')
1034: or nvl(action_information7,'X')
1035: <> nvl(p_sex,'X')
1036: or nvl(action_information8,'X')
1037: <> nvl(fnd_date.date_to_canonical(p_birth_date),'X'));
1038: --
1039: end if;
1040: --
1041: end if;
1307: p_action_context_type,
1308: p_effective_date,
1309: p_assignment_id,
1310: p_action_information_category,
1311: fnd_date.date_to_canonical(p_hire_date),
1312: p_organization_name,
1313: p_job_name,
1314: p_payroll_name,
1315: p_location_name);
1380: --
1381: update pay_action_information
1382: set object_version_number = p_object_version_number,
1383: action_information1 = decode(nvl(action_information1,'X'),
1384: nvl(fnd_date.date_to_canonical(p_hire_date),'X'),
1385: action_information1,
1386: fnd_date.date_to_canonical(p_hire_date)),
1387: action_information2 = decode(nvl(action_information2,'X'),
1388: nvl(p_organization_name,'X'),
1382: set object_version_number = p_object_version_number,
1383: action_information1 = decode(nvl(action_information1,'X'),
1384: nvl(fnd_date.date_to_canonical(p_hire_date),'X'),
1385: action_information1,
1386: fnd_date.date_to_canonical(p_hire_date)),
1387: action_information2 = decode(nvl(action_information2,'X'),
1388: nvl(p_organization_name,'X'),
1389: action_information2,
1390: p_organization_name),
1405: and action_context_id = p_assignment_action_id
1406: and action_context_type = 'AAP'
1407: and action_information_category = 'JP_ITWB_EMP_ASS'
1408: and (nvl(action_information1,'X')
1409: <> nvl(fnd_date.date_to_canonical(p_hire_date),'X')
1410: or nvl(action_information2,'X')
1411: <> nvl(p_organization_name,'X')
1412: or nvl(action_information3,'X')
1413: <> nvl(p_job_name,'X')
1499: p_wpf_number,
1500: fnd_number.number_to_canonical(p_ei_org_id),
1501: p_ei_number,
1502: p_nres_flag,
1503: fnd_date.date_to_canonical(p_nres_start_date),
1504: fnd_date.date_to_canonical(p_projected_res_date));
1505: --
1506: if g_debug then
1507: hr_utility.set_location(l_proc,1000);
1500: fnd_number.number_to_canonical(p_ei_org_id),
1501: p_ei_number,
1502: p_nres_flag,
1503: fnd_date.date_to_canonical(p_nres_start_date),
1504: fnd_date.date_to_canonical(p_projected_res_date));
1505: --
1506: if g_debug then
1507: hr_utility.set_location(l_proc,1000);
1508: end if;
1621: nvl(p_nres_flag,'X'),
1622: action_information11,
1623: p_nres_flag),
1624: action_information12 = decode(nvl(action_information12,'X'),
1625: nvl(fnd_date.date_to_canonical(p_nres_start_date),'X'),
1626: action_information12,
1627: fnd_date.date_to_canonical(p_nres_start_date)),
1628: action_information13 = decode(nvl(action_information13,'X'),
1629: nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'),
1623: p_nres_flag),
1624: action_information12 = decode(nvl(action_information12,'X'),
1625: nvl(fnd_date.date_to_canonical(p_nres_start_date),'X'),
1626: action_information12,
1627: fnd_date.date_to_canonical(p_nres_start_date)),
1628: action_information13 = decode(nvl(action_information13,'X'),
1629: nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'),
1630: action_information13,
1631: fnd_date.date_to_canonical(p_projected_res_date))
1625: nvl(fnd_date.date_to_canonical(p_nres_start_date),'X'),
1626: action_information12,
1627: fnd_date.date_to_canonical(p_nres_start_date)),
1628: action_information13 = decode(nvl(action_information13,'X'),
1629: nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'),
1630: action_information13,
1631: fnd_date.date_to_canonical(p_projected_res_date))
1632: where action_information_id = p_action_information_id
1633: and object_version_number < p_object_version_number
1627: fnd_date.date_to_canonical(p_nres_start_date)),
1628: action_information13 = decode(nvl(action_information13,'X'),
1629: nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'),
1630: action_information13,
1631: fnd_date.date_to_canonical(p_projected_res_date))
1632: where action_information_id = p_action_information_id
1633: and object_version_number < p_object_version_number
1634: and action_context_id = p_assignment_action_id
1635: and action_context_type = 'AAP'
1656: <> nvl(p_ei_number,'X')
1657: or nvl(action_information11,'X')
1658: <> nvl(p_nres_flag,'X')
1659: or nvl(action_information12,'X')
1660: <> nvl(fnd_date.date_to_canonical(p_nres_start_date),'X')
1661: or nvl(action_information13,'X')
1662: <> nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'));
1663: --
1664: end if;
1658: <> nvl(p_nres_flag,'X')
1659: or nvl(action_information12,'X')
1660: <> nvl(fnd_date.date_to_canonical(p_nres_start_date),'X')
1661: or nvl(action_information13,'X')
1662: <> nvl(fnd_date.date_to_canonical(p_projected_res_date),'X'));
1663: --
1664: end if;
1665: --
1666: end if;
6390: p_action_context_type,
6391: p_effective_date,
6392: p_assignment_id,
6393: p_action_information_category,
6394: fnd_date.date_to_canonical(p_term_date),
6395: p_employer_name,
6396: p_employer_name_kana,
6397: p_employer_address,
6398: p_employer_address_kana,
6876: p_effective_date,
6877: p_assignment_id,
6878: p_action_information_category,
6879: fnd_number.number_to_canonical(p_act),
6880: fnd_date.date_to_canonical(p_efd),
6881: fnd_date.date_to_canonical(p_erd),
6882: fnd_number.number_to_canonical(p_pay),
6883: p_yea_type,
6884: p_yea_flag);
6877: p_assignment_id,
6878: p_action_information_category,
6879: fnd_number.number_to_canonical(p_act),
6880: fnd_date.date_to_canonical(p_efd),
6881: fnd_date.date_to_canonical(p_erd),
6882: fnd_number.number_to_canonical(p_pay),
6883: p_yea_type,
6884: p_yea_flag);
6885: --
6955: nvl(fnd_number.number_to_canonical(p_act),'X'),
6956: action_information1,
6957: fnd_number.number_to_canonical(p_act)),
6958: action_information2 = decode(nvl(action_information2,'X'),
6959: nvl(fnd_date.date_to_canonical(p_efd),'X'),
6960: action_information2,
6961: fnd_date.date_to_canonical(p_efd)),
6962: action_information3 = decode(nvl(action_information3,'X'),
6963: nvl(fnd_date.date_to_canonical(p_erd),'X'),
6957: fnd_number.number_to_canonical(p_act)),
6958: action_information2 = decode(nvl(action_information2,'X'),
6959: nvl(fnd_date.date_to_canonical(p_efd),'X'),
6960: action_information2,
6961: fnd_date.date_to_canonical(p_efd)),
6962: action_information3 = decode(nvl(action_information3,'X'),
6963: nvl(fnd_date.date_to_canonical(p_erd),'X'),
6964: action_information3,
6965: fnd_date.date_to_canonical(p_erd)),
6959: nvl(fnd_date.date_to_canonical(p_efd),'X'),
6960: action_information2,
6961: fnd_date.date_to_canonical(p_efd)),
6962: action_information3 = decode(nvl(action_information3,'X'),
6963: nvl(fnd_date.date_to_canonical(p_erd),'X'),
6964: action_information3,
6965: fnd_date.date_to_canonical(p_erd)),
6966: action_information4 = decode(nvl(action_information4,'X'),
6967: nvl(fnd_number.number_to_canonical(p_pay),'X'),
6961: fnd_date.date_to_canonical(p_efd)),
6962: action_information3 = decode(nvl(action_information3,'X'),
6963: nvl(fnd_date.date_to_canonical(p_erd),'X'),
6964: action_information3,
6965: fnd_date.date_to_canonical(p_erd)),
6966: action_information4 = decode(nvl(action_information4,'X'),
6967: nvl(fnd_number.number_to_canonical(p_pay),'X'),
6968: action_information4,
6969: fnd_number.number_to_canonical(p_pay)),
6982: and action_information_category = 'JP_ITWB_YEA_ACT'
6983: and (nvl(action_information1,'X')
6984: <> nvl(fnd_number.number_to_canonical(p_act),'X')
6985: or nvl(action_information2,'X')
6986: <> nvl(fnd_date.date_to_canonical(p_efd),'X')
6987: or nvl(action_information3,'X')
6988: <> nvl(fnd_date.date_to_canonical(p_erd),'X')
6989: or nvl(action_information4,'X')
6990: <> nvl(fnd_number.number_to_canonical(p_pay),'X')
6984: <> nvl(fnd_number.number_to_canonical(p_act),'X')
6985: or nvl(action_information2,'X')
6986: <> nvl(fnd_date.date_to_canonical(p_efd),'X')
6987: or nvl(action_information3,'X')
6988: <> nvl(fnd_date.date_to_canonical(p_erd),'X')
6989: or nvl(action_information4,'X')
6990: <> nvl(fnd_number.number_to_canonical(p_pay),'X')
6991: or nvl(action_information5,'X')
6992: <> nvl(p_yea_type,'X')
7064: set object_version_number = p_object_version_number,
7065: action_information1 = decode(nvl(fnd_number.number_to_canonical(p_act),'X'),
7066: 'X',action_information1,
7067: fnd_number.number_to_canonical(p_act)),
7068: action_information2 = decode(nvl(fnd_date.date_to_canonical(p_efd),'X'),
7069: 'X',action_information2,
7070: fnd_date.date_to_canonical(p_efd)),
7071: action_information3 = decode(nvl(fnd_date.date_to_canonical(p_erd),'X'),
7072: 'X',action_information3,
7066: 'X',action_information1,
7067: fnd_number.number_to_canonical(p_act)),
7068: action_information2 = decode(nvl(fnd_date.date_to_canonical(p_efd),'X'),
7069: 'X',action_information2,
7070: fnd_date.date_to_canonical(p_efd)),
7071: action_information3 = decode(nvl(fnd_date.date_to_canonical(p_erd),'X'),
7072: 'X',action_information3,
7073: fnd_date.date_to_canonical(p_erd)),
7074: action_information4 = decode(nvl(fnd_number.number_to_canonical(p_pay),'X'),
7067: fnd_number.number_to_canonical(p_act)),
7068: action_information2 = decode(nvl(fnd_date.date_to_canonical(p_efd),'X'),
7069: 'X',action_information2,
7070: fnd_date.date_to_canonical(p_efd)),
7071: action_information3 = decode(nvl(fnd_date.date_to_canonical(p_erd),'X'),
7072: 'X',action_information3,
7073: fnd_date.date_to_canonical(p_erd)),
7074: action_information4 = decode(nvl(fnd_number.number_to_canonical(p_pay),'X'),
7075: 'X',action_information4,
7069: 'X',action_information2,
7070: fnd_date.date_to_canonical(p_efd)),
7071: action_information3 = decode(nvl(fnd_date.date_to_canonical(p_erd),'X'),
7072: 'X',action_information3,
7073: fnd_date.date_to_canonical(p_erd)),
7074: action_information4 = decode(nvl(fnd_number.number_to_canonical(p_pay),'X'),
7075: 'X',action_information4,
7076: fnd_number.number_to_canonical(p_pay)),
7077: action_information5 = decode(nvl(p_yea_type,'X'),
8775: p_assignment_id => p_assignment_id,
8776: p_effective_date => p_effective_date,
8777: p_action_information_category => p_action_information_category,
8778: p_data_type => p_data_type,
8779: p_information1 => fnd_date.date_to_canonical(p_information1),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8776: p_effective_date => p_effective_date,
8777: p_action_information_category => p_action_information_category,
8778: p_data_type => p_data_type,
8779: p_information1 => fnd_date.date_to_canonical(p_information1),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8777: p_action_information_category => p_action_information_category,
8778: p_data_type => p_data_type,
8779: p_information1 => fnd_date.date_to_canonical(p_information1),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8778: p_data_type => p_data_type,
8779: p_information1 => fnd_date.date_to_canonical(p_information1),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8779: p_information1 => fnd_date.date_to_canonical(p_information1),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8780: p_information2 => fnd_date.date_to_canonical(p_information2),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8781: p_information3 => fnd_date.date_to_canonical(p_information3),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8782: p_information4 => fnd_date.date_to_canonical(p_information4),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8783: p_information5 => fnd_date.date_to_canonical(p_information5),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8784: p_information6 => fnd_date.date_to_canonical(p_information6),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8785: p_information7 => fnd_date.date_to_canonical(p_information7),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8786: p_information8 => fnd_date.date_to_canonical(p_information8),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8787: p_information9 => fnd_date.date_to_canonical(p_information9),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8788: p_information10 => fnd_date.date_to_canonical(p_information10),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8789: p_information11 => fnd_date.date_to_canonical(p_information11),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8790: p_information12 => fnd_date.date_to_canonical(p_information12),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8791: p_information13 => fnd_date.date_to_canonical(p_information13),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8792: p_information14 => fnd_date.date_to_canonical(p_information14),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8793: p_information15 => fnd_date.date_to_canonical(p_information15),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8794: p_information16 => fnd_date.date_to_canonical(p_information16),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8795: p_information17 => fnd_date.date_to_canonical(p_information17),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8796: p_information18 => fnd_date.date_to_canonical(p_information18),
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8804: p_object_version_number => p_object_version_number);
8797: p_information19 => fnd_date.date_to_canonical(p_information19),
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8804: p_object_version_number => p_object_version_number);
8805: --
8798: p_information20 => fnd_date.date_to_canonical(p_information20),
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8804: p_object_version_number => p_object_version_number);
8805: --
8806: if g_debug then
8799: p_information21 => fnd_date.date_to_canonical(p_information21),
8800: p_information22 => fnd_date.date_to_canonical(p_information22),
8801: p_information23 => fnd_date.date_to_canonical(p_information23),
8802: p_information24 => fnd_date.date_to_canonical(p_information24),
8803: p_information25 => fnd_date.date_to_canonical(p_information25),
8804: p_object_version_number => p_object_version_number);
8805: --
8806: if g_debug then
8807: hr_utility.set_location(l_proc,1000);
8946: p_assignment_id => p_assignment_id,
8947: p_effective_date => p_effective_date,
8948: p_arch_assignment_action_id_o => p_arch_assignment_action_id_o,
8949: p_data_type => p_data_type,
8950: p_information1 => fnd_date.date_to_canonical(p_information1),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8947: p_effective_date => p_effective_date,
8948: p_arch_assignment_action_id_o => p_arch_assignment_action_id_o,
8949: p_data_type => p_data_type,
8950: p_information1 => fnd_date.date_to_canonical(p_information1),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8948: p_arch_assignment_action_id_o => p_arch_assignment_action_id_o,
8949: p_data_type => p_data_type,
8950: p_information1 => fnd_date.date_to_canonical(p_information1),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8949: p_data_type => p_data_type,
8950: p_information1 => fnd_date.date_to_canonical(p_information1),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8950: p_information1 => fnd_date.date_to_canonical(p_information1),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8951: p_information2 => fnd_date.date_to_canonical(p_information2),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8952: p_information3 => fnd_date.date_to_canonical(p_information3),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8953: p_information4 => fnd_date.date_to_canonical(p_information4),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8954: p_information5 => fnd_date.date_to_canonical(p_information5),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8955: p_information6 => fnd_date.date_to_canonical(p_information6),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8956: p_information7 => fnd_date.date_to_canonical(p_information7),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8957: p_information8 => fnd_date.date_to_canonical(p_information8),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8958: p_information9 => fnd_date.date_to_canonical(p_information9),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8959: p_information10 => fnd_date.date_to_canonical(p_information10),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8960: p_information11 => fnd_date.date_to_canonical(p_information11),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8961: p_information12 => fnd_date.date_to_canonical(p_information12),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8962: p_information13 => fnd_date.date_to_canonical(p_information13),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8963: p_information14 => fnd_date.date_to_canonical(p_information14),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8964: p_information15 => fnd_date.date_to_canonical(p_information15),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8965: p_information16 => fnd_date.date_to_canonical(p_information16),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8966: p_information17 => fnd_date.date_to_canonical(p_information17),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8974: p_information25 => fnd_date.date_to_canonical(p_information25),
8967: p_information18 => fnd_date.date_to_canonical(p_information18),
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8974: p_information25 => fnd_date.date_to_canonical(p_information25),
8975: p_action_information_id => p_action_information_id,
8968: p_information19 => fnd_date.date_to_canonical(p_information19),
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8974: p_information25 => fnd_date.date_to_canonical(p_information25),
8975: p_action_information_id => p_action_information_id,
8976: p_object_version_number => p_object_version_number);
8969: p_information20 => fnd_date.date_to_canonical(p_information20),
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8974: p_information25 => fnd_date.date_to_canonical(p_information25),
8975: p_action_information_id => p_action_information_id,
8976: p_object_version_number => p_object_version_number);
8977: --
8970: p_information21 => fnd_date.date_to_canonical(p_information21),
8971: p_information22 => fnd_date.date_to_canonical(p_information22),
8972: p_information23 => fnd_date.date_to_canonical(p_information23),
8973: p_information24 => fnd_date.date_to_canonical(p_information24),
8974: p_information25 => fnd_date.date_to_canonical(p_information25),
8975: p_action_information_id => p_action_information_id,
8976: p_object_version_number => p_object_version_number);
8977: --
8978: if g_debug then