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.PER_DISABILITY_API dependencies on PER_MEDICAL_ASSESSMENTS

Line 103: l_object_version_number1 per_medical_assessments.object_version_number%TYPE;

99: --
100: l_proc varchar2(72) := g_package||'create_disability';
101: l_disability_id per_disabilities_f.disability_id%TYPE;
102: l_object_version_number per_disabilities_f.object_version_number%TYPE;
103: l_object_version_number1 per_medical_assessments.object_version_number%TYPE;
104: l_effective_date date;
105: l_effective_start_date per_disabilities_f.effective_start_date%TYPE;
106: l_effective_end_date per_disabilities_f.effective_end_date%TYPE;
107: l_registration_date per_disabilities_f.registration_date%TYPE;

Line 408: from per_medical_assessments mea

404: -- get ovn of medical_assessment record
405: -- for update.
406:
407: select mea.object_version_number into l_object_version_number1
408: from per_medical_assessments mea
409: where mea.medical_assessment_id = p_medical_assessment_id;
410:
411: per_medical_assessment_api.update_medical_assessment
412: (p_validate => p_validate

Line 572: from per_medical_assessments mea

568: -- for the current disability_id
569: --
570: cursor c_control_med_assmt is
571: select mea.medical_assessment_id
572: from per_medical_assessments mea
573: where mea.disability_id = p_disability_id
574: and mea.consultation_result = 'DI';
575: --
576: l_proc varchar2(72) := g_package||'update_disability';

Line 580: l_object_version_number1 per_medical_assessments.object_version_number%TYPE;

576: l_proc varchar2(72) := g_package||'update_disability';
577: l_disability_id per_disabilities_f.disability_id%TYPE;
578: l_object_version_number per_disabilities_f.object_version_number%TYPE;
579: l_ovn per_disabilities_f.object_version_number%TYPE := p_object_version_number;
580: l_object_version_number1 per_medical_assessments.object_version_number%TYPE;
581: l_effective_date date;
582: l_effective_start_date per_disabilities_f.effective_start_date%TYPE;
583: l_effective_end_date per_disabilities_f.effective_end_date%TYPE;
584: l_registration_date per_disabilities_f.registration_date%TYPE;

Line 587: l_mea_id per_medical_assessments.medical_assessment_id%TYPE;

583: l_effective_end_date per_disabilities_f.effective_end_date%TYPE;
584: l_registration_date per_disabilities_f.registration_date%TYPE;
585: l_registration_exp_date per_disabilities_f.registration_exp_date%TYPE;
586: --
587: l_mea_id per_medical_assessments.medical_assessment_id%TYPE;
588: l_new_flag boolean := TRUE;
589: begin
590: hr_utility.set_location('Entering:'|| l_proc, 10);
591: --

Line 633: from per_medical_assessments mea

629: --
630: -- unlink previous child medical record first.
631: --
632: select mea.object_version_number into l_object_version_number1
633: from per_medical_assessments mea
634: where mea.medical_assessment_id = l_mea_id;
635:
636: per_medical_assessment_api.update_medical_assessment
637: (p_validate => p_validate

Line 664: from per_medical_assessments mea

660: -- make a new link to new medical assessment child record,
661: -- (as identified by the p_medical_assessment_id value).
662: --
663: select mea.object_version_number into l_object_version_number1
664: from per_medical_assessments mea
665: where mea.medical_assessment_id = p_medical_assessment_id
666: and mea.consultation_result = 'DI'
667: and (mea.disability_id is null or mea.disability_id = p_disability_id);
668:

Line 1025: from per_medical_assessments mea

1021: -- Declare cursors and local variables
1022: --
1023: Cursor csr_mea is
1024: select medical_assessment_id, object_version_number
1025: from per_medical_assessments mea
1026: where mea.disability_id = p_disability_id;
1027: --
1028: --
1029: l_proc varchar2(72) := g_package||'delete_disability';

Line 1034: l_ovn1 per_medical_assessments.object_version_number%TYPE;

1030: l_object_version_number per_disabilities_f.object_version_number%TYPE;
1031: l_ovn per_disabilities_f.object_version_number%TYPE := p_object_version_number;
1032: l_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1033: l_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1034: l_ovn1 per_medical_assessments.object_version_number%TYPE;
1035: l_assessment_id per_medical_assessments.medical_assessment_id%TYPE;
1036: --
1037: begin
1038: --

Line 1035: l_assessment_id per_medical_assessments.medical_assessment_id%TYPE;

1031: l_ovn per_disabilities_f.object_version_number%TYPE := p_object_version_number;
1032: l_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1033: l_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1034: l_ovn1 per_medical_assessments.object_version_number%TYPE;
1035: l_assessment_id per_medical_assessments.medical_assessment_id%TYPE;
1036: --
1037: begin
1038: --
1039: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1076: -- disability record to be deleted in per_medical_assessments table.

1072: --
1073: end;
1074: --
1075: -- Nullify any foreign key references that may exist for the
1076: -- disability record to be deleted in per_medical_assessments table.
1077: -- (required when performing DT Purge only, as this field is not
1078: -- part of date tracked disability entity)
1079: --
1080: if p_datetrack_mode = 'ZAP' then