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_TUR_INS dependencies on BEN_TUR_SHD

Line 57: (p_rec in out nocopy ben_tur_shd.g_rec_type,

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

Line 71: ben_tur_shd.g_old_rec.effective_start_date

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

Line 128: ben_tur_shd.g_api_dml := true; -- Set the api dml status

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

Line 227: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

223: l_last_updated_by,
224: l_last_update_login
225: );
226: --
227: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: --
230: Exception
231: When hr_api.check_integrity_violated Then

Line 233: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

229: --
230: Exception
231: When hr_api.check_integrity_violated Then
232: -- A check constraint has been violated
233: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
234: ben_tur_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated

Line 234: ben_tur_shd.constraint_error

230: Exception
231: When hr_api.check_integrity_violated Then
232: -- A check constraint has been violated
233: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
234: ben_tur_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

Line 238: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

234: ben_tur_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
239: ben_tur_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

Line 239: ben_tur_shd.constraint_error

235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
239: ben_tur_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
243: Raise;

Line 242: ben_tur_shd.g_api_dml := false; -- Unset the api dml status

238: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
239: ben_tur_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_tur_shd.g_api_dml := false; -- Unset the api dml status
243: Raise;
244: End dt_insert_dml;
245: --
246: -- ----------------------------------------------------------------------------

Line 250: (p_rec in out nocopy ben_tur_shd.g_rec_type,

246: -- ----------------------------------------------------------------------------
247: -- |------------------------------< insert_dml >------------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure insert_dml
250: (p_rec in out nocopy ben_tur_shd.g_rec_type,
251: p_effective_date in date,
252: p_datetrack_mode in varchar2,
253: p_validation_start_date in date,
254: p_validation_end_date in date) is

Line 310: (p_rec in out nocopy ben_tur_shd.g_rec_type,

306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_insert
310: (p_rec in out nocopy ben_tur_shd.g_rec_type,
311: p_effective_date in date,
312: p_datetrack_mode in varchar2,
313: p_validation_start_date in date,
314: p_validation_end_date in date) is

Line 367: (p_rec in ben_tur_shd.g_rec_type,

363: --
364: -- {End Of Comments}
365: -- ----------------------------------------------------------------------------
366: Procedure post_insert
367: (p_rec in ben_tur_shd.g_rec_type,
368: p_effective_date in date,
369: p_datetrack_mode in varchar2,
370: p_validation_start_date in date,
371: p_validation_end_date in date) is

Line 486: p_rec in ben_tur_shd.g_rec_type,

482: -- ----------------------------------------------------------------------------
483: Procedure ins_lck
484: (p_effective_date in date,
485: p_datetrack_mode in varchar2,
486: p_rec in ben_tur_shd.g_rec_type,
487: p_validation_start_date out nocopy date,
488: p_validation_end_date out nocopy date) is
489: --
490: l_proc varchar2(72) := g_package||'ins_lck';

Line 527: p_rec in out nocopy ben_tur_shd.g_rec_type,

523: -- |---------------------------------< ins >----------------------------------|
524: -- ----------------------------------------------------------------------------
525: Procedure ins
526: (
527: p_rec in out nocopy ben_tur_shd.g_rec_type,
528: p_effective_date in date
529: ) is
530: --
531: l_proc varchar2(72) := g_package||'ins';

Line 633: l_rec ben_tur_shd.g_rec_type;

629: p_object_version_number out nocopy number,
630: p_effective_date in date
631: ) is
632: --
633: l_rec ben_tur_shd.g_rec_type;
634: l_proc varchar2(72) := g_package||'ins';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);

Line 643: ben_tur_shd.convert_args

639: -- Call conversion function to turn arguments into the
640: -- p_rec structure.
641: --
642: l_rec :=
643: ben_tur_shd.convert_args
644: (
645: null,
646: null,
647: null,