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 423: if( p_balance_name <> nvl(pay_blt_shd.g_old_rec.balance_name,p_balance_name)) then

419: null);
420: --
421: hr_utility.set_location('Entering:'||l_proc, 10);
422: --
423: if( p_balance_name <> nvl(pay_blt_shd.g_old_rec.balance_name,p_balance_name)) then
424: --
425: -- Check db items exist for this balance
426: --
427: open chk_db_items;

Line 505: elsif((pay_blt_shd.api_updating

501: --
502: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
503: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
504: fnd_message.raise_error;
505: elsif((pay_blt_shd.api_updating
506: (p_balance_type_id => p_balance_type_id
507: ,p_object_version_number => p_object_version_number)) and
508: nvl(p_balance_uom,hr_api.g_varchar2) <>
509: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then

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

505: elsif((pay_blt_shd.api_updating
506: (p_balance_type_id => p_balance_type_id
507: ,p_object_version_number => p_object_version_number)) and
508: nvl(p_balance_uom,hr_api.g_varchar2) <>
509: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
510: --
511: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
512: --
513: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);

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

507: ,p_object_version_number => p_object_version_number)) and
508: nvl(p_balance_uom,hr_api.g_varchar2) <>
509: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
510: --
511: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
512: --
513: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);
514: Fetch c_chk_balance_uom_class into l_class_exists;
515: If c_chk_balance_uom_class%notfound Then

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

509: nvl(pay_blt_shd.g_old_rec.balance_uom,hr_api.g_varchar2)) then
510: --
511: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
512: --
513: Open c_chk_balance_uom_class(pay_blt_shd.g_old_rec.balance_uom);
514: Fetch c_chk_balance_uom_class into l_class_exists;
515: If c_chk_balance_uom_class%notfound Then
516: --
517: Close c_chk_balance_uom_class;

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

722: -- classification exists.
723: --
724: If(p_input_value_id is not null and
725: nvl(p_input_value_id,hr_api.g_number) <>
726: nvl(pay_blt_shd.g_old_rec.input_value_id,hr_api.g_number)) then
727: --
728:
729: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
730: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then

Line 907: ,p_rec in pay_blt_shd.g_rec_type

903: -- {End Of Comments}
904: -- ----------------------------------------------------------------------------
905: Procedure chk_non_updateable_args
906: (p_effective_date in date
907: ,p_rec in pay_blt_shd.g_rec_type
908: ) IS
909: --
910: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
911: l_argument varchar2(80);

Line 919: IF NOT pay_blt_shd.api_updating

915: --
916: -- Only proceed with the validation if a row exists for the current
917: -- record in the HR Schema.
918: --
919: IF NOT pay_blt_shd.api_updating
920: (p_balance_type_id => p_rec.balance_type_id
921: ,p_object_version_number => p_rec.object_version_number
922: ) THEN
923: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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

930: --
931: -- Ensure that the following attributes are not updated.
932: --
933: If nvl(p_rec.business_group_id,hr_api.g_number) <>
934: nvl(pay_blt_shd.g_old_rec.business_group_id,hr_api.g_number) then
935: --
936: l_argument := 'business_group_id';
937: raise l_error;
938: --

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

