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_MEA_BUS dependencies on PER_MEDICAL_ASSESSMENTS

Line 47: (p_consultation_type IN per_medical_assessments.consultation_type%TYPE

43: --
44: -- ---------------------------------------------------------------------------
45: --
46: PROCEDURE chk_consultation_combination
47: (p_consultation_type IN per_medical_assessments.consultation_type%TYPE
48: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE) IS
49: --
50: -- Declare local variables
51: --

Line 48: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE) IS

44: -- ---------------------------------------------------------------------------
45: --
46: PROCEDURE chk_consultation_combination
47: (p_consultation_type IN per_medical_assessments.consultation_type%TYPE
48: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE) IS
49: --
50: -- Declare local variables
51: --
52: l_proc varchar2(72) := g_package||'chk_combination_id';

Line 103: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE

99: --
100: -- ---------------------------------------------------------------------------
101: --
102: PROCEDURE chk_inc_consul_date
103: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE
104: ,p_incident_id IN per_medical_assessments.incident_id%TYPE) IS
105: --
106: -- Declare Local variables
107: --

Line 104: ,p_incident_id IN per_medical_assessments.incident_id%TYPE) IS

100: -- ---------------------------------------------------------------------------
101: --
102: PROCEDURE chk_inc_consul_date
103: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE
104: ,p_incident_id IN per_medical_assessments.incident_id%TYPE) IS
105: --
106: -- Declare Local variables
107: --
108: l_proc VARCHAR2(72) := g_package||'chk_inc_consul_date';

Line 177: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE

173: --
174: -- ---------------------------------------------------------------------------
175: --
176: PROCEDURE chk_date_combinations
177: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE
178: ,p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS
179: --
180: -- Declare Local variables
181: --

Line 178: ,p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS

174: -- ---------------------------------------------------------------------------
175: --
176: PROCEDURE chk_date_combinations
177: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE
178: ,p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS
179: --
180: -- Declare Local variables
181: --
182: l_proc VARCHAR2(72) := g_package||'chk_consultation_date_combinations';

Line 235: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE

231: -- {End of Comments}
232: --
233: -- ---------------------------------------------------------------------------
234: PROCEDURE chk_person_id
235: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
236: ,p_person_id IN per_medical_assessments.person_id%TYPE
237: ,p_effective_date IN date) is
238: --
239: l_proc varchar2(72) := g_package||'chk_person_id';

Line 236: ,p_person_id IN per_medical_assessments.person_id%TYPE

232: --
233: -- ---------------------------------------------------------------------------
234: PROCEDURE chk_person_id
235: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
236: ,p_person_id IN per_medical_assessments.person_id%TYPE
237: ,p_effective_date IN date) is
238: --
239: l_proc varchar2(72) := g_package||'chk_person_id';
240: l_dummy number;

Line 325: (p_medical_assessment_id IN per_medical_assessments.disability_id%TYPE

321: --
322: -- {End of Comments}
323: --
324: PROCEDURE chk_organization_id
325: (p_medical_assessment_id IN per_medical_assessments.disability_id%TYPE
326: ,p_organization_id IN per_medical_assessments.organization_id%TYPE
327: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
328: ,p_effective_date IN date) IS
329: --

Line 326: ,p_organization_id IN per_medical_assessments.organization_id%TYPE

322: -- {End of Comments}
323: --
324: PROCEDURE chk_organization_id
325: (p_medical_assessment_id IN per_medical_assessments.disability_id%TYPE
326: ,p_organization_id IN per_medical_assessments.organization_id%TYPE
327: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
328: ,p_effective_date IN date) IS
329: --
330: cursor csr_org is

Line 454: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE,

450: --
451: -- {End of Comments}
452: --
453: PROCEDURE chk_consultation_date
454: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE,
455: p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS
456: --
457: -- Declare Local variables
458: --

Line 455: p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS

451: -- {End of Comments}
452: --
453: PROCEDURE chk_consultation_date
454: (p_consultation_date IN per_medical_assessments.consultation_date%TYPE,
455: p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE) IS
456: --
457: -- Declare Local variables
458: --
459: l_proc VARCHAR2(72) := g_package||'chk_consultation_date';

Line 516: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE

512: --
513: -- ---------------------------------------------------------------------------
514: --
515: PROCEDURE chk_consultation_type
516: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
517: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
518: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
519: ,p_effective_date IN date) IS
520: --

Line 517: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE

513: -- ---------------------------------------------------------------------------
514: --
515: PROCEDURE chk_consultation_type
516: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
517: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
518: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
519: ,p_effective_date IN date) IS
520: --
521: -- Declare Local Variables

Line 518: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE

514: --
515: PROCEDURE chk_consultation_type
516: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
517: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
518: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
519: ,p_effective_date IN date) IS
520: --
521: -- Declare Local Variables
522: --

Line 608: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE

604: --
605: -- ---------------------------------------------------------------------------
606: --
607: PROCEDURE chk_consultation_result
608: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
609: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
610: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
611: ,p_effective_date IN date) is
612: --

