APPS.BEN_XCC_DEL dependencies on BEN_XCC_SHD

Line 87: Procedure delete_dml(p_rec in ben_xcc_shd.g_rec_type) is

83: -- Internal Row Handler Use Only.
84: --
85: -- {End Of Comments}
86: -- ----------------------------------------------------------------------------
87: Procedure delete_dml(p_rec in ben_xcc_shd.g_rec_type) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
91: Begin

Line 94: ben_xcc_shd.g_api_dml := true; -- Set the api dml status

90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: ben_xcc_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the ben_ext_crit_cmbn row.
97: --
98: delete from ben_ext_crit_cmbn

Line 101: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status

97: --
98: delete from ben_ext_crit_cmbn
99: where ext_crit_cmbn_id = p_rec.ext_crit_cmbn_id;
100: --
101: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

Line 108: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status

104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status

Line 109: ben_xcc_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

Line 112: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status

108: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xcc_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 148: Procedure pre_delete(p_rec in ben_xcc_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in ben_xcc_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 191: p_effective_date in date,p_rec in ben_xcc_shd.g_rec_type) is

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_delete(
191: p_effective_date in date,p_rec in ben_xcc_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'post_delete';
194: --
195: Begin

Line 211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd

207: --
208: ben_xcc_rkd.after_delete
209: (
210: p_ext_crit_cmbn_id =>p_rec.ext_crit_cmbn_id
211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd
212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id

Line 212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd

208: ben_xcc_rkd.after_delete
209: (
210: p_ext_crit_cmbn_id =>p_rec.ext_crit_cmbn_id
211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd
212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id

Line 213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1

209: (
210: p_ext_crit_cmbn_id =>p_rec.ext_crit_cmbn_id
211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd
212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code

Line 214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2

210: p_ext_crit_cmbn_id =>p_rec.ext_crit_cmbn_id
211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd
212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code
218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number

Line 215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id

211: ,p_crit_typ_cd_o =>ben_xcc_shd.g_old_rec.crit_typ_cd
212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code
218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number
219: );

Line 216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id

212: ,p_oper_cd_o =>ben_xcc_shd.g_old_rec.oper_cd
213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code
218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number
219: );
220: --

Line 217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code

213: ,p_val_1_o =>ben_xcc_shd.g_old_rec.val_1
214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code
218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number
219: );
220: --
221: exception

Line 218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number

214: ,p_val_2_o =>ben_xcc_shd.g_old_rec.val_2
215: ,p_ext_crit_val_id_o =>ben_xcc_shd.g_old_rec.ext_crit_val_id
216: ,p_business_group_id_o =>ben_xcc_shd.g_old_rec.business_group_id
217: ,p_legislation_code_o =>ben_xcc_shd.g_old_rec.legislation_code
218: ,p_object_version_number_o =>ben_xcc_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
222: --

Line 243: p_rec in ben_xcc_shd.g_rec_type

239: -- ----------------------------------------------------------------------------
240: Procedure del
241: (
242: p_effective_date in date,
243: p_rec in ben_xcc_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
247: --

Line 253: ben_xcc_shd.lck

249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- We must lock the row which we need to delete.
252: --
253: ben_xcc_shd.lck
254: (
255: p_rec.ext_crit_cmbn_id,
256: p_rec.object_version_number
257: );

Line 289: l_rec ben_xcc_shd.g_rec_type;

285: p_legislation_code in varchar2 default null,
286: p_object_version_number in number
287: ) is
288: --
289: l_rec ben_xcc_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'del';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);