DBA Data[Home] [Help]

APPS.PER_SOLUTION_API dependencies on PER_SOLUTIONS

Line 30: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_proc varchar2(72) := g_package||'CREATE_SOLUTION';
29: l_effective_date date;
30: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;
31: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;
32: --
33: begin
34: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 31: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;

27: --
28: l_proc varchar2(72) := g_package||'CREATE_SOLUTION';
29: l_effective_date date;
30: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;
31: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;
32: --
33: begin
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --

Line 161: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;

157: -- Declare cursors and local variables
158: --
159: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION';
160: l_effective_date date;
161: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;
162: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;
163: --
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 162: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;

158: --
159: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION';
160: l_effective_date date;
161: l_solution_id PER_SOLUTIONS.SOLUTION_ID%TYPE;
162: l_object_version_number PER_SOLUTIONS.OBJECT_VERSION_NUMBER%TYPE;
163: --
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 10);
166: --