37: ) is
38: --
39: -- Declare cursors and local variables
40: --
41: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
42: l_proc varchar2(72) := g_package||'create_TRAN_CATEGORY';
43: l_object_version_number pqh_transaction_categories.object_version_number%TYPE;
44: --
45: begin
39: -- Declare cursors and local variables
40: --
41: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
42: l_proc varchar2(72) := g_package||'create_TRAN_CATEGORY';
43: l_object_version_number pqh_transaction_categories.object_version_number%TYPE;
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
242: --
243: -- Declare cursors and local variables
244: --
245: l_proc varchar2(72) := g_package||'update_TRAN_CATEGORY';
246: l_object_version_number pqh_transaction_categories.object_version_number%TYPE;
247: --
248: begin
249: --
250: hr_utility.set_location('Entering:'|| l_proc, 10);
422: --
423: -- Declare cursors and local variables
424: --
425: l_proc varchar2(72) := g_package||'delete_TRAN_CATEGORY';
426: l_object_version_number pqh_transaction_categories.object_version_number%TYPE;
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);