APPS.PQH_BVR_INS dependencies on PQH_BVR_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pqh_bvr_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_bvr_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 101: pqh_bvr_shd.constraint_error

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

Line 105: pqh_bvr_shd.constraint_error

101: pqh_bvr_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: pqh_bvr_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: pqh_bvr_shd.constraint_error

Line 109: pqh_bvr_shd.constraint_error

105: pqh_bvr_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: pqh_bvr_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End insert_dml;

Line 152: Procedure pre_insert(p_rec in out nocopy pqh_bvr_shd.g_rec_type) is

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

Line 204: p_effective_date in date,p_rec in pqh_bvr_shd.g_rec_type) is

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

Line 258: p_rec in out nocopy pqh_bvr_shd.g_rec_type

254: -- ----------------------------------------------------------------------------
255: Procedure ins
256: (
257: p_effective_date in date,
258: p_rec in out nocopy pqh_bvr_shd.g_rec_type
259: ) is
260: --
261: l_proc varchar2(72) := g_package||'ins';
262: --

Line 308: l_rec pqh_bvr_shd.g_rec_type;

304: p_budget_unit2_available in number default null,
305: p_budget_unit3_available in number default null
306: ) is
307: --
308: l_rec pqh_bvr_shd.g_rec_type;
309: l_proc varchar2(72) := g_package||'ins';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);

Line 318: pqh_bvr_shd.convert_args

314: -- Call conversion function to turn arguments into the
315: -- p_rec structure.
316: --
317: l_rec :=
318: pqh_bvr_shd.convert_args
319: (
320: null,
321: p_budget_id,
322: p_version_number,