APPS.PER_PTU_DFF_MIG dependencies on HR_API

Line 59: and person_id = hr_api.g_number;

55: cursor csr_is_alrady_run_for_bg(p_business_group_id number) IS
56: select ERROR_DESCRIPTION
57: from PER_PTU_DFF_MIG_FAILED_PEOPLE
58: where nvl(business_group_id,-1) = nvl(p_business_group_id,-1)
59: and person_id = hr_api.g_number;
60: --
61: cursor csr_prev_run_all_bgs IS
62: select ERROR_DESCRIPTION
63: from PER_PTU_DFF_MIG_FAILED_PEOPLE

Line 64: where person_id = hr_api.g_number

60: --
61: cursor csr_prev_run_all_bgs IS
62: select ERROR_DESCRIPTION
63: from PER_PTU_DFF_MIG_FAILED_PEOPLE
64: where person_id = hr_api.g_number
65: and business_group_id is null;
66: --
67: BEGIN
68: --

Line 334: AND PERSON_ID = hr_api.g_number)

330: AND ppf.business_group_id not in
331: (select nvl(business_group_id,-1)
332: from PER_PTU_DFF_MIG_FAILED_PEOPLE
333: where ERROR_DESCRIPTION = 'SUCCESS'
334: AND PERSON_ID = hr_api.g_number)
335: AND (PPF.ATTRIBUTE1 IS NOT NULL OR
336: PPF.ATTRIBUTE2 IS NOT NULL OR
337: PPF.ATTRIBUTE3 IS NOT NULL OR
338: PPF.ATTRIBUTE4 IS NOT NULL OR

Line 928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)

924: --
925: IF j <> 0 then
926: --
927: IF l_sub_per_rec.effective_start_date = MIG_TAB_NEW(j).effective_end_date+1 AND
928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)
929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)

Line 929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND

925: IF j <> 0 then
926: --
927: IF l_sub_per_rec.effective_start_date = MIG_TAB_NEW(j).effective_end_date+1 AND
928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)
929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND

Line 930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)

926: --
927: IF l_sub_per_rec.effective_start_date = MIG_TAB_NEW(j).effective_end_date+1 AND
928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)
929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)

Line 931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND

927: IF l_sub_per_rec.effective_start_date = MIG_TAB_NEW(j).effective_end_date+1 AND
928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)
929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND

Line 932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)

928: nvl(MIG_TAB_NEW(j).attribute1,hr_api.g_varchar2)
929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)

Line 933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND

929: = nvl(l_sub_per_rec.attribute1,hr_api.g_varchar2) AND
930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND

Line 934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)

930: nvl(MIG_TAB_NEW(j).attribute2,hr_api.g_varchar2)
931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)

Line 935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND

931: = nvl(l_sub_per_rec.attribute2,hr_api.g_varchar2) AND
932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND

Line 936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)

932: nvl(MIG_TAB_NEW(j).attribute3,hr_api.g_varchar2)
933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)

Line 937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND

933: = nvl(l_sub_per_rec.attribute3,hr_api.g_varchar2) AND
934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND

Line 938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)

934: nvl(MIG_TAB_NEW(j).attribute4,hr_api.g_varchar2)
935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)

Line 939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND

935: = nvl(l_sub_per_rec.attribute4,hr_api.g_varchar2) AND
936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND

Line 940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)

936: nvl(MIG_TAB_NEW(j).attribute5,hr_api.g_varchar2)
937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)

Line 941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND

937: = nvl(l_sub_per_rec.attribute5,hr_api.g_varchar2) AND
938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND

Line 942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)

938: nvl(MIG_TAB_NEW(j).attribute6,hr_api.g_varchar2)
939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)

Line 943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND

939: = nvl(l_sub_per_rec.attribute6,hr_api.g_varchar2) AND
940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND

Line 944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)

940: nvl(MIG_TAB_NEW(j).attribute7,hr_api.g_varchar2)
941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)

Line 945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND

941: = nvl(l_sub_per_rec.attribute7,hr_api.g_varchar2) AND
942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND

Line 946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)

942: nvl(MIG_TAB_NEW(j).attribute8,hr_api.g_varchar2)
943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)

Line 947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND

943: = nvl(l_sub_per_rec.attribute8,hr_api.g_varchar2) AND
944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND

Line 948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)

944: nvl(MIG_TAB_NEW(j).attribute9,hr_api.g_varchar2)
945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)

Line 949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND

945: = nvl(l_sub_per_rec.attribute9,hr_api.g_varchar2) AND
946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND

Line 950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)

