APPS.BEN_PQC_BUS dependencies on BEN_PQC_SHD

Line 177: (p_rec in ben_pqc_shd.g_rec_type

173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: procedure chk_df
177: (p_rec in ben_pqc_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --

Line 186: nvl(ben_pqc_shd.g_old_rec.pqc_attribute_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.prtt_rmt_rqst_ctfn_prvdd_id is not null) and (
186: nvl(ben_pqc_shd.g_old_rec.pqc_attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pqc_attribute_category, hr_api.g_varchar2) or
188: nvl(ben_pqc_shd.g_old_rec.pqc_attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.pqc_attribute1, hr_api.g_varchar2) or
190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>

Line 188: nvl(ben_pqc_shd.g_old_rec.pqc_attribute1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.prtt_rmt_rqst_ctfn_prvdd_id is not null) and (
186: nvl(ben_pqc_shd.g_old_rec.pqc_attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pqc_attribute_category, hr_api.g_varchar2) or
188: nvl(ben_pqc_shd.g_old_rec.pqc_attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.pqc_attribute1, hr_api.g_varchar2) or
190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.pqc_attribute2, hr_api.g_varchar2) or
192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>

Line 190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>

186: nvl(ben_pqc_shd.g_old_rec.pqc_attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pqc_attribute_category, hr_api.g_varchar2) or
188: nvl(ben_pqc_shd.g_old_rec.pqc_attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.pqc_attribute1, hr_api.g_varchar2) or
190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.pqc_attribute2, hr_api.g_varchar2) or
192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.pqc_attribute3, hr_api.g_varchar2) or
194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>

Line 192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>

188: nvl(ben_pqc_shd.g_old_rec.pqc_attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.pqc_attribute1, hr_api.g_varchar2) or
190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.pqc_attribute2, hr_api.g_varchar2) or
192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.pqc_attribute3, hr_api.g_varchar2) or
194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.pqc_attribute4, hr_api.g_varchar2) or
196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>

Line 194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>

190: nvl(ben_pqc_shd.g_old_rec.pqc_attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.pqc_attribute2, hr_api.g_varchar2) or
192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.pqc_attribute3, hr_api.g_varchar2) or
194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.pqc_attribute4, hr_api.g_varchar2) or
196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.pqc_attribute5, hr_api.g_varchar2) or
198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>

Line 196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>

192: nvl(ben_pqc_shd.g_old_rec.pqc_attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.pqc_attribute3, hr_api.g_varchar2) or
194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.pqc_attribute4, hr_api.g_varchar2) or
196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.pqc_attribute5, hr_api.g_varchar2) or
198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.pqc_attribute6, hr_api.g_varchar2) or
200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>

Line 198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>

194: nvl(ben_pqc_shd.g_old_rec.pqc_attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.pqc_attribute4, hr_api.g_varchar2) or
196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.pqc_attribute5, hr_api.g_varchar2) or
198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.pqc_attribute6, hr_api.g_varchar2) or
200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.pqc_attribute7, hr_api.g_varchar2) or
202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>

Line 200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>

196: nvl(ben_pqc_shd.g_old_rec.pqc_attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.pqc_attribute5, hr_api.g_varchar2) or
198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.pqc_attribute6, hr_api.g_varchar2) or
200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.pqc_attribute7, hr_api.g_varchar2) or
202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.pqc_attribute8, hr_api.g_varchar2) or
204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>

Line 202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>

198: nvl(ben_pqc_shd.g_old_rec.pqc_attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.pqc_attribute6, hr_api.g_varchar2) or
200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.pqc_attribute7, hr_api.g_varchar2) or
202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.pqc_attribute8, hr_api.g_varchar2) or
204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.pqc_attribute9, hr_api.g_varchar2) or
206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>

Line 204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>

200: nvl(ben_pqc_shd.g_old_rec.pqc_attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.pqc_attribute7, hr_api.g_varchar2) or
202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.pqc_attribute8, hr_api.g_varchar2) or
204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.pqc_attribute9, hr_api.g_varchar2) or
206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.pqc_attribute10, hr_api.g_varchar2) or
208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>

Line 206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>

