APPS.PQH_BST_INS dependencies on PQH_BST_SHD

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

Line 100: pqh_bst_shd.constraint_error

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

Line 104: pqh_bst_shd.constraint_error

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

Line 108: pqh_bst_shd.constraint_error

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

Line 151: Procedure pre_insert(p_rec in out nocopy pqh_bst_shd.g_rec_type) is

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

Line 203: p_effective_date in date,p_rec in pqh_bst_shd.g_rec_type) is

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

Line 258: p_rec in out nocopy pqh_bst_shd.g_rec_type

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

Line 309: l_rec pqh_bst_shd.g_rec_type;

305: p_budget_unit2_value_type_cd in varchar2 default null,
306: p_budget_unit3_value_type_cd in varchar2 default null
307: ) is
308: --
309: l_rec pqh_bst_shd.g_rec_type;
310: l_proc varchar2(72) := g_package||'ins';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);

Line 319: pqh_bst_shd.convert_args

315: -- Call conversion function to turn arguments into the
316: -- p_rec structure.
317: --
318: l_rec :=
319: pqh_bst_shd.convert_args
320: (
321: null,
322: p_dflt_budget_set_id,
323: p_budget_period_id,