APPS.BEN_PUM_DEL dependencies on BEN_PUM_SHD

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

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

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

61: --
62: delete from ben_pop_up_messages
63: where pop_up_messages_id = p_rec.pop_up_messages_id;
64: --
65: ben_pum_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_pum_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_pum_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pum_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pum_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_pum_shd.constraint_error

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

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

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

Line 170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name

166: --
167: ben_pum_rkd.after_delete
168: (
169: p_pop_up_messages_id =>p_rec.pop_up_messages_id
170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name

Line 171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id

167: ben_pum_rkd.after_delete
168: (
169: p_pop_up_messages_id =>p_rec.pop_up_messages_id
170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name

Line 172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name

168: (
169: p_pop_up_messages_id =>p_rec.pop_up_messages_id
170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message

Line 173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name

169: p_pop_up_messages_id =>p_rec.pop_up_messages_id
170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type

Line 174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name

170: ,p_pop_name_o =>ben_pum_shd.g_old_rec.pop_name
171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id

Line 175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name

171: ,p_formula_id_o =>ben_pum_shd.g_old_rec.formula_id
172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number

Line 176: ,p_message_o =>ben_pum_shd.g_old_rec.message

172: ,p_function_name_o =>ben_pum_shd.g_old_rec.function_name
173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date

Line 177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type

173: ,p_block_name_o =>ben_pum_shd.g_old_rec.block_name
174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date

Line 178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id

174: ,p_field_name_o =>ben_pum_shd.g_old_rec.field_name
175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag

Line 179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number

175: ,p_event_name_o =>ben_pum_shd.g_old_rec.event_name
176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
183: );

Line 180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date

176: ,p_message_o =>ben_pum_shd.g_old_rec.message
177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
183: );
184: --

Line 181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date

177: ,p_message_type_o =>ben_pum_shd.g_old_rec.message_type
178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
183: );
184: --
185: exception

Line 182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag

178: ,p_business_group_id_o =>ben_pum_shd.g_old_rec.business_group_id
179: ,p_object_version_number_o =>ben_pum_shd.g_old_rec.object_version_number
180: ,p_start_date_o =>ben_pum_shd.g_old_rec.start_date
181: ,p_end_date_o =>ben_pum_shd.g_old_rec.end_date
182: ,p_no_formula_flag_o =>ben_pum_shd.g_old_rec.no_formula_flag
183: );
184: --
185: exception
186: --

Line 207: p_rec in ben_pum_shd.g_rec_type

203: -- ----------------------------------------------------------------------------
204: Procedure del
205: (
206: p_effective_date in date,
207: p_rec in ben_pum_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'del';
211: --

Line 217: ben_pum_shd.lck

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- We must lock the row which we need to delete.
216: --
217: ben_pum_shd.lck
218: (
219: p_rec.pop_up_messages_id,
220: p_rec.object_version_number
221: );

Line 252: l_rec ben_pum_shd.g_rec_type;

248: p_pop_up_messages_id in number,
249: p_object_version_number in number
250: ) is
251: --
252: l_rec ben_pum_shd.g_rec_type;
253: l_proc varchar2(72) := g_package||'del';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);