APPS.GHR_PDH_INS dependencies on GHR_PDH_SHD

Line 47: Procedure insert_dml(p_rec in out NOCOPY ghr_pdh_shd.g_rec_type) is

43: -- Internal Table Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out NOCOPY ghr_pdh_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50:
51: Begin

Line 111: ghr_pdh_shd.constraint_error

107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: ghr_pdh_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: ghr_pdh_shd.constraint_error

Line 115: ghr_pdh_shd.constraint_error

111: ghr_pdh_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: ghr_pdh_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: ghr_pdh_shd.constraint_error

Line 119: ghr_pdh_shd.constraint_error

115: ghr_pdh_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: ghr_pdh_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: Raise;
123: End insert_dml;

Line 163: (p_rec in out NOCOPY ghr_pdh_shd.g_rec_type)is

159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_insert
163: (p_rec in out NOCOPY ghr_pdh_shd.g_rec_type)is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
166: --
167: Cursor C_Sel1 is select ghr_pd_routing_history_s.nextval from sys.dual;

Line 216: Procedure post_insert(p_rec in ghr_pdh_shd.g_rec_type) is

212: -- Internal Table Handler Use Only.
213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_insert(p_rec in ghr_pdh_shd.g_rec_type) is
217: --
218: l_proc varchar2(72) := g_package||'post_insert';
219: --
220: Begin

Line 266: p_rec in out NOCOPY ghr_pdh_shd.g_rec_type,

262: -- |---------------------------------< ins >----------------------------------|
263: -- ----------------------------------------------------------------------------
264: Procedure ins
265: (
266: p_rec in out NOCOPY ghr_pdh_shd.g_rec_type,
267: p_validate in boolean default false
268: ) is
269: --
270: l_proc varchar2(72) := g_package||'ins';

Line 346: l_rec ghr_pdh_shd.g_rec_type;

342: p_validate in boolean default false ,
343: p_item_key in varchar2
344: ) is
345: --
346: l_rec ghr_pdh_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);

Line 356: ghr_pdh_shd.convert_args

352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
355: l_rec :=
356: ghr_pdh_shd.convert_args
357: (
358: null,
359: p_position_description_id,
360: p_initiator_flag,