APPS.PER_MEA_UPD dependencies on PER_MEDICAL_ASSESSMENTS

Line 59: l_last_update_date per_medical_assessments.last_update_date%TYPE;

55: (p_rec in out nocopy per_mea_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_medical_assessments.last_update_date%TYPE;
60: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
61: l_last_update_login per_medical_assessments.last_update_login%TYPE;
62: --
63: Begin

Line 60: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;

56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_medical_assessments.last_update_date%TYPE;
60: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
61: l_last_update_login per_medical_assessments.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);

Line 61: l_last_update_login per_medical_assessments.last_update_login%TYPE;

57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_medical_assessments.last_update_date%TYPE;
60: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
61: l_last_update_login per_medical_assessments.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: --

Line 75: -- Update the per_medical_assessments Row

71: l_last_update_date := sysdate;
72: l_last_updated_by := fnd_global.user_id;
73: l_last_update_login := fnd_global.login_id;
74: --
75: -- Update the per_medical_assessments Row
76: --
77: update per_medical_assessments
78: set
79: medical_assessment_id = p_rec.medical_assessment_id

Line 77: update per_medical_assessments

73: l_last_update_login := fnd_global.login_id;
74: --
75: -- Update the per_medical_assessments Row
76: --
77: update per_medical_assessments
78: set
79: medical_assessment_id = p_rec.medical_assessment_id
80: ,person_id = p_rec.person_id
81: ,examiner_name = p_rec.examiner_name

Line 426: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'

422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'
427: ,p_hook_type => 'AU');
428: --
429: end;
430: --