APPS.BEN_PTY_INS dependencies on BEN_PTY_SHD

Line 54: (p_rec in out nocopy ben_pty_shd.g_rec_type

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

Line 63: ben_pty_shd.g_api_dml := true; -- Set the api dml status

59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: ben_pty_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: ben_pl_pcp_typ
66: --
67: insert into ben_pl_pcp_typ

Line 150: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

146: ,p_rec.pty_attribute30
147: ,p_rec.object_version_number
148: );
149: --
150: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then

Line 156: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
157: ben_pty_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated

Line 157: ben_pty_shd.constraint_error

153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
157: ben_pty_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

Line 161: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

157: ben_pty_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
162: ben_pty_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated

Line 162: ben_pty_shd.constraint_error

158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
162: ben_pty_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

Line 166: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

162: ben_pty_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
167: ben_pty_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

Line 167: ben_pty_shd.constraint_error

163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
167: ben_pty_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;

Line 170: ben_pty_shd.g_api_dml := false; -- Unset the api dml status

166: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
167: ben_pty_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;
172: End insert_dml;
173: --
174: -- ----------------------------------------------------------------------------

Line 212: (p_rec in out nocopy ben_pty_shd.g_rec_type

208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure pre_insert
212: (p_rec in out nocopy ben_pty_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: --

Line 265: (p_rec in ben_pty_shd.g_rec_type

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure post_insert
265: (p_rec in ben_pty_shd.g_rec_type
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'post_insert';
269: --

Line 373: p_rec in out nocopy ben_pty_shd.g_rec_type

369: -- |---------------------------------< ins >----------------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure ins
372: (p_effective_date in date,
373: p_rec in out nocopy ben_pty_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'ins';
377: --

Line 450: l_rec ben_pty_shd.g_rec_type;

446: ,p_pl_pcp_typ_id out nocopy number
447: ,p_object_version_number out nocopy number
448: ) is
449: --
450: l_rec ben_pty_shd.g_rec_type;
451: l_proc varchar2(72) := g_package||'ins';
452: --
453: Begin
454: hr_utility.set_location('Entering:'||l_proc, 5);

Line 460: ben_pty_shd.convert_args

456: -- Call conversion function to turn arguments into the
457: -- p_rec structure.
458: --
459: l_rec :=
460: ben_pty_shd.convert_args
461: (null
462: ,p_pl_pcp_id
463: ,p_business_group_id
464: ,p_pcp_typ_cd