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