940: --
941: hr_utility.set_location('Entering:'||l_proc, 15);
942: --
943: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
944: nvl(pay_blt_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
945: --
946: l_argument := 'legislation_code';
947: raise l_error;
948: --

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

950: --
951: hr_utility.set_location('Entering:'||l_proc, 20);
952: --
953: If nvl(p_rec.balance_type_id,hr_api.g_number) <>
954: nvl(pay_blt_shd.g_old_rec.balance_type_id,hr_api.g_number) then
955: --
956: l_argument := 'balance_type_id';
957: raise l_error;
958: --

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

960: --
961: hr_utility.set_location('Entering:'||l_proc, 25);
962: -- balance category can be updated only if it is null
963: --
964: If(pay_blt_shd.g_old_rec.balance_category_id is not null and
965: nvl(p_rec.balance_category_id,hr_api.g_number) <>
966: nvl(pay_blt_shd.g_old_rec.balance_category_id,hr_api.g_number)) then
967: --
968: l_argument := 'balance_category_id';

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

962: -- balance category can be updated only if it is null
963: --
964: If(pay_blt_shd.g_old_rec.balance_category_id is not null and
965: nvl(p_rec.balance_category_id,hr_api.g_number) <>
966: nvl(pay_blt_shd.g_old_rec.balance_category_id,hr_api.g_number)) then
967: --
968: l_argument := 'balance_category_id';
969: raise l_error;
970: --

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

973: hr_utility.set_location('Entering:'||l_proc, 30);
974: -- jurisdiction_level can not be updated
975: --
976: If nvl(p_rec.jurisdiction_level,hr_api.g_number) <>
977: nvl(pay_blt_shd.g_old_rec.jurisdiction_level,hr_api.g_number) then
978: --
979: l_argument := 'jurisdiction_level';
980: raise l_error;
981: --

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

984: hr_utility.set_location('Entering:'||l_proc, 35);
985: -- Tax_Type can not be updated
986: --
987: If nvl(p_rec.tax_type,hr_api.g_varchar2) <>
988: nvl(pay_blt_shd.g_old_rec.tax_type,hr_api.g_varchar2) then
989: --
990: l_argument := 'tax_type';
991: raise l_error;
992: --

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

995: --
996: hr_utility.set_location('Entering:'||l_proc, 45);
997: --
998: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
999: nvl(pay_blt_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
1000: --
1001: l_argument := 'legislation_subgroup';
1002: raise l_error;
1003: --

Line 1065: ,p_rec in pay_blt_shd.g_rec_type

1061: -- |---------------------------< insert_validate >----------------------------|
1062: -- ----------------------------------------------------------------------------
1063: Procedure insert_validate
1064: (p_effective_date in date
1065: ,p_rec in pay_blt_shd.g_rec_type
1066: ) is
1067: --
1068: l_proc varchar2(72) := g_package||'insert_validate';
1069: l_balance_name_warning number;

Line 1088: ,p_associated_column1 => pay_blt_shd.g_tab_nam

1084: -- Validate Important Attributes
1085: --
1086: hr_api.validate_bus_grp_id
1087: (p_business_group_id => p_rec.business_group_id
1088: ,p_associated_column1 => pay_blt_shd.g_tab_nam
1089: || '.BUSINESS_GROUP_ID');
1090: --
1091: -- after validating the set of important attributes,
1092: -- if Multiple Message Detection is enabled and at least

Line 1191: ,p_rec in pay_blt_shd.g_rec_type

1187: -- |---------------------------< update_validate >----------------------------|
1188: -- ----------------------------------------------------------------------------
1189: Procedure update_validate
1190: (p_effective_date in date
1191: ,p_rec in pay_blt_shd.g_rec_type
1192: ,p_balance_name_warning out nocopy number
1193:
1194: ) is
1195: --

Line 1217: ,p_associated_column1 => pay_blt_shd.g_tab_nam

1213: -- Validate Important Attributes
1214: --
1215: hr_api.validate_bus_grp_id
1216: (p_business_group_id => p_rec.business_group_id
1217: ,p_associated_column1 => pay_blt_shd.g_tab_nam
1218: || '.BUSINESS_GROUP_ID');
1219: --
1220: -- After validating the set of important attributes,
1221: -- if Multiple Message Detection is enabled and at least

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

1250: );
1251:
1252: -- ----------------------------------------------------------------------------
1253: if nvl(p_rec.balance_name,hr_api.g_varchar2) <>
1254: nvl(pay_blt_shd.g_old_rec.balance_name,hr_api.g_varchar2) then
1255: chk_balance_name
1256: (p_business_group_id => p_rec.business_group_id
1257: ,p_legislation_code => p_rec.legislation_code
1258: ,p_balance_type_id => p_rec.balance_type_id

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

1275: -- ----------------------------------------------------------------------------
1276:
1277: if (p_rec.reporting_name is not null and
1278: nvl(p_rec.reporting_name,hr_api.g_varchar2) <>
1279: nvl(pay_blt_shd.g_old_rec.reporting_name,hr_api.g_varchar2)) then
1280: chk_reporting_name
1281: (p_business_group_id => p_rec.business_group_id
1282: ,p_legislation_code => p_rec.legislation_code
1283: ,p_reporting_name => p_rec.reporting_name

Line 1325: (p_rec in pay_blt_shd.g_rec_type

1321: -- ----------------------------------------------------------------------------
1322: -- |---------------------------< delete_validate >----------------------------|
1323: -- ----------------------------------------------------------------------------
1324: Procedure delete_validate
1325: (p_rec in pay_blt_shd.g_rec_type
1326: ) is
1327: --
1328: l_proc varchar2(72) := g_package||'delete_validate';
1329: --

Line 1335: ,pay_blt_shd.g_old_rec.business_group_id

1331: hr_utility.set_location('Entering:'||l_proc, 5);
1332: --
1333: --
1334: chk_startup_action(false
1335: ,pay_blt_shd.g_old_rec.business_group_id
1336: ,pay_blt_shd.g_old_rec.legislation_code
1337: );
1338: IF hr_startup_data_api_support.g_startup_mode
1339: NOT IN ('GENERIC','STARTUP') THEN

Line 1336: ,pay_blt_shd.g_old_rec.legislation_code

1332: --
1333: --
1334: chk_startup_action(false
1335: ,pay_blt_shd.g_old_rec.business_group_id
1336: ,pay_blt_shd.g_old_rec.legislation_code
1337: );
1338: IF hr_startup_data_api_support.g_startup_mode
1339: NOT IN ('GENERIC','STARTUP') THEN
1340: --