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.GHR_CPL_UPD dependencies on GHR_CPL_SHD

Line 55: (p_rec in out nocopy ghr_cpl_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ghr_cpl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 89: ghr_cpl_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: ghr_cpl_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: ghr_cpl_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: ghr_cpl_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: ghr_cpl_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: ghr_cpl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in ghr_cpl_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in ghr_cpl_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 184: ,p_rec in ghr_cpl_shd.g_rec_type

180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update
183: (p_effective_date in date
184: ,p_rec in ghr_cpl_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --

Line 202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id

198: ,p_role_code => p_rec.role_code
199: ,p_start_date => p_rec.start_date
200: ,p_end_date => p_rec.end_date
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id
203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date

Line 203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id

199: ,p_start_date => p_rec.start_date
200: ,p_end_date => p_rec.end_date
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id
203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date
207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number

Line 204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code

200: ,p_end_date => p_rec.end_date
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id
203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date
207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date

201: ,p_object_version_number => p_rec.object_version_number
202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id
203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date
207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date

202: ,p_person_id_o => ghr_cpl_shd.g_old_rec.person_id
203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date
207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

Line 207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number

203: ,p_complaint_id_o => ghr_cpl_shd.g_old_rec.complaint_id
204: ,p_role_code_o => ghr_cpl_shd.g_old_rec.role_code
205: ,p_start_date_o => ghr_cpl_shd.g_old_rec.start_date
206: ,p_end_date_o => ghr_cpl_shd.g_old_rec.end_date
207: ,p_object_version_number_o => ghr_cpl_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy ghr_cpl_shd.g_rec_type

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure convert_defs
267: (p_rec in out nocopy ghr_cpl_shd.g_rec_type
268: ) is
269: --
270: Begin
271: --

Line 279: ghr_cpl_shd.g_old_rec.person_id;

275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.person_id = hr_api.g_number) then
278: p_rec.person_id :=
279: ghr_cpl_shd.g_old_rec.person_id;
280: End If;
281: If (p_rec.complaint_id = hr_api.g_number) then
282: p_rec.complaint_id :=
283: ghr_cpl_shd.g_old_rec.complaint_id;

Line 283: ghr_cpl_shd.g_old_rec.complaint_id;

279: ghr_cpl_shd.g_old_rec.person_id;
280: End If;
281: If (p_rec.complaint_id = hr_api.g_number) then
282: p_rec.complaint_id :=
283: ghr_cpl_shd.g_old_rec.complaint_id;
284: End If;
285: If (p_rec.role_code = hr_api.g_varchar2) then
286: p_rec.role_code :=
287: ghr_cpl_shd.g_old_rec.role_code;

Line 287: ghr_cpl_shd.g_old_rec.role_code;

283: ghr_cpl_shd.g_old_rec.complaint_id;
284: End If;
285: If (p_rec.role_code = hr_api.g_varchar2) then
286: p_rec.role_code :=
287: ghr_cpl_shd.g_old_rec.role_code;
288: End If;
289: If (p_rec.start_date = hr_api.g_date) then
290: p_rec.start_date :=
291: ghr_cpl_shd.g_old_rec.start_date;

Line 291: ghr_cpl_shd.g_old_rec.start_date;

287: ghr_cpl_shd.g_old_rec.role_code;
288: End If;
289: If (p_rec.start_date = hr_api.g_date) then
290: p_rec.start_date :=
291: ghr_cpl_shd.g_old_rec.start_date;
292: End If;
293: If (p_rec.end_date = hr_api.g_date) then
294: p_rec.end_date :=
295: ghr_cpl_shd.g_old_rec.end_date;

Line 295: ghr_cpl_shd.g_old_rec.end_date;

291: ghr_cpl_shd.g_old_rec.start_date;
292: End If;
293: If (p_rec.end_date = hr_api.g_date) then
294: p_rec.end_date :=
295: ghr_cpl_shd.g_old_rec.end_date;
296: End If;
297: --
298: End convert_defs;
299: --

Line 305: ,p_rec in out nocopy ghr_cpl_shd.g_rec_type

301: -- |---------------------------------< upd >----------------------------------|
302: -- ----------------------------------------------------------------------------
303: Procedure upd
304: (p_effective_date in date
305: ,p_rec in out nocopy ghr_cpl_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'upd';
309: --

Line 315: ghr_cpl_shd.lck

311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: -- We must lock the row which we need to update.
314: --
315: ghr_cpl_shd.lck
316: (p_rec.compl_person_id
317: ,p_rec.object_version_number
318: );
319: --

Line 362: l_rec ghr_cpl_shd.g_rec_type;

358: ,p_start_date in date default hr_api.g_date
359: ,p_end_date in date default hr_api.g_date
360: ) is
361: --
362: l_rec ghr_cpl_shd.g_rec_type;
363: l_proc varchar2(72) := g_package||'upd';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);

Line 372: ghr_cpl_shd.convert_args

368: -- Call conversion function to turn arguments into the
369: -- l_rec structure.
370: --
371: l_rec :=
372: ghr_cpl_shd.convert_args
373: (p_compl_person_id
374: ,p_person_id
375: ,p_complaint_id
376: ,p_role_code