[Home] [Help]
138: hr_utility.set_location('Leaving:'|| l_proc, 30);
139: end if;
140:
141: Exception
142: When HR_Api.Object_Locked then
143: --
144: -- This autonomous transaction was unable to lock the row.
145: -- It can be assumed that another transaction has locked the
146: -- row and is performing the update. Hence the error can
190: l_asg_end_date date;
191: l_cost_warning boolean;
192: l_assignment_status_id number;
193: l_date_recieved date;
194: l_eot date := hr_api.g_eot;
195: l_ass_status varchar2(20);
196: l_dummy varchar2(10);
197: l_asg_status_id number;
198: l_object_version_number number;
282:
283: l_apl_person_type_id number;
284: l_max_ptu_end_date date;
285: cursor get_max_end_date(p_date_received date) is
286: select nvl(max(effective_end_date),hr_api.g_eot)
287: from per_person_type_usages_f ptu, per_person_types ppt
288: where ptu.person_type_id = ppt.person_type_id
289: and ppt.system_person_type = 'APL'
290: and ptu.effective_start_date > p_date_received;
333: hr_utility.set_location('reverse_term_apln_fut - p_assignment_id:'|| p_assignment_id, 10);
334:
335: --
336: if p_status_change_reason is not null then
337: if hr_api.not_exists_in_dt_hr_lookups
338: (p_effective_date => p_effective_date
339: ,p_validation_start_date => p_effective_date
340: ,p_validation_end_date => p_effective_date
341: ,p_lookup_type => 'APL_ASSIGN_REASON'
670: l_asg_end_date date;
671: l_cost_warning boolean;
672: l_assignment_status_id number;
673: l_date_recieved date;
674: l_eot date := hr_api.g_eot;
675: l_ass_status varchar2(20);
676: l_dummy varchar2(10);
677: l_asg_status_id number;
678: l_object_version_number number;
797: hr_utility.set_location('REVERSE_TERM_APLN - p_assignment_id:'|| p_assignment_id, 10);
798:
799: --
800: if p_status_change_reason is not null then
801: if hr_api.not_exists_in_dt_hr_lookups
802: (p_effective_date => p_effective_date
803: ,p_validation_start_date => p_effective_date
804: ,p_validation_end_date => p_effective_date
805: ,p_lookup_type => 'APL_ASSIGN_REASON'
1184: hr_utility.set_location('Leaving:'|| l_proc, 30);
1185: end if;
1186:
1187: Exception
1188: When HR_Api.Object_Locked then
1189: --
1190: -- This autonomous transaction was unable to lock the row.
1191: -- It can be assumed that another transaction has locked the
1192: -- row and is performing the update. Hence the error can
1487:
1488: -- Start of Fix for Bug 2643451
1489: -- Start of Fix for Bug 2548555
1490: --
1491: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1488: -- Start of Fix for Bug 2643451
1489: -- Start of Fix for Bug 2548555
1490: --
1491: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1489: -- Start of Fix for Bug 2548555
1490: --
1491: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1490: --
1491: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1491: if nvl(l_scl_segment1,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment1 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1492: or nvl(l_scl_segment2,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment2 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1493: or nvl(l_scl_segment3,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment3 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1494: or nvl(l_scl_segment4,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment4 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1495: or nvl(l_scl_segment5,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment5 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1496: or nvl(l_scl_segment6,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment6 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1497: or nvl(l_scl_segment7,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment7 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1498: or nvl(l_scl_segment8,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment8 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1499: or nvl(l_scl_segment9,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment9 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1500: or nvl(l_scl_segment10,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment10 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1501: or nvl(l_scl_segment11,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment11 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1502: or nvl(l_scl_segment12,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment12 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1503: or nvl(l_scl_segment13,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment13 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1504: or nvl(l_scl_segment14,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment14 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1505: or nvl(l_scl_segment15,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment15 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1506: or nvl(l_scl_segment16,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment16 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1507: or nvl(l_scl_segment17,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment17 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1508: or nvl(l_scl_segment18,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment18 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1509: or nvl(l_scl_segment19,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment19 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1510: or nvl(l_scl_segment20,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment20 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1511: or nvl(l_scl_segment21,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment21 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1512: or nvl(l_scl_segment22,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment22 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1513: or nvl(l_scl_segment23,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment23 ,hr_api.g_varchar2)
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1521: -- bug 944911
1514: or nvl(l_scl_segment24,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment24 ,hr_api.g_varchar2)
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1521: -- bug 944911
1522: -- changed p_concatenated_segments to p_concat_segments
1515: or nvl(l_scl_segment25,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment25 ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1521: -- bug 944911
1522: -- changed p_concatenated_segments to p_concat_segments
1523: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
1516: or nvl(l_scl_segment26,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment26 ,hr_api.g_varchar2)
1517: or nvl(l_scl_segment27,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment27 ,hr_api.g_varchar2)
1518: or nvl(l_scl_segment28,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment28 ,hr_api.g_varchar2)
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1521: -- bug 944911
1522: -- changed p_concatenated_segments to p_concat_segments
1523: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
1524: --
1519: or nvl(l_scl_segment29,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment29 ,hr_api.g_varchar2)
1520: or nvl(l_scl_segment30,hr_api.g_varchar2) <> nvl(l_old_scl_segments.segment30 ,hr_api.g_varchar2)
1521: -- bug 944911
1522: -- changed p_concatenated_segments to p_concat_segments
1523: or nvl(p_concat_segments,hr_api.g_varchar2) <> nvl(l_old_scl_segments.concatenated_segments ,hr_api.g_varchar2)
1524: --
1525: -- End of Fix for Bug 2548555
1526: -- End of Fix for Bug 2643451
1527: --
1634: );
1635: --
1636: end if; -- csr_scl_idsel%NOTFOUND
1637: --
1638: end if; -- l_scl_segment1 <> hr_api.g_varchar2
1639: --
1640: end if; -- l_soft_coding_key_flex_id is null
1641:
1642: --
1642: --
1643: -- When in validation only mode raise the Validate_Enabled exception
1644: --
1645: if p_validate then
1646: raise hr_api.validate_enabled;
1647: end if;
1648:
1649: --
1650: -- Setting Output Variables
1653: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
1654:
1655:
1656: EXCEPTION
1657: when hr_api.validate_enabled then
1658: ROLLBACK TO validate_SCL;
1659:
1660: p_concatenated_segments := l_old_conc_segments;
1661:
1853: ,p_object_version_number => p_object_version_number
1854: ,p_assignment_status_type_id => p_assignment_status_type_id
1855: );
1856: exception
1857: when hr_api.cannot_find_prog_unit then
1858: hr_api.cannot_find_prog_unit_error
1859: (p_module_name => 'ACTIVATE_EMP_ASG',
1860: p_hook_type => 'BP'
1861: );
1854: ,p_assignment_status_type_id => p_assignment_status_type_id
1855: );
1856: exception
1857: when hr_api.cannot_find_prog_unit then
1858: hr_api.cannot_find_prog_unit_error
1859: (p_module_name => 'ACTIVATE_EMP_ASG',
1860: p_hook_type => 'BP'
1861: );
1862: end;
1892: ,p_effective_start_date => l_effective_start_date
1893: ,p_effective_end_date => l_effective_end_date
1894: );
1895: exception
1896: when hr_api.cannot_find_prog_unit then
1897: hr_api.cannot_find_prog_unit_error
1898: (p_module_name => 'ACTIVATE_EMP_ASG',
1899: p_hook_type => 'AP'
1900: );
1893: ,p_effective_end_date => l_effective_end_date
1894: );
1895: exception
1896: when hr_api.cannot_find_prog_unit then
1897: hr_api.cannot_find_prog_unit_error
1898: (p_module_name => 'ACTIVATE_EMP_ASG',
1899: p_hook_type => 'AP'
1900: );
1901: end;
1905: --
1906: -- When in validation only mode raise the Validate_Enabled exception
1907: --
1908: if p_validate then
1909: raise hr_api.validate_enabled;
1910: end if;
1911: --
1912: -- Set all output arguments
1913: --
1918: if g_debug then
1919: hr_utility.set_location(' Leaving:'||l_proc, 100);
1920: end if;
1921: exception
1922: when hr_api.validate_enabled then
1923: --
1924: -- As the Validate_Enabled exception has been raised
1925: -- we must rollback to the savepoint
1926: --
2021: ,p_object_version_number => p_object_version_number
2022: ,p_assignment_status_type_id => p_assignment_status_type_id
2023: );
2024: exception
2025: when hr_api.cannot_find_prog_unit then
2026: hr_api.cannot_find_prog_unit_error
2027: (p_module_name => 'ACTIVATE_CWK_ASG',
2028: p_hook_type => 'BP'
2029: );
2022: ,p_assignment_status_type_id => p_assignment_status_type_id
2023: );
2024: exception
2025: when hr_api.cannot_find_prog_unit then
2026: hr_api.cannot_find_prog_unit_error
2027: (p_module_name => 'ACTIVATE_CWK_ASG',
2028: p_hook_type => 'BP'
2029: );
2030: end;
2060: ,p_effective_start_date => l_effective_start_date
2061: ,p_effective_end_date => l_effective_end_date
2062: );
2063: exception
2064: when hr_api.cannot_find_prog_unit then
2065: hr_api.cannot_find_prog_unit_error
2066: (p_module_name => 'ACTIVATE_CWK_ASG',
2067: p_hook_type => 'AP'
2068: );
2061: ,p_effective_end_date => l_effective_end_date
2062: );
2063: exception
2064: when hr_api.cannot_find_prog_unit then
2065: hr_api.cannot_find_prog_unit_error
2066: (p_module_name => 'ACTIVATE_CWK_ASG',
2067: p_hook_type => 'AP'
2068: );
2069: end;
2073: --
2074: -- When in validation only mode raise the Validate_Enabled exception
2075: --
2076: if p_validate then
2077: raise hr_api.validate_enabled;
2078: end if;
2079: --
2080: -- Set all output arguments
2081: --
2086: if g_debug then
2087: hr_utility.set_location(' Leaving:'||l_proc, 100);
2088: end if;
2089: exception
2090: when hr_api.validate_enabled then
2091: --
2092: -- As the Validate_Enabled exception has been raised
2093: -- we must rollback to the savepoint
2094: --
2214: -- Validation in addition to Table Handlers
2215: --
2216: -- Get assignment and business group details for validation.
2217: --
2218: hr_api.mandatory_arg_error
2219: (p_api_name => l_proc
2220: ,p_argument => 'assignment_id'
2221: ,p_argument_value => p_assignment_id
2222: );
2220: ,p_argument => 'assignment_id'
2221: ,p_argument_value => p_assignment_id
2222: );
2223: --
2224: hr_api.mandatory_arg_error
2225: (p_api_name => l_proc
2226: ,p_argument => 'actual_termination_date'
2227: ,p_argument_value => l_actual_termination_date
2228: );
2264: ,p_assignment_status_type_id => p_assignment_status_type_id
2265: ,p_business_group_id => l_asg_business_group_id
2266: );
2267: exception
2268: when hr_api.cannot_find_prog_unit then
2269: hr_api.cannot_find_prog_unit_error
2270: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
2271: p_hook_type => 'BP'
2272: );
2265: ,p_business_group_id => l_asg_business_group_id
2266: );
2267: exception
2268: when hr_api.cannot_find_prog_unit then
2269: hr_api.cannot_find_prog_unit_error
2270: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
2271: p_hook_type => 'BP'
2272: );
2273: end;
2466: ,p_pay_proposal_warning => l_pay_proposal_warning
2467: ,p_business_group_id => l_asg_business_group_id
2468: );
2469: exception
2470: when hr_api.cannot_find_prog_unit then
2471: hr_api.cannot_find_prog_unit_error
2472: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
2473: p_hook_type => 'AP'
2474: );
2467: ,p_business_group_id => l_asg_business_group_id
2468: );
2469: exception
2470: when hr_api.cannot_find_prog_unit then
2471: hr_api.cannot_find_prog_unit_error
2472: (p_module_name => 'ACTUAL_TERMINATION_CWK_ASG',
2473: p_hook_type => 'AP'
2474: );
2475: end;
2476: --
2477: -- End of API User Hook for the after hook of actual_termination_cwk_asg.
2478: --
2479: if p_validate then
2480: raise hr_api.validate_enabled;
2481: end if;
2482: --
2483: -- Set all output arguments
2484: --
2492: if g_debug then
2493: hr_utility.set_location(' Leaving:'||l_proc, 200);
2494: end if;
2495: exception
2496: when hr_api.validate_enabled then
2497: --
2498: -- As the Validate_Enabled exception has been raised
2499: -- we must rollback to the savepoint
2500: --
2615: -- Validation in addition to Table Handlers
2616: --
2617: -- Get assignment and business group details for validation.
2618: --
2619: hr_api.mandatory_arg_error
2620: (p_api_name => l_proc
2621: ,p_argument => 'assignment_id'
2622: ,p_argument_value => p_assignment_id
2623: );
2621: ,p_argument => 'assignment_id'
2622: ,p_argument_value => p_assignment_id
2623: );
2624: --
2625: hr_api.mandatory_arg_error
2626: (p_api_name => l_proc
2627: ,p_argument => 'final_process_date'
2628: ,p_argument_value => l_final_process_date
2629: );
2660: ,p_object_version_number => p_object_version_number
2661: ,p_final_process_date => l_final_process_date
2662: );
2663: exception
2664: when hr_api.cannot_find_prog_unit then
2665: hr_api.cannot_find_prog_unit_error
2666: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2667: p_hook_type => 'BP'
2668: );
2661: ,p_final_process_date => l_final_process_date
2662: );
2663: exception
2664: when hr_api.cannot_find_prog_unit then
2665: hr_api.cannot_find_prog_unit_error
2666: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2667: p_hook_type => 'BP'
2668: );
2669: end;
2711: into l_max_asg_end_date;
2712: close csr_invalid_term_assign;
2713:
2714: --
2715: if l_max_asg_end_date <> hr_api.g_eot
2716: then
2717: --
2718: if g_debug then
2719: hr_utility.set_location(l_proc, 90);
2806: ,p_asg_future_changes_warning => l_asg_future_changes_warning
2807: ,p_entries_changed_warning => l_entries_changed_warning
2808: );
2809: exception
2810: when hr_api.cannot_find_prog_unit then
2811: hr_api.cannot_find_prog_unit_error
2812: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2813: p_hook_type => 'AP'
2814: );
2807: ,p_entries_changed_warning => l_entries_changed_warning
2808: );
2809: exception
2810: when hr_api.cannot_find_prog_unit then
2811: hr_api.cannot_find_prog_unit_error
2812: (p_module_name => 'FINAL_PROCESS_CWK_ASG',
2813: p_hook_type => 'AP'
2814: );
2815: end;
2819: --
2820: -- When in validation only mode raise the Validate_Enabled exception
2821: --
2822: if p_validate then
2823: raise hr_api.validate_enabled;
2824: end if;
2825: --
2826: -- Set all output arguments
2827: --
2835: if g_debug then
2836: hr_utility.set_location(' Leaving:'||l_proc, 300);
2837: end if;
2838: exception
2839: when hr_api.validate_enabled then
2840: --
2841: -- As the Validate_Enabled exception has been raised
2842: -- we must rollback to the savepoint
2843: --
2940: ,p_object_version_number => p_object_version_number
2941: ,p_assignment_status_type_id => p_assignment_status_type_id
2942: );
2943: exception
2944: when hr_api.cannot_find_prog_unit then
2945: hr_api.cannot_find_prog_unit_error
2946: (p_module_name => 'SUSPEND_CWK_ASG',
2947: p_hook_type => 'BP'
2948: );
2941: ,p_assignment_status_type_id => p_assignment_status_type_id
2942: );
2943: exception
2944: when hr_api.cannot_find_prog_unit then
2945: hr_api.cannot_find_prog_unit_error
2946: (p_module_name => 'SUSPEND_CWK_ASG',
2947: p_hook_type => 'BP'
2948: );
2949: end;
2980: ,p_effective_start_date => l_effective_start_date
2981: ,p_effective_end_date => l_effective_end_date
2982: );
2983: exception
2984: when hr_api.cannot_find_prog_unit then
2985: hr_api.cannot_find_prog_unit_error
2986: (p_module_name => 'SUSPEND_CWK_ASG',
2987: p_hook_type => 'AP'
2988: );
2981: ,p_effective_end_date => l_effective_end_date
2982: );
2983: exception
2984: when hr_api.cannot_find_prog_unit then
2985: hr_api.cannot_find_prog_unit_error
2986: (p_module_name => 'SUSPEND_CWK_ASG',
2987: p_hook_type => 'AP'
2988: );
2989: end;
2993: --
2994: -- When in validation only mode raise the Validate_Enabled exception
2995: --
2996: if p_validate then
2997: raise hr_api.validate_enabled;
2998: end if;
2999: --
3000: -- Set all output arguments
3001: --
3006: if g_debug then
3007: hr_utility.set_location(' Leaving:'||l_proc, 100);
3008: end if;
3009: exception
3010: when hr_api.validate_enabled then
3011: --
3012: -- As the Validate_Enabled exception has been raised
3013: -- we must rollback to the savepoint
3014: --
3130: -- Validation in addition to Table Handlers
3131: --
3132: -- Get assignment and business group details for validation.
3133: --
3134: hr_api.mandatory_arg_error
3135: (p_api_name => l_proc
3136: ,p_argument => 'assignment_id'
3137: ,p_argument_value => p_assignment_id
3138: );
3136: ,p_argument => 'assignment_id'
3137: ,p_argument_value => p_assignment_id
3138: );
3139: --
3140: hr_api.mandatory_arg_error
3141: (p_api_name => l_proc
3142: ,p_argument => 'actual_termination_date'
3143: ,p_argument_value => l_actual_termination_date
3144: );
3180: ,p_assignment_status_type_id => p_assignment_status_type_id
3181: ,p_business_group_id => l_asg_business_group_id
3182: );
3183: exception
3184: when hr_api.cannot_find_prog_unit then
3185: hr_api.cannot_find_prog_unit_error
3186: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
3187: p_hook_type => 'BP'
3188: );
3181: ,p_business_group_id => l_asg_business_group_id
3182: );
3183: exception
3184: when hr_api.cannot_find_prog_unit then
3185: hr_api.cannot_find_prog_unit_error
3186: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
3187: p_hook_type => 'BP'
3188: );
3189: end;
3381: ,p_pay_proposal_warning => l_pay_proposal_warning
3382: ,p_business_group_id => l_asg_business_group_id
3383: );
3384: exception
3385: when hr_api.cannot_find_prog_unit then
3386: hr_api.cannot_find_prog_unit_error
3387: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
3388: p_hook_type => 'AP'
3389: );
3382: ,p_business_group_id => l_asg_business_group_id
3383: );
3384: exception
3385: when hr_api.cannot_find_prog_unit then
3386: hr_api.cannot_find_prog_unit_error
3387: (p_module_name => 'ACTUAL_TERMINATION_EMP_ASG',
3388: p_hook_type => 'AP'
3389: );
3390: end;
3391: --
3392: -- End of API User Hook for the after hook of actual_termination_emp_asg.
3393: --
3394: if p_validate then
3395: raise hr_api.validate_enabled;
3396: end if;
3397: --
3398: -- Set all output arguments
3399: --
3407: if g_debug then
3408: hr_utility.set_location(' Leaving:'||l_proc, 200);
3409: end if;
3410: exception
3411: when hr_api.validate_enabled then
3412: --
3413: -- As the Validate_Enabled exception has been raised
3414: -- we must rollback to the savepoint
3415: --
5556: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
5557: ,p_supervisor_assignment_id => p_supervisor_assignment_id
5558: );
5559: exception
5560: when hr_api.cannot_find_prog_unit then
5561: hr_api.cannot_find_prog_unit_error
5562: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
5563: ,p_hook_type => 'BP'
5564: );
5557: ,p_supervisor_assignment_id => p_supervisor_assignment_id
5558: );
5559: exception
5560: when hr_api.cannot_find_prog_unit then
5561: hr_api.cannot_find_prog_unit_error
5562: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
5563: ,p_hook_type => 'BP'
5564: );
5565: --
5574: -- Validation in addition to Table Handlers
5575: --
5576: -- Get person details.
5577: --
5578: hr_api.mandatory_arg_error
5579: (p_api_name => l_proc
5580: ,p_argument => 'person_id'
5581: ,p_argument_value => p_person_id
5582: );
5580: ,p_argument => 'person_id'
5581: ,p_argument_value => p_person_id
5582: );
5583: --
5584: hr_api.mandatory_arg_error
5585: (p_api_name => l_proc
5586: ,p_argument => 'effective_date'
5587: ,p_argument_value => l_effective_date
5588: );
6187: --
6188: ,p_scl_concat_segments => l_old_scl_conc_segments
6189: );
6190: exception
6191: when hr_api.cannot_find_prog_unit then
6192: hr_api.cannot_find_prog_unit_error
6193: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
6194: ,p_hook_type => 'AP'
6195: );
6188: ,p_scl_concat_segments => l_old_scl_conc_segments
6189: );
6190: exception
6191: when hr_api.cannot_find_prog_unit then
6192: hr_api.cannot_find_prog_unit_error
6193: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
6194: ,p_hook_type => 'AP'
6195: );
6196: --
6211: --
6212: -- When in validation only mode raise the Validate_Enabled exception
6213: --
6214: if p_validate then
6215: raise hr_api.validate_enabled;
6216: end if;
6217: --
6218: -- Set remaining output arguments
6219: --
6240: if g_debug then
6241: hr_utility.set_location(' Leaving:'||l_proc, 50);
6242: end if;
6243: exception
6244: when hr_api.validate_enabled then
6245: --
6246: -- As the Validate_Enabled exception has been raised
6247: -- we must rollback to the savepoint
6248: --
6713: ,p_supervisor_assignment_id => p_supervisor_assignment_id
6714: );
6715: --
6716: EXCEPTION
6717: WHEN hr_api.cannot_find_prog_unit THEN
6718: hr_api.cannot_find_prog_unit_error
6719: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6720: ,p_hook_type => 'BP');
6721: --
6714: );
6715: --
6716: EXCEPTION
6717: WHEN hr_api.cannot_find_prog_unit THEN
6718: hr_api.cannot_find_prog_unit_error
6719: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
6720: ,p_hook_type => 'BP');
6721: --
6722: -- End of API User Hook for the before hook of create_secondary_emp_asg
6730: -- Validation in addition to Table Handlers
6731: --
6732: -- Get person details.
6733: --
6734: hr_api.mandatory_arg_error
6735: (p_api_name => l_proc
6736: ,p_argument => 'person_id'
6737: ,p_argument_value => p_person_id
6738: );
6736: ,p_argument => 'person_id'
6737: ,p_argument_value => p_person_id
6738: );
6739: --
6740: hr_api.mandatory_arg_error
6741: (p_api_name => l_proc
6742: ,p_argument => 'effective_date'
6743: ,p_argument_value => l_effective_date
6744: );
7323: );
7324: --
7325: EXCEPTION
7326: --
7327: WHEN hr_api.cannot_find_prog_unit THEN
7328: --
7329: hr_api.cannot_find_prog_unit_error
7330: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
7331: ,p_hook_type => 'AP');
7325: EXCEPTION
7326: --
7327: WHEN hr_api.cannot_find_prog_unit THEN
7328: --
7329: hr_api.cannot_find_prog_unit_error
7330: (p_module_name => 'CREATE_SECONDARY_CWK_ASG'
7331: ,p_hook_type => 'AP');
7332: --
7333: -- End of API User Hook for the after hook of create_secondary_emp_asg
7337: -- When in validation only mode raise the Validate_Enabled exception
7338: --
7339: IF p_validate THEN
7340: --
7341: RAISE hr_api.validate_enabled;
7342: --
7343: END IF;
7344: --
7345: -- Set remaining output arguments
7367: end if;
7368: --
7369: EXCEPTION
7370: --
7371: WHEN hr_api.validate_enabled THEN
7372: --
7373: -- As the Validate_Enabled exception has been raised
7374: -- we must rollback to the savepoint
7375: --
8979: -- Validation in addition to Table Handlers
8980: --
8981: -- Get assignment and business group details for validation.
8982: --
8983: hr_api.mandatory_arg_error
8984: (p_api_name => l_proc
8985: ,p_argument => 'assignment_id'
8986: ,p_argument_value => p_assignment_id
8987: );
8985: ,p_argument => 'assignment_id'
8986: ,p_argument_value => p_assignment_id
8987: );
8988: --
8989: hr_api.mandatory_arg_error
8990: (p_api_name => l_proc
8991: ,p_argument => 'final_process_date'
8992: ,p_argument_value => l_final_process_date
8993: );
9024: ,p_object_version_number => p_object_version_number
9025: ,p_final_process_date => l_final_process_date
9026: );
9027: exception
9028: when hr_api.cannot_find_prog_unit then
9029: hr_api.cannot_find_prog_unit_error
9030: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
9031: p_hook_type => 'BP'
9032: );
9025: ,p_final_process_date => l_final_process_date
9026: );
9027: exception
9028: when hr_api.cannot_find_prog_unit then
9029: hr_api.cannot_find_prog_unit_error
9030: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
9031: p_hook_type => 'BP'
9032: );
9033: end;
9075: into l_max_asg_end_date;
9076: close csr_invalid_term_assign;
9077:
9078: --
9079: if l_max_asg_end_date <> hr_api.g_eot
9080: then
9081: --
9082: if g_debug then
9083: hr_utility.set_location(l_proc, 90);
9163: ,p_asg_future_changes_warning => l_asg_future_changes_warning
9164: ,p_entries_changed_warning => l_entries_changed_warning
9165: );
9166: exception
9167: when hr_api.cannot_find_prog_unit then
9168: hr_api.cannot_find_prog_unit_error
9169: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
9170: p_hook_type => 'AP'
9171: );
9164: ,p_entries_changed_warning => l_entries_changed_warning
9165: );
9166: exception
9167: when hr_api.cannot_find_prog_unit then
9168: hr_api.cannot_find_prog_unit_error
9169: (p_module_name => 'FINAL_PROCESS_EMP_ASG',
9170: p_hook_type => 'AP'
9171: );
9172: end;
9176: --
9177: -- When in validation only mode raise the Validate_Enabled exception
9178: --
9179: if p_validate then
9180: raise hr_api.validate_enabled;
9181: end if;
9182: --
9183: -- Set all output arguments
9184: --
9192: if g_debug then
9193: hr_utility.set_location(' Leaving:'||l_proc, 300);
9194: end if;
9195: exception
9196: when hr_api.validate_enabled then
9197: --
9198: -- As the Validate_Enabled exception has been raised
9199: -- we must rollback to the savepoint
9200: --
9302: ,p_object_version_number => p_object_version_number
9303: ,p_assignment_status_type_id => p_assignment_status_type_id
9304: );
9305: exception
9306: when hr_api.cannot_find_prog_unit then
9307: hr_api.cannot_find_prog_unit_error
9308: (p_module_name => 'SUSPEND_EMP_ASG',
9309: p_hook_type => 'BP'
9310: );
9303: ,p_assignment_status_type_id => p_assignment_status_type_id
9304: );
9305: exception
9306: when hr_api.cannot_find_prog_unit then
9307: hr_api.cannot_find_prog_unit_error
9308: (p_module_name => 'SUSPEND_EMP_ASG',
9309: p_hook_type => 'BP'
9310: );
9311: end;
9342: ,p_effective_start_date => l_effective_start_date
9343: ,p_effective_end_date => l_effective_end_date
9344: );
9345: exception
9346: when hr_api.cannot_find_prog_unit then
9347: hr_api.cannot_find_prog_unit_error
9348: (p_module_name => 'SUSPEND_EMP_ASG',
9349: p_hook_type => 'AP'
9350: );
9343: ,p_effective_end_date => l_effective_end_date
9344: );
9345: exception
9346: when hr_api.cannot_find_prog_unit then
9347: hr_api.cannot_find_prog_unit_error
9348: (p_module_name => 'SUSPEND_EMP_ASG',
9349: p_hook_type => 'AP'
9350: );
9351: end;
9355: --
9356: -- When in validation only mode raise the Validate_Enabled exception
9357: --
9358: if p_validate then
9359: raise hr_api.validate_enabled;
9360: end if;
9361: --
9362: -- Set all output arguments
9363: --
9368: if g_debug then
9369: hr_utility.set_location(' Leaving:'||l_proc, 100);
9370: end if;
9371: exception
9372: when hr_api.validate_enabled then
9373: --
9374: -- As the Validate_Enabled exception has been raised
9375: -- we must rollback to the savepoint
9376: --
9636: ,p_segment28 => p_segment28
9637: ,p_segment29 => p_segment29
9638: ,p_segment30 => p_segment30
9639: ,p_concat_segments => p_concat_segments
9640: ,p_contract_id => hr_api.g_number
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9637: ,p_segment29 => p_segment29
9638: ,p_segment30 => p_segment30
9639: ,p_concat_segments => p_concat_segments
9640: ,p_contract_id => hr_api.g_number
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9638: ,p_segment30 => p_segment30
9639: ,p_concat_segments => p_concat_segments
9640: ,p_contract_id => hr_api.g_number
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9639: ,p_concat_segments => p_concat_segments
9640: ,p_contract_id => hr_api.g_number
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9640: ,p_contract_id => hr_api.g_number
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9641: ,p_establishment_id => hr_api.g_number
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9642: ,p_collective_agreement_id => hr_api.g_number
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9643: ,p_cagr_id_flex_num => hr_api.g_number
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9644: ,p_cag_segment1 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9645: ,p_cag_segment2 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9646: ,p_cag_segment3 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9647: ,p_cag_segment4 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9648: ,p_cag_segment5 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9649: ,p_cag_segment6 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9650: ,p_cag_segment7 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9651: ,p_cag_segment8 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9652: ,p_cag_segment9 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9653: ,p_cag_segment10 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9654: ,p_cag_segment11 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9655: ,p_cag_segment12 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9663: ,p_cag_segment20 => hr_api.g_varchar2
9656: ,p_cag_segment13 => hr_api.g_varchar2
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9663: ,p_cag_segment20 => hr_api.g_varchar2
9664: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9657: ,p_cag_segment14 => hr_api.g_varchar2
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9663: ,p_cag_segment20 => hr_api.g_varchar2
9664: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9665: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9658: ,p_cag_segment15 => hr_api.g_varchar2
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9663: ,p_cag_segment20 => hr_api.g_varchar2
9664: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9665: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9666: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
9659: ,p_cag_segment16 => hr_api.g_varchar2
9660: ,p_cag_segment17 => hr_api.g_varchar2
9661: ,p_cag_segment18 => hr_api.g_varchar2
9662: ,p_cag_segment19 => hr_api.g_varchar2
9663: ,p_cag_segment20 => hr_api.g_varchar2
9664: ,p_cagr_grade_def_id => l_cagr_grade_def_id
9665: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
9666: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
9667: ,p_comment_id => l_comment_id
10987: ,p_job_post_source_name => p_job_post_source_name
10988: ,p_supervisor_assignment_id => p_supervisor_assignment_id
10989: );
10990: exception
10991: when hr_api.cannot_find_prog_unit then
10992: hr_api.cannot_find_prog_unit_error
10993: (p_module_name => 'UPDATE_EMP_ASG'
10994: ,p_hook_type => 'BP'
10995: );
10988: ,p_supervisor_assignment_id => p_supervisor_assignment_id
10989: );
10990: exception
10991: when hr_api.cannot_find_prog_unit then
10992: hr_api.cannot_find_prog_unit_error
10993: (p_module_name => 'UPDATE_EMP_ASG'
10994: ,p_hook_type => 'BP'
10995: );
10996: --
11005: -- Validation in addition to Table Handlers
11006: --
11007: -- Get assignment type.
11008: --
11009: hr_api.mandatory_arg_error
11010: (p_api_name => l_proc
11011: ,p_argument => 'assignment_id'
11012: ,p_argument_value => p_assignment_id);
11013: --
11010: (p_api_name => l_proc
11011: ,p_argument => 'assignment_id'
11012: ,p_argument_value => p_assignment_id);
11013: --
11014: hr_api.mandatory_arg_error
11015: (p_api_name => l_proc
11016: ,p_argument => 'effective_date'
11017: ,p_argument_value => l_effective_date);
11018: --
11046: end if;
11047: --
11048: --added validation for bug 1867720
11049: --
11050: if p_assignment_status_type_id <> hr_api.g_number then
11051: open csr_old_asg_status;
11052: fetch csr_old_asg_status into l_old_asg_status;
11053: close csr_old_asg_status;
11054: --
11112: close csr_get_soft_coding_keyflex;
11113: --
11114: -- Start of Fix for Bug 2548555
11115: --
11116: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11113: --
11114: -- Start of Fix for Bug 2548555
11115: --
11116: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11114: -- Start of Fix for Bug 2548555
11115: --
11116: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11115: --
11116: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11116: if nvl(l_scl_segment1,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11117: or nvl(l_scl_segment2,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11118: or nvl(l_scl_segment3,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11119: or nvl(l_scl_segment4,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11120: or nvl(l_scl_segment5,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11121: or nvl(l_scl_segment6,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11122: or nvl(l_scl_segment7,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11123: or nvl(l_scl_segment8,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11124: or nvl(l_scl_segment9,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11125: or nvl(l_scl_segment10,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11126: or nvl(l_scl_segment11,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11127: or nvl(l_scl_segment12,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11128: or nvl(l_scl_segment13,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11129: or nvl(l_scl_segment14,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11130: or nvl(l_scl_segment15,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11131: or nvl(l_scl_segment16,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11132: or nvl(l_scl_segment17,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11133: or nvl(l_scl_segment18,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11134: or nvl(l_scl_segment19,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11135: or nvl(l_scl_segment20,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11136: or nvl(l_scl_segment21,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11137: or nvl(l_scl_segment22,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11138: or nvl(l_scl_segment23,'x') <> hr_api.g_varchar2
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11146: -- bug 944911
11139: or nvl(l_scl_segment24,'x') <> hr_api.g_varchar2
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11146: -- bug 944911
11147: -- changed p_concatenated_segments to p_concat_segments
11140: or nvl(l_scl_segment25,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11146: -- bug 944911
11147: -- changed p_concatenated_segments to p_concat_segments
11148: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
11141: or nvl(l_scl_segment26,'x') <> hr_api.g_varchar2
11142: or nvl(l_scl_segment27,'x') <> hr_api.g_varchar2
11143: or nvl(l_scl_segment28,'x') <> hr_api.g_varchar2
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11146: -- bug 944911
11147: -- changed p_concatenated_segments to p_concat_segments
11148: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
11149: --
11144: or nvl(l_scl_segment29,'x') <> hr_api.g_varchar2
11145: or nvl(l_scl_segment30,'x') <> hr_api.g_varchar2
11146: -- bug 944911
11147: -- changed p_concatenated_segments to p_concat_segments
11148: or nvl(p_concat_segments,'x') <> hr_api.g_varchar2
11149: --
11150: -- End of Fix for Bug 2548555
11151: --
11152: then
11249: );
11250: --
11251: end if; -- csr_scl_idsel%NOTFOUND
11252: --
11253: end if; -- l_scl_segment1 <> hr_api.g_varchar2
11254: --
11255: end if; -- l_soft_coding_key_flex_id is null
11256: --
11257: Added By FS */
11327: -- function allows that function to derive the old values.
11328: --
11329: l_cagr_id_flex_num := p_cagr_id_flex_num;
11330: --
11331: if (p_cagr_id_flex_num = hr_api.g_number)
11332: then
11333: per_asg_shd.lck
11334: (p_effective_date => l_effective_date,
11335: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
11387: hr_utility.set_location(l_proc, 25);
11388: end if;
11389:
11390: -- fix for bug 6595592 starts here.
11391: if (p_projected_assignment_end = to_char(hr_api.g_date) OR p_projected_assignment_end = hr_api.g_varchar2) then --fix for 6862763
11392: --l_projected_assignment_end :=hr_api.g_date; -- commented for bug#14002201
11393: --l_projected_assignment_end :=hr_api.g_eot; -- added for bug#14002201
11394:
11395: l_projected_assignment_end := null; -- added for bug#14470849
11388: end if;
11389:
11390: -- fix for bug 6595592 starts here.
11391: if (p_projected_assignment_end = to_char(hr_api.g_date) OR p_projected_assignment_end = hr_api.g_varchar2) then --fix for 6862763
11392: --l_projected_assignment_end :=hr_api.g_date; -- commented for bug#14002201
11393: --l_projected_assignment_end :=hr_api.g_eot; -- added for bug#14002201
11394:
11395: l_projected_assignment_end := null; -- added for bug#14470849
11396:
11389:
11390: -- fix for bug 6595592 starts here.
11391: if (p_projected_assignment_end = to_char(hr_api.g_date) OR p_projected_assignment_end = hr_api.g_varchar2) then --fix for 6862763
11392: --l_projected_assignment_end :=hr_api.g_date; -- commented for bug#14002201
11393: --l_projected_assignment_end :=hr_api.g_eot; -- added for bug#14002201
11394:
11395: l_projected_assignment_end := null; -- added for bug#14470849
11396:
11397: else
11650: ,p_hourly_salaried_warning => l_hourly_salaried_warning
11651: ,p_supervisor_assignment_id => p_supervisor_assignment_id
11652: );
11653: exception
11654: when hr_api.cannot_find_prog_unit then
11655: hr_api.cannot_find_prog_unit_error
11656: (p_module_name => 'UPDATE_EMP_ASG'
11657: ,p_hook_type => 'AP'
11658: );
11651: ,p_supervisor_assignment_id => p_supervisor_assignment_id
11652: );
11653: exception
11654: when hr_api.cannot_find_prog_unit then
11655: hr_api.cannot_find_prog_unit_error
11656: (p_module_name => 'UPDATE_EMP_ASG'
11657: ,p_hook_type => 'AP'
11658: );
11659: --
11674: --
11675: -- When in validation only mode raise the Validate_Enabled exception
11676: --
11677: if p_validate then
11678: raise hr_api.validate_enabled;
11679: end if;
11680: --
11681: -- Set all output arguments
11682: --
11701: hr_utility.set_location(' Leaving:'||l_proc, 30);
11702: hr_utility.set_location('EMP Asg Leaving:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
11703: end if;
11704: exception
11705: when hr_api.validate_enabled then
11706: --
11707: -- As the Validate_Enabled exception has been raised
11708: -- we must rollback to the savepoint
11709: --
12099: );
12100: --
12101: EXCEPTION
12102: --
12103: WHEN hr_api.cannot_find_prog_unit THEN
12104: --
12105: hr_api.cannot_find_prog_unit_error
12106: (p_module_name => 'UPDATE_CWK_ASG'
12107: ,p_hook_type => 'BP'
12101: EXCEPTION
12102: --
12103: WHEN hr_api.cannot_find_prog_unit THEN
12104: --
12105: hr_api.cannot_find_prog_unit_error
12106: (p_module_name => 'UPDATE_CWK_ASG'
12107: ,p_hook_type => 'BP'
12108: );
12109: --
12118: -- Validation in addition to Table Handlers
12119: --
12120: -- Get assignment type.
12121: --
12122: hr_api.mandatory_arg_error
12123: (p_api_name => l_proc
12124: ,p_argument => 'assignment_id'
12125: ,p_argument_value => p_assignment_id);
12126: --
12123: (p_api_name => l_proc
12124: ,p_argument => 'assignment_id'
12125: ,p_argument_value => p_assignment_id);
12126: --
12127: hr_api.mandatory_arg_error
12128: (p_api_name => l_proc
12129: ,p_argument => 'effective_date'
12130: ,p_argument_value => l_effective_date);
12131: --
12164: end if;
12165: --
12166: --added validation for bug 1867720
12167: --
12168: IF p_assignment_status_type_id <> hr_api.g_number THEN
12169: --
12170: OPEN csr_old_asg_status;
12171: FETCH csr_old_asg_status INTO l_old_asg_status;
12172: CLOSE csr_old_asg_status;
12202: --
12203: -- Bug 944911
12204: -- Added to next 2 ifs check for p_concatenated_segments also
12205: --
12206: if p_scl_segment1 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12203: -- Bug 944911
12204: -- Added to next 2 ifs check for p_concatenated_segments also
12205: --
12206: if p_scl_segment1 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12204: -- Added to next 2 ifs check for p_concatenated_segments also
12205: --
12206: if p_scl_segment1 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12205: --
12206: if p_scl_segment1 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12206: if p_scl_segment1 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12207: or p_scl_segment2 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12208: or p_scl_segment3 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12209: or p_scl_segment4 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12210: or p_scl_segment5 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12211: or p_scl_segment6 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12212: or p_scl_segment7 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12213: or p_scl_segment8 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12214: or p_scl_segment9 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12215: or p_scl_segment10 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12216: or p_scl_segment11 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12217: or p_scl_segment12 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12218: or p_scl_segment13 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12219: or p_scl_segment14 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12220: or p_scl_segment15 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12221: or p_scl_segment16 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12222: or p_scl_segment17 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12223: or p_scl_segment18 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12224: or p_scl_segment19 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12225: or p_scl_segment20 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12226: or p_scl_segment21 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12227: or p_scl_segment22 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12228: or p_scl_segment23 <> hr_api.g_varchar2
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12236: -- bug 944911
12229: or p_scl_segment24 <> hr_api.g_varchar2
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12236: -- bug 944911
12237: -- changed p_concatenated_segments to p_concat_segments
12230: or p_scl_segment25 <> hr_api.g_varchar2
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12236: -- bug 944911
12237: -- changed p_concatenated_segments to p_concat_segments
12238: or p_concat_segments <> hr_api.g_varchar2 then
12231: or p_scl_segment26 <> hr_api.g_varchar2
12232: or p_scl_segment27 <> hr_api.g_varchar2
12233: or p_scl_segment28 <> hr_api.g_varchar2
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12236: -- bug 944911
12237: -- changed p_concatenated_segments to p_concat_segments
12238: or p_concat_segments <> hr_api.g_varchar2 then
12239: --
12234: or p_scl_segment29 <> hr_api.g_varchar2
12235: or p_scl_segment30 <> hr_api.g_varchar2
12236: -- bug 944911
12237: -- changed p_concatenated_segments to p_concat_segments
12238: or p_concat_segments <> hr_api.g_varchar2 then
12239: --
12240: OPEN csr_scl_idsel;
12241: FETCH csr_scl_idsel INTO l_flex_num;
12242: --
12409: -- function allows that function to derive the old values.
12410: --
12411: l_cagr_id_flex_num := p_cagr_id_flex_num;
12412: --
12413: If (p_cagr_id_flex_num = hr_api.g_number) THEN
12414: --
12415: per_asg_shd.lck
12416: (p_effective_date => l_effective_date,
12417: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
12669: );
12670: --
12671: EXCEPTION
12672: --
12673: WHEN hr_api.cannot_find_prog_unit THEN
12674: --
12675: hr_api.cannot_find_prog_unit_error
12676: (p_module_name => 'UPDATE_CWK_ASG'
12677: ,p_hook_type => 'AP'
12671: EXCEPTION
12672: --
12673: WHEN hr_api.cannot_find_prog_unit THEN
12674: --
12675: hr_api.cannot_find_prog_unit_error
12676: (p_module_name => 'UPDATE_CWK_ASG'
12677: ,p_hook_type => 'AP'
12678: );
12679: --
12684: -- When in validation only mode raise the Validate_Enabled exception
12685: --
12686: IF p_validate THEN
12687: --
12688: RAISE hr_api.validate_enabled;
12689: --
12690: END IF;
12691: --
12692: -- Set all output arguments
12711: end if;
12712: --
12713: EXCEPTION
12714: --
12715: WHEN hr_api.validate_enabled THEN
12716: --
12717: -- As the Validate_Enabled exception has been raised
12718: -- we must rollback to the savepoint
12719: --
13039: ,p_concat_segments => l_old_group_name);
13040: --
13041: EXCEPTION
13042: --
13043: WHEN hr_api.cannot_find_prog_unit THEN
13044: --
13045: hr_api.cannot_find_prog_unit_error
13046: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
13047: ,p_hook_type => 'BP');
13041: EXCEPTION
13042: --
13043: WHEN hr_api.cannot_find_prog_unit THEN
13044: --
13045: hr_api.cannot_find_prog_unit_error
13046: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
13047: ,p_hook_type => 'BP');
13048: --
13049: -- End of API User Hook for the before hook of update_emp_cwk_criteria
13130: -- insert the profile options and effective date for the flexfield
13131: -- validation to work
13132: --
13133: --
13134: IF (l_org_id = hr_api.g_number) THEN -- Bug 3553286
13135: --
13136: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
13137: --
13138: ELSE
13140: l_organization_id := l_org_id; -- Bug 3553286
13141: --
13142: END IF;
13143: --
13144: IF (p_location_id=hr_api.g_number) THEN
13145: --
13146: l_location_id:=per_asg_shd.g_old_rec.location_id;
13147: --
13148: ELSE
13185: --
13186: -- Only call the flex code if a non-default value(includng null) is passed
13187: -- to the procedure.
13188: --
13189: if nvl(p_segment1,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13186: -- Only call the flex code if a non-default value(includng null) is passed
13187: -- to the procedure.
13188: --
13189: if nvl(p_segment1,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13187: -- to the procedure.
13188: --
13189: if nvl(p_segment1,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13188: --
13189: if nvl(p_segment1,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13189: if nvl(p_segment1,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13190: or nvl(p_segment2,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13191: or nvl(p_segment3,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13192: or nvl(p_segment4,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13193: or nvl(p_segment5,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13194: or nvl(p_segment6,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13195: or nvl(p_segment7,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13196: or nvl(p_segment8,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13197: or nvl(p_segment9,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13198: or nvl(p_segment10,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13199: or nvl(p_segment11,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13200: or nvl(p_segment12,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13201: or nvl(p_segment13,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13202: or nvl(p_segment14,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13203: or nvl(p_segment15,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13204: or nvl(p_segment16,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13205: or nvl(p_segment17,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13206: or nvl(p_segment18,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13207: or nvl(p_segment19,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13208: or nvl(p_segment20,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13209: or nvl(p_segment21,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13210: or nvl(p_segment22,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13211: or nvl(p_segment23,'X') <> hr_api.g_varchar2
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13212: or nvl(p_segment24,'X') <> hr_api.g_varchar2
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13220: --
13213: or nvl(p_segment25,'X') <> hr_api.g_varchar2
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13220: --
13221: hr_kflex_utility.upd_or_sel_keyflex_comb
13214: or nvl(p_segment26,'X') <> hr_api.g_varchar2
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13220: --
13221: hr_kflex_utility.upd_or_sel_keyflex_comb
13222: (p_appl_short_name => 'PAY'
13215: or nvl(p_segment27,'X') <> hr_api.g_varchar2
13216: or nvl(p_segment28,'X') <> hr_api.g_varchar2
13217: or nvl(p_segment29,'X') <> hr_api.g_varchar2
13218: or nvl(p_segment30,'X') <> hr_api.g_varchar2
13219: or nvl(l_old_group_name,'X') <> hr_api.g_varchar2 THEN
13220: --
13221: hr_kflex_utility.upd_or_sel_keyflex_comb
13222: (p_appl_short_name => 'PAY'
13223: ,p_flex_code => 'GRP'
13343: --of non payrolled worker. As a result this code has been commented
13344: --out, but left in as it is likely to form part of a later phase
13345: --
13346: /*
13347: IF (p_pay_basis_id <> hr_api.g_number or
13348: p_pay_basis_id is null ) and
13349: (nvl(p_pay_basis_id,hr_api.g_number) <>
13350: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
13351: then
13345: --
13346: /*
13347: IF (p_pay_basis_id <> hr_api.g_number or
13348: p_pay_basis_id is null ) and
13349: (nvl(p_pay_basis_id,hr_api.g_number) <>
13350: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
13351: then
13352: open csr_get_salary;
13353: fetch csr_get_salary into l_element_entry_id;
13346: /*
13347: IF (p_pay_basis_id <> hr_api.g_number or
13348: p_pay_basis_id is null ) and
13349: (nvl(p_pay_basis_id,hr_api.g_number) <>
13350: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
13351: then
13352: open csr_get_salary;
13353: fetch csr_get_salary into l_element_entry_id;
13354: if csr_get_salary%found then
13372: -- of non payrolled worker. As a result this code has been commented
13373: -- out, but left in as it is likely to form part of a later phase
13374: --
13375: /*
13376: if p_payroll_id = hr_api.g_number
13377: then
13378: --
13379: if g_debug then
13380: hr_utility.set_location(l_proc, 150);
13426: p_grade_id IS NULL) OR
13427: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13428: p_grade_id IS NOT NULL AND
13429: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
13430: p_grade_id <> hr_api.g_number) THEN
13431: --
13432: if g_debug then
13433: hr_utility.set_location(l_proc, 190);
13434: end if;
13579: ,p_concat_segments => l_old_group_name);
13580: --
13581: EXCEPTION
13582: --
13583: WHEN hr_api.cannot_find_prog_unit THEN
13584: --
13585: hr_api.cannot_find_prog_unit_error
13586: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
13587: ,p_hook_type => 'AP');
13581: EXCEPTION
13582: --
13583: WHEN hr_api.cannot_find_prog_unit THEN
13584: --
13585: hr_api.cannot_find_prog_unit_error
13586: (p_module_name => 'UPDATE_CWK_ASG_CRITERIA'
13587: ,p_hook_type => 'AP');
13588: --
13589: -- End of API User Hook for the after hook of update_emp_asg_criteria
13593: -- When in validation only mode raise the Validate_Enabled exception
13594: --
13595: IF p_validate THEN
13596: --
13597: RAISE hr_api.validate_enabled;
13598: --
13599: END IF;
13600: --
13601: -- Set all output arguments
13622: end if;
13623: --
13624: EXCEPTION
13625: --
13626: WHEN hr_api.validate_enabled THEN
13627: --
13628: -- As the Validate_Enabled exception has been raised
13629: -- we must rollback to the savepoint
13630: --
15494: ,p_entries_changed_warning => l_entries_changed_warning
15495: ,p_tax_district_changed_warning => l_tax_district_changed_warning
15496: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
15497: ,p_concatenated_segments => l_concatenated_segments
15498: --2689059: changed the following: must pass hr_api defaults to NEW update API
15499: ,p_contract_id => hr_api.g_number --l_contract_id
15500: ,p_establishment_id => hr_api.g_number --l_establishment_id
15501: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
15502: ) ;
15495: ,p_tax_district_changed_warning => l_tax_district_changed_warning
15496: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
15497: ,p_concatenated_segments => l_concatenated_segments
15498: --2689059: changed the following: must pass hr_api defaults to NEW update API
15499: ,p_contract_id => hr_api.g_number --l_contract_id
15500: ,p_establishment_id => hr_api.g_number --l_establishment_id
15501: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
15502: ) ;
15503:
15496: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
15497: ,p_concatenated_segments => l_concatenated_segments
15498: --2689059: changed the following: must pass hr_api defaults to NEW update API
15499: ,p_contract_id => hr_api.g_number --l_contract_id
15500: ,p_establishment_id => hr_api.g_number --l_establishment_id
15501: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
15502: ) ;
15503:
15504:
15497: ,p_concatenated_segments => l_concatenated_segments
15498: --2689059: changed the following: must pass hr_api defaults to NEW update API
15499: ,p_contract_id => hr_api.g_number --l_contract_id
15500: ,p_establishment_id => hr_api.g_number --l_establishment_id
15501: ,p_scl_segment1 => hr_api.g_varchar2 --l_scl_segment1
15502: ) ;
15503:
15504:
15505: --
15900: l_pgp_segment30 varchar2(60) := p_segment30;
15901:
15902: -- Start of Fix for Bug 2622747
15903: l_scl_segment1 varchar2(60) := p_scl_segment1;
15904: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15901:
15902: -- Start of Fix for Bug 2622747
15903: l_scl_segment1 varchar2(60) := p_scl_segment1;
15904: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15902: -- Start of Fix for Bug 2622747
15903: l_scl_segment1 varchar2(60) := p_scl_segment1;
15904: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15903: l_scl_segment1 varchar2(60) := p_scl_segment1;
15904: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15904: l_scl_segment2 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15905: l_scl_segment3 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15906: l_scl_segment4 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15907: l_scl_segment5 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15908: l_scl_segment6 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15909: l_scl_segment7 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15910: l_scl_segment8 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15911: l_scl_segment9 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15912: l_scl_segment10 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15913: l_scl_segment11 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15914: l_scl_segment12 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15915: l_scl_segment13 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15916: l_scl_segment14 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15917: l_scl_segment15 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15918: l_scl_segment16 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15919: l_scl_segment17 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15920: l_scl_segment18 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15921: l_scl_segment19 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15922: l_scl_segment20 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15923: l_scl_segment21 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15924: l_scl_segment22 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15932: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15925: l_scl_segment23 varchar2(60) := hr_api.g_varchar2 ;
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15932: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15933: --
15926: l_scl_segment24 varchar2(60) := hr_api.g_varchar2 ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15932: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15933: --
15934: lv_object_version_number number := p_object_version_number ;
15927: l_scl_segment25 varchar2(60) := hr_api.g_varchar2 ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15932: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15933: --
15934: lv_object_version_number number := p_object_version_number ;
15935: lv_special_ceiling_step_id number := p_special_ceiling_step_id ;
15928: l_scl_segment26 varchar2(60) := hr_api.g_varchar2 ;
15929: l_scl_segment27 varchar2(60) := hr_api.g_varchar2 ;
15930: l_scl_segment28 varchar2(60) := hr_api.g_varchar2 ;
15931: l_scl_segment29 varchar2(60) := hr_api.g_varchar2 ;
15932: l_scl_segment30 varchar2(60) := hr_api.g_varchar2 ;
15933: --
15934: lv_object_version_number number := p_object_version_number ;
15935: lv_special_ceiling_step_id number := p_special_ceiling_step_id ;
15936: lv_people_group_id number := p_people_group_id ;
16257: );
16258: -- End of Fix for Bug 2622747
16259:
16260: exception
16261: when hr_api.cannot_find_prog_unit then
16262: hr_api.cannot_find_prog_unit_error
16263: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
16264: ,p_hook_type => 'BP'
16265: );
16258: -- End of Fix for Bug 2622747
16259:
16260: exception
16261: when hr_api.cannot_find_prog_unit then
16262: hr_api.cannot_find_prog_unit_error
16263: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
16264: ,p_hook_type => 'BP'
16265: );
16266: --
16345: -- l_special_ceiling_step_id := null;
16346: -- else
16347: -- --
16348: -- --
16349: -- if p_special_ceiling_step_id = hr_api.g_number then
16350: -- --
16351: -- --
16352: -- l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
16353: -- else
16373: -- the grade is assigned to assignment but not passed
16374: -- to api.
16375: --
16376: if (per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
16377: p_grade_id <> hr_api.g_number AND -- 3485599
16378: p_special_ceiling_step_id IS NOT NULL) then
16379: --
16380: if g_debug then
16381: hr_utility.set_location(l_proc, 140);
16428: if g_debug then
16429: hr_utility.set_location(l_proc, 180);
16430: end if;
16431: --
16432: if p_special_ceiling_step_id = hr_api.g_number then
16433: --
16434: if g_debug then
16435: hr_utility.set_location(l_proc, 190);
16436: end if;
16469: -- insert the profile options and effective date for the flexfield
16470: -- validation to work
16471: --
16472: --
16473: if (l_org_id = hr_api.g_number) then -- Bug 3553286
16474: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
16475: else
16476: l_organization_id:= l_org_id; -- Bug 3553286
16477: end if;
16475: else
16476: l_organization_id:= l_org_id; -- Bug 3553286
16477: end if;
16478: --
16479: if (p_location_id=hr_api.g_number) then
16480: l_location_id:=per_asg_shd.g_old_rec.location_id;
16481: else
16482: l_location_id:=p_location_id;
16483: end if;
16548: fetch c_pgp_segments into l_old_pgp_segments;
16549: close c_pgp_segments;
16550: end if;
16551: --
16552: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16549: close c_pgp_segments;
16550: end if;
16551: --
16552: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16550: end if;
16551: --
16552: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16551: --
16552: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16552: if nvl(p_segment1, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment1, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16553: or nvl(p_segment2, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment2, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16554: or nvl(p_segment3, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment3, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16555: or nvl(p_segment4, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment4, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16556: or nvl(p_segment5, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment5, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16557: or nvl(p_segment6, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment6, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16558: or nvl(p_segment7, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment7, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16559: or nvl(p_segment8, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment8, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16560: or nvl(p_segment9, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment9, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16561: or nvl(p_segment10, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment10, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16562: or nvl(p_segment11, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment11, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16563: or nvl(p_segment12, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment12, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16564: or nvl(p_segment13, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment13, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16565: or nvl(p_segment14, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment14, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16566: or nvl(p_segment15, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment15, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16567: or nvl(p_segment16, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment16, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16568: or nvl(p_segment17, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment17, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16569: or nvl(p_segment18, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment18, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16570: or nvl(p_segment19, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment19, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16571: or nvl(p_segment20, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment20, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16572: or nvl(p_segment21, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment21, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16573: or nvl(p_segment22, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment22, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16574: or nvl(p_segment23, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment23, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16575: or nvl(p_segment24, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment24, hr_api.g_varchar2)
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16583: or l_people_group_id is null -- fix for bug 4633742.
16576: or nvl(p_segment25, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment25, hr_api.g_varchar2)
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16583: or l_people_group_id is null -- fix for bug 4633742.
16584: then
16577: or nvl(p_segment26, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment26, hr_api.g_varchar2)
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16583: or l_people_group_id is null -- fix for bug 4633742.
16584: then
16585: hr_kflex_utility.upd_or_sel_keyflex_comb
16578: or nvl(p_segment27, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment27, hr_api.g_varchar2)
16579: or nvl(p_segment28, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment28, hr_api.g_varchar2)
16580: or nvl(p_segment29, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment29, hr_api.g_varchar2)
16581: or nvl(p_segment30, hr_api.g_varchar2) <> nvl(l_old_pgp_segments.segment30, hr_api.g_varchar2)
16582: or nvl(l_old_group_name,hr_api.g_varchar2) <> nvl(l_old_pgp_segments.group_name, hr_api.g_varchar2)
16583: or l_people_group_id is null -- fix for bug 4633742.
16584: then
16585: hr_kflex_utility.upd_or_sel_keyflex_comb
16586: (p_appl_short_name => 'PAY'
16750: --
16751: -- Delete the SP element entry if there is one when the pay_basis
16752: -- changes
16753: --
16754: if (p_pay_basis_id <> hr_api.g_number or
16755: p_pay_basis_id is null ) and
16756: (nvl(p_pay_basis_id,hr_api.g_number) <>
16757: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16758: then
16752: -- changes
16753: --
16754: if (p_pay_basis_id <> hr_api.g_number or
16755: p_pay_basis_id is null ) and
16756: (nvl(p_pay_basis_id,hr_api.g_number) <>
16757: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16758: then
16759: -- start of bug fix 4464072
16760: -- commented out the following part and newly defined
16753: --
16754: if (p_pay_basis_id <> hr_api.g_number or
16755: p_pay_basis_id is null ) and
16756: (nvl(p_pay_basis_id,hr_api.g_number) <>
16757: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16758: then
16759: -- start of bug fix 4464072
16760: -- commented out the following part and newly defined
16761:
16803: close csr_pay_proposal_exists;
16804:
16805: if l_pay_proposal_id is null then -- no salary proposal exists on this date. Go create it .
16806:
16807: if hr_api.not_exists_in_hr_lookups
16808: (p_effective_date => p_effective_date
16809: ,p_lookup_type => 'PROPOSAL_REASON'
16810: ,p_lookup_code => 'SALBASISCHG'
16811: )
16869: if future_pay_proposals%notfound then
16870: --
16871: -- No problem. Can allow sal basis change. Just close the cursor.
16872: --
16873: IF hr_api.not_exists_in_hr_lookups -- if 4
16874: (p_effective_date => p_effective_date,
16875: p_lookup_type => 'PROPOSAL_REASON',
16876: p_lookup_code => 'SALBASISCHG'
16877: ) THEN
16965: -- Maintain standard element entries for this assignment.
16966: --
16967: -- Bug 638026 fix starts
16968: --
16969: if p_payroll_id = hr_api.g_number
16970: then
16971: --
16972: if g_debug then
16973: hr_utility.set_location(l_proc, 300);
17050: AND p_grade_id is null)
17051: OR ( per_asg_shd.g_old_rec.grade_id is not null
17052: AND p_grade_id is not null
17053: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
17054: AND p_grade_id <> hr_api.g_number)
17055: then
17056: --
17057: if g_debug then
17058: hr_utility.set_location(l_proc, 340);
17215: ,p_scl_segment1 => l_scl_segment1
17216: -- End of Fix for Bug 2622747
17217: );
17218: exception
17219: when hr_api.cannot_find_prog_unit then
17220: hr_api.cannot_find_prog_unit_error
17221: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
17222: ,p_hook_type => 'AP'
17223: );
17216: -- End of Fix for Bug 2622747
17217: );
17218: exception
17219: when hr_api.cannot_find_prog_unit then
17220: hr_api.cannot_find_prog_unit_error
17221: (p_module_name => 'UPDATE_EMP_ASG_CRITERIA'
17222: ,p_hook_type => 'AP'
17223: );
17224: --
17240: --
17241: -- When in validation only mode raise the Validate_Enabled exception
17242: --
17243: if p_validate then
17244: raise hr_api.validate_enabled;
17245: end if;
17246: --
17247: -- Set all output arguments
17248: --
17268: hr_utility.set_location(' Leaving:'||l_proc, 997);
17269: end if;
17270: --
17271: exception
17272: when hr_api.validate_enabled then
17273: --
17274: if g_debug then
17275: hr_utility.set_location(' Leaving:'||l_proc, 998);
17276: end if;
17884: -- Validation in addition to Table Handlers
17885: --
17886: -- Check mandatory arguments
17887: --
17888: hr_api.mandatory_arg_error
17889: (p_api_name => l_proc
17890: ,p_argument => 'assignment_id'
17891: ,p_argument_value => p_assignment_id);
17892: --
17889: (p_api_name => l_proc
17890: ,p_argument => 'assignment_id'
17891: ,p_argument_value => p_assignment_id);
17892: --
17893: hr_api.mandatory_arg_error
17894: (p_api_name => l_proc
17895: ,p_argument => 'effective_date'
17896: ,p_argument_value => l_effective_date);
17897: --
17894: (p_api_name => l_proc
17895: ,p_argument => 'effective_date'
17896: ,p_argument_value => l_effective_date);
17897: --
17898: hr_api.mandatory_arg_error
17899: (p_api_name => l_proc
17900: ,p_argument => 'datetrack_update_mode'
17901: ,p_argument_value => p_datetrack_update_mode);
17902: --
17899: (p_api_name => l_proc
17900: ,p_argument => 'datetrack_update_mode'
17901: ,p_argument_value => p_datetrack_update_mode);
17902: --
17903: hr_api.mandatory_arg_error
17904: (p_api_name => l_proc
17905: ,p_argument => 'object_version_number'
17906: ,p_argument_value => l_object_version_number);
17907: --
18250: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
18251: ,p_supervisor_assignment_id => p_supervisor_assignment_id
18252: );
18253: exception
18254: when hr_api.cannot_find_prog_unit then
18255: hr_api.cannot_find_prog_unit_error
18256: (p_module_name => 'UPDATE_APL_ASG',
18257: p_hook_type => 'BP'
18258: );
18251: ,p_supervisor_assignment_id => p_supervisor_assignment_id
18252: );
18253: exception
18254: when hr_api.cannot_find_prog_unit then
18255: hr_api.cannot_find_prog_unit_error
18256: (p_module_name => 'UPDATE_APL_ASG',
18257: p_hook_type => 'BP'
18258: );
18259: end;
18264: end if;
18265: --
18266: --added validation for bug 1867720
18267: --
18268: if p_assignment_status_type_id <> hr_api.g_number then
18269: open csr_old_asg_status;
18270: fetch csr_old_asg_status into l_old_asg_status;
18271: close csr_old_asg_status;
18272: --
18285: --
18286: -- insert the profile options and effective date for the flexfield
18287: -- validation to work
18288: --
18289: if (p_organization_id=hr_api.g_number) then
18290: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
18291: else
18292: l_organization_id:=p_organization_id;
18293: end if;
18291: else
18292: l_organization_id:=p_organization_id;
18293: end if;
18294: --
18295: if (p_location_id=hr_api.g_number) then
18296: l_location_id:=per_asg_shd.g_old_rec.location_id;
18297: else
18298: l_location_id:=p_location_id;
18299: end if;
18374: -- Update or select the soft_coding_keyflex_id
18375: --
18376: if l_soft_coding_keyflex_id is null
18377: then
18378: if l_scl_segment1 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18375: --
18376: if l_soft_coding_keyflex_id is null
18377: then
18378: if l_scl_segment1 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18376: if l_soft_coding_keyflex_id is null
18377: then
18378: if l_scl_segment1 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18377: then
18378: if l_scl_segment1 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18378: if l_scl_segment1 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18379: or l_scl_segment2 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18380: or l_scl_segment3 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18381: or l_scl_segment4 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18382: or l_scl_segment5 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18383: or l_scl_segment6 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18384: or l_scl_segment7 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18385: or l_scl_segment8 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18386: or l_scl_segment9 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18387: or l_scl_segment10 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18388: or l_scl_segment11 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18389: or l_scl_segment12 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18390: or l_scl_segment13 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18391: or l_scl_segment14 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18392: or l_scl_segment15 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18393: or l_scl_segment16 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18394: or l_scl_segment17 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18395: or l_scl_segment18 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18396: or l_scl_segment19 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18397: or l_scl_segment20 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18398: or l_scl_segment21 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18399: or l_scl_segment22 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18400: or l_scl_segment23 <> hr_api.g_varchar2
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18408: --
18401: or l_scl_segment24 <> hr_api.g_varchar2
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18408: --
18409: -- Bug 944911
18402: or l_scl_segment25 <> hr_api.g_varchar2
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18408: --
18409: -- Bug 944911
18410: -- Added this additional check
18403: or l_scl_segment26 <> hr_api.g_varchar2
18404: or l_scl_segment27 <> hr_api.g_varchar2
18405: or l_scl_segment28 <> hr_api.g_varchar2
18406: or l_scl_segment29 <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18408: --
18409: -- Bug 944911
18410: -- Added this additional check
18411: or p_scl_concat_segments <> hr_api.g_varchar2
18407: or l_scl_segment30 <> hr_api.g_varchar2
18408: --
18409: -- Bug 944911
18410: -- Added this additional check
18411: or p_scl_concat_segments <> hr_api.g_varchar2
18412: then
18413: -- gets flex num id from pay_legislation_rules and
18414: -- per_business_groups_perf
18415: --
18514: );
18515: --
18516: end if; -- csr_scl_idsel%NOTFOUND
18517: --
18518: end if; -- l_scl_segment1 <> hr_api.g_varchar2
18519: --
18520: end if; -- l_soft_coding_key_flex_id is null
18521: --
18522: -- need to call the lck procedure early, to fetch the old value of
18532: -- function allows that function to derive the old values.
18533: --
18534: l_cagr_id_flex_num := p_cagr_id_flex_num;
18535: --
18536: if (p_cagr_id_flex_num = hr_api.g_number) THEN
18537: per_asg_shd.lck
18538: (p_effective_date => l_effective_date,
18539: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
18540: p_datetrack_mode => p_datetrack_update_mode,
18695: --
18696: -- ***** Start new code for bug 2276928 **************
18697: -- modified the below if condition for bug 7657734
18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18697: -- modified the below if condition for bug 7657734
18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18704: -- end of 9496344
18705: --12427559
18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18704: -- end of 9496344
18705: --12427559
18706:
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18704: -- end of 9496344
18705: --12427559
18706:
18707: if p_assignment_status_type_id = hr_api.g_number or p_assignment_status_type_id is null then
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18704: -- end of 9496344
18705: --12427559
18706:
18707: if p_assignment_status_type_id = hr_api.g_number or p_assignment_status_type_id is null then
18708: l_asg_status_type_id := per_asg_shd.g_old_rec.assignment_status_type_id;
18709:
18710: else
18711:
18727: -- with that vacancy.
18728: -- When the assignemnt status is changed, create new letter request lines.
18729: --
18730: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
18731: AND p_assignment_status_type_id<>hr_api.g_number
18732: )
18733: OR
18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18735: nvl(p_vacancy_id,-1) <> hr_api.g_number
18731: AND p_assignment_status_type_id<>hr_api.g_number
18732: )
18733: OR
18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18735: nvl(p_vacancy_id,-1) <> hr_api.g_number
18736: ) THEN
18737: --
18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18739: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
18735: nvl(p_vacancy_id,-1) <> hr_api.g_number
18736: ) THEN
18737: --
18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18739: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
18740: --
18741: delete from per_letter_request_lines plrl
18742: where plrl.assignment_id = p_assignment_id
18743: and plrl.assignment_status_type_id = p_assignment_status_type_id
18999: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
19000: ,p_supervisor_assignment_id => p_supervisor_assignment_id
19001: );
19002: exception
19003: when hr_api.cannot_find_prog_unit then
19004: hr_api.cannot_find_prog_unit_error
19005: (p_module_name => 'UPDATE_APL_ASG',
19006: p_hook_type => 'AP'
19007: );
19000: ,p_supervisor_assignment_id => p_supervisor_assignment_id
19001: );
19002: exception
19003: when hr_api.cannot_find_prog_unit then
19004: hr_api.cannot_find_prog_unit_error
19005: (p_module_name => 'UPDATE_APL_ASG',
19006: p_hook_type => 'AP'
19007: );
19008: end;
19012: --
19013: -- When in validation only mode raise the Validate_Enabled exception
19014: --
19015: if p_validate then
19016: raise hr_api.validate_enabled;
19017: end if;
19018: --
19019: -- Set all output arguments
19020: --
19039: if g_debug then
19040: hr_utility.set_location(' Leaving:'||l_proc, 6);
19041: end if;
19042: exception
19043: when hr_api.validate_enabled then
19044: --
19045: -- As the Validate_Enabled exception has been raised
19046: -- we must rollback to the savepoint
19047: --
20094: select apl.application_id, apl.date_end
20095: from per_applications apl
20096: where apl.person_id = p_person_id
20097: and l_effective_date between apl.date_received
20098: and nvl(apl.date_end,hr_api.g_eot);
20099: -- <<
20100: cursor csr_get_apl_asg is
20101: select asg.application_id
20102: from per_all_assignments_f asg
20268: -- Validation in addition to Table Handlers
20269: --
20270: -- Get person details.
20271: --
20272: hr_api.mandatory_arg_error
20273: (p_api_name => l_proc
20274: ,p_argument => 'person_id'
20275: ,p_argument_value => p_person_id
20276: );
20274: ,p_argument => 'person_id'
20275: ,p_argument_value => p_person_id
20276: );
20277: --
20278: hr_api.mandatory_arg_error
20279: (p_api_name => l_proc
20280: ,p_argument => 'effective_date'
20281: ,p_argument_value => l_effective_date
20282: );
20607: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
20608: ,p_supervisor_assignment_id => p_supervisor_assignment_id
20609: );
20610: exception
20611: when hr_api.cannot_find_prog_unit then
20612: hr_api.cannot_find_prog_unit_error
20613: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
20614: p_hook_type => 'BP'
20615: );
20608: ,p_supervisor_assignment_id => p_supervisor_assignment_id
20609: );
20610: exception
20611: when hr_api.cannot_find_prog_unit then
20612: hr_api.cannot_find_prog_unit_error
20613: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
20614: p_hook_type => 'BP'
20615: );
20616: end;
20951: --
20952: hr_assignment_api.update_apl_asg
20953: (p_validate => FALSE
20954: ,p_effective_date => l_effective_date
20955: ,p_datetrack_update_mode => hr_api.g_correction
20956: ,p_assignment_id => l_assignment_id
20957: ,p_object_version_number => l_object_version_number
20958: ,p_recruiter_id => p_recruiter_id
20959: ,p_grade_id => p_grade_id
21435: ,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
21436: ,p_supervisor_assignment_id => p_supervisor_assignment_id
21437: );
21438: exception
21439: when hr_api.cannot_find_prog_unit then
21440: hr_api.cannot_find_prog_unit_error
21441: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
21442: p_hook_type => 'AP'
21443: );
21436: ,p_supervisor_assignment_id => p_supervisor_assignment_id
21437: );
21438: exception
21439: when hr_api.cannot_find_prog_unit then
21440: hr_api.cannot_find_prog_unit_error
21441: (p_module_name => 'CREATE_SECONDARY_APL_ASG',
21442: p_hook_type => 'AP'
21443: );
21444: end;
21448: --
21449: -- When in validation only mode raise the Validate_Enabled exception
21450: --
21451: if p_validate then
21452: raise hr_api.validate_enabled;
21453: end if;
21454: --
21455: -- Set remaining output arguments
21456: --
21479: if g_debug then
21480: hr_utility.set_location(' Leaving:'||l_proc, 50);
21481: end if;
21482: exception
21483: when hr_api.validate_enabled then
21484: --
21485: -- As the Validate_Enabled exception has been raised
21486: -- we must rollback to the savepoint
21487: --
21884: ,p_assignment_status_type_id => p_assignment_status_type_id
21885: ,p_change_reason => p_change_reason
21886: );
21887: exception
21888: when hr_api.cannot_find_prog_unit then
21889: hr_api.cannot_find_prog_unit_error
21890: (p_module_name => 'OFFER_APL_ASG',
21891: p_hook_type => 'BP'
21892: );
21885: ,p_change_reason => p_change_reason
21886: );
21887: exception
21888: when hr_api.cannot_find_prog_unit then
21889: hr_api.cannot_find_prog_unit_error
21890: (p_module_name => 'OFFER_APL_ASG',
21891: p_hook_type => 'BP'
21892: );
21893: end;
21921: ,p_effective_start_date => l_effective_start_date
21922: ,p_effective_end_date => l_effective_end_date
21923: );
21924: exception
21925: when hr_api.cannot_find_prog_unit then
21926: hr_api.cannot_find_prog_unit_error
21927: (p_module_name => 'OFFER_APL_ASG',
21928: p_hook_type => 'AP'
21929: );
21922: ,p_effective_end_date => l_effective_end_date
21923: );
21924: exception
21925: when hr_api.cannot_find_prog_unit then
21926: hr_api.cannot_find_prog_unit_error
21927: (p_module_name => 'OFFER_APL_ASG',
21928: p_hook_type => 'AP'
21929: );
21930: end;
21934: --
21935: -- When in validation only mode raise the Validate_Enabled exception
21936: --
21937: if p_validate then
21938: raise hr_api.validate_enabled;
21939: end if;
21940: --
21941: -- Set remaining output arguments
21942: --
21947: if g_debug then
21948: hr_utility.set_location(' Leaving:'||l_proc, 50);
21949: end if;
21950: exception
21951: when hr_api.validate_enabled then
21952: --
21953: -- As the Validate_Enabled exception has been raised
21954: -- we must rollback to the savepoint
21955: --
22045: ,p_assignment_status_type_id => p_assignment_status_type_id
22046: ,p_change_reason => p_change_reason
22047: );
22048: exception
22049: when hr_api.cannot_find_prog_unit then
22050: hr_api.cannot_find_prog_unit_error
22051: (p_module_name => 'ACCEPT_APL_ASG',
22052: p_hook_type => 'BP'
22053: );
22046: ,p_change_reason => p_change_reason
22047: );
22048: exception
22049: when hr_api.cannot_find_prog_unit then
22050: hr_api.cannot_find_prog_unit_error
22051: (p_module_name => 'ACCEPT_APL_ASG',
22052: p_hook_type => 'BP'
22053: );
22054: end;
22084: ,p_effective_start_date => l_effective_start_date
22085: ,p_effective_end_date => l_effective_end_date
22086: );
22087: exception
22088: when hr_api.cannot_find_prog_unit then
22089: hr_api.cannot_find_prog_unit_error
22090: (p_module_name => 'OFFER_APL_ASG',
22091: p_hook_type => 'AP'
22092: );
22085: ,p_effective_end_date => l_effective_end_date
22086: );
22087: exception
22088: when hr_api.cannot_find_prog_unit then
22089: hr_api.cannot_find_prog_unit_error
22090: (p_module_name => 'OFFER_APL_ASG',
22091: p_hook_type => 'AP'
22092: );
22093: end;
22098: --
22099: -- When in validation only mode raise the Validate_Enabled exception
22100: --
22101: if p_validate then
22102: raise hr_api.validate_enabled;
22103: end if;
22104: --
22105: -- Set remaining output arguments
22106: --
22111: if g_debug then
22112: hr_utility.set_location(' Leaving:'||l_proc, 50);
22113: end if;
22114: exception
22115: when hr_api.validate_enabled then
22116: -- As the Validate_Enabled exception has been raised
22117: -- we must rollback to the savepoint
22118: --
22119: ROLLBACK TO accept_apl_asg;
22198: ,p_assignment_status_type_id => p_assignment_status_type_id
22199: ,p_change_reason => p_change_reason
22200: );
22201: EXCEPTION
22202: WHEN hr_api.cannot_find_prog_unit
22203: THEN
22204: hr_api.cannot_find_prog_unit_error
22205: (p_module_name => 'ACTIVATE_APL_ASG',
22206: p_hook_type => 'BP'
22200: );
22201: EXCEPTION
22202: WHEN hr_api.cannot_find_prog_unit
22203: THEN
22204: hr_api.cannot_find_prog_unit_error
22205: (p_module_name => 'ACTIVATE_APL_ASG',
22206: p_hook_type => 'BP'
22207: );
22208: END;
22242: ,p_effective_start_date => l_effective_start_date
22243: ,p_effective_end_date => l_effective_end_date
22244: );
22245: EXCEPTION
22246: WHEN hr_api.cannot_find_prog_unit
22247: THEN
22248: hr_api.cannot_find_prog_unit_error
22249: (p_module_name => 'ACTIVATE_APL_ASG',
22250: p_hook_type => 'AP'
22244: );
22245: EXCEPTION
22246: WHEN hr_api.cannot_find_prog_unit
22247: THEN
22248: hr_api.cannot_find_prog_unit_error
22249: (p_module_name => 'ACTIVATE_APL_ASG',
22250: p_hook_type => 'AP'
22251: );
22252: END;
22258: -- When in validation only mode raise validate_enabled exception
22259: --
22260: IF p_validate
22261: THEN
22262: RAISE hr_api.validate_enabled;
22263: END IF;
22264: --
22265: -- Set OUT parameters
22266: --
22271: hr_utility.set_location(' Leaving:'||l_proc,100);
22272: end if;
22273: --
22274: EXCEPTION
22275: WHEN hr_api.validate_enabled
22276: THEN
22277: --
22278: -- In validation only mode
22279: -- Rollback to savepoint
22525: per_asg_del.del
22526: (p_assignment_id => p_assignment_id
22527: ,p_object_version_number => p_object_version_number
22528: ,p_effective_date => l_effective_date
22529: ,p_datetrack_mode => hr_api.g_delete
22530: ,p_effective_start_date => l_effective_start_date
22531: ,p_effective_end_date => l_effective_end_date
22532: ,p_business_group_id => l_business_group_id
22533: ,p_validation_start_date => l_validation_start_date
22661: end if;
22662: --
22663: -- Ensure mandatory arguments have been passed
22664: --
22665: hr_api.mandatory_arg_error
22666: (p_api_name => l_proc
22667: ,p_argument => 'assignment_id'
22668: ,p_argument_value => p_assignment_id
22669: );
22667: ,p_argument => 'assignment_id'
22668: ,p_argument_value => p_assignment_id
22669: );
22670: --
22671: hr_api.mandatory_arg_error
22672: (p_api_name => l_proc
22673: ,p_argument => 'effective_date'
22674: ,p_argument_value => p_effective_date
22675: );
22696: ,p_assignment_id => p_assignment_id
22697: ,p_object_version_number => p_object_version_number
22698: );
22699: EXCEPTION
22700: WHEN hr_api.cannot_find_prog_unit
22701: THEN
22702: hr_api.cannot_find_prog_unit_error
22703: (p_module_name => 'TERMINATE_APL_ASG'
22704: ,p_hook_type => 'B'
22698: );
22699: EXCEPTION
22700: WHEN hr_api.cannot_find_prog_unit
22701: THEN
22702: hr_api.cannot_find_prog_unit_error
22703: (p_module_name => 'TERMINATE_APL_ASG'
22704: ,p_hook_type => 'B'
22705: );
22706: END;
22859: ,p_validation_start_date => l_validation_start_date
22860: ,p_validation_end_date => l_validation_end_date
22861: ,p_object_version_number => l_asg_ovn
22862: ,p_effective_date => l_asg_eff_date
22863: ,p_datetrack_mode => hr_api.g_correction
22864: ,p_validate => FALSE
22865: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
22866: -- update all other future assignments
22867: hr_utility.trace(' update all other assignments');
22884: ,p_validation_start_date => l_validation_start_date
22885: ,p_validation_end_date => l_validation_end_date
22886: ,p_object_version_number => l_asg_ovn
22887: ,p_effective_date => l_asg_eff_date
22888: ,p_datetrack_mode => hr_api.g_correction
22889: ,p_validate => FALSE
22890: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
22891: END LOOP;
22892: --
23087: ,p_validation_start_date => l_validation_start_date
23088: ,p_validation_end_date => l_validation_end_date
23089: ,p_object_version_number => l_asg_ovn
23090: ,p_effective_date => l_asg_eff_date
23091: ,p_datetrack_mode => hr_api.g_correction
23092: ,p_validate => FALSE
23093: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
23094: -- update all other future assignments
23095: hr_utility.trace(' update all other assignments');
23112: ,p_validation_start_date => l_validation_start_date
23113: ,p_validation_end_date => l_validation_end_date
23114: ,p_object_version_number => l_asg_ovn
23115: ,p_effective_date => l_asg_eff_date
23116: ,p_datetrack_mode => hr_api.g_correction
23117: ,p_validate => FALSE
23118: ,p_hourly_salaried_warning => l_hourly_salaried_warning);
23119: END LOOP;
23120: --
23185: ,p_effective_start_date => l_effective_start_date
23186: ,p_effective_end_date => l_effective_end_date
23187: );
23188: EXCEPTION
23189: WHEN hr_api.cannot_find_prog_unit
23190: THEN
23191: hr_api.cannot_find_prog_unit_error
23192: (p_module_name => 'TERMINATE_APL_ASG'
23193: ,p_hook_type => 'A'
23187: );
23188: EXCEPTION
23189: WHEN hr_api.cannot_find_prog_unit
23190: THEN
23191: hr_api.cannot_find_prog_unit_error
23192: (p_module_name => 'TERMINATE_APL_ASG'
23193: ,p_hook_type => 'A'
23194: );
23195: END;
23201: -- When in validation only mode raise validate enabled exception
23202: --
23203: IF p_validate
23204: THEN
23205: RAISE hr_api.validate_enabled;
23206: END IF;
23207: --
23208: -- Set OUT parameters
23209: --
23214: hr_utility.set_location(' Leaving:'||l_proc,1000);
23215: end if;
23216: --
23217: EXCEPTION
23218: WHEN hr_api.validate_enabled
23219: THEN
23220: --
23221: -- In validation only mode
23222: -- Rollback to savepoint
23327: end if;
23328: --
23329: -- Ensure mandatory parameters have been passed
23330: --
23331: hr_api.mandatory_arg_error
23332: (p_api_name => l_proc
23333: ,p_argument => 'effective_date'
23334: ,p_argument_value => p_effective_date
23335: );
23333: ,p_argument => 'effective_date'
23334: ,p_argument_value => p_effective_date
23335: );
23336: --
23337: hr_api.mandatory_arg_error
23338: (p_api_name => l_proc
23339: ,p_argument => 'person_id'
23340: ,p_argument_value => p_person_id
23341: );
23339: ,p_argument => 'person_id'
23340: ,p_argument_value => p_person_id
23341: );
23342: --
23343: hr_api.mandatory_arg_error
23344: (p_api_name => l_proc
23345: ,p_argument => 'assignment_id'
23346: ,p_argument_value => p_assignment_id
23347: );
23367: ,p_assignment_id => p_assignment_id
23368: ,p_object_version_number => p_object_version_number
23369: );
23370: EXCEPTION
23371: WHEN hr_api.cannot_find_prog_unit
23372: THEN
23373: hr_api.cannot_find_prog_unit_error
23374: (p_module_name => 'SET_NEW_PRIMARY_ASG'
23375: ,p_hook_type => 'BP'
23369: );
23370: EXCEPTION
23371: WHEN hr_api.cannot_find_prog_unit
23372: THEN
23373: hr_api.cannot_find_prog_unit_error
23374: (p_module_name => 'SET_NEW_PRIMARY_ASG'
23375: ,p_hook_type => 'BP'
23376: );
23377: END;
23434: THEN
23435: hr_utility.set_message(801,'HR_7999_ASG_INV_PRIM_ASG');
23436: hr_utility.raise_error;
23437: END IF;
23438: IF l_new_assignment.max_effective_end_date <> NVL(l_new_assignment.actual_termination_date,hr_api.g_eot)
23439: THEN
23440: hr_utility.set_message(800,'HR_6438_EMP_ASS_NOT_CONTIN');
23441: hr_utility.raise_error;
23442: END IF;
23455: -- ,p_period_of_service_id => l_old_assignment.period_of_service_id
23456: -- ,p_new_primary_ass_id => p_assignment_id
23457: -- ,p_sdate => l_effective_date
23458: -- ,p_new_primary_flag => 'Y'
23459: -- ,p_mode => hr_api.g_update
23460: -- ,p_last_updated_by => TO_NUMBER(NULL)
23461: -- ,p_last_update_login => TO_NUMBER(NULL)
23462: -- );
23463: --
23472: ,p_period_of_service_id => l_old_assignment.period_of_service_id -- #2468916:instead of new.
23473: ,p_new_primary_ass_id => p_assignment_id
23474: ,p_sdate => l_effective_date
23475: ,p_new_primary_flag => 'Y'
23476: ,p_mode => hr_api.g_update
23477: ,p_last_updated_by => TO_NUMBER(NULL)
23478: ,p_last_update_login => TO_NUMBER(NULL)
23479: );
23480: --
23527: ,p_effective_start_date => l_new_assignment.effective_start_date
23528: ,p_effective_end_date => l_new_assignment.effective_end_date
23529: );
23530: EXCEPTION
23531: WHEN hr_api.cannot_find_prog_unit
23532: THEN
23533: hr_api.cannot_find_prog_unit_error
23534: (p_module_name => 'SET_NEW_PRIMARY_ASG'
23535: ,p_hook_type => 'AP'
23529: );
23530: EXCEPTION
23531: WHEN hr_api.cannot_find_prog_unit
23532: THEN
23533: hr_api.cannot_find_prog_unit_error
23534: (p_module_name => 'SET_NEW_PRIMARY_ASG'
23535: ,p_hook_type => 'AP'
23536: );
23537: END;
23543: -- When in validation only mode raise validate enabled exception
23544: --
23545: IF p_validate
23546: THEN
23547: RAISE hr_api.validate_enabled;
23548: END IF;
23549: --
23550: -- Set OUT parameters
23551: --
23557: hr_utility.set_location(' Leaving:'||l_proc,1000);
23558: end if;
23559: --
23560: EXCEPTION
23561: WHEN hr_api.validate_enabled
23562: THEN
23563: --
23564: -- In validation only mode
23565: -- Rollback to savepoint
23668: end if;
23669: --
23670: -- Ensure mandatory parameters have been passed
23671: --
23672: hr_api.mandatory_arg_error
23673: (p_api_name => l_proc
23674: ,p_argument => 'effective_date'
23675: ,p_argument_value => p_effective_date
23676: );
23674: ,p_argument => 'effective_date'
23675: ,p_argument_value => p_effective_date
23676: );
23677: --
23678: hr_api.mandatory_arg_error
23679: (p_api_name => l_proc
23680: ,p_argument => 'person_id'
23681: ,p_argument_value => p_person_id
23682: );
23680: ,p_argument => 'person_id'
23681: ,p_argument_value => p_person_id
23682: );
23683: --
23684: hr_api.mandatory_arg_error
23685: (p_api_name => l_proc
23686: ,p_argument => 'assignment_id'
23687: ,p_argument_value => p_assignment_id
23688: );
23710: ,p_object_version_number => p_object_version_number);
23711: --
23712: EXCEPTION
23713: --
23714: WHEN hr_api.cannot_find_prog_unit THEN
23715: --
23716: hr_api.cannot_find_prog_unit_error
23717: (p_module_name => 'set_new_primary_cwk_asg'
23718: ,p_hook_type => 'BP');
23712: EXCEPTION
23713: --
23714: WHEN hr_api.cannot_find_prog_unit THEN
23715: --
23716: hr_api.cannot_find_prog_unit_error
23717: (p_module_name => 'set_new_primary_cwk_asg'
23718: ,p_hook_type => 'BP');
23719: --
23720: END;
23793: --
23794: END IF;
23795: --
23796: IF l_new_assignment.max_effective_end_date <>
23797: NVL(l_new_assignment.actual_termination_date,hr_api.g_eot) THEN
23798: --
23799: hr_utility.set_message(800,'HR_6438_EMP_ASS_NOT_CONTIN');
23800: hr_utility.raise_error;
23801: --
23813: ,p_pop_date_start => l_old_assignment.period_of_placement_date_start
23814: ,p_new_primary_ass_id => p_assignment_id
23815: ,p_sdate => l_effective_date
23816: ,p_new_primary_flag => 'Y'
23817: ,p_mode => hr_api.g_update
23818: ,p_last_updated_by => TO_NUMBER(NULL)
23819: ,p_last_update_login => TO_NUMBER(NULL)
23820: );
23821: --
23831: ,p_pop_date_start => l_new_assignment.period_of_placement_date_start
23832: ,p_new_primary_ass_id => p_assignment_id
23833: ,p_sdate => l_effective_date
23834: ,p_new_primary_flag => 'Y'
23835: ,p_mode => hr_api.g_update
23836: ,p_last_updated_by => TO_NUMBER(NULL)
23837: ,p_last_update_login => TO_NUMBER(NULL)
23838: );
23839: --
23877: ,p_effective_end_date => l_new_assignment.effective_end_date);
23878: --
23879: EXCEPTION
23880: --
23881: WHEN hr_api.cannot_find_prog_unit THEN
23882: --
23883: hr_api.cannot_find_prog_unit_error
23884: (p_module_name => 'set_new_primary_cwk_asg'
23885: ,p_hook_type => 'AP');
23879: EXCEPTION
23880: --
23881: WHEN hr_api.cannot_find_prog_unit THEN
23882: --
23883: hr_api.cannot_find_prog_unit_error
23884: (p_module_name => 'set_new_primary_cwk_asg'
23885: ,p_hook_type => 'AP');
23886: --
23887: END;
23893: -- When in validation only mode raise validate enabled exception
23894: --
23895: IF p_validate THEN
23896: --
23897: RAISE hr_api.validate_enabled;
23898: --
23899: END IF;
23900: --
23901: -- Set OUT parameters
23909: end if;
23910: --
23911: EXCEPTION
23912: --
23913: WHEN hr_api.validate_enabled THEN
23914: --
23915: -- In validation only mode
23916: -- Rollback to savepoint
23917: -- Set relevant output warning parmeters
24000: ,p_assignment_status_type_id => p_assignment_status_type_id
24001: ,p_change_reason => p_change_reason
24002: );
24003: EXCEPTION
24004: WHEN hr_api.cannot_find_prog_unit
24005: THEN
24006: hr_api.cannot_find_prog_unit_error
24007: (p_module_name => 'INTERVIEW1_APL_ASG',
24008: p_hook_type => 'BP'
24002: );
24003: EXCEPTION
24004: WHEN hr_api.cannot_find_prog_unit
24005: THEN
24006: hr_api.cannot_find_prog_unit_error
24007: (p_module_name => 'INTERVIEW1_APL_ASG',
24008: p_hook_type => 'BP'
24009: );
24010: END;
24044: ,p_effective_start_date => l_effective_start_date
24045: ,p_effective_end_date => l_effective_end_date
24046: );
24047: EXCEPTION
24048: WHEN hr_api.cannot_find_prog_unit
24049: THEN
24050: hr_api.cannot_find_prog_unit_error
24051: (p_module_name => 'INTERVIEW1_APL_ASG',
24052: p_hook_type => 'AP'
24046: );
24047: EXCEPTION
24048: WHEN hr_api.cannot_find_prog_unit
24049: THEN
24050: hr_api.cannot_find_prog_unit_error
24051: (p_module_name => 'INTERVIEW1_APL_ASG',
24052: p_hook_type => 'AP'
24053: );
24054: END;
24060: -- When in validation only mode raise validate_enabled exception
24061: --
24062: IF p_validate
24063: THEN
24064: RAISE hr_api.validate_enabled;
24065: END IF;
24066: --
24067: -- Set OUT parameters
24068: --
24073: hr_utility.set_location(' Leaving:'||l_proc,100);
24074: end if;
24075: --
24076: EXCEPTION
24077: WHEN hr_api.validate_enabled
24078: THEN
24079: --
24080: -- In validation only mode
24081: -- Rollback to savepoint
24164: ,p_assignment_status_type_id => p_assignment_status_type_id
24165: ,p_change_reason => p_change_reason
24166: );
24167: EXCEPTION
24168: WHEN hr_api.cannot_find_prog_unit
24169: THEN
24170: hr_api.cannot_find_prog_unit_error
24171: (p_module_name => 'INTERVIEW2_APL_ASG',
24172: p_hook_type => 'BP'
24166: );
24167: EXCEPTION
24168: WHEN hr_api.cannot_find_prog_unit
24169: THEN
24170: hr_api.cannot_find_prog_unit_error
24171: (p_module_name => 'INTERVIEW2_APL_ASG',
24172: p_hook_type => 'BP'
24173: );
24174: END;
24208: ,p_effective_start_date => l_effective_start_date
24209: ,p_effective_end_date => l_effective_end_date
24210: );
24211: EXCEPTION
24212: WHEN hr_api.cannot_find_prog_unit
24213: THEN
24214: hr_api.cannot_find_prog_unit_error
24215: (p_module_name => 'INTERVIEW2_APL_ASG',
24216: p_hook_type => 'AP'
24210: );
24211: EXCEPTION
24212: WHEN hr_api.cannot_find_prog_unit
24213: THEN
24214: hr_api.cannot_find_prog_unit_error
24215: (p_module_name => 'INTERVIEW2_APL_ASG',
24216: p_hook_type => 'AP'
24217: );
24218: END;
24224: -- When in validation only mode raise validate_enabled exception
24225: --
24226: IF p_validate
24227: THEN
24228: RAISE hr_api.validate_enabled;
24229: END IF;
24230: --
24231: -- Set OUT parameters
24232: --
24237: hr_utility.set_location(' Leaving:'||l_proc,100);
24238: end if;
24239: --
24240: EXCEPTION
24241: WHEN hr_api.validate_enabled
24242: THEN
24243: --
24244: -- In validation only mode
24245: -- Rollback to savepoint
24350: ,p_datetrack_mode => p_datetrack_mode
24351: );
24352: --
24353: exception
24354: when hr_api.cannot_find_prog_unit then
24355: hr_api.cannot_find_prog_unit_error
24356: (p_module_name => 'DELETE_ASSIGNMENT'
24357: ,p_hook_type => 'BP'
24358: );
24351: );
24352: --
24353: exception
24354: when hr_api.cannot_find_prog_unit then
24355: hr_api.cannot_find_prog_unit_error
24356: (p_module_name => 'DELETE_ASSIGNMENT'
24357: ,p_hook_type => 'BP'
24358: );
24359: --
24398: ,p_life_events_exists => p_life_events_exists
24399: ,p_cobra_coverage_elements => p_cobra_coverage_elements
24400: ,p_assgt_term_elements => p_assgt_term_elements );
24401: exception
24402: when hr_api.cannot_find_prog_unit then
24403: hr_api.cannot_find_prog_unit_error
24404: (p_module_name => 'DELETE_ASSIGNMENT'
24405: ,p_hook_type => 'AP'
24406: );
24399: ,p_cobra_coverage_elements => p_cobra_coverage_elements
24400: ,p_assgt_term_elements => p_assgt_term_elements );
24401: exception
24402: when hr_api.cannot_find_prog_unit then
24403: hr_api.cannot_find_prog_unit_error
24404: (p_module_name => 'DELETE_ASSIGNMENT'
24405: ,p_hook_type => 'AP'
24406: );
24407: --
24410: end;
24411: --
24412:
24413: if p_validate then
24414: raise hr_api.validate_enabled;
24415: end if;
24416: --
24417: if g_debug then
24418: hr_utility.set_location(' Leaving:'||l_proc, 100);
24418: hr_utility.set_location(' Leaving:'||l_proc, 100);
24419: end if;
24420: --
24421: exception
24422: when hr_api.validate_enabled then
24423: --
24424: -- As the Validate_Enabled exception has been raised
24425: -- we must rollback to the savepoint
24426: --