Line 609: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE

605: -- ---------------------------------------------------------------------------
606: --
607: PROCEDURE chk_consultation_result
608: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
609: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
610: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
611: ,p_effective_date IN date) is
612: --
613: -- Declare Local Variables

Line 610: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE

606: --
607: PROCEDURE chk_consultation_result
608: (p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
609: ,p_consultation_result IN per_medical_assessments.consultation_result%TYPE
610: ,p_consultation_type IN per_medical_assessments.consultation_type%TYPE
611: ,p_effective_date IN date) is
612: --
613: -- Declare Local Variables
614: --

Line 686: (p_incident_id IN per_medical_assessments.incident_id%TYPE

682: --
683: -- ---------------------------------------------------------------------------
684: --
685: PROCEDURE chk_incident_id
686: (p_incident_id IN per_medical_assessments.incident_id%TYPE
687: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE) IS
688: --
689: -- Declare Curors
690: --

Line 687: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE) IS

683: -- ---------------------------------------------------------------------------
684: --
685: PROCEDURE chk_incident_id
686: (p_incident_id IN per_medical_assessments.incident_id%TYPE
687: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE) IS
688: --
689: -- Declare Curors
690: --
691: CURSOR c_incident_id IS

Line 699: l_dummy_id per_medical_assessments.incident_id%TYPE;

695: --
696: -- Declare local variables
697: --
698: l_proc VARCHAR2(72) := g_package||'set_security_group_id';
699: l_dummy_id per_medical_assessments.incident_id%TYPE;
700: --
701: BEGIN
702: --
703: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 771: (p_disability_id IN per_medical_assessments.disability_id%TYPE

767: --
768: -- ---------------------------------------------------------------------------
769: --
770: PROCEDURE chk_valid_id_combinations
771: (p_disability_id IN per_medical_assessments.disability_id%TYPE
772: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
773: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
774: ,p_person_id IN per_medical_assessments.person_id%TYPE) IS
775: --

Line 772: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE

768: -- ---------------------------------------------------------------------------
769: --
770: PROCEDURE chk_valid_id_combinations
771: (p_disability_id IN per_medical_assessments.disability_id%TYPE
772: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
773: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
774: ,p_person_id IN per_medical_assessments.person_id%TYPE) IS
775: --
776: -- Declare cursor

Line 773: ,p_incident_id IN per_medical_assessments.incident_id%TYPE

769: --
770: PROCEDURE chk_valid_id_combinations
771: (p_disability_id IN per_medical_assessments.disability_id%TYPE
772: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
773: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
774: ,p_person_id IN per_medical_assessments.person_id%TYPE) IS
775: --
776: -- Declare cursor
777: --

Line 774: ,p_person_id IN per_medical_assessments.person_id%TYPE) IS

770: PROCEDURE chk_valid_id_combinations
771: (p_disability_id IN per_medical_assessments.disability_id%TYPE
772: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
773: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
774: ,p_person_id IN per_medical_assessments.person_id%TYPE) IS
775: --
776: -- Declare cursor
777: --
778: CURSOR c_valid_id IS

Line 780: FROM per_medical_assessments mea

776: -- Declare cursor
777: --
778: CURSOR c_valid_id IS
779: SELECT medical_assessment_id
780: FROM per_medical_assessments mea
781: WHERE mea.medical_assessment_id <> p_medical_assessment_id
782: AND mea.incident_id = p_incident_id
783: AND mea.person_id = p_person_id
784: AND mea.disability_id = p_disability_id;

Line 788: l_dummy_id per_medical_assessments.medical_assessment_id%TYPE;

784: AND mea.disability_id = p_disability_id;
785: --
786: -- Declare local variables
787: --
788: l_dummy_id per_medical_assessments.medical_assessment_id%TYPE;
789: l_proc VARCHAR2(72) := g_package||'chk_valid_id_combinations';
790: --
791: BEGIN
792: --