946: nvl(MIG_TAB_NEW(j).attribute10,hr_api.g_varchar2)
947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)

Line 951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND

947: = nvl(l_sub_per_rec.attribute10,hr_api.g_varchar2) AND
948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND

Line 952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)

948: nvl(MIG_TAB_NEW(j).attribute11,hr_api.g_varchar2)
949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)

Line 953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND

949: = nvl(l_sub_per_rec.attribute11,hr_api.g_varchar2) AND
950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND

Line 954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)

950: nvl(MIG_TAB_NEW(j).attribute12,hr_api.g_varchar2)
951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)

Line 955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND

951: = nvl(l_sub_per_rec.attribute12,hr_api.g_varchar2) AND
952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND

Line 956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)

952: nvl(MIG_TAB_NEW(j).attribute13,hr_api.g_varchar2)
953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)

Line 957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND

953: = nvl(l_sub_per_rec.attribute13,hr_api.g_varchar2) AND
954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND

Line 958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)

954: nvl(MIG_TAB_NEW(j).attribute14,hr_api.g_varchar2)
955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)

Line 959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND

955: = nvl(l_sub_per_rec.attribute14,hr_api.g_varchar2) AND
956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND

Line 960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)

956: nvl(MIG_TAB_NEW(j).attribute15,hr_api.g_varchar2)
957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)

Line 961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND

957: = nvl(l_sub_per_rec.attribute15,hr_api.g_varchar2) AND
958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND

Line 962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)

958: nvl(MIG_TAB_NEW(j).attribute16,hr_api.g_varchar2)
959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)

Line 963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND

959: = nvl(l_sub_per_rec.attribute16,hr_api.g_varchar2) AND
960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND

Line 964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)

960: nvl(MIG_TAB_NEW(j).attribute17,hr_api.g_varchar2)
961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)

Line 965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND

961: = nvl(l_sub_per_rec.attribute17,hr_api.g_varchar2) AND
962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND

Line 966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)

962: nvl(MIG_TAB_NEW(j).attribute18,hr_api.g_varchar2)
963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)

Line 967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND

963: = nvl(l_sub_per_rec.attribute18,hr_api.g_varchar2) AND
964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND

Line 968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)

964: nvl(MIG_TAB_NEW(j).attribute19,hr_api.g_varchar2)
965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)

Line 969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND

965: = nvl(l_sub_per_rec.attribute19,hr_api.g_varchar2) AND
966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND

Line 970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)

966: nvl(MIG_TAB_NEW(j).attribute20,hr_api.g_varchar2)
967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)

Line 971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND

967: = nvl(l_sub_per_rec.attribute20,hr_api.g_varchar2) AND
968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND

Line 972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)

968: nvl(MIG_TAB_NEW(j).attribute21,hr_api.g_varchar2)
969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)

Line 973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND

969: = nvl(l_sub_per_rec.attribute21,hr_api.g_varchar2) AND
970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND

Line 974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)

970: nvl(MIG_TAB_NEW(j).attribute22,hr_api.g_varchar2)
971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)

Line 975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND

971: = nvl(l_sub_per_rec.attribute22,hr_api.g_varchar2) AND
972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND

Line 976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)

972: nvl(MIG_TAB_NEW(j).attribute23,hr_api.g_varchar2)
973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)

Line 977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND

973: = nvl(l_sub_per_rec.attribute23,hr_api.g_varchar2) AND
974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND

Line 978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)

974: nvl(MIG_TAB_NEW(j).attribute24,hr_api.g_varchar2)
975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)

Line 979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND

975: = nvl(l_sub_per_rec.attribute24,hr_api.g_varchar2) AND
976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND

Line 980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)

976: nvl(MIG_TAB_NEW(j).attribute25,hr_api.g_varchar2)
977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)

Line 981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND

977: = nvl(l_sub_per_rec.attribute25,hr_api.g_varchar2) AND
978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND

Line 982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)

978: nvl(MIG_TAB_NEW(j).attribute26,hr_api.g_varchar2)
979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)

Line 983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND

979: = nvl(l_sub_per_rec.attribute26,hr_api.g_varchar2) AND
980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)
987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN

Line 984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)

980: nvl(MIG_TAB_NEW(j).attribute27,hr_api.g_varchar2)
981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)
987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN
988: --

Line 985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND

981: = nvl(l_sub_per_rec.attribute27,hr_api.g_varchar2) AND
982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)
987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN
988: --
989: -- Both the records are same and continuous. So just move the EED to the EED

Line 986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)

