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_UPD dependencies on PQH_TJR_SHD

Line 55: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 118: pqh_tjr_shd.constraint_error

114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: --
118: pqh_tjr_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: --

Line 123: pqh_tjr_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: --
123: pqh_tjr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: --

Line 128: pqh_tjr_shd.constraint_error

124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: --
128: pqh_tjr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: --
132: Raise;

Line 168: (p_rec in pqh_tjr_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_update
168: (p_rec in pqh_tjr_shd.g_rec_type
169: ) is
170: --
171: l_proc varchar2(72) := g_package||'pre_update';
172: --

Line 212: (p_rec in pqh_tjr_shd.g_rec_type

208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure post_update
212: (p_rec in pqh_tjr_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --

Line 295: => pqh_tjr_shd.g_old_rec.position_transaction_id

291: => p_rec.attribute20
292: ,p_comments
293: => p_rec.comments
294: ,p_position_transaction_id_o
295: => pqh_tjr_shd.g_old_rec.position_transaction_id
296: ,p_job_requirement_id_o
297: => pqh_tjr_shd.g_old_rec.job_requirement_id
298: ,p_business_group_id_o
299: => pqh_tjr_shd.g_old_rec.business_group_id

Line 297: => pqh_tjr_shd.g_old_rec.job_requirement_id

293: => p_rec.comments
294: ,p_position_transaction_id_o
295: => pqh_tjr_shd.g_old_rec.position_transaction_id
296: ,p_job_requirement_id_o
297: => pqh_tjr_shd.g_old_rec.job_requirement_id
298: ,p_business_group_id_o
299: => pqh_tjr_shd.g_old_rec.business_group_id
300: ,p_analysis_criteria_id_o
301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id

Line 299: => pqh_tjr_shd.g_old_rec.business_group_id

295: => pqh_tjr_shd.g_old_rec.position_transaction_id
296: ,p_job_requirement_id_o
297: => pqh_tjr_shd.g_old_rec.job_requirement_id
298: ,p_business_group_id_o
299: => pqh_tjr_shd.g_old_rec.business_group_id
300: ,p_analysis_criteria_id_o
301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
302: ,p_date_from_o
303: => pqh_tjr_shd.g_old_rec.date_from

Line 301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id

297: => pqh_tjr_shd.g_old_rec.job_requirement_id
298: ,p_business_group_id_o
299: => pqh_tjr_shd.g_old_rec.business_group_id
300: ,p_analysis_criteria_id_o
301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
302: ,p_date_from_o
303: => pqh_tjr_shd.g_old_rec.date_from
304: ,p_date_to_o
305: => pqh_tjr_shd.g_old_rec.date_to

Line 303: => pqh_tjr_shd.g_old_rec.date_from

299: => pqh_tjr_shd.g_old_rec.business_group_id
300: ,p_analysis_criteria_id_o
301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
302: ,p_date_from_o
303: => pqh_tjr_shd.g_old_rec.date_from
304: ,p_date_to_o
305: => pqh_tjr_shd.g_old_rec.date_to
306: ,p_essential_o
307: => pqh_tjr_shd.g_old_rec.essential

Line 305: => pqh_tjr_shd.g_old_rec.date_to

301: => pqh_tjr_shd.g_old_rec.analysis_criteria_id
302: ,p_date_from_o
303: => pqh_tjr_shd.g_old_rec.date_from
304: ,p_date_to_o
305: => pqh_tjr_shd.g_old_rec.date_to
306: ,p_essential_o
307: => pqh_tjr_shd.g_old_rec.essential
308: ,p_job_id_o
309: => pqh_tjr_shd.g_old_rec.job_id

Line 307: => pqh_tjr_shd.g_old_rec.essential

303: => pqh_tjr_shd.g_old_rec.date_from
304: ,p_date_to_o
305: => pqh_tjr_shd.g_old_rec.date_to
306: ,p_essential_o
307: => pqh_tjr_shd.g_old_rec.essential
308: ,p_job_id_o
309: => pqh_tjr_shd.g_old_rec.job_id
310: ,p_object_version_number_o
311: => pqh_tjr_shd.g_old_rec.object_version_number

Line 309: => pqh_tjr_shd.g_old_rec.job_id

305: => pqh_tjr_shd.g_old_rec.date_to
306: ,p_essential_o
307: => pqh_tjr_shd.g_old_rec.essential
308: ,p_job_id_o
309: => pqh_tjr_shd.g_old_rec.job_id
310: ,p_object_version_number_o
311: => pqh_tjr_shd.g_old_rec.object_version_number
312: ,p_request_id_o
313: => pqh_tjr_shd.g_old_rec.request_id

Line 311: => pqh_tjr_shd.g_old_rec.object_version_number

307: => pqh_tjr_shd.g_old_rec.essential
308: ,p_job_id_o
309: => pqh_tjr_shd.g_old_rec.job_id
310: ,p_object_version_number_o
311: => pqh_tjr_shd.g_old_rec.object_version_number
312: ,p_request_id_o
313: => pqh_tjr_shd.g_old_rec.request_id
314: ,p_program_application_id_o
315: => pqh_tjr_shd.g_old_rec.program_application_id

Line 313: => pqh_tjr_shd.g_old_rec.request_id

309: => pqh_tjr_shd.g_old_rec.job_id
310: ,p_object_version_number_o
311: => pqh_tjr_shd.g_old_rec.object_version_number
312: ,p_request_id_o
313: => pqh_tjr_shd.g_old_rec.request_id
314: ,p_program_application_id_o
315: => pqh_tjr_shd.g_old_rec.program_application_id
316: ,p_program_id_o
317: => pqh_tjr_shd.g_old_rec.program_id

Line 315: => pqh_tjr_shd.g_old_rec.program_application_id

311: => pqh_tjr_shd.g_old_rec.object_version_number
312: ,p_request_id_o
313: => pqh_tjr_shd.g_old_rec.request_id
314: ,p_program_application_id_o
315: => pqh_tjr_shd.g_old_rec.program_application_id
316: ,p_program_id_o
317: => pqh_tjr_shd.g_old_rec.program_id
318: ,p_program_update_date_o
319: => pqh_tjr_shd.g_old_rec.program_update_date

Line 317: => pqh_tjr_shd.g_old_rec.program_id

313: => pqh_tjr_shd.g_old_rec.request_id
314: ,p_program_application_id_o
315: => pqh_tjr_shd.g_old_rec.program_application_id
316: ,p_program_id_o
317: => pqh_tjr_shd.g_old_rec.program_id
318: ,p_program_update_date_o
319: => pqh_tjr_shd.g_old_rec.program_update_date
320: ,p_attribute_category_o
321: => pqh_tjr_shd.g_old_rec.attribute_category

Line 319: => pqh_tjr_shd.g_old_rec.program_update_date

315: => pqh_tjr_shd.g_old_rec.program_application_id
316: ,p_program_id_o
317: => pqh_tjr_shd.g_old_rec.program_id
318: ,p_program_update_date_o
319: => pqh_tjr_shd.g_old_rec.program_update_date
320: ,p_attribute_category_o
321: => pqh_tjr_shd.g_old_rec.attribute_category
322: ,p_attribute1_o
323: => pqh_tjr_shd.g_old_rec.attribute1

Line 321: => pqh_tjr_shd.g_old_rec.attribute_category

317: => pqh_tjr_shd.g_old_rec.program_id
318: ,p_program_update_date_o
319: => pqh_tjr_shd.g_old_rec.program_update_date
320: ,p_attribute_category_o
321: => pqh_tjr_shd.g_old_rec.attribute_category
322: ,p_attribute1_o
323: => pqh_tjr_shd.g_old_rec.attribute1
324: ,p_attribute2_o
325: => pqh_tjr_shd.g_old_rec.attribute2

Line 323: => pqh_tjr_shd.g_old_rec.attribute1

319: => pqh_tjr_shd.g_old_rec.program_update_date
320: ,p_attribute_category_o
321: => pqh_tjr_shd.g_old_rec.attribute_category
322: ,p_attribute1_o
323: => pqh_tjr_shd.g_old_rec.attribute1
324: ,p_attribute2_o
325: => pqh_tjr_shd.g_old_rec.attribute2
326: ,p_attribute3_o
327: => pqh_tjr_shd.g_old_rec.attribute3

Line 325: => pqh_tjr_shd.g_old_rec.attribute2

321: => pqh_tjr_shd.g_old_rec.attribute_category
322: ,p_attribute1_o
323: => pqh_tjr_shd.g_old_rec.attribute1
324: ,p_attribute2_o
325: => pqh_tjr_shd.g_old_rec.attribute2
326: ,p_attribute3_o
327: => pqh_tjr_shd.g_old_rec.attribute3
328: ,p_attribute4_o
329: => pqh_tjr_shd.g_old_rec.attribute4

Line 327: => pqh_tjr_shd.g_old_rec.attribute3

323: => pqh_tjr_shd.g_old_rec.attribute1
324: ,p_attribute2_o
325: => pqh_tjr_shd.g_old_rec.attribute2
326: ,p_attribute3_o
327: => pqh_tjr_shd.g_old_rec.attribute3
328: ,p_attribute4_o
329: => pqh_tjr_shd.g_old_rec.attribute4
330: ,p_attribute5_o
331: => pqh_tjr_shd.g_old_rec.attribute5

Line 329: => pqh_tjr_shd.g_old_rec.attribute4

325: => pqh_tjr_shd.g_old_rec.attribute2
326: ,p_attribute3_o
327: => pqh_tjr_shd.g_old_rec.attribute3
328: ,p_attribute4_o
329: => pqh_tjr_shd.g_old_rec.attribute4
330: ,p_attribute5_o
331: => pqh_tjr_shd.g_old_rec.attribute5
332: ,p_attribute6_o
333: => pqh_tjr_shd.g_old_rec.attribute6

Line 331: => pqh_tjr_shd.g_old_rec.attribute5

327: => pqh_tjr_shd.g_old_rec.attribute3
328: ,p_attribute4_o
329: => pqh_tjr_shd.g_old_rec.attribute4
330: ,p_attribute5_o
331: => pqh_tjr_shd.g_old_rec.attribute5
332: ,p_attribute6_o
333: => pqh_tjr_shd.g_old_rec.attribute6
334: ,p_attribute7_o
335: => pqh_tjr_shd.g_old_rec.attribute7

Line 333: => pqh_tjr_shd.g_old_rec.attribute6

329: => pqh_tjr_shd.g_old_rec.attribute4
330: ,p_attribute5_o
331: => pqh_tjr_shd.g_old_rec.attribute5
332: ,p_attribute6_o
333: => pqh_tjr_shd.g_old_rec.attribute6
334: ,p_attribute7_o
335: => pqh_tjr_shd.g_old_rec.attribute7
336: ,p_attribute8_o
337: => pqh_tjr_shd.g_old_rec.attribute8

Line 335: => pqh_tjr_shd.g_old_rec.attribute7

331: => pqh_tjr_shd.g_old_rec.attribute5
332: ,p_attribute6_o
333: => pqh_tjr_shd.g_old_rec.attribute6
334: ,p_attribute7_o
335: => pqh_tjr_shd.g_old_rec.attribute7
336: ,p_attribute8_o
337: => pqh_tjr_shd.g_old_rec.attribute8
338: ,p_attribute9_o
339: => pqh_tjr_shd.g_old_rec.attribute9

Line 337: => pqh_tjr_shd.g_old_rec.attribute8

333: => pqh_tjr_shd.g_old_rec.attribute6
334: ,p_attribute7_o
335: => pqh_tjr_shd.g_old_rec.attribute7
336: ,p_attribute8_o
337: => pqh_tjr_shd.g_old_rec.attribute8
338: ,p_attribute9_o
339: => pqh_tjr_shd.g_old_rec.attribute9
340: ,p_attribute10_o
341: => pqh_tjr_shd.g_old_rec.attribute10

Line 339: => pqh_tjr_shd.g_old_rec.attribute9

335: => pqh_tjr_shd.g_old_rec.attribute7
336: ,p_attribute8_o
337: => pqh_tjr_shd.g_old_rec.attribute8
338: ,p_attribute9_o
339: => pqh_tjr_shd.g_old_rec.attribute9
340: ,p_attribute10_o
341: => pqh_tjr_shd.g_old_rec.attribute10
342: ,p_attribute11_o
343: => pqh_tjr_shd.g_old_rec.attribute11

Line 341: => pqh_tjr_shd.g_old_rec.attribute10

337: => pqh_tjr_shd.g_old_rec.attribute8
338: ,p_attribute9_o
339: => pqh_tjr_shd.g_old_rec.attribute9
340: ,p_attribute10_o
341: => pqh_tjr_shd.g_old_rec.attribute10
342: ,p_attribute11_o
343: => pqh_tjr_shd.g_old_rec.attribute11
344: ,p_attribute12_o
345: => pqh_tjr_shd.g_old_rec.attribute12

Line 343: => pqh_tjr_shd.g_old_rec.attribute11

339: => pqh_tjr_shd.g_old_rec.attribute9
340: ,p_attribute10_o
341: => pqh_tjr_shd.g_old_rec.attribute10
342: ,p_attribute11_o
343: => pqh_tjr_shd.g_old_rec.attribute11
344: ,p_attribute12_o
345: => pqh_tjr_shd.g_old_rec.attribute12
346: ,p_attribute13_o
347: => pqh_tjr_shd.g_old_rec.attribute13

Line 345: => pqh_tjr_shd.g_old_rec.attribute12

341: => pqh_tjr_shd.g_old_rec.attribute10
342: ,p_attribute11_o
343: => pqh_tjr_shd.g_old_rec.attribute11
344: ,p_attribute12_o
345: => pqh_tjr_shd.g_old_rec.attribute12
346: ,p_attribute13_o
347: => pqh_tjr_shd.g_old_rec.attribute13
348: ,p_attribute14_o
349: => pqh_tjr_shd.g_old_rec.attribute14

Line 347: => pqh_tjr_shd.g_old_rec.attribute13

343: => pqh_tjr_shd.g_old_rec.attribute11
344: ,p_attribute12_o
345: => pqh_tjr_shd.g_old_rec.attribute12
346: ,p_attribute13_o
347: => pqh_tjr_shd.g_old_rec.attribute13
348: ,p_attribute14_o
349: => pqh_tjr_shd.g_old_rec.attribute14
350: ,p_attribute15_o
351: => pqh_tjr_shd.g_old_rec.attribute15

Line 349: => pqh_tjr_shd.g_old_rec.attribute14

345: => pqh_tjr_shd.g_old_rec.attribute12
346: ,p_attribute13_o
347: => pqh_tjr_shd.g_old_rec.attribute13
348: ,p_attribute14_o
349: => pqh_tjr_shd.g_old_rec.attribute14
350: ,p_attribute15_o
351: => pqh_tjr_shd.g_old_rec.attribute15
352: ,p_attribute16_o
353: => pqh_tjr_shd.g_old_rec.attribute16

Line 351: => pqh_tjr_shd.g_old_rec.attribute15

347: => pqh_tjr_shd.g_old_rec.attribute13
348: ,p_attribute14_o
349: => pqh_tjr_shd.g_old_rec.attribute14
350: ,p_attribute15_o
351: => pqh_tjr_shd.g_old_rec.attribute15
352: ,p_attribute16_o
353: => pqh_tjr_shd.g_old_rec.attribute16
354: ,p_attribute17_o
355: => pqh_tjr_shd.g_old_rec.attribute17

Line 353: => pqh_tjr_shd.g_old_rec.attribute16

349: => pqh_tjr_shd.g_old_rec.attribute14
350: ,p_attribute15_o
351: => pqh_tjr_shd.g_old_rec.attribute15
352: ,p_attribute16_o
353: => pqh_tjr_shd.g_old_rec.attribute16
354: ,p_attribute17_o
355: => pqh_tjr_shd.g_old_rec.attribute17
356: ,p_attribute18_o
357: => pqh_tjr_shd.g_old_rec.attribute18

Line 355: => pqh_tjr_shd.g_old_rec.attribute17

351: => pqh_tjr_shd.g_old_rec.attribute15
352: ,p_attribute16_o
353: => pqh_tjr_shd.g_old_rec.attribute16
354: ,p_attribute17_o
355: => pqh_tjr_shd.g_old_rec.attribute17
356: ,p_attribute18_o
357: => pqh_tjr_shd.g_old_rec.attribute18
358: ,p_attribute19_o
359: => pqh_tjr_shd.g_old_rec.attribute19

Line 357: => pqh_tjr_shd.g_old_rec.attribute18

353: => pqh_tjr_shd.g_old_rec.attribute16
354: ,p_attribute17_o
355: => pqh_tjr_shd.g_old_rec.attribute17
356: ,p_attribute18_o
357: => pqh_tjr_shd.g_old_rec.attribute18
358: ,p_attribute19_o
359: => pqh_tjr_shd.g_old_rec.attribute19
360: ,p_attribute20_o
361: => pqh_tjr_shd.g_old_rec.attribute20

Line 359: => pqh_tjr_shd.g_old_rec.attribute19

355: => pqh_tjr_shd.g_old_rec.attribute17
356: ,p_attribute18_o
357: => pqh_tjr_shd.g_old_rec.attribute18
358: ,p_attribute19_o
359: => pqh_tjr_shd.g_old_rec.attribute19
360: ,p_attribute20_o
361: => pqh_tjr_shd.g_old_rec.attribute20
362: ,p_comments_o
363: => pqh_tjr_shd.g_old_rec.comments

Line 361: => pqh_tjr_shd.g_old_rec.attribute20

357: => pqh_tjr_shd.g_old_rec.attribute18
358: ,p_attribute19_o
359: => pqh_tjr_shd.g_old_rec.attribute19
360: ,p_attribute20_o
361: => pqh_tjr_shd.g_old_rec.attribute20
362: ,p_comments_o
363: => pqh_tjr_shd.g_old_rec.comments
364: );
365: --

Line 363: => pqh_tjr_shd.g_old_rec.comments

359: => pqh_tjr_shd.g_old_rec.attribute19
360: ,p_attribute20_o
361: => pqh_tjr_shd.g_old_rec.attribute20
362: ,p_comments_o
363: => pqh_tjr_shd.g_old_rec.comments
364: );
365: --
366: exception
367: --

Line 423: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure convert_defs
423: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
424: ) is
425: --
426: Begin
427: --

