[Home] [Help]
1: PACKAGE BODY hr_job_pos AS
2: /* $Header: pejapdel.pkb 120.0 2005/05/31 10:32:28 appldev noship $ */
3: /*
4: ******************************************************************
5: * *
20: * *
21: ******************************************************************
22: ==================================================================
23:
24: Name : hr_job_pos (BODY)
25:
26: Description : Contains the definition of job and position procedures
27: as declared in the hr_job_pos package header
28:
23:
24: Name : hr_job_pos (BODY)
25:
26: Description : Contains the definition of job and position procedures
27: as declared in the hr_job_pos package header
28:
29: Uses : hr_utility
30:
31: Change List
69: --
70: if p_business_group_id = p_organization_id then
71: begin
72: -- Do Any rows Exist in PER_JOBS.
73: hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);
74: select '1'
75: into l_test_func
76: from sys.dual
77: where exists ( select 1
92: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
93: --
94: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
95: --
96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);
97: select '1'
98: into l_test_func
99: from sys.dual
100: where exists ( select 1
133: begin
134: -- Doing check on HR_ALL_POSITIONS_F.
135: --
136: -- Changed 02-Oct-99 SCNair (per_positions to HR_ALL_POSITIONS_F) Date tracked position requirement
137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);
138: select '1'
139: into l_test_func
140: from sys.dual
141: where exists ( select 1
153: --
154: end hr_pos_bg_chk;
155: ------------------------- END: hr_pos_bg_chk -------------------
156: --
157: end hr_job_pos;