DBA Data[Home] [Help]

APPS.GHR_CIN_UPD dependencies on GHR_CIN_SHD

Line 55: (p_rec in out nocopy ghr_cin_shd.g_rec_type

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

Line 89: ghr_cin_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: ghr_cin_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_cin_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_cin_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_cin_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_cin_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_cin_shd.g_rec_type

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

Line 184: ,p_rec in ghr_cin_shd.g_rec_type

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

Line 202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id

198: ,p_description => p_rec.description
199: ,p_date_amended => p_rec.date_amended
200: ,p_date_acknowledged => p_rec.date_acknowledged
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id
203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged

Line 203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date

199: ,p_date_amended => p_rec.date_amended
200: ,p_date_acknowledged => p_rec.date_acknowledged
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id
203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged
207: ,p_object_version_number_o => ghr_cin_shd.g_old_rec.object_version_number

Line 204: ,p_description_o => ghr_cin_shd.g_old_rec.description

200: ,p_date_acknowledged => p_rec.date_acknowledged
201: ,p_object_version_number => p_rec.object_version_number
202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id
203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged
207: ,p_object_version_number_o => ghr_cin_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended

201: ,p_object_version_number => p_rec.object_version_number
202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id
203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged
207: ,p_object_version_number_o => ghr_cin_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged

202: ,p_compl_claim_id_o => ghr_cin_shd.g_old_rec.compl_claim_id
203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged
207: ,p_object_version_number_o => ghr_cin_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

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

203: ,p_incident_date_o => ghr_cin_shd.g_old_rec.incident_date
204: ,p_description_o => ghr_cin_shd.g_old_rec.description
205: ,p_date_amended_o => ghr_cin_shd.g_old_rec.date_amended
206: ,p_date_acknowledged_o => ghr_cin_shd.g_old_rec.date_acknowledged
207: ,p_object_version_number_o => ghr_cin_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy ghr_cin_shd.g_rec_type

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

Line 279: ghr_cin_shd.g_old_rec.compl_claim_id;

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

Line 283: ghr_cin_shd.g_old_rec.incident_date;

279: ghr_cin_shd.g_old_rec.compl_claim_id;
280: End If;
281: If (p_rec.incident_date = hr_api.g_date) then
282: p_rec.incident_date :=
283: ghr_cin_shd.g_old_rec.incident_date;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ghr_cin_shd.g_old_rec.description;

Line 287: ghr_cin_shd.g_old_rec.description;

283: ghr_cin_shd.g_old_rec.incident_date;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ghr_cin_shd.g_old_rec.description;
288: End If;
289: If (p_rec.date_amended = hr_api.g_date) then
290: p_rec.date_amended :=
291: ghr_cin_shd.g_old_rec.date_amended;

Line 291: ghr_cin_shd.g_old_rec.date_amended;

287: ghr_cin_shd.g_old_rec.description;
288: End If;
289: If (p_rec.date_amended = hr_api.g_date) then
290: p_rec.date_amended :=
291: ghr_cin_shd.g_old_rec.date_amended;
292: End If;
293: If (p_rec.date_acknowledged = hr_api.g_date) then
294: p_rec.date_acknowledged :=
295: ghr_cin_shd.g_old_rec.date_acknowledged;

Line 295: ghr_cin_shd.g_old_rec.date_acknowledged;

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

Line 305: ,p_rec in out nocopy ghr_cin_shd.g_rec_type

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

Line 315: ghr_cin_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_cin_shd.lck
316: (p_rec.compl_incident_id
317: ,p_rec.object_version_number
318: );
319: --

Line 362: l_rec ghr_cin_shd.g_rec_type;

358: ,p_date_amended in date default hr_api.g_date
359: ,p_date_acknowledged in date default hr_api.g_date
360: ) is
361: --
362: l_rec ghr_cin_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_cin_shd.convert_args

368: -- Call conversion function to turn arguments into the
369: -- l_rec structure.
370: --
371: l_rec :=
372: ghr_cin_shd.convert_args
373: (p_compl_incident_id
374: ,p_compl_claim_id
375: ,p_incident_date
376: ,p_description