Line 435: pqh_tjr_shd.g_old_rec.position_transaction_id;

431: -- is being used then we must set to the 'current' argument value.
432: --
433: If (p_rec.position_transaction_id = hr_api.g_number) then
434: p_rec.position_transaction_id :=
435: pqh_tjr_shd.g_old_rec.position_transaction_id;
436: End If;
437: If (p_rec.job_requirement_id = hr_api.g_number) then
438: p_rec.job_requirement_id :=
439: pqh_tjr_shd.g_old_rec.job_requirement_id;

Line 439: pqh_tjr_shd.g_old_rec.job_requirement_id;

435: pqh_tjr_shd.g_old_rec.position_transaction_id;
436: End If;
437: If (p_rec.job_requirement_id = hr_api.g_number) then
438: p_rec.job_requirement_id :=
439: pqh_tjr_shd.g_old_rec.job_requirement_id;
440: End If;
441: If (p_rec.business_group_id = hr_api.g_number) then
442: p_rec.business_group_id :=
443: pqh_tjr_shd.g_old_rec.business_group_id;

Line 443: pqh_tjr_shd.g_old_rec.business_group_id;

439: pqh_tjr_shd.g_old_rec.job_requirement_id;
440: End If;
441: If (p_rec.business_group_id = hr_api.g_number) then
442: p_rec.business_group_id :=
443: pqh_tjr_shd.g_old_rec.business_group_id;
444: End If;
445: If (p_rec.analysis_criteria_id = hr_api.g_number) then
446: p_rec.analysis_criteria_id :=
447: pqh_tjr_shd.g_old_rec.analysis_criteria_id;

