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_DDR_INS dependencies on BEN_DDR_SHD

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

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

68: t.creation_date
69: from ben_dsgn_rqmt_f t
70: where t.dsgn_rqmt_id = p_rec.dsgn_rqmt_id
71: and t.effective_start_date =
72: ben_ddr_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_dsgn_rqmt_f.created_by%TYPE;

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

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

236: l_last_updated_by,
237: l_last_update_login
238: );
239: --
240: ben_ddr_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_ddr_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_ddr_shd.g_api_dml := false; -- Unset the api dml status
247: ben_ddr_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_ddr_shd.constraint_error

243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
247: ben_ddr_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_ddr_shd.g_api_dml := false; -- Unset the api dml status

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

247: ben_ddr_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_ddr_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ddr_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status

Line 252: ben_ddr_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_ddr_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ddr_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
256: Raise;

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

251: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
252: ben_ddr_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When Others Then
255: ben_ddr_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_ddr_shd.g_rec_type,

259: -- ----------------------------------------------------------------------------
260: -- |------------------------------< insert_dml >------------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure insert_dml
263: (p_rec in out nocopy ben_ddr_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_ddr_shd.g_rec_type,

319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure pre_insert
323: (p_rec in out nocopy ben_ddr_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 380: (p_rec in ben_ddr_shd.g_rec_type,

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure post_insert
380: (p_rec in ben_ddr_shd.g_rec_type,
381: p_effective_date in date,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) is

Line 505: p_rec in ben_ddr_shd.g_rec_type,

501: -- ----------------------------------------------------------------------------
502: Procedure ins_lck
503: (p_effective_date in date,
504: p_datetrack_mode in varchar2,
505: p_rec in ben_ddr_shd.g_rec_type,
506: p_validation_start_date out nocopy date,
507: p_validation_end_date out nocopy date) is
508: --
509: l_proc varchar2(72) := g_package||'ins_lck';

Line 552: p_rec in out nocopy ben_ddr_shd.g_rec_type,

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

Line 664: l_rec ben_ddr_shd.g_rec_type;

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

Line 674: ben_ddr_shd.convert_args

670: -- Call conversion function to turn arguments into the
671: -- p_rec structure.
672: --
673: l_rec :=
674: ben_ddr_shd.convert_args
675: (
676: null,
677: null,
678: null,