eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PPB_INS dependencies on PER_PPB_SHD

Line 76: (p_rec in out nocopy per_ppb_shd.g_rec_type

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

Line 80: l_rec per_ppb_shd.g_rec_type ;

76: (p_rec in out nocopy per_ppb_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: l_rec per_ppb_shd.g_rec_type ;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: l_rec := p_rec;

Line 87: per_ppb_shd.g_api_dml := true; -- Set the api dml status

83: hr_utility.set_location('Entering:'||l_proc, 5);
84: l_rec := p_rec;
85: p_rec.object_version_number := 1; -- Initialise the object version
86: --
87: per_ppb_shd.g_api_dml := true; -- Set the api dml status
88: --
89: -- Insert the row into: per_pay_bases
90: --
91: insert into per_pay_bases

Line 202: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

198: ,p_rec.information20
199: ,p_rec.object_version_number
200: );
201: --
202: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: Exception
206: When hr_api.check_integrity_violated Then

Line 208: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

204: hr_utility.set_location(' Leaving:'||l_proc, 10);
205: Exception
206: When hr_api.check_integrity_violated Then
207: -- A check constraint has been violated
208: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
209: p_rec := l_rec;
210: per_ppb_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.parent_integrity_violated Then

Line 210: per_ppb_shd.constraint_error

206: When hr_api.check_integrity_violated Then
207: -- A check constraint has been violated
208: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
209: p_rec := l_rec;
210: per_ppb_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.parent_integrity_violated Then
213: -- Parent integrity has been violated
214: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

Line 214: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

210: per_ppb_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.parent_integrity_violated Then
213: -- Parent integrity has been violated
214: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
215: p_rec := l_rec;
216: per_ppb_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then

Line 216: per_ppb_shd.constraint_error

212: When hr_api.parent_integrity_violated Then
213: -- Parent integrity has been violated
214: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
215: p_rec := l_rec;
216: per_ppb_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

Line 220: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

216: per_ppb_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
221: p_rec := l_rec;
222: per_ppb_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then

Line 222: per_ppb_shd.constraint_error

218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
221: p_rec := l_rec;
222: per_ppb_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then
225: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
226: p_rec := l_rec;

Line 225: per_ppb_shd.g_api_dml := false; -- Unset the api dml status

221: p_rec := l_rec;
222: per_ppb_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then
225: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
226: p_rec := l_rec;
227: Raise;
228: End insert_dml;
229: --

Line 268: (p_rec in out nocopy per_ppb_shd.g_rec_type

264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure pre_insert
268: (p_rec in out nocopy per_ppb_shd.g_rec_type
269: ) is
270: --
271: Cursor C_Sel1 is select per_pay_bases_s.nextval from sys.dual;
272: --

Line 281: l_rec per_ppb_shd.g_rec_type;

277: per_ppb_ins.g_pay_basis_id_i;
278: --
279: l_proc varchar2(72) := g_package||'pre_insert';
280: l_exists varchar2(1);
281: l_rec per_ppb_shd.g_rec_type;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: l_rec := p_rec;

Line 361: (p_rec in per_ppb_shd.g_rec_type

357: --
358: -- {End Of Comments}
359: -- ----------------------------------------------------------------------------
360: Procedure post_insert
361: (p_rec in per_ppb_shd.g_rec_type
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'post_insert';
365: --

Line 496: (p_rec in out nocopy per_ppb_shd.g_rec_type

492: -- ----------------------------------------------------------------------------
493: -- |---------------------------------< ins >----------------------------------|
494: -- ----------------------------------------------------------------------------
495: Procedure ins
496: (p_rec in out nocopy per_ppb_shd.g_rec_type
497: ) is
498: --
499: l_proc varchar2(72) := g_package||'ins';
500: l_rec per_ppb_shd.g_rec_type;

Line 500: l_rec per_ppb_shd.g_rec_type;

496: (p_rec in out nocopy per_ppb_shd.g_rec_type
497: ) is
498: --
499: l_proc varchar2(72) := g_package||'ins';
500: l_rec per_ppb_shd.g_rec_type;
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: l_rec := p_rec;

Line 598: l_rec per_ppb_shd.g_rec_type;

594: ,p_pay_basis_id out nocopy number
595: ,p_object_version_number out nocopy number
596: ) is
597: --
598: l_rec per_ppb_shd.g_rec_type;
599: l_proc varchar2(72) := g_package||'ins';
600: --
601: Begin
602: hr_utility.set_location('Entering:'||l_proc, 5);

Line 608: per_ppb_shd.convert_args

604: -- Call conversion function to turn arguments into the
605: -- p_rec structure.
606: --
607: l_rec :=
608: per_ppb_shd.convert_args
609: (null
610: ,p_input_value_id
611: ,p_rate_id
612: ,p_business_group_id