Line 447: pqh_tjr_shd.g_old_rec.analysis_criteria_id;

443: pqh_tjr_shd.g_old_rec.business_group_id;
444: End If;
445: If (p_rec.analysis_criteria_id = hr_api.g_number) then
446: p_rec.analysis_criteria_id :=
447: pqh_tjr_shd.g_old_rec.analysis_criteria_id;
448: End If;
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=
451: pqh_tjr_shd.g_old_rec.date_from;

Line 451: pqh_tjr_shd.g_old_rec.date_from;

447: pqh_tjr_shd.g_old_rec.analysis_criteria_id;
448: End If;
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=
451: pqh_tjr_shd.g_old_rec.date_from;
452: End If;
453: If (p_rec.date_to = hr_api.g_date) then
454: p_rec.date_to :=
455: pqh_tjr_shd.g_old_rec.date_to;

Line 455: pqh_tjr_shd.g_old_rec.date_to;

451: pqh_tjr_shd.g_old_rec.date_from;
452: End If;
453: If (p_rec.date_to = hr_api.g_date) then
454: p_rec.date_to :=
455: pqh_tjr_shd.g_old_rec.date_to;
456: End If;
457: If (p_rec.essential = hr_api.g_varchar2) then
458: p_rec.essential :=
459: pqh_tjr_shd.g_old_rec.essential;