202: nvl(ben_pqc_shd.g_old_rec.pqc_attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.pqc_attribute8, hr_api.g_varchar2) or
204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.pqc_attribute9, hr_api.g_varchar2) or
206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.pqc_attribute10, hr_api.g_varchar2) or
208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.pqc_attribute11, hr_api.g_varchar2) or
210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>

Line 208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>

204: nvl(ben_pqc_shd.g_old_rec.pqc_attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.pqc_attribute9, hr_api.g_varchar2) or
206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.pqc_attribute10, hr_api.g_varchar2) or
208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.pqc_attribute11, hr_api.g_varchar2) or
210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.pqc_attribute12, hr_api.g_varchar2) or
212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>

Line 210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>

206: nvl(ben_pqc_shd.g_old_rec.pqc_attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.pqc_attribute10, hr_api.g_varchar2) or
208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.pqc_attribute11, hr_api.g_varchar2) or
210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.pqc_attribute12, hr_api.g_varchar2) or
212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.pqc_attribute13, hr_api.g_varchar2) or
214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>

Line 212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>

208: nvl(ben_pqc_shd.g_old_rec.pqc_attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.pqc_attribute11, hr_api.g_varchar2) or
210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.pqc_attribute12, hr_api.g_varchar2) or
212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.pqc_attribute13, hr_api.g_varchar2) or
214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.pqc_attribute14, hr_api.g_varchar2) or
216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>

Line 214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>

210: nvl(ben_pqc_shd.g_old_rec.pqc_attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.pqc_attribute12, hr_api.g_varchar2) or
212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.pqc_attribute13, hr_api.g_varchar2) or
214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.pqc_attribute14, hr_api.g_varchar2) or
216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.pqc_attribute15, hr_api.g_varchar2) or
218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>

Line 216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>

212: nvl(ben_pqc_shd.g_old_rec.pqc_attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.pqc_attribute13, hr_api.g_varchar2) or
214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.pqc_attribute14, hr_api.g_varchar2) or
216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.pqc_attribute15, hr_api.g_varchar2) or
218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.pqc_attribute16, hr_api.g_varchar2) or
220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>

Line 218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>

214: nvl(ben_pqc_shd.g_old_rec.pqc_attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.pqc_attribute14, hr_api.g_varchar2) or
216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.pqc_attribute15, hr_api.g_varchar2) or
218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.pqc_attribute16, hr_api.g_varchar2) or
220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.pqc_attribute17, hr_api.g_varchar2) or
222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>

Line 220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>

216: nvl(ben_pqc_shd.g_old_rec.pqc_attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.pqc_attribute15, hr_api.g_varchar2) or
218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.pqc_attribute16, hr_api.g_varchar2) or
220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.pqc_attribute17, hr_api.g_varchar2) or
222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.pqc_attribute18, hr_api.g_varchar2) or
224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>

Line 222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>

218: nvl(ben_pqc_shd.g_old_rec.pqc_attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.pqc_attribute16, hr_api.g_varchar2) or
220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.pqc_attribute17, hr_api.g_varchar2) or
222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.pqc_attribute18, hr_api.g_varchar2) or
224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.pqc_attribute19, hr_api.g_varchar2) or
226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>

Line 224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>

220: nvl(ben_pqc_shd.g_old_rec.pqc_attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.pqc_attribute17, hr_api.g_varchar2) or
222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.pqc_attribute18, hr_api.g_varchar2) or
224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.pqc_attribute19, hr_api.g_varchar2) or
226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.pqc_attribute20, hr_api.g_varchar2) or
228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>

Line 226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>

222: nvl(ben_pqc_shd.g_old_rec.pqc_attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.pqc_attribute18, hr_api.g_varchar2) or
224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.pqc_attribute19, hr_api.g_varchar2) or
226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.pqc_attribute20, hr_api.g_varchar2) or
228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>
229: nvl(p_rec.pqc_attribute21, hr_api.g_varchar2) or
230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>

Line 228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>

