[Home] [Help]
36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := ben_pqc_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: ben_pqc_bus.g_prtt_rmt_rqst_ctfn_prvdd_id := p_prtt_rmt_rqst_ctfn_prvdd_id;
142: ben_pqc_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------
179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.prtt_rmt_rqst_ctfn_prvdd_id is not null) and (
186: nvl(ben_pqc_shd.g_old_rec.pqc_attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pqc_attribute_category, hr_api.g_varchar2) or
321: */
322: null ;
323: end if;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc,20);
326: end chk_df;
327: --
328: -- ----------------------------------------------------------------------------
329: -- |-----------------------< chk_non_updateable_args >------------------------|
618: --
619: l_proc varchar2(72) := g_package||'insert_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
641: --
642: --
643: ben_pqc_bus.chk_df(p_rec);
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: End insert_validate;
647: --
648: -- ----------------------------------------------------------------------------
649: -- |---------------------------< update_validate >----------------------------|
658: --
659: l_proc varchar2(72) := g_package||'update_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call all supporting business operations
665: --
666: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
696: --
697: --
698: ben_pqc_bus.chk_df(p_rec);
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: End update_validate;
702: --
703: -- ----------------------------------------------------------------------------
704: -- |---------------------------< 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: dt_delete_validate
724: ,p_validation_end_date => p_validation_end_date
725: ,p_prtt_rmt_rqst_ctfn_prvdd_id => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
726: );
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: End delete_validate;
730: --
731: end ben_pqc_bus;