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_ORG_PRE_DELETE

Line 1: PACKAGE BODY hr_org_pre_delete AS

1: PACKAGE BODY hr_org_pre_delete AS
2: /* $Header: pedelorg.pkb 115.2 99/10/12 23:43:14 porting shi $ */
3: /*
4: ******************************************************************
5: * *

Line 23: Name : hr_org_pre_delete (BODY)

19: * England. *
20: * *
21: ****************************************************************** */
22: /*
23: Name : hr_org_pre_delete (BODY)
24:
25: Description : This package declares procedures required to test for referential
26: integrity errors which could potentially be caused by deleting
27: an organization which relationship rows with other tables.

Line 76: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

72: if p_organization_id = p_business_group_id then
73: begin
74: begin
75: -- Do Any rows Exist in PER_PEOPLE_F.
76: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
77: ,1);
78: select '1'
79: into l_test_func
80: from sys.dual

Line 96: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

92: end;
93: --
94: begin
95: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
96: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
97: ,2);
98: select '1'
99: into l_test_func
100: from sys.dual

Line 117: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

113: end;
114: --
115: begin
116: -- Do Any rows Exist in PER_JOBS.
117: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
118: ,3);
119: select '1'
120: into l_test_func
121: from sys.dual

Line 140: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

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
144: from sys.dual

Line 160: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

156: end;
157: --
158: begin
159: -- Do Any rows Exist in PER_BUDGET_VALUES.
160: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
161: ,5);
162: select '1'
163: into l_test_func
164: from sys.dual

Line 180: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

176: end;
177: --
178: begin
179: -- Do Any rows Exist in PER_RECRUITMENT_ACTIVITIES.
180: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
181: ,6);
182: select '1'
183: into l_test_func
184: from sys.dual

Line 200: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'

196: end;
197: --
198: begin
199: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
200: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
201: ,7);
202: select '1'
203: into l_test_func
204: from sys.dual

Line 226: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',8);

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
230: where exists ( select 1

Line 246: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',9);

242: --
243: --
244: begin
245: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
246: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',9);
247: select '1'
248: into l_test_func
249: from sys.dual
250: where exists ( select 1

Line 265: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',10);

261: end;
262: --
263: begin
264: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
265: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',10);
266: select '1'
267: into l_test_func
268: from sys.dual
269: where exists ( select 1

Line 283: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',11);

279: null;
280: end;
281: --
282: begin
283: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',11);
284: select '1'
285: into l_test_func
286: from sys.dual where exists ( select 1
287: from per_assignments_f x

Line 300: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',12);

296: null;
297: end;
298: --
299: begin
300: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',12);
301: select '1'
302: into l_test_func
303: from sys.dual where exists ( select 1
304: from per_assignments_f x

Line 316: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',13);

312: null;
313: end;
314: --
315: begin
316: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',13);
317: select '1'
318: into l_test_func
319: from sys.dual where exists ( select 1
320: from per_recruitment_activities x

Line 332: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',14);

328: null;
329: end;
330: --
331: begin
332: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',14);
333: select '1'
334: into l_test_func
335: from sys.dual where exists ( select 1
336: from per_vacancies x

Line 348: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',15);

344: null;
345: end;
346: --
347: begin
348: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',15);
349: select '1'
350: into l_test_func
351: from sys.dual where exists ( select 1
352: from per_events x

Line 364: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);

360: null;
361: end;
362: --
363: begin
364: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);
365: select '1'
366: into l_test_func
367: from sys.dual where exists ( select 1
368: from pay_element_links_f x

Line 380: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);

376: null;
377: end;
378: --
379: begin
380: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);
381: select '1'
382: into l_test_func
383: from sys.dual where exists ( select 1
384: from pay_payrolls_f x

Line 396: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',17);

392: null;
393: end;
394: --
395: begin
396: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',17);
397: select '1'
398: into l_test_func
399: from sys.dual where exists ( select 1
400: from pay_wc_funds x

Line 412: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',18);

408: null;
409: end;
410: --
411: begin
412: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',18);
413: select '1'
414: into l_test_func
415: from sys.dual where exists ( select 1
416: from per_budget_elements x

Line 428: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',20);

424: null;
425: end;
426: --
427: begin
428: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',20);
429: select '1'
430: into l_test_func
431: from sys.dual where exists ( select 1
432: from per_security_profiles x

Line 465: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',1);

461: --
462:
463: begin
464: -- Doing check on PAY_ELEMENT_LINKS_F.
465: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',1);
466: select '1'
467: into l_test_func
468: from sys.dual
469: where exists ( select 1

Line 484: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',2);

480: end;
481: --
482: begin
483: -- Doing check on PAY_PAYROLLS_F.
484: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',2);
485: select '1'
486: into l_test_func
487: from sys.dual
488: where exists ( select 1

Line 503: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',3);

499: end;
500: --
501: begin
502: -- Doing check on PER_ASSIGNMENTS_F.
503: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',3);
504: select '1'
505: into l_test_func
506: from sys.dual
507: where exists ( select 1

Line 522: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',4);

518: end;
519: --
520: begin
521: -- Doing check on PER_ASSIGNMENTS_F.
522: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',4);
523: select '1'
524: into l_test_func
525: from sys.dual
526: where exists ( select 1

Line 541: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',5);

537: end;
538: --
539: begin
540: -- Doing check on PER_BUDGET_ELEMENTS.
541: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',5);
542: select '1'
543: into l_test_func
544: from sys.dual
545: where exists ( select 1

Line 560: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',6);

556: end;
557: --
558: begin
559: -- Doing check on PER_EVENTS.
560: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',6);
561: select '1'
562: into l_test_func
563: from sys.dual
564: where exists ( select 1

Line 579: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',7);

575: end;
576: --
577: begin
578: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
579: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',7);
580: select '1'
581: into l_test_func
582: from sys.dual
583: where exists ( select 1

Line 598: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',8);

594: end;
595: --
596: begin
597: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
598: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',8);
599: select '1'
600: into l_test_func
601: from sys.dual
602: where exists ( select 1

Line 620: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',9);

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
624: where exists ( select 1

Line 639: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',10);

635: end;
636: --
637: begin
638: -- Doing check on PER_RECRUITMENT_ACTIVITIES.
639: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',10);
640: select '1'
641: into l_test_func
642: from sys.dual
643: where exists ( select 1

Line 658: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',11);

654: end;
655: --
656: begin
657: -- Doing check on PER_SECURITY_PROFILES.
658: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',11);
659: select '1'
660: into l_test_func
661: from sys.dual
662: where exists ( select 1

Line 677: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',12);

673: end;
674: --
675: begin
676: -- Doing check on PER_VACANCIES.
677: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',12);
678: select '1'
679: into l_test_func
680: from sys.dual
681: where exists ( select 1

Line 696: END hr_org_pre_delete;

692: end;
693: --
694: end hr_strong_bg_chk;
695: --------------------- END: hr_strong_bg_chk -----------------------------------
696: END hr_org_pre_delete;