224: nvl(ben_pqc_shd.g_old_rec.pqc_attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.pqc_attribute19, hr_api.g_varchar2) or
226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.pqc_attribute20, hr_api.g_varchar2) or
228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>
229: nvl(p_rec.pqc_attribute21, hr_api.g_varchar2) or
230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>
231: nvl(p_rec.pqc_attribute22, hr_api.g_varchar2) or
232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>

Line 230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>

226: nvl(ben_pqc_shd.g_old_rec.pqc_attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.pqc_attribute20, hr_api.g_varchar2) or
228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>
229: nvl(p_rec.pqc_attribute21, hr_api.g_varchar2) or
230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>
231: nvl(p_rec.pqc_attribute22, hr_api.g_varchar2) or
232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>
233: nvl(p_rec.pqc_attribute23, hr_api.g_varchar2) or
234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>

Line 232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>

228: nvl(ben_pqc_shd.g_old_rec.pqc_attribute21, hr_api.g_varchar2) <>
229: nvl(p_rec.pqc_attribute21, hr_api.g_varchar2) or
230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>
231: nvl(p_rec.pqc_attribute22, hr_api.g_varchar2) or
232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>
233: nvl(p_rec.pqc_attribute23, hr_api.g_varchar2) or
234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>
235: nvl(p_rec.pqc_attribute24, hr_api.g_varchar2) or
236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>

Line 234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>

230: nvl(ben_pqc_shd.g_old_rec.pqc_attribute22, hr_api.g_varchar2) <>
231: nvl(p_rec.pqc_attribute22, hr_api.g_varchar2) or
232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>
233: nvl(p_rec.pqc_attribute23, hr_api.g_varchar2) or
234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>
235: nvl(p_rec.pqc_attribute24, hr_api.g_varchar2) or
236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>
237: nvl(p_rec.pqc_attribute25, hr_api.g_varchar2) or
238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>

Line 236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>

232: nvl(ben_pqc_shd.g_old_rec.pqc_attribute23, hr_api.g_varchar2) <>
233: nvl(p_rec.pqc_attribute23, hr_api.g_varchar2) or
234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>
235: nvl(p_rec.pqc_attribute24, hr_api.g_varchar2) or
236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>
237: nvl(p_rec.pqc_attribute25, hr_api.g_varchar2) or
238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>
239: nvl(p_rec.pqc_attribute26, hr_api.g_varchar2) or
240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>

Line 238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>

234: nvl(ben_pqc_shd.g_old_rec.pqc_attribute24, hr_api.g_varchar2) <>
235: nvl(p_rec.pqc_attribute24, hr_api.g_varchar2) or
236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>
237: nvl(p_rec.pqc_attribute25, hr_api.g_varchar2) or
238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>
239: nvl(p_rec.pqc_attribute26, hr_api.g_varchar2) or
240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>
241: nvl(p_rec.pqc_attribute27, hr_api.g_varchar2) or
242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>

Line 240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>

236: nvl(ben_pqc_shd.g_old_rec.pqc_attribute25, hr_api.g_varchar2) <>
237: nvl(p_rec.pqc_attribute25, hr_api.g_varchar2) or
238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>
239: nvl(p_rec.pqc_attribute26, hr_api.g_varchar2) or
240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>
241: nvl(p_rec.pqc_attribute27, hr_api.g_varchar2) or
242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>
243: nvl(p_rec.pqc_attribute28, hr_api.g_varchar2) or
244: nvl(ben_pqc_shd.g_old_rec.pqc_attribute29, hr_api.g_varchar2) <>

Line 242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>

238: nvl(ben_pqc_shd.g_old_rec.pqc_attribute26, hr_api.g_varchar2) <>
239: nvl(p_rec.pqc_attribute26, hr_api.g_varchar2) or
240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>
241: nvl(p_rec.pqc_attribute27, hr_api.g_varchar2) or
242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>
243: nvl(p_rec.pqc_attribute28, hr_api.g_varchar2) or
244: nvl(ben_pqc_shd.g_old_rec.pqc_attribute29, hr_api.g_varchar2) <>
245: nvl(p_rec.pqc_attribute29, hr_api.g_varchar2) or
246: nvl(ben_pqc_shd.g_old_rec.pqc_attribute30, hr_api.g_varchar2) <>