Line 459: pqh_tjr_shd.g_old_rec.essential;

455: pqh_tjr_shd.g_old_rec.date_to;
456: End If;
457: If (p_rec.essential = hr_api.g_varchar2) then
458: p_rec.essential :=
459: pqh_tjr_shd.g_old_rec.essential;
460: End If;
461: If (p_rec.job_id = hr_api.g_number) then
462: p_rec.job_id :=
463: pqh_tjr_shd.g_old_rec.job_id;

Line 463: pqh_tjr_shd.g_old_rec.job_id;

459: pqh_tjr_shd.g_old_rec.essential;
460: End If;
461: If (p_rec.job_id = hr_api.g_number) then
462: p_rec.job_id :=
463: pqh_tjr_shd.g_old_rec.job_id;
464: End If;
465: If (p_rec.request_id = hr_api.g_number) then
466: p_rec.request_id :=
467: pqh_tjr_shd.g_old_rec.request_id;

Line 467: pqh_tjr_shd.g_old_rec.request_id;

463: pqh_tjr_shd.g_old_rec.job_id;
464: End If;
465: If (p_rec.request_id = hr_api.g_number) then
466: p_rec.request_id :=
467: pqh_tjr_shd.g_old_rec.request_id;
468: End If;
469: If (p_rec.program_application_id = hr_api.g_number) then
470: p_rec.program_application_id :=
471: pqh_tjr_shd.g_old_rec.program_application_id;

