DBA Data[Home] [Help]

APPS.PAY_CNU_BUS dependencies on PAY_CNU_SHD

Line 176: (p_rec in pay_cnu_shd.g_rec_type

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_rec in pay_cnu_shd.g_rec_type
177: ) IS
178: --
179: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
180: l_error EXCEPTION;

Line 188: IF NOT pay_cnu_shd.api_updating

184: --
185: -- Only proceed with the validation if a row exists for the current
186: -- record in the HR Schema.
187: --
188: IF NOT pay_cnu_shd.api_updating
189: (p_contribution_usage_id => p_rec.contribution_usage_id
190: ,p_object_version_number => p_rec.object_version_number
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 201: nvl(pay_cnu_shd.g_old_rec.contribution_usage_id, hr_api.g_number) then

197: --
198: --
199: hr_utility.set_location(' Step:'|| l_proc, 10);
200: if nvl(p_rec.contribution_usage_id, hr_api.g_number) <>
201: nvl(pay_cnu_shd.g_old_rec.contribution_usage_id, hr_api.g_number) then
202: l_argument := 'contribution_usage_id';
203: raise l_error;
204: end if;
205: --

Line 208: nvl(pay_cnu_shd.g_old_rec.date_from, hr_api.g_date) then

204: end if;
205: --
206: hr_utility.set_location(' Step:'|| l_proc, 20);
207: if nvl(p_rec.date_from, hr_api.g_date) <>
208: nvl(pay_cnu_shd.g_old_rec.date_from, hr_api.g_date) then
209: l_argument := 'date_from';
210: raise l_error;
211: end if;
212: --

Line 215: nvl(pay_cnu_shd.g_old_rec.group_code, hr_api.g_varchar2) then

211: end if;
212: --
213: hr_utility.set_location(' Step:'|| l_proc, 40);
214: if nvl(p_rec.group_code, hr_api.g_varchar2) <>
215: nvl(pay_cnu_shd.g_old_rec.group_code, hr_api.g_varchar2) then
216: l_argument := 'group_code';
217: raise l_error;
218: end if;
219: --

Line 222: nvl(pay_cnu_shd.g_old_rec.process_type, hr_api.g_varchar2) then

218: end if;
219: --
220: hr_utility.set_location(' Step:'|| l_proc, 50);
221: if nvl(p_rec.process_type, hr_api.g_varchar2) <>
222: nvl(pay_cnu_shd.g_old_rec.process_type, hr_api.g_varchar2) then
223: l_argument := 'process_type';
224: raise l_error;
225: end if;
226: --

Line 229: nvl(pay_cnu_shd.g_old_rec.element_name, hr_api.g_varchar2) then

225: end if;
226: --
227: hr_utility.set_location(' Step:'|| l_proc, 60);
228: if nvl(p_rec.element_name, hr_api.g_varchar2) <>
229: nvl(pay_cnu_shd.g_old_rec.element_name, hr_api.g_varchar2) then
230: l_argument := 'element_name';
231: raise l_error;
232: end if;
233: --

Line 236: nvl(pay_cnu_shd.g_old_rec.rate_type, hr_api.g_varchar2) then

232: end if;
233: --
234: hr_utility.set_location(' Step:'|| l_proc, 70);
235: if nvl(p_rec.rate_type, hr_api.g_varchar2) <>
236: nvl(pay_cnu_shd.g_old_rec.rate_type, hr_api.g_varchar2) then
237: l_argument := 'rate_type';
238: raise l_error;
239: end if;
240: --

Line 243: nvl(pay_cnu_shd.g_old_rec.contribution_code, hr_api.g_varchar2) then

239: end if;
240: --
241: hr_utility.set_location(' Step:'|| l_proc, 80);
242: /* if nvl(p_rec.contribution_code, hr_api.g_varchar2) <>
243: nvl(pay_cnu_shd.g_old_rec.contribution_code, hr_api.g_varchar2) then
244: l_argument := 'contribution_code';
245: raise l_error;
246: end if;
247: --

Line 250: nvl(pay_cnu_shd.g_old_rec.contribution_type, hr_api.g_varchar2) then

246: end if;
247: --
248: hr_utility.set_location(' Step:'|| l_proc, 90);
249: if nvl(p_rec.contribution_type, hr_api.g_varchar2) <>
250: nvl(pay_cnu_shd.g_old_rec.contribution_type, hr_api.g_varchar2) then
251: l_argument := 'contribution_type';
252: raise l_error;
253: end if;*/
254: --

Line 257: nvl(pay_cnu_shd.g_old_rec.contribution_usage_type, hr_api.g_varchar2) then

253: end if;*/
254: --
255: hr_utility.set_location(' Step:'|| l_proc, 100);
256: if nvl(p_rec.contribution_usage_type, hr_api.g_varchar2) <>
257: nvl(pay_cnu_shd.g_old_rec.contribution_usage_type, hr_api.g_varchar2) then
258: l_argument := 'contribution_usage_type';
259: raise l_error;
260: end if;
261: --

Line 264: nvl(pay_cnu_shd.g_old_rec.rate_category, hr_api.g_varchar2) then

260: end if;
261: --
262: hr_utility.set_location(' Step:'|| l_proc, 110);
263: if nvl(p_rec.rate_category, hr_api.g_varchar2) <>
264: nvl(pay_cnu_shd.g_old_rec.rate_category, hr_api.g_varchar2) then
265: l_argument := 'rate_category';
266: raise l_error;
267: end if;
268: --

Line 271: nvl(pay_cnu_shd.g_old_rec.business_group_id, hr_api.g_number) then

267: end if;
268: --
269: hr_utility.set_location(' Step:'|| l_proc, 120);
270: if nvl(p_rec.business_group_id, hr_api.g_number) <>
271: nvl(pay_cnu_shd.g_old_rec.business_group_id, hr_api.g_number) then
272: l_argument := 'business_group_id';
273: raise l_error;
274: end if;
275: --

Line 278: nvl(pay_cnu_shd.g_old_rec.code_rate_id, hr_api.g_number) then

274: end if;
275: --
276: hr_utility.set_location(' Step:'|| l_proc, 130);
277: /*if nvl(p_rec.code_rate_id, hr_api.g_number) <>
278: nvl(pay_cnu_shd.g_old_rec.code_rate_id, hr_api.g_number) then
279: l_argument := 'code_rate_id';
280: raise l_error;
281: end if;*/
282: --

Line 297: ,p_rec in pay_cnu_shd.g_rec_type

293: -- |---------------------------< insert_validate >----------------------------|
294: -- ----------------------------------------------------------------------------
295: Procedure insert_validate
296: (p_effective_date in date
297: ,p_rec in pay_cnu_shd.g_rec_type
298: ,p_code_Rate_id out nocopy PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE
299: ) is
300: --
301: l_proc varchar2(72) := g_package||'insert_validate';

Line 412: ,p_rec in pay_cnu_shd.g_rec_type

408: -- |---------------------------< update_validate >----------------------------|
409: -- ----------------------------------------------------------------------------
410: Procedure update_validate
411: (p_effective_date in date
412: ,p_rec in pay_cnu_shd.g_rec_type
413: ) is
414: --
415: l_proc varchar2(72) := g_package||'update_validate';
416: --

Line 464: (p_rec in pay_cnu_shd.g_rec_type

460: -- ----------------------------------------------------------------------------
461: -- |---------------------------< delete_validate >----------------------------|
462: -- ----------------------------------------------------------------------------
463: Procedure delete_validate
464: (p_rec in pay_cnu_shd.g_rec_type
465: ) is
466: --
467: l_proc varchar2(72) := g_package||'delete_validate';
468: --