DBA Data[Home] [Help]

APPS.PER_SOLUTION_SET_API dependencies on PER_SOLUTION_SETS

Line 27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;

23: -- Declare cursors and local variables
24: --
25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin

Line 28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;

24: --
25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;

25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --

Line 153: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;

149: -- Declare cursors and local variables
150: --
151: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION_SET';
152: l_effective_date date;
153: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
154: --
155: begin
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: --