Line 471: pqh_tjr_shd.g_old_rec.program_application_id;

467: pqh_tjr_shd.g_old_rec.request_id;
468: End If;
469: If (p_rec.program_application_id = hr_api.g_number) then
470: p_rec.program_application_id :=
471: pqh_tjr_shd.g_old_rec.program_application_id;
472: End If;
473: If (p_rec.program_id = hr_api.g_number) then
474: p_rec.program_id :=
475: pqh_tjr_shd.g_old_rec.program_id;

Line 475: pqh_tjr_shd.g_old_rec.program_id;

471: pqh_tjr_shd.g_old_rec.program_application_id;
472: End If;
473: If (p_rec.program_id = hr_api.g_number) then
474: p_rec.program_id :=
475: pqh_tjr_shd.g_old_rec.program_id;
476: End If;
477: If (p_rec.program_update_date = hr_api.g_date) then
478: p_rec.program_update_date :=
479: pqh_tjr_shd.g_old_rec.program_update_date;

Line 479: pqh_tjr_shd.g_old_rec.program_update_date;

475: pqh_tjr_shd.g_old_rec.program_id;
476: End If;
477: If (p_rec.program_update_date = hr_api.g_date) then
478: p_rec.program_update_date :=
479: pqh_tjr_shd.g_old_rec.program_update_date;
480: End If;
481: If (p_rec.attribute_category = hr_api.g_varchar2) then
482: p_rec.attribute_category :=
483: pqh_tjr_shd.g_old_rec.attribute_category;

