128: --
129: -- Declare cursors and local variables
130: --
131: l_proc varchar2(72) := g_package||'create_work_incident';
132: l_incident_id per_work_incidents.incident_id%TYPE;
133: l_object_version_number per_work_incidents.object_version_number%TYPE;
134: l_effective_date date;
135: l_incident_date per_work_incidents.incident_date%TYPE;
136: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
129: -- Declare cursors and local variables
130: --
131: l_proc varchar2(72) := g_package||'create_work_incident';
132: l_incident_id per_work_incidents.incident_id%TYPE;
133: l_object_version_number per_work_incidents.object_version_number%TYPE;
134: l_effective_date date;
135: l_incident_date per_work_incidents.incident_date%TYPE;
136: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
137: --
131: l_proc varchar2(72) := g_package||'create_work_incident';
132: l_incident_id per_work_incidents.incident_id%TYPE;
133: l_object_version_number per_work_incidents.object_version_number%TYPE;
134: l_effective_date date;
135: l_incident_date per_work_incidents.incident_date%TYPE;
136: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
137: --
138: begin
139: hr_utility.set_location('Entering:'|| l_proc, 10);
132: l_incident_id per_work_incidents.incident_id%TYPE;
133: l_object_version_number per_work_incidents.object_version_number%TYPE;
134: l_effective_date date;
135: l_incident_date per_work_incidents.incident_date%TYPE;
136: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
137: --
138: begin
139: hr_utility.set_location('Entering:'|| l_proc, 10);
140: --
682: --
683: -- Declare cursors and local variables
684: --
685: l_proc varchar2(72) := g_package||'update_work_incident';
686: l_incident_id per_work_incidents.incident_id%TYPE;
687: l_object_version_number per_work_incidents.object_version_number%TYPE;
688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;
689: l_effective_date date;
690: l_incident_date per_work_incidents.incident_date%TYPE;
683: -- Declare cursors and local variables
684: --
685: l_proc varchar2(72) := g_package||'update_work_incident';
686: l_incident_id per_work_incidents.incident_id%TYPE;
687: l_object_version_number per_work_incidents.object_version_number%TYPE;
688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;
689: l_effective_date date;
690: l_incident_date per_work_incidents.incident_date%TYPE;
691: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
684: --
685: l_proc varchar2(72) := g_package||'update_work_incident';
686: l_incident_id per_work_incidents.incident_id%TYPE;
687: l_object_version_number per_work_incidents.object_version_number%TYPE;
688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;
689: l_effective_date date;
690: l_incident_date per_work_incidents.incident_date%TYPE;
691: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
692: --
686: l_incident_id per_work_incidents.incident_id%TYPE;
687: l_object_version_number per_work_incidents.object_version_number%TYPE;
688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;
689: l_effective_date date;
690: l_incident_date per_work_incidents.incident_date%TYPE;
691: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
692: --
693: begin
694: hr_utility.set_location('Entering:'|| l_proc, 10);
687: l_object_version_number per_work_incidents.object_version_number%TYPE;
688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;
689: l_effective_date date;
690: l_incident_date per_work_incidents.incident_date%TYPE;
691: l_org_notified_date per_work_incidents.org_notified_date%TYPE;
692: --
693: begin
694: hr_utility.set_location('Entering:'|| l_proc, 10);
695: --