APPS.PQH_TTL_INS dependencies on PQH_TTL_SHD

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

Line 89: pqh_ttl_shd.constraint_error

85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_ttl_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_ttl_shd.constraint_error

Line 93: pqh_ttl_shd.constraint_error

89: pqh_ttl_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_ttl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_ttl_shd.constraint_error

Line 97: pqh_ttl_shd.constraint_error

93: pqh_ttl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_ttl_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: Raise;
101: End insert_dml;

Line 140: Procedure pre_insert(p_rec in out nocopy pqh_ttl_shd.g_rec_type,

136: -- Internal Row Handler Use Only.
137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_insert(p_rec in out nocopy pqh_ttl_shd.g_rec_type,
141: p_template_id in number) is
142: --
143: l_proc varchar2(72) := g_package||'pre_insert';
144: --

Line 189: Procedure post_insert(p_rec in pqh_ttl_shd.g_rec_type) is

185: -- Internal Row Handler Use Only.
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_insert(p_rec in pqh_ttl_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_insert';
192: --
193: Begin

Line 230: p_rec in out nocopy pqh_ttl_shd.g_rec_type ,

226: -- |---------------------------------< ins >----------------------------------|
227: -- ----------------------------------------------------------------------------
228: Procedure ins
229: (
230: p_rec in out nocopy pqh_ttl_shd.g_rec_type ,
231: p_template_id in number
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'ins';

Line 268: l_rec pqh_ttl_shd.g_rec_type;

264: p_language in varchar2,
265: p_source_lang in varchar2
266: ) is
267: --
268: l_rec pqh_ttl_shd.g_rec_type;
269: l_proc varchar2(72) := g_package||'ins';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);

Line 278: pqh_ttl_shd.convert_args

274: -- Call conversion function to turn arguments into the
275: -- p_rec structure.
276: --
277: l_rec :=
278: pqh_ttl_shd.convert_args
279: (
280: null,
281: p_template_name,
282: p_language,