Line 483: pqh_tjr_shd.g_old_rec.attribute_category;

479: pqh_tjr_shd.g_old_rec.program_update_date;
480: End If;
481: If (p_rec.attribute_category = hr_api.g_varchar2) then
482: p_rec.attribute_category :=
483: pqh_tjr_shd.g_old_rec.attribute_category;
484: End If;
485: If (p_rec.attribute1 = hr_api.g_varchar2) then
486: p_rec.attribute1 :=
487: pqh_tjr_shd.g_old_rec.attribute1;

Line 487: pqh_tjr_shd.g_old_rec.attribute1;

483: pqh_tjr_shd.g_old_rec.attribute_category;
484: End If;
485: If (p_rec.attribute1 = hr_api.g_varchar2) then
486: p_rec.attribute1 :=
487: pqh_tjr_shd.g_old_rec.attribute1;
488: End If;
489: If (p_rec.attribute2 = hr_api.g_varchar2) then
490: p_rec.attribute2 :=
491: pqh_tjr_shd.g_old_rec.attribute2;

Line 491: pqh_tjr_shd.g_old_rec.attribute2;

487: pqh_tjr_shd.g_old_rec.attribute1;
488: End If;
489: If (p_rec.attribute2 = hr_api.g_varchar2) then
490: p_rec.attribute2 :=
491: pqh_tjr_shd.g_old_rec.attribute2;
492: End If;
493: If (p_rec.attribute3 = hr_api.g_varchar2) then
494: p_rec.attribute3 :=
495: pqh_tjr_shd.g_old_rec.attribute3;

Line 495: pqh_tjr_shd.g_old_rec.attribute3;

491: pqh_tjr_shd.g_old_rec.attribute2;
492: End If;
493: If (p_rec.attribute3 = hr_api.g_varchar2) then
494: p_rec.attribute3 :=
495: pqh_tjr_shd.g_old_rec.attribute3;
496: End If;
497: If (p_rec.attribute4 = hr_api.g_varchar2) then
498: p_rec.attribute4 :=
499: pqh_tjr_shd.g_old_rec.attribute4;

Line 499: pqh_tjr_shd.g_old_rec.attribute4;

495: pqh_tjr_shd.g_old_rec.attribute3;
496: End If;
497: If (p_rec.attribute4 = hr_api.g_varchar2) then
498: p_rec.attribute4 :=
499: pqh_tjr_shd.g_old_rec.attribute4;
500: End If;
501: If (p_rec.attribute5 = hr_api.g_varchar2) then
502: p_rec.attribute5 :=
503: pqh_tjr_shd.g_old_rec.attribute5;

Line 503: pqh_tjr_shd.g_old_rec.attribute5;

499: pqh_tjr_shd.g_old_rec.attribute4;
500: End If;
501: If (p_rec.attribute5 = hr_api.g_varchar2) then
502: p_rec.attribute5 :=
503: pqh_tjr_shd.g_old_rec.attribute5;
504: End If;
505: If (p_rec.attribute6 = hr_api.g_varchar2) then
506: p_rec.attribute6 :=
507: pqh_tjr_shd.g_old_rec.attribute6;

Line 507: pqh_tjr_shd.g_old_rec.attribute6;

