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.BEN_CTU_INS dependencies on BEN_CTU_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy ben_ctu_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_ctu_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from ben_cm_typ_usg_f t
70: where t.cm_typ_usg_id = p_rec.cm_typ_usg_id
71: and t.effective_start_date =
72: ben_ctu_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_cm_typ_usg_f.created_by%TYPE;

Line 129: ben_ctu_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_ctu_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: ben_cm_typ_usg_f
132: --
133: insert into ben_cm_typ_usg_f

Line 240: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

236: l_last_updated_by,
237: l_last_update_login
238: );
239: --
240: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
241: hr_utility.set_location(' Leaving:'||l_proc, 15);
242: --
243: Exception
244: When hr_api.check_integrity_violated Then

Line 246: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

242: --
243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
247: ben_ctu_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated

Line 247: ben_ctu_shd.constraint_error

243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
247: ben_ctu_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

Line 251: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

247: ben_ctu_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ctu_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

Line 252: ben_ctu_shd.constraint_error

248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ctu_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
256: Raise;

Line 255: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status

251: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ctu_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ctu_shd.g_api_dml := false; -- Unset the api dml status
256: Raise;
257: End dt_insert_dml;
258: --
259: -- ----------------------------------------------------------------------------

Line 263: (p_rec in out nocopy ben_ctu_shd.g_rec_type,

259: -- ----------------------------------------------------------------------------
260: -- |------------------------------< insert_dml >------------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure insert_dml
263: (p_rec in out nocopy ben_ctu_shd.g_rec_type,
264: p_effective_date in date,
265: p_datetrack_mode in varchar2,
266: p_validation_start_date in date,
267: p_validation_end_date in date) is

Line 323: (p_rec in out nocopy ben_ctu_shd.g_rec_type,

319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure pre_insert
323: (p_rec in out nocopy ben_ctu_shd.g_rec_type,
324: p_effective_date in date,
325: p_datetrack_mode in varchar2,
326: p_validation_start_date in date,
327: p_validation_end_date in date) is

Line 376: (p_rec in ben_ctu_shd.g_rec_type,

372: --
373: -- {End Of Comments}
374: -- ----------------------------------------------------------------------------
375: Procedure post_insert
376: (p_rec in ben_ctu_shd.g_rec_type,
377: p_effective_date in date,
378: p_datetrack_mode in varchar2,
379: p_validation_start_date in date,
380: p_validation_end_date in date) is

Line 499: p_rec in ben_ctu_shd.g_rec_type,

495: -- ----------------------------------------------------------------------------
496: Procedure ins_lck
497: (p_effective_date in date,
498: p_datetrack_mode in varchar2,
499: p_rec in ben_ctu_shd.g_rec_type,
500: p_validation_start_date out nocopy date,
501: p_validation_end_date out nocopy date) is
502: --
503: l_proc varchar2(72) := g_package||'ins_lck';

Line 549: p_rec in out nocopy ben_ctu_shd.g_rec_type,

545: -- |---------------------------------< ins >----------------------------------|
546: -- ----------------------------------------------------------------------------
547: Procedure ins
548: (
549: p_rec in out nocopy ben_ctu_shd.g_rec_type,
550: p_effective_date in date
551: ) is
552: --
553: l_proc varchar2(72) := g_package||'ins';

Line 661: l_rec ben_ctu_shd.g_rec_type;

657: p_object_version_number out nocopy number,
658: p_effective_date in date
659: ) is
660: --
661: l_rec ben_ctu_shd.g_rec_type;
662: l_proc varchar2(72) := g_package||'ins';
663: --
664: Begin
665: hr_utility.set_location('Entering:'||l_proc, 5);

Line 671: ben_ctu_shd.convert_args

667: -- Call conversion function to turn arguments into the
668: -- p_rec structure.
669: --
670: l_rec :=
671: ben_ctu_shd.convert_args
672: (
673: null,
674: null,
675: null,