[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_qig_shd.api_updating
55: (p_effective_date => p_effective_date,
56: p_qua_in_gr_rt_id => p_qua_in_gr_rt_id,
77: end if;
78: --
79: end if;
80: --
81: hr_utility.set_location('Leaving:'||l_proc, 10);
82: --
83: End chk_qua_in_gr_rt_id;
84: --
85: -- ----------------------------------------------------------------------------
145: --
146: --
147: Begin
148: --
149: hr_utility.set_location('Entering:'||l_proc,5);
150: --
151: l_api_updating := ben_qig_shd.api_updating
152: (p_qua_in_gr_rt_id => p_qua_in_gr_rt_id,
153: p_effective_date => p_effective_date,
193: --
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving:'||l_proc,10);
198: --
199: End chk_quar_in_grade_cd;
200: --
201: -- ----------------------------------------------------------------------------
233: l_api_updating boolean;
234: --
235: Begin
236: --
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: l_api_updating := ben_qig_shd.api_updating
240: (p_qua_in_gr_rt_id => p_qua_in_gr_rt_id,
241: p_effective_date => p_effective_date,
262: end if;
263: --
264: end if;
265: --
266: hr_utility.set_location('Leaving:'||l_proc,10);
267: --
268: end chk_excld_flag;
269: --
270: -- ---------------------------------------------------------------------------
291: l_proc varchar2(72) := g_package||'set_security_group_id';
292: --
293: begin
294: --
295: hr_utility.set_location('Entering:'|| l_proc, 10);
296: --
297: -- Ensure that all the mandatory parameter are not null
298: --
299: hr_api.mandatory_arg_error
326: (p_security_group_id => l_security_group_id
327: );
328: end if;
329: --
330: hr_utility.set_location(' Leaving:'|| l_proc, 20);
331: --
332: end set_security_group_id;
333: --
334: -- ---------------------------------------------------------------------------
355: l_proc varchar2(72) := g_package||'return_legislation_code';
356: --
357: Begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);
360: --
361: -- Ensure that all the mandatory parameter are not null
362: --
363: hr_api.mandatory_arg_error
373: -- call to this function. Just return the value in the global
374: -- variable.
375: --
376: l_legislation_code := ben_qig_bus.g_legislation_code;
377: hr_utility.set_location(l_proc, 20);
378: else
379: --
380: -- The ID is different to the last call to this function
381: -- or this is the first call to this function.
390: close csr_leg_code;
391: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
392: fnd_message.raise_error;
393: end if;
394: hr_utility.set_location(l_proc,30);
395: --
396: -- Set the global variables so the values are
397: -- available for the next call to this function.
398: --
399: close csr_leg_code;
400: ben_qig_bus.g_qua_in_gr_rt_id := p_qua_in_gr_rt_id;
401: ben_qig_bus.g_legislation_code := l_legislation_code;
402: end if;
403: hr_utility.set_location(' Leaving:'|| l_proc, 40);
404: return l_legislation_code;
405: end return_legislation_code;
406: --
407: -- ----------------------------------------------------------------------------
438: --
439: l_proc varchar2(72) := g_package || 'chk_df';
440: --
441: begin
442: hr_utility.set_location('Entering:'||l_proc,10);
443: --
444: if ((p_rec.qua_in_gr_rt_id is not null) and (
445: nvl(ben_qig_shd.g_old_rec.qig_attribute_category, hr_api.g_varchar2) <>
446: nvl(p_rec.qig_attribute_category, hr_api.g_varchar2) or
577: ,p_attribute30_value => p_rec.qig_attribute30
578: );
579: end if;
580: --
581: hr_utility.set_location(' Leaving:'||l_proc,20);
582: end chk_df;
583: --
584: -- ----------------------------------------------------------------------------
585: -- |-----------------------< chk_non_updateable_args >------------------------|
687: and business_group_id + 0 = p_business_group_id
688: and ordr_num = p_ordr_num;
689: --
690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
692:
693: --
694: open c1;
695: fetch c1 into l_dummy;
699: fnd_message.raise_error;
700: end if;
701: close c1;
702: --
703: hr_utility.set_location('Leaving:'||l_proc, 15);
704: End chk_duplicate_ordr_num;
705:
706:
707:
907: --
908: l_proc varchar2(72) := g_package||'insert_validate';
909: --
910: Begin
911: hr_utility.set_location('Entering:'||l_proc, 5);
912: --
913: -- Call all supporting business operations
914: --
915: hr_api.validate_bus_grp_id
959: --
960: --
961: -- ben_qig_bus.chk_df(p_rec);
962: --
963: hr_utility.set_location(' Leaving:'||l_proc, 10);
964: End insert_validate;
965: --
966: -- ----------------------------------------------------------------------------
967: -- |---------------------------< update_validate >----------------------------|
976: --
977: l_proc varchar2(72) := g_package||'update_validate';
978: --
979: Begin
980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
982: -- Call all supporting business operations
983: --
984: hr_api.validate_bus_grp_id
1041: --
1042: --
1043: -- ben_qig_bus.chk_df(p_rec);
1044: --
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: End update_validate;
1047: --
1048: -- ----------------------------------------------------------------------------
1049: -- |---------------------------< delete_validate >----------------------------|
1058: --
1059: l_proc varchar2(72) := g_package||'delete_validate';
1060: --
1061: Begin
1062: hr_utility.set_location('Entering:'||l_proc, 5);
1063: --
1064: -- Call all supporting business operations
1065: --
1066: dt_delete_validate
1069: ,p_validation_end_date => p_validation_end_date
1070: ,p_qua_in_gr_rt_id => p_rec.qua_in_gr_rt_id
1071: );
1072: --
1073: hr_utility.set_location(' Leaving:'||l_proc, 10);
1074: End delete_validate;
1075: --
1076: end ben_qig_bus;