982: nvl(MIG_TAB_NEW(j).attribute28,hr_api.g_varchar2)
983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)
987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN
988: --
989: -- Both the records are same and continuous. So just move the EED to the EED
990: -- of second record.

Line 987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN

983: = nvl(l_sub_per_rec.attribute28,hr_api.g_varchar2) AND
984: nvl(MIG_TAB_NEW(j).attribute29,hr_api.g_varchar2)
985: = nvl(l_sub_per_rec.attribute29,hr_api.g_varchar2) AND
986: nvl(MIG_TAB_NEW(j).attribute30,hr_api.g_varchar2)
987: = nvl(l_sub_per_rec.attribute30,hr_api.g_varchar2) THEN
988: --
989: -- Both the records are same and continuous. So just move the EED to the EED
990: -- of second record.
991: --

Line 1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)

1476: ,p_effective_date => l_effective_date
1477: ,p_datetrack_mode => l_datetrack_mode
1478: ,p_object_version_number => l_object_version_number
1479: ,p_attribute_category => p_mig_rec.attribute_category -- ****
1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)
1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)

Line 1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)

1477: ,p_datetrack_mode => l_datetrack_mode
1478: ,p_object_version_number => l_object_version_number
1479: ,p_attribute_category => p_mig_rec.attribute_category -- ****
1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)
1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)

Line 1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)

1478: ,p_object_version_number => l_object_version_number
1479: ,p_attribute_category => p_mig_rec.attribute_category -- ****
1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)
1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)

Line 1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)

1479: ,p_attribute_category => p_mig_rec.attribute_category -- ****
1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)
1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)

Line 1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)

1480: ,p_attribute1 => nvl(l_ptu_attrs_data_rec.attribute1, hr_api.g_varchar2)
1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)

Line 1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)

1481: ,p_attribute2 => nvl(l_ptu_attrs_data_rec.attribute2, hr_api.g_varchar2)
1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)

Line 1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)

1482: ,p_attribute3 => nvl(l_ptu_attrs_data_rec.attribute3, hr_api.g_varchar2)
1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)

Line 1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)

1483: ,p_attribute4 => nvl(l_ptu_attrs_data_rec.attribute4, hr_api.g_varchar2)
1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)

Line 1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)

1484: ,p_attribute5 => nvl(l_ptu_attrs_data_rec.attribute5, hr_api.g_varchar2)
1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)

Line 1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)

1485: ,p_attribute6 => nvl(l_ptu_attrs_data_rec.attribute6, hr_api.g_varchar2)
1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)

Line 1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)

1486: ,p_attribute7 => nvl(l_ptu_attrs_data_rec.attribute7, hr_api.g_varchar2)
1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)

Line 1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)

1487: ,p_attribute8 => nvl(l_ptu_attrs_data_rec.attribute8, hr_api.g_varchar2)
1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)

Line 1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)

1488: ,p_attribute9 => nvl(l_ptu_attrs_data_rec.attribute9, hr_api.g_varchar2)
1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)

Line 1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)

1489: ,p_attribute10 => nvl(l_ptu_attrs_data_rec.attribute10, hr_api.g_varchar2)
1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)

Line 1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)

1490: ,p_attribute11 => nvl(l_ptu_attrs_data_rec.attribute11, hr_api.g_varchar2)
1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)

Line 1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)

1491: ,p_attribute12 => nvl(l_ptu_attrs_data_rec.attribute12, hr_api.g_varchar2)
1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)

Line 1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)

1492: ,p_attribute13 => nvl(l_ptu_attrs_data_rec.attribute13, hr_api.g_varchar2)
1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)

Line 1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)

1493: ,p_attribute14 => nvl(l_ptu_attrs_data_rec.attribute14, hr_api.g_varchar2)
1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)

Line 1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)

1494: ,p_attribute15 => nvl(l_ptu_attrs_data_rec.attribute15, hr_api.g_varchar2)
1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)

Line 1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)

1495: ,p_attribute16 => nvl(l_ptu_attrs_data_rec.attribute16, hr_api.g_varchar2)
1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)

Line 1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)

1496: ,p_attribute17 => nvl(l_ptu_attrs_data_rec.attribute17, hr_api.g_varchar2)
1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)

Line 1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)

1497: ,p_attribute18 => nvl(l_ptu_attrs_data_rec.attribute18, hr_api.g_varchar2)
1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)

Line 1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)

1498: ,p_attribute19 => nvl(l_ptu_attrs_data_rec.attribute19, hr_api.g_varchar2)
1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)

Line 1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)

1499: ,p_attribute20 => nvl(l_ptu_attrs_data_rec.attribute20, hr_api.g_varchar2)
1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)

