DBA Data[Home] [Help]

APPS.PER_SLT_INS dependencies on PER_SLT_SHD

Line 76: (p_rec in out nocopy per_slt_shd.g_rec_type

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

Line 109: per_slt_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: per_slt_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --

Line 114: per_slt_shd.constraint_error

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

Line 119: per_slt_shd.constraint_error

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

Line 164: (p_rec in out nocopy per_slt_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_insert
164: (p_rec in out nocopy per_slt_shd.g_rec_type
165: ) is
166: --
167: Cursor C_Sel2 is
168: Select null

Line 243: ,p_rec in per_slt_shd.g_rec_type

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

Line 282: ,p_rec in out nocopy per_slt_shd.g_rec_type

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

Line 332: l_rec per_slt_shd.g_rec_type;

328: ,p_solution_category in varchar2 default null
329: ,p_object_version_number out nocopy number
330: ) is
331: --
332: l_rec per_slt_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'ins';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);

Line 342: per_slt_shd.convert_args

338: -- Call conversion function to turn arguments into the
339: -- p_rec structure.
340: --
341: l_rec :=
342: per_slt_shd.convert_args
343: (null
344: ,p_solution_category
345: ,p_updateable
346: ,null