APPS.HR_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREV_JOB_EXTRA_INFO

Line 1914: from per_prev_job_extra_info

1910: -- Cursor for all the records in previous job extra info
1911: cursor csr_pji is
1912: select previous_job_extra_info_id
1913: ,object_version_number
1914: from per_prev_job_extra_info
1915: where previous_job_id = p_previous_job_id;
1916: --
1917: begin
1918: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2102: per_prev_job_extra_info.previous_job_extra_info_id%type;

2098: -- Declare cursors and local variables
2099: --
2100: l_flag varchar2(30);
2101: l_previous_job_extra_info_id
2102: per_prev_job_extra_info.previous_job_extra_info_id%type;
2103: l_object_version_number
2104: per_prev_job_extra_info.object_version_number%type;
2105: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2106: --

Line 2104: per_prev_job_extra_info.object_version_number%type;

2100: l_flag varchar2(30);
2101: l_previous_job_extra_info_id
2102: per_prev_job_extra_info.previous_job_extra_info_id%type;
2103: l_object_version_number
2104: per_prev_job_extra_info.object_version_number%type;
2105: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2106: --
2107: begin
2108: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2457: per_prev_job_extra_info.object_version_number%type

2453: ) is
2454: --
2455: l_proc varchar2(72) := g_package||'update_prev_job_extra_info';
2456: l_object_version_number
2457: per_prev_job_extra_info.object_version_number%type
2458: := p_object_version_number;
2459: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2460: begin
2461: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2459: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;

2455: l_proc varchar2(72) := g_package||'update_prev_job_extra_info';
2456: l_object_version_number
2457: per_prev_job_extra_info.object_version_number%type
2458: := p_object_version_number;
2459: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2460: begin
2461: hr_utility.set_location('Entering:'|| l_proc, 10);
2462: --
2463: -- Issue a savepoint

Line 2745: per_prev_job_extra_info.previous_job_extra_info_id%type;

2741: is
2742: l_proc varchar2(72)
2743: := g_package||'delete_prev_job_extra_info';
2744: l_previous_job_extra_info_id
2745: per_prev_job_extra_info.previous_job_extra_info_id%type;
2746: l_object_version_number
2747: per_prev_job_extra_info.object_version_number%type
2748: := p_object_version_number;
2749: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;

Line 2747: per_prev_job_extra_info.object_version_number%type

2743: := g_package||'delete_prev_job_extra_info';
2744: l_previous_job_extra_info_id
2745: per_prev_job_extra_info.previous_job_extra_info_id%type;
2746: l_object_version_number
2747: per_prev_job_extra_info.object_version_number%type
2748: := p_object_version_number;
2749: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2750: begin
2751: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2749: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;

2745: per_prev_job_extra_info.previous_job_extra_info_id%type;
2746: l_object_version_number
2747: per_prev_job_extra_info.object_version_number%type
2748: := p_object_version_number;
2749: l_ovn per_prev_job_extra_info.object_version_number%type := p_object_version_number;
2750: begin
2751: hr_utility.set_location('Entering:'|| l_proc, 10);
2752: --
2753: -- Issue a savepoint