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

Line 58: l_created_by per_medical_assessments.created_by%TYPE;

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

Line 59: l_creation_date per_medical_assessments.creation_date%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_medical_assessments.created_by%TYPE;
59: l_creation_date per_medical_assessments.creation_date%TYPE;
60: l_last_update_date per_medical_assessments.last_update_date%TYPE;
61: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
62: l_last_update_login per_medical_assessments.last_update_login%TYPE;
63: --

Line 60: l_last_update_date per_medical_assessments.last_update_date%TYPE;

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_medical_assessments.created_by%TYPE;
59: l_creation_date per_medical_assessments.creation_date%TYPE;
60: l_last_update_date per_medical_assessments.last_update_date%TYPE;
61: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
62: l_last_update_login per_medical_assessments.last_update_login%TYPE;
63: --
64: Begin

Line 61: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_medical_assessments.created_by%TYPE;
59: l_creation_date per_medical_assessments.creation_date%TYPE;
60: l_last_update_date per_medical_assessments.last_update_date%TYPE;
61: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
62: l_last_update_login per_medical_assessments.last_update_login%TYPE;
63: --
64: Begin
65: --

Line 62: l_last_update_login per_medical_assessments.last_update_login%TYPE;

58: l_created_by per_medical_assessments.created_by%TYPE;
59: l_creation_date per_medical_assessments.creation_date%TYPE;
60: l_last_update_date per_medical_assessments.last_update_date%TYPE;
61: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
62: l_last_update_login per_medical_assessments.last_update_login%TYPE;
63: --
64: Begin
65: --
66: hr_utility.set_location('Entering:'||l_proc, 5);

Line 77: -- Insert the row into: per_medical_assessments

73: l_last_update_date := sysdate;
74: l_last_updated_by := fnd_global.user_id;
75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Insert the row into: per_medical_assessments
78: --
79: insert into per_medical_assessments
80: (medical_assessment_id
81: ,person_id

Line 79: insert into per_medical_assessments

75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Insert the row into: per_medical_assessments
78: --
79: insert into per_medical_assessments
80: (medical_assessment_id
81: ,person_id
82: ,examiner_name
83: ,organization_id

Line 308: select per_medical_assessments_s.nextval

304: --
305: l_proc varchar2(72) := g_package||'pre_insert';
306: --
307: Cursor C_Sel1 is
308: select per_medical_assessments_s.nextval
309: from sys.dual;
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);

Line 450: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'

446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'
451: ,p_hook_type => 'AI');
452: --
453: end;
454: --