DBA Data[Home] [Help]

APPS.BEN_COP_INS dependencies on BEN_COP_SHD

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

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

68: t.creation_date
69: from ben_oipl_f t
70: where t.oipl_id = p_rec.oipl_id
71: and t.effective_start_date =
72: ben_cop_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_oipl_f.created_by%TYPE;

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

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

290: l_last_updated_by,
291: l_last_update_login
292: );
293: --
294: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
295: hr_utility.set_location(' Leaving:'||l_proc, 15);
296: --
297: Exception
298: When hr_api.check_integrity_violated Then

Line 300: ben_cop_shd.g_api_dml := false; -- Unset the api dml status

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

Line 301: ben_cop_shd.constraint_error

297: Exception
298: When hr_api.check_integrity_violated Then
299: -- A check constraint has been violated
300: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
301: ben_cop_shd.constraint_error
302: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
303: When hr_api.unique_integrity_violated Then
304: -- Unique integrity has been violated
305: ben_cop_shd.g_api_dml := false; -- Unset the api dml status

Line 305: ben_cop_shd.g_api_dml := false; -- Unset the api dml status

301: ben_cop_shd.constraint_error
302: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
303: When hr_api.unique_integrity_violated Then
304: -- Unique integrity has been violated
305: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
306: ben_cop_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When Others Then
309: ben_cop_shd.g_api_dml := false; -- Unset the api dml status

Line 306: ben_cop_shd.constraint_error

302: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
303: When hr_api.unique_integrity_violated Then
304: -- Unique integrity has been violated
305: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
306: ben_cop_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When Others Then
309: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
310: Raise;

Line 309: ben_cop_shd.g_api_dml := false; -- Unset the api dml status

305: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
306: ben_cop_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When Others Then
309: ben_cop_shd.g_api_dml := false; -- Unset the api dml status
310: Raise;
311: End dt_insert_dml;
312: --
313: -- ----------------------------------------------------------------------------

Line 317: (p_rec in out nocopy ben_cop_shd.g_rec_type,

313: -- ----------------------------------------------------------------------------
314: -- |------------------------------< insert_dml >------------------------------|
315: -- ----------------------------------------------------------------------------
316: Procedure insert_dml
317: (p_rec in out nocopy ben_cop_shd.g_rec_type,
318: p_effective_date in date,
319: p_datetrack_mode in varchar2,
320: p_validation_start_date in date,
321: p_validation_end_date in date) is

Line 377: (p_rec in out nocopy ben_cop_shd.g_rec_type,

373: --
374: -- {End Of Comments}
375: -- ----------------------------------------------------------------------------
376: Procedure pre_insert
377: (p_rec in out nocopy ben_cop_shd.g_rec_type,
378: p_effective_date in date,
379: p_datetrack_mode in varchar2,
380: p_validation_start_date in date,
381: p_validation_end_date in date) is

Line 449: (p_rec in ben_cop_shd.g_rec_type,

445: --
446: -- {End Of Comments}
447: -- ----------------------------------------------------------------------------
448: Procedure post_insert
449: (p_rec in ben_cop_shd.g_rec_type,
450: p_effective_date in date,
451: p_datetrack_mode in varchar2,
452: p_validation_start_date in date,
453: p_validation_end_date in date) is

Line 608: p_rec in ben_cop_shd.g_rec_type,

604: -- ----------------------------------------------------------------------------
605: Procedure ins_lck
606: (p_effective_date in date,
607: p_datetrack_mode in varchar2,
608: p_rec in ben_cop_shd.g_rec_type,
609: p_validation_start_date out nocopy date,
610: p_validation_end_date out nocopy date) is
611: --
612: l_proc varchar2(72) := g_package||'ins_lck';

Line 667: p_rec in out nocopy ben_cop_shd.g_rec_type,

663: -- |---------------------------------< ins >----------------------------------|
664: -- ----------------------------------------------------------------------------
665: Procedure ins
666: (
667: p_rec in out nocopy ben_cop_shd.g_rec_type,
668: p_effective_date in date
669: ) is
670: --
671: l_proc varchar2(72) := g_package||'ins';

Line 806: l_rec ben_cop_shd.g_rec_type;

802: p_object_version_number out nocopy number,
803: p_effective_date in date
804: ) is
805: --
806: l_rec ben_cop_shd.g_rec_type;
807: l_proc varchar2(72) := g_package||'ins';
808: --
809: Begin
810: hr_utility.set_location('Entering:'||l_proc, 5);

Line 816: ben_cop_shd.convert_args

812: -- Call conversion function to turn arguments into the
813: -- p_rec structure.
814: --
815: l_rec :=
816: ben_cop_shd.convert_args
817: (
818: null,
819: null,
820: null,