DBA Data[Home] [Help]

APPS.PQH_RHA_INS dependencies on PQH_RHA_SHD

Line 54: (p_rec in out nocopy pqh_rha_shd.g_rec_type

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

Line 107: pqh_rha_shd.constraint_error

103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: --
107: pqh_rha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --

Line 112: pqh_rha_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --

Line 117: pqh_rha_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: pqh_rha_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: --
121: Raise;

Line 162: (p_rec in out nocopy pqh_rha_shd.g_rec_type

158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_insert
162: (p_rec in out nocopy pqh_rha_shd.g_rec_type
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
166: --

Line 216: ,p_rec in pqh_rha_shd.g_rec_type

212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_insert
215: (p_effective_date in date
216: ,p_rec in pqh_rha_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'post_insert';
220: --

Line 275: ,p_rec in out nocopy pqh_rha_shd.g_rec_type

271: -- |---------------------------------< ins >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure ins
274: (p_effective_date in date
275: ,p_rec in out nocopy pqh_rha_shd.g_rec_type
276: ) is
277: --
278: l_proc varchar2(72) := g_package||'ins';
279: --

Line 329: l_rec pqh_rha_shd.g_rec_type;

325: ,p_routing_hist_attrib_id out nocopy number
326: ,p_object_version_number out nocopy number
327: ) is
328: --
329: l_rec pqh_rha_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);

Line 339: pqh_rha_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: pqh_rha_shd.convert_args
340: (null
341: ,p_routing_history_id
342: ,p_attribute_id
343: ,p_from_char