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_NAA_DEL dependencies on PER_NAA_SHD

Line 52: (p_rec in per_naa_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_naa_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: per_naa_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: per_naa_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_nl_absence_actions row.
63: --
64: delete from per_nl_absence_actions

Line 67: per_naa_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_nl_absence_actions
65: where absence_action_id = p_rec.absence_action_id;
66: --
67: per_naa_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: per_naa_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_naa_shd.g_api_dml := false; -- Unset the api dml status
75: per_naa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_naa_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_naa_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_naa_shd.g_api_dml := false; -- Unset the api dml status
75: per_naa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_naa_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: per_naa_shd.g_api_dml := false; -- Unset the api dml status

74: per_naa_shd.g_api_dml := false; -- Unset the api dml status
75: per_naa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_naa_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in per_naa_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_naa_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_naa_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_naa_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_naa_shd.g_old_rec.absence_attendance_id

164: per_naa_rkd.after_delete
165: (p_absence_action_id
166: => p_rec.absence_action_id
167: ,p_absence_attendance_id_o
168: => per_naa_shd.g_old_rec.absence_attendance_id
169: ,p_expected_date_o
170: => per_naa_shd.g_old_rec.expected_date
171: ,p_description_o
172: => per_naa_shd.g_old_rec.description

Line 170: => per_naa_shd.g_old_rec.expected_date

166: => p_rec.absence_action_id
167: ,p_absence_attendance_id_o
168: => per_naa_shd.g_old_rec.absence_attendance_id
169: ,p_expected_date_o
170: => per_naa_shd.g_old_rec.expected_date
171: ,p_description_o
172: => per_naa_shd.g_old_rec.description
173: ,p_actual_start_date_o
174: => per_naa_shd.g_old_rec.actual_start_date

Line 172: => per_naa_shd.g_old_rec.description

168: => per_naa_shd.g_old_rec.absence_attendance_id
169: ,p_expected_date_o
170: => per_naa_shd.g_old_rec.expected_date
171: ,p_description_o
172: => per_naa_shd.g_old_rec.description
173: ,p_actual_start_date_o
174: => per_naa_shd.g_old_rec.actual_start_date
175: ,p_actual_end_date_o
176: => per_naa_shd.g_old_rec.actual_end_date

Line 174: => per_naa_shd.g_old_rec.actual_start_date

170: => per_naa_shd.g_old_rec.expected_date
171: ,p_description_o
172: => per_naa_shd.g_old_rec.description
173: ,p_actual_start_date_o
174: => per_naa_shd.g_old_rec.actual_start_date
175: ,p_actual_end_date_o
176: => per_naa_shd.g_old_rec.actual_end_date
177: ,p_holder_o
178: => per_naa_shd.g_old_rec.holder

Line 176: => per_naa_shd.g_old_rec.actual_end_date

172: => per_naa_shd.g_old_rec.description
173: ,p_actual_start_date_o
174: => per_naa_shd.g_old_rec.actual_start_date
175: ,p_actual_end_date_o
176: => per_naa_shd.g_old_rec.actual_end_date
177: ,p_holder_o
178: => per_naa_shd.g_old_rec.holder
179: ,p_comments_o
180: => per_naa_shd.g_old_rec.comments

Line 178: => per_naa_shd.g_old_rec.holder

174: => per_naa_shd.g_old_rec.actual_start_date
175: ,p_actual_end_date_o
176: => per_naa_shd.g_old_rec.actual_end_date
177: ,p_holder_o
178: => per_naa_shd.g_old_rec.holder
179: ,p_comments_o
180: => per_naa_shd.g_old_rec.comments
181: ,p_document_file_name_o
182: => per_naa_shd.g_old_rec.document_file_name

Line 180: => per_naa_shd.g_old_rec.comments

176: => per_naa_shd.g_old_rec.actual_end_date
177: ,p_holder_o
178: => per_naa_shd.g_old_rec.holder
179: ,p_comments_o
180: => per_naa_shd.g_old_rec.comments
181: ,p_document_file_name_o
182: => per_naa_shd.g_old_rec.document_file_name
183: ,p_last_updated_by_o
184: => per_naa_shd.g_old_rec.last_updated_by

Line 182: => per_naa_shd.g_old_rec.document_file_name

178: => per_naa_shd.g_old_rec.holder
179: ,p_comments_o
180: => per_naa_shd.g_old_rec.comments
181: ,p_document_file_name_o
182: => per_naa_shd.g_old_rec.document_file_name
183: ,p_last_updated_by_o
184: => per_naa_shd.g_old_rec.last_updated_by
185: ,p_object_version_number_o
186: => per_naa_shd.g_old_rec.object_version_number

Line 184: => per_naa_shd.g_old_rec.last_updated_by

180: => per_naa_shd.g_old_rec.comments
181: ,p_document_file_name_o
182: => per_naa_shd.g_old_rec.document_file_name
183: ,p_last_updated_by_o
184: => per_naa_shd.g_old_rec.last_updated_by
185: ,p_object_version_number_o
186: => per_naa_shd.g_old_rec.object_version_number
187: ,p_enabled_o
188: => per_naa_shd.g_old_rec.enabled

Line 186: => per_naa_shd.g_old_rec.object_version_number

182: => per_naa_shd.g_old_rec.document_file_name
183: ,p_last_updated_by_o
184: => per_naa_shd.g_old_rec.last_updated_by
185: ,p_object_version_number_o
186: => per_naa_shd.g_old_rec.object_version_number
187: ,p_enabled_o
188: => per_naa_shd.g_old_rec.enabled
189: );
190: --

Line 188: => per_naa_shd.g_old_rec.enabled

184: => per_naa_shd.g_old_rec.last_updated_by
185: ,p_object_version_number_o
186: => per_naa_shd.g_old_rec.object_version_number
187: ,p_enabled_o
188: => per_naa_shd.g_old_rec.enabled
189: );
190: --
191: exception
192: --

Line 208: (p_rec in per_naa_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (p_rec in per_naa_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'del';
212: --

Line 218: per_naa_shd.lck

214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- We must lock the row which we need to delete.
217: --
218: per_naa_shd.lck
219: (p_rec.absence_action_id
220: ,p_rec.object_version_number
221: );
222: --

Line 255: l_rec per_naa_shd.g_rec_type;

251: (p_absence_action_id in number
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec per_naa_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);