APPS.HR_RETAINED_RIGHTS_API dependencies on PER_CAGR_RETAINED_RIGHTS

Line 28: FROM PER_CAGR_RETAINED_RIGHTS crr

24:
25: -- check if result already has a retained right
26: CURSOR csr_ret_rights IS
27: SELECT null
28: FROM PER_CAGR_RETAINED_RIGHTS crr
29: WHERE crr.cagr_entitlement_result_id = p_cagr_entitlement_result_id;
30:
31: -- fetch result data to create the retained right
32: CURSOR csr_results IS

Line 40: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;

36:
37: l_proc varchar2(72) := g_package||'create_retained_right';
38: l_result csr_results%ROWTYPE;
39: l_dummy varchar2(1);
40: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
41: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
42: l_effective_date date;
43: l_start_date per_cagr_retained_rights.start_date%TYPE;
44: l_end_date per_cagr_retained_rights.end_date%TYPE;

Line 41: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;

37: l_proc varchar2(72) := g_package||'create_retained_right';
38: l_result csr_results%ROWTYPE;
39: l_dummy varchar2(1);
40: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
41: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
42: l_effective_date date;
43: l_start_date per_cagr_retained_rights.start_date%TYPE;
44: l_end_date per_cagr_retained_rights.end_date%TYPE;
45: --

Line 43: l_start_date per_cagr_retained_rights.start_date%TYPE;

39: l_dummy varchar2(1);
40: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
41: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
42: l_effective_date date;
43: l_start_date per_cagr_retained_rights.start_date%TYPE;
44: l_end_date per_cagr_retained_rights.end_date%TYPE;
45: --
46: begin
47: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 44: l_end_date per_cagr_retained_rights.end_date%TYPE;

40: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
41: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
42: l_effective_date date;
43: l_start_date per_cagr_retained_rights.start_date%TYPE;
44: l_end_date per_cagr_retained_rights.end_date%TYPE;
45: --
46: begin
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --

Line 405: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;

401: --
402: -- Declare cursors and local variables
403: --
404: l_proc varchar2(72) := g_package||'update_retained_right';
405: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
406: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
407: l_effective_date date;
408: l_end_date per_cagr_retained_rights.end_date%TYPE;
409: --

Line 406: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;

402: -- Declare cursors and local variables
403: --
404: l_proc varchar2(72) := g_package||'update_retained_right';
405: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
406: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
407: l_effective_date date;
408: l_end_date per_cagr_retained_rights.end_date%TYPE;
409: --
410: begin

Line 408: l_end_date per_cagr_retained_rights.end_date%TYPE;

404: l_proc varchar2(72) := g_package||'update_retained_right';
405: l_cagr_retained_right_id per_cagr_retained_rights.cagr_retained_right_id%TYPE;
406: l_object_version_number per_cagr_retained_rights.object_version_number%TYPE;
407: l_effective_date date;
408: l_end_date per_cagr_retained_rights.end_date%TYPE;
409: --
410: begin
411: hr_utility.set_location('Entering:'|| l_proc, 10);
412: --