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 82: pqh_tat_shd.constraint_error

78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_tat_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_tat_shd.constraint_error

Line 86: pqh_tat_shd.constraint_error

82: pqh_tat_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_tat_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_tat_shd.constraint_error

Line 90: pqh_tat_shd.constraint_error

86: pqh_tat_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_tat_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: Raise;
94: End insert_dml;

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

129: -- Internal Row Handler Use Only.
130: --
131: -- {End Of Comments}
132: -- ----------------------------------------------------------------------------
133: Procedure pre_insert(p_rec in out nocopy pqh_tat_shd.g_rec_type) is
134: --
135: l_proc varchar2(72) := g_package||'pre_insert';
136: --
137: Cursor C_Sel1 is select pqh_template_attributes_s.nextval from sys.dual;

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

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_insert(
185: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'post_insert';
188: --
189: Begin

Line 231: p_rec in out nocopy pqh_tat_shd.g_rec_type

227: -- ----------------------------------------------------------------------------
228: Procedure ins
229: (
230: p_effective_date in date,
231: p_rec in out nocopy pqh_tat_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'ins';
235: --

Line 273: l_rec pqh_tat_shd.g_rec_type;

269: p_template_id in number,
270: p_object_version_number out nocopy number
271: ) is
272: --
273: l_rec pqh_tat_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'ins';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);

Line 283: pqh_tat_shd.convert_args

279: -- Call conversion function to turn arguments into the
280: -- p_rec structure.
281: --
282: l_rec :=
283: pqh_tat_shd.convert_args
284: (
285: p_required_flag,
286: p_view_flag,
287: p_edit_flag,