DBA Data[Home] [Help]

APPS.HR_CAGR_PARAMETER_API dependencies on PER_CAGR_API_PARAMETERS

Line 31: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;

27: --
28: -- Declare cursors and local variables
29: --
30: l_proc varchar2(72) := g_package||'create_cagr_parameter';
31: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
32: l_cagr_api_param_id per_cagr_api_parameters.object_version_number%TYPE;
33: l_effective_date DATE;
34: --
35: begin

Line 32: l_cagr_api_param_id per_cagr_api_parameters.object_version_number%TYPE;

28: -- Declare cursors and local variables
29: --
30: l_proc varchar2(72) := g_package||'create_cagr_parameter';
31: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
32: l_cagr_api_param_id per_cagr_api_parameters.object_version_number%TYPE;
33: l_effective_date DATE;
34: --
35: begin
36: --

Line 137: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;

133: --
134: -- Declare cursors and local variables
135: --
136: l_proc varchar2(72) := g_package||'update_cagr_parameter';
137: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
138: l_effective_date DATE;
139: l_temp_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
140: --
141: begin

Line 139: l_temp_object_version_number per_cagr_api_parameters.object_version_number%TYPE;

135: --
136: l_proc varchar2(72) := g_package||'update_cagr_parameter';
137: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
138: l_effective_date DATE;
139: l_temp_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
140: --
141: begin
142: --
143: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 232: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;

228: --
229: -- Declare cursors and local variables
230: --
231: l_proc varchar2(72) := g_package||'update_cagr_parameter';
232: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
233: --
234: begin
235: --
236: hr_utility.set_location('Entering:'|| l_proc, 10);