DBA Data[Home] [Help]

APPS.PER_VAC_BUS dependencies on PER_VAC_BUS

Line 1: Package Body per_vac_bus as

1: Package Body per_vac_bus as
2: /* $Header: pevacrhi.pkb 120.2 2010/12/24 11:51:11 avarri ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_vac_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_vac_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 113: if ( nvl(per_vac_bus.g_vacancy_id, hr_api.g_number)

109: ,p_argument => 'vacancy_id'
110: ,p_argument_value => p_vacancy_id
111: );
112: --
113: if ( nvl(per_vac_bus.g_vacancy_id, hr_api.g_number)
114: = p_vacancy_id) then
115: --
116: -- The legislation code has already been found with a previous
117: -- call to this function. Just return the value in the global

Line 120: l_legislation_code := per_vac_bus.g_legislation_code;

116: -- The legislation code has already been found with a previous
117: -- call to this function. Just return the value in the global
118: -- variable.
119: --
120: l_legislation_code := per_vac_bus.g_legislation_code;
121: hr_utility.set_location(l_proc, 20);
122: else
123: --
124: -- The ID is different to the last call to this function

Line 144: per_vac_bus.g_vacancy_id := p_vacancy_id;

140: -- Set the global variables so the values are
141: -- available for the next call to this function.
142: --
143: close csr_leg_code;
144: per_vac_bus.g_vacancy_id := p_vacancy_id;
145: per_vac_bus.g_legislation_code := l_legislation_code;
146: end if;
147: hr_utility.set_location(' Leaving:'|| l_proc, 40);
148: return l_legislation_code;

Line 145: per_vac_bus.g_legislation_code := l_legislation_code;

141: -- available for the next call to this function.
142: --
143: close csr_leg_code;
144: per_vac_bus.g_vacancy_id := p_vacancy_id;
145: per_vac_bus.g_legislation_code := l_legislation_code;
146: end if;
147: hr_utility.set_location(' Leaving:'|| l_proc, 40);
148: return l_legislation_code;
149: end return_legislation_code;

Line 2401: per_vac_bus.chk_job_id_grade_id

2397: );
2398: --
2399: hr_utility.set_location(l_proc, 140);
2400: --
2401: per_vac_bus.chk_job_id_grade_id
2402: (p_vacancy_id => p_rec.vacancy_id
2403: ,p_job_id => p_rec.job_id
2404: ,p_grade_id => p_rec.grade_id
2405: ,p_effective_date => p_effective_date

Line 2486: per_vac_bus.chk_df(p_rec);

2482:
2483: -- ER#8530112 ends here
2484: hr_utility.set_location(l_proc, 230);
2485: --
2486: per_vac_bus.chk_df(p_rec);
2487: --
2488: hr_utility.set_location(l_proc, 240);
2489: --
2490: p_inv_job_grade_warning:=l_inv_job_grade_warning;

Line 2626: per_vac_bus.chk_job_id_grade_id

2622: );
2623: --
2624: hr_utility.set_location(l_proc, 120);
2625: --
2626: per_vac_bus.chk_job_id_grade_id
2627: (p_vacancy_id => p_rec.vacancy_id
2628: ,p_job_id => p_rec.job_id
2629: ,p_grade_id => p_rec.grade_id
2630: ,p_effective_date => p_effective_date

Line 2719: per_vac_bus.chk_df(p_rec);

2715: CHK_POS_BUDGET_VAL( p_rec.Position_Id,p_effective_date,p_rec.Organization_Id,p_rec.Number_Of_Openings,p_rec.Vacancy_Id);
2716: -- ER#8530112 ends here
2717: hr_utility.set_location(l_proc, 220);
2718: --
2719: per_vac_bus.chk_df(p_rec);
2720: --
2721: p_inv_job_grade_warning:=l_inv_job_grade_warning;
2722: p_inv_pos_grade_warning:=l_inv_pos_grade_warning;
2723: --

Line 2744: end per_vac_bus;

2740: --
2741: hr_utility.set_location(' Leaving:'||l_proc, 10);
2742: End delete_validate;
2743: --
2744: end per_vac_bus;