43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'rate_element_relation_id'
50: ,p_argument_value => p_rate_element_relation_id
51: );
70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'rate_element_relation_id'
119: ,p_argument_value => p_rate_element_relation_id
120: );
118: ,p_argument => 'rate_element_relation_id'
119: ,p_argument_value => p_rate_element_relation_id
120: );
121: --
122: if ( nvl(pqh_rer_bus.g_rate_element_relation_id, hr_api.g_number)
123: = p_rate_element_relation_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
210: -- not been updated.
211: --
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pqh_rer_shd.g_old_rec.business_group_id
215: ,hr_api.g_number
216: ) then
217: hr_api.argument_changed_error
211: --
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pqh_rer_shd.g_old_rec.business_group_id
215: ,hr_api.g_number
216: ) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'BUSINESS_GROUP_ID'
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pqh_rer_shd.g_old_rec.business_group_id
215: ,hr_api.g_number
216: ) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'BUSINESS_GROUP_ID'
220: ,p_base_table => pqh_rer_shd.g_tab_nam
221: );
317: (p_rate_element_relation_id => p_rate_element_relation_id,
318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and nvl(p_criteria_rate_element_id,hr_api.g_number)
322: <> nvl(pqh_rer_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if criteria_rate_element_id value exists in
318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and nvl(p_criteria_rate_element_id,hr_api.g_number)
322: <> nvl(pqh_rer_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if criteria_rate_element_id value exists in
326: -- PQH_CRITERIA_RATE_ELEMENTS table
406: (p_rate_element_relation_id => p_rate_element_relation_id,
407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating
410: and nvl(p_rel_element_type_id,hr_api.g_number)
411: <> nvl(pqh_rer_shd.g_old_rec.rel_element_type_id,hr_api.g_number)
412: or not l_api_updating) then
413: --
414: -- check if rel_element_type_id value exists in
407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating
410: and nvl(p_rel_element_type_id,hr_api.g_number)
411: <> nvl(pqh_rer_shd.g_old_rec.rel_element_type_id,hr_api.g_number)
412: or not l_api_updating) then
413: --
414: -- check if rel_element_type_id value exists in
415: -- PAY_ELEMENT_TYPES_F table
489: (p_rate_element_relation_id => p_rate_element_relation_id,
490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating
493: and nvl(p_rel_input_value_id,hr_api.g_number)
494: <> nvl(pqh_rer_shd.g_old_rec.rel_input_value_id,hr_api.g_number)
495: or not l_api_updating) then
496: --
497: -- check if rel_input_value_id value exists in
490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating
493: and nvl(p_rel_input_value_id,hr_api.g_number)
494: <> nvl(pqh_rer_shd.g_old_rec.rel_input_value_id,hr_api.g_number)
495: or not l_api_updating) then
496: --
497: -- check if rel_input_value_id value exists in
498: -- PAY_INPUT_VALUE_F table
571: (p_rate_element_relation_id => p_rate_element_relation_id,
572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating
575: and nvl(p_business_group_id ,hr_api.g_number)
576: <> nvl(pqh_rer_shd.g_old_rec.business_group_id ,hr_api.g_number)
577: or not l_api_updating) then
578: --
579: -- check if business_group_id value exists in
572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating
575: and nvl(p_business_group_id ,hr_api.g_number)
576: <> nvl(pqh_rer_shd.g_old_rec.business_group_id ,hr_api.g_number)
577: or not l_api_updating) then
578: --
579: -- check if business_group_id value exists in
580: -- HR_ALL_ORGANIZATION_UNITS table
627: p_object_version_number => p_object_version_number);
628: --
629: if (l_api_updating
630: and p_relation_type_cd
631: <> nvl(pqh_rer_shd.g_old_rec.relation_type_cd,hr_api.g_varchar2)
632: or not l_api_updating)
633: and p_relation_type_cd is not null then
634:
635: -- check if value of lookup falls within lookup type.
633: and p_relation_type_cd is not null then
634:
635: -- check if value of lookup falls within lookup type.
636:
637: if hr_api.not_exists_in_hr_lookups
638: (p_lookup_type => 'PQH_RBC_ELMNT_RELATION_TYPE',
639: p_lookup_code => p_relation_type_cd,
640: p_effective_date => p_effective_date) then
641: --
679: NOT IN ('GENERIC','STARTUP') THEN
680: --
681: -- Validate Important Attributes
682: --
683: hr_api.validate_bus_grp_id
684: (p_business_group_id => p_rec.business_group_id
685: ,p_associated_column1 => pqh_rer_shd.g_tab_nam
686: || '.BUSINESS_GROUP_ID');
687: --
755: NOT IN ('GENERIC','STARTUP') THEN
756: --
757: -- Validate Important Attributes
758: --
759: hr_api.validate_bus_grp_id
760: (p_business_group_id => p_rec.business_group_id
761: ,p_associated_column1 => pqh_rer_shd.g_tab_nam
762: || '.BUSINESS_GROUP_ID');
763: --