APPS.GHR_CAD_INS dependencies on GHR_CAD_SHD

Line 76: (p_rec in out nocopy ghr_cad_shd.g_rec_type

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

Line 123: ghr_cad_shd.constraint_error

119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: --
123: ghr_cad_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --

Line 128: ghr_cad_shd.constraint_error

124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --
128: ghr_cad_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --

Line 133: ghr_cad_shd.constraint_error

129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --
133: ghr_cad_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: --
137: Raise;

Line 178: (p_rec in out nocopy ghr_cad_shd.g_rec_type

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure pre_insert
178: (p_rec in out nocopy ghr_cad_shd.g_rec_type
179: ) is
180: --
181: Cursor C_Sel1 is select ghr_compl_adrs_s.nextval from sys.dual;
182: --

Line 266: ,p_rec in ghr_cad_shd.g_rec_type

262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure post_insert
265: (p_effective_date in date
266: ,p_rec in ghr_cad_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72) := g_package||'post_insert';
270: --

Line 310: ,p_rec in out nocopy ghr_cad_shd.g_rec_type

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

Line 361: l_rec ghr_cad_shd.g_rec_type;

357: ,p_compl_adr_id out nocopy number
358: ,p_object_version_number out nocopy number
359: ) is
360: --
361: l_rec ghr_cad_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'ins';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);

Line 371: ghr_cad_shd.convert_args

367: -- Call conversion function to turn arguments into the
368: -- p_rec structure.
369: --
370: l_rec :=
371: ghr_cad_shd.convert_args
372: (null
373: ,p_complaint_id
374: ,p_stage
375: ,p_start_date