Line 875: (p_disability_id IN per_medical_assessments.disability_id%TYPE

871: -- ---------------------------------------------------------------------------
872: --
873:
874: PROCEDURE chk_inc_against_dis
875: (p_disability_id IN per_medical_assessments.disability_id%TYPE
876: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
877: ,p_person_id IN per_medical_assessments.person_id%TYPE
878: ,p_effective_date IN DATE) IS
879: --

Line 876: ,p_incident_id IN per_medical_assessments.incident_id%TYPE

872: --
873:
874: PROCEDURE chk_inc_against_dis
875: (p_disability_id IN per_medical_assessments.disability_id%TYPE
876: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
877: ,p_person_id IN per_medical_assessments.person_id%TYPE
878: ,p_effective_date IN DATE) IS
879: --
880: -- Declare cursor

Line 877: ,p_person_id IN per_medical_assessments.person_id%TYPE

873:
874: PROCEDURE chk_inc_against_dis
875: (p_disability_id IN per_medical_assessments.disability_id%TYPE
876: ,p_incident_id IN per_medical_assessments.incident_id%TYPE
877: ,p_person_id IN per_medical_assessments.person_id%TYPE
878: ,p_effective_date IN DATE) IS
879: --
880: -- Declare cursor
881: --

Line 894: l_dummy_id per_medical_assessments.disability_id%TYPE;

890: --
891: --
892: -- Declare local variables
893: --
894: l_dummy_id per_medical_assessments.disability_id%TYPE;
895: l_proc VARCHAR2(72) := g_package||'chk_inc_against_dis';
896: --
897: BEGIN
898: --

Line 978: (p_disability_id IN per_medical_assessments.disability_id%TYPE

974: --
975: -- ---------------------------------------------------------------------------
976: --
977: PROCEDURE chk_disability_id
978: (p_disability_id IN per_medical_assessments.disability_id%TYPE
979: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
980: ,p_person_id IN per_medical_assessments.person_id%TYPE
981: ,p_object_version_number IN per_medical_assessments.object_version_number%TYPE
982: ,p_effective_date IN DATE) IS

Line 979: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE

975: -- ---------------------------------------------------------------------------
976: --
977: PROCEDURE chk_disability_id
978: (p_disability_id IN per_medical_assessments.disability_id%TYPE
979: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
980: ,p_person_id IN per_medical_assessments.person_id%TYPE
981: ,p_object_version_number IN per_medical_assessments.object_version_number%TYPE
982: ,p_effective_date IN DATE) IS
983: --

Line 980: ,p_person_id IN per_medical_assessments.person_id%TYPE

976: --
977: PROCEDURE chk_disability_id
978: (p_disability_id IN per_medical_assessments.disability_id%TYPE
979: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
980: ,p_person_id IN per_medical_assessments.person_id%TYPE
981: ,p_object_version_number IN per_medical_assessments.object_version_number%TYPE
982: ,p_effective_date IN DATE) IS
983: --
984: -- Declare cursor

Line 981: ,p_object_version_number IN per_medical_assessments.object_version_number%TYPE

977: PROCEDURE chk_disability_id
978: (p_disability_id IN per_medical_assessments.disability_id%TYPE
979: ,p_medical_assessment_id IN per_medical_assessments.medical_assessment_id%TYPE
980: ,p_person_id IN per_medical_assessments.person_id%TYPE
981: ,p_object_version_number IN per_medical_assessments.object_version_number%TYPE
982: ,p_effective_date IN DATE) IS
983: --
984: -- Declare cursor
985: --

Line 996: l_dummy_id per_medical_assessments.disability_id%TYPE;

992: AND pdf.effective_end_date;
993: --
994: -- Declare local variables
995: --
996: l_dummy_id per_medical_assessments.disability_id%TYPE;
997: l_proc VARCHAR2(72) := g_package||'chk_disability_id';
998: --
999: BEGIN
1000: --

Line 1075: (p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE

1071: --
1072: -- ---------------------------------------------------------------------------
1073: --
1074: PROCEDURE chk_next_consultation_date
1075: (p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE
1076: ,p_consultation_date IN per_medical_assessments.consultation_date%TYPE) IS
1077: --
1078: -- Declare local variables
1079: --

Line 1076: ,p_consultation_date IN per_medical_assessments.consultation_date%TYPE) IS

1072: -- ---------------------------------------------------------------------------
1073: --
1074: PROCEDURE chk_next_consultation_date
1075: (p_next_consultation_date IN per_medical_assessments.next_consultation_date%TYPE
1076: ,p_consultation_date IN per_medical_assessments.consultation_date%TYPE) IS
1077: --
1078: -- Declare local variables
1079: --
1080: l_proc VARCHAR2(72) := g_package||'chk_next_consultation_date';

Line 1109: per_medical_assessments mea,

1105: --
1106: CURSOR csr_sec_grp is
1107: SELECT pbg.security_group_id
1108: FROM per_business_groups pbg,
1109: per_medical_assessments mea,
1110: per_people_f per
1111: WHERE mea.medical_assessment_id = p_medical_assessment_id
1112: AND per.person_id = mea.person_id
1113: AND pbg.business_group_id = per.business_group_id;

Line 1170: from per_medical_assessments mea,

1166: -- Declare cursor
1167: --
1168: cursor csr_leg_code is
1169: select pbg.legislation_code
1170: from per_medical_assessments mea,
1171: per_people_f per,
1172: per_business_groups pbg
1173: where mea.medical_assessment_id = p_medical_assessment_id
1174: and mea.person_id = per.person_id

Line 1519: ,p_descflex_name => 'PER_MEDICAL_ASSESSMENTS'

1515: -- b) During insert.
1516: --
1517: hr_dflex_utility.ins_or_upd_descflex_attribs
1518: (p_appl_short_name => 'PER'
1519: ,p_descflex_name => 'PER_MEDICAL_ASSESSMENTS'
1520: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
1521: ,p_attribute1_name => 'ATTRIBUTE1'
1522: ,p_attribute1_value => p_rec.attribute1
1523: ,p_attribute2_name => 'ATTRIBUTE2'