APPS.PAY_BLT_BUS dependencies on PAY_BLT_SHD

Line 189: (p_rec in pay_blt_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in pay_blt_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(pay_blt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.balance_type_id is not null) and (
198: nvl(pay_blt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(pay_blt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(pay_blt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.balance_type_id is not null) and (
198: nvl(pay_blt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(pay_blt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(pay_blt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(pay_blt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(pay_blt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(pay_blt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(pay_blt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(pay_blt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(pay_blt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(pay_blt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(pay_blt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(pay_blt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(pay_blt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(pay_blt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(pay_blt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(pay_blt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(pay_blt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

226: nvl(pay_blt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

228: nvl(pay_blt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(pay_blt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

230: nvl(pay_blt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(pay_blt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(pay_blt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(pay_blt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

232: nvl(pay_blt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(pay_blt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(pay_blt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.balance_type_id is null) then

Line 238: nvl(pay_blt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

234: nvl(pay_blt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(pay_blt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(pay_blt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.balance_type_id is null) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 451: if( p_balance_name <> nvl(pay_blt_shd.g_old_rec.balance_name,p_balance_name)) then

447: null);
448: --
449: hr_utility.set_location('Entering:'||l_proc, 10);
450: --
451: if( p_balance_name <> nvl(pay_blt_shd.g_old_rec.balance_name,p_balance_name)) then
452: --
453: -- Check db items exist for this balance
454: --
455: open chk_db_items;

Line 533: elsif((pay_blt_shd.api_updating

529: --
530: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
531: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
532: fnd_message.raise_error;
533: elsif((pay_blt_shd.api_updating
534: (p_balance_type_id => p_balance_type_id
535: ,p_object_version_number => p_object_version_number)) and
536: nvl(p_balance_uom,hr_api.g_varchar2) <>
537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then

Line 537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then

533: elsif((pay_blt_shd.api_updating
534: (p_balance_type_id => p_balance_type_id
535: ,p_object_version_number => p_object_version_number)) and
536: nvl(p_balance_uom,hr_api.g_varchar2) <>
537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
538: --
539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
540: --
541: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);

Line 539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);

535: ,p_object_version_number => p_object_version_number)) and
536: nvl(p_balance_uom,hr_api.g_varchar2) <>
537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
538: --
539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
540: --
541: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);
542: Fetch c_chk_balance_uom_class into l_class_exists;
543: If c_chk_balance_uom_class%notfound Then

Line 541: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);

537: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
538: --
539: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
540: --
541: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);
542: Fetch c_chk_balance_uom_class into l_class_exists;
543: If c_chk_balance_uom_class%notfound Then
544: --
545: Close c_chk_balance_uom_class;

Line 754: nvl(pay_blt_shd.g_old_rec.input_value_id,hr_api.g_number)) then

750: -- classification exists.
751: --
752: If(p_input_value_id is not null and
753: nvl(p_input_value_id,hr_api.g_number) <>
754: nvl(pay_blt_shd.g_old_rec.input_value_id,hr_api.g_number)) then
755: --
756:
757: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
758: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then

Line 935: ,p_rec in pay_blt_shd.g_rec_type

931: -- {End Of Comments}
932: -- ----------------------------------------------------------------------------
933: Procedure chk_non_updateable_args
934: (p_effective_date in date
935: ,p_rec in pay_blt_shd.g_rec_type
936: ) IS
937: --
938: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
939: l_argument varchar2(80);

Line 947: IF NOT pay_blt_shd.api_updating

943: --
944: -- Only proceed with the validation if a row exists for the current
945: -- record in the HR Schema.
946: --
947: IF NOT pay_blt_shd.api_updating
948: (p_balance_type_id => p_rec.balance_type_id
949: ,p_object_version_number => p_rec.object_version_number
950: ) THEN
951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 962: nvl(pay_blt_shd.g_old_rec.business_group_id,hr_api.g_number) then

958: --
959: -- Ensure that the following attributes are not updated.
960: --
961: If nvl(p_rec.business_group_id,hr_api.g_number) <>
962: nvl(pay_blt_shd.g_old_rec.business_group_id,hr_api.g_number) then
963: --
964: l_argument := 'business_group_id';
965: raise l_error;
966: --

Line 972: nvl(pay_blt_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then

968: --
969: hr_utility.set_location('Entering:'||l_proc, 15);
970: --
971: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
972: nvl(pay_blt_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
973: --
974: l_argument := 'legislation_code';
975: raise l_error;
976: --

Line 982: nvl(pay_blt_shd.g_old_rec.balance_type_id,hr_api.g_number) then

978: --
979: hr_utility.set_location('Entering:'||l_proc, 20);
980: --
981: If nvl(p_rec.balance_type_id,hr_api.g_number) <>
982: nvl(pay_blt_shd.g_old_rec.balance_type_id,hr_api.g_number) then
983: --
984: l_argument := 'balance_type_id';
985: raise l_error;
986: --

Line 992: If(pay_blt_shd.g_old_rec.balance_category_id is not null and

988: --
989: hr_utility.set_location('Entering:'||l_proc, 25);
990: -- balance category can be updated only if it is null
991: --
992: If(pay_blt_shd.g_old_rec.balance_category_id is not null and
993: nvl(p_rec.balance_category_id,hr_api.g_number) <>
994: nvl(pay_blt_shd.g_old_rec.balance_category_id,hr_api.g_number)) then
995: --
996: l_argument := 'balance_category_id';

Line 994: nvl(pay_blt_shd.g_old_rec.balance_category_id,hr_api.g_number)) then

990: -- balance category can be updated only if it is null
991: --
992: If(pay_blt_shd.g_old_rec.balance_category_id is not null and
993: nvl(p_rec.balance_category_id,hr_api.g_number) <>
994: nvl(pay_blt_shd.g_old_rec.balance_category_id,hr_api.g_number)) then
995: --
996: l_argument := 'balance_category_id';
997: raise l_error;
998: --

Line 1005: nvl(pay_blt_shd.g_old_rec.jurisdiction_level,hr_api.g_number) then

1001: hr_utility.set_location('Entering:'||l_proc, 30);
1002: -- jurisdiction_level can not be updated
1003: --
1004: If nvl(p_rec.jurisdiction_level,hr_api.g_number) <>
1005: nvl(pay_blt_shd.g_old_rec.jurisdiction_level,hr_api.g_number) then
1006: --
1007: l_argument := 'jurisdiction_level';
1008: raise l_error;
1009: --

Line 1016: nvl(pay_blt_shd.g_old_rec.tax_type,hr_api.g_varchar2) then

1012: hr_utility.set_location('Entering:'||l_proc, 35);
1013: -- Tax_Type can not be updated
1014: --
1015: If nvl(p_rec.tax_type,hr_api.g_varchar2) <>
1016: nvl(pay_blt_shd.g_old_rec.tax_type,hr_api.g_varchar2) then
1017: --
1018: l_argument := 'tax_type';
1019: raise l_error;
1020: --

Line 1027: nvl(pay_blt_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then

1023: --
1024: hr_utility.set_location('Entering:'||l_proc, 45);
1025: --
1026: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
1027: nvl(pay_blt_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
1028: --
1029: l_argument := 'legislation_subgroup';
1030: raise l_error;
1031: --

Line 1093: ,p_rec in pay_blt_shd.g_rec_type

1089: -- |---------------------------< insert_validate >----------------------------|
1090: -- ----------------------------------------------------------------------------
1091: Procedure insert_validate
1092: (p_effective_date in date
1093: ,p_rec in pay_blt_shd.g_rec_type
1094: ) is
1095: --
1096: l_proc varchar2(72) := g_package||'insert_validate';
1097: l_balance_name_warning number;

Line 1116: ,p_associated_column1 => pay_blt_shd.g_tab_nam

1112: -- Validate Important Attributes
1113: --
1114: hr_api.validate_bus_grp_id
1115: (p_business_group_id => p_rec.business_group_id
1116: ,p_associated_column1 => pay_blt_shd.g_tab_nam
1117: || '.BUSINESS_GROUP_ID');
1118: --
1119: -- after validating the set of important attributes,
1120: -- if Multiple Message Detection is enabled and at least

Line 1219: ,p_rec in pay_blt_shd.g_rec_type

1215: -- |---------------------------< update_validate >----------------------------|
1216: -- ----------------------------------------------------------------------------
1217: Procedure update_validate
1218: (p_effective_date in date
1219: ,p_rec in pay_blt_shd.g_rec_type
1220: ,p_balance_name_warning out nocopy number
1221:
1222: ) is
1223: --

Line 1245: ,p_associated_column1 => pay_blt_shd.g_tab_nam

1241: -- Validate Important Attributes
1242: --
1243: hr_api.validate_bus_grp_id
1244: (p_business_group_id => p_rec.business_group_id
1245: ,p_associated_column1 => pay_blt_shd.g_tab_nam
1246: || '.BUSINESS_GROUP_ID');
1247: --
1248: -- After validating the set of important attributes,
1249: -- if Multiple Message Detection is enabled and at least

Line 1282: nvl(pay_blt_shd.g_old_rec.balance_name,hr_api.g_varchar2) then

1278: );
1279:
1280: -- ----------------------------------------------------------------------------
1281: if nvl(p_rec.balance_name,hr_api.g_varchar2) <>
1282: nvl(pay_blt_shd.g_old_rec.balance_name,hr_api.g_varchar2) then
1283: chk_balance_name
1284: (p_business_group_id => p_rec.business_group_id
1285: ,p_legislation_code => p_rec.legislation_code
1286: ,p_balance_type_id => p_rec.balance_type_id

Line 1307: nvl(pay_blt_shd.g_old_rec.reporting_name,hr_api.g_varchar2)) then

1303: -- ----------------------------------------------------------------------------
1304:
1305: if (p_rec.reporting_name is not null and
1306: nvl(p_rec.reporting_name,hr_api.g_varchar2) <>
1307: nvl(pay_blt_shd.g_old_rec.reporting_name,hr_api.g_varchar2)) then
1308: chk_reporting_name
1309: (p_business_group_id => p_rec.business_group_id
1310: ,p_legislation_code => p_rec.legislation_code
1311: ,p_reporting_name => p_rec.reporting_name

Line 1353: (p_rec in pay_blt_shd.g_rec_type

1349: -- ----------------------------------------------------------------------------
1350: -- |---------------------------< delete_validate >----------------------------|
1351: -- ----------------------------------------------------------------------------
1352: Procedure delete_validate
1353: (p_rec in pay_blt_shd.g_rec_type
1354: ) is
1355: --
1356: l_proc varchar2(72) := g_package||'delete_validate';
1357: --

Line 1363: ,pay_blt_shd.g_old_rec.business_group_id

1359: hr_utility.set_location('Entering:'||l_proc, 5);
1360: --
1361: --
1362: chk_startup_action(false
1363: ,pay_blt_shd.g_old_rec.business_group_id
1364: ,pay_blt_shd.g_old_rec.legislation_code
1365: );
1366: IF hr_startup_data_api_support.g_startup_mode
1367: NOT IN ('GENERIC','STARTUP') THEN

Line 1364: ,pay_blt_shd.g_old_rec.legislation_code

1360: --
1361: --
1362: chk_startup_action(false
1363: ,pay_blt_shd.g_old_rec.business_group_id
1364: ,pay_blt_shd.g_old_rec.legislation_code
1365: );
1366: IF hr_startup_data_api_support.g_startup_mode
1367: NOT IN ('GENERIC','STARTUP') THEN
1368: --