503: pqh_tjr_shd.g_old_rec.attribute5;
504: End If;
505: If (p_rec.attribute6 = hr_api.g_varchar2) then
506: p_rec.attribute6 :=
507: pqh_tjr_shd.g_old_rec.attribute6;
508: End If;
509: If (p_rec.attribute7 = hr_api.g_varchar2) then
510: p_rec.attribute7 :=
511: pqh_tjr_shd.g_old_rec.attribute7;

Line 511: pqh_tjr_shd.g_old_rec.attribute7;

507: pqh_tjr_shd.g_old_rec.attribute6;
508: End If;
509: If (p_rec.attribute7 = hr_api.g_varchar2) then
510: p_rec.attribute7 :=
511: pqh_tjr_shd.g_old_rec.attribute7;
512: End If;
513: If (p_rec.attribute8 = hr_api.g_varchar2) then
514: p_rec.attribute8 :=
515: pqh_tjr_shd.g_old_rec.attribute8;

Line 515: pqh_tjr_shd.g_old_rec.attribute8;

511: pqh_tjr_shd.g_old_rec.attribute7;
512: End If;
513: If (p_rec.attribute8 = hr_api.g_varchar2) then
514: p_rec.attribute8 :=
515: pqh_tjr_shd.g_old_rec.attribute8;
516: End If;
517: If (p_rec.attribute9 = hr_api.g_varchar2) then
518: p_rec.attribute9 :=
519: pqh_tjr_shd.g_old_rec.attribute9;

Line 519: pqh_tjr_shd.g_old_rec.attribute9;

515: pqh_tjr_shd.g_old_rec.attribute8;
516: End If;
517: If (p_rec.attribute9 = hr_api.g_varchar2) then
518: p_rec.attribute9 :=
519: pqh_tjr_shd.g_old_rec.attribute9;
520: End If;
521: If (p_rec.attribute10 = hr_api.g_varchar2) then
522: p_rec.attribute10 :=
523: pqh_tjr_shd.g_old_rec.attribute10;

Line 523: pqh_tjr_shd.g_old_rec.attribute10;

519: pqh_tjr_shd.g_old_rec.attribute9;
520: End If;
521: If (p_rec.attribute10 = hr_api.g_varchar2) then
522: p_rec.attribute10 :=
523: pqh_tjr_shd.g_old_rec.attribute10;
524: End If;
525: If (p_rec.attribute11 = hr_api.g_varchar2) then
526: p_rec.attribute11 :=
527: pqh_tjr_shd.g_old_rec.attribute11;

Line 527: pqh_tjr_shd.g_old_rec.attribute11;

523: pqh_tjr_shd.g_old_rec.attribute10;
524: End If;
525: If (p_rec.attribute11 = hr_api.g_varchar2) then
526: p_rec.attribute11 :=
527: pqh_tjr_shd.g_old_rec.attribute11;
528: End If;
529: If (p_rec.attribute12 = hr_api.g_varchar2) then
530: p_rec.attribute12 :=
531: pqh_tjr_shd.g_old_rec.attribute12;

Line 531: pqh_tjr_shd.g_old_rec.attribute12;

527: pqh_tjr_shd.g_old_rec.attribute11;
528: End If;
529: If (p_rec.attribute12 = hr_api.g_varchar2) then
530: p_rec.attribute12 :=
531: pqh_tjr_shd.g_old_rec.attribute12;
532: End If;
533: If (p_rec.attribute13 = hr_api.g_varchar2) then
534: p_rec.attribute13 :=
535: pqh_tjr_shd.g_old_rec.attribute13;

Line 535: pqh_tjr_shd.g_old_rec.attribute13;

531: pqh_tjr_shd.g_old_rec.attribute12;
532: End If;
533: If (p_rec.attribute13 = hr_api.g_varchar2) then
534: p_rec.attribute13 :=
535: pqh_tjr_shd.g_old_rec.attribute13;
536: End If;
537: If (p_rec.attribute14 = hr_api.g_varchar2) then
538: p_rec.attribute14 :=
539: pqh_tjr_shd.g_old_rec.attribute14;

Line 539: pqh_tjr_shd.g_old_rec.attribute14;

535: pqh_tjr_shd.g_old_rec.attribute13;
536: End If;
537: If (p_rec.attribute14 = hr_api.g_varchar2) then
538: p_rec.attribute14 :=
539: pqh_tjr_shd.g_old_rec.attribute14;
540: End If;
541: If (p_rec.attribute15 = hr_api.g_varchar2) then
542: p_rec.attribute15 :=
543: pqh_tjr_shd.g_old_rec.attribute15;

Line 543: pqh_tjr_shd.g_old_rec.attribute15;

