APPS.PQH_TAT_INS dependencies on PQH_TAT_SHD

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

Line 98: pqh_tat_shd.constraint_error

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pqh_tat_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pqh_tat_shd.constraint_error

Line 102: pqh_tat_shd.constraint_error

98: pqh_tat_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pqh_tat_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: pqh_tat_shd.constraint_error

Line 106: pqh_tat_shd.constraint_error

102: pqh_tat_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: pqh_tat_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: Raise;
110: End insert_dml;

Line 149: Procedure pre_insert(p_rec in out nocopy pqh_tat_shd.g_rec_type) is

145: -- Internal Row Handler Use Only.
146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert(p_rec in out nocopy pqh_tat_shd.g_rec_type) is
150: --
151: l_proc varchar2(72) := g_package||'pre_insert';
152: --
153: Cursor C_Sel1 is select pqh_template_attributes_s.nextval from sys.dual;

Line 201: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is

197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_insert(
201: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is
202: --
203: l_proc varchar2(72) := g_package||'post_insert';
204: --
205: Begin

Line 247: p_rec in out nocopy pqh_tat_shd.g_rec_type

243: -- ----------------------------------------------------------------------------
244: Procedure ins
245: (
246: p_effective_date in date,
247: p_rec in out nocopy pqh_tat_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'ins';
251: --

Line 289: l_rec pqh_tat_shd.g_rec_type;

285: p_template_id in number,
286: p_object_version_number out nocopy number
287: ) is
288: --
289: l_rec pqh_tat_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'ins';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);

Line 299: pqh_tat_shd.convert_args

295: -- Call conversion function to turn arguments into the
296: -- p_rec structure.
297: --
298: l_rec :=
299: pqh_tat_shd.convert_args
300: (
301: p_required_flag,
302: p_view_flag,
303: p_edit_flag,