APPS.PAY_SIV_INS dependencies on PAY_SIV_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pay_siv_shd.g_rec_type) is

46: -- Internal Row Handler Use Only.
47: --
48: -- {End Of Comments}
49: -- ----------------------------------------------------------------------------
50: Procedure insert_dml(p_rec in out nocopy pay_siv_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 107: pay_siv_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: pay_siv_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: pay_siv_shd.constraint_error

Line 111: pay_siv_shd.constraint_error

107: pay_siv_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: pay_siv_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: pay_siv_shd.constraint_error

Line 115: pay_siv_shd.constraint_error

111: pay_siv_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: pay_siv_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 pay_siv_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 pay_siv_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';
161: --
162: Cursor C_Sel1 is select pay_shadow_input_values_s.nextval from sys.dual;

Line 209: Procedure post_insert(p_rec in pay_siv_shd.g_rec_type) is

205: -- Internal Row Handler Use Only.
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_insert(p_rec in pay_siv_shd.g_rec_type) is
210: --
211: l_proc varchar2(72) := g_package||'post_insert';
212: --
213: Begin

Line 224: ,p_rec in out nocopy pay_siv_shd.g_rec_type

220: -- |---------------------------------< ins >----------------------------------|
221: -- ----------------------------------------------------------------------------
222: Procedure ins
223: (p_effective_date in date
224: ,p_rec in out nocopy pay_siv_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'ins';
228: --

Line 275: l_rec pay_siv_shd.g_rec_type;

271: p_input_validation_formula in varchar2 default null,
272: p_object_version_number out nocopy number
273: ) is
274: --
275: l_rec pay_siv_shd.g_rec_type;
276: l_proc varchar2(72) := g_package||'ins';
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);

Line 285: pay_siv_shd.convert_args

281: -- Call conversion function to turn arguments into the
282: -- p_rec structure.
283: --
284: l_rec :=
285: pay_siv_shd.convert_args
286: (
287: null,
288: p_element_type_id,
289: p_display_sequence,