Line 1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)

1500: ,p_attribute21 => nvl(l_ptu_attrs_data_rec.attribute21, hr_api.g_varchar2)
1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)

Line 1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)

1501: ,p_attribute22 => nvl(l_ptu_attrs_data_rec.attribute22, hr_api.g_varchar2)
1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)
1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)

Line 1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)

1502: ,p_attribute23 => nvl(l_ptu_attrs_data_rec.attribute23, hr_api.g_varchar2)
1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)
1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)
1510: ,p_effective_start_date => l_effective_start_date

Line 1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)

1503: ,p_attribute24 => nvl(l_ptu_attrs_data_rec.attribute24, hr_api.g_varchar2)
1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)
1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)
1510: ,p_effective_start_date => l_effective_start_date
1511: ,p_effective_end_date => l_effective_end_date

Line 1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)

1504: ,p_attribute25 => nvl(l_ptu_attrs_data_rec.attribute25, hr_api.g_varchar2)
1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)
1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)
1510: ,p_effective_start_date => l_effective_start_date
1511: ,p_effective_end_date => l_effective_end_date
1512: );

Line 1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)

1505: ,p_attribute26 => nvl(l_ptu_attrs_data_rec.attribute26, hr_api.g_varchar2)
1506: ,p_attribute27 => nvl(l_ptu_attrs_data_rec.attribute27, hr_api.g_varchar2)
1507: ,p_attribute28 => nvl(l_ptu_attrs_data_rec.attribute28, hr_api.g_varchar2)
1508: ,p_attribute29 => nvl(l_ptu_attrs_data_rec.attribute29, hr_api.g_varchar2)
1509: ,p_attribute30 => nvl(l_ptu_attrs_data_rec.attribute30, hr_api.g_varchar2)
1510: ,p_effective_start_date => l_effective_start_date
1511: ,p_effective_end_date => l_effective_end_date
1512: );
1513: --

Line 2276: and PERSON_ID <> hr_api.g_number;

2272: select person_id
2273: from PER_PTU_DFF_MIG_FAILED_PEOPLE
2274: where business_group_id = nvl(p_bg_id,business_group_id)
2275: and ERROR_DESCRIPTION <> 'SUCCESS'
2276: and PERSON_ID <> hr_api.g_number;
2277: --
2278: --
2279: BEGIN
2280: --

Line 2288: -- hr_api.g_number and business_group_id as current business_group_id and

2284: -- for a perticular Bg was successful or not.
2285: --
2286: -- Check the table PER_PTU_DFF_MIG_FAILED_PEOPLE for failed people for the given BG.
2287: -- If any person record is found as failed then insert a record with person_id as
2288: -- hr_api.g_number and business_group_id as current business_group_id and
2289: -- error_description as FAILED. If no person record is failed then insert the above
2290: -- record with error_description as SUCCESS. This error_description is used in
2291: -- procedure submit_migration to decide whetehr this request is re-run or a fresh
2292: -- request.

Line 2306: WHERE PERSON_ID = hr_api.g_number

2302: --
2303: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2304: SET ERROR_DESCRIPTION = 'FAILED',
2305: REQUEST_ID = g_request_id
2306: WHERE PERSON_ID = hr_api.g_number
2307: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);
2308: --
2309: IF SQL%rowcount = 0 THEN
2310: --

Line 2322: select hr_api.g_number, l_business_group_id,

2318: CREATION_DATE,
2319: LAST_UPDATED_BY,
2320: LAST_UPDATE_DATE,
2321: LAST_UPDATE_LOGIN)
2322: select hr_api.g_number, l_business_group_id,
2323: g_request_id, 'FAILED',
2324: null,fnd_global.user_id,
2325: sysdate, fnd_global.user_id,sysdate,
2326: fnd_global.login_id

Line 2336: WHERE PERSON_ID = hr_api.g_number

2332: --
2333: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2334: SET ERROR_DESCRIPTION = 'SUCCESS',
2335: REQUEST_ID = g_request_id
2336: WHERE PERSON_ID = hr_api.g_number
2337: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);
2338: --
2339: IF SQL%rowcount = 0 THEN
2340: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE

Line 2351: select hr_api.g_number, l_business_group_id,

2347: CREATION_DATE,
2348: LAST_UPDATED_BY,
2349: LAST_UPDATE_DATE,
2350: LAST_UPDATE_LOGIN)
2351: select hr_api.g_number, l_business_group_id,
2352: g_request_id, 'SUCCESS',
2353: null,fnd_global.user_id,
2354: sysdate, fnd_global.user_id,sysdate,
2355: fnd_global.login_id