DBA Data[Home] [Help]

APPS.PER_BBA_BUS dependencies on PER_BBA_SHD

Line 171: (p_rec in per_bba_shd.g_rec_type

167: -- Internal Row Handler Use Only.
168: --
169: -- ----------------------------------------------------------------------------
170: procedure chk_df
171: (p_rec in per_bba_shd.g_rec_type
172: ) is
173: --
174: l_proc varchar2(72) := g_package || 'chk_df';
175: --

Line 180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>

176: begin
177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>

Line 182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>

178: --
179: if ((p_rec.balance_amount_id is not null) and (
180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>

Line 184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>

180: nvl(per_bba_shd.g_old_rec.bba_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bba_attribute_category, hr_api.g_varchar2) or
182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>

Line 186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>

182: nvl(per_bba_shd.g_old_rec.bba_attribute1, hr_api.g_varchar2) <>
183: nvl(p_rec.bba_attribute1, hr_api.g_varchar2) or
184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>

Line 188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>

184: nvl(per_bba_shd.g_old_rec.bba_attribute2, hr_api.g_varchar2) <>
185: nvl(p_rec.bba_attribute2, hr_api.g_varchar2) or
186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>

Line 190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>

186: nvl(per_bba_shd.g_old_rec.bba_attribute3, hr_api.g_varchar2) <>
187: nvl(p_rec.bba_attribute3, hr_api.g_varchar2) or
188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>

Line 192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>

188: nvl(per_bba_shd.g_old_rec.bba_attribute4, hr_api.g_varchar2) <>
189: nvl(p_rec.bba_attribute4, hr_api.g_varchar2) or
190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>

Line 194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>

190: nvl(per_bba_shd.g_old_rec.bba_attribute5, hr_api.g_varchar2) <>
191: nvl(p_rec.bba_attribute5, hr_api.g_varchar2) or
192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>

Line 196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>

192: nvl(per_bba_shd.g_old_rec.bba_attribute6, hr_api.g_varchar2) <>
193: nvl(p_rec.bba_attribute6, hr_api.g_varchar2) or
194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>

Line 198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>

194: nvl(per_bba_shd.g_old_rec.bba_attribute7, hr_api.g_varchar2) <>
195: nvl(p_rec.bba_attribute7, hr_api.g_varchar2) or
196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>

Line 200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>

196: nvl(per_bba_shd.g_old_rec.bba_attribute8, hr_api.g_varchar2) <>
197: nvl(p_rec.bba_attribute8, hr_api.g_varchar2) or
198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>

Line 202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>

198: nvl(per_bba_shd.g_old_rec.bba_attribute9, hr_api.g_varchar2) <>
199: nvl(p_rec.bba_attribute9, hr_api.g_varchar2) or
200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>

Line 204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>

200: nvl(per_bba_shd.g_old_rec.bba_attribute10, hr_api.g_varchar2) <>
201: nvl(p_rec.bba_attribute10, hr_api.g_varchar2) or
202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>

Line 206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>

202: nvl(per_bba_shd.g_old_rec.bba_attribute11, hr_api.g_varchar2) <>
203: nvl(p_rec.bba_attribute11, hr_api.g_varchar2) or
204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>

Line 208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>

204: nvl(per_bba_shd.g_old_rec.bba_attribute12, hr_api.g_varchar2) <>
205: nvl(p_rec.bba_attribute12, hr_api.g_varchar2) or
206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>

Line 210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>

206: nvl(per_bba_shd.g_old_rec.bba_attribute13, hr_api.g_varchar2) <>
207: nvl(p_rec.bba_attribute13, hr_api.g_varchar2) or
208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>

Line 212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>

208: nvl(per_bba_shd.g_old_rec.bba_attribute14, hr_api.g_varchar2) <>
209: nvl(p_rec.bba_attribute14, hr_api.g_varchar2) or
210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>

Line 214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>

210: nvl(per_bba_shd.g_old_rec.bba_attribute15, hr_api.g_varchar2) <>
211: nvl(p_rec.bba_attribute15, hr_api.g_varchar2) or
212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>

Line 216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>

212: nvl(per_bba_shd.g_old_rec.bba_attribute16, hr_api.g_varchar2) <>
213: nvl(p_rec.bba_attribute16, hr_api.g_varchar2) or
214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>

Line 218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>

214: nvl(per_bba_shd.g_old_rec.bba_attribute17, hr_api.g_varchar2) <>
215: nvl(p_rec.bba_attribute17, hr_api.g_varchar2) or
216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>

Line 220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>

216: nvl(per_bba_shd.g_old_rec.bba_attribute18, hr_api.g_varchar2) <>
217: nvl(p_rec.bba_attribute18, hr_api.g_varchar2) or
218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>

Line 222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>

218: nvl(per_bba_shd.g_old_rec.bba_attribute19, hr_api.g_varchar2) <>
219: nvl(p_rec.bba_attribute19, hr_api.g_varchar2) or
220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>

Line 224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>

220: nvl(per_bba_shd.g_old_rec.bba_attribute20, hr_api.g_varchar2) <>
221: nvl(p_rec.bba_attribute20, hr_api.g_varchar2) or
222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>

Line 226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>

222: nvl(per_bba_shd.g_old_rec.bba_attribute21, hr_api.g_varchar2) <>
223: nvl(p_rec.bba_attribute21, hr_api.g_varchar2) or
224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>

Line 228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>

224: nvl(per_bba_shd.g_old_rec.bba_attribute22, hr_api.g_varchar2) <>
225: nvl(p_rec.bba_attribute22, hr_api.g_varchar2) or
226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>

Line 230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>

226: nvl(per_bba_shd.g_old_rec.bba_attribute23, hr_api.g_varchar2) <>
227: nvl(p_rec.bba_attribute23, hr_api.g_varchar2) or
228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>

Line 232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>

228: nvl(per_bba_shd.g_old_rec.bba_attribute24, hr_api.g_varchar2) <>
229: nvl(p_rec.bba_attribute24, hr_api.g_varchar2) or
230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>

Line 234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>

230: nvl(per_bba_shd.g_old_rec.bba_attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.bba_attribute25, hr_api.g_varchar2) or
232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>

Line 236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>

232: nvl(per_bba_shd.g_old_rec.bba_attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.bba_attribute26, hr_api.g_varchar2) or
234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>

Line 238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>

234: nvl(per_bba_shd.g_old_rec.bba_attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.bba_attribute27, hr_api.g_varchar2) or
236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then

Line 240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>

236: nvl(per_bba_shd.g_old_rec.bba_attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.bba_attribute28, hr_api.g_varchar2) or
238: nvl(per_bba_shd.g_old_rec.bba_attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.bba_attribute29, hr_api.g_varchar2) or
240: nvl(per_bba_shd.g_old_rec.bba_attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.bba_attribute30, hr_api.g_varchar2) ))
242: or (p_rec.balance_amount_id is null) then
243: --
244: -- Only execute the validation if absolutely necessary:

Line 346: Procedure chk_non_updateable_args(p_rec in per_bba_shd.g_rec_type) IS

342: -- have been altered.
343: --
344: -- {End Of Comments}
345: -- ----------------------------------------------------------------------------
346: Procedure chk_non_updateable_args(p_rec in per_bba_shd.g_rec_type) IS
347: --
348: l_proc varchar2(72) := g_package || 'check_non_updateable_args';
349: l_error EXCEPTION;
350: l_argument varchar2(30);

Line 358: IF NOT per_bba_shd.api_updating

354: --
355: -- Only proceed with the validation if a row exists for the current
356: -- record in the HR Schema.
357: --
358: IF NOT per_bba_shd.api_updating
359: (p_balance_amount_id => p_rec.balance_amount_id
360: ,p_object_version_number => p_rec.object_version_number
361: ) THEN
362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 370: per_bba_shd.g_old_rec.balance_type_id then

366: --
367: hr_utility.set_location(l_proc,10);
368: --
369: IF nvl(p_rec.balance_type_id, hr_api.g_number) <>
370: per_bba_shd.g_old_rec.balance_type_id then
371: l_argument:='balance_type_id';
372: raise l_error;
373: END IF;
374: hr_utility.set_location(l_proc,20);

Line 377: per_bba_shd.g_old_rec.processed_assignment_id then

373: END IF;
374: hr_utility.set_location(l_proc,20);
375: --
376: IF nvl(p_rec.processed_assignment_id, hr_api.g_number) <>
377: per_bba_shd.g_old_rec.processed_assignment_id then
378: l_argument:='processed_assignment_id';
379: raise l_error;
380: END IF;
381: hr_utility.set_location(l_proc,30);

Line 384: per_bba_shd.g_old_rec.business_group_id then

380: END IF;
381: hr_utility.set_location(l_proc,30);
382: --
383: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
384: per_bba_shd.g_old_rec.business_group_id then
385: l_argument:='business_group_id';
386: raise l_error;
387: END IF;
388: hr_utility.set_location(l_proc,40);

Line 444: per_bba_shd.constraint_error

440: CLOSE csr_chk_processed_asg_id;
441: --
442: -- The ID hasn't been found, so error
443: --
444: per_bba_shd.constraint_error
445: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK3');
446: --
447: END IF;
448: CLOSE csr_chk_processed_asg_id;

Line 498: per_bba_shd.constraint_error

494: --
495: -- The balance type either doesn't exist or is in a different BG
496: -- so error.
497: --
498: per_bba_shd.constraint_error
499: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK2');
500: --
501: END IF;
502: --

Line 511: p_rec in per_bba_shd.g_rec_type

507: -- ----------------------------------------------------------------------------
508: -- |---------------------------< insert_validate >----------------------------|
509: -- ----------------------------------------------------------------------------
510: Procedure insert_validate(p_effective_date in date,
511: p_rec in per_bba_shd.g_rec_type
512: ) is
513: --
514: l_proc varchar2(72) := g_package||'insert_validate';
515: --

Line 541: p_rec in per_bba_shd.g_rec_type

537: -- ----------------------------------------------------------------------------
538: -- |---------------------------< update_validate >----------------------------|
539: -- ----------------------------------------------------------------------------
540: Procedure update_validate(p_effective_date in date,
541: p_rec in per_bba_shd.g_rec_type
542: ) is
543: --
544: l_proc varchar2(72) := g_package||'update_validate';
545: --

Line 566: Procedure delete_validate(p_rec in per_bba_shd.g_rec_type) is

562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------< delete_validate >----------------------------|
565: -- ----------------------------------------------------------------------------
566: Procedure delete_validate(p_rec in per_bba_shd.g_rec_type) is
567: --
568: l_proc varchar2(72) := g_package||'delete_validate';
569: --
570: Begin