539: pqh_tjr_shd.g_old_rec.attribute14;
540: End If;
541: If (p_rec.attribute15 = hr_api.g_varchar2) then
542: p_rec.attribute15 :=
543: pqh_tjr_shd.g_old_rec.attribute15;
544: End If;
545: If (p_rec.attribute16 = hr_api.g_varchar2) then
546: p_rec.attribute16 :=
547: pqh_tjr_shd.g_old_rec.attribute16;

Line 547: pqh_tjr_shd.g_old_rec.attribute16;

543: pqh_tjr_shd.g_old_rec.attribute15;
544: End If;
545: If (p_rec.attribute16 = hr_api.g_varchar2) then
546: p_rec.attribute16 :=
547: pqh_tjr_shd.g_old_rec.attribute16;
548: End If;
549: If (p_rec.attribute17 = hr_api.g_varchar2) then
550: p_rec.attribute17 :=
551: pqh_tjr_shd.g_old_rec.attribute17;

Line 551: pqh_tjr_shd.g_old_rec.attribute17;

547: pqh_tjr_shd.g_old_rec.attribute16;
548: End If;
549: If (p_rec.attribute17 = hr_api.g_varchar2) then
550: p_rec.attribute17 :=
551: pqh_tjr_shd.g_old_rec.attribute17;
552: End If;
553: If (p_rec.attribute18 = hr_api.g_varchar2) then
554: p_rec.attribute18 :=
555: pqh_tjr_shd.g_old_rec.attribute18;

Line 555: pqh_tjr_shd.g_old_rec.attribute18;

551: pqh_tjr_shd.g_old_rec.attribute17;
552: End If;
553: If (p_rec.attribute18 = hr_api.g_varchar2) then
554: p_rec.attribute18 :=
555: pqh_tjr_shd.g_old_rec.attribute18;
556: End If;
557: If (p_rec.attribute19 = hr_api.g_varchar2) then
558: p_rec.attribute19 :=
559: pqh_tjr_shd.g_old_rec.attribute19;

Line 559: pqh_tjr_shd.g_old_rec.attribute19;

555: pqh_tjr_shd.g_old_rec.attribute18;
556: End If;
557: If (p_rec.attribute19 = hr_api.g_varchar2) then
558: p_rec.attribute19 :=
559: pqh_tjr_shd.g_old_rec.attribute19;
560: End If;
561: If (p_rec.attribute20 = hr_api.g_varchar2) then
562: p_rec.attribute20 :=
563: pqh_tjr_shd.g_old_rec.attribute20;

Line 563: pqh_tjr_shd.g_old_rec.attribute20;

559: pqh_tjr_shd.g_old_rec.attribute19;
560: End If;
561: If (p_rec.attribute20 = hr_api.g_varchar2) then
562: p_rec.attribute20 :=
563: pqh_tjr_shd.g_old_rec.attribute20;
564: End If;
565: If (p_rec.comments = hr_api.g_varchar2) then
566: p_rec.comments :=
567: pqh_tjr_shd.g_old_rec.comments;

Line 567: pqh_tjr_shd.g_old_rec.comments;

563: pqh_tjr_shd.g_old_rec.attribute20;
564: End If;
565: If (p_rec.comments = hr_api.g_varchar2) then
566: p_rec.comments :=
567: pqh_tjr_shd.g_old_rec.comments;
568: End If;
569: --
570: End convert_defs;
571: --

Line 576: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

572: -- ----------------------------------------------------------------------------
573: -- |---------------------------------< upd >----------------------------------|
574: -- ----------------------------------------------------------------------------
575: Procedure upd
576: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
577: ) is
578: --
579: l_proc varchar2(72) := g_package||'upd';
580: --

Line 586: pqh_tjr_shd.lck

582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: -- We must lock the row which we need to update.
585: --
586: pqh_tjr_shd.lck
587: (p_rec.txn_job_requirement_id
588: ,p_rec.object_version_number
589: );
590: --

Line 659: l_rec pqh_tjr_shd.g_rec_type;

655: ,p_attribute20 in varchar2 default hr_api.g_varchar2
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ) is
658: --
659: l_rec pqh_tjr_shd.g_rec_type;
660: l_proc varchar2(72) := g_package||'upd';
661: --
662: Begin
663: hr_utility.set_location('Entering:'||l_proc, 5);

Line 669: pqh_tjr_shd.convert_args

665: -- Call conversion function to turn arguments into the
666: -- l_rec structure.
667: --
668: l_rec :=
669: pqh_tjr_shd.convert_args
670: (p_txn_job_requirement_id
671: ,p_position_transaction_id
672: ,p_job_requirement_id
673: ,p_business_group_id