82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in ff_ffn_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: ff_ffn_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the ff_functions row.
97: --
98: delete from ff_functions
97: --
98: delete from ff_functions
99: where function_id = p_rec.function_id;
100: --
101: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception
104: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
108: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
109: ff_ffn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ff_ffn_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End delete_dml;
115: --
116: -- ----------------------------------------------------------------------------
144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in ff_ffn_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin
186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in ff_ffn_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: ff_ffn_rkd.after_delete
204: (p_function_id
205: => p_rec.function_id
206: ,p_business_group_id_o
207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
205: => p_rec.function_id
206: ,p_business_group_id_o
207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
207: => ff_ffn_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
209: => ff_ffn_shd.g_old_rec.legislation_code
210: ,p_class_o
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
211: => ff_ffn_shd.g_old_rec.class
212: ,p_name_o
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
213: => ff_ffn_shd.g_old_rec.name
214: ,p_alias_name_o
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
215: => ff_ffn_shd.g_old_rec.alias_name
216: ,p_data_type_o
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number
217: => ff_ffn_shd.g_old_rec.data_type
218: ,p_definition_o
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number
224: );
225: --
219: => ff_ffn_shd.g_old_rec.definition
220: ,p_description_o
221: => ff_ffn_shd.g_old_rec.description
222: ,p_object_version_number_o
223: => ff_ffn_shd.g_old_rec.object_version_number
224: );
225: --
226: exception
227: --
239: -- ----------------------------------------------------------------------------
240: -- |---------------------------------< del >----------------------------------|
241: -- ----------------------------------------------------------------------------
242: Procedure del
243: (p_rec in ff_ffn_shd.g_rec_type
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
247: l_object_version_number ff_functions.object_version_number%type;
284: End Loop;
285: --
286: -- We must lock the row which we need to delete.
287: --
288: ff_ffn_shd.lck
289: (p_rec.function_id
290: ,p_rec.object_version_number
291: );
292: --
321: (p_function_id in number
322: ,p_object_version_number in number
323: ) is
324: --
325: l_rec ff_ffn_shd.g_rec_type;
326: l_proc varchar2(72) := g_package||'del';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);