APPS.PAY_BLT_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'balance_type_id'
50: ,p_argument_value => p_balance_type_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'balance_type_id'
119: ,p_argument_value => p_balance_type_id
120: );

Line 122: if ( nvl(pay_blt_bus.g_balance_type_id, hr_api.g_number)

118: ,p_argument => 'balance_type_id'
119: ,p_argument_value => p_balance_type_id
120: );
121: --
122: if ( nvl(pay_blt_bus.g_balance_type_id, hr_api.g_number)
123: = p_balance_type_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

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 199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 201: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 203: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 205: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 207: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 209: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 211: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 213: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 215: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 217: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 219: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 221: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 223: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 225: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 227: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 229: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 231: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 233: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 235: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
239: nvl(p_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 237: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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
241: --

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 239: nvl(p_rec.attribute20, 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:
243: -- a) During update, the structure column value or any

Line 320: hr_api.return_legislation_code(p_business_group_id)),

316: pay_balance_types_pkg.chk_balance_type
317: ( p_row_id => null,
318: p_business_group_id => p_business_group_id,
319: p_legislation_code => nvl(p_legislation_code,
320: hr_api.return_legislation_code(p_business_group_id)),
321: p_balance_name => null,
322: p_reporting_name => null,
323: p_assignment_remuneration_flag =>p_assignment_remuneration_flag
324: );

Line 508: nvl(p_balance_uom,hr_api.g_varchar2) <>

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
510: --
511: hr_utility.set_location('Entering:'||l_proc|| ' new :'||p_balance_uom||' old '||pay_blt_shd.g_old_rec.balance_uom, 10);
512: --

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 593: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

589: select '1'
590: from pay_balance_categories_f
591: where balance_category_id = p_balance_category_id
592: and nvl(legislation_code,
593: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
594: nvl(p_legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))
595: and p_effective_date between effective_start_date
596: and effective_end_date;
597: --

Line 594: nvl(p_legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))

590: from pay_balance_categories_f
591: where balance_category_id = p_balance_category_id
592: and nvl(legislation_code,
593: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
594: nvl(p_legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))
595: and p_effective_date between effective_start_date
596: and effective_end_date;
597: --
598: Begin

Line 603: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then

599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: if (p_balance_category_id is null and
602: pay_balance_types_pkg.chk_balance_category_rule(
603: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then
604: hr_api.mandatory_arg_error
605: (p_api_name => l_proc
606: ,p_argument => 'balance_category_id'
607: ,p_argument_value => p_balance_category_id

Line 604: hr_api.mandatory_arg_error

600: --
601: if (p_balance_category_id is null and
602: pay_balance_types_pkg.chk_balance_category_rule(
603: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then
604: hr_api.mandatory_arg_error
605: (p_api_name => l_proc
606: ,p_argument => 'balance_category_id'
607: ,p_argument_value => p_balance_category_id
608: );

Line 651: or nvl(legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

647: where base_balance_type_id is null
648: and balance_type_id = p_base_balance_type_id
649: and ((p_business_group_id is not null
650: and nvl(business_group_id,-1) = p_business_group_id
651: or nvl(legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
652: nvl(p_legislation_code,nvl(hr_api.return_legislation_code(p_business_group_id),'~~nvl~~')))
653: or (p_legislation_code is not null
654: and nvl(legislation_code,' ') = p_legislation_code
655: or business_group_id is not null

Line 652: nvl(p_legislation_code,nvl(hr_api.return_legislation_code(p_business_group_id),'~~nvl~~')))

648: and balance_type_id = p_base_balance_type_id
649: and ((p_business_group_id is not null
650: and nvl(business_group_id,-1) = p_business_group_id
651: or nvl(legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
652: nvl(p_legislation_code,nvl(hr_api.return_legislation_code(p_business_group_id),'~~nvl~~')))
653: or (p_legislation_code is not null
654: and nvl(legislation_code,' ') = p_legislation_code
655: or business_group_id is not null
656: and legislation_code = p_legislation_code)

Line 725: nvl(p_input_value_id,hr_api.g_number) <>

721: -- no balance feed exist except initial feed or there is no balance
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

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 793: nvl(hr_api.return_legislation_code(p_business_group_id), 'NULL')

789: where pbf.balance_type_id = p_balance_type_id
790: and pbf.input_value_id = p_input_value_id
791: and nvl(pbf.business_group_id, -1) = nvl(p_business_group_id, -1)
792: and nvl(pbf.legislation_code, 'NULL') =
793: nvl(hr_api.return_legislation_code(p_business_group_id), 'NULL')
794: and p_effective_date between pbf.effective_start_date
795: and pbf.effective_end_date;
796:
797:

Line 820: => hr_api.return_legislation_code(p_business_group_id)

816: ,p_scale => 1
817: ,p_session_date => p_effective_date
818: ,p_business_group => p_business_group_id
819: ,p_legislation_code
820: => hr_api.return_legislation_code(p_business_group_id)
821: ,p_mode
822: => hr_startup_data_api_support.g_startup_mode
823: );
824: else

Line 933: If nvl(p_rec.business_group_id,hr_api.g_number) <>

929: hr_utility.set_location('Entering:'||l_proc, 10);
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;

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 943: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>

939: End if;
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;

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 953: If nvl(p_rec.balance_type_id,hr_api.g_number) <>

949: End if;
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;

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 965: nvl(p_rec.balance_category_id,hr_api.g_number) <>

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';
969: raise l_error;

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 976: If nvl(p_rec.jurisdiction_level,hr_api.g_number) <>

972: --
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;

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 987: If nvl(p_rec.tax_type,hr_api.g_varchar2) <>

983: --
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;

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 998: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>

994: --
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;

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 1009: hr_api.argument_changed_error

1005: --
1006: hr_utility.set_location('Leaving :'||l_proc, 50);
1007: EXCEPTION
1008: WHEN l_error THEN
1009: hr_api.argument_changed_error
1010: (p_api_name => l_proc
1011: ,p_argument => l_argument);
1012: WHEN OTHERS THEN
1013: RAISE;

Line 1086: hr_api.validate_bus_grp_id

1082: NOT IN ('GENERIC','STARTUP') THEN
1083: --
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: --

Line 1215: hr_api.validate_bus_grp_id

1211: NOT IN ('GENERIC','STARTUP') THEN
1212: --
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: --

Line 1253: if nvl(p_rec.balance_name,hr_api.g_varchar2) <>

1249: ,p_currency_code => p_rec.currency_code
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

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 1278: nvl(p_rec.reporting_name,hr_api.g_varchar2) <>

1274: );
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

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