eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TJR_BUS dependencies on PQH_TJR_SHD

Line 177: (p_rec in pqh_tjr_shd.g_rec_type

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

Line 186: nvl(pqh_tjr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.txn_job_requirement_id is not null) and (
186: nvl(pqh_tjr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(pqh_tjr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 188: nvl(pqh_tjr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.txn_job_requirement_id is not null) and (
186: nvl(pqh_tjr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(pqh_tjr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

186: nvl(pqh_tjr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(pqh_tjr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

188: nvl(pqh_tjr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

190: nvl(pqh_tjr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

192: nvl(pqh_tjr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

194: nvl(pqh_tjr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

196: nvl(pqh_tjr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

198: nvl(pqh_tjr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

200: nvl(pqh_tjr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

202: nvl(pqh_tjr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

204: nvl(pqh_tjr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

206: nvl(pqh_tjr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

208: nvl(pqh_tjr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

210: nvl(pqh_tjr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

212: nvl(pqh_tjr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

214: nvl(pqh_tjr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

216: nvl(pqh_tjr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(pqh_tjr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

218: nvl(pqh_tjr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(pqh_tjr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(pqh_tjr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 224: nvl(pqh_tjr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

220: nvl(pqh_tjr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(pqh_tjr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(pqh_tjr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.txn_job_requirement_id is null) then

Line 226: nvl(pqh_tjr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

222: nvl(pqh_tjr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(pqh_tjr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(pqh_tjr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.txn_job_requirement_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 313: (p_rec in pqh_tjr_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure chk_non_updateable_args
313: (p_rec in pqh_tjr_shd.g_rec_type
314: ) IS
315: --
316: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
317: l_error EXCEPTION;

Line 325: IF NOT pqh_tjr_shd.api_updating

321: --
322: -- Only proceed with the validation if a row exists for the current
323: -- record in the HR Schema.
324: --
325: IF NOT pqh_tjr_shd.api_updating
326: (p_txn_job_requirement_id => p_rec.txn_job_requirement_id
327: ,p_object_version_number => p_rec.object_version_number
328: ) THEN
329: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 351: (p_rec in pqh_tjr_shd.g_rec_type

347: -- ----------------------------------------------------------------------------
348: -- |---------------------------< insert_validate >----------------------------|
349: -- ----------------------------------------------------------------------------
350: Procedure insert_validate
351: (p_rec in pqh_tjr_shd.g_rec_type
352: ) is
353: --
354: l_proc varchar2(72) := g_package||'insert_validate';
355: --

Line 373: (p_rec in pqh_tjr_shd.g_rec_type

369: -- ----------------------------------------------------------------------------
370: -- |---------------------------< update_validate >----------------------------|
371: -- ----------------------------------------------------------------------------
372: Procedure update_validate
373: (p_rec in pqh_tjr_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'update_validate';
377: --

Line 399: (p_rec in pqh_tjr_shd.g_rec_type

395: -- ----------------------------------------------------------------------------
396: -- |---------------------------< delete_validate >----------------------------|
397: -- ----------------------------------------------------------------------------
398: Procedure delete_validate
399: (p_rec in pqh_tjr_shd.g_rec_type
400: ) is
401: --
402: l_proc varchar2(72) := g_package||'delete_validate';
403: --