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_ECC_DEL dependencies on BEN_ECC_SHD

Line 51: Procedure delete_dml(p_rec in ben_ecc_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_ecc_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_ecc_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_ecc_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_elctbl_chc_ctfn row.
61: --
62: delete from ben_elctbl_chc_ctfn

Line 65: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from ben_elctbl_chc_ctfn
63: where elctbl_chc_ctfn_id = p_rec.elctbl_chc_ctfn_id;
64: --
65: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_ecc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_ecc_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_ecc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status

72: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_ecc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_ecc_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_ecc_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 155: p_effective_date in date,p_rec in ben_ecc_shd.g_rec_type) is

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_ecc_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd

166: --
167: ben_ecc_rkd.after_delete
168: (
169: p_elctbl_chc_ctfn_id =>p_rec.elctbl_chc_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id

Line 171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag

167: ben_ecc_rkd.after_delete
168: (
169: p_elctbl_chc_ctfn_id =>p_rec.elctbl_chc_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category

Line 172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id

168: (
169: p_elctbl_chc_ctfn_id =>p_rec.elctbl_chc_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1

Line 173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id

169: p_elctbl_chc_ctfn_id =>p_rec.elctbl_chc_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2

Line 174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id

170: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3

Line 175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category

171: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4

Line 176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1

172: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5

Line 177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2

173: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6

Line 178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3

174: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7

Line 179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4

175: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8

Line 180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5

176: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9

Line 181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6

177: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10

Line 182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7

178: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11

Line 183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8

179: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12

Line 184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9

180: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13

Line 185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10

181: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14

Line 186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11

182: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15

Line 187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12

183: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16

Line 188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13

184: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17

Line 189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14

185: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18

Line 190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15

186: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19

Line 191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16

187: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20

Line 192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17

188: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21

Line 193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18

189: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22

Line 194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19

190: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23

Line 195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20

191: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24

Line 196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21

192: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25

Line 197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22

193: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26

Line 198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23

194: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27

Line 199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24

195: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28

Line 200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25

196: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29

Line 201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26

197: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30

Line 202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27

198: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag

Line 203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28

199: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd

Line 204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29

200: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id

Line 205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30

201: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id

Line 206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag

202: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id

Line 207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd

203: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date

Line 208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id

204: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number

Line 209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id

205: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
213: );

Line 210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id

206: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
213: );
214: --

Line 211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date

207: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
213: );
214: --
215: exception

Line 212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number

208: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
209: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
210: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
211: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
212: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
213: );
214: --
215: exception
216: --

Line 237: p_rec in ben_ecc_shd.g_rec_type

233: -- ----------------------------------------------------------------------------
234: Procedure del
235: (
236: p_effective_date in date,
237: p_rec in ben_ecc_shd.g_rec_type
238: ) is
239: --
240: l_proc varchar2(72) := g_package||'del';
241: --

Line 247: ben_ecc_shd.lck

243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- We must lock the row which we need to delete.
246: --
247: ben_ecc_shd.lck
248: (
249: p_rec.elctbl_chc_ctfn_id,
250: p_rec.object_version_number
251: );

Line 282: l_rec ben_ecc_shd.g_rec_type;

278: p_elctbl_chc_ctfn_id in number,
279: p_object_version_number in number
280: ) is
281: --
282: l_rec ben_ecc_shd.g_rec_type;
283: l_proc varchar2(72) := g_package||'del';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);