APPS.HR_OPT_INS dependencies on HR_OPT_SHD

Line 76: (p_rec in out nocopy hr_opt_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy hr_opt_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 117: hr_opt_shd.constraint_error

113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_opt_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: --

Line 122: hr_opt_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: --
122: hr_opt_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --

Line 127: hr_opt_shd.constraint_error

123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_opt_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;

Line 172: (p_rec in out nocopy hr_opt_shd.g_rec_type

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure pre_insert
172: (p_rec in out nocopy hr_opt_shd.g_rec_type
173: ) is
174: --
175: Cursor C_Sel1 is select hr_ki_options_s.nextval from sys.dual;
176: --

Line 273: ,p_rec in hr_opt_shd.g_rec_type

269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure post_insert
272: (p_effective_date in date
273: ,p_rec in hr_opt_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'post_insert';
277: --

Line 320: ,p_rec in out nocopy hr_opt_shd.g_rec_type

316: -- |---------------------------------< ins >----------------------------------|
317: -- ----------------------------------------------------------------------------
318: Procedure ins
319: (p_effective_date in date
320: ,p_rec in out nocopy hr_opt_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package||'ins';
324: --

Line 374: l_rec hr_opt_shd.g_rec_type;

370: ,p_option_id out nocopy number
371: ,p_object_version_number out nocopy number
372: ) is
373: --
374: l_rec hr_opt_shd.g_rec_type;
375: l_proc varchar2(72) := g_package||'ins';
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);

Line 384: hr_opt_shd.convert_args

380: -- Call conversion function to turn arguments into the
381: -- p_rec structure.
382: --
383: l_rec :=
384: hr_opt_shd.convert_args
385: (null
386: ,p_option_type_id
387: ,p_option_level
388: ,p_option_level_id