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 DUAL

Line 80: from sys.dual

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
81: where exists ( select 1
82: from PER_PEOPLE_F x
83: where x.business_group_id = p_business_group_id);
84: --

Line 100: from sys.dual

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
101: where exists ( select 1
102: from HR_ORGANIZATION_UNITS x
103: where x.business_group_id = p_business_group_id
104: and x.organization_id <> p_business_group_id);

Line 121: from sys.dual

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
122: where exists ( select 1
123: from PER_JOBS x
124: where x.business_group_id = p_business_group_id);
125: --

Line 144: from sys.dual

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
145: where exists ( select 1
146: from HR_ALL_POSITIONS_F x
147: where x.business_group_id = p_business_group_id);
148: --

Line 164: from sys.dual

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
165: where exists ( select 1
166: from PER_BUDGET_VALUES x
167: where x.business_group_id = p_business_group_id);
168: --

Line 184: from sys.dual

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
185: where exists ( select 1
186: from PER_RECRUITMENT_ACTIVITIES x
187: where x.business_group_id = p_business_group_id);
188: --

Line 204: from sys.dual

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
205: where exists ( select 1
206: from PER_ORG_STRUCTURE_ELEMENTS x
207: where x.business_group_id = p_business_group_id);
208: --

Line 229: from sys.dual

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
231: from HR_ALL_POSITIONS_F x
232: where x.organization_id = p_organization_id);
233: --

Line 249: from sys.dual

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
251: from PER_ORG_STRUCTURE_ELEMENTS x
252: where x.organization_id_child = p_organization_id);
253: --

Line 268: from sys.dual

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
270: from PER_ORG_STRUCTURE_ELEMENTS x
271: where x.organization_id_parent = p_organization_id);
272: --

Line 286: from sys.dual where exists ( select 1

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
288: where x.source_organization_id = p_organization_id);
289: if SQL%ROWCOUNT >0 THEN
290: hr_utility.set_message(801,'HR_7333_ORG_ASSIGNMENTS_EXIST');

Line 303: from sys.dual where exists ( select 1

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
305: where x.organization_id = p_organization_id);
306: if SQL%ROWCOUNT >0 THEN
307: hr_utility.set_message(801,'HR_7333_ORG_ASSIGNMENTS_EXIST');

Line 319: from sys.dual where exists ( select 1

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
321: where x.run_by_organization_id = p_organization_id);
322: if SQL%ROWCOUNT >0 THEN
323: hr_utility.set_message(801,'HR_7336_ORG_REC_ACT_EXIST');

Line 335: from sys.dual where exists ( select 1

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
337: where x.organization_id = p_organization_id);
338: if SQL%ROWCOUNT >0 THEN
339: hr_utility.set_message(801,'HR_7337_ORG_VACANCIES');

Line 351: from sys.dual where exists ( select 1

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
353: where x.organization_run_by_id = p_organization_id);
354: if SQL%ROWCOUNT >0 THEN
355: hr_utility.set_message(801,'HR_7334_ORG_EVENTS_EXIST');

Line 367: from sys.dual where exists ( select 1

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
369: where x.organization_id = p_organization_id);
370: if SQL%ROWCOUNT >0 THEN
371: hr_utility.set_message(801,'HR_7330_ORG_LINKS_EXIST');

Line 383: from sys.dual where exists ( select 1

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
385: where x.organization_id = p_organization_id);
386: if SQL%ROWCOUNT >0 THEN
387: hr_utility.set_message(801,'HR_7331_ORG_PAYROLLS_EXIST');

Line 399: from sys.dual where exists ( select 1

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
401: where x.carrier_id = p_organization_id);
402: if SQL%ROWCOUNT >0 THEN
403: hr_utility.set_message(801,'HR_7332_WC_FUNDS_EXIST');

Line 415: from sys.dual where exists ( select 1

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
417: where x.organization_id = p_organization_id);
418: if SQL%ROWCOUNT >0 THEN
419: hr_utility.set_message(801,'HR_7335_ORG_BUDGET_ELEMENTS');

Line 431: from sys.dual where exists ( select 1

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
433: where x.organization_id = p_organization_id);
434: if SQL%ROWCOUNT >0 THEN
435: hr_utility.set_message(801,'HR_7339_ORG_SEC_PROFILE');

Line 468: from sys.dual

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
470: from PAY_ELEMENT_LINKS_F x
471: where x.ORGANIZATION_ID = p_organization_id);
472: --

Line 487: from sys.dual

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
489: from PAY_PAYROLLS_F x
490: where x.ORGANIZATION_ID = p_organization_id);
491: --

Line 506: from sys.dual

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
508: from PER_ASSIGNMENTS_F x
509: where x.SOURCE_ORGANIZATION_ID = p_organization_id);
510: --

Line 525: from sys.dual

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
527: from PER_ASSIGNMENTS_F x
528: where x.ORGANIZATION_ID = p_organization_id);
529: --

Line 544: from sys.dual

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
546: from PER_BUDGET_ELEMENTS x
547: where x.ORGANIZATION_ID = p_organization_id);
548: --

Line 563: from sys.dual

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
565: from PER_EVENTS x
566: where x.ORGANIZATION_RUN_BY_ID = p_organization_id);
567: --

Line 582: from sys.dual

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
584: from PER_ORG_STRUCTURE_ELEMENTS x
585: where x.ORGANIZATION_ID_PARENT = p_organization_id);
586: --

Line 601: from sys.dual

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
603: from PER_ORG_STRUCTURE_ELEMENTS x
604: where x.ORGANIZATION_ID_CHILD = p_organization_id);
605: --

Line 623: from sys.dual

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
625: from HR_ALL_POSITIONS_F x
626: where x.ORGANIZATION_ID = p_organization_id);
627: --

Line 642: from sys.dual

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
644: from PER_RECRUITMENT_ACTIVITIES x
645: where x.RUN_BY_ORGANIZATION_ID = p_organization_id);
646: --

Line 661: from sys.dual

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
663: from PER_SECURITY_PROFILES x
664: where x.ORGANIZATION_ID = p_organization_id);
665: --

Line 680: from sys.dual

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
682: from PER_VACANCIES x
683: where x.ORGANIZATION_ID = p_organization_id);
684: --