DBA Data[Home] [Help]

APPS.BEN_PTP_INS dependencies on BEN_PTP_SHD

Line 58: (p_rec in out nocopy ben_ptp_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 72: ben_ptp_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from ben_pl_typ_f t
70: where t.pl_typ_id = p_rec.pl_typ_id
71: and t.effective_start_date =
72: ben_ptp_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by ben_pl_typ_f.created_by%TYPE;

Line 129: ben_ptp_shd.g_api_dml := true; -- Set the api dml status

125: l_last_updated_by := fnd_global.user_id;
126: l_last_update_login := fnd_global.login_id;
127: End If;
128: --
129: ben_ptp_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: ben_pl_typ_f
132: --
133: insert into ben_pl_typ_f

Line 248: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

244: l_last_updated_by,
245: l_last_update_login
246: );
247: --
248: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
249: hr_utility.set_location(' Leaving:'||l_proc, 15);
250: --
251: Exception
252: When hr_api.check_integrity_violated Then

Line 254: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

250: --
251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
254: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
255: ben_ptp_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated

Line 255: ben_ptp_shd.constraint_error

251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
254: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
255: ben_ptp_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

Line 259: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

255: ben_ptp_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
260: ben_ptp_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

Line 260: ben_ptp_shd.constraint_error

256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
260: ben_ptp_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
264: Raise;

Line 263: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status

259: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
260: ben_ptp_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ben_ptp_shd.g_api_dml := false; -- Unset the api dml status
264: Raise;
265: End dt_insert_dml;
266: --
267: -- ----------------------------------------------------------------------------

Line 271: (p_rec in out nocopy ben_ptp_shd.g_rec_type,

267: -- ----------------------------------------------------------------------------
268: -- |------------------------------< insert_dml >------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure insert_dml
271: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
272: p_effective_date in date,
273: p_datetrack_mode in varchar2,
274: p_validation_start_date in date,
275: p_validation_end_date in date) is

Line 331: (p_rec in out nocopy ben_ptp_shd.g_rec_type,

327: --
328: -- {End Of Comments}
329: -- ----------------------------------------------------------------------------
330: Procedure pre_insert
331: (p_rec in out nocopy ben_ptp_shd.g_rec_type,
332: p_effective_date in date,
333: p_datetrack_mode in varchar2,
334: p_validation_start_date in date,
335: p_validation_end_date in date) is

Line 387: (p_rec in ben_ptp_shd.g_rec_type,

383: --
384: -- {End Of Comments}
385: -- ----------------------------------------------------------------------------
386: Procedure post_insert
387: (p_rec in ben_ptp_shd.g_rec_type,
388: p_effective_date in date,
389: p_datetrack_mode in varchar2,
390: p_validation_start_date in date,
391: p_validation_end_date in date) is

Line 516: p_rec in ben_ptp_shd.g_rec_type,

512: -- ----------------------------------------------------------------------------
513: Procedure ins_lck
514: (p_effective_date in date,
515: p_datetrack_mode in varchar2,
516: p_rec in ben_ptp_shd.g_rec_type,
517: p_validation_start_date out nocopy date,
518: p_validation_end_date out nocopy date) is
519: --
520: l_proc varchar2(72) := g_package||'ins_lck';

Line 554: p_rec in out nocopy ben_ptp_shd.g_rec_type,

550: -- |---------------------------------< ins >----------------------------------|
551: -- ----------------------------------------------------------------------------
552: Procedure ins
553: (
554: p_rec in out nocopy ben_ptp_shd.g_rec_type,
555: p_effective_date in date
556: ) is
557: --
558: l_proc varchar2(72) := g_package||'ins';

Line 670: l_rec ben_ptp_shd.g_rec_type;

666: p_object_version_number out nocopy number,
667: p_effective_date in date
668: ) is
669: --
670: l_rec ben_ptp_shd.g_rec_type;
671: l_proc varchar2(72) := g_package||'ins';
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);

Line 680: ben_ptp_shd.convert_args

676: -- Call conversion function to turn arguments into the
677: -- p_rec structure.
678: --
679: l_rec :=
680: ben_ptp_shd.convert_args
681: (
682: null,
683: null,
684: null,