DBA Data[Home] [Help]

APPS.HR_QSV_INS dependencies on HR_QSV_SHD

Line 74: Procedure insert_dml(p_rec in out nocopy hr_qsv_shd.g_rec_type) is

70: -- Internal Row Handler Use Only.
71: --
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure insert_dml(p_rec in out nocopy hr_qsv_shd.g_rec_type) is
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin

Line 103: hr_qsv_shd.constraint_error

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

Line 107: hr_qsv_shd.constraint_error

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

Line 111: hr_qsv_shd.constraint_error

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

Line 154: Procedure pre_insert(p_rec in out nocopy hr_qsv_shd.g_rec_type) is

150: -- Internal Row Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure pre_insert(p_rec in out nocopy hr_qsv_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'pre_insert';
157: l_exists varchar2(1);
158: --

Line 235: Procedure post_insert(p_rec in hr_qsv_shd.g_rec_type) is

231: -- Internal Row Handler Use Only.
232: --
233: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure post_insert(p_rec in hr_qsv_shd.g_rec_type) is
236: --
237: l_proc varchar2(72) := g_package||'post_insert';
238: --
239: Begin

Line 266: p_rec in out nocopy hr_qsv_shd.g_rec_type

262: -- |---------------------------------< ins >----------------------------------|
263: -- ----------------------------------------------------------------------------
264: Procedure ins
265: (
266: p_rec in out nocopy hr_qsv_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72) := g_package||'ins';
270: --

Line 303: l_rec hr_qsv_shd.g_rec_type;

299: p_object_version_number out nocopy number,
300: p_value in varchar2 default null
301: ) is
302: --
303: l_rec hr_qsv_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);

Line 313: hr_qsv_shd.convert_args

309: -- Call conversion function to turn arguments into the
310: -- p_rec structure.
311: --
312: l_rec :=
313: hr_qsv_shd.convert_args
314: (
315: null,
316: p_questionnaire_answer_id,
317: p_field_id,