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_CRP_DEL dependencies on BEN_CRP_SHD

Line 51: Procedure delete_dml(p_rec in ben_crp_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_crp_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_crp_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_crp_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_cbr_per_in_ler row.
61: --
62: delete from ben_cbr_per_in_ler

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

61: --
62: delete from ben_cbr_per_in_ler
63: where cbr_per_in_ler_id = p_rec.cbr_per_in_ler_id;
64: --
65: ben_crp_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_crp_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_crp_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crp_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_crp_shd.constraint_error

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

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

72: ben_crp_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crp_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_crp_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_crp_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_crp_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_crp_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag

166: --
167: ben_crp_rkd.after_delete
168: (
169: p_cbr_per_in_ler_id =>p_rec.cbr_per_in_ler_id
170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag
171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt

Line 171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num

167: ben_crp_rkd.after_delete
168: (
169: p_cbr_per_in_ler_id =>p_rec.cbr_per_in_ler_id
170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag
171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id

Line 172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id

168: (
169: p_cbr_per_in_ler_id =>p_rec.cbr_per_in_ler_id
170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag
171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category

Line 173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id

169: p_cbr_per_in_ler_id =>p_rec.cbr_per_in_ler_id
170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag
171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1

Line 174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt

170: ,p_init_evt_flag_o =>ben_crp_shd.g_old_rec.init_evt_flag
171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2

Line 175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id

171: ,p_cnt_num_o =>ben_crp_shd.g_old_rec.cnt_num
172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3

Line 176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category

172: ,p_per_in_ler_id_o =>ben_crp_shd.g_old_rec.per_in_ler_id
173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4

Line 177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1

173: ,p_cbr_quald_bnf_id_o =>ben_crp_shd.g_old_rec.cbr_quald_bnf_id
174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5

Line 178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2

174: ,p_prvs_elig_perd_end_dt_o =>ben_crp_shd.g_old_rec.prvs_elig_perd_end_dt
175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6

Line 179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3

175: ,p_business_group_id_o =>ben_crp_shd.g_old_rec.business_group_id
176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7

Line 180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4

176: ,p_crp_attribute_category_o =>ben_crp_shd.g_old_rec.crp_attribute_category
177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8

Line 181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5

177: ,p_crp_attribute1_o =>ben_crp_shd.g_old_rec.crp_attribute1
178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9

Line 182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6

178: ,p_crp_attribute2_o =>ben_crp_shd.g_old_rec.crp_attribute2
179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10

Line 183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7

179: ,p_crp_attribute3_o =>ben_crp_shd.g_old_rec.crp_attribute3
180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11

Line 184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8

180: ,p_crp_attribute4_o =>ben_crp_shd.g_old_rec.crp_attribute4
181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12

Line 185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9

181: ,p_crp_attribute5_o =>ben_crp_shd.g_old_rec.crp_attribute5
182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13

Line 186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10

182: ,p_crp_attribute6_o =>ben_crp_shd.g_old_rec.crp_attribute6
183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14

Line 187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11

183: ,p_crp_attribute7_o =>ben_crp_shd.g_old_rec.crp_attribute7
184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15

Line 188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12

184: ,p_crp_attribute8_o =>ben_crp_shd.g_old_rec.crp_attribute8
185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16

Line 189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13

185: ,p_crp_attribute9_o =>ben_crp_shd.g_old_rec.crp_attribute9
186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17

Line 190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14

186: ,p_crp_attribute10_o =>ben_crp_shd.g_old_rec.crp_attribute10
187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18

Line 191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15

187: ,p_crp_attribute11_o =>ben_crp_shd.g_old_rec.crp_attribute11
188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19

Line 192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16

188: ,p_crp_attribute12_o =>ben_crp_shd.g_old_rec.crp_attribute12
189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20

Line 193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17

189: ,p_crp_attribute13_o =>ben_crp_shd.g_old_rec.crp_attribute13
190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21

Line 194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18

190: ,p_crp_attribute14_o =>ben_crp_shd.g_old_rec.crp_attribute14
191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22

Line 195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19

191: ,p_crp_attribute15_o =>ben_crp_shd.g_old_rec.crp_attribute15
192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23

Line 196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20

192: ,p_crp_attribute16_o =>ben_crp_shd.g_old_rec.crp_attribute16
193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24

Line 197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21

193: ,p_crp_attribute17_o =>ben_crp_shd.g_old_rec.crp_attribute17
194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25

Line 198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22

194: ,p_crp_attribute18_o =>ben_crp_shd.g_old_rec.crp_attribute18
195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26

Line 199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23

195: ,p_crp_attribute19_o =>ben_crp_shd.g_old_rec.crp_attribute19
196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27

Line 200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24

196: ,p_crp_attribute20_o =>ben_crp_shd.g_old_rec.crp_attribute20
197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28

Line 201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25

197: ,p_crp_attribute21_o =>ben_crp_shd.g_old_rec.crp_attribute21
198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29

Line 202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26

198: ,p_crp_attribute22_o =>ben_crp_shd.g_old_rec.crp_attribute22
199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30

Line 203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27

199: ,p_crp_attribute23_o =>ben_crp_shd.g_old_rec.crp_attribute23
200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30
207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number

Line 204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28

200: ,p_crp_attribute24_o =>ben_crp_shd.g_old_rec.crp_attribute24
201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30
207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number
208: );

Line 205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29

201: ,p_crp_attribute25_o =>ben_crp_shd.g_old_rec.crp_attribute25
202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30
207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number
208: );
209: --

Line 206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30

202: ,p_crp_attribute26_o =>ben_crp_shd.g_old_rec.crp_attribute26
203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30
207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number
208: );
209: --
210: exception

Line 207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number

203: ,p_crp_attribute27_o =>ben_crp_shd.g_old_rec.crp_attribute27
204: ,p_crp_attribute28_o =>ben_crp_shd.g_old_rec.crp_attribute28
205: ,p_crp_attribute29_o =>ben_crp_shd.g_old_rec.crp_attribute29
206: ,p_crp_attribute30_o =>ben_crp_shd.g_old_rec.crp_attribute30
207: ,p_object_version_number_o =>ben_crp_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 232: p_rec in ben_crp_shd.g_rec_type

228: -- ----------------------------------------------------------------------------
229: Procedure del
230: (
231: p_effective_date in date,
232: p_rec in ben_crp_shd.g_rec_type
233: ) is
234: --
235: l_proc varchar2(72) := g_package||'del';
236: --

Line 242: ben_crp_shd.lck

238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: -- We must lock the row which we need to delete.
241: --
242: ben_crp_shd.lck
243: (
244: p_rec.cbr_per_in_ler_id,
245: p_rec.object_version_number
246: );

Line 277: l_rec ben_crp_shd.g_rec_type;

273: p_cbr_per_in_ler_id in number,
274: p_object_version_number in number
275: ) is
276: --
277: l_rec ben_crp_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'del';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);