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_BPP_INS dependencies on BEN_BPP_SHD

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

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

68: t.creation_date
69: from ben_bnft_prvdr_pool_f t
70: where t.bnft_prvdr_pool_id = p_rec.bnft_prvdr_pool_id
71: and t.effective_start_date =
72: ben_bpp_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_bnft_prvdr_pool_f.created_by%TYPE;

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

Line 288: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

284: l_last_update_login
285: );
286: --
287:
288: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
289: hr_utility.set_location(' Leaving:'||l_proc, 15);
290: --
291: Exception
292: When hr_api.check_integrity_violated Then

Line 294: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

290: --
291: Exception
292: When hr_api.check_integrity_violated Then
293: -- A check constraint has been violated
294: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
295: ben_bpp_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When hr_api.unique_integrity_violated Then
298: -- Unique integrity has been violated

Line 295: ben_bpp_shd.constraint_error

291: Exception
292: When hr_api.check_integrity_violated Then
293: -- A check constraint has been violated
294: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
295: ben_bpp_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When hr_api.unique_integrity_violated Then
298: -- Unique integrity has been violated
299: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

Line 299: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

295: ben_bpp_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When hr_api.unique_integrity_violated Then
298: -- Unique integrity has been violated
299: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
300: ben_bpp_shd.constraint_error
301: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
302: When Others Then
303: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

Line 300: ben_bpp_shd.constraint_error

296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When hr_api.unique_integrity_violated Then
298: -- Unique integrity has been violated
299: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
300: ben_bpp_shd.constraint_error
301: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
302: When Others Then
303: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
304: Raise;

Line 303: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status

299: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
300: ben_bpp_shd.constraint_error
301: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
302: When Others Then
303: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
304: Raise;
305: End dt_insert_dml;
306: --
307: -- ----------------------------------------------------------------------------

Line 311: (p_rec in out nocopy ben_bpp_shd.g_rec_type,

307: -- ----------------------------------------------------------------------------
308: -- |------------------------------< insert_dml >------------------------------|
309: -- ----------------------------------------------------------------------------
310: Procedure insert_dml
311: (p_rec in out nocopy ben_bpp_shd.g_rec_type,
312: p_effective_date in date,
313: p_datetrack_mode in varchar2,
314: p_validation_start_date in date,
315: p_validation_end_date in date) is

Line 371: (p_rec in out nocopy ben_bpp_shd.g_rec_type,

367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure pre_insert
371: (p_rec in out nocopy ben_bpp_shd.g_rec_type,
372: p_effective_date in date,
373: p_datetrack_mode in varchar2,
374: p_validation_start_date in date,
375: p_validation_end_date in date) is

Line 426: (p_rec in ben_bpp_shd.g_rec_type,

422: --
423: -- {End Of Comments}
424: -- ----------------------------------------------------------------------------
425: Procedure post_insert
426: (p_rec in ben_bpp_shd.g_rec_type,
427: p_effective_date in date,
428: p_datetrack_mode in varchar2,
429: p_validation_start_date in date,
430: p_validation_end_date in date) is

Line 573: p_rec in ben_bpp_shd.g_rec_type,

569: -- ----------------------------------------------------------------------------
570: Procedure ins_lck
571: (p_effective_date in date,
572: p_datetrack_mode in varchar2,
573: p_rec in ben_bpp_shd.g_rec_type,
574: p_validation_start_date out nocopy date,
575: p_validation_end_date out nocopy date) is
576: --
577: l_proc varchar2(72) := g_package||'ins_lck';

Line 632: p_rec in out nocopy ben_bpp_shd.g_rec_type,

628: -- |---------------------------------< ins >----------------------------------|
629: -- ----------------------------------------------------------------------------
630: Procedure ins
631: (
632: p_rec in out nocopy ben_bpp_shd.g_rec_type,
633: p_effective_date in date
634: ) is
635: --
636: l_proc varchar2(72) := g_package||'ins';

Line 767: l_rec ben_bpp_shd.g_rec_type;

763: p_object_version_number out nocopy number,
764: p_effective_date in date
765: ) is
766: --
767: l_rec ben_bpp_shd.g_rec_type;
768: l_proc varchar2(72) := g_package||'ins';
769: --
770: Begin
771: hr_utility.set_location('Entering:'||l_proc, 5);

Line 777: ben_bpp_shd.convert_args

773: -- Call conversion function to turn arguments into the
774: -- p_rec structure.
775: --
776: l_rec :=
777: ben_bpp_shd.convert_args
778: (
779: null,
780: null,
781: null,