DBA Data[Home] [Help]

APPS.GHR_CBA_UPD dependencies on GHR_CBA_SHD

Line 55: (p_rec in out nocopy ghr_cba_shd.g_rec_type

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

Line 90: ghr_cba_shd.constraint_error

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

Line 95: ghr_cba_shd.constraint_error

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

Line 100: ghr_cba_shd.constraint_error

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

Line 140: (p_rec in ghr_cba_shd.g_rec_type

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

Line 185: ,p_rec in ghr_cba_shd.g_rec_type

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

Line 204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id

200: ,p_statute => p_rec.statute
201: ,p_agency_finding => p_rec.agency_finding
202: ,p_aj_finding => p_rec.aj_finding
203: ,p_object_version_number => p_rec.object_version_number
204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id
205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding

Line 205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis

201: ,p_agency_finding => p_rec.agency_finding
202: ,p_aj_finding => p_rec.aj_finding
203: ,p_object_version_number => p_rec.object_version_number
204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id
205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding

Line 206: ,p_value_o => ghr_cba_shd.g_old_rec.value

202: ,p_aj_finding => p_rec.aj_finding
203: ,p_object_version_number => p_rec.object_version_number
204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id
205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding
210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number

Line 207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute

203: ,p_object_version_number => p_rec.object_version_number
204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id
205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding
210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number
211: );

Line 208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding

204: ,p_compl_claim_id_o => ghr_cba_shd.g_old_rec.compl_claim_id
205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding
210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number
211: );
212: --

Line 209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding

205: ,p_basis_o => ghr_cba_shd.g_old_rec.basis
206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding
210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number
211: );
212: --
213: exception

Line 210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number

206: ,p_value_o => ghr_cba_shd.g_old_rec.value
207: ,p_statute_o => ghr_cba_shd.g_old_rec.statute
208: ,p_agency_finding_o => ghr_cba_shd.g_old_rec.agency_finding
209: ,p_aj_finding_o => ghr_cba_shd.g_old_rec.aj_finding
210: ,p_object_version_number_o => ghr_cba_shd.g_old_rec.object_version_number
211: );
212: --
213: exception
214: --

Line 270: (p_rec in out nocopy ghr_cba_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy ghr_cba_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: ghr_cba_shd.g_old_rec.compl_claim_id;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.compl_claim_id = hr_api.g_number) then
281: p_rec.compl_claim_id :=
282: ghr_cba_shd.g_old_rec.compl_claim_id;
283: End If;
284: If (p_rec.basis = hr_api.g_varchar2) then
285: p_rec.basis :=
286: ghr_cba_shd.g_old_rec.basis;

Line 286: ghr_cba_shd.g_old_rec.basis;

282: ghr_cba_shd.g_old_rec.compl_claim_id;
283: End If;
284: If (p_rec.basis = hr_api.g_varchar2) then
285: p_rec.basis :=
286: ghr_cba_shd.g_old_rec.basis;
287: End If;
288: If (p_rec.value = hr_api.g_varchar2) then
289: p_rec.value :=
290: ghr_cba_shd.g_old_rec.value;

Line 290: ghr_cba_shd.g_old_rec.value;

286: ghr_cba_shd.g_old_rec.basis;
287: End If;
288: If (p_rec.value = hr_api.g_varchar2) then
289: p_rec.value :=
290: ghr_cba_shd.g_old_rec.value;
291: End If;
292: If (p_rec.statute = hr_api.g_varchar2) then
293: p_rec.statute :=
294: ghr_cba_shd.g_old_rec.statute;

Line 294: ghr_cba_shd.g_old_rec.statute;

290: ghr_cba_shd.g_old_rec.value;
291: End If;
292: If (p_rec.statute = hr_api.g_varchar2) then
293: p_rec.statute :=
294: ghr_cba_shd.g_old_rec.statute;
295: End If;
296: If (p_rec.agency_finding = hr_api.g_varchar2) then
297: p_rec.agency_finding :=
298: ghr_cba_shd.g_old_rec.agency_finding;

Line 298: ghr_cba_shd.g_old_rec.agency_finding;

294: ghr_cba_shd.g_old_rec.statute;
295: End If;
296: If (p_rec.agency_finding = hr_api.g_varchar2) then
297: p_rec.agency_finding :=
298: ghr_cba_shd.g_old_rec.agency_finding;
299: End If;
300: If (p_rec.aj_finding = hr_api.g_varchar2) then
301: p_rec.aj_finding :=
302: ghr_cba_shd.g_old_rec.aj_finding;

Line 302: ghr_cba_shd.g_old_rec.aj_finding;

298: ghr_cba_shd.g_old_rec.agency_finding;
299: End If;
300: If (p_rec.aj_finding = hr_api.g_varchar2) then
301: p_rec.aj_finding :=
302: ghr_cba_shd.g_old_rec.aj_finding;
303: End If;
304: --
305: End convert_defs;
306: --

Line 312: ,p_rec in out nocopy ghr_cba_shd.g_rec_type

308: -- |---------------------------------< upd >----------------------------------|
309: -- ----------------------------------------------------------------------------
310: Procedure upd
311: (p_effective_date in date
312: ,p_rec in out nocopy ghr_cba_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'upd';
316: --

Line 322: ghr_cba_shd.lck

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: ghr_cba_shd.lck
323: (p_rec.compl_basis_id
324: ,p_rec.object_version_number
325: );
326: --

Line 370: l_rec ghr_cba_shd.g_rec_type;

366: ,p_agency_finding in varchar2 default hr_api.g_varchar2
367: ,p_aj_finding in varchar2 default hr_api.g_varchar2
368: ) is
369: --
370: l_rec ghr_cba_shd.g_rec_type;
371: l_proc varchar2(72) := g_package||'upd';
372: --
373: Begin
374: hr_utility.set_location('Entering:'||l_proc, 5);

Line 380: ghr_cba_shd.convert_args

376: -- Call conversion function to turn arguments into the
377: -- l_rec structure.
378: --
379: l_rec :=
380: ghr_cba_shd.convert_args
381: (p_compl_basis_id
382: ,p_compl_claim_id
383: ,p_basis
384: ,p_value