DBA Data[Home] [Help]

APPS.PER_RET_INS dependencies on PER_RET_SHD

Line 54: (p_rec in out nocopy per_ret_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_ret_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 135: per_ret_shd.constraint_error

131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: --
135: per_ret_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --

Line 140: per_ret_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --
140: per_ret_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --

Line 145: per_ret_shd.constraint_error

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --
145: per_ret_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: --
149: Raise;

Line 190: (p_rec in out nocopy per_ret_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy per_ret_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'pre_insert';
194: --

Line 244: ,p_rec in per_ret_shd.g_rec_type

240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure post_insert
243: (p_effective_date in date
244: ,p_rec in per_ret_shd.g_rec_type
245: ) is
246: --
247: l_proc varchar2(72) := g_package||'post_insert';
248: --

Line 333: ,p_rec in out nocopy per_ret_shd.g_rec_type

329: -- |---------------------------------< ins >----------------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure ins
332: (p_effective_date in date
333: ,p_rec in out nocopy per_ret_shd.g_rec_type
334: ) is
335: --
336: l_proc varchar2(72) := g_package||'ins';
337: --

Line 401: l_rec per_ret_shd.g_rec_type;

397: ,p_cagr_retained_right_id out nocopy number
398: ,p_object_version_number out nocopy number
399: ) is
400: --
401: l_rec per_ret_shd.g_rec_type;
402: l_proc varchar2(72) := g_package||'ins';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);

Line 411: per_ret_shd.convert_args

407: -- Call conversion function to turn arguments into the
408: -- p_rec structure.
409: --
410: l_rec :=
411: per_ret_shd.convert_args
412: (null
413: ,p_assignment_id
414: ,p_cagr_entitlement_item_id
415: ,p_collective_agreement_id