APPS.PQH_CEF_INS dependencies on PQH_CEF_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pqh_cef_shd.g_rec_type) is

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

Line 87: pqh_cef_shd.constraint_error

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

Line 91: pqh_cef_shd.constraint_error

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

Line 95: pqh_cef_shd.constraint_error

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

Line 138: Procedure pre_insert(p_rec in out nocopy pqh_cef_shd.g_rec_type) is

134: -- Internal Row Handler Use Only.
135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_insert(p_rec in out nocopy pqh_cef_shd.g_rec_type) is
139: --
140: l_proc varchar2(72) := g_package||'pre_insert';
141: --
142: Cursor C_Sel1 is select pqh_copy_entity_functions_s.nextval from sys.dual;

Line 190: p_effective_date in date,p_rec in pqh_cef_shd.g_rec_type) is

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_insert(
190: p_effective_date in date,p_rec in pqh_cef_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin

Line 237: p_rec in out nocopy pqh_cef_shd.g_rec_type

233: -- ----------------------------------------------------------------------------
234: Procedure ins
235: (
236: p_effective_date in date,
237: p_rec in out nocopy pqh_cef_shd.g_rec_type
238: ) is
239: --
240: l_proc varchar2(72) := g_package||'ins';
241: --

Line 280: l_rec pqh_cef_shd.g_rec_type;

276: p_object_version_number out nocopy number,
277: p_context in varchar2
278: ) is
279: --
280: l_rec pqh_cef_shd.g_rec_type;
281: l_proc varchar2(72) := g_package||'ins';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);

Line 290: pqh_cef_shd.convert_args

286: -- Call conversion function to turn arguments into the
287: -- p_rec structure.
288: --
289: l_rec :=
290: pqh_cef_shd.convert_args
291: (
292: null,
293: p_table_route_id,
294: p_function_type_cd,