DBA Data[Home] [Help]

APPS.HR_QSF_INS dependencies on HR_QSF_SHD

Line 74: Procedure insert_dml(p_rec in out nocopy hr_qsf_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_qsf_shd.g_rec_type) is
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin

Line 111: hr_qsf_shd.constraint_error

107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: hr_qsf_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: hr_qsf_shd.constraint_error

Line 115: hr_qsf_shd.constraint_error

111: hr_qsf_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: hr_qsf_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: hr_qsf_shd.constraint_error

Line 119: hr_qsf_shd.constraint_error

115: hr_qsf_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: hr_qsf_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: Raise;
123: End insert_dml;

Line 162: Procedure pre_insert(p_rec in out nocopy hr_qsf_shd.g_rec_type) is

158: -- Internal Row Handler Use Only.
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_insert(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
163: --
164: l_proc varchar2(72) := g_package||'pre_insert';
165: l_exists varchar2(1);
166: --

Line 243: Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type

239: -- Internal Row Handler Use Only.
240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type
244: ,p_effective_date in date
245: ) is
246: --
247: l_proc varchar2(72) := g_package||'post_insert';

Line 280: p_rec in out nocopy hr_qsf_shd.g_rec_type,

276: -- |---------------------------------< ins >----------------------------------|
277: -- ----------------------------------------------------------------------------
278: Procedure ins
279: (
280: p_rec in out nocopy hr_qsf_shd.g_rec_type,
281: p_effective_date in date
282: ) is
283: --
284: l_proc varchar2(72) := g_package||'ins';

Line 324: l_rec hr_qsf_shd.g_rec_type;

320: p_object_version_number out nocopy number,
321: p_effective_date in date
322: ) is
323: --
324: l_rec hr_qsf_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'ins';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);

Line 334: hr_qsf_shd.convert_args

330: -- Call conversion function to turn arguments into the
331: -- p_rec structure.
332: --
333: l_rec :=
334: hr_qsf_shd.convert_args
335: (
336: null,
337: p_questionnaire_template_id,
338: p_name,