APPS.PQH_ATT_INS dependencies on PQH_ATT_SHD

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

Line 107: pqh_att_shd.constraint_error

103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: pqh_att_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqh_att_shd.constraint_error

Line 111: pqh_att_shd.constraint_error

107: pqh_att_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqh_att_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: pqh_att_shd.constraint_error

Line 115: pqh_att_shd.constraint_error

111: pqh_att_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: pqh_att_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When Others Then
118: Raise;
119: End insert_dml;

Line 158: Procedure pre_insert(p_rec in out nocopy pqh_att_shd.g_rec_type) is

154: -- Internal Row Handler Use Only.
155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure pre_insert(p_rec in out nocopy pqh_att_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';
161: --
162: Cursor C_Sel1 is select pqh_attributes_s.nextval from sys.dual;

Line 210: p_effective_date in date,p_rec in pqh_att_shd.g_rec_type) is

206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_insert(
210: p_effective_date in date,p_rec in pqh_att_shd.g_rec_type) is
211: --
212: l_proc varchar2(72) := g_package||'post_insert';
213: --
214: Begin

Line 261: p_rec in out nocopy pqh_att_shd.g_rec_type

257: -- ----------------------------------------------------------------------------
258: Procedure ins
259: (
260: p_effective_date in date,
261: p_rec in out nocopy pqh_att_shd.g_rec_type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'ins';
265: --

Line 308: l_rec pqh_att_shd.g_rec_type;

304: p_attribute_itemname in varchar2,
305: p_decode_function_name in varchar2
306: ) is
307: --
308: l_rec pqh_att_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_att_shd.convert_args

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