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_PRY_INS dependencies on BEN_PRY_SHD

Line 58: (p_rec in out nocopy ben_pry_shd.g_rec_type

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

Line 72: ben_pry_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from ben_prtt_rmt_aprvd_fr_pymt_f t
70: where t.prtt_rmt_aprvd_fr_pymt_id = p_rec.prtt_rmt_aprvd_fr_pymt_id
71: and t.effective_start_date =
72: ben_pry_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_prtt_rmt_aprvd_fr_pymt_f.created_by%TYPE;

Line 130: ben_pry_shd.g_api_dml := true; -- Set the api dml status

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

Line 239: ben_pry_shd.g_api_dml := false; -- Unset the api dml status

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

Line 245: ben_pry_shd.g_api_dml := false; -- Unset the api dml status

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

Line 246: ben_pry_shd.constraint_error

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

Line 250: ben_pry_shd.g_api_dml := false; -- Unset the api dml status

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

Line 251: ben_pry_shd.constraint_error

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

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

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

Line 262: (p_rec in out nocopy ben_pry_shd.g_rec_type

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

Line 325: (p_rec in out nocopy ben_pry_shd.g_rec_type

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure pre_insert
325: (p_rec in out nocopy ben_pry_shd.g_rec_type
326: ,p_effective_date in date
327: ,p_datetrack_mode in varchar2
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date

Line 391: (p_rec in ben_pry_shd.g_rec_type

387: --
388: -- {End Of Comments}
389: -- ----------------------------------------------------------------------------
390: Procedure post_insert
391: (p_rec in ben_pry_shd.g_rec_type
392: ,p_effective_date in date
393: ,p_datetrack_mode in varchar2
394: ,p_validation_start_date in date
395: ,p_validation_end_date in date

Line 554: ,p_rec in ben_pry_shd.g_rec_type

550: -- ----------------------------------------------------------------------------
551: Procedure ins_lck
552: (p_effective_date in date
553: ,p_datetrack_mode in varchar2
554: ,p_rec in ben_pry_shd.g_rec_type
555: ,p_validation_start_date out nocopy date
556: ,p_validation_end_date out nocopy date
557: ) is
558: --

Line 597: ,p_rec in out nocopy ben_pry_shd.g_rec_type

593: -- |---------------------------------< ins >----------------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure ins
596: (p_effective_date in date
597: ,p_rec in out nocopy ben_pry_shd.g_rec_type
598: ) is
599: --
600: l_proc varchar2(72) := g_package||'ins';
601: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 713: l_rec ben_pry_shd.g_rec_type;

709: ,p_effective_start_date out nocopy date
710: ,p_effective_end_date out nocopy date
711: ) is
712: --
713: l_rec ben_pry_shd.g_rec_type;
714: l_proc varchar2(72) := g_package||'ins';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);

Line 723: ben_pry_shd.convert_args

719: -- Call conversion function to turn arguments into the
720: -- p_rec structure.
721: --
722: l_rec :=
723: ben_pry_shd.convert_args
724: (null
725: ,p_prtt_reimbmt_rqst_id
726: ,null
727: ,null