APPS.PQH_TJR_UPD dependencies on HR_API

Line 115: When hr_api.check_integrity_violated Then

111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
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));

Line 119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
123: pqh_tjr_shd.constraint_error

Line 120: When hr_api.parent_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: --
123: pqh_tjr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 124: (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: --
128: pqh_tjr_shd.constraint_error

Line 125: When hr_api.unique_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: --
128: pqh_tjr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 129: (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;
133: End update_dml;

Line 368: when hr_api.cannot_find_prog_unit then

364: );
365: --
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'PQH_TXN_JOB_REQUIREMENTS'
372: ,p_hook_type => 'AU');

Line 370: hr_api.cannot_find_prog_unit_error

366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'PQH_TXN_JOB_REQUIREMENTS'
372: ,p_hook_type => 'AU');
373: --
374: end;

Line 433: If (p_rec.position_transaction_id = hr_api.g_number) then

429: -- p_rec plsql record structure
430: -- to see if a system default is being used. If a system default
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

Line 437: If (p_rec.job_requirement_id = hr_api.g_number) then

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;
440: End If;
441: If (p_rec.business_group_id = hr_api.g_number) then

Line 441: If (p_rec.business_group_id = hr_api.g_number) then

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;
444: End If;
445: If (p_rec.analysis_criteria_id = hr_api.g_number) then

Line 445: If (p_rec.analysis_criteria_id = hr_api.g_number) then

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;
448: End If;
449: If (p_rec.date_from = hr_api.g_date) then

Line 449: If (p_rec.date_from = hr_api.g_date) then

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;
452: End If;
453: If (p_rec.date_to = hr_api.g_date) then

Line 453: If (p_rec.date_to = hr_api.g_date) then

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;
456: End If;
457: If (p_rec.essential = hr_api.g_varchar2) then

Line 457: If (p_rec.essential = hr_api.g_varchar2) then

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;
460: End If;
461: If (p_rec.job_id = hr_api.g_number) then

Line 461: If (p_rec.job_id = hr_api.g_number) then

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;
464: End If;
465: If (p_rec.request_id = hr_api.g_number) then

Line 465: If (p_rec.request_id = hr_api.g_number) then

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;
468: End If;
469: If (p_rec.program_application_id = hr_api.g_number) then

Line 469: If (p_rec.program_application_id = hr_api.g_number) then

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;
472: End If;
473: If (p_rec.program_id = hr_api.g_number) then

Line 473: If (p_rec.program_id = hr_api.g_number) then

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;
476: End If;
477: If (p_rec.program_update_date = hr_api.g_date) then

Line 477: If (p_rec.program_update_date = hr_api.g_date) then

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;
480: End If;
481: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 481: If (p_rec.attribute_category = hr_api.g_varchar2) then

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;
484: End If;
485: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute1 = hr_api.g_varchar2) then

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;
488: End If;
489: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute2 = hr_api.g_varchar2) then

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;
492: End If;
493: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute3 = hr_api.g_varchar2) then

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;
496: End If;
497: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute4 = hr_api.g_varchar2) then

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;
500: End If;
501: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute5 = hr_api.g_varchar2) then

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;
504: End If;
505: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute6 = hr_api.g_varchar2) then

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;
508: End If;
509: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute7 = hr_api.g_varchar2) then

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;
512: End If;
513: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 513: If (p_rec.attribute8 = hr_api.g_varchar2) then

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;
516: End If;
517: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 517: If (p_rec.attribute9 = hr_api.g_varchar2) then

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;
520: End If;
521: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 521: If (p_rec.attribute10 = hr_api.g_varchar2) then

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;
524: End If;
525: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 525: If (p_rec.attribute11 = hr_api.g_varchar2) then

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;
528: End If;
529: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 529: If (p_rec.attribute12 = hr_api.g_varchar2) then

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;
532: End If;
533: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 533: If (p_rec.attribute13 = hr_api.g_varchar2) then

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;
536: End If;
537: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 537: If (p_rec.attribute14 = hr_api.g_varchar2) then

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;
540: End If;
541: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 541: If (p_rec.attribute15 = hr_api.g_varchar2) then

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;
544: End If;
545: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 545: If (p_rec.attribute16 = hr_api.g_varchar2) then

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;
548: End If;
549: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 549: If (p_rec.attribute17 = hr_api.g_varchar2) then

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;
552: End If;
553: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 553: If (p_rec.attribute18 = hr_api.g_varchar2) then

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;
556: End If;
557: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 557: If (p_rec.attribute19 = hr_api.g_varchar2) then

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;
560: End If;
561: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 561: If (p_rec.attribute20 = hr_api.g_varchar2) then

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;
564: End If;
565: If (p_rec.comments = hr_api.g_varchar2) then

Line 565: If (p_rec.comments = hr_api.g_varchar2) then

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;
568: End If;
569: --

Line 623: ,p_business_group_id in number default hr_api.g_number

