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.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BATCH_UTILS

Line 94: ben_batch_utils.write(p_text => 'PER_CONTACT_RELATIOSHSHIPS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

90: and a.person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
91: from per_all_people_f ppf );
92: --
93:
94: ben_batch_utils.write(p_text => 'PER_CONTACT_RELATIOSHSHIPS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
95: --
96: hr_utility.set_location ('Leaving ' || l_proc, 10);
97: --
98: end delete_per_con;

Line 124: ben_batch_utils.write(p_text => 'BEN_CBR_QUALD_BNF : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

120: FROM per_all_people_f per
121: WHERE per.person_id = a.cvrd_emp_person_id);
122: --
123: --
124: ben_batch_utils.write(p_text => 'BEN_CBR_QUALD_BNF : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
125:
126: hr_utility.set_location ('Leaving ' || l_proc, 10);
127: --
128: end delete_cbr_quald_bnf;

Line 152: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

148: DELETE FROM ben_crt_ordr a
149: WHERE NOT EXISTS (SELECT 1
150: FROM per_all_people_f per
151: WHERE per.person_id = a.person_id);
152: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
153: --
154: hr_utility.set_location ('Leaving ' || l_proc, 10);
155: --
156: end delete_crt_ordr;

Line 180: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR_CVRD_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

176: DELETE FROM ben_crt_ordr_cvrd_per a
177: WHERE NOT EXISTS (SELECT 1
178: FROM per_all_people_f per
179: WHERE per.person_id = a.person_id);
180: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR_CVRD_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
181: --
182: hr_utility.set_location ('Leaving ' || l_proc, 10);
183: --
184: end delete_crt_ordr_cvrd_per;

Line 208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a
205: WHERE a.dpnt_person_id IS NOT NULL
206: AND a.dpnt_person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
207: FROM per_all_people_f per);
208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
209: --
210: hr_utility.set_location ('Leaving ' || l_proc, 10);
211: --
212: end delete_elig_dpnt;

Line 236: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a
233: WHERE a.person_id IS NOT NULL
234: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
235: FROM per_all_people_f per);
236: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
237: --
238: hr_utility.set_location ('Leaving ' || l_proc, 10);
239: --
240: end delete_elig_per_f;

Line 264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a
261: WHERE a.person_id IS NOT NULL
262: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
263: FROM per_all_people_f per);
264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
265: --
266: hr_utility.set_location ('Leaving ' || l_proc, 10);
267: --
268: end delete_ext_chg_evt_log;

Line 293: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_DTL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

289: WHERE a.person_id IS NOT NULL
290: AND a.person_id NOT IN (0, 999999999999)
291: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
292: FROM per_all_people_f per);
293: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_DTL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
294: --
295: hr_utility.set_location ('Leaving ' || l_proc, 10);
296: --
297: end delete_ext_rslt_dtl;

Line 321: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_ERR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a
318: WHERE a.person_id IS NOT NULL
319: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
320: FROM per_all_people_f per);
321: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_ERR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
322: --
323: hr_utility.set_location ('Leaving ' || l_proc, 10);
324: --
325: end delete_ext_rslt_err;

