41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'cwb_matrix_dtl_id'
48: ,p_argument_value => p_cwb_matrix_dtl_id
49: );
67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'cwb_matrix_dtl_id'
112: ,p_argument_value => p_cwb_matrix_dtl_id
113: );
111: ,p_argument => 'cwb_matrix_dtl_id'
112: ,p_argument_value => p_cwb_matrix_dtl_id
113: );
114: --
115: if ( nvl(ben_bcd_bus.g_cwb_matrix_dtl_id, hr_api.g_number)
116: = p_cwb_matrix_dtl_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global
249: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id,
250: p_object_version_number => p_object_version_number);
251: --
252: if (l_api_updating
253: and nvl(p_cwb_matrix_id, hr_api.g_number)
254: <> nvl(ben_bcd_shd.g_old_rec.cwb_matrix_id, hr_api.g_number)
255: or not l_api_updating) then
256: --
257: -- check if cwb_matrix_id value exists in
250: p_object_version_number => p_object_version_number);
251: --
252: if (l_api_updating
253: and nvl(p_cwb_matrix_id, hr_api.g_number)
254: <> nvl(ben_bcd_shd.g_old_rec.cwb_matrix_id, hr_api.g_number)
255: or not l_api_updating) then
256: --
257: -- check if cwb_matrix_id value exists in
258: -- ben_cwb_matrix table
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- Call all supporting business operations
295: --
296: hr_api.validate_bus_grp_id
297: (p_business_group_id => p_rec.business_group_id
298: ,p_associated_column1 => ben_bcd_shd.g_tab_nam
299: || '.BUSINESS_GROUP_ID');
300: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: hr_api.validate_bus_grp_id
332: (p_business_group_id => p_rec.business_group_id
333: ,p_associated_column1 => ben_bcd_shd.g_tab_nam
334: || '.BUSINESS_GROUP_ID');
335: --