[Home] [Help]
48: l_api_updating boolean;
49: --
50: Begin
51: --
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: l_api_updating := ben_jrt_shd.api_updating
55: (p_effective_date => p_effective_date,
56: p_job_rt_id => p_job_rt_id,
77: end if;
78: --
79: end if;
80: --
81: hr_utility.set_location('Leaving:'||l_proc, 10);
82: --
83: End chk_job_rt_id;
84: --
85: -- ----------------------------------------------------------------------------
144: --
145: --
146: Begin
147: --
148: hr_utility.set_location('Entering:'||l_proc,5);
149: --
150: l_api_updating := ben_jrt_shd.api_updating
151: (p_job_rt_id => p_job_rt_id,
152: p_effective_date => p_effective_date,
192: --
193: --
194: end if;
195: --
196: hr_utility.set_location('Leaving:'||l_proc,10);
197: --
198: End chk_job_id;
199: --
200: -- ----------------------------------------------------------------------------
232: l_api_updating boolean;
233: --
234: Begin
235: --
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: l_api_updating := ben_jrt_shd.api_updating
239: (p_job_rt_id => p_job_rt_id,
240: p_effective_date => p_effective_date,
261: end if;
262: --
263: end if;
264: --
265: hr_utility.set_location('Leaving:'||l_proc,10);
266: --
267: end chk_excld_flag;
268: --
269: -- ---------------------------------------------------------------------------
290: l_proc varchar2(72) := g_package||'set_security_group_id';
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: -- Ensure that all the mandatory parameter are not null
297: --
298: hr_api.mandatory_arg_error
325: (p_security_group_id => l_security_group_id
326: );
327: end if;
328: --
329: hr_utility.set_location(' Leaving:'|| l_proc, 20);
330: --
331: end set_security_group_id;
332: --
333: -- ---------------------------------------------------------------------------
354: l_proc varchar2(72) := g_package||'return_legislation_code';
355: --
356: Begin
357: --
358: hr_utility.set_location('Entering:'|| l_proc, 10);
359: --
360: -- Ensure that all the mandatory parameter are not null
361: --
362: hr_api.mandatory_arg_error
372: -- call to this function. Just return the value in the global
373: -- variable.
374: --
375: l_legislation_code := ben_jrt_bus.g_legislation_code;
376: hr_utility.set_location(l_proc, 20);
377: else
378: --
379: -- The ID is different to the last call to this function
380: -- or this is the first call to this function.
389: close csr_leg_code;
390: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
391: fnd_message.raise_error;
392: end if;
393: hr_utility.set_location(l_proc,30);
394: --
395: -- Set the global variables so the values are
396: -- available for the next call to this function.
397: --
398: close csr_leg_code;
399: ben_jrt_bus.g_job_rt_id := p_job_rt_id;
400: ben_jrt_bus.g_legislation_code := l_legislation_code;
401: end if;
402: hr_utility.set_location(' Leaving:'|| l_proc, 40);
403: return l_legislation_code;
404: end return_legislation_code;
405: --
406: -- ----------------------------------------------------------------------------
437: --
438: l_proc varchar2(72) := g_package || 'chk_df';
439: --
440: begin
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443: if ((p_rec.job_rt_id is not null) and (
444: nvl(ben_jrt_shd.g_old_rec.jrt_attribute_category, hr_api.g_varchar2) <>
445: nvl(p_rec.jrt_attribute_category, hr_api.g_varchar2) or
576: ,p_attribute30_value => p_rec.jrt_attribute30
577: );
578: end if;
579: --
580: hr_utility.set_location(' Leaving:'||l_proc,20);
581: end chk_df;
582: --
583: -- ----------------------------------------------------------------------------
584: -- |-----------------------< chk_non_updateable_args >------------------------|
686: and business_group_id + 0 = p_business_group_id
687: and ordr_num = p_ordr_num;
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691:
692: --
693: open c1;
694: fetch c1 into l_dummy;
698: fnd_message.raise_error;
699: end if;
700: close c1;
701: --
702: hr_utility.set_location('Leaving:'||l_proc, 15);
703: End chk_duplicate_ordr_num;
704:
705:
706: --
904: --
905: l_proc varchar2(72) := g_package||'insert_validate';
906: --
907: Begin
908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: -- Call all supporting business operations
911: --
912: hr_api.validate_bus_grp_id
955: --
956: --
957: -- ben_jrt_bus.chk_df(p_rec);
958: --
959: hr_utility.set_location(' Leaving:'||l_proc, 10);
960: End insert_validate;
961: --
962: -- ----------------------------------------------------------------------------
963: -- |---------------------------< update_validate >----------------------------|
972: --
973: l_proc varchar2(72) := g_package||'update_validate';
974: --
975: Begin
976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: -- Call all supporting business operations
979: --
980: hr_api.validate_bus_grp_id
1037: --
1038: --
1039: -- ben_jrt_bus.chk_df(p_rec);
1040: --
1041: hr_utility.set_location(' Leaving:'||l_proc, 10);
1042: End update_validate;
1043: --
1044: -- ----------------------------------------------------------------------------
1045: -- |---------------------------< delete_validate >----------------------------|
1054: --
1055: l_proc varchar2(72) := g_package||'delete_validate';
1056: --
1057: Begin
1058: hr_utility.set_location('Entering:'||l_proc, 5);
1059: --
1060: -- Call all supporting business operations
1061: --
1062: dt_delete_validate
1065: ,p_validation_end_date => p_validation_end_date
1066: ,p_job_rt_id => p_rec.job_rt_id
1067: );
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 10);
1070: End delete_validate;
1071: --
1072: end ben_jrt_bus;