619: -- ----------------------------------------------------------------------------
620: Procedure upd
621: (p_txn_job_requirement_id in number
622: ,p_object_version_number in out nocopy number
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date

Line 624: ,p_analysis_criteria_id in number default hr_api.g_number

620: Procedure upd
621: (p_txn_job_requirement_id in number
622: ,p_object_version_number in out nocopy number
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date

Line 625: ,p_position_transaction_id in number default hr_api.g_number

621: (p_txn_job_requirement_id in number
622: ,p_object_version_number in out nocopy number
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2

Line 626: ,p_job_requirement_id in number default hr_api.g_number

622: ,p_object_version_number in out nocopy number
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number

Line 627: ,p_date_from in date default hr_api.g_date

623: ,p_business_group_id in number default hr_api.g_number
624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number

Line 628: ,p_date_to in date default hr_api.g_date

624: ,p_analysis_criteria_id in number default hr_api.g_number
625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number

Line 629: ,p_essential in varchar2 default hr_api.g_varchar2

625: ,p_position_transaction_id in number default hr_api.g_number
626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number

Line 630: ,p_job_id in number default hr_api.g_number

626: ,p_job_requirement_id in number default hr_api.g_number
627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date

Line 631: ,p_request_id in number default hr_api.g_number

627: ,p_date_from in date default hr_api.g_date
628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 632: ,p_program_application_id in number default hr_api.g_number

628: ,p_date_to in date default hr_api.g_date
629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 633: ,p_program_id in number default hr_api.g_number

629: ,p_essential in varchar2 default hr_api.g_varchar2
630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 634: ,p_program_update_date in date default hr_api.g_date

630: ,p_job_id in number default hr_api.g_number
631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 635: ,p_attribute_category in varchar2 default hr_api.g_varchar2

631: ,p_request_id in number default hr_api.g_number
632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 636: ,p_attribute1 in varchar2 default hr_api.g_varchar2

632: ,p_program_application_id in number default hr_api.g_number
633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 637: ,p_attribute2 in varchar2 default hr_api.g_varchar2

633: ,p_program_id in number default hr_api.g_number
634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 638: ,p_attribute3 in varchar2 default hr_api.g_varchar2

634: ,p_program_update_date in date default hr_api.g_date
635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 639: ,p_attribute4 in varchar2 default hr_api.g_varchar2

635: ,p_attribute_category in varchar2 default hr_api.g_varchar2
636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 640: ,p_attribute5 in varchar2 default hr_api.g_varchar2

636: ,p_attribute1 in varchar2 default hr_api.g_varchar2
637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 641: ,p_attribute6 in varchar2 default hr_api.g_varchar2

637: ,p_attribute2 in varchar2 default hr_api.g_varchar2
638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 642: ,p_attribute7 in varchar2 default hr_api.g_varchar2

638: ,p_attribute3 in varchar2 default hr_api.g_varchar2
639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 643: ,p_attribute8 in varchar2 default hr_api.g_varchar2

639: ,p_attribute4 in varchar2 default hr_api.g_varchar2
640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 644: ,p_attribute9 in varchar2 default hr_api.g_varchar2

640: ,p_attribute5 in varchar2 default hr_api.g_varchar2
641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 645: ,p_attribute10 in varchar2 default hr_api.g_varchar2

641: ,p_attribute6 in varchar2 default hr_api.g_varchar2
642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 646: ,p_attribute11 in varchar2 default hr_api.g_varchar2

642: ,p_attribute7 in varchar2 default hr_api.g_varchar2
643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 647: ,p_attribute12 in varchar2 default hr_api.g_varchar2

643: ,p_attribute8 in varchar2 default hr_api.g_varchar2
644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 648: ,p_attribute13 in varchar2 default hr_api.g_varchar2

644: ,p_attribute9 in varchar2 default hr_api.g_varchar2
645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 649: ,p_attribute14 in varchar2 default hr_api.g_varchar2

645: ,p_attribute10 in varchar2 default hr_api.g_varchar2
646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 650: ,p_attribute15 in varchar2 default hr_api.g_varchar2

646: ,p_attribute11 in varchar2 default hr_api.g_varchar2
647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 651: ,p_attribute16 in varchar2 default hr_api.g_varchar2

647: ,p_attribute12 in varchar2 default hr_api.g_varchar2
648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
655: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 652: ,p_attribute17 in varchar2 default hr_api.g_varchar2

648: ,p_attribute13 in varchar2 default hr_api.g_varchar2
649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
655: ,p_attribute20 in varchar2 default hr_api.g_varchar2
656: ,p_comments in varchar2 default hr_api.g_varchar2

Line 653: ,p_attribute18 in varchar2 default hr_api.g_varchar2

649: ,p_attribute14 in varchar2 default hr_api.g_varchar2
650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
655: ,p_attribute20 in varchar2 default hr_api.g_varchar2
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ) is

Line 654: ,p_attribute19 in varchar2 default hr_api.g_varchar2

650: ,p_attribute15 in varchar2 default hr_api.g_varchar2
651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
655: ,p_attribute20 in varchar2 default hr_api.g_varchar2
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ) is
658: --

Line 655: ,p_attribute20 in varchar2 default hr_api.g_varchar2

651: ,p_attribute16 in varchar2 default hr_api.g_varchar2
652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
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;

Line 656: ,p_comments in varchar2 default hr_api.g_varchar2

652: ,p_attribute17 in varchar2 default hr_api.g_varchar2
653: ,p_attribute18 in varchar2 default hr_api.g_varchar2
654: ,p_attribute19 in varchar2 default hr_api.g_varchar2
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';