eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ORG_PRE_DELETE dependencies on HR_ALL_POSITIONS_F

Line 137: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked pos. req.

133: end;
134: --
135: begin
136: --
137: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked pos. req.
138: --
139: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
140: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
141: ,4);

Line 139: -- Do Any rows Exist in HR_ALL_POSITIONS_F.

135: begin
136: --
137: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked pos. req.
138: --
139: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
140: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
141: ,4);
142: select '1'
143: into l_test_func

Line 146: from HR_ALL_POSITIONS_F x

142: select '1'
143: into l_test_func
144: from sys.dual
145: where exists ( select 1
146: from HR_ALL_POSITIONS_F x
147: where x.business_group_id = p_business_group_id);
148: --
149: if SQL%ROWCOUNT >0 THEN
150: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');

Line 223: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement

219: --
220: -- Now do all Organization specific checks.
221: begin
222: --
223: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
224: --
225: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
226: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',8);
227: select '1'

Line 225: -- Do Any rows Exist in HR_ALL_POSITIONS_F.

221: begin
222: --
223: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
224: --
225: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
226: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',8);
227: select '1'
228: into l_test_func
229: from sys.dual

Line 231: from HR_ALL_POSITIONS_F x

227: select '1'
228: into l_test_func
229: from sys.dual
230: where exists ( select 1
231: from HR_ALL_POSITIONS_F x
232: where x.organization_id = p_organization_id);
233: --
234: if SQL%ROWCOUNT >0 THEN
235: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');

Line 617: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement

613: end;
614: --
615: begin
616: --
617: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
618: --
619: -- Doing check on HR_ALL_POSITIONS_F.
620: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',9);
621: select '1'

Line 619: -- Doing check on HR_ALL_POSITIONS_F.

615: begin
616: --
617: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
618: --
619: -- Doing check on HR_ALL_POSITIONS_F.
620: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',9);
621: select '1'
622: into l_test_func
623: from sys.dual

Line 625: from HR_ALL_POSITIONS_F x

621: select '1'
622: into l_test_func
623: from sys.dual
624: where exists ( select 1
625: from HR_ALL_POSITIONS_F x
626: where x.ORGANIZATION_ID = p_organization_id);
627: --
628: if SQL%ROWCOUNT >0 THEN
629: hr_utility.set_message(801,'HR_6726_BG_POS_EXIST');