47: ) is
48: --
49: -- Declare cursors and local variables
50: --
51: l_delivery_method_id per_person_dlvry_methods.delivery_method_id%TYPE;
52: l_proc varchar2(72) := g_package||'create_delivery_method';
53: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
54: l_effective_date date;
55: --
49: -- Declare cursors and local variables
50: --
51: l_delivery_method_id per_person_dlvry_methods.delivery_method_id%TYPE;
52: l_proc varchar2(72) := g_package||'create_delivery_method';
53: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
54: l_effective_date date;
55: --
56: begin
57: --
295: --
296: -- Declare cursors and local variables
297: --
298: l_proc varchar2(72) := g_package||'update_delivery_method';
299: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
300: l_ovn per_person_dlvry_methods.object_version_number%TYPE := p_object_version_number;
301: l_effective_date date;
302: --
303: begin
296: -- Declare cursors and local variables
297: --
298: l_proc varchar2(72) := g_package||'update_delivery_method';
299: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
300: l_ovn per_person_dlvry_methods.object_version_number%TYPE := p_object_version_number;
301: l_effective_date date;
302: --
303: begin
304: --
500: --
501: -- Declare cursors and local variables
502: --
503: l_proc varchar2(72) := g_package||'delete_delivery_method';
504: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
505: --
506: begin
507: --
508: hr_utility.set_location('Entering:'|| l_proc, 10);