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 117: hr_qsf_shd.constraint_error

113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: hr_qsf_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: hr_qsf_shd.constraint_error

Line 121: hr_qsf_shd.constraint_error

117: hr_qsf_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: hr_qsf_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: hr_qsf_shd.constraint_error

Line 125: hr_qsf_shd.constraint_error

121: hr_qsf_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: hr_qsf_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: Raise;
129: End insert_dml;

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

164: -- Internal Row Handler Use Only.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_insert(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'pre_insert';
171: l_exists varchar2(1);
172: --

Line 249: Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type

245: -- Internal Row Handler Use Only.
246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type
250: ,p_effective_date in date
251: ) is
252: --
253: l_proc varchar2(72) := g_package||'post_insert';

Line 289: p_rec in out nocopy hr_qsf_shd.g_rec_type,

285: -- |---------------------------------< ins >----------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure ins
288: (
289: p_rec in out nocopy hr_qsf_shd.g_rec_type,
290: p_effective_date in date
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'ins';

Line 336: l_rec hr_qsf_shd.g_rec_type;

332: ,p_validation_detail in varchar2
333: ,p_display_sequence in number
334: ) is
335: --
336: l_rec hr_qsf_shd.g_rec_type;
337: l_proc varchar2(72) := g_package||'ins';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);

Line 346: hr_qsf_shd.convert_args

342: -- Call conversion function to turn arguments into the
343: -- p_rec structure.
344: --
345: l_rec :=
346: hr_qsf_shd.convert_args
347: (
348: null,
349: p_questionnaire_template_id,
350: p_name,