Line 244: nvl(ben_pqc_shd.g_old_rec.pqc_attribute29, hr_api.g_varchar2) <>

240: nvl(ben_pqc_shd.g_old_rec.pqc_attribute27, hr_api.g_varchar2) <>
241: nvl(p_rec.pqc_attribute27, hr_api.g_varchar2) or
242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>
243: nvl(p_rec.pqc_attribute28, hr_api.g_varchar2) or
244: nvl(ben_pqc_shd.g_old_rec.pqc_attribute29, hr_api.g_varchar2) <>
245: nvl(p_rec.pqc_attribute29, hr_api.g_varchar2) or
246: nvl(ben_pqc_shd.g_old_rec.pqc_attribute30, hr_api.g_varchar2) <>
247: nvl(p_rec.pqc_attribute30, hr_api.g_varchar2) ))
248: or (p_rec.prtt_rmt_rqst_ctfn_prvdd_id is null) then

Line 246: nvl(ben_pqc_shd.g_old_rec.pqc_attribute30, hr_api.g_varchar2) <>

242: nvl(ben_pqc_shd.g_old_rec.pqc_attribute28, hr_api.g_varchar2) <>
243: nvl(p_rec.pqc_attribute28, hr_api.g_varchar2) or
244: nvl(ben_pqc_shd.g_old_rec.pqc_attribute29, hr_api.g_varchar2) <>
245: nvl(p_rec.pqc_attribute29, hr_api.g_varchar2) or
246: nvl(ben_pqc_shd.g_old_rec.pqc_attribute30, hr_api.g_varchar2) <>
247: nvl(p_rec.pqc_attribute30, hr_api.g_varchar2) ))
248: or (p_rec.prtt_rmt_rqst_ctfn_prvdd_id is null) then
249: --
250: -- Only execute the validation if absolutely necessary:

Line 357: ,p_rec in ben_pqc_shd.g_rec_type

353: -- {End Of Comments}
354: -- ----------------------------------------------------------------------------
355: Procedure chk_non_updateable_args
356: (p_effective_date in date
357: ,p_rec in ben_pqc_shd.g_rec_type
358: ) IS
359: --
360: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
361: l_error EXCEPTION;

Line 369: IF NOT ben_pqc_shd.api_updating

365: --
366: -- Only proceed with the validation if a row exists for the current
367: -- record in the HR Schema.
368: --
369: IF NOT ben_pqc_shd.api_updating
370: (p_prtt_rmt_rqst_ctfn_prvdd_id => p_rec.prtt_rmt_rqst_ctfn_prvdd_id
371: ,p_effective_date => p_effective_date
372: ,p_object_version_number => p_rec.object_version_number
373: ) THEN

Line 612: (p_rec in ben_pqc_shd.g_rec_type

608: -- ----------------------------------------------------------------------------
609: -- |---------------------------< insert_validate >----------------------------|
610: -- ----------------------------------------------------------------------------
611: Procedure insert_validate
612: (p_rec in ben_pqc_shd.g_rec_type
613: ,p_effective_date in date
614: ,p_datetrack_mode in varchar2
615: ,p_validation_start_date in date
616: ,p_validation_end_date in date

Line 652: (p_rec in ben_pqc_shd.g_rec_type

648: -- ----------------------------------------------------------------------------
649: -- |---------------------------< update_validate >----------------------------|
650: -- ----------------------------------------------------------------------------
651: Procedure update_validate
652: (p_rec in ben_pqc_shd.g_rec_type
653: ,p_effective_date in date
654: ,p_datetrack_mode in varchar2
655: ,p_validation_start_date in date
656: ,p_validation_end_date in date

Line 707: (p_rec in ben_pqc_shd.g_rec_type

703: -- ----------------------------------------------------------------------------
704: -- |---------------------------< delete_validate >----------------------------|
705: -- ----------------------------------------------------------------------------
706: Procedure delete_validate
707: (p_rec in ben_pqc_shd.g_rec_type
708: ,p_effective_date in date
709: ,p_datetrack_mode in varchar2
710: ,p_validation_start_date in date
711: ,p_validation_end_date in date