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_ECV_INS dependencies on BEN_ECV_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy ben_ecv_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 71: and t.effective_start_date = ben_ecv_shd.g_old_rec.effective_start_date

67: Select t.created_by,
68: t.creation_date
69: from ben_eligy_crit_values_f t
70: where t.eligy_crit_values_id = p_rec.eligy_crit_values_id
71: and t.effective_start_date = ben_ecv_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_eligy_crit_values_f.created_by%TYPE;

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

Line 260: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

256: p_rec.date_value3,
257: p_rec.date_value4
258: );
259: --
260: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
261: hr_utility.set_location(' Leaving:'||l_proc, 15);
262: --
263: Exception
264: When hr_api.check_integrity_violated Then

Line 266: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

262: --
263: Exception
264: When hr_api.check_integrity_violated Then
265: -- A check constraint has been violated
266: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
267: ben_ecv_shd.constraint_error
268: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
269: When hr_api.unique_integrity_violated Then
270: -- Unique integrity has been violated

Line 267: ben_ecv_shd.constraint_error

263: Exception
264: When hr_api.check_integrity_violated Then
265: -- A check constraint has been violated
266: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
267: ben_ecv_shd.constraint_error
268: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
269: When hr_api.unique_integrity_violated Then
270: -- Unique integrity has been violated
271: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

Line 271: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

267: ben_ecv_shd.constraint_error
268: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
269: When hr_api.unique_integrity_violated Then
270: -- Unique integrity has been violated
271: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
272: ben_ecv_shd.constraint_error
273: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274: When Others Then
275: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

Line 272: ben_ecv_shd.constraint_error

268: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
269: When hr_api.unique_integrity_violated Then
270: -- Unique integrity has been violated
271: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
272: ben_ecv_shd.constraint_error
273: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274: When Others Then
275: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
276: Raise;

Line 275: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status

271: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
272: ben_ecv_shd.constraint_error
273: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274: When Others Then
275: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
276: Raise;
277: End dt_insert_dml;
278: --
279: -- ----------------------------------------------------------------------------

Line 283: (p_rec in out nocopy ben_ecv_shd.g_rec_type,

279: -- ----------------------------------------------------------------------------
280: -- |------------------------------< insert_dml >------------------------------|
281: -- ----------------------------------------------------------------------------
282: Procedure insert_dml
283: (p_rec in out nocopy ben_ecv_shd.g_rec_type,
284: p_effective_date in date,
285: p_datetrack_mode in varchar2,
286: p_validation_start_date in date,
287: p_validation_end_date in date) is

Line 343: (p_rec in out nocopy ben_ecv_shd.g_rec_type,

339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure pre_insert
343: (p_rec in out nocopy ben_ecv_shd.g_rec_type,
344: p_effective_date in date,
345: p_datetrack_mode in varchar2,
346: p_validation_start_date in date,
347: p_validation_end_date in date) is

Line 400: (p_rec in ben_ecv_shd.g_rec_type,

396: --
397: -- {End Of Comments}
398: -- ----------------------------------------------------------------------------
399: Procedure post_insert
400: (p_rec in ben_ecv_shd.g_rec_type,
401: p_effective_date in date,
402: p_datetrack_mode in varchar2,
403: p_validation_start_date in date,
404: p_validation_end_date in date) is

Line 534: p_rec in ben_ecv_shd.g_rec_type,

530: -- ----------------------------------------------------------------------------
531: Procedure ins_lck
532: (p_effective_date in date,
533: p_datetrack_mode in varchar2,
534: p_rec in ben_ecv_shd.g_rec_type,
535: p_validation_start_date out nocopy date,
536: p_validation_end_date out nocopy date) is
537: --
538: l_proc varchar2(72) := g_package||'ins_lck';

Line 578: p_rec in out nocopy ben_ecv_shd.g_rec_type,

574: -- |---------------------------------< ins >----------------------------------|
575: -- ----------------------------------------------------------------------------
576: Procedure ins
577: (
578: p_rec in out nocopy ben_ecv_shd.g_rec_type,
579: p_effective_date in date
580: ) is
581: --
582: l_proc varchar2(72) := g_package||'ins';

Line 699: l_rec ben_ecv_shd.g_rec_type;

695: ,p_date_value3 In Date default NULL
696: ,p_date_value4 In Date default NULL
697: ) is
698: --
699: l_rec ben_ecv_shd.g_rec_type;
700: l_proc varchar2(72) := g_package||'ins';
701: --
702:
703: Begin

Line 710: ben_ecv_shd.convert_args

706: -- Call conversion function to turn arguments into the
707: -- p_rec structure.
708: --
709: l_rec :=
710: ben_ecv_shd.convert_args
711: (
712: NULL,
713: p_eligy_prfl_id,
714: p_eligy_criteria_id,