[Home] [Help]
121: hr_utility.set_location('Leaving:'|| l_proc, 30);
122: end if;
123:
124: Exception
125: When HR_Api.Object_Locked then
126: --
127: -- This autonomous transaction was unable to lock the row.
128: -- It can be assumed that another transaction has locked the
129: -- row and is performing the update. Hence the error can
205: l_asg_end_date date;
206: l_cost_warning boolean;
207: l_assignment_status_id number;
208: l_date_recieved date;
209: l_eot date := hr_api.g_eot;
210: l_ass_status varchar2(20);
211: l_dummy varchar2(10);
212: l_asg_status_id number;
213: l_object_version_number number;
623: hr_utility.set_location('Leaving:'|| l_proc, 30);
624: end if;
625:
626: Exception
627: When HR_Api.Object_Locked then
628: --
629: -- This autonomous transaction was unable to lock the row.
630: -- It can be assumed that another transaction has locked the
631: -- row and is performing the update. Hence the error can
926:
927: -- Start of Fix for Bug 2643451
928: -- Start of Fix for Bug 2548555
929: --
930: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
927: -- Start of Fix for Bug 2643451
928: -- Start of Fix for Bug 2548555
929: --
930: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
928: -- Start of Fix for Bug 2548555
929: --
930: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
929: --
930: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
930: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
931: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
932: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
933: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
934: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
935: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
936: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
937: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
938: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
939: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
940: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
941: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
942: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
943: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
944: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
945: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
946: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
947: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
948: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
949: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
950: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
951: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
952: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
960: -- bug 944911
953: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
960: -- bug 944911
961: -- changed p_concatenated_segments to p_concat_segments
954: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
960: -- bug 944911
961: -- changed p_concatenated_segments to p_concat_segments
962: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
955: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
956: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
957: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
960: -- bug 944911
961: -- changed p_concatenated_segments to p_concat_segments
962: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
963: --
958: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
959: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
960: -- bug 944911
961: -- changed p_concatenated_segments to p_concat_segments
962: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
963: --
964: -- End of Fix for Bug 2548555
965: -- End of Fix for Bug 2643451
966: --
1073: );
1074: --
1075: end if; -- csr_scl_idsel%NOTFOUND
1076: --
1077: end if; -- l_scl_segment1 <> hr_api.g_varchar2
1078: --
1079: end if; -- l_soft_coding_key_flex_id is null
1080:
1081: --
1081: --
1082: -- When in validation only mode raise the Validate_Enabled exception
1083: --
1084: if p_validate then
1085: raise hr_api.validate_enabled;
1086: end if;
1087:
1088: --
1089: -- Setting Output Variables
1092: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1093:
1094:
1095: EXCEPTION
1096: when hr_api.validate_enabled then
1097: ROLLBACK TO validate_SCL;
1098:
1099: p_concatenated_segments := l_old_conc_segments;
1100:
1292: ,p_object_version_number => p_object_version_number
1293: ,p_assignment_status_type_id => p_assignment_status_type_id
1294: );
1295: exception
1296: when hr_api.cannot_find_prog_unit then
1297: hr_api.cannot_find_prog_unit_error
1298: (p_module_name => 'ACTIVATE_EMP_ASG',
1299: p_hook_type => 'BP'
1300: );
1293: ,p_assignment_status_type_id => p_assignment_status_type_id
1294: );
1295: exception
1296: when hr_api.cannot_find_prog_unit then
1297: hr_api.cannot_find_prog_unit_error
1298: (p_module_name => 'ACTIVATE_EMP_ASG',
1299: p_hook_type => 'BP'
1300: );
1301: end;
1331: ,p_effective_start_date => l_effective_start_date
1332: ,p_effective_end_date => l_effective_end_date
1333: );
1334: exception
1335: when hr_api.cannot_find_prog_unit then
1336: hr_api.cannot_find_prog_unit_error
1337: (p_module_name => 'ACTIVATE_EMP_ASG',
1338: p_hook_type => 'AP'
1339: );
1332: ,p_effective_end_date => l_effective_end_date
1333: );
1334: exception
1335: when hr_api.cannot_find_prog_unit then
1336: hr_api.cannot_find_prog_unit_error
1337: (p_module_name => 'ACTIVATE_EMP_ASG',
1338: p_hook_type => 'AP'
1339: );
1340: end;
1344: --
1345: -- When in validation only mode raise the Validate_Enabled exception
1346: --
1347: if p_validate then
1348: raise hr_api.validate_enabled;
1349: end if;
1350: --
1351: -- Set all output arguments
1352: --
1357: if g_debug then
1358: hr_utility.set_location(' Leaving:'||l_proc, 100);
1359: end if;
1360: exception
1361: when hr_api.validate_enabled then
1362: --
1363: -- As the Validate_Enabled exception has been raised
1364: -- we must rollback to the savepoint
1365: --
1460: ,p_object_version_number => p_object_version_number
1461: ,p_assignment_status_type_id => p_assignment_status_type_id
1462: );
1463: exception
1464: when hr_api.cannot_find_prog_unit then
1465: hr_api.cannot_find_prog_unit_error
1466: (p_module_name => 'ACTIVATE_CWK_ASG',
1467: p_hook_type => 'BP'
1468: );
1461: ,p_assignment_status_type_id => p_assignment_status_type_id
1462: );
1463: exception
1464: when hr_api.cannot_find_prog_unit then
1465: hr_api.cannot_find_prog_unit_error
1466: (p_module_name => 'ACTIVATE_CWK_ASG',
1467: p_hook_type => 'BP'
1468: );
1469: end;
1499: ,p_effective_start_date => l_effective_start_date
1500: ,p_effective_end_date => l_effective_end_date
1501: );
1502: exception
1503: when hr_api.cannot_find_prog_unit then
1504: hr_api.cannot_find_prog_unit_error
1505: (p_module_name => 'ACTIVATE_CWK_ASG',
1506: p_hook_type => 'AP'
1507: );
1500: ,p_effective_end_date => l_effective_end_date
1501: );
1502: exception
1503: when hr_api.cannot_find_prog_unit then
1504: hr_api.cannot_find_prog_unit_error
1505: (p_module_name => 'ACTIVATE_CWK_ASG',
1506: p_hook_type => 'AP'
1507: );
1508: end;
1512: --
1513: -- When in validation only mode raise the Validate_Enabled exception
1514: --
1515: if p_validate then
1516: raise hr_api.validate_enabled;
1517: end if;
1518: --
1519: -- Set all output arguments
1520: --
1525: if g_debug then
1526: hr_utility.set_location(' Leaving:'||l_proc, 100);
1527: end if;
1528: exception
1529: when hr_api.validate_enabled then
1530: --
1531: -- As the Validate_Enabled exception has been raised
1532: -- we must rollback to the savepoint
1533: --
1653: -- Validation in addition to Table Handlers
1654: --
1655: -- Get assignment and business group details for validation.
1656: --
1657: hr_api.mandatory_arg_error
1658: (p_api_name => l_proc
1659: ,p_argument => 'assignment_id'
1660: ,p_argument_value => p_assignment_id
1661: );
1659: ,p_argument => 'assignment_id'
1660: ,p_argument_value => p_assignment_id
1661: );
1662: --
1663: hr_api.mandatory_arg_error
1664: (p_api_name => l_proc
1665: ,p_argument => 'actual_termination_date'
1666: ,p_argument_value => l_actual_termination_date
1667: );
1703: ,p_assignment_status_type_id => p_assignment_status_type_id
1704: ,p_business_group_id => l_asg_business_group_id
1705: );
1706: exception
1707: when hr_api.cannot_find_prog_unit then
1708: hr_api.cannot_find_prog_unit_error
1709: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
1710: p_hook_type => 'BP'
1711: );
1704: ,p_business_group_id => l_asg_business_group_id
1705: );
1706: exception
1707: when hr_api.cannot_find_prog_unit then
1708: hr_api.cannot_find_prog_unit_error
1709: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
1710: p_hook_type => 'BP'
1711: );
1712: end;
1905: ,p_pay_proposal_warning => l_pay_proposal_warning
1906: ,p_business_group_id => l_asg_business_group_id
1907: );
1908: exception
1909: when hr_api.cannot_find_prog_unit then
1910: hr_api.cannot_find_prog_unit_error
1911: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
1912: p_hook_type => 'AP'
1913: );
1906: ,p_business_group_id => l_asg_business_group_id
1907: );
1908: exception
1909: when hr_api.cannot_find_prog_unit then
1910: hr_api.cannot_find_prog_unit_error
1911: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
1912: p_hook_type => 'AP'
1913: );
1914: end;
1915: --
1916: -- End of API User Hook for the after hook of actual_termination_cwk_asg.
1917: --
1918: if p_validate then
1919: raise hr_api.validate_enabled;
1920: end if;
1921: --
1922: -- Set all output arguments
1923: --
1931: if g_debug then
1932: hr_utility.set_location(' Leaving:'||l_proc, 200);
1933: end if;
1934: exception
1935: when hr_api.validate_enabled then
1936: --
1937: -- As the Validate_Enabled exception has been raised
1938: -- we must rollback to the savepoint
1939: --
2054: -- Validation in addition to Table Handlers
2055: --
2056: -- Get assignment and business group details for validation.
2057: --
2058: hr_api.mandatory_arg_error
2059: (p_api_name => l_proc
2060: ,p_argument => 'assignment_id'
2061: ,p_argument_value => p_assignment_id
2062: );
2060: ,p_argument => 'assignment_id'
2061: ,p_argument_value => p_assignment_id
2062: );
2063: --
2064: hr_api.mandatory_arg_error
2065: (p_api_name => l_proc
2066: ,p_argument => 'final_process_date'
2067: ,p_argument_value => l_final_process_date
2068: );
2099: ,p_object_version_number => p_object_version_number
2100: ,p_final_process_date => l_final_process_date
2101: );
2102: exception
2103: when hr_api.cannot_find_prog_unit then
2104: hr_api.cannot_find_prog_unit_error
2105: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2106: p_hook_type => 'BP'
2107: );
2100: ,p_final_process_date => l_final_process_date
2101: );
2102: exception
2103: when hr_api.cannot_find_prog_unit then
2104: hr_api.cannot_find_prog_unit_error
2105: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2106: p_hook_type => 'BP'
2107: );
2108: end;
2150: into l_max_asg_end_date;
2151: close csr_invalid_term_assign;
2152:
2153: --
2154: if l_max_asg_end_date <> hr_api.g_eot
2155: then
2156: --
2157: if g_debug then
2158: hr_utility.set_location(l_proc, 90);
2239: ,p_asg_future_changes_warning => l_asg_future_changes_warning
2240: ,p_entries_changed_warning => l_entries_changed_warning
2241: );
2242: exception
2243: when hr_api.cannot_find_prog_unit then
2244: hr_api.cannot_find_prog_unit_error
2245: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2246: p_hook_type => 'AP'
2247: );
2240: ,p_entries_changed_warning => l_entries_changed_warning
2241: );
2242: exception
2243: when hr_api.cannot_find_prog_unit then
2244: hr_api.cannot_find_prog_unit_error
2245: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2246: p_hook_type => 'AP'
2247: );
2248: end;
2252: --
2253: -- When in validation only mode raise the Validate_Enabled exception
2254: --
2255: if p_validate then
2256: raise hr_api.validate_enabled;
2257: end if;
2258: --
2259: -- Set all output arguments
2260: --
2268: if g_debug then
2269: hr_utility.set_location(' Leaving:'||l_proc, 300);
2270: end if;
2271: exception
2272: when hr_api.validate_enabled then
2273: --
2274: -- As the Validate_Enabled exception has been raised
2275: -- we must rollback to the savepoint
2276: --
2373: ,p_object_version_number => p_object_version_number
2374: ,p_assignment_status_type_id => p_assignment_status_type_id
2375: );
2376: exception
2377: when hr_api.cannot_find_prog_unit then
2378: hr_api.cannot_find_prog_unit_error
2379: (p_module_name => 'SUSPEND_CWK_ASG',
2380: p_hook_type => 'BP'
2381: );
2374: ,p_assignment_status_type_id => p_assignment_status_type_id
2375: );
2376: exception
2377: when hr_api.cannot_find_prog_unit then
2378: hr_api.cannot_find_prog_unit_error
2379: (p_module_name => 'SUSPEND_CWK_ASG',
2380: p_hook_type => 'BP'
2381: );
2382: end;
2413: ,p_effective_start_date => l_effective_start_date
2414: ,p_effective_end_date => l_effective_end_date
2415: );
2416: exception
2417: when hr_api.cannot_find_prog_unit then
2418: hr_api.cannot_find_prog_unit_error
2419: (p_module_name => 'SUSPEND_CWK_ASG',
2420: p_hook_type => 'AP'
2421: );
2414: ,p_effective_end_date => l_effective_end_date
2415: );
2416: exception
2417: when hr_api.cannot_find_prog_unit then
2418: hr_api.cannot_find_prog_unit_error
2419: (p_module_name => 'SUSPEND_CWK_ASG',
2420: p_hook_type => 'AP'
2421: );
2422: end;
2426: --
2427: -- When in validation only mode raise the Validate_Enabled exception
2428: --
2429: if p_validate then
2430: raise hr_api.validate_enabled;
2431: end if;
2432: --
2433: -- Set all output arguments
2434: --
2439: if g_debug then
2440: hr_utility.set_location(' Leaving:'||l_proc, 100);
2441: end if;
2442: exception
2443: when hr_api.validate_enabled then
2444: --
2445: -- As the Validate_Enabled exception has been raised
2446: -- we must rollback to the savepoint
2447: --
2563: -- Validation in addition to Table Handlers
2564: --
2565: -- Get assignment and business group details for validation.
2566: --
2567: hr_api.mandatory_arg_error
2568: (p_api_name => l_proc
2569: ,p_argument => 'assignment_id'
2570: ,p_argument_value => p_assignment_id
2571: );
2569: ,p_argument => 'assignment_id'
2570: ,p_argument_value => p_assignment_id
2571: );
2572: --
2573: hr_api.mandatory_arg_error
2574: (p_api_name => l_proc
2575: ,p_argument => 'actual_termination_date'
2576: ,p_argument_value => l_actual_termination_date
2577: );
2613: ,p_assignment_status_type_id => p_assignment_status_type_id
2614: ,p_business_group_id => l_asg_business_group_id
2615: );
2616: exception
2617: when hr_api.cannot_find_prog_unit then
2618: hr_api.cannot_find_prog_unit_error
2619: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
2620: p_hook_type => 'BP'
2621: );
2614: ,p_business_group_id => l_asg_business_group_id
2615: );
2616: exception
2617: when hr_api.cannot_find_prog_unit then
2618: hr_api.cannot_find_prog_unit_error
2619: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
2620: p_hook_type => 'BP'
2621: );
2622: end;
2814: ,p_pay_proposal_warning => l_pay_proposal_warning
2815: ,p_business_group_id => l_asg_business_group_id
2816: );
2817: exception
2818: when hr_api.cannot_find_prog_unit then
2819: hr_api.cannot_find_prog_unit_error
2820: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
2821: p_hook_type => 'AP'
2822: );
2815: ,p_business_group_id => l_asg_business_group_id
2816: );
2817: exception
2818: when hr_api.cannot_find_prog_unit then
2819: hr_api.cannot_find_prog_unit_error
2820: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
2821: p_hook_type => 'AP'
2822: );
2823: end;
2824: --
2825: -- End of API User Hook for the after hook of actual_termination_emp_asg.
2826: --
2827: if p_validate then
2828: raise hr_api.validate_enabled;
2829: end if;
2830: --
2831: -- Set all output arguments
2832: --
2840: if g_debug then
2841: hr_utility.set_location(' Leaving:'||l_proc, 200);
2842: end if;
2843: exception
2844: when hr_api.validate_enabled then
2845: --
2846: -- As the Validate_Enabled exception has been raised
2847: -- we must rollback to the savepoint
2848: --
4989: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
4990: ,p_supervisor_assignment_id => p_supervisor_assignment_id
4991: );
4992: exception
4993: when hr_api.cannot_find_prog_unit then
4994: hr_api.cannot_find_prog_unit_error
4995: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
4996: ,p_hook_type => 'BP'
4997: );
4990: ,p_supervisor_assignment_id => p_supervisor_assignment_id
4991: );
4992: exception
4993: when hr_api.cannot_find_prog_unit then
4994: hr_api.cannot_find_prog_unit_error
4995: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
4996: ,p_hook_type => 'BP'
4997: );
4998: --
5007: -- Validation in addition to Table Handlers
5008: --
5009: -- Get person details.
5010: --
5011: hr_api.mandatory_arg_error
5012: (p_api_name => l_proc
5013: ,p_argument => 'person_id'
5014: ,p_argument_value => p_person_id
5015: );
5013: ,p_argument => 'person_id'
5014: ,p_argument_value => p_person_id
5015: );
5016: --
5017: hr_api.mandatory_arg_error
5018: (p_api_name => l_proc
5019: ,p_argument => 'effective_date'
5020: ,p_argument_value => l_effective_date
5021: );
5620: --
5621: ,p_scl_concat_segments => l_old_scl_conc_segments
5622: );
5623: exception
5624: when hr_api.cannot_find_prog_unit then
5625: hr_api.cannot_find_prog_unit_error
5626: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
5627: ,p_hook_type => 'AP'
5628: );
5621: ,p_scl_concat_segments => l_old_scl_conc_segments
5622: );
5623: exception
5624: when hr_api.cannot_find_prog_unit then
5625: hr_api.cannot_find_prog_unit_error
5626: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
5627: ,p_hook_type => 'AP'
5628: );
5629: --
5644: --
5645: -- When in validation only mode raise the Validate_Enabled exception
5646: --
5647: if p_validate then
5648: raise hr_api.validate_enabled;
5649: end if;
5650: --
5651: -- Set remaining output arguments
5652: --
5673: if g_debug then
5674: hr_utility.set_location(' Leaving:'||l_proc, 50);
5675: end if;
5676: exception
5677: when hr_api.validate_enabled then
5678: --
5679: -- As the Validate_Enabled exception has been raised
5680: -- we must rollback to the savepoint
5681: --
6146: ,p_supervisor_assignment_id => p_supervisor_assignment_id
6147: );
6148: --
6149: EXCEPTION
6150: WHEN hr_api.cannot_find_prog_unit THEN
6151: hr_api.cannot_find_prog_unit_error
6152: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6153: ,p_hook_type => 'BP');
6154: --
6147: );
6148: --
6149: EXCEPTION
6150: WHEN hr_api.cannot_find_prog_unit THEN
6151: hr_api.cannot_find_prog_unit_error
6152: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6153: ,p_hook_type => 'BP');
6154: --
6155: -- End of API User Hook for the before hook of create_secondary_emp_asg
6163: -- Validation in addition to Table Handlers
6164: --
6165: -- Get person details.
6166: --
6167: hr_api.mandatory_arg_error
6168: (p_api_name => l_proc
6169: ,p_argument => 'person_id'
6170: ,p_argument_value => p_person_id
6171: );
6169: ,p_argument => 'person_id'
6170: ,p_argument_value => p_person_id
6171: );
6172: --
6173: hr_api.mandatory_arg_error
6174: (p_api_name => l_proc
6175: ,p_argument => 'effective_date'
6176: ,p_argument_value => l_effective_date
6177: );
6756: );
6757: --
6758: EXCEPTION
6759: --
6760: WHEN hr_api.cannot_find_prog_unit THEN
6761: --
6762: hr_api.cannot_find_prog_unit_error
6763: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6764: ,p_hook_type => 'AP');
6758: EXCEPTION
6759: --
6760: WHEN hr_api.cannot_find_prog_unit THEN
6761: --
6762: hr_api.cannot_find_prog_unit_error
6763: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6764: ,p_hook_type => 'AP');
6765: --
6766: -- End of API User Hook for the after hook of create_secondary_emp_asg
6770: -- When in validation only mode raise the Validate_Enabled exception
6771: --
6772: IF p_validate THEN
6773: --
6774: RAISE hr_api.validate_enabled;
6775: --
6776: END IF;
6777: --
6778: -- Set remaining output arguments
6800: end if;
6801: --
6802: EXCEPTION
6803: --
6804: WHEN hr_api.validate_enabled THEN
6805: --
6806: -- As the Validate_Enabled exception has been raised
6807: -- we must rollback to the savepoint
6808: --
8412: -- Validation in addition to Table Handlers
8413: --
8414: -- Get assignment and business group details for validation.
8415: --
8416: hr_api.mandatory_arg_error
8417: (p_api_name => l_proc
8418: ,p_argument => 'assignment_id'
8419: ,p_argument_value => p_assignment_id
8420: );
8418: ,p_argument => 'assignment_id'
8419: ,p_argument_value => p_assignment_id
8420: );
8421: --
8422: hr_api.mandatory_arg_error
8423: (p_api_name => l_proc
8424: ,p_argument => 'final_process_date'
8425: ,p_argument_value => l_final_process_date
8426: );
8457: ,p_object_version_number => p_object_version_number
8458: ,p_final_process_date => l_final_process_date
8459: );
8460: exception
8461: when hr_api.cannot_find_prog_unit then
8462: hr_api.cannot_find_prog_unit_error
8463: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
8464: p_hook_type => 'BP'
8465: );
8458: ,p_final_process_date => l_final_process_date
8459: );
8460: exception
8461: when hr_api.cannot_find_prog_unit then
8462: hr_api.cannot_find_prog_unit_error
8463: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
8464: p_hook_type => 'BP'
8465: );
8466: end;
8508: into l_max_asg_end_date;
8509: close csr_invalid_term_assign;
8510:
8511: --
8512: if l_max_asg_end_date <> hr_api.g_eot
8513: then
8514: --
8515: if g_debug then
8516: hr_utility.set_location(l_proc, 90);
8596: ,p_asg_future_changes_warning => l_asg_future_changes_warning
8597: ,p_entries_changed_warning => l_entries_changed_warning
8598: );
8599: exception
8600: when hr_api.cannot_find_prog_unit then
8601: hr_api.cannot_find_prog_unit_error
8602: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
8603: p_hook_type => 'AP'
8604: );
8597: ,p_entries_changed_warning => l_entries_changed_warning
8598: );
8599: exception
8600: when hr_api.cannot_find_prog_unit then
8601: hr_api.cannot_find_prog_unit_error
8602: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
8603: p_hook_type => 'AP'
8604: );
8605: end;
8609: --
8610: -- When in validation only mode raise the Validate_Enabled exception
8611: --
8612: if p_validate then
8613: raise hr_api.validate_enabled;
8614: end if;
8615: --
8616: -- Set all output arguments
8617: --
8625: if g_debug then
8626: hr_utility.set_location(' Leaving:'||l_proc, 300);
8627: end if;
8628: exception
8629: when hr_api.validate_enabled then
8630: --
8631: -- As the Validate_Enabled exception has been raised
8632: -- we must rollback to the savepoint
8633: --
8735: ,p_object_version_number => p_object_version_number
8736: ,p_assignment_status_type_id => p_assignment_status_type_id
8737: );
8738: exception
8739: when hr_api.cannot_find_prog_unit then
8740: hr_api.cannot_find_prog_unit_error
8741: (p_module_name => 'SUSPEND_EMP_ASG',
8742: p_hook_type => 'BP'
8743: );
8736: ,p_assignment_status_type_id => p_assignment_status_type_id
8737: );
8738: exception
8739: when hr_api.cannot_find_prog_unit then
8740: hr_api.cannot_find_prog_unit_error
8741: (p_module_name => 'SUSPEND_EMP_ASG',
8742: p_hook_type => 'BP'
8743: );
8744: end;
8775: ,p_effective_start_date => l_effective_start_date
8776: ,p_effective_end_date => l_effective_end_date
8777: );
8778: exception
8779: when hr_api.cannot_find_prog_unit then
8780: hr_api.cannot_find_prog_unit_error
8781: (p_module_name => 'SUSPEND_EMP_ASG',
8782: p_hook_type => 'AP'
8783: );
8776: ,p_effective_end_date => l_effective_end_date
8777: );
8778: exception
8779: when hr_api.cannot_find_prog_unit then
8780: hr_api.cannot_find_prog_unit_error
8781: (p_module_name => 'SUSPEND_EMP_ASG',
8782: p_hook_type => 'AP'
8783: );
8784: end;
8788: --
8789: -- When in validation only mode raise the Validate_Enabled exception
8790: --
8791: if p_validate then
8792: raise hr_api.validate_enabled;
8793: end if;
8794: --
8795: -- Set all output arguments
8796: --
8801: if g_debug then
8802: hr_utility.set_location(' Leaving:'||l_proc, 100);
8803: end if;
8804: exception
8805: when hr_api.validate_enabled then
8806: --
8807: -- As the Validate_Enabled exception has been raised
8808: -- we must rollback to the savepoint
8809: --
9069: ,p_segment28 => p_segment28
9070: ,p_segment29 => p_segment29
9071: ,p_segment30 => p_segment30
9072: ,p_concat_segments => p_concat_segments
9073: ,p_contract_id => hr_api.g_number
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9070: ,p_segment29 => p_segment29
9071: ,p_segment30 => p_segment30
9072: ,p_concat_segments => p_concat_segments
9073: ,p_contract_id => hr_api.g_number
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9071: ,p_segment30 => p_segment30
9072: ,p_concat_segments => p_concat_segments
9073: ,p_contract_id => hr_api.g_number
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9072: ,p_concat_segments => p_concat_segments
9073: ,p_contract_id => hr_api.g_number
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9073: ,p_contract_id => hr_api.g_number
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9074: ,p_establishment_id => hr_api.g_number
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9075: ,p_collective_agreement_id => hr_api.g_number
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9076: ,p_cagr_id_flex_num => hr_api.g_number
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9077: ,p_cag_segment1 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9078: ,p_cag_segment2 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9079: ,p_cag_segment3 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9080: ,p_cag_segment4 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9081: ,p_cag_segment5 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9082: ,p_cag_segment6 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9083: ,p_cag_segment7 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9084: ,p_cag_segment8 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9085: ,p_cag_segment9 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9086: ,p_cag_segment10 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9087: ,p_cag_segment11 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9088: ,p_cag_segment12 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9096: ,p_cag_segment20 => hr_api.g_varchar2
9089: ,p_cag_segment13 => hr_api.g_varchar2
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9096: ,p_cag_segment20 => hr_api.g_varchar2
9097: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9090: ,p_cag_segment14 => hr_api.g_varchar2
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9096: ,p_cag_segment20 => hr_api.g_varchar2
9097: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9098: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9091: ,p_cag_segment15 => hr_api.g_varchar2
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9096: ,p_cag_segment20 => hr_api.g_varchar2
9097: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9098: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9099: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
9092: ,p_cag_segment16 => hr_api.g_varchar2
9093: ,p_cag_segment17 => hr_api.g_varchar2
9094: ,p_cag_segment18 => hr_api.g_varchar2
9095: ,p_cag_segment19 => hr_api.g_varchar2
9096: ,p_cag_segment20 => hr_api.g_varchar2
9097: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9098: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9099: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
9100: ,p_comment_id => l_comment_id
10420: ,p_job_post_source_name => p_job_post_source_name
10421: ,p_supervisor_assignment_id => p_supervisor_assignment_id
10422: );
10423: exception
10424: when hr_api.cannot_find_prog_unit then
10425: hr_api.cannot_find_prog_unit_error
10426: (p_module_name => 'UPDATE_EMP_ASG'
10427: ,p_hook_type => 'BP'
10428: );
10421: ,p_supervisor_assignment_id => p_supervisor_assignment_id
10422: );
10423: exception
10424: when hr_api.cannot_find_prog_unit then
10425: hr_api.cannot_find_prog_unit_error
10426: (p_module_name => 'UPDATE_EMP_ASG'
10427: ,p_hook_type => 'BP'
10428: );
10429: --
10438: -- Validation in addition to Table Handlers
10439: --
10440: -- Get assignment type.
10441: --
10442: hr_api.mandatory_arg_error
10443: (p_api_name => l_proc
10444: ,p_argument => 'assignment_id'
10445: ,p_argument_value => p_assignment_id);
10446: --
10443: (p_api_name => l_proc
10444: ,p_argument => 'assignment_id'
10445: ,p_argument_value => p_assignment_id);
10446: --
10447: hr_api.mandatory_arg_error
10448: (p_api_name => l_proc
10449: ,p_argument => 'effective_date'
10450: ,p_argument_value => l_effective_date);
10451: --
10479: end if;
10480: --
10481: --added validation for bug 1867720
10482: --
10483: if p_assignment_status_type_id <> hr_api.g_number then
10484: open csr_old_asg_status;
10485: fetch csr_old_asg_status into l_old_asg_status;
10486: close csr_old_asg_status;
10487: --
10537: close csr_get_soft_coding_keyflex;
10538: --
10539: -- Start of Fix for Bug 2548555
10540: --
10541: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10538: --
10539: -- Start of Fix for Bug 2548555
10540: --
10541: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10539: -- Start of Fix for Bug 2548555
10540: --
10541: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10540: --
10541: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10541: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10542: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10543: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10544: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10545: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10546: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10547: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10548: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10549: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10550: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10551: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10552: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10553: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10554: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10555: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10556: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10557: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10558: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10559: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10560: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10561: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10562: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10563: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10571: -- bug 944911
10564: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10571: -- bug 944911
10572: -- changed p_concatenated_segments to p_concat_segments
10565: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10571: -- bug 944911
10572: -- changed p_concatenated_segments to p_concat_segments
10573: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
10566: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
10567: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
10568: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10571: -- bug 944911
10572: -- changed p_concatenated_segments to p_concat_segments
10573: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
10574: --
10569: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
10570: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
10571: -- bug 944911
10572: -- changed p_concatenated_segments to p_concat_segments
10573: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
10574: --
10575: -- End of Fix for Bug 2548555
10576: --
10577: then
10674: );
10675: --
10676: end if; -- csr_scl_idsel%NOTFOUND
10677: --
10678: end if; -- l_scl_segment1 <> hr_api.g_varchar2
10679: --
10680: end if; -- l_soft_coding_key_flex_id is null
10681: --
10682: Added By FS */
10747: -- function allows that function to derive the old values.
10748: --
10749: l_cagr_id_flex_num := p_cagr_id_flex_num;
10750: --
10751: if (p_cagr_id_flex_num = hr_api.g_number)
10752: then
10753: per_asg_shd.lck
10754: (p_effective_date => l_effective_date,
10755: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
10807: hr_utility.set_location(l_proc, 25);
10808: end if;
10809:
10810: -- fix for bug 6595592 starts here.
10811: if (p_projected_assignment_end = hr_api.g_date) then -- fix for 6862763
10812: l_projected_assignment_end :=hr_api.g_date;
10813: else
10814: l_projected_assignment_end :=p_projected_assignment_end;
10815: end if;
10808: end if;
10809:
10810: -- fix for bug 6595592 starts here.
10811: if (p_projected_assignment_end = hr_api.g_date) then -- fix for 6862763
10812: l_projected_assignment_end :=hr_api.g_date;
10813: else
10814: l_projected_assignment_end :=p_projected_assignment_end;
10815: end if;
10816: -- fix for bug 6595592 ends here.
11050: ,p_hourly_salaried_warning => l_hourly_salaried_warning
11051: ,p_supervisor_assignment_id => p_supervisor_assignment_id
11052: );
11053: exception
11054: when hr_api.cannot_find_prog_unit then
11055: hr_api.cannot_find_prog_unit_error
11056: (p_module_name => 'UPDATE_EMP_ASG'
11057: ,p_hook_type => 'AP'
11058: );
11051: ,p_supervisor_assignment_id => p_supervisor_assignment_id
11052: );
11053: exception
11054: when hr_api.cannot_find_prog_unit then
11055: hr_api.cannot_find_prog_unit_error
11056: (p_module_name => 'UPDATE_EMP_ASG'
11057: ,p_hook_type => 'AP'
11058: );
11059: --
11074: --
11075: -- When in validation only mode raise the Validate_Enabled exception
11076: --
11077: if p_validate then
11078: raise hr_api.validate_enabled;
11079: end if;
11080: --
11081: -- Set all output arguments
11082: --
11100: if g_debug then
11101: hr_utility.set_location(' Leaving:'||l_proc, 30);
11102: end if;
11103: exception
11104: when hr_api.validate_enabled then
11105: --
11106: -- As the Validate_Enabled exception has been raised
11107: -- we must rollback to the savepoint
11108: --
11498: );
11499: --
11500: EXCEPTION
11501: --
11502: WHEN hr_api.cannot_find_prog_unit THEN
11503: --
11504: hr_api.cannot_find_prog_unit_error
11505: (p_module_name => 'UPDATE_CWK_ASG'
11506: ,p_hook_type => 'BP'
11500: EXCEPTION
11501: --
11502: WHEN hr_api.cannot_find_prog_unit THEN
11503: --
11504: hr_api.cannot_find_prog_unit_error
11505: (p_module_name => 'UPDATE_CWK_ASG'
11506: ,p_hook_type => 'BP'
11507: );
11508: --
11517: -- Validation in addition to Table Handlers
11518: --
11519: -- Get assignment type.
11520: --
11521: hr_api.mandatory_arg_error
11522: (p_api_name => l_proc
11523: ,p_argument => 'assignment_id'
11524: ,p_argument_value => p_assignment_id);
11525: --
11522: (p_api_name => l_proc
11523: ,p_argument => 'assignment_id'
11524: ,p_argument_value => p_assignment_id);
11525: --
11526: hr_api.mandatory_arg_error
11527: (p_api_name => l_proc
11528: ,p_argument => 'effective_date'
11529: ,p_argument_value => l_effective_date);
11530: --
11563: end if;
11564: --
11565: --added validation for bug 1867720
11566: --
11567: IF p_assignment_status_type_id <> hr_api.g_number THEN
11568: --
11569: OPEN csr_old_asg_status;
11570: FETCH csr_old_asg_status INTO l_old_asg_status;
11571: CLOSE csr_old_asg_status;
11601: --
11602: -- Bug 944911
11603: -- Added to next 2 ifs check for p_concatenated_segments also
11604: --
11605: if p_scl_segment1 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11602: -- Bug 944911
11603: -- Added to next 2 ifs check for p_concatenated_segments also
11604: --
11605: if p_scl_segment1 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11603: -- Added to next 2 ifs check for p_concatenated_segments also
11604: --
11605: if p_scl_segment1 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11604: --
11605: if p_scl_segment1 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11605: if p_scl_segment1 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11606: or p_scl_segment2 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11607: or p_scl_segment3 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11608: or p_scl_segment4 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11609: or p_scl_segment5 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11610: or p_scl_segment6 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11611: or p_scl_segment7 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11612: or p_scl_segment8 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11613: or p_scl_segment9 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11614: or p_scl_segment10 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11615: or p_scl_segment11 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11616: or p_scl_segment12 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11617: or p_scl_segment13 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11618: or p_scl_segment14 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11619: or p_scl_segment15 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11620: or p_scl_segment16 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11621: or p_scl_segment17 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11622: or p_scl_segment18 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11623: or p_scl_segment19 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11624: or p_scl_segment20 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11625: or p_scl_segment21 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11626: or p_scl_segment22 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11627: or p_scl_segment23 <> hr_api.g_varchar2
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11635: -- bug 944911
11628: or p_scl_segment24 <> hr_api.g_varchar2
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11635: -- bug 944911
11636: -- changed p_concatenated_segments to p_concat_segments
11629: or p_scl_segment25 <> hr_api.g_varchar2
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11635: -- bug 944911
11636: -- changed p_concatenated_segments to p_concat_segments
11637: or p_concat_segments <> hr_api.g_varchar2 then
11630: or p_scl_segment26 <> hr_api.g_varchar2
11631: or p_scl_segment27 <> hr_api.g_varchar2
11632: or p_scl_segment28 <> hr_api.g_varchar2
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11635: -- bug 944911
11636: -- changed p_concatenated_segments to p_concat_segments
11637: or p_concat_segments <> hr_api.g_varchar2 then
11638: --
11633: or p_scl_segment29 <> hr_api.g_varchar2
11634: or p_scl_segment30 <> hr_api.g_varchar2
11635: -- bug 944911
11636: -- changed p_concatenated_segments to p_concat_segments
11637: or p_concat_segments <> hr_api.g_varchar2 then
11638: --
11639: OPEN csr_scl_idsel;
11640: FETCH csr_scl_idsel INTO l_flex_num;
11641: --
11808: -- function allows that function to derive the old values.
11809: --
11810: l_cagr_id_flex_num := p_cagr_id_flex_num;
11811: --
11812: If (p_cagr_id_flex_num = hr_api.g_number) THEN
11813: --
11814: per_asg_shd.lck
11815: (p_effective_date => l_effective_date,
11816: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
12068: );
12069: --
12070: EXCEPTION
12071: --
12072: WHEN hr_api.cannot_find_prog_unit THEN
12073: --
12074: hr_api.cannot_find_prog_unit_error
12075: (p_module_name => 'UPDATE_CWK_ASG'
12076: ,p_hook_type => 'AP'
12070: EXCEPTION
12071: --
12072: WHEN hr_api.cannot_find_prog_unit THEN
12073: --
12074: hr_api.cannot_find_prog_unit_error
12075: (p_module_name => 'UPDATE_CWK_ASG'
12076: ,p_hook_type => 'AP'
12077: );
12078: --
12083: -- When in validation only mode raise the Validate_Enabled exception
12084: --
12085: IF p_validate THEN
12086: --
12087: RAISE hr_api.validate_enabled;
12088: --
12089: END IF;
12090: --
12091: -- Set all output arguments
12110: end if;
12111: --
12112: EXCEPTION
12113: --
12114: WHEN hr_api.validate_enabled THEN
12115: --
12116: -- As the Validate_Enabled exception has been raised
12117: -- we must rollback to the savepoint
12118: --
12438: ,p_concat_segments => l_old_group_name);
12439: --
12440: EXCEPTION
12441: --
12442: WHEN hr_api.cannot_find_prog_unit THEN
12443: --
12444: hr_api.cannot_find_prog_unit_error
12445: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
12446: ,p_hook_type => 'BP');
12440: EXCEPTION
12441: --
12442: WHEN hr_api.cannot_find_prog_unit THEN
12443: --
12444: hr_api.cannot_find_prog_unit_error
12445: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
12446: ,p_hook_type => 'BP');
12447: --
12448: -- End of API User Hook for the before hook of update_emp_cwk_criteria
12529: -- insert the profile options and effective date for the flexfield
12530: -- validation to work
12531: --
12532: --
12533: IF (l_org_id = hr_api.g_number) THEN -- Bug 3553286
12534: --
12535: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
12536: --
12537: ELSE
12539: l_organization_id := l_org_id; -- Bug 3553286
12540: --
12541: END IF;
12542: --
12543: IF (p_location_id=hr_api.g_number) THEN
12544: --
12545: l_location_id:=per_asg_shd.g_old_rec.location_id;
12546: --
12547: ELSE
12584: --
12585: -- Only call the flex code if a non-default value(includng null) is passed
12586: -- to the procedure.
12587: --
12588: if nvl(p_segment1,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12585: -- Only call the flex code if a non-default value(includng null) is passed
12586: -- to the procedure.
12587: --
12588: if nvl(p_segment1,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12586: -- to the procedure.
12587: --
12588: if nvl(p_segment1,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12587: --
12588: if nvl(p_segment1,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12588: if nvl(p_segment1,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12589: or nvl(p_segment2,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12590: or nvl(p_segment3,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12591: or nvl(p_segment4,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12592: or nvl(p_segment5,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12593: or nvl(p_segment6,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12594: or nvl(p_segment7,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12595: or nvl(p_segment8,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12596: or nvl(p_segment9,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12597: or nvl(p_segment10,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12598: or nvl(p_segment11,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12599: or nvl(p_segment12,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12600: or nvl(p_segment13,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12601: or nvl(p_segment14,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12602: or nvl(p_segment15,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12603: or nvl(p_segment16,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12604: or nvl(p_segment17,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12605: or nvl(p_segment18,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12606: or nvl(p_segment19,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12607: or nvl(p_segment20,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12608: or nvl(p_segment21,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12609: or nvl(p_segment22,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12610: or nvl(p_segment23,'X') <> hr_api.g_varchar2
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12618: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
12611: or nvl(p_segment24,'X') <> hr_api.g_varchar2
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12618: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
12619: --
12612: or nvl(p_segment25,'X') <> hr_api.g_varchar2
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12618: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
12619: --
12620: hr_kflex_utility.upd_or_sel_keyflex_comb
12613: or nvl(p_segment26,'X') <> hr_api.g_varchar2
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12618: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
12619: --
12620: hr_kflex_utility.upd_or_sel_keyflex_comb
12621: (p_appl_short_name => 'PAY'
12614: or nvl(p_segment27,'X') <> hr_api.g_varchar2
12615: or nvl(p_segment28,'X') <> hr_api.g_varchar2
12616: or nvl(p_segment29,'X') <> hr_api.g_varchar2
12617: or nvl(p_segment30,'X') <> hr_api.g_varchar2
12618: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
12619: --
12620: hr_kflex_utility.upd_or_sel_keyflex_comb
12621: (p_appl_short_name => 'PAY'
12622: ,p_flex_code => 'GRP'
12742: --of non payrolled worker. As a result this code has been commented
12743: --out, but left in as it is likely to form part of a later phase
12744: --
12745: /*
12746: IF (p_pay_basis_id <> hr_api.g_number or
12747: p_pay_basis_id is null ) and
12748: (nvl(p_pay_basis_id,hr_api.g_number) <>
12749: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
12750: then
12744: --
12745: /*
12746: IF (p_pay_basis_id <> hr_api.g_number or
12747: p_pay_basis_id is null ) and
12748: (nvl(p_pay_basis_id,hr_api.g_number) <>
12749: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
12750: then
12751: open csr_get_salary;
12752: fetch csr_get_salary into l_element_entry_id;
12745: /*
12746: IF (p_pay_basis_id <> hr_api.g_number or
12747: p_pay_basis_id is null ) and
12748: (nvl(p_pay_basis_id,hr_api.g_number) <>
12749: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
12750: then
12751: open csr_get_salary;
12752: fetch csr_get_salary into l_element_entry_id;
12753: if csr_get_salary%found then
12771: -- of non payrolled worker. As a result this code has been commented
12772: -- out, but left in as it is likely to form part of a later phase
12773: --
12774: /*
12775: if p_payroll_id = hr_api.g_number
12776: then
12777: --
12778: if g_debug then
12779: hr_utility.set_location(l_proc, 150);
12825: p_grade_id IS NULL) OR
12826: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12827: p_grade_id IS NOT NULL AND
12828: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
12829: p_grade_id <> hr_api.g_number) THEN
12830: --
12831: if g_debug then
12832: hr_utility.set_location(l_proc, 190);
12833: end if;
12978: ,p_concat_segments => l_old_group_name);
12979: --
12980: EXCEPTION
12981: --
12982: WHEN hr_api.cannot_find_prog_unit THEN
12983: --
12984: hr_api.cannot_find_prog_unit_error
12985: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
12986: ,p_hook_type => 'AP');
12980: EXCEPTION
12981: --
12982: WHEN hr_api.cannot_find_prog_unit THEN
12983: --
12984: hr_api.cannot_find_prog_unit_error
12985: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
12986: ,p_hook_type => 'AP');
12987: --
12988: -- End of API User Hook for the after hook of update_emp_asg_criteria
12992: -- When in validation only mode raise the Validate_Enabled exception
12993: --
12994: IF p_validate THEN
12995: --
12996: RAISE hr_api.validate_enabled;
12997: --
12998: END IF;
12999: --
13000: -- Set all output arguments
13021: end if;
13022: --
13023: EXCEPTION
13024: --
13025: WHEN hr_api.validate_enabled THEN
13026: --
13027: -- As the Validate_Enabled exception has been raised
13028: -- we must rollback to the savepoint
13029: --
14893: ,p_entries_changed_warning => l_entries_changed_warning
14894: ,p_tax_district_changed_warning => l_tax_district_changed_warning
14895: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
14896: ,p_concatenated_segments => l_concatenated_segments
14897: --2689059: changed the following: must pass hr_api defaults to NEW update API
14898: ,p_contract_id => hr_api.g_number --l_contract_id
14899: ,p_establishment_id => hr_api.g_number --l_establishment_id
14900: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
14901: ) ;
14894: ,p_tax_district_changed_warning => l_tax_district_changed_warning
14895: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
14896: ,p_concatenated_segments => l_concatenated_segments
14897: --2689059: changed the following: must pass hr_api defaults to NEW update API
14898: ,p_contract_id => hr_api.g_number --l_contract_id
14899: ,p_establishment_id => hr_api.g_number --l_establishment_id
14900: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
14901: ) ;
14902:
14895: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
14896: ,p_concatenated_segments => l_concatenated_segments
14897: --2689059: changed the following: must pass hr_api defaults to NEW update API
14898: ,p_contract_id => hr_api.g_number --l_contract_id
14899: ,p_establishment_id => hr_api.g_number --l_establishment_id
14900: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
14901: ) ;
14902:
14903:
14896: ,p_concatenated_segments => l_concatenated_segments
14897: --2689059: changed the following: must pass hr_api defaults to NEW update API
14898: ,p_contract_id => hr_api.g_number --l_contract_id
14899: ,p_establishment_id => hr_api.g_number --l_establishment_id
14900: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
14901: ) ;
14902:
14903:
14904: --
15298: l_pgp_segment30 varchar2(60) := p_segment30;
15299:
15300: -- Start of Fix for Bug 2622747
15301: l_scl_segment1 varchar2(60) := p_scl_segment1;
15302: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15299:
15300: -- Start of Fix for Bug 2622747
15301: l_scl_segment1 varchar2(60) := p_scl_segment1;
15302: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15300: -- Start of Fix for Bug 2622747
15301: l_scl_segment1 varchar2(60) := p_scl_segment1;
15302: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15301: l_scl_segment1 varchar2(60) := p_scl_segment1;
15302: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15302: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15303: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15304: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15305: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15306: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15307: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15308: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15309: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15310: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15311: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15312: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15313: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15314: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15315: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15316: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15317: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15318: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15319: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15320: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15321: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15322: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15330: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15323: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15330: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15331: --
15324: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15330: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15331: --
15332: lv_object_version_number number := p_object_version_number ;
15325: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15330: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15331: --
15332: lv_object_version_number number := p_object_version_number ;
15333: lv_special_ceiling_step_id number := p_special_ceiling_step_id ;
15326: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15327: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15328: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15329: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15330: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15331: --
15332: lv_object_version_number number := p_object_version_number ;
15333: lv_special_ceiling_step_id number := p_special_ceiling_step_id ;
15334: lv_people_group_id number := p_people_group_id ;
15600: );
15601: -- End of Fix for Bug 2622747
15602:
15603: exception
15604: when hr_api.cannot_find_prog_unit then
15605: hr_api.cannot_find_prog_unit_error
15606: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
15607: ,p_hook_type => 'BP'
15608: );
15601: -- End of Fix for Bug 2622747
15602:
15603: exception
15604: when hr_api.cannot_find_prog_unit then
15605: hr_api.cannot_find_prog_unit_error
15606: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
15607: ,p_hook_type => 'BP'
15608: );
15609: --
15688: -- l_special_ceiling_step_id := null;
15689: -- else
15690: -- --
15691: -- --
15692: -- if p_special_ceiling_step_id = hr_api.g_number then
15693: -- --
15694: -- --
15695: -- l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
15696: -- else
15716: -- the grade is assigned to assignment but not passed
15717: -- to api.
15718: --
15719: if (per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
15720: p_grade_id <> hr_api.g_number AND -- 3485599
15721: p_special_ceiling_step_id IS NOT NULL) then
15722: --
15723: if g_debug then
15724: hr_utility.set_location(l_proc, 140);
15771: if g_debug then
15772: hr_utility.set_location(l_proc, 180);
15773: end if;
15774: --
15775: if p_special_ceiling_step_id = hr_api.g_number then
15776: --
15777: if g_debug then
15778: hr_utility.set_location(l_proc, 190);
15779: end if;
15812: -- insert the profile options and effective date for the flexfield
15813: -- validation to work
15814: --
15815: --
15816: if (l_org_id = hr_api.g_number) then -- Bug 3553286
15817: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
15818: else
15819: l_organization_id:= l_org_id; -- Bug 3553286
15820: end if;
15818: else
15819: l_organization_id:= l_org_id; -- Bug 3553286
15820: end if;
15821: --
15822: if (p_location_id=hr_api.g_number) then
15823: l_location_id:=per_asg_shd.g_old_rec.location_id;
15824: else
15825: l_location_id:=p_location_id;
15826: end if;
15880: fetch c_pgp_segments into l_old_pgp_segments;
15881: close c_pgp_segments;
15882: end if;
15883: --
15884: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15881: close c_pgp_segments;
15882: end if;
15883: --
15884: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15882: end if;
15883: --
15884: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15883: --
15884: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15884: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15885: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15886: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15887: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15888: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15889: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15890: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15891: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15892: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15893: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15894: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15895: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15896: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15897: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15898: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15899: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15900: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15901: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15902: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15903: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15904: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15905: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15906: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15914: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
15907: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15914: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
15915: or l_people_group_id is null -- fix for bug 4633742.
15908: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15914: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
15915: or l_people_group_id is null -- fix for bug 4633742.
15916: then
15909: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15914: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
15915: or l_people_group_id is null -- fix for bug 4633742.
15916: then
15917: hr_kflex_utility.upd_or_sel_keyflex_comb
15910: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
15911: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
15912: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
15913: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
15914: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
15915: or l_people_group_id is null -- fix for bug 4633742.
15916: then
15917: hr_kflex_utility.upd_or_sel_keyflex_comb
15918: (p_appl_short_name => 'PAY'
16082: --
16083: -- Delete the SP element entry if there is one when the pay_basis
16084: -- changes
16085: --
16086: if (p_pay_basis_id <> hr_api.g_number or
16087: p_pay_basis_id is null ) and
16088: (nvl(p_pay_basis_id,hr_api.g_number) <>
16089: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16090: then
16084: -- changes
16085: --
16086: if (p_pay_basis_id <> hr_api.g_number or
16087: p_pay_basis_id is null ) and
16088: (nvl(p_pay_basis_id,hr_api.g_number) <>
16089: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16090: then
16091: -- start of bug fix 4464072
16092: -- commented out the following part and newly defined
16085: --
16086: if (p_pay_basis_id <> hr_api.g_number or
16087: p_pay_basis_id is null ) and
16088: (nvl(p_pay_basis_id,hr_api.g_number) <>
16089: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16090: then
16091: -- start of bug fix 4464072
16092: -- commented out the following part and newly defined
16093:
16148: -- Maintain standard element entries for this assignment.
16149: --
16150: -- Bug 638026 fix starts
16151: --
16152: if p_payroll_id = hr_api.g_number
16153: then
16154: --
16155: if g_debug then
16156: hr_utility.set_location(l_proc, 300);
16204: AND p_grade_id is null)
16205: OR ( per_asg_shd.g_old_rec.grade_id is not null
16206: AND p_grade_id is not null
16207: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
16208: AND p_grade_id <> hr_api.g_number)
16209: then
16210: --
16211: if g_debug then
16212: hr_utility.set_location(l_proc, 340);
16369: ,p_scl_segment1 => l_scl_segment1
16370: -- End of Fix for Bug 2622747
16371: );
16372: exception
16373: when hr_api.cannot_find_prog_unit then
16374: hr_api.cannot_find_prog_unit_error
16375: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
16376: ,p_hook_type => 'AP'
16377: );
16370: -- End of Fix for Bug 2622747
16371: );
16372: exception
16373: when hr_api.cannot_find_prog_unit then
16374: hr_api.cannot_find_prog_unit_error
16375: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
16376: ,p_hook_type => 'AP'
16377: );
16378: --
16394: --
16395: -- When in validation only mode raise the Validate_Enabled exception
16396: --
16397: if p_validate then
16398: raise hr_api.validate_enabled;
16399: end if;
16400: --
16401: -- Set all output arguments
16402: --
16422: hr_utility.set_location(' Leaving:'||l_proc, 997);
16423: end if;
16424: --
16425: exception
16426: when hr_api.validate_enabled then
16427: --
16428: if g_debug then
16429: hr_utility.set_location(' Leaving:'||l_proc, 998);
16430: end if;
17037: -- Validation in addition to Table Handlers
17038: --
17039: -- Check mandatory arguments
17040: --
17041: hr_api.mandatory_arg_error
17042: (p_api_name => l_proc
17043: ,p_argument => 'assignment_id'
17044: ,p_argument_value => p_assignment_id);
17045: --
17042: (p_api_name => l_proc
17043: ,p_argument => 'assignment_id'
17044: ,p_argument_value => p_assignment_id);
17045: --
17046: hr_api.mandatory_arg_error
17047: (p_api_name => l_proc
17048: ,p_argument => 'effective_date'
17049: ,p_argument_value => l_effective_date);
17050: --
17047: (p_api_name => l_proc
17048: ,p_argument => 'effective_date'
17049: ,p_argument_value => l_effective_date);
17050: --
17051: hr_api.mandatory_arg_error
17052: (p_api_name => l_proc
17053: ,p_argument => 'datetrack_update_mode'
17054: ,p_argument_value => p_datetrack_update_mode);
17055: --
17052: (p_api_name => l_proc
17053: ,p_argument => 'datetrack_update_mode'
17054: ,p_argument_value => p_datetrack_update_mode);
17055: --
17056: hr_api.mandatory_arg_error
17057: (p_api_name => l_proc
17058: ,p_argument => 'object_version_number'
17059: ,p_argument_value => l_object_version_number);
17060: --
17403: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
17404: ,p_supervisor_assignment_id => p_supervisor_assignment_id
17405: );
17406: exception
17407: when hr_api.cannot_find_prog_unit then
17408: hr_api.cannot_find_prog_unit_error
17409: (p_module_name => 'UPDATE_APL_ASG',
17410: p_hook_type => 'BP'
17411: );
17404: ,p_supervisor_assignment_id => p_supervisor_assignment_id
17405: );
17406: exception
17407: when hr_api.cannot_find_prog_unit then
17408: hr_api.cannot_find_prog_unit_error
17409: (p_module_name => 'UPDATE_APL_ASG',
17410: p_hook_type => 'BP'
17411: );
17412: end;
17417: end if;
17418: --
17419: --added validation for bug 1867720
17420: --
17421: if p_assignment_status_type_id <> hr_api.g_number then
17422: open csr_old_asg_status;
17423: fetch csr_old_asg_status into l_old_asg_status;
17424: close csr_old_asg_status;
17425: --
17438: --
17439: -- insert the profile options and effective date for the flexfield
17440: -- validation to work
17441: --
17442: if (p_organization_id=hr_api.g_number) then
17443: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
17444: else
17445: l_organization_id:=p_organization_id;
17446: end if;
17444: else
17445: l_organization_id:=p_organization_id;
17446: end if;
17447: --
17448: if (p_location_id=hr_api.g_number) then
17449: l_location_id:=per_asg_shd.g_old_rec.location_id;
17450: else
17451: l_location_id:=p_location_id;
17452: end if;
17527: -- Update or select the soft_coding_keyflex_id
17528: --
17529: if l_soft_coding_keyflex_id is null
17530: then
17531: if l_scl_segment1 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17528: --
17529: if l_soft_coding_keyflex_id is null
17530: then
17531: if l_scl_segment1 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17529: if l_soft_coding_keyflex_id is null
17530: then
17531: if l_scl_segment1 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17530: then
17531: if l_scl_segment1 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17531: if l_scl_segment1 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17532: or l_scl_segment2 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17533: or l_scl_segment3 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17534: or l_scl_segment4 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17535: or l_scl_segment5 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17536: or l_scl_segment6 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17537: or l_scl_segment7 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17538: or l_scl_segment8 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17539: or l_scl_segment9 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17540: or l_scl_segment10 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17541: or l_scl_segment11 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17542: or l_scl_segment12 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17543: or l_scl_segment13 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17544: or l_scl_segment14 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17545: or l_scl_segment15 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17546: or l_scl_segment16 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17547: or l_scl_segment17 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17548: or l_scl_segment18 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17549: or l_scl_segment19 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17550: or l_scl_segment20 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17551: or l_scl_segment21 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17552: or l_scl_segment22 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17553: or l_scl_segment23 <> hr_api.g_varchar2
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17561: --
17554: or l_scl_segment24 <> hr_api.g_varchar2
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17561: --
17562: -- Bug 944911
17555: or l_scl_segment25 <> hr_api.g_varchar2
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17561: --
17562: -- Bug 944911
17563: -- Added this additional check
17556: or l_scl_segment26 <> hr_api.g_varchar2
17557: or l_scl_segment27 <> hr_api.g_varchar2
17558: or l_scl_segment28 <> hr_api.g_varchar2
17559: or l_scl_segment29 <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17561: --
17562: -- Bug 944911
17563: -- Added this additional check
17564: or p_scl_concat_segments <> hr_api.g_varchar2
17560: or l_scl_segment30 <> hr_api.g_varchar2
17561: --
17562: -- Bug 944911
17563: -- Added this additional check
17564: or p_scl_concat_segments <> hr_api.g_varchar2
17565: then
17566: -- gets flex num id from pay_legislation_rules and
17567: -- per_business_groups_perf
17568: --
17667: );
17668: --
17669: end if; -- csr_scl_idsel%NOTFOUND
17670: --
17671: end if; -- l_scl_segment1 <> hr_api.g_varchar2
17672: --
17673: end if; -- l_soft_coding_key_flex_id is null
17674: --
17675: -- need to call the lck procedure early, to fetch the old value of
17685: -- function allows that function to derive the old values.
17686: --
17687: l_cagr_id_flex_num := p_cagr_id_flex_num;
17688: --
17689: if (p_cagr_id_flex_num = hr_api.g_number) THEN
17690: per_asg_shd.lck
17691: (p_effective_date => l_effective_date,
17692: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
17693: p_datetrack_mode => p_datetrack_update_mode,
17847: );
17848: --
17849: -- ***** Start new code for bug 2276928 **************
17850: if per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
17851: and p_assignment_status_type_id<>hr_api.g_number then
17852: IRC_ASG_STATUS_API.create_irc_asg_status
17853: (p_assignment_id => p_assignment_id
17854: , p_assignment_status_type_id => p_assignment_status_type_id
17855: , p_status_change_date => p_effective_date
17864: -- with that vacancy.
17865: -- When the assignemnt status is changed, create new letter request lines.
17866: --
17867: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
17868: AND p_assignment_status_type_id<>hr_api.g_number
17869: )
17870: OR
17871: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17872: nvl(p_vacancy_id,-1) <> hr_api.g_number
17868: AND p_assignment_status_type_id<>hr_api.g_number
17869: )
17870: OR
17871: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17872: nvl(p_vacancy_id,-1) <> hr_api.g_number
17873: ) THEN
17874: --
17875: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17876: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
17872: nvl(p_vacancy_id,-1) <> hr_api.g_number
17873: ) THEN
17874: --
17875: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17876: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
17877: --
17878: delete from per_letter_request_lines plrl
17879: where plrl.assignment_id = p_assignment_id
17880: and plrl.assignment_status_type_id = p_assignment_status_type_id
18136: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
18137: ,p_supervisor_assignment_id => p_supervisor_assignment_id
18138: );
18139: exception
18140: when hr_api.cannot_find_prog_unit then
18141: hr_api.cannot_find_prog_unit_error
18142: (p_module_name => 'UPDATE_APL_ASG',
18143: p_hook_type => 'AP'
18144: );
18137: ,p_supervisor_assignment_id => p_supervisor_assignment_id
18138: );
18139: exception
18140: when hr_api.cannot_find_prog_unit then
18141: hr_api.cannot_find_prog_unit_error
18142: (p_module_name => 'UPDATE_APL_ASG',
18143: p_hook_type => 'AP'
18144: );
18145: end;
18149: --
18150: -- When in validation only mode raise the Validate_Enabled exception
18151: --
18152: if p_validate then
18153: raise hr_api.validate_enabled;
18154: end if;
18155: --
18156: -- Set all output arguments
18157: --
18176: if g_debug then
18177: hr_utility.set_location(' Leaving:'||l_proc, 6);
18178: end if;
18179: exception
18180: when hr_api.validate_enabled then
18181: --
18182: -- As the Validate_Enabled exception has been raised
18183: -- we must rollback to the savepoint
18184: --
19231: select apl.application_id, apl.date_end
19232: from per_applications apl
19233: where apl.person_id = p_person_id
19234: and l_effective_date between apl.date_received
19235: and nvl(apl.date_end,hr_api.g_eot);
19236: -- <<
19237: cursor csr_get_apl_asg is
19238: select asg.application_id
19239: from per_all_assignments_f asg
19405: -- Validation in addition to Table Handlers
19406: --
19407: -- Get person details.
19408: --
19409: hr_api.mandatory_arg_error
19410: (p_api_name => l_proc
19411: ,p_argument => 'person_id'
19412: ,p_argument_value => p_person_id
19413: );
19411: ,p_argument => 'person_id'
19412: ,p_argument_value => p_person_id
19413: );
19414: --
19415: hr_api.mandatory_arg_error
19416: (p_api_name => l_proc
19417: ,p_argument => 'effective_date'
19418: ,p_argument_value => l_effective_date
19419: );
19744: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
19745: ,p_supervisor_assignment_id => p_supervisor_assignment_id
19746: );
19747: exception
19748: when hr_api.cannot_find_prog_unit then
19749: hr_api.cannot_find_prog_unit_error
19750: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
19751: p_hook_type => 'BP'
19752: );
19745: ,p_supervisor_assignment_id => p_supervisor_assignment_id
19746: );
19747: exception
19748: when hr_api.cannot_find_prog_unit then
19749: hr_api.cannot_find_prog_unit_error
19750: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
19751: p_hook_type => 'BP'
19752: );
19753: end;
20088: --
20089: hr_assignment_api.update_apl_asg
20090: (p_validate => FALSE
20091: ,p_effective_date => l_effective_date
20092: ,p_datetrack_update_mode => hr_api.g_correction
20093: ,p_assignment_id => l_assignment_id
20094: ,p_object_version_number => l_object_version_number
20095: ,p_recruiter_id => p_recruiter_id
20096: ,p_grade_id => p_grade_id
20572: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
20573: ,p_supervisor_assignment_id => p_supervisor_assignment_id
20574: );
20575: exception
20576: when hr_api.cannot_find_prog_unit then
20577: hr_api.cannot_find_prog_unit_error
20578: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
20579: p_hook_type => 'AP'
20580: );
20573: ,p_supervisor_assignment_id => p_supervisor_assignment_id
20574: );
20575: exception
20576: when hr_api.cannot_find_prog_unit then
20577: hr_api.cannot_find_prog_unit_error
20578: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
20579: p_hook_type => 'AP'
20580: );
20581: end;
20585: --
20586: -- When in validation only mode raise the Validate_Enabled exception
20587: --
20588: if p_validate then
20589: raise hr_api.validate_enabled;
20590: end if;
20591: --
20592: -- Set remaining output arguments
20593: --
20616: if g_debug then
20617: hr_utility.set_location(' Leaving:'||l_proc, 50);
20618: end if;
20619: exception
20620: when hr_api.validate_enabled then
20621: --
20622: -- As the Validate_Enabled exception has been raised
20623: -- we must rollback to the savepoint
20624: --
21021: ,p_assignment_status_type_id => p_assignment_status_type_id
21022: ,p_change_reason => p_change_reason
21023: );
21024: exception
21025: when hr_api.cannot_find_prog_unit then
21026: hr_api.cannot_find_prog_unit_error
21027: (p_module_name => 'OFFER_APL_ASG',
21028: p_hook_type => 'BP'
21029: );
21022: ,p_change_reason => p_change_reason
21023: );
21024: exception
21025: when hr_api.cannot_find_prog_unit then
21026: hr_api.cannot_find_prog_unit_error
21027: (p_module_name => 'OFFER_APL_ASG',
21028: p_hook_type => 'BP'
21029: );
21030: end;
21058: ,p_effective_start_date => l_effective_start_date
21059: ,p_effective_end_date => l_effective_end_date
21060: );
21061: exception
21062: when hr_api.cannot_find_prog_unit then
21063: hr_api.cannot_find_prog_unit_error
21064: (p_module_name => 'OFFER_APL_ASG',
21065: p_hook_type => 'AP'
21066: );
21059: ,p_effective_end_date => l_effective_end_date
21060: );
21061: exception
21062: when hr_api.cannot_find_prog_unit then
21063: hr_api.cannot_find_prog_unit_error
21064: (p_module_name => 'OFFER_APL_ASG',
21065: p_hook_type => 'AP'
21066: );
21067: end;
21071: --
21072: -- When in validation only mode raise the Validate_Enabled exception
21073: --
21074: if p_validate then
21075: raise hr_api.validate_enabled;
21076: end if;
21077: --
21078: -- Set remaining output arguments
21079: --
21084: if g_debug then
21085: hr_utility.set_location(' Leaving:'||l_proc, 50);
21086: end if;
21087: exception
21088: when hr_api.validate_enabled then
21089: --
21090: -- As the Validate_Enabled exception has been raised
21091: -- we must rollback to the savepoint
21092: --
21182: ,p_assignment_status_type_id => p_assignment_status_type_id
21183: ,p_change_reason => p_change_reason
21184: );
21185: exception
21186: when hr_api.cannot_find_prog_unit then
21187: hr_api.cannot_find_prog_unit_error
21188: (p_module_name => 'ACCEPT_APL_ASG',
21189: p_hook_type => 'BP'
21190: );
21183: ,p_change_reason => p_change_reason
21184: );
21185: exception
21186: when hr_api.cannot_find_prog_unit then
21187: hr_api.cannot_find_prog_unit_error
21188: (p_module_name => 'ACCEPT_APL_ASG',
21189: p_hook_type => 'BP'
21190: );
21191: end;
21221: ,p_effective_start_date => l_effective_start_date
21222: ,p_effective_end_date => l_effective_end_date
21223: );
21224: exception
21225: when hr_api.cannot_find_prog_unit then
21226: hr_api.cannot_find_prog_unit_error
21227: (p_module_name => 'OFFER_APL_ASG',
21228: p_hook_type => 'AP'
21229: );
21222: ,p_effective_end_date => l_effective_end_date
21223: );
21224: exception
21225: when hr_api.cannot_find_prog_unit then
21226: hr_api.cannot_find_prog_unit_error
21227: (p_module_name => 'OFFER_APL_ASG',
21228: p_hook_type => 'AP'
21229: );
21230: end;
21235: --
21236: -- When in validation only mode raise the Validate_Enabled exception
21237: --
21238: if p_validate then
21239: raise hr_api.validate_enabled;
21240: end if;
21241: --
21242: -- Set remaining output arguments
21243: --
21248: if g_debug then
21249: hr_utility.set_location(' Leaving:'||l_proc, 50);
21250: end if;
21251: exception
21252: when hr_api.validate_enabled then
21253: -- As the Validate_Enabled exception has been raised
21254: -- we must rollback to the savepoint
21255: --
21256: ROLLBACK TO accept_apl_asg;
21335: ,p_assignment_status_type_id => p_assignment_status_type_id
21336: ,p_change_reason => p_change_reason
21337: );
21338: EXCEPTION
21339: WHEN hr_api.cannot_find_prog_unit
21340: THEN
21341: hr_api.cannot_find_prog_unit_error
21342: (p_module_name => 'ACTIVATE_APL_ASG',
21343: p_hook_type => 'BP'
21337: );
21338: EXCEPTION
21339: WHEN hr_api.cannot_find_prog_unit
21340: THEN
21341: hr_api.cannot_find_prog_unit_error
21342: (p_module_name => 'ACTIVATE_APL_ASG',
21343: p_hook_type => 'BP'
21344: );
21345: END;
21379: ,p_effective_start_date => l_effective_start_date
21380: ,p_effective_end_date => l_effective_end_date
21381: );
21382: EXCEPTION
21383: WHEN hr_api.cannot_find_prog_unit
21384: THEN
21385: hr_api.cannot_find_prog_unit_error
21386: (p_module_name => 'ACTIVATE_APL_ASG',
21387: p_hook_type => 'AP'
21381: );
21382: EXCEPTION
21383: WHEN hr_api.cannot_find_prog_unit
21384: THEN
21385: hr_api.cannot_find_prog_unit_error
21386: (p_module_name => 'ACTIVATE_APL_ASG',
21387: p_hook_type => 'AP'
21388: );
21389: END;
21395: -- When in validation only mode raise validate_enabled exception
21396: --
21397: IF p_validate
21398: THEN
21399: RAISE hr_api.validate_enabled;
21400: END IF;
21401: --
21402: -- Set OUT parameters
21403: --
21408: hr_utility.set_location(' Leaving:'||l_proc,100);
21409: end if;
21410: --
21411: EXCEPTION
21412: WHEN hr_api.validate_enabled
21413: THEN
21414: --
21415: -- In validation only mode
21416: -- Rollback to savepoint
21597: per_asg_del.del
21598: (p_assignment_id => p_assignment_id
21599: ,p_object_version_number => p_object_version_number
21600: ,p_effective_date => l_effective_date
21601: ,p_datetrack_mode => hr_api.g_delete
21602: ,p_effective_start_date => l_effective_start_date
21603: ,p_effective_end_date => l_effective_end_date
21604: ,p_business_group_id => l_business_group_id
21605: ,p_validation_start_date => l_validation_start_date
21685: end if;
21686: --
21687: -- Ensure mandatory arguments have been passed
21688: --
21689: hr_api.mandatory_arg_error
21690: (p_api_name => l_proc
21691: ,p_argument => 'assignment_id'
21692: ,p_argument_value => p_assignment_id
21693: );
21691: ,p_argument => 'assignment_id'
21692: ,p_argument_value => p_assignment_id
21693: );
21694: --
21695: hr_api.mandatory_arg_error
21696: (p_api_name => l_proc
21697: ,p_argument => 'effective_date'
21698: ,p_argument_value => p_effective_date
21699: );
21720: ,p_assignment_id => p_assignment_id
21721: ,p_object_version_number => p_object_version_number
21722: );
21723: EXCEPTION
21724: WHEN hr_api.cannot_find_prog_unit
21725: THEN
21726: hr_api.cannot_find_prog_unit_error
21727: (p_module_name => 'TERMINATE_APL_ASG'
21728: ,p_hook_type => 'B'
21722: );
21723: EXCEPTION
21724: WHEN hr_api.cannot_find_prog_unit
21725: THEN
21726: hr_api.cannot_find_prog_unit_error
21727: (p_module_name => 'TERMINATE_APL_ASG'
21728: ,p_hook_type => 'B'
21729: );
21730: END;
21883: ,p_validation_start_date => l_validation_start_date
21884: ,p_validation_end_date => l_validation_end_date
21885: ,p_object_version_number => l_asg_ovn
21886: ,p_effective_date => l_asg_eff_date
21887: ,p_datetrack_mode => hr_api.g_correction
21888: ,p_validate => FALSE
21889: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
21890: -- update all other future assignments
21891: hr_utility.trace(' update all other assignments');
21908: ,p_validation_start_date => l_validation_start_date
21909: ,p_validation_end_date => l_validation_end_date
21910: ,p_object_version_number => l_asg_ovn
21911: ,p_effective_date => l_asg_eff_date
21912: ,p_datetrack_mode => hr_api.g_correction
21913: ,p_validate => FALSE
21914: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
21915: END LOOP;
21916: --
22057: ,p_validation_start_date => l_validation_start_date
22058: ,p_validation_end_date => l_validation_end_date
22059: ,p_object_version_number => l_asg_ovn
22060: ,p_effective_date => l_asg_eff_date
22061: ,p_datetrack_mode => hr_api.g_correction
22062: ,p_validate => FALSE
22063: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
22064: -- update all other future assignments
22065: hr_utility.trace(' update all other assignments');
22082: ,p_validation_start_date => l_validation_start_date
22083: ,p_validation_end_date => l_validation_end_date
22084: ,p_object_version_number => l_asg_ovn
22085: ,p_effective_date => l_asg_eff_date
22086: ,p_datetrack_mode => hr_api.g_correction
22087: ,p_validate => FALSE
22088: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
22089: END LOOP;
22090: --
22137: ,p_effective_start_date => l_effective_start_date
22138: ,p_effective_end_date => l_effective_end_date
22139: );
22140: EXCEPTION
22141: WHEN hr_api.cannot_find_prog_unit
22142: THEN
22143: hr_api.cannot_find_prog_unit_error
22144: (p_module_name => 'TERMINATE_APL_ASG'
22145: ,p_hook_type => 'A'
22139: );
22140: EXCEPTION
22141: WHEN hr_api.cannot_find_prog_unit
22142: THEN
22143: hr_api.cannot_find_prog_unit_error
22144: (p_module_name => 'TERMINATE_APL_ASG'
22145: ,p_hook_type => 'A'
22146: );
22147: END;
22153: -- When in validation only mode raise validate enabled exception
22154: --
22155: IF p_validate
22156: THEN
22157: RAISE hr_api.validate_enabled;
22158: END IF;
22159: --
22160: -- Set OUT parameters
22161: --
22166: hr_utility.set_location(' Leaving:'||l_proc,1000);
22167: end if;
22168: --
22169: EXCEPTION
22170: WHEN hr_api.validate_enabled
22171: THEN
22172: --
22173: -- In validation only mode
22174: -- Rollback to savepoint
22279: end if;
22280: --
22281: -- Ensure mandatory parameters have been passed
22282: --
22283: hr_api.mandatory_arg_error
22284: (p_api_name => l_proc
22285: ,p_argument => 'effective_date'
22286: ,p_argument_value => p_effective_date
22287: );
22285: ,p_argument => 'effective_date'
22286: ,p_argument_value => p_effective_date
22287: );
22288: --
22289: hr_api.mandatory_arg_error
22290: (p_api_name => l_proc
22291: ,p_argument => 'person_id'
22292: ,p_argument_value => p_person_id
22293: );
22291: ,p_argument => 'person_id'
22292: ,p_argument_value => p_person_id
22293: );
22294: --
22295: hr_api.mandatory_arg_error
22296: (p_api_name => l_proc
22297: ,p_argument => 'assignment_id'
22298: ,p_argument_value => p_assignment_id
22299: );
22319: ,p_assignment_id => p_assignment_id
22320: ,p_object_version_number => p_object_version_number
22321: );
22322: EXCEPTION
22323: WHEN hr_api.cannot_find_prog_unit
22324: THEN
22325: hr_api.cannot_find_prog_unit_error
22326: (p_module_name => 'SET_NEW_PRIMARY_ASG'
22327: ,p_hook_type => 'BP'
22321: );
22322: EXCEPTION
22323: WHEN hr_api.cannot_find_prog_unit
22324: THEN
22325: hr_api.cannot_find_prog_unit_error
22326: (p_module_name => 'SET_NEW_PRIMARY_ASG'
22327: ,p_hook_type => 'BP'
22328: );
22329: END;
22386: THEN
22387: hr_utility.set_message(801,'HR_7999_ASG_INV_PRIM_ASG');
22388: hr_utility.raise_error;
22389: END IF;
22390: IF l_new_assignment.max_effective_end_date <> NVL(l_new_assignment.actual_termination_date,hr_api.g_eot)
22391: THEN
22392: hr_utility.set_message(800,'HR_6438_EMP_ASS_NOT_CONTIN');
22393: hr_utility.raise_error;
22394: END IF;
22407: -- ,p_period_of_service_id => l_old_assignment.period_of_service_id
22408: -- ,p_new_primary_ass_id => p_assignment_id
22409: -- ,p_sdate => l_effective_date
22410: -- ,p_new_primary_flag => 'Y'
22411: -- ,p_mode => hr_api.g_update
22412: -- ,p_last_updated_by => TO_NUMBER(NULL)
22413: -- ,p_last_update_login => TO_NUMBER(NULL)
22414: -- );
22415: --
22424: ,p_period_of_service_id => l_old_assignment.period_of_service_id -- #2468916:instead of new.
22425: ,p_new_primary_ass_id => p_assignment_id
22426: ,p_sdate => l_effective_date
22427: ,p_new_primary_flag => 'Y'
22428: ,p_mode => hr_api.g_update
22429: ,p_last_updated_by => TO_NUMBER(NULL)
22430: ,p_last_update_login => TO_NUMBER(NULL)
22431: );
22432: --
22479: ,p_effective_start_date => l_new_assignment.effective_start_date
22480: ,p_effective_end_date => l_new_assignment.effective_end_date
22481: );
22482: EXCEPTION
22483: WHEN hr_api.cannot_find_prog_unit
22484: THEN
22485: hr_api.cannot_find_prog_unit_error
22486: (p_module_name => 'SET_NEW_PRIMARY_ASG'
22487: ,p_hook_type => 'AP'
22481: );
22482: EXCEPTION
22483: WHEN hr_api.cannot_find_prog_unit
22484: THEN
22485: hr_api.cannot_find_prog_unit_error
22486: (p_module_name => 'SET_NEW_PRIMARY_ASG'
22487: ,p_hook_type => 'AP'
22488: );
22489: END;
22495: -- When in validation only mode raise validate enabled exception
22496: --
22497: IF p_validate
22498: THEN
22499: RAISE hr_api.validate_enabled;
22500: END IF;
22501: --
22502: -- Set OUT parameters
22503: --
22509: hr_utility.set_location(' Leaving:'||l_proc,1000);
22510: end if;
22511: --
22512: EXCEPTION
22513: WHEN hr_api.validate_enabled
22514: THEN
22515: --
22516: -- In validation only mode
22517: -- Rollback to savepoint
22620: end if;
22621: --
22622: -- Ensure mandatory parameters have been passed
22623: --
22624: hr_api.mandatory_arg_error
22625: (p_api_name => l_proc
22626: ,p_argument => 'effective_date'
22627: ,p_argument_value => p_effective_date
22628: );
22626: ,p_argument => 'effective_date'
22627: ,p_argument_value => p_effective_date
22628: );
22629: --
22630: hr_api.mandatory_arg_error
22631: (p_api_name => l_proc
22632: ,p_argument => 'person_id'
22633: ,p_argument_value => p_person_id
22634: );
22632: ,p_argument => 'person_id'
22633: ,p_argument_value => p_person_id
22634: );
22635: --
22636: hr_api.mandatory_arg_error
22637: (p_api_name => l_proc
22638: ,p_argument => 'assignment_id'
22639: ,p_argument_value => p_assignment_id
22640: );
22662: ,p_object_version_number => p_object_version_number);
22663: --
22664: EXCEPTION
22665: --
22666: WHEN hr_api.cannot_find_prog_unit THEN
22667: --
22668: hr_api.cannot_find_prog_unit_error
22669: (p_module_name => 'set_new_primary_cwk_asg'
22670: ,p_hook_type => 'BP');
22664: EXCEPTION
22665: --
22666: WHEN hr_api.cannot_find_prog_unit THEN
22667: --
22668: hr_api.cannot_find_prog_unit_error
22669: (p_module_name => 'set_new_primary_cwk_asg'
22670: ,p_hook_type => 'BP');
22671: --
22672: END;
22745: --
22746: END IF;
22747: --
22748: IF l_new_assignment.max_effective_end_date <>
22749: NVL(l_new_assignment.actual_termination_date,hr_api.g_eot) THEN
22750: --
22751: hr_utility.set_message(800,'HR_6438_EMP_ASS_NOT_CONTIN');
22752: hr_utility.raise_error;
22753: --
22765: ,p_pop_date_start => l_old_assignment.period_of_placement_date_start
22766: ,p_new_primary_ass_id => p_assignment_id
22767: ,p_sdate => l_effective_date
22768: ,p_new_primary_flag => 'Y'
22769: ,p_mode => hr_api.g_update
22770: ,p_last_updated_by => TO_NUMBER(NULL)
22771: ,p_last_update_login => TO_NUMBER(NULL)
22772: );
22773: --
22783: ,p_pop_date_start => l_new_assignment.period_of_placement_date_start
22784: ,p_new_primary_ass_id => p_assignment_id
22785: ,p_sdate => l_effective_date
22786: ,p_new_primary_flag => 'Y'
22787: ,p_mode => hr_api.g_update
22788: ,p_last_updated_by => TO_NUMBER(NULL)
22789: ,p_last_update_login => TO_NUMBER(NULL)
22790: );
22791: --
22829: ,p_effective_end_date => l_new_assignment.effective_end_date);
22830: --
22831: EXCEPTION
22832: --
22833: WHEN hr_api.cannot_find_prog_unit THEN
22834: --
22835: hr_api.cannot_find_prog_unit_error
22836: (p_module_name => 'set_new_primary_cwk_asg'
22837: ,p_hook_type => 'AP');
22831: EXCEPTION
22832: --
22833: WHEN hr_api.cannot_find_prog_unit THEN
22834: --
22835: hr_api.cannot_find_prog_unit_error
22836: (p_module_name => 'set_new_primary_cwk_asg'
22837: ,p_hook_type => 'AP');
22838: --
22839: END;
22845: -- When in validation only mode raise validate enabled exception
22846: --
22847: IF p_validate THEN
22848: --
22849: RAISE hr_api.validate_enabled;
22850: --
22851: END IF;
22852: --
22853: -- Set OUT parameters
22861: end if;
22862: --
22863: EXCEPTION
22864: --
22865: WHEN hr_api.validate_enabled THEN
22866: --
22867: -- In validation only mode
22868: -- Rollback to savepoint
22869: -- Set relevant output warning parmeters
22952: ,p_assignment_status_type_id => p_assignment_status_type_id
22953: ,p_change_reason => p_change_reason
22954: );
22955: EXCEPTION
22956: WHEN hr_api.cannot_find_prog_unit
22957: THEN
22958: hr_api.cannot_find_prog_unit_error
22959: (p_module_name => 'INTERVIEW1_APL_ASG',
22960: p_hook_type => 'BP'
22954: );
22955: EXCEPTION
22956: WHEN hr_api.cannot_find_prog_unit
22957: THEN
22958: hr_api.cannot_find_prog_unit_error
22959: (p_module_name => 'INTERVIEW1_APL_ASG',
22960: p_hook_type => 'BP'
22961: );
22962: END;
22996: ,p_effective_start_date => l_effective_start_date
22997: ,p_effective_end_date => l_effective_end_date
22998: );
22999: EXCEPTION
23000: WHEN hr_api.cannot_find_prog_unit
23001: THEN
23002: hr_api.cannot_find_prog_unit_error
23003: (p_module_name => 'INTERVIEW1_APL_ASG',
23004: p_hook_type => 'AP'
22998: );
22999: EXCEPTION
23000: WHEN hr_api.cannot_find_prog_unit
23001: THEN
23002: hr_api.cannot_find_prog_unit_error
23003: (p_module_name => 'INTERVIEW1_APL_ASG',
23004: p_hook_type => 'AP'
23005: );
23006: END;
23012: -- When in validation only mode raise validate_enabled exception
23013: --
23014: IF p_validate
23015: THEN
23016: RAISE hr_api.validate_enabled;
23017: END IF;
23018: --
23019: -- Set OUT parameters
23020: --
23025: hr_utility.set_location(' Leaving:'||l_proc,100);
23026: end if;
23027: --
23028: EXCEPTION
23029: WHEN hr_api.validate_enabled
23030: THEN
23031: --
23032: -- In validation only mode
23033: -- Rollback to savepoint
23116: ,p_assignment_status_type_id => p_assignment_status_type_id
23117: ,p_change_reason => p_change_reason
23118: );
23119: EXCEPTION
23120: WHEN hr_api.cannot_find_prog_unit
23121: THEN
23122: hr_api.cannot_find_prog_unit_error
23123: (p_module_name => 'INTERVIEW2_APL_ASG',
23124: p_hook_type => 'BP'
23118: );
23119: EXCEPTION
23120: WHEN hr_api.cannot_find_prog_unit
23121: THEN
23122: hr_api.cannot_find_prog_unit_error
23123: (p_module_name => 'INTERVIEW2_APL_ASG',
23124: p_hook_type => 'BP'
23125: );
23126: END;
23160: ,p_effective_start_date => l_effective_start_date
23161: ,p_effective_end_date => l_effective_end_date
23162: );
23163: EXCEPTION
23164: WHEN hr_api.cannot_find_prog_unit
23165: THEN
23166: hr_api.cannot_find_prog_unit_error
23167: (p_module_name => 'INTERVIEW2_APL_ASG',
23168: p_hook_type => 'AP'
23162: );
23163: EXCEPTION
23164: WHEN hr_api.cannot_find_prog_unit
23165: THEN
23166: hr_api.cannot_find_prog_unit_error
23167: (p_module_name => 'INTERVIEW2_APL_ASG',
23168: p_hook_type => 'AP'
23169: );
23170: END;
23176: -- When in validation only mode raise validate_enabled exception
23177: --
23178: IF p_validate
23179: THEN
23180: RAISE hr_api.validate_enabled;
23181: END IF;
23182: --
23183: -- Set OUT parameters
23184: --
23189: hr_utility.set_location(' Leaving:'||l_proc,100);
23190: end if;
23191: --
23192: EXCEPTION
23193: WHEN hr_api.validate_enabled
23194: THEN
23195: --
23196: -- In validation only mode
23197: -- Rollback to savepoint
23302: ,p_datetrack_mode => p_datetrack_mode
23303: );
23304: --
23305: exception
23306: when hr_api.cannot_find_prog_unit then
23307: hr_api.cannot_find_prog_unit_error
23308: (p_module_name => 'DELETE_ASSIGNMENT'
23309: ,p_hook_type => 'BP'
23310: );
23303: );
23304: --
23305: exception
23306: when hr_api.cannot_find_prog_unit then
23307: hr_api.cannot_find_prog_unit_error
23308: (p_module_name => 'DELETE_ASSIGNMENT'
23309: ,p_hook_type => 'BP'
23310: );
23311: --
23350: ,p_life_events_exists => p_life_events_exists
23351: ,p_cobra_coverage_elements => p_cobra_coverage_elements
23352: ,p_assgt_term_elements => p_assgt_term_elements );
23353: exception
23354: when hr_api.cannot_find_prog_unit then
23355: hr_api.cannot_find_prog_unit_error
23356: (p_module_name => 'DELETE_ASSIGNMENT'
23357: ,p_hook_type => 'AP'
23358: );
23351: ,p_cobra_coverage_elements => p_cobra_coverage_elements
23352: ,p_assgt_term_elements => p_assgt_term_elements );
23353: exception
23354: when hr_api.cannot_find_prog_unit then
23355: hr_api.cannot_find_prog_unit_error
23356: (p_module_name => 'DELETE_ASSIGNMENT'
23357: ,p_hook_type => 'AP'
23358: );
23359: --
23362: end;
23363: --
23364:
23365: if p_validate then
23366: raise hr_api.validate_enabled;
23367: end if;
23368: --
23369: if g_debug then
23370: hr_utility.set_location(' Leaving:'||l_proc, 100);
23370: hr_utility.set_location(' Leaving:'||l_proc, 100);
23371: end if;
23372: --
23373: exception
23374: when hr_api.validate_enabled then
23375: --
23376: -- As the Validate_Enabled exception has been raised
23377: -- we must rollback to the savepoint
23378: --