Line 349: ben_batch_utils.write(p_text => 'BEN_LE_CLSN_N_RSTR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a
346: WHERE a.person_id IS NOT NULL
347: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
348: FROM per_all_people_f per);
349: ben_batch_utils.write(p_text => 'BEN_LE_CLSN_N_RSTR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
350: --
351: hr_utility.set_location ('Leaving ' || l_proc, 10);
352: --
353: end delete_le_clsn_n_rstr;

Line 377: ben_batch_utils.write(p_text => 'BEN_PERSON_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a
374: WHERE a.person_id IS NOT NULL
375: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
376: FROM per_all_people_f per);
377: ben_batch_utils.write(p_text => 'BEN_PERSON_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
378: --
379: hr_utility.set_location ('Leaving ' || l_proc, 10);
380: --
381: end delete_person_actions;

Line 405: ben_batch_utils.write(p_text => 'BEN_PER_BNFTS_BAL_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

401: DELETE FROM ben_per_bnfts_bal_f a
402: WHERE NOT EXISTS (SELECT 1
403: FROM per_all_people_f per
404: WHERE per.person_id = a.person_id);
405: ben_batch_utils.write(p_text => 'BEN_PER_BNFTS_BAL_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
406: --
407: hr_utility.set_location ('Leaving ' || l_proc, 10);
408: --
409: end delete_per_bnfts_bal_f;

Line 433: ben_batch_utils.write(p_text => 'BEN_PER_DLVRY_MTHD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

429: DELETE FROM ben_per_dlvry_mthd_f a
430: WHERE NOT EXISTS (SELECT 1
431: FROM per_all_people_f per
432: WHERE per.person_id = a.person_id);
433: ben_batch_utils.write(p_text => 'BEN_PER_DLVRY_MTHD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
434: --
435: hr_utility.set_location ('Leaving ' || l_proc, 10);
436: --
437: end delete_per_dlvry_mthd_f;

Line 461: ben_batch_utils.write(p_text => 'BEN_PER_PIN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

457: DELETE FROM ben_per_pin_f a
458: WHERE NOT EXISTS (SELECT 1
459: FROM per_all_people_f per
460: WHERE per.person_id = a.person_id);
461: ben_batch_utils.write(p_text => 'BEN_PER_PIN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
462: --
463: hr_utility.set_location ('Leaving ' || l_proc, 10);
464: --
465: end delete_per_pin_f;

Line 491: ben_batch_utils.write(p_text => 'BEN_PL_BNF_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

487: SELECT 1
488: FROM per_all_people_f per
489: WHERE per.person_id = a.bnf_person_id
490: OR per.person_id = a.ttee_person_id);
491: ben_batch_utils.write(p_text => 'BEN_PL_BNF_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
492: --
493: hr_utility.set_location ('Leaving ' || l_proc, 10);
494: --
495: end delete_pl_bnf_f;

Line 523: ben_batch_utils.write(p_text => 'BEN_PRTT_REIMBMT_RQST_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

519: WHERE per.person_id = a.submitter_person_id
520: OR per.person_id = a.recipient_person_id
521: OR per.person_id = a.provider_person_id
522: OR per.person_id = a.provider_ssn_person_id);
523: ben_batch_utils.write(p_text => 'BEN_PRTT_REIMBMT_RQST_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
524: --
525: hr_utility.set_location ('Leaving ' || l_proc, 10);
526: --
527: end delete_prtt_reimbmt_rqst_f;

Line 551: ben_batch_utils.write(p_text => 'BEN_PTNL_LER_FOR_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a
548: WHERE a.person_id IS NOT NULL
549: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
550: FROM per_all_people_f per);
551: ben_batch_utils.write(p_text => 'BEN_PTNL_LER_FOR_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
552: --
553: hr_utility.set_location ('Leaving ' || l_proc, 10);
554: --
555: end delete_ptnl_ler_for_per;

Line 606: ben_batch_utils.write(p_text => 'BEN_BATCH_ACTN_ITEM_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

602: FORALL i IN 1..l_data.COUNT
603: DELETE FROM BEN_BATCH_ACTN_ITEM_INFO
604: WHERE benefit_action_id = l_data(i);
605: --
606: ben_batch_utils.write(p_text => 'BEN_BATCH_ACTN_ITEM_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
607: --
608: FORALL i IN 1..l_data.COUNT
609: DELETE FROM BEN_BATCH_BNFT_CERT_INFO
610: WHERE benefit_action_id = l_data(i);

Line 612: ben_batch_utils.write(p_text => 'BEN_BATCH_BNFT_CERT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

608: FORALL i IN 1..l_data.COUNT
609: DELETE FROM BEN_BATCH_BNFT_CERT_INFO
610: WHERE benefit_action_id = l_data(i);
611: --
612: ben_batch_utils.write(p_text => 'BEN_BATCH_BNFT_CERT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
613: --
614: FORALL i IN 1..l_data.COUNT
615: DELETE FROM BEN_BATCH_COMMU_INFO
616: WHERE benefit_action_id = l_data(i);

Line 618: ben_batch_utils.write(p_text => 'BEN_BATCH_COMMU_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

614: FORALL i IN 1..l_data.COUNT
615: DELETE FROM BEN_BATCH_COMMU_INFO
616: WHERE benefit_action_id = l_data(i);
617: --
618: ben_batch_utils.write(p_text => 'BEN_BATCH_COMMU_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
619: --
620: FORALL i IN 1..l_data.COUNT
621: DELETE FROM BEN_BATCH_DPNT_INFO
622: WHERE benefit_action_id = l_data(i);

Line 624: ben_batch_utils.write(p_text => 'BEN_BATCH_DPNT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

620: FORALL i IN 1..l_data.COUNT
621: DELETE FROM BEN_BATCH_DPNT_INFO
622: WHERE benefit_action_id = l_data(i);
623: --
624: ben_batch_utils.write(p_text => 'BEN_BATCH_DPNT_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
625: --
626: FORALL i IN 1..l_data.COUNT
627: DELETE FROM BEN_BATCH_ELCTBL_CHC_INFO
628: WHERE benefit_action_id = l_data(i);

Line 630: ben_batch_utils.write(p_text => 'BEN_BATCH_ELCTBL_CHC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

626: FORALL i IN 1..l_data.COUNT
627: DELETE FROM BEN_BATCH_ELCTBL_CHC_INFO
628: WHERE benefit_action_id = l_data(i);
629: --
630: ben_batch_utils.write(p_text => 'BEN_BATCH_ELCTBL_CHC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
631: --
632: FORALL i IN 1..l_data.COUNT
633: DELETE FROM BEN_BATCH_ELIG_INFO
634: WHERE benefit_action_id = l_data(i);

Line 636: ben_batch_utils.write(p_text => 'BEN_BATCH_ELIG_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

632: FORALL i IN 1..l_data.COUNT
633: DELETE FROM BEN_BATCH_ELIG_INFO
634: WHERE benefit_action_id = l_data(i);
635: --
636: ben_batch_utils.write(p_text => 'BEN_BATCH_ELIG_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
637: --
638: FORALL i IN 1..l_data.COUNT
639: DELETE FROM BEN_BATCH_LER_INFO
640: WHERE benefit_action_id = l_data(i);

Line 642: ben_batch_utils.write(p_text => 'BEN_BATCH_LER_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

638: FORALL i IN 1..l_data.COUNT
639: DELETE FROM BEN_BATCH_LER_INFO
640: WHERE benefit_action_id = l_data(i);
641: --
642: ben_batch_utils.write(p_text => 'BEN_BATCH_LER_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
643: --
644: FORALL i IN 1..l_data.COUNT
645: DELETE FROM BEN_BATCH_RATE_INFO
646: WHERE benefit_action_id = l_data(i);

Line 648: ben_batch_utils.write(p_text => 'BEN_BATCH_RATE_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

644: FORALL i IN 1..l_data.COUNT
645: DELETE FROM BEN_BATCH_RATE_INFO
646: WHERE benefit_action_id = l_data(i);
647: --
648: ben_batch_utils.write(p_text => 'BEN_BATCH_RATE_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
649: --
650: FORALL i IN 1..l_data.COUNT
651: DELETE FROM BEN_BATCH_PROC_INFO
652: WHERE benefit_action_id = l_data(i);

Line 654: ben_batch_utils.write(p_text => 'BEN_BATCH_PROC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

650: FORALL i IN 1..l_data.COUNT
651: DELETE FROM BEN_BATCH_PROC_INFO
652: WHERE benefit_action_id = l_data(i);
653: --
654: ben_batch_utils.write(p_text => 'BEN_BATCH_PROC_INFO : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
655: --
656: FORALL i IN 1..l_data.COUNT
657: DELETE FROM BEN_BATCH_RANGES
658: WHERE benefit_action_id = l_data(i);

Line 660: ben_batch_utils.write(p_text => 'BEN_BATCH_RANGES : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

656: FORALL i IN 1..l_data.COUNT
657: DELETE FROM BEN_BATCH_RANGES
658: WHERE benefit_action_id = l_data(i);
659: --
660: ben_batch_utils.write(p_text => 'BEN_BATCH_RANGES : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
661: --
662: FORALL i IN 1..l_data.COUNT
663: DELETE FROM BEN_REPORTING
664: WHERE benefit_action_id = l_data(i);

Line 666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

662: FORALL i IN 1..l_data.COUNT
663: DELETE FROM BEN_REPORTING
664: WHERE benefit_action_id = l_data(i);
665: --
666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
667: --
668: FORALL i IN 1..l_data.COUNT
669: DELETE FROM ben_benefit_actions
670: WHERE benefit_action_id = l_data(i);

Line 672: ben_batch_utils.write(p_text => 'BEN_BENEFIT_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

668: FORALL i IN 1..l_data.COUNT
669: DELETE FROM ben_benefit_actions
670: WHERE benefit_action_id = l_data(i);
671: --
672: ben_batch_utils.write(p_text => 'BEN_BENEFIT_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
673: --
674: EXIT WHEN c1%NOTFOUND;
675: --
676: end loop;

Line 733: ben_batch_utils.write(p_text => 'BEN_BNFT_PRVDD_LDGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

729: FORALL i IN 1..l_data.COUNT
730: DELETE FROM BEN_BNFT_PRVDD_LDGR_F
731: WHERE PER_IN_LER_ID = l_data(i);
732: --
733: ben_batch_utils.write(p_text => 'BEN_BNFT_PRVDD_LDGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
734: --
735: FORALL i IN 1..l_data.COUNT
736: DELETE FROM BEN_CBR_PER_IN_LER
737: WHERE PER_IN_LER_ID = l_data(i);

Line 739: ben_batch_utils.write(p_text => 'BEN_CBR_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

735: FORALL i IN 1..l_data.COUNT
736: DELETE FROM BEN_CBR_PER_IN_LER
737: WHERE PER_IN_LER_ID = l_data(i);
738: --
739: ben_batch_utils.write(p_text => 'BEN_CBR_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
740: --
741: FORALL i IN 1..l_data.COUNT
742: DELETE FROM BEN_ELIG_PER_OPT_F
743: WHERE PER_IN_LER_ID = l_data(i);

Line 745: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_OPT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

741: FORALL i IN 1..l_data.COUNT
742: DELETE FROM BEN_ELIG_PER_OPT_F
743: WHERE PER_IN_LER_ID = l_data(i);
744: --
745: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_OPT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
746: --
747: FORALL i IN 1..l_data.COUNT
748: delete from BEN_ELIG_DPNT a
749: where PER_IN_LER_ID = l_data(i);

Line 751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

747: FORALL i IN 1..l_data.COUNT
748: delete from BEN_ELIG_DPNT a
749: where PER_IN_LER_ID = l_data(i);
750: --
751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
752: --
753: FORALL i IN 1..l_data.COUNT
754: delete from BEN_PIL_ELCTBL_CHC_POPL a
755: where PER_IN_LER_ID = l_data(i);

Line 757: ben_batch_utils.write(p_text => 'BEN_PIL_ELCTBL_CHC_POPL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

753: FORALL i IN 1..l_data.COUNT
754: delete from BEN_PIL_ELCTBL_CHC_POPL a
755: where PER_IN_LER_ID = l_data(i);
756: --
757: ben_batch_utils.write(p_text => 'BEN_PIL_ELCTBL_CHC_POPL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
758: --
759: FORALL i IN 1..l_data.COUNT
760: delete from BEN_ENRT_RT
761: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID

Line 765: ben_batch_utils.write(p_text => 'BEN_ENRT_RT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

761: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
762: from BEN_ELIG_PER_ELCTBL_CHC a
763: where a.PER_IN_LER_ID = l_data(i) );
764: --
765: ben_batch_utils.write(p_text => 'BEN_ENRT_RT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
766: --
767: FORALL i IN 1..l_data.COUNT
768: delete from BEN_PRTT_PREM_BY_MO_F
769: where PRTT_PREM_ID IN ( select PRTT_PREM_ID

Line 773: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_BY_MO_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

769: where PRTT_PREM_ID IN ( select PRTT_PREM_ID
770: from BEN_PRTT_PREM_F a
771: where a.PER_IN_LER_ID = l_data(i) );
772: --
773: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_BY_MO_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
774: --
775: FORALL i IN 1..l_data.COUNT
776: delete from BEN_PRTT_PREM_F a
777: where PER_IN_LER_ID = l_data(i);

Line 779: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

775: FORALL i IN 1..l_data.COUNT
776: delete from BEN_PRTT_PREM_F a
777: where PER_IN_LER_ID = l_data(i);
778: --
779: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
780: --
781: FORALL i IN 1..l_data.COUNT
782: delete from BEN_ENRT_PREM
783: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID

Line 787: ben_batch_utils.write(p_text => 'BEN_ENRT_PREM : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

783: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
784: from BEN_ELIG_PER_ELCTBL_CHC a
785: where a.PER_IN_LER_ID = l_data(i) );
786: --
787: ben_batch_utils.write(p_text => 'BEN_ENRT_PREM : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
788: --
789: FORALL i IN 1..l_data.COUNT
790: delete from BEN_ENRT_BNFT
791: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID

Line 795: ben_batch_utils.write(p_text => 'BEN_ENRT_BNFT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

791: where ELIG_PER_ELCTBL_CHC_ID in ( select ELIG_PER_ELCTBL_CHC_ID
792: from BEN_ELIG_PER_ELCTBL_CHC a
793: where a.PER_IN_LER_ID = l_data(i) );
794: --
795: ben_batch_utils.write(p_text => 'BEN_ENRT_BNFT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
796: --
797: FORALL i IN 1..l_data.COUNT
798: delete from BEN_ELIG_PER_ELCTBL_CHC a
799: where PER_IN_LER_ID = l_data(i) ;

Line 801: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_ELCTBL_CHC : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

797: FORALL i IN 1..l_data.COUNT
798: delete from BEN_ELIG_PER_ELCTBL_CHC a
799: where PER_IN_LER_ID = l_data(i) ;
800: --
801: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_ELCTBL_CHC : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
802: --
803: FORALL i IN 1..l_data.COUNT
804: DELETE FROM BEN_PER_IN_LER
805: WHERE PER_IN_LER_ID = l_data(i) ;

Line 807: ben_batch_utils.write(p_text => 'BEN_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

803: FORALL i IN 1..l_data.COUNT
804: DELETE FROM BEN_PER_IN_LER
805: WHERE PER_IN_LER_ID = l_data(i) ;
806: --
807: ben_batch_utils.write(p_text => 'BEN_PER_IN_LER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
808: --
809: EXIT WHEN c2%NOTFOUND;
810: --
811: end loop;

Line 862: ben_batch_utils.write(p_text => 'BEN_PRMRY_CARE_PRVDR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

858: FORALL i IN 1..l_data.COUNT
859: DELETE FROM BEN_PRMRY_CARE_PRVDR_F
860: WHERE prtt_enrt_rslt_id = l_data(i);
861: --
862: ben_batch_utils.write(p_text => 'BEN_PRMRY_CARE_PRVDR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
863: --
864: FORALL i IN 1..l_data.COUNT
865: DELETE FROM BEN_PRTT_ENRT_ACTN_F
866: WHERE prtt_enrt_rslt_id = l_data(i);

Line 868: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_ACTN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

864: FORALL i IN 1..l_data.COUNT
865: DELETE FROM BEN_PRTT_ENRT_ACTN_F
866: WHERE prtt_enrt_rslt_id = l_data(i);
867: --
868: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_ACTN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
869: --
870: FORALL i IN 1..l_data.COUNT
871: DELETE FROM BEN_PRTT_ENRT_CTFN_PRVDD_F
872: WHERE prtt_enrt_rslt_id = l_data(i);

Line 874: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

870: FORALL i IN 1..l_data.COUNT
871: DELETE FROM BEN_PRTT_ENRT_CTFN_PRVDD_F
872: WHERE prtt_enrt_rslt_id = l_data(i);
873: --
874: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
875: --
876: FORALL i IN 1..l_data.COUNT
877: DELETE FROM BEN_PRTT_PREM_F
878: WHERE prtt_enrt_rslt_id = l_data(i);

Line 880: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

876: FORALL i IN 1..l_data.COUNT
877: DELETE FROM BEN_PRTT_PREM_F
878: WHERE prtt_enrt_rslt_id = l_data(i);
879: --
880: ben_batch_utils.write(p_text => 'BEN_PRTT_PREM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
881: --
882: FORALL i IN 1..l_data.COUNT
883: DELETE FROM BEN_PRTT_RT_VAL
884: WHERE prtt_enrt_rslt_id = l_data(i);

Line 886: ben_batch_utils.write(p_text => 'BEN_PRTT_RT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

882: FORALL i IN 1..l_data.COUNT
883: DELETE FROM BEN_PRTT_RT_VAL
884: WHERE prtt_enrt_rslt_id = l_data(i);
885: --
886: ben_batch_utils.write(p_text => 'BEN_PRTT_RT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
887: --
888: FORALL i IN 1..l_data.COUNT
889: DELETE FROM BEN_PRTT_ENRT_RSLT_F
890: WHERE prtt_enrt_rslt_id = l_data(i);

Line 892: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_RSLT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

888: FORALL i IN 1..l_data.COUNT
889: DELETE FROM BEN_PRTT_ENRT_RSLT_F
890: WHERE prtt_enrt_rslt_id = l_data(i);
891: --
892: ben_batch_utils.write(p_text => 'BEN_PRTT_ENRT_RSLT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
893: --
894: EXIT WHEN c3%NOTFOUND;
895: --
896: end loop;

Line 944: ben_batch_utils.write(p_text => 'BEN_CVRD_DPNT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

940: FORALL i IN 1..l_data.COUNT
941: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
942: WHERE elig_cvrd_dpnt_id = l_data (i);
943: --
944: ben_batch_utils.write(p_text => 'BEN_CVRD_DPNT_CTFN_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
945: --
946: FORALL i IN 1..l_data.COUNT
947: DELETE FROM ben_ext_crit_val
948: WHERE ext_crit_val_id IN (

Line 955: ben_batch_utils.write(p_text => 'BEN_EXT_CRIT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

951: WHERE typ.crit_typ_cd = 'PID'
952: AND val.ext_crit_typ_id = typ.ext_crit_typ_id
953: AND val.val_1 = TO_CHAR (l_data (i)));
954: --
955: ben_batch_utils.write(p_text => 'BEN_EXT_CRIT_VAL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
956: --
957: FORALL i IN 1..l_data.COUNT
958: DELETE FROM ben_elig_cvrd_dpnt_f
959: WHERE elig_cvrd_dpnt_id = l_data (i);

Line 961: ben_batch_utils.write(p_text => 'BEN_ELIG_CVRD_DPNT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

957: FORALL i IN 1..l_data.COUNT
958: DELETE FROM ben_elig_cvrd_dpnt_f
959: WHERE elig_cvrd_dpnt_id = l_data (i);
960: --
961: ben_batch_utils.write(p_text => 'BEN_ELIG_CVRD_DPNT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
962: --
963: EXIT WHEN c4%NOTFOUND;
964: --
965: end loop;

Line 1014: ben_batch_utils.write(p_text => 'BEN_PER_CM_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

1010: FORALL i IN 1..l_data.COUNT
1011: delete FROM ben_per_cm_prvdd_f
1012: WHERE per_cm_id = l_data(i) ;
1013: --
1014: ben_batch_utils.write(p_text => 'BEN_PER_CM_PRVDD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1015: --
1016: FORALL i IN 1..l_data.COUNT
1017: delete FROM ben_per_cm_trgr_f
1018: WHERE per_cm_id = l_data(i) ;

Line 1020: ben_batch_utils.write(p_text => 'BEN_PER_CM_TRGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

1016: FORALL i IN 1..l_data.COUNT
1017: delete FROM ben_per_cm_trgr_f
1018: WHERE per_cm_id = l_data(i) ;
1019: --
1020: ben_batch_utils.write(p_text => 'BEN_PER_CM_TRGR_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1021: --
1022: FORALL i IN 1..l_data.COUNT
1023: delete FROM ben_per_cm_usg_f
1024: WHERE per_cm_id = l_data(i) ;

Line 1026: ben_batch_utils.write(p_text => 'BEN_PER_CM_USG_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

1022: FORALL i IN 1..l_data.COUNT
1023: delete FROM ben_per_cm_usg_f
1024: WHERE per_cm_id = l_data(i) ;
1025: --
1026: ben_batch_utils.write(p_text => 'BEN_PER_CM_USG_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1027: --
1028: FORALL i IN 1..l_data.COUNT
1029: delete FROM ben_per_cm_f
1030: WHERE per_cm_id = l_data(i) ;

Line 1032: ben_batch_utils.write(p_text => 'BEN_PER_CM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

1028: FORALL i IN 1..l_data.COUNT
1029: delete FROM ben_per_cm_f
1030: WHERE per_cm_id = l_data(i) ;
1031: --
1032: ben_batch_utils.write(p_text => 'BEN_PER_CM_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
1033: --
1034: EXIT WHEN c5%NOTFOUND;
1035: --
1036: end loop;

Line 1071: ben_batch_utils.write(p_text => l_title_text);

1067: l_title_text := 'Number of rows deleted from the following tables :';
1068: --
1069: if p_thread_id = 1 then
1070: --
1071: ben_batch_utils.write(p_text => l_title_text);
1072: --
1073: delete_elig_per_f;
1074: delete_cbr_quald_bnf;
1075: delete_crt_ordr;

Line 1080: ben_batch_utils.write(p_text => l_title_text);

1076: delete_crt_ordr_cvrd_per ;
1077: --
1078: elsif p_thread_id = 2 then
1079: --
1080: ben_batch_utils.write(p_text => l_title_text);
1081: --
1082: delete_elig_dpnt;
1083: delete_per_dlvry_mthd_f ;
1084: delete_pl_bnf_f;

Line 1089: ben_batch_utils.write(p_text => l_title_text);

1085: delete_per_pin_f ;
1086: --
1087: elsif p_thread_id = 3 then
1088: --
1089: ben_batch_utils.write(p_text => l_title_text);
1090: --
1091: delete_ext_rslt_dtl ;
1092: delete_per_bnfts_bal_f ;
1093: delete_prtt_reimbmt_rqst_f;

Line 1097: ben_batch_utils.write(p_text => l_title_text);

1093: delete_prtt_reimbmt_rqst_f;
1094: --
1095: elsif p_thread_id = 4 then
1096: --
1097: ben_batch_utils.write(p_text => l_title_text);
1098: --
1099: delete_ext_rslt_err;
1100: delete_person_actions;
1101: --

Line 1104: ben_batch_utils.write(p_text => l_title_text);

1100: delete_person_actions;
1101: --
1102: elsif p_thread_id = 5 then
1103: --
1104: ben_batch_utils.write(p_text => l_title_text);
1105: --
1106: delete_benefit_actions;
1107: delete_le_clsn_n_rstr;
1108: --

Line 1111: ben_batch_utils.write(p_text => l_title_text);

1107: delete_le_clsn_n_rstr;
1108: --
1109: elsif p_thread_id = 6 then
1110: --
1111: ben_batch_utils.write(p_text => l_title_text);
1112: --
1113: delete_per_in_ler;
1114: --
1115: elsif p_thread_id = 7 then

Line 1117: ben_batch_utils.write(p_text => l_title_text);

1113: delete_per_in_ler;
1114: --
1115: elsif p_thread_id = 7 then
1116: --
1117: ben_batch_utils.write(p_text => l_title_text);
1118: --
1119: delete_prtt_enrt_rslt_f;
1120: --
1121: elsif p_thread_id = 8 then

Line 1123: ben_batch_utils.write(p_text => l_title_text);

1119: delete_prtt_enrt_rslt_f;
1120: --
1121: elsif p_thread_id = 8 then
1122: --
1123: ben_batch_utils.write(p_text => l_title_text);
1124: --
1125: delete_elig_cvrd_dpnt_f;
1126: delete_ext_chg_evt_log;
1127: --

Line 1130: ben_batch_utils.write(p_text => l_title_text);

1126: delete_ext_chg_evt_log;
1127: --
1128: elsif p_thread_id = 9 then
1129: --
1130: ben_batch_utils.write(p_text => l_title_text);
1131: --
1132: delete_per_cm_f;
1133: delete_ptnl_ler_for_per;
1134: delete_per_con ;