APPS.PQH_VER_INS dependencies on PQH_VER_SHD

Line 76: (p_rec in out nocopy pqh_ver_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pqh_ver_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 135: pqh_ver_shd.constraint_error

131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: --
135: pqh_ver_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --

Line 140: pqh_ver_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --
140: pqh_ver_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --

Line 145: pqh_ver_shd.constraint_error

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --
145: pqh_ver_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: --
149: Raise;

Line 190: (p_rec in out nocopy pqh_ver_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy pqh_ver_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select pqh_de_wrkplc_vldtn_vers_s.nextval from sys.dual;
194: --

Line 278: ,p_rec in pqh_ver_shd.g_rec_type

274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure post_insert
277: (p_effective_date in date
278: ,p_rec in pqh_ver_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) := g_package||'post_insert';
282: --

Line 343: ,p_rec in out nocopy pqh_ver_shd.g_rec_type

339: -- |---------------------------------< ins >----------------------------------|
340: -- ----------------------------------------------------------------------------
341: Procedure ins
342: (p_effective_date in date
343: ,p_rec in out nocopy pqh_ver_shd.g_rec_type
344: ) is
345: --
346: l_proc varchar2(72) := g_package||'ins';
347: --

Line 408: l_rec pqh_ver_shd.g_rec_type;

404: ,p_wrkplc_vldtn_ver_id out nocopy number
405: ,p_object_version_number out nocopy number
406: ) is
407: --
408: l_rec pqh_ver_shd.g_rec_type;
409: l_proc varchar2(72) := g_package||'ins';
410: --
411: Begin
412: hr_utility.set_location('Entering:'||l_proc, 5);

Line 418: pqh_ver_shd.convert_args

414: -- Call conversion function to turn arguments into the
415: -- p_rec structure.
416: --
417: l_rec :=
418: pqh_ver_shd.convert_args
419: (null
420: ,p_wrkplc_vldtn_id
421: ,p_version_number
422: ,p_business_group_id