DBA Data[Home] [Help]

APPS.PER_SOLUTION_CMPT_NAME_API dependencies on PER_SOLUTION_CMPT_NAMES

Line 48: l_solution_id PER_SOLUTION_CMPT_NAMES.SOLUTION_ID%TYPE;

44: -- Declare cursors and local variables
45: --
46: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_CMPT_NAME';
47: l_effective_date date;
48: l_solution_id PER_SOLUTION_CMPT_NAMES.SOLUTION_ID%TYPE;
49: l_component_name PER_SOLUTION_CMPT_NAMES.COMPONENT_NAME%TYPE;
50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;
51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
52: --

Line 49: l_component_name PER_SOLUTION_CMPT_NAMES.COMPONENT_NAME%TYPE;

45: --
46: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_CMPT_NAME';
47: l_effective_date date;
48: l_solution_id PER_SOLUTION_CMPT_NAMES.SOLUTION_ID%TYPE;
49: l_component_name PER_SOLUTION_CMPT_NAMES.COMPONENT_NAME%TYPE;
50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;
51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
52: --
53: begin

Line 50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;

46: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_CMPT_NAME';
47: l_effective_date date;
48: l_solution_id PER_SOLUTION_CMPT_NAMES.SOLUTION_ID%TYPE;
49: l_component_name PER_SOLUTION_CMPT_NAMES.COMPONENT_NAME%TYPE;
50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;
51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;

47: l_effective_date date;
48: l_solution_id PER_SOLUTION_CMPT_NAMES.SOLUTION_ID%TYPE;
49: l_component_name PER_SOLUTION_CMPT_NAMES.COMPONENT_NAME%TYPE;
50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;
51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --

Line 167: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;

163: -- Declare cursors and local variables
164: --
165: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION_CMPT_NAME';
166: l_effective_date date;
167: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
168: --
169: begin
170: hr_utility.set_location('Entering:'|| l_proc, 10);
171: --