[Home] [Help]
375: PROCEDURE delete_mag_structure(p_business_group_id NUMBER)
376: IS
377: begin
378: --
379: hr_utility.set_location('hr_delete.delete_mag_structure',1);
380: DELETE FROM pay_magnetic_records mr
381: WHERE EXISTS ( SELECT ''
382: FROM ff_formulas_f ff
383: WHERE ff.formula_id = mr.formula_id
409: where bl.batch_id = p_batch;
410: --
411: begin
412: --
413: hr_utility.set_location('hr_delete.delete_bal_load_struct',10);
414: --
415: OPEN get_bg ;
416: FETCH get_bg INTO l_business_group_name ;
417: CLOSE get_bg ;
415: OPEN get_bg ;
416: FETCH get_bg INTO l_business_group_name ;
417: CLOSE get_bg ;
418: --
419: hr_utility.set_location('hr_delete.delete_bal_load_struct',20);
420: --
421: FOR pbhrec IN pbh LOOP
422: if (pbhrec.batch_status in ('E', 'P', 'V')) then
423: hr_utility.set_location('hr_delete.delete_bal_load_struct',30);
419: hr_utility.set_location('hr_delete.delete_bal_load_struct',20);
420: --
421: FOR pbhrec IN pbh LOOP
422: if (pbhrec.batch_status in ('E', 'P', 'V')) then
423: hr_utility.set_location('hr_delete.delete_bal_load_struct',30);
424: FOR pblrec IN pbl (pbhrec.batch_id) LOOP
425: DELETE FROM pay_message_lines
426: WHERE source_id = pblrec.batch_line_id
427: AND source_type = 'L';
437: DELETE FROM pay_balance_batch_headers bh
438: WHERE bh.batch_id = pbhrec.batch_id;
439: END LOOP;
440: --
441: hr_utility.set_location('hr_delete.delete_bal_load_struct',99);
442: --
443: end delete_bal_load_struct;
444: --
445: PROCEDURE delete_formula_direct(p_business_group_id NUMBER)
454: FROM ff_formulas_f
455: WHERE business_group_id = c_business_group_id;
456: --
457: begin
458: hr_utility.set_location('Entering: '||l_proc,10);
459: --
460: -- Check if a formulas exist for the business group
461: --
462: for form in csr_get_bg_formulas(p_business_group_id) loop
462: for form in csr_get_bg_formulas(p_business_group_id) loop
463: --
464: DELETE FROM ff_compiled_info_f ci
465: WHERE ci.formula_id = form.formula_id;
466: hr_utility.set_location(l_proc,20);
467: --
468: DELETE FROM ff_fdi_usages_f fdi
469: WHERE fdi.formula_id = form.formula_id;
470: hr_utility.set_location(l_proc,30);
466: hr_utility.set_location(l_proc,20);
467: --
468: DELETE FROM ff_fdi_usages_f fdi
469: WHERE fdi.formula_id = form.formula_id;
470: hr_utility.set_location(l_proc,30);
471: --
472: DELETE FROM ff_formulas_f ff
473: WHERE ff.formula_id = form.formula_id;
474: hr_utility.set_location(l_proc,40);
470: hr_utility.set_location(l_proc,30);
471: --
472: DELETE FROM ff_formulas_f ff
473: WHERE ff.formula_id = form.formula_id;
474: hr_utility.set_location(l_proc,40);
475: --
476: end loop;
477: --
478: hr_utility.set_location('Leaving: '||l_proc,100);
474: hr_utility.set_location(l_proc,40);
475: --
476: end loop;
477: --
478: hr_utility.set_location('Leaving: '||l_proc,100);
479: end delete_formula_direct;
480: --
481: PROCEDURE delete_database_items(p_business_group_id NUMBER)
482: IS
492: FROM ff_user_entities
493: WHERE business_group_id = c_business_group_id;
494: --
495: begin
496: hr_utility.set_location('Entering: '||l_proc, 10);
497: --
498: -- Check if a user entities exist for the business group
499: --
500: open csr_get_ff_user_ents(p_business_group_id);
502: if csr_get_ff_user_ents%found then
503: --
504: DELETE FROM ff_user_entities
505: WHERE business_group_id = p_business_group_id;
506: hr_utility.set_location(l_proc, 20);
507: --
508: end if;
509: close csr_get_ff_user_ents;
510: hr_utility.set_location('Leaving: '||l_proc, 30);
506: hr_utility.set_location(l_proc, 20);
507: --
508: end if;
509: close csr_get_ff_user_ents;
510: hr_utility.set_location('Leaving: '||l_proc, 30);
511: --
512: end delete_database_items;
513: --
514: PROCEDURE delete_assign_low_detail(p_business_group_id NUMBER)
514: PROCEDURE delete_assign_low_detail(p_business_group_id NUMBER)
515: IS
516: begin
517: --
518: hr_utility.set_location('hr_delete.delete_assign_low_detail',1);
519: DELETE FROM pay_coin_anal_elements cae
520: WHERE EXISTS (SELECT ''
521: FROM pay_pre_payments ppp
522: WHERE ppp.pre_payment_id
534: )
535: )
536: );
537: --
538: hr_utility.set_location('hr_delete.delete_assign_low_detail',3);
539: DELETE FROM pay_monetary_units_tl montl
540: WHERE EXISTS ( SELECT ''
541: FROM pay_monetary_units mon
542: WHERE montl.monetary_unit_id = mon.monetary_unit_id
545: --
546: DELETE FROM pay_monetary_units mon
547: WHERE mon.business_group_id = p_business_group_id;
548: --
549: hr_utility.set_location('hr_delete.delete_assign_low_detail',5);
550: DELETE FROM pay_process_events ppe
551: WHERE EXISTS (SELECT ''
552: FROM per_assignments_f pa
553: WHERE pa.assignment_id = ppe.assignment_id
572: where pel.business_group_id = p_business_group_id
573: and pee.element_link_id = pel.element_link_id;
574: --
575: begin
576: hr_utility.set_location('Entering: '||l_proc, 10);
577: --
578: -- This performed here because we have to cope with
579: -- the rollback rules that prevent rolling back
580: -- single assignment actions for various action types.
650: --
651: py_rollback_pkg.rollback_payroll_action(c1rec.payroll_action_id);
652: end loop;
653: end;
654: hr_utility.set_location(l_proc, 30);
655: --
656: -- Delete entries and entry values.
657: --
658: for cevrec in cev loop
664: --
665: delete from pay_element_entries_f pee
666: where pee.element_entry_id = cevrec.element_entry_id;
667: end loop;
668: hr_utility.set_location('Leaving: '||l_proc, 90);
669: --
670: end delete_assign_detail;
671: --
672: --
809: -- Changed all following cursors to use exists and for assignments
810: -- to use the base table
811: --
812: begin
813: hr_utility.set_location('Entering: '||l_proc,10);
814: --
815: -- Check if letter types exist for the
816: -- business group
817: --
820: if csr_get_ltp%found then
821: --
822: DELETE FROM per_letter_request_lines
823: WHERE business_group_id = p_business_group_id;
824: hr_utility.set_location(l_proc,20);
825: --
826: DELETE per_letter_requests
827: WHERE business_group_id = p_business_group_id;
828: hr_utility.set_location(l_proc,30);
824: hr_utility.set_location(l_proc,20);
825: --
826: DELETE per_letter_requests
827: WHERE business_group_id = p_business_group_id;
828: hr_utility.set_location(l_proc,30);
829: --
830: DELETE per_letter_gen_statuses
831: WHERE business_group_id = p_business_group_id;
832: hr_utility.set_location(l_proc,40);
828: hr_utility.set_location(l_proc,30);
829: --
830: DELETE per_letter_gen_statuses
831: WHERE business_group_id = p_business_group_id;
832: hr_utility.set_location(l_proc,40);
833: --
834: DELETE per_letter_types
835: WHERE business_group_id = p_business_group_id;
836: hr_utility.set_location(l_proc,50);
832: hr_utility.set_location(l_proc,40);
833: --
834: DELETE per_letter_types
835: WHERE business_group_id = p_business_group_id;
836: hr_utility.set_location(l_proc,50);
837: --
838: end if;
839: close csr_get_ltp;
840: hr_utility.set_location(l_proc,60);
836: hr_utility.set_location(l_proc,50);
837: --
838: end if;
839: close csr_get_ltp;
840: hr_utility.set_location(l_proc,60);
841: --
842: -- Check if pay proposals exist for the
843: -- business group
844: --
847: if csr_get_pyp%found then
848: --
849: delete from per_pay_proposal_components ppc
850: where ppc.business_group_id = p_business_group_id;
851: hr_utility.set_location(l_proc, 70);
852: --
853: delete from per_pay_proposals
854: where business_group_id = p_business_group_id;
855: hr_utility.set_location(l_proc, 80);
851: hr_utility.set_location(l_proc, 70);
852: --
853: delete from per_pay_proposals
854: where business_group_id = p_business_group_id;
855: hr_utility.set_location(l_proc, 80);
856: --
857: end if;
858: close csr_get_pyp;
859: hr_utility.set_location(l_proc,90);
855: hr_utility.set_location(l_proc, 80);
856: --
857: end if;
858: close csr_get_pyp;
859: hr_utility.set_location(l_proc,90);
860: --
861: -- Check if an event exists for the business group.
862: --
863: open csr_get_evt(p_business_group_id);
865: if csr_get_evt%found then
866: --
867: DELETE FROM per_bookings pb
868: WHERE pb.business_group_id = p_business_group_id;
869: hr_utility.set_location(l_proc,100);
870: --
871: DELETE FROM per_events
872: WHERE business_group_id = p_business_group_id;
873: hr_utility.set_location(l_proc,110);
869: hr_utility.set_location(l_proc,100);
870: --
871: DELETE FROM per_events
872: WHERE business_group_id = p_business_group_id;
873: hr_utility.set_location(l_proc,110);
874: --
875: end if;
876: close csr_get_evt;
877: hr_utility.set_location(l_proc,120);
873: hr_utility.set_location(l_proc,110);
874: --
875: end if;
876: close csr_get_evt;
877: hr_utility.set_location(l_proc,120);
878: --
879: -- Check if a budget exists for the
880: -- business group
881: --
884: if csr_get_bud%found then
885: --
886: DELETE FROM per_assignment_budget_values_f abv
887: WHERE abv.business_group_id = p_business_group_id;
888: hr_utility.set_location(l_proc, 130);
889: --
890: DELETE FROM per_budget_values
891: WHERE business_group_id = p_business_group_id;
892: hr_utility.set_location(l_proc,140);
888: hr_utility.set_location(l_proc, 130);
889: --
890: DELETE FROM per_budget_values
891: WHERE business_group_id = p_business_group_id;
892: hr_utility.set_location(l_proc,140);
893: --
894: DELETE FROM per_budget_values
895: WHERE business_group_id = p_business_group_id;
896: hr_utility.set_location(l_proc,150);
892: hr_utility.set_location(l_proc,140);
893: --
894: DELETE FROM per_budget_values
895: WHERE business_group_id = p_business_group_id;
896: hr_utility.set_location(l_proc,150);
897: --
898: DELETE FROM per_budget_elements
899: WHERE business_group_id = p_business_group_id;
900: hr_utility.set_location(l_proc,160);
896: hr_utility.set_location(l_proc,150);
897: --
898: DELETE FROM per_budget_elements
899: WHERE business_group_id = p_business_group_id;
900: hr_utility.set_location(l_proc,160);
901: --
902: DELETE FROM per_budget_versions
903: WHERE business_group_id = p_business_group_id;
904: hr_utility.set_location(l_proc,170);
900: hr_utility.set_location(l_proc,160);
901: --
902: DELETE FROM per_budget_versions
903: WHERE business_group_id = p_business_group_id;
904: hr_utility.set_location(l_proc,170);
905: --
906: DELETE FROM per_budgets
907: WHERE business_group_id = p_business_group_id;
908: hr_utility.set_location(l_proc,180);
904: hr_utility.set_location(l_proc,170);
905: --
906: DELETE FROM per_budgets
907: WHERE business_group_id = p_business_group_id;
908: hr_utility.set_location(l_proc,180);
909: --
910: end if;
911: close csr_get_bud;
912: hr_utility.set_location(l_proc,190);
908: hr_utility.set_location(l_proc,180);
909: --
910: end if;
911: close csr_get_bud;
912: hr_utility.set_location(l_proc,190);
913: --
914: -- Check if an assignment exists for the business group
915: --
916: open csr_get_asg (p_business_group_id);
936: AND pa.business_group_id = p_business_group_id);
937: --
938: DELETE FROM pay_personal_payment_methods_f ppm
939: WHERE ppm.business_group_id = p_business_group_id;
940: hr_utility.set_location(l_proc, 200);
941: --
942: DELETE FROM pay_cost_allocations_f ca
943: WHERE ca.business_group_id = p_business_group_id;
944: hr_utility.set_location(l_proc, 210);
940: hr_utility.set_location(l_proc, 200);
941: --
942: DELETE FROM pay_cost_allocations_f ca
943: WHERE ca.business_group_id = p_business_group_id;
944: hr_utility.set_location(l_proc, 210);
945: --
946: DELETE FROM per_assignment_extra_info aei
947: WHERE
948: EXISTS
949: (SELECT ''
950: FROM per_assignments_f pa
951: WHERE pa.assignment_id = aei.assignment_id
952: AND pa.business_group_id = p_business_group_id);
953: hr_utility.set_location(l_proc, 220);
954: --
955: DELETE FROM per_quickpaint_result_text qrt
956: WHERE
957: EXISTS
958: (SELECT ''
959: FROM per_assignments_f pa
960: WHERE pa.assignment_id = qrt.assignment_id
961: AND pa.business_group_id = p_business_group_id);
962: hr_utility.set_location(l_proc,230);
963: --
964: DELETE FROM pay_assignment_link_usages alu
965: WHERE EXISTS ( SELECT ''
966: FROM per_assignments_f pa
965: WHERE EXISTS ( SELECT ''
966: FROM per_assignments_f pa
967: WHERE pa.assignment_id = alu.assignment_id
968: AND pa.business_group_id = p_business_group_id);
969: hr_utility.set_location(l_proc,235);
970: --
971: DELETE FROM hr_assignment_set_amendments asa
972: WHERE EXISTS ( SELECT ''
973: FROM per_assignments_f pa
972: WHERE EXISTS ( SELECT ''
973: FROM per_assignments_f pa
974: WHERE pa.assignment_id = asa.assignment_id
975: AND pa.business_group_id = p_business_group_id);
976: hr_utility.set_location('Leaving: '||l_proc,237);
977: --
978: DELETE FROM per_spinal_point_placements_f
979: WHERE business_group_id = p_business_group_id;
980: hr_utility.set_location(l_proc, 240);
976: hr_utility.set_location('Leaving: '||l_proc,237);
977: --
978: DELETE FROM per_spinal_point_placements_f
979: WHERE business_group_id = p_business_group_id;
980: hr_utility.set_location(l_proc, 240);
981: --
982: DELETE FROM per_secondary_ass_statuses
983: WHERE business_group_id = p_business_group_id;
984: hr_utility.set_location(l_proc, 250);
980: hr_utility.set_location(l_proc, 240);
981: --
982: DELETE FROM per_secondary_ass_statuses
983: WHERE business_group_id = p_business_group_id;
984: hr_utility.set_location(l_proc, 250);
985: --
986: -- WWBUG 1833930. Changed to use base table per_all_assignments_f
987: --
988: DELETE FROM per_all_assignments_f
986: -- WWBUG 1833930. Changed to use base table per_all_assignments_f
987: --
988: DELETE FROM per_all_assignments_f
989: WHERE business_group_id = p_business_group_id;
990: hr_utility.set_location(l_proc, 260);
991: --
992: end if;
993: close csr_get_asg;
994: hr_utility.set_location(l_proc, 270);
990: hr_utility.set_location(l_proc, 260);
991: --
992: end if;
993: close csr_get_asg;
994: hr_utility.set_location(l_proc, 270);
995: --
996: DELETE FROM per_pay_bases
997: WHERE business_group_id = p_business_group_id;
998: hr_utility.set_location(l_proc,160);
994: hr_utility.set_location(l_proc, 270);
995: --
996: DELETE FROM per_pay_bases
997: WHERE business_group_id = p_business_group_id;
998: hr_utility.set_location(l_proc,160);
999: --
1000: -- Check if career paths exist for the business group
1001: --
1002: open csr_get_crp (p_business_group_id);
1004: if csr_get_crp%found then
1005: --
1006: DELETE FROM per_career_path_elements
1007: WHERE business_group_id = p_business_group_id;
1008: hr_utility.set_location(l_proc,60);
1009: --
1010: DELETE FROM per_career_paths
1011: WHERE business_group_id = p_business_group_id;
1012: hr_utility.set_location(l_proc,70);
1008: hr_utility.set_location(l_proc,60);
1009: --
1010: DELETE FROM per_career_paths
1011: WHERE business_group_id = p_business_group_id;
1012: hr_utility.set_location(l_proc,70);
1013: --
1014: end if;
1015: close csr_get_crp;
1016: hr_utility.set_location(l_proc,70);
1012: hr_utility.set_location(l_proc,70);
1013: --
1014: end if;
1015: close csr_get_crp;
1016: hr_utility.set_location(l_proc,70);
1017: --
1018: -- Check if an assignment status type exists for the
1019: -- business group
1020: --
1023: if csr_get_ast%found then
1024: --
1025: DELETE PER_ASS_STATUS_TYPE_AMENDS
1026: WHERE business_group_id = p_business_group_id;
1027: hr_utility.set_location(l_proc,150);
1028: --
1029: DELETE per_assignment_status_types
1030: WHERE business_group_id = p_business_group_id;
1031: hr_utility.set_location(l_proc,160);
1027: hr_utility.set_location(l_proc,150);
1028: --
1029: DELETE per_assignment_status_types
1030: WHERE business_group_id = p_business_group_id;
1031: hr_utility.set_location(l_proc,160);
1032: --
1033: end if;
1034: close csr_get_ast;
1035: hr_utility.set_location(l_proc,170);
1031: hr_utility.set_location(l_proc,160);
1032: --
1033: end if;
1034: close csr_get_ast;
1035: hr_utility.set_location(l_proc,170);
1036: --
1037: -- Check if a recruitment activity exists for the
1038: -- business group
1039: --
1042: if csr_get_rca%found then
1043: --
1044: DELETE FROM per_recruitment_activity_for
1045: WHERE business_group_id = p_business_group_id;
1046: hr_utility.set_location(l_proc,280);
1047: --
1048: DELETE FROM per_recruitment_activities
1049: WHERE business_group_id = p_business_group_id;
1050: hr_utility.set_location(l_proc,290);
1046: hr_utility.set_location(l_proc,280);
1047: --
1048: DELETE FROM per_recruitment_activities
1049: WHERE business_group_id = p_business_group_id;
1050: hr_utility.set_location(l_proc,290);
1051: --
1052: end if;
1053: close csr_get_rca;
1054: hr_utility.set_location(l_proc,300);
1050: hr_utility.set_location(l_proc,290);
1051: --
1052: end if;
1053: close csr_get_rca;
1054: hr_utility.set_location(l_proc,300);
1055: --
1056: -- Check if a requisition exists for the
1057: -- business group
1058: --
1061: if csr_get_req%found then
1062: --
1063: DELETE FROM per_vacancies vac
1064: WHERE vac.business_group_id = p_business_group_id;
1065: hr_utility.set_location(l_proc,310);
1066: --
1067: DELETE FROM per_requisitions pr
1068: WHERE pr.business_group_id = p_business_group_id;
1069: hr_utility.set_location(l_proc,320);
1065: hr_utility.set_location(l_proc,310);
1066: --
1067: DELETE FROM per_requisitions pr
1068: WHERE pr.business_group_id = p_business_group_id;
1069: hr_utility.set_location(l_proc,320);
1070: --
1071: end if;
1072: close csr_get_req;
1073: hr_utility.set_location(l_proc,330);
1069: hr_utility.set_location(l_proc,320);
1070: --
1071: end if;
1072: close csr_get_req;
1073: hr_utility.set_location(l_proc,330);
1074: --
1075: DELETE FROM pay_org_payment_methods_f
1076: WHERE business_group_id = p_business_group_id;
1077: hr_utility.set_location(l_proc,340);
1073: hr_utility.set_location(l_proc,330);
1074: --
1075: DELETE FROM pay_org_payment_methods_f
1076: WHERE business_group_id = p_business_group_id;
1077: hr_utility.set_location(l_proc,340);
1078: --
1079: end delete_assign_direct;
1080: --
1081: --
1100: FROM per_parent_spines
1101: WHERE business_group_id = c_business_group_id;
1102: --
1103: begin
1104: hr_utility.set_location('Entering: '||l_proc,10);
1105: --
1106: -- Check if grades exist for the
1107: -- business group
1108: --
1111: if csr_get_gra%found then
1112: --
1113: DELETE FROM per_grade_spines_f gs
1114: WHERE gs.business_group_id = p_business_group_id;
1115: hr_utility.set_location(l_proc,200);
1116: --
1117: DELETE FROM per_valid_grades vg
1118: WHERE vg.business_group_id = p_business_group_id;
1119: hr_utility.set_location(l_proc,230);
1115: hr_utility.set_location(l_proc,200);
1116: --
1117: DELETE FROM per_valid_grades vg
1118: WHERE vg.business_group_id = p_business_group_id;
1119: hr_utility.set_location(l_proc,230);
1120: --
1121: DELETE FROM per_grades_tl gdt
1122: WHERE gdt.grade_id IN (SELECT pg.grade_id
1123: FROM per_grades pg
1121: DELETE FROM per_grades_tl gdt
1122: WHERE gdt.grade_id IN (SELECT pg.grade_id
1123: FROM per_grades pg
1124: WHERE pg.business_group_id = p_business_group_id);
1125: hr_utility.set_location(l_proc,235);
1126: --
1127: DELETE FROM per_grades pg
1128: WHERE pg.business_group_id = p_business_group_id;
1129: hr_utility.set_location(l_proc,240);
1125: hr_utility.set_location(l_proc,235);
1126: --
1127: DELETE FROM per_grades pg
1128: WHERE pg.business_group_id = p_business_group_id;
1129: hr_utility.set_location(l_proc,240);
1130: --
1131: end if;
1132: close csr_get_gra;
1133: hr_utility.set_location(l_proc,170);
1129: hr_utility.set_location(l_proc,240);
1130: --
1131: end if;
1132: close csr_get_gra;
1133: hr_utility.set_location(l_proc,170);
1134: --
1135: -- Check if parent spines exist for the
1136: -- business group
1137: --
1140: if csr_get_prs%found then
1141: --
1142: DELETE FROM PER_SPINAL_POINT_STEPS_F
1143: WHERE business_group_id = p_business_group_id;
1144: hr_utility.set_location(l_proc,180);
1145: --
1146: DELETE FROM per_spinal_points
1147: WHERE business_group_id = p_business_group_id;
1148: hr_utility.set_location(l_proc,190);
1144: hr_utility.set_location(l_proc,180);
1145: --
1146: DELETE FROM per_spinal_points
1147: WHERE business_group_id = p_business_group_id;
1148: hr_utility.set_location(l_proc,190);
1149: --
1150: DELETE FROM per_parent_spines
1151: WHERE business_group_id = p_business_group_id;
1152: hr_utility.set_location(l_proc,200);
1148: hr_utility.set_location(l_proc,190);
1149: --
1150: DELETE FROM per_parent_spines
1151: WHERE business_group_id = p_business_group_id;
1152: hr_utility.set_location(l_proc,200);
1153: --
1154: end if;
1155: close csr_get_prs;
1156: hr_utility.set_location('Leaving: '||l_proc,130);
1152: hr_utility.set_location(l_proc,200);
1153: --
1154: end if;
1155: close csr_get_prs;
1156: hr_utility.set_location('Leaving: '||l_proc,130);
1157: --
1158: end delete_grade_direct;
1159: --
1160: --
1180: FROM per_jobs
1181: WHERE business_group_id = c_business_group_id;
1182: --
1183: begin
1184: hr_utility.set_location('Entering: '||l_proc,10);
1185: --
1186: -- Check if position structures exist for the
1187: -- business group
1188: --
1191: if csr_get_pst%found then
1192: --
1193: DELETE FROM per_pos_structure_elements pse
1194: WHERE pse.business_group_id = p_business_group_id;
1195: hr_utility.set_location(l_proc,20);
1196: --
1197: DELETE FROM per_pos_structure_versions psv
1198: WHERE psv.business_group_id = p_business_group_id;
1199: hr_utility.set_location(l_proc,30);
1195: hr_utility.set_location(l_proc,20);
1196: --
1197: DELETE FROM per_pos_structure_versions psv
1198: WHERE psv.business_group_id = p_business_group_id;
1199: hr_utility.set_location(l_proc,30);
1200: --
1201: DELETE FROM per_position_structures ps
1202: WHERE ps.business_group_id = p_business_group_id;
1203: hr_utility.set_location(l_proc,40);
1199: hr_utility.set_location(l_proc,30);
1200: --
1201: DELETE FROM per_position_structures ps
1202: WHERE ps.business_group_id = p_business_group_id;
1203: hr_utility.set_location(l_proc,40);
1204: --
1205: end if;
1206: close csr_get_pst;
1207: hr_utility.set_location(l_proc,50);
1203: hr_utility.set_location(l_proc,40);
1204: --
1205: end if;
1206: close csr_get_pst;
1207: hr_utility.set_location(l_proc,50);
1208: --
1209: DELETE FROM per_job_evaluations
1210: WHERE business_group_id = p_business_group_id;
1211: hr_utility.set_location(l_proc,60);
1207: hr_utility.set_location(l_proc,50);
1208: --
1209: DELETE FROM per_job_evaluations
1210: WHERE business_group_id = p_business_group_id;
1211: hr_utility.set_location(l_proc,60);
1212: --
1213: DELETE FROM per_job_requirements
1214: WHERE business_group_id = p_business_group_id;
1215: hr_utility.set_location(l_proc,70);
1211: hr_utility.set_location(l_proc,60);
1212: --
1213: DELETE FROM per_job_requirements
1214: WHERE business_group_id = p_business_group_id;
1215: hr_utility.set_location(l_proc,70);
1216: --
1217: -- Check if jobs exist for the business group
1218: --
1219: open csr_get_job (p_business_group_id);
1226: WHERE EXISTS (SELECT ''
1227: FROM hr_all_positions_f pos
1228: WHERE pos.position_id = poi.position_id
1229: AND pos.business_group_id = p_business_group_id);
1230: hr_utility.set_location(l_proc,75);
1231: --
1232: -- PMFLETCH Delete from hr_all_positions_f_tl
1233: --
1234: DELETE FROM hr_all_positions_f_tl pft
1234: DELETE FROM hr_all_positions_f_tl pft
1235: WHERE pft.position_id IN (SELECT psf.position_id
1236: FROM hr_all_positions_f psf
1237: WHERE psf.business_group_id = p_business_group_id);
1238: hr_utility.set_location(l_proc,76);
1239: --
1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.
1241: --
1242: DELETE FROM hr_all_positions_f
1240: -- Changes 02-Oct-99 SCNair (delete hr_all_positions_f) date track position req.
1241: --
1242: DELETE FROM hr_all_positions_f
1243: WHERE business_group_id = p_business_group_id;
1244: hr_utility.set_location(l_proc,77);
1245: --
1246: DELETE FROM per_positions
1247: WHERE business_group_id = p_business_group_id;
1248: hr_utility.set_location(l_proc,80);
1244: hr_utility.set_location(l_proc,77);
1245: --
1246: DELETE FROM per_positions
1247: WHERE business_group_id = p_business_group_id;
1248: hr_utility.set_location(l_proc,80);
1249: --
1250: DELETE FROM per_job_extra_info jei
1251: WHERE EXISTS (SELECT ''
1252: FROM per_jobs job
1251: WHERE EXISTS (SELECT ''
1252: FROM per_jobs job
1253: WHERE job.job_id = jei.job_id
1254: AND job.business_group_id = p_business_group_id);
1255: hr_utility.set_location(l_proc,85);
1256: --
1257: hr_utility.set_location(l_proc,86);
1258: --
1259: DELETE FROM per_jobs_tl jbt
1253: WHERE job.job_id = jei.job_id
1254: AND job.business_group_id = p_business_group_id);
1255: hr_utility.set_location(l_proc,85);
1256: --
1257: hr_utility.set_location(l_proc,86);
1258: --
1259: DELETE FROM per_jobs_tl jbt
1260: WHERE EXISTS (SELECT ''
1261: FROM per_jobs job
1260: WHERE EXISTS (SELECT ''
1261: FROM per_jobs job
1262: WHERE job.job_id = jbt.job_id
1263: AND job.business_group_id = p_business_group_id);
1264: hr_utility.set_location(l_proc,87);
1265: --
1266: DELETE FROM per_jobs job
1267: WHERE job.business_group_id = p_business_group_id;
1268: --
1265: --
1266: DELETE FROM per_jobs job
1267: WHERE job.business_group_id = p_business_group_id;
1268: --
1269: hr_utility.set_location(l_proc,90);
1270: --
1271: end if;
1272: close csr_get_job;
1273: --
1273: --
1274: DELETE FROM per_job_groups jgr
1275: WHERE jgr.business_group_id = p_business_group_id;
1276: --
1277: hr_utility.set_location('Leaving: '||l_proc,100);
1278: --
1279: end delete_job_direct;
1280: --
1281: --
1302: FROM per_absence_attendance_types
1303: WHERE business_group_id = c_business_group_id;
1304: --
1305: begin
1306: hr_utility.set_location('Entering: '||l_proc,10);
1307: --
1308: -- Check if a absence attendence types exist
1309: -- for the business group.
1310: --
1313: if csr_get_aats%found then
1314: --
1315: DELETE FROM per_absence_attendances
1316: WHERE business_group_id = p_business_group_id;
1317: hr_utility.set_location(l_proc,20);
1318: --
1319: DELETE FROM per_abs_attendance_reasons
1320: WHERE business_group_id = p_business_group_id;
1321: hr_utility.set_location(l_proc,30);
1317: hr_utility.set_location(l_proc,20);
1318: --
1319: DELETE FROM per_abs_attendance_reasons
1320: WHERE business_group_id = p_business_group_id;
1321: hr_utility.set_location(l_proc,30);
1322: --
1323: DELETE FROM per_abs_attendance_types_tl t
1324: WHERE t.absence_attendance_type_id in
1325: (select b.absence_attendance_type_id
1324: WHERE t.absence_attendance_type_id in
1325: (select b.absence_attendance_type_id
1326: from per_absence_attendance_types b
1327: where b.business_group_id = p_business_group_id);
1328: hr_utility.set_location(l_proc,40);
1329: --
1330: DELETE FROM per_absence_attendance_types
1331: WHERE business_group_id = p_business_group_id;
1332: hr_utility.set_location(l_proc,40);
1328: hr_utility.set_location(l_proc,40);
1329: --
1330: DELETE FROM per_absence_attendance_types
1331: WHERE business_group_id = p_business_group_id;
1332: hr_utility.set_location(l_proc,40);
1333: --
1334: end if;
1335: close csr_get_aats;
1336: hr_utility.set_location(l_proc,50);
1332: hr_utility.set_location(l_proc,40);
1333: --
1334: end if;
1335: close csr_get_aats;
1336: hr_utility.set_location(l_proc,50);
1337: --
1338: -- Check if a person exists for the business group
1339: --
1340: open csr_get_person(p_business_group_id);
1354: WHERE EXISTS (SELECT ''
1355: FROM per_people_f per
1356: WHERE per.person_id = pei.person_id
1357: AND per.business_group_id = p_business_group_id);
1358: hr_utility.set_location(l_proc,55);
1359: --
1360: DELETE FROM per_person_analyses
1361: WHERE business_group_id = p_business_group_id;
1362: hr_utility.set_location(l_proc,60);
1358: hr_utility.set_location(l_proc,55);
1359: --
1360: DELETE FROM per_person_analyses
1361: WHERE business_group_id = p_business_group_id;
1362: hr_utility.set_location(l_proc,60);
1363: --
1364: DELETE FROM per_contact_relationships cr
1365: WHERE cr.business_group_id = p_business_group_id;
1366: hr_utility.set_location(l_proc,70);
1362: hr_utility.set_location(l_proc,60);
1363: --
1364: DELETE FROM per_contact_relationships cr
1365: WHERE cr.business_group_id = p_business_group_id;
1366: hr_utility.set_location(l_proc,70);
1367: --
1368: DELETE FROM per_applications app
1369: WHERE app.business_group_id = p_business_group_id;
1370: hr_utility.set_location(l_proc,80);
1366: hr_utility.set_location(l_proc,70);
1367: --
1368: DELETE FROM per_applications app
1369: WHERE app.business_group_id = p_business_group_id;
1370: hr_utility.set_location(l_proc,80);
1371: --
1372: DELETE FROM per_periods_of_service pos
1373: WHERE pos.business_group_id = p_business_group_id;
1374: hr_utility.set_location(l_proc,90);
1370: hr_utility.set_location(l_proc,80);
1371: --
1372: DELETE FROM per_periods_of_service pos
1373: WHERE pos.business_group_id = p_business_group_id;
1374: hr_utility.set_location(l_proc,90);
1375: --
1376: DELETE FROM per_addresses pa
1377: WHERE pa.business_group_id = p_business_group_id;
1378: hr_utility.set_location(l_proc,100);
1374: hr_utility.set_location(l_proc,90);
1375: --
1376: DELETE FROM per_addresses pa
1377: WHERE pa.business_group_id = p_business_group_id;
1378: hr_utility.set_location(l_proc,100);
1379: --
1380: DELETE FROM per_people_f pp
1381: WHERE pp.business_group_id = p_business_group_id;
1382: hr_utility.set_location(l_proc,110);
1378: hr_utility.set_location(l_proc,100);
1379: --
1380: DELETE FROM per_people_f pp
1381: WHERE pp.business_group_id = p_business_group_id;
1382: hr_utility.set_location(l_proc,110);
1383: --
1384: end if;
1385: close csr_get_person;
1386: hr_utility.set_location(l_proc,120);
1382: hr_utility.set_location(l_proc,110);
1383: --
1384: end if;
1385: close csr_get_person;
1386: hr_utility.set_location(l_proc,120);
1387: --
1388: DELETE FROM per_person_types
1389: WHERE business_group_id = p_business_group_id;
1390: hr_utility.set_location('Leaving: '||l_proc,130);
1386: hr_utility.set_location(l_proc,120);
1387: --
1388: DELETE FROM per_person_types
1389: WHERE business_group_id = p_business_group_id;
1390: hr_utility.set_location('Leaving: '||l_proc,130);
1391: --
1392: end delete_person_direct;
1393: --
1394: --
1399: --
1400: l_exists varchar2(1);
1401: --
1402: begin
1403: hr_utility.set_location('Entering: '||l_proc,10);
1404: --
1405: DELETE FROM per_number_generation_controls png
1406: WHERE png.business_group_id = p_business_group_id;
1407: hr_utility.set_location('Leaving: '||l_proc,10);
1403: hr_utility.set_location('Entering: '||l_proc,10);
1404: --
1405: DELETE FROM per_number_generation_controls png
1406: WHERE png.business_group_id = p_business_group_id;
1407: hr_utility.set_location('Leaving: '||l_proc,10);
1408: --
1409: end delete_per_misc;
1410: --
1411: PROCEDURE delete_element_direct(p_business_group_id NUMBER)
1453: where pel.business_group_id = p_business_group_id
1454: and liv.element_link_id = pel.element_link_id;
1455: --
1456: begin
1457: hr_utility.set_location('Entering: '||l_proc, 10);
1458: DELETE FROM pay_balance_feeds_f pbf
1459: WHERE pbf.business_group_id = p_business_group_id;
1460: hr_utility.set_location(l_proc, 20);
1461: --
1456: begin
1457: hr_utility.set_location('Entering: '||l_proc, 10);
1458: DELETE FROM pay_balance_feeds_f pbf
1459: WHERE pbf.business_group_id = p_business_group_id;
1460: hr_utility.set_location(l_proc, 20);
1461: --
1462: FOR levrec in lev LOOP
1463: delete from pay_link_input_values_f liv
1464: where liv.link_input_value_id = levrec.link_input_value_id;
1462: FOR levrec in lev LOOP
1463: delete from pay_link_input_values_f liv
1464: where liv.link_input_value_id = levrec.link_input_value_id;
1465: END LOOP;
1466: hr_utility.set_location(l_proc, 30);
1467: --
1468: DELETE FROM pay_element_links_f el
1469: WHERE el.business_group_id = p_business_group_id;
1470: hr_utility.set_location(l_proc, 40);
1466: hr_utility.set_location(l_proc, 30);
1467: --
1468: DELETE FROM pay_element_links_f el
1469: WHERE el.business_group_id = p_business_group_id;
1470: hr_utility.set_location(l_proc, 40);
1471: --
1472: DELETE FROM pay_element_type_rules etr
1473: WHERE EXISTS (SELECT ''
1474: FROM pay_element_sets es
1473: WHERE EXISTS (SELECT ''
1474: FROM pay_element_sets es
1475: WHERE es.element_set_id = etr.element_set_id
1476: AND es.business_group_id = p_business_group_id);
1477: hr_utility.set_location(l_proc, 50);
1478: --
1479: DELETE FROM pay_ele_classification_rules ecr
1480: WHERE EXISTS (SELECT ''
1481: FROM pay_element_sets es
1480: WHERE EXISTS (SELECT ''
1481: FROM pay_element_sets es
1482: WHERE es.element_set_id = ecr.element_set_id
1483: AND es.business_group_id = p_business_group_id);
1484: hr_utility.set_location(l_proc, 60);
1485: --
1486: DELETE FROM pay_element_sets es
1487: WHERE es.business_group_id = p_business_group_id;
1488: hr_utility.set_location(l_proc, 70);
1484: hr_utility.set_location(l_proc, 60);
1485: --
1486: DELETE FROM pay_element_sets es
1487: WHERE es.business_group_id = p_business_group_id;
1488: hr_utility.set_location(l_proc, 70);
1489: --
1490: DELETE FROM pay_sub_classification_rules_f scr
1491: WHERE scr.business_group_id = p_business_group_id;
1492: hr_utility.set_location(l_proc, 80);
1488: hr_utility.set_location(l_proc, 70);
1489: --
1490: DELETE FROM pay_sub_classification_rules_f scr
1491: WHERE scr.business_group_id = p_business_group_id;
1492: hr_utility.set_location(l_proc, 80);
1493: --
1494: DELETE FROM pay_formula_result_rules_f frr
1495: WHERE frr.business_group_id = p_business_group_id;
1496: hr_utility.set_location(l_proc, 90);
1492: hr_utility.set_location(l_proc, 80);
1493: --
1494: DELETE FROM pay_formula_result_rules_f frr
1495: WHERE frr.business_group_id = p_business_group_id;
1496: hr_utility.set_location(l_proc, 90);
1497: --
1498: DELETE FROM pay_status_processing_rules_f spr
1499: WHERE spr.business_group_id = p_business_group_id;
1500: hr_utility.set_location(l_proc, 90);
1496: hr_utility.set_location(l_proc, 90);
1497: --
1498: DELETE FROM pay_status_processing_rules_f spr
1499: WHERE spr.business_group_id = p_business_group_id;
1500: hr_utility.set_location(l_proc, 90);
1501: --
1502: DELETE FROM pay_iterative_rules_f pir
1503: WHERE exists (select ''
1504: from pay_element_types pet
1504: from pay_element_types pet
1505: where pir.business_group_id = p_business_group_id
1506: and pet.element_type_id = pir.element_type_id
1507: );
1508: hr_utility.set_location(l_proc, 95);
1509: --
1510: -- Check if a element types exist for the business group
1511: --
1512: open csr_get_ele_types(p_business_group_id);
1526: delete from pay_input_values_f_tl
1527: where input_value_id = iv_rec.input_value_id;
1528: --
1529: end loop;
1530: hr_utility.set_location(l_proc, 100);
1531: --
1532: for et_rec in get_element_types loop
1533: --
1534: -- delete element types
1540: where current of get_element_types;
1541: --
1542: --
1543: end loop;
1544: hr_utility.set_location(l_proc, 110);
1545: --
1546: end if;
1547: close csr_get_ele_types;
1548: hr_utility.set_location('Leaving: '||l_proc, 120);
1544: hr_utility.set_location(l_proc, 110);
1545: --
1546: end if;
1547: close csr_get_ele_types;
1548: hr_utility.set_location('Leaving: '||l_proc, 120);
1549: --
1550: end delete_element_direct;
1551: --
1552: --
1553: PROCEDURE delete_org_low_detail(p_business_group_id NUMBER)
1554: IS
1555: begin
1556: --
1557: hr_utility.set_location('hr_delete.delete_org_low_detail',10);
1558: DELETE FROM pay_grade_rules_f gr
1559: WHERE gr.business_group_id = p_business_group_id;
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1557: hr_utility.set_location('hr_delete.delete_org_low_detail',10);
1558: DELETE FROM pay_grade_rules_f gr
1559: WHERE gr.business_group_id = p_business_group_id;
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1562: DELETE FROM pay_rates pr
1563: WHERE pr.business_group_id = p_business_group_id;
1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);
1565: --
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1562: DELETE FROM pay_rates pr
1563: WHERE pr.business_group_id = p_business_group_id;
1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);
1565: --
1566: --
1567: end delete_org_low_detail;
1568: --
1582: WHERE business_group_id = c_business_group_id;
1583: --
1584: begin
1585: --
1586: hr_utility.set_location('Entering: '||l_proc,10);
1587: DELETE FROM pay_wc_rates pwr
1588: WHERE pwr.business_group_id = p_business_group_id;
1589: hr_utility.set_location(l_proc,20);
1590: --
1585: --
1586: hr_utility.set_location('Entering: '||l_proc,10);
1587: DELETE FROM pay_wc_rates pwr
1588: WHERE pwr.business_group_id = p_business_group_id;
1589: hr_utility.set_location(l_proc,20);
1590: --
1591: DELETE FROM pay_wc_funds pwf
1592: WHERE pwf.business_group_id = p_business_group_id;
1593: hr_utility.set_location(l_proc,30);
1589: hr_utility.set_location(l_proc,20);
1590: --
1591: DELETE FROM pay_wc_funds pwf
1592: WHERE pwf.business_group_id = p_business_group_id;
1593: hr_utility.set_location(l_proc,30);
1594: --
1595:
1596:
1597:
1608: (SELECT sit.special_information_type_id
1609: FROM per_special_info_types sit
1610: WHERE sit.special_information_type_id = situ.special_information_type_id
1611: AND sit.business_group_id = p_business_group_id);
1612: hr_utility.set_location(l_proc,100);
1613: --
1614: DELETE FROM per_special_info_types sit
1615: WHERE sit.business_group_id = p_business_group_id;
1616: hr_utility.set_location(l_proc,110);
1612: hr_utility.set_location(l_proc,100);
1613: --
1614: DELETE FROM per_special_info_types sit
1615: WHERE sit.business_group_id = p_business_group_id;
1616: hr_utility.set_location(l_proc,110);
1617: --
1618: end if;
1619: close csr_get_spec_inf_type;
1620: hr_utility.set_location(l_proc,120);
1616: hr_utility.set_location(l_proc,110);
1617: --
1618: end if;
1619: close csr_get_spec_inf_type;
1620: hr_utility.set_location(l_proc,120);
1621: --
1622: hr_utility.set_location('Leaving: '||l_proc,200);
1623: --
1624: end delete_org_detail;
1618: end if;
1619: close csr_get_spec_inf_type;
1620: hr_utility.set_location(l_proc,120);
1621: --
1622: hr_utility.set_location('Leaving: '||l_proc,200);
1623: --
1624: end delete_org_detail;
1625: --
1626: PROCEDURE delete_payroll_direct(p_business_group_id NUMBER)
1637: FROM pay_payrolls_f
1638: WHERE business_group_id = c_business_group_id;
1639: --
1640: begin
1641: hr_utility.set_location('Entering: '||l_proc,10);
1642: --
1643: -- Check if a payrolls exist for the business group
1644: --
1645: open csr_get_bg_payrolls(p_business_group_id);
1651: EXISTS ( SELECT ''
1652: FROM pay_payrolls_f pp
1653: WHERE pp.payroll_id = pmu.payroll_id
1654: AND pp.business_group_id = p_business_group_id);
1655: hr_utility.set_location(l_proc,30);
1656: --
1657: DELETE FROM hr_assignment_set_criteria has
1658: WHERE
1659: EXISTS ( SELECT ''
1659: EXISTS ( SELECT ''
1660: FROM hr_assignment_sets ase
1661: WHERE ase.assignment_set_id = has.assignment_set_id
1662: AND ase.business_group_id = p_business_group_id);
1663: hr_utility.set_location(l_proc,40);
1664: --
1665: DELETE FROM hr_assignment_sets ase
1666: WHERE ase.business_group_id = p_business_group_id;
1667: hr_utility.set_location(l_proc,50);
1663: hr_utility.set_location(l_proc,40);
1664: --
1665: DELETE FROM hr_assignment_sets ase
1666: WHERE ase.business_group_id = p_business_group_id;
1667: hr_utility.set_location(l_proc,50);
1668: --
1669: --
1670: DELETE FROM PER_TIME_PERIODS tim
1671: WHERE EXISTS ( SELECT ''
1671: WHERE EXISTS ( SELECT ''
1672: FROM pay_payrolls_f pp
1673: WHERE pp.payroll_id = tim.payroll_id
1674: AND pp.business_group_id = p_business_group_id);
1675: hr_utility.set_location(l_proc,70);
1676: --
1677: DELETE FROM pay_payroll_gl_flex_maps glf
1678: WHERE EXISTS ( SELECT ''
1679: FROM pay_payrolls_f pp
1678: WHERE EXISTS ( SELECT ''
1679: FROM pay_payrolls_f pp
1680: WHERE pp.payroll_id = glf.payroll_id
1681: AND pp.business_group_id = p_business_group_id);
1682: hr_utility.set_location(l_proc,80);
1683: --
1684: DELETE FROM pay_payrolls_f pay
1685: WHERE pay.business_group_id = p_business_group_id;
1686: hr_utility.set_location(l_proc,90);
1682: hr_utility.set_location(l_proc,80);
1683: --
1684: DELETE FROM pay_payrolls_f pay
1685: WHERE pay.business_group_id = p_business_group_id;
1686: hr_utility.set_location(l_proc,90);
1687: --
1688: end if;
1689: close csr_get_bg_payrolls;
1690: hr_utility.set_location('Leaving: '||l_proc,100);
1686: hr_utility.set_location(l_proc,90);
1687: --
1688: end if;
1689: close csr_get_bg_payrolls;
1690: hr_utility.set_location('Leaving: '||l_proc,100);
1691: --
1692: --
1693: end delete_payroll_direct;
1694: --
1714: from pay_balance_types
1715: where business_group_id = c_business_group_id;
1716: begin
1717: --
1718: hr_utility.set_location('Entering: '||l_proc,10);
1719: --
1720: DELETE FROM pay_backpay_rules br
1721: WHERE EXISTS ( SELECT ''
1722: FROM pay_backpay_sets bs
1721: WHERE EXISTS ( SELECT ''
1722: FROM pay_backpay_sets bs
1723: WHERE bs.backpay_set_id = br.backpay_set_id
1724: AND bs.business_group_id = p_business_group_id);
1725: hr_utility.set_location(l_proc,30);
1726: --
1727: DELETE FROM pay_backpay_sets bs
1728: WHERE bs.business_group_id = p_business_group_id;
1729: hr_utility.set_location(l_proc,40);
1725: hr_utility.set_location(l_proc,30);
1726: --
1727: DELETE FROM pay_backpay_sets bs
1728: WHERE bs.business_group_id = p_business_group_id;
1729: hr_utility.set_location(l_proc,40);
1730: --
1731: DELETE FROM pay_balance_set_members bsm
1732: WHERE EXISTS ( SELECT ''
1733: FROM pay_balance_sets pbs
1732: WHERE EXISTS ( SELECT ''
1733: FROM pay_balance_sets pbs
1734: WHERE pbs.balance_set_id = bsm.balance_set_id
1735: AND pbs.business_group_id = p_business_group_id);
1736: hr_utility.set_location(l_proc,50);
1737: --
1738: DELETE FROM pay_balance_sets pbs
1739: WHERE pbs.business_group_id = p_business_group_id;
1740: hr_utility.set_location(l_proc,60);
1736: hr_utility.set_location(l_proc,50);
1737: --
1738: DELETE FROM pay_balance_sets pbs
1739: WHERE pbs.business_group_id = p_business_group_id;
1740: hr_utility.set_location(l_proc,60);
1741: --
1742: DELETE FROM pay_balance_classifications pbc
1743: WHERE pbc.business_group_id = p_business_group_id;
1744: hr_utility.set_location(l_proc,70);
1740: hr_utility.set_location(l_proc,60);
1741: --
1742: DELETE FROM pay_balance_classifications pbc
1743: WHERE pbc.business_group_id = p_business_group_id;
1744: hr_utility.set_location(l_proc,70);
1745: --
1746: -- Check if a defined balance exists for the business group
1747: --
1748: open csr_get_def_bals(p_business_group_id);
1750: if csr_get_def_bals%found then
1751: --
1752: DELETE FROM pay_defined_balances pdb
1753: WHERE pdb.business_group_id = p_business_group_id;
1754: hr_utility.set_location(l_proc,80);
1755: --
1756: end if;
1757: close csr_get_def_bals;
1758: hr_utility.set_location(l_proc,90);
1754: hr_utility.set_location(l_proc,80);
1755: --
1756: end if;
1757: close csr_get_def_bals;
1758: hr_utility.set_location(l_proc,90);
1759: --
1760: DELETE FROM pay_balance_dimensions pbd
1761: WHERE pbd.business_group_id = p_business_group_id;
1762: hr_utility.set_location(l_proc,100);
1758: hr_utility.set_location(l_proc,90);
1759: --
1760: DELETE FROM pay_balance_dimensions pbd
1761: WHERE pbd.business_group_id = p_business_group_id;
1762: hr_utility.set_location(l_proc,100);
1763: --
1764: for balrec in csr_get_bal_types(p_business_group_id) loop
1765: --
1766: DELETE FROM pay_balance_feeds_f pbf
1764: for balrec in csr_get_bal_types(p_business_group_id) loop
1765: --
1766: DELETE FROM pay_balance_feeds_f pbf
1767: WHERE pbf.balance_type_id = balrec.balance_type_id;
1768: hr_utility.set_location('Leaving: '||l_proc,90);
1769: --
1770: DELETE FROM pay_balance_types_tl pbt
1771: WHERE pbt.balance_type_id = balrec.balance_type_id;
1772: hr_utility.set_location('Leaving: '||l_proc,95);
1768: hr_utility.set_location('Leaving: '||l_proc,90);
1769: --
1770: DELETE FROM pay_balance_types_tl pbt
1771: WHERE pbt.balance_type_id = balrec.balance_type_id;
1772: hr_utility.set_location('Leaving: '||l_proc,95);
1773: --
1774: DELETE FROM pay_balance_types pbt
1775: WHERE pbt.balance_type_id = balrec.balance_type_id;
1776: hr_utility.set_location('Leaving: '||l_proc,100);
1772: hr_utility.set_location('Leaving: '||l_proc,95);
1773: --
1774: DELETE FROM pay_balance_types pbt
1775: WHERE pbt.balance_type_id = balrec.balance_type_id;
1776: hr_utility.set_location('Leaving: '||l_proc,100);
1777: --
1778: end loop;
1779: --
1780: end delete_balance_direct;
1801: FROM PAY_BATCH_HEADERS pbh
1802: WHERE pbh.BUSINESS_GROUP_ID = p_bg_id;
1803: --
1804: begin
1805: hr_utility.set_location('Entering: '||l_proc, 10);
1806: DELETE pay_consolidation_sets cs
1807: WHERE cs.business_group_id = p_business_group_id;
1808: hr_utility.set_location(l_proc, 20);
1809: --
1804: begin
1805: hr_utility.set_location('Entering: '||l_proc, 10);
1806: DELETE pay_consolidation_sets cs
1807: WHERE cs.business_group_id = p_business_group_id;
1808: hr_utility.set_location(l_proc, 20);
1809: --
1810: DELETE pay_restriction_values rv
1811: WHERE EXISTS (SELECT ''
1812: FROM pay_customized_restrictions cr
1812: FROM pay_customized_restrictions cr
1813: WHERE cr.customized_restriction_id
1814: = rv.customized_restriction_id
1815: AND cr.business_group_id = p_business_group_id);
1816: hr_utility.set_location(l_proc, 30);
1817: --
1818:
1819: DELETE pay_custom_restrictions_tl crtl
1820: WHERE EXISTS (SELECT ''
1821: FROM pay_customized_restrictions cr
1822: WHERE cr.customized_restriction_id
1823: = crtl.customized_restriction_id
1824: AND cr.business_group_id = p_business_group_id);
1825: hr_utility.set_location(l_proc, 35);
1826:
1827: ------
1828:
1829: DELETE pay_customized_restrictions cr
1827: ------
1828:
1829: DELETE pay_customized_restrictions cr
1830: WHERE cr.business_group_id = p_business_group_id;
1831: hr_utility.set_location(l_proc, 40);
1832: --
1833: DELETE pay_user_column_instances_f uci
1834: WHERE uci.business_group_id = p_business_group_id;
1835: hr_utility.set_location(l_proc, 50);
1831: hr_utility.set_location(l_proc, 40);
1832: --
1833: DELETE pay_user_column_instances_f uci
1834: WHERE uci.business_group_id = p_business_group_id;
1835: hr_utility.set_location(l_proc, 50);
1836: --
1837: DELETE pay_user_columns uc
1838: WHERE uc.business_group_id = p_business_group_id;
1839: hr_utility.set_location(l_proc, 60);
1835: hr_utility.set_location(l_proc, 50);
1836: --
1837: DELETE pay_user_columns uc
1838: WHERE uc.business_group_id = p_business_group_id;
1839: hr_utility.set_location(l_proc, 60);
1840: --
1841: DELETE pay_user_rows_f ur
1842: WHERE ur.business_group_id = p_business_group_id;
1843: hr_utility.set_location(l_proc, 70);
1839: hr_utility.set_location(l_proc, 60);
1840: --
1841: DELETE pay_user_rows_f ur
1842: WHERE ur.business_group_id = p_business_group_id;
1843: hr_utility.set_location(l_proc, 70);
1844: --
1845: DELETE pay_user_tables ut
1846: WHERE ut.business_group_id = p_business_group_id;
1847: hr_utility.set_location(l_proc, 80);
1843: hr_utility.set_location(l_proc, 70);
1844: --
1845: DELETE pay_user_tables ut
1846: WHERE ut.business_group_id = p_business_group_id;
1847: hr_utility.set_location(l_proc, 80);
1848: --
1849: DELETE pay_element_classifications ec
1850: WHERE ec.business_group_id = p_business_group_id;
1851: hr_utility.set_location(l_proc, 90);
1847: hr_utility.set_location(l_proc, 80);
1848: --
1849: DELETE pay_element_classifications ec
1850: WHERE ec.business_group_id = p_business_group_id;
1851: hr_utility.set_location(l_proc, 90);
1852: --
1853: -- Check if a message lines exist for the business group
1854: --
1855: open csr_get_mess_lines(p_business_group_id);
1861: AND ml.source_id = p_business_group_id;
1862: --
1863: end if;
1864: close csr_get_mess_lines;
1865: hr_utility.set_location(l_proc, 100);
1866: --
1867: DELETE FROM pay_freq_rule_periods pfr
1868: WHERE pfr.business_group_id = p_business_group_id;
1869: hr_utility.set_location(l_proc, 110);
1865: hr_utility.set_location(l_proc, 100);
1866: --
1867: DELETE FROM pay_freq_rule_periods pfr
1868: WHERE pfr.business_group_id = p_business_group_id;
1869: hr_utility.set_location(l_proc, 110);
1870: --
1871: DELETE FROM pay_ele_payroll_freq_rules pef
1872: WHERE pef.business_group_id = p_business_group_id;
1873: hr_utility.set_location(l_proc, 120);
1869: hr_utility.set_location(l_proc, 110);
1870: --
1871: DELETE FROM pay_ele_payroll_freq_rules pef
1872: WHERE pef.business_group_id = p_business_group_id;
1873: hr_utility.set_location(l_proc, 120);
1874: --
1875: FOR bahrec IN csr_batch_header(p_business_group_id) LOOP
1876: --
1877: payplnk.purge(bahrec.batch_id);
1876: --
1877: payplnk.purge(bahrec.batch_id);
1878: --
1879: END LOOP;
1880: hr_utility.set_location(l_proc, 130);
1881: --
1882: DELETE FROM ben_benefit_contributions_f bbc
1883: WHERE bbc.business_group_id = p_business_group_id;
1884: --
1883: WHERE bbc.business_group_id = p_business_group_id;
1884: --
1885: DELETE FROM pay_datetracked_events
1886: WHERE business_group_id = p_business_group_id;
1887: hr_utility.set_location(l_proc, 140);
1888: --
1889: DELETE FROM pay_event_groups
1890: WHERE business_group_id = p_business_group_id;
1891: hr_utility.set_location(l_proc, 150);
1887: hr_utility.set_location(l_proc, 140);
1888: --
1889: DELETE FROM pay_event_groups
1890: WHERE business_group_id = p_business_group_id;
1891: hr_utility.set_location(l_proc, 150);
1892: --
1893: DELETE FROM pay_event_procedures
1894: WHERE business_group_id = p_business_group_id;
1895: hr_utility.set_location(l_proc, 155);
1891: hr_utility.set_location(l_proc, 150);
1892: --
1893: DELETE FROM pay_event_procedures
1894: WHERE business_group_id = p_business_group_id;
1895: hr_utility.set_location(l_proc, 155);
1896: --
1897: DELETE FROM pay_event_updates
1898: WHERE business_group_id = p_business_group_id;
1899: hr_utility.set_location(l_proc, 160);
1895: hr_utility.set_location(l_proc, 155);
1896: --
1897: DELETE FROM pay_event_updates
1898: WHERE business_group_id = p_business_group_id;
1899: hr_utility.set_location(l_proc, 160);
1900: --
1901: DELETE FROM pay_dated_tables
1902: WHERE business_group_id = p_business_group_id;
1903: --
1900: --
1901: DELETE FROM pay_dated_tables
1902: WHERE business_group_id = p_business_group_id;
1903: --
1904: hr_utility.set_location('Leaving: '||l_proc, 200);
1905: end delete_pay_misc;
1906: --
1907: Procedure delete_qun_misc(p_business_group_id number)
1908: IS
1910: l_proc varchar2(80) := g_package || 'delete_qun_misc';
1911: --
1912: BEGIN
1913: --
1914: hr_utility.set_location('Entering: '||l_proc,10);
1915: --
1916: DELETE from hr_quest_answer_values qsv
1917: WHERE qsv.quest_answer_val_id in (
1918: SELECT qv.quest_answer_val_id
1920: , hr_quest_answers qa
1921: WHERE qa.questionnaire_answer_id = qv.questionnaire_answer_id
1922: AND qa.business_group_id = P_BUSINESS_GROUP_ID);
1923: --
1924: hr_utility.set_location(l_proc,20);
1925: --
1926: DELETE from hr_quest_answers qsa
1927: WHERE qsa.business_group_id = P_BUSINESS_GROUP_ID;
1928: --
1925: --
1926: DELETE from hr_quest_answers qsa
1927: WHERE qsa.business_group_id = P_BUSINESS_GROUP_ID;
1928: --
1929: hr_utility.set_location(l_proc,30);
1930: --
1931: DELETE from hr_quest_fields qsf
1932: WHERE qsf.field_id in (
1933: SELECT qf.field_id
1935: , hr_questionnaires qn
1936: WHERE qf.questionnaire_template_id = qn.questionnaire_template_id
1937: AND qn.business_group_id = P_BUSINESS_GROUP_ID);
1938: --
1939: hr_utility.set_location(l_proc,40);
1940: --
1941: DELETE from hr_questionnaires qsn
1942: WHERE qsn.business_group_id = P_BUSINESS_GROUP_ID;
1943: --
1940: --
1941: DELETE from hr_questionnaires qsn
1942: WHERE qsn.business_group_id = P_BUSINESS_GROUP_ID;
1943: --
1944: hr_utility.set_location(l_proc,50);
1945: --
1946: DELETE from per_participants par
1947: WHERE par.business_group_id = P_BUSINESS_GROUP_ID;
1948: --
1945: --
1946: DELETE from per_participants par
1947: WHERE par.business_group_id = P_BUSINESS_GROUP_ID;
1948: --
1949: hr_utility.set_location(l_proc,60);
1950: --
1951: DELETE from per_appraisals apr
1952: WHERE apr.business_group_id = P_BUSINESS_GROUP_ID;
1953: --
1950: --
1951: DELETE from per_appraisals apr
1952: WHERE apr.business_group_id = P_BUSINESS_GROUP_ID;
1953: --
1954: hr_utility.set_location('Leaving: '||l_proc,70);
1955: --
1956: END;
1957: --
1958: PROCEDURE delete_org_direct(p_business_group_id NUMBER,
1980: from fnd_lookup_types
1981: where security_group_id = p_sec_grp;
1982: --
1983: begin
1984: hr_utility.set_location('Entering: '||l_proc, 10);
1985: --
1986: if p_rt_running = 'N' then
1987: --
1988: select security_group_id
1989: into l_security_group_id
1990: from per_business_groups
1991: where business_group_id = p_business_group_id;
1992: --
1993: hr_utility.set_location('Entering: '||l_proc, 13);
1994: --
1995: DELETE FROM hr_organization_information hoi
1996: WHERE
1997: EXISTS
1999: FROM hr_organization_units hou
2000: WHERE hou.organization_id = hoi.organization_id
2001: AND hou.business_group_id = p_business_group_id);
2002: --
2003: hr_utility.set_location('Entering: '||l_proc, 14);
2004: --
2005: --
2006: -- Check if the enable_security_groups profile is set to 'Y'
2007: -- for any applications - if it is then delete the security
2051: AND lookup_type = typrec.lookup_type;
2052: --
2053: end loop;
2054: --
2055: hr_utility.set_location(l_proc, 15);
2056: --
2057: DELETE FROM fnd_security_groups_tl
2058: WHERE security_group_id = l_security_group_id;
2059: --
2056: --
2057: DELETE FROM fnd_security_groups_tl
2058: WHERE security_group_id = l_security_group_id;
2059: --
2060: hr_utility.set_location('Entering: '||l_proc, 16);
2061: --
2062: DELETE FROM fnd_security_groups
2063: WHERE security_group_id = l_security_group_id;
2064: --
2065: END IF;
2066: END;
2067: end if;
2068: --
2069: hr_utility.set_location(l_proc, 20);
2070: --
2071: -- Check if an organization structure exists for the
2072: -- business group
2073: --
2076: if csr_get_ost%found then
2077: --
2078: DELETE per_org_structure_elements
2079: WHERE business_group_id = p_business_group_id;
2080: hr_utility.set_location(l_proc, 30);
2081: --
2082: DELETE per_org_structure_versions
2083: WHERE business_group_id = p_business_group_id;
2084: hr_utility.set_location(l_proc, 40);
2080: hr_utility.set_location(l_proc, 30);
2081: --
2082: DELETE per_org_structure_versions
2083: WHERE business_group_id = p_business_group_id;
2084: hr_utility.set_location(l_proc, 40);
2085: --
2086: DELETE per_organization_structures
2087: WHERE business_group_id = p_business_group_id;
2088: hr_utility.set_location(l_proc, 50);
2084: hr_utility.set_location(l_proc, 40);
2085: --
2086: DELETE per_organization_structures
2087: WHERE business_group_id = p_business_group_id;
2088: hr_utility.set_location(l_proc, 50);
2089: --
2090: end if;
2091: close csr_get_ost;
2092: hr_utility.set_location(l_proc, 60);
2088: hr_utility.set_location(l_proc, 50);
2089: --
2090: end if;
2091: close csr_get_ost;
2092: hr_utility.set_location(l_proc, 60);
2093: --
2094: if p_rt_running = 'N' then
2095: DELETE hr_organization_units
2096: WHERE business_group_id = p_business_group_id
2095: DELETE hr_organization_units
2096: WHERE business_group_id = p_business_group_id
2097: AND organization_id <> p_business_group_id;
2098: end if;
2099: hr_utility.set_location('Leaving: '||l_proc, 100);
2100: end delete_org_direct;
2101: --
2102: --
2103: PROCEDURE delete_bg_misc(p_business_group_id NUMBER)
2127: l_rows_processed number;
2128: --
2129: begin
2130: --
2131: hr_utility.set_location('hr_delete.delete_bg_misc',1);
2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --
2128: --
2129: begin
2130: --
2131: hr_utility.set_location('hr_delete.delete_bg_misc',1);
2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --
2136: hr_utility.set_location('hr_delete.delete_bg_misc',4);
2132: hr_utility.set_location('hr_delete.delete_bg_misc',2);
2133: DELETE per_letter_gen_statuses
2134: WHERE business_group_id = p_business_group_id;
2135: --
2136: hr_utility.set_location('hr_delete.delete_bg_misc',4);
2137: --
2138: -- Get table name if it exists.
2139: --
2140: open fsp_table_name;
2141: fetch fsp_table_name into l_fsp_table_name;
2142: if fsp_table_name%found then
2143: close fsp_table_name;
2144: --
2145: hr_utility.set_location('hr_delete.delete_bg_misc',7);
2146: --
2147: -- Define the dynamic cursor.
2148: --
2149: l_sql_text := 'delete from '
2154: -- Open Cursor for Processing Sql statment.
2155: --
2156: l_sql_cursor := dbms_sql.open_cursor;
2157: --
2158: hr_utility.set_location('hr_delete.delete_bg_misc',8);
2159: --
2160: -- Parse SQL statement.
2161: --
2162: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
2160: -- Parse SQL statement.
2161: --
2162: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
2163: --
2164: hr_utility.set_location('hr_delete.delete_bg_misc',9);
2165: --
2166: -- Execute the sql
2167: --
2168: l_rows_processed := dbms_sql.execute(l_sql_cursor);
2166: -- Execute the sql
2167: --
2168: l_rows_processed := dbms_sql.execute(l_sql_cursor);
2169: --
2170: hr_utility.set_location('hr_delete.delete_bg_misc',10);
2171: --
2172: -- Close cursor.
2173: --
2174: dbms_sql.close_cursor(l_sql_cursor);
2172: -- Close cursor.
2173: --
2174: dbms_sql.close_cursor(l_sql_cursor);
2175: --
2176: hr_utility.set_location('hr_delete.delete_bg_misc',11);
2177: --
2178: --
2179: else
2180: close fsp_table_name;
2178: --
2179: else
2180: close fsp_table_name;
2181: --
2182: hr_utility.set_location('hr_delete.delete_bg_misc',12);
2183: end if;
2184: end delete_bg_misc;
2185: --
2186: PROCEDURE delete_upg_details(p_business_group_id NUMBER)
2187: IS
2188: --
2189: begin
2190: --
2191: hr_utility.set_location('hr_delete.p_business_group_id',1);
2192: --
2193: delete from pay_upgrade_status
2194: where business_group_id = p_business_group_id;
2195: --
2192: --
2193: delete from pay_upgrade_status
2194: where business_group_id = p_business_group_id;
2195: --
2196: hr_utility.set_location('hr_delete.p_business_group_id',2);
2197: --
2198: end delete_upg_details;
2199: --
2200: -- ----------------------------------------------------------------------------
2215: WHERE pp.person_id = pl.person_id
2216: AND pp.business_group_id = p_business_group_id;
2217: BEGIN
2218: --
2219: hr_utility.set_location(l_proc,20);
2220: --
2221: DELETE FROM pay_security_payrolls psp
2222: WHERE psp.business_group_id = p_business_group_id;
2223: hr_utility.set_location(l_proc,30);
2219: hr_utility.set_location(l_proc,20);
2220: --
2221: DELETE FROM pay_security_payrolls psp
2222: WHERE psp.business_group_id = p_business_group_id;
2223: hr_utility.set_location(l_proc,30);
2224: --
2225: DELETE FROM pay_payroll_list ppl
2226: WHERE EXISTS ( SELECT ''
2227: FROM pay_payrolls_f pay
2226: WHERE EXISTS ( SELECT ''
2227: FROM pay_payrolls_f pay
2228: WHERE pay.payroll_id = ppl.payroll_id
2229: AND pay.business_group_id = p_business_group_id);
2230: hr_utility.set_location(l_proc,40);
2231: --
2232: FOR pevrec IN pev LOOP
2233: DELETE FROM per_person_list pl
2234: WHERE pl.person_id = pevrec.person_id;
2232: FOR pevrec IN pev LOOP
2233: DELETE FROM per_person_list pl
2234: WHERE pl.person_id = pevrec.person_id;
2235: END LOOP;
2236: hr_utility.set_location(l_proc,50);
2237: --
2238: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
2239: --
2240: DELETE FROM per_position_list pol
2242: FROM hr_all_positions_f pos
2243: WHERE pos.position_id = pol.position_id
2244: AND pos.business_group_id = p_business_group_id);
2245: --
2246: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);
2247:
2248: -- Bug fix 3622082.
2249: -- Delete statement modified to improve performance.
2250:
2252: WHERE ol.organization_id IN ( SELECT ou.organization_id
2253: FROM hr_all_organization_units ou
2254: WHERE ou.business_group_id = p_business_group_id);
2255: --
2256: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
2257: DELETE FROM per_security_profiles psp
2258: WHERE psp.business_group_id = p_business_group_id
2259: AND psp.view_all_flag = 'N';
2260: --
2257: DELETE FROM per_security_profiles psp
2258: WHERE psp.business_group_id = p_business_group_id
2259: AND psp.view_all_flag = 'N';
2260: --
2261: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
2262: DELETE FROM per_security_organizations pso
2263: WHERE pso.organization_id IN ( SELECT ou.organization_id
2264: FROM hr_all_organization_units ou
2265: WHERE ou.business_group_id = p_business_group_id);
2263: WHERE pso.organization_id IN ( SELECT ou.organization_id
2264: FROM hr_all_organization_units ou
2265: WHERE ou.business_group_id = p_business_group_id);
2266: --
2267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
2268: DELETE FROM per_security_users psu
2269: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
2270: FROM per_security_profiles sp
2271: WHERE sp.business_group_id = p_business_group_id);
2286: --
2287: l_exists varchar2(1);
2288: --
2289: begin
2290: hr_utility.set_location('Entering: '||l_proc,5);
2291: delete_run_types(p_business_group_id);
2292: --
2293: hr_utility.set_location(l_proc,10);
2294: delete_security_list_for_bg(p_business_group_id);
2289: begin
2290: hr_utility.set_location('Entering: '||l_proc,5);
2291: delete_run_types(p_business_group_id);
2292: --
2293: hr_utility.set_location(l_proc,10);
2294: delete_security_list_for_bg(p_business_group_id);
2295: hr_utility.set_location(l_proc,20);
2296: --
2297: delete_retro_details(p_business_group_id);
2291: delete_run_types(p_business_group_id);
2292: --
2293: hr_utility.set_location(l_proc,10);
2294: delete_security_list_for_bg(p_business_group_id);
2295: hr_utility.set_location(l_proc,20);
2296: --
2297: delete_retro_details(p_business_group_id);
2298: hr_utility.set_location(l_proc,25);
2299: --
2294: delete_security_list_for_bg(p_business_group_id);
2295: hr_utility.set_location(l_proc,20);
2296: --
2297: delete_retro_details(p_business_group_id);
2298: hr_utility.set_location(l_proc,25);
2299: --
2300: delete_mag_structure(p_business_group_id);
2301: hr_utility.set_location(l_proc,30);
2302: --
2297: delete_retro_details(p_business_group_id);
2298: hr_utility.set_location(l_proc,25);
2299: --
2300: delete_mag_structure(p_business_group_id);
2301: hr_utility.set_location(l_proc,30);
2302: --
2303: delete_bal_load_struct(p_business_group_id);
2304: hr_utility.set_location(l_proc,40);
2305: --
2300: delete_mag_structure(p_business_group_id);
2301: hr_utility.set_location(l_proc,30);
2302: --
2303: delete_bal_load_struct(p_business_group_id);
2304: hr_utility.set_location(l_proc,40);
2305: --
2306: delete_formula_direct(p_business_group_id);
2307: hr_utility.set_location(l_proc,50);
2308: --
2303: delete_bal_load_struct(p_business_group_id);
2304: hr_utility.set_location(l_proc,40);
2305: --
2306: delete_formula_direct(p_business_group_id);
2307: hr_utility.set_location(l_proc,50);
2308: --
2309: delete_assign_low_detail(p_business_group_id);
2310: hr_utility.set_location(l_proc,60);
2311: --
2306: delete_formula_direct(p_business_group_id);
2307: hr_utility.set_location(l_proc,50);
2308: --
2309: delete_assign_low_detail(p_business_group_id);
2310: hr_utility.set_location(l_proc,60);
2311: --
2312: delete_assign_detail(p_business_group_id);
2313: hr_utility.set_location(l_proc,70);
2314: --
2309: delete_assign_low_detail(p_business_group_id);
2310: hr_utility.set_location(l_proc,60);
2311: --
2312: delete_assign_detail(p_business_group_id);
2313: hr_utility.set_location(l_proc,70);
2314: --
2315: delete_database_items(p_business_group_id);
2316: hr_utility.set_location(l_proc,80);
2317: --
2312: delete_assign_detail(p_business_group_id);
2313: hr_utility.set_location(l_proc,70);
2314: --
2315: delete_database_items(p_business_group_id);
2316: hr_utility.set_location(l_proc,80);
2317: --
2318: delete_assign_direct(p_business_group_id);
2319: hr_utility.set_location(l_proc,90);
2320: --
2315: delete_database_items(p_business_group_id);
2316: hr_utility.set_location(l_proc,80);
2317: --
2318: delete_assign_direct(p_business_group_id);
2319: hr_utility.set_location(l_proc,90);
2320: --
2321: delete_grade_direct(p_business_group_id);
2322: hr_utility.set_location(l_proc,100);
2323: --
2318: delete_assign_direct(p_business_group_id);
2319: hr_utility.set_location(l_proc,90);
2320: --
2321: delete_grade_direct(p_business_group_id);
2322: hr_utility.set_location(l_proc,100);
2323: --
2324: delete_job_direct(p_business_group_id);
2325: hr_utility.set_location(l_proc,110);
2326: --
2321: delete_grade_direct(p_business_group_id);
2322: hr_utility.set_location(l_proc,100);
2323: --
2324: delete_job_direct(p_business_group_id);
2325: hr_utility.set_location(l_proc,110);
2326: --
2327: delete_person_direct(p_business_group_id);
2328: hr_utility.set_location(l_proc,140);
2329: --
2324: delete_job_direct(p_business_group_id);
2325: hr_utility.set_location(l_proc,110);
2326: --
2327: delete_person_direct(p_business_group_id);
2328: hr_utility.set_location(l_proc,140);
2329: --
2330: delete_per_misc(p_business_group_id);
2331: hr_utility.set_location(l_proc,150);
2332: --
2327: delete_person_direct(p_business_group_id);
2328: hr_utility.set_location(l_proc,140);
2329: --
2330: delete_per_misc(p_business_group_id);
2331: hr_utility.set_location(l_proc,150);
2332: --
2333: delete_element_direct(p_business_group_id);
2334: hr_utility.set_location(l_proc,160);
2335: --
2330: delete_per_misc(p_business_group_id);
2331: hr_utility.set_location(l_proc,150);
2332: --
2333: delete_element_direct(p_business_group_id);
2334: hr_utility.set_location(l_proc,160);
2335: --
2336: delete_org_low_detail(p_business_group_id);
2337: hr_utility.set_location(l_proc,170);
2338: --
2333: delete_element_direct(p_business_group_id);
2334: hr_utility.set_location(l_proc,160);
2335: --
2336: delete_org_low_detail(p_business_group_id);
2337: hr_utility.set_location(l_proc,170);
2338: --
2339: delete_org_detail(p_business_group_id);
2340: hr_utility.set_location(l_proc,180);
2341: --
2336: delete_org_low_detail(p_business_group_id);
2337: hr_utility.set_location(l_proc,170);
2338: --
2339: delete_org_detail(p_business_group_id);
2340: hr_utility.set_location(l_proc,180);
2341: --
2342: delete_time_def_direct(p_business_group_id);
2343: hr_utility.set_location(l_proc,185);
2344: --
2339: delete_org_detail(p_business_group_id);
2340: hr_utility.set_location(l_proc,180);
2341: --
2342: delete_time_def_direct(p_business_group_id);
2343: hr_utility.set_location(l_proc,185);
2344: --
2345: delete_payroll_direct(p_business_group_id);
2346: hr_utility.set_location(l_proc,190);
2347: --
2342: delete_time_def_direct(p_business_group_id);
2343: hr_utility.set_location(l_proc,185);
2344: --
2345: delete_payroll_direct(p_business_group_id);
2346: hr_utility.set_location(l_proc,190);
2347: --
2348: delete_balance_direct(p_business_group_id);
2349: hr_utility.set_location(l_proc,200);
2350: --
2345: delete_payroll_direct(p_business_group_id);
2346: hr_utility.set_location(l_proc,190);
2347: --
2348: delete_balance_direct(p_business_group_id);
2349: hr_utility.set_location(l_proc,200);
2350: --
2351: delete_pay_misc(p_business_group_id);
2352: hr_utility.set_location(l_proc,210);
2353: --
2348: delete_balance_direct(p_business_group_id);
2349: hr_utility.set_location(l_proc,200);
2350: --
2351: delete_pay_misc(p_business_group_id);
2352: hr_utility.set_location(l_proc,210);
2353: --
2354: delete_qun_misc(p_business_group_id);
2355: hr_utility.set_location(l_proc,215);
2356: --
2351: delete_pay_misc(p_business_group_id);
2352: hr_utility.set_location(l_proc,210);
2353: --
2354: delete_qun_misc(p_business_group_id);
2355: hr_utility.set_location(l_proc,215);
2356: --
2357: delete_upg_details(p_business_group_id);
2358: hr_utility.set_location(l_proc,217);
2359: --
2354: delete_qun_misc(p_business_group_id);
2355: hr_utility.set_location(l_proc,215);
2356: --
2357: delete_upg_details(p_business_group_id);
2358: hr_utility.set_location(l_proc,217);
2359: --
2360: -- Caller can choose not to delete business group info.
2361: if p_preserve_org_information = 'N' then
2362: delete_org_direct(p_business_group_id,
2360: -- Caller can choose not to delete business group info.
2361: if p_preserve_org_information = 'N' then
2362: delete_org_direct(p_business_group_id,
2363: p_rt_running);
2364: hr_utility.set_location(l_proc,220);
2365: end if;
2366: hr_utility.set_location(l_proc,230);
2367: --
2368: delete_bg_misc(p_business_group_id);
2362: delete_org_direct(p_business_group_id,
2363: p_rt_running);
2364: hr_utility.set_location(l_proc,220);
2365: end if;
2366: hr_utility.set_location(l_proc,230);
2367: --
2368: delete_bg_misc(p_business_group_id);
2369: hr_utility.set_location('Leaving: '||l_proc,230);
2370: end delete_below_bg;
2365: end if;
2366: hr_utility.set_location(l_proc,230);
2367: --
2368: delete_bg_misc(p_business_group_id);
2369: hr_utility.set_location('Leaving: '||l_proc,230);
2370: end delete_below_bg;
2371: --
2372: --
2373: end hr_delete;