[Home] [Help]
39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
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
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------
108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
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
126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := psp_poa_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: psp_poa_bus.g_organization_account_id := p_organization_account_id;
154: psp_poa_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------
192: l_proc varchar2(72) := g_package || 'chk_df';
193:
194: --
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.organization_account_id is not null) and (
199: nvl(psp_poa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
272: ,p_attribute15_value => p_rec.attribute15
273: );
274: end if;
275: --
276: hr_utility.set_location(' Leaving:'||l_proc,20);
277: end chk_df;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------< chk_non_updateable_args >------------------------|
606: --
607: l_proc varchar2(72) := g_package||'insert_validate';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Call all supporting business operations
613: --
614: hr_api.validate_bus_grp_id
644: --
645: --
646: psp_poa_bus.chk_df(p_rec);
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: End insert_validate;
650: --
651: -- ----------------------------------------------------------------------------
652: -- |---------------------------< update_validate >----------------------------|
657: --
658: l_proc varchar2(72) := g_package||'update_validate';
659: --
660: Begin
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: -- Call all supporting business operations
664: --
665: hr_api.validate_bus_grp_id
700: --
701: --
702: psp_poa_bus.chk_df(p_rec);
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End update_validate;
706: --
707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
722: End delete_validate;
723:
724:
725: end psp_poa_bus;