DBA Data[Home] [Help]

APPS.PER_WORK_INCIDENT_API dependencies on PER_WORK_INCIDENTS

Line 132: l_incident_id per_work_incidents.incident_id%TYPE;

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;

Line 133: l_object_version_number per_work_incidents.object_version_number%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: --

Line 135: l_incident_date per_work_incidents.incident_date%TYPE;

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);

Line 136: l_org_notified_date per_work_incidents.org_notified_date%TYPE;

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: --

Line 686: l_incident_id per_work_incidents.incident_id%TYPE;

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;

Line 687: l_object_version_number per_work_incidents.object_version_number%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;

Line 688: l_ovn per_work_incidents.object_version_number%TYPE := p_object_version_number;

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: --

Line 690: l_incident_date per_work_incidents.incident_date%TYPE;

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);

Line 691: l_org_notified_date per_work_incidents.org_notified_date%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);
695: --