DBA Data[Home] [Help]

APPS.GHR_CST_INS dependencies on GHR_CST_SHD

Line 76: (p_rec in out nocopy ghr_cst_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ghr_cst_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 119: ghr_cst_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: ghr_cst_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --

Line 124: ghr_cst_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --
124: ghr_cst_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --

Line 129: ghr_cst_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: ghr_cst_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: --
133: Raise;

Line 174: (p_rec in out nocopy ghr_cst_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_insert
174: (p_rec in out nocopy ghr_cst_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel1 is select ghr_compl_agency_costs_s.nextval from sys.dual;
178: --

Line 262: ,p_rec in ghr_cst_shd.g_rec_type

258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure post_insert
261: (p_effective_date in date
262: ,p_rec in ghr_cst_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72) := g_package||'post_insert';
266: --

Line 302: ,p_rec in out nocopy ghr_cst_shd.g_rec_type

298: -- |---------------------------------< ins >----------------------------------|
299: -- ----------------------------------------------------------------------------
300: Procedure ins
301: (p_effective_date in date
302: ,p_rec in out nocopy ghr_cst_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'ins';
306: --

Line 351: l_rec ghr_cst_shd.g_rec_type;

347: ,p_compl_agency_cost_id out nocopy number
348: ,p_object_version_number out nocopy number
349: ) is
350: --
351: l_rec ghr_cst_shd.g_rec_type;
352: l_proc varchar2(72) := g_package||'ins';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);

Line 361: ghr_cst_shd.convert_args

357: -- Call conversion function to turn arguments into the
358: -- p_rec structure.
359: --
360: l_rec :=
361: ghr_cst_shd.convert_args
362: (null
363: ,p_complaint_id
364: ,p_phase
365: ,p_stage