APPS.PQH_PTE_INS dependencies on PQH_PTE_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_pte_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_pte_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 182: pqh_pte_shd.constraint_error

178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: Exception
180: When hr_api.check_integrity_violated Then
181: -- A check constraint has been violated
182: pqh_pte_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: pqh_pte_shd.constraint_error

Line 186: pqh_pte_shd.constraint_error

182: pqh_pte_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: pqh_pte_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqh_pte_shd.constraint_error

Line 190: pqh_pte_shd.constraint_error

186: pqh_pte_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqh_pte_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: Raise;
194: End insert_dml;

Line 233: Procedure pre_insert(p_rec in out nocopy pqh_pte_shd.g_rec_type) is

229: -- Internal Row Handler Use Only.
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure pre_insert(p_rec in out nocopy pqh_pte_shd.g_rec_type) is
234: --
235: l_proc varchar2(72) := g_package||'pre_insert';
236: --
237: Cursor C_Sel1 is select pqh_ptx_extra_info_s.nextval from sys.dual;

Line 287: Procedure post_insert(p_rec in pqh_pte_shd.g_rec_type) is

283: -- Internal Row Handler Use Only.
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_insert(p_rec in pqh_pte_shd.g_rec_type) is
288: --
289: l_proc varchar2(72) := g_package||'post_insert';
290: --
291: Begin

Line 381: p_rec in out nocopy pqh_pte_shd.g_rec_type

377: -- |---------------------------------< ins >----------------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure ins
380: (
381: p_rec in out nocopy pqh_pte_shd.g_rec_type
382: ) is
383: --
384: l_proc varchar2(72) := g_package||'ins';
385: --

Line 470: l_rec pqh_pte_shd.g_rec_type;

466: p_attribute20 in varchar2 default null,
467: p_object_version_number out nocopy number
468: ) is
469: --
470: l_rec pqh_pte_shd.g_rec_type;
471: l_proc varchar2(72) := g_package||'ins';
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc, 5);

Line 480: pqh_pte_shd.convert_args

476: -- Call conversion function to turn arguments into the
477: -- p_rec structure.
478: --
479: l_rec :=
480: pqh_pte_shd.convert_args
481: (
482: null,
483: p_information_type,
484: p_position_transaction_id,