DBA Data[Home] [Help]

APPS.PQH_RTL_INS dependencies on PQH_RTL_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_rtl_shd.g_rec_type) is

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

Line 93: pqh_rtl_shd.constraint_error

89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: pqh_rtl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pqh_rtl_shd.constraint_error

Line 97: pqh_rtl_shd.constraint_error

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

Line 101: pqh_rtl_shd.constraint_error

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

Line 144: Procedure pre_insert(p_rec in out nocopy pqh_rtl_shd.g_rec_type,

140: -- Internal Row Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure pre_insert(p_rec in out nocopy pqh_rtl_shd.g_rec_type,
145: p_rule_set_id in number) is
146: --
147: l_proc varchar2(72) := g_package||'pre_insert';
148: --

Line 193: Procedure post_insert(p_rec in pqh_rtl_shd.g_rec_type) is

189: -- Internal Row Handler Use Only.
190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure post_insert(p_rec in pqh_rtl_shd.g_rec_type) is
194: --
195: l_proc varchar2(72) := g_package||'post_insert';
196: --
197: Begin

Line 235: p_rec in out nocopy pqh_rtl_shd.g_rec_type

231: -- |---------------------------------< ins >----------------------------------|
232: -- ----------------------------------------------------------------------------
233: Procedure ins
234: (
235: p_rec in out nocopy pqh_rtl_shd.g_rec_type
236: ,p_rule_set_id in number
237: ) is
238: --
239: l_proc varchar2(72) := g_package||'ins';

Line 274: l_rec pqh_rtl_shd.g_rec_type;

270: p_description in varchar2,
271: p_source_lang in varchar2
272: ) is
273: --
274: l_rec pqh_rtl_shd.g_rec_type;
275: l_proc varchar2(72) := g_package||'ins';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);

Line 284: pqh_rtl_shd.convert_args

280: -- Call conversion function to turn arguments into the
281: -- p_rec structure.
282: --
283: l_rec :=
284: pqh_rtl_shd.convert_args
285: (
286: null,
287: p_rule_set_name,
288: p_description,