117: AND c_effective_date BETWEEN effective_start_date AND effective_end_date
118: AND bgp.legislation_code = 'NZ';
119: --
120: BEGIN
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122:
123: l_effective_date := TRUNC(p_effective_date);
124:
125: --
132: FETCH csr_legislation INTO l_legislation_code;
133: IF (csr_legislation%NOTFOUND)
134: THEN
135: CLOSE csr_legislation;
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE', 'NZ');
138: hr_utility.raise_error;
139: END IF;
140: CLOSE csr_legislation;
133: IF (csr_legislation%NOTFOUND)
134: THEN
135: CLOSE csr_legislation;
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE', 'NZ');
138: hr_utility.raise_error;
139: END IF;
140: CLOSE csr_legislation;
141:
134: THEN
135: CLOSE csr_legislation;
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE', 'NZ');
138: hr_utility.raise_error;
139: END IF;
140: CLOSE csr_legislation;
141:
142: hr_utility.set_location(l_proc, 20);
138: hr_utility.raise_error;
139: END IF;
140: CLOSE csr_legislation;
141:
142: hr_utility.set_location(l_proc, 20);
143:
144: --
145: -- Call update_emp_asg business process
146: --
231: ,p_other_manager_warning => p_other_manager_warning
232: ,p_hourly_salaried_warning => p_hourly_salaried_warning
233: ,p_gsp_post_process_warning => p_gsp_post_process_warning
234: );
235: hr_utility.set_location(' Leaving:'||l_proc, 30);
236: END update_nz_emp_asg;
237:
238:
239: ------------------------------------------------------------------------------
393: AND pbg.legislation_code = 'NZ';
394:
395:
396: BEGIN
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398:
399: --
400: -- Initialise local variable
401: --
411: FETCH csr_legislation INTO l_legislation_code;
412: IF (csr_legislation%NOTFOUND)
413: THEN
414: CLOSE csr_legislation;
415: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
416: hr_utility.set_message_token('LEG_CODE', 'NZ');
417: hr_utility.raise_error;
418: END IF;
419: CLOSE csr_legislation;
412: IF (csr_legislation%NOTFOUND)
413: THEN
414: CLOSE csr_legislation;
415: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
416: hr_utility.set_message_token('LEG_CODE', 'NZ');
417: hr_utility.raise_error;
418: END IF;
419: CLOSE csr_legislation;
420: --
413: THEN
414: CLOSE csr_legislation;
415: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
416: hr_utility.set_message_token('LEG_CODE', 'NZ');
417: hr_utility.raise_error;
418: END IF;
419: CLOSE csr_legislation;
420: --
421: hr_utility.set_location(l_proc, 20);
417: hr_utility.raise_error;
418: END IF;
419: CLOSE csr_legislation;
420: --
421: hr_utility.set_location(l_proc, 20);
422: --
423: -- Call create_secondary_emp_asg
424: --
425: hr_assignment_api.create_secondary_emp_asg
552: ,p_hourly_salaried_warning => p_hourly_salaried_warning
553: ,p_gsp_post_process_warning => p_gsp_post_process_warning
554: );
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 30);
557: --
558: END create_nz_secondary_emp_asg;
559:
560: END hr_nz_assignment_api;