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 HR_UTILITY

Line 31: hr_utility.set_location ('Entering ' || l_proc, 5);

27: WHERE fnd.phase_code <> 'C' AND fnd.request_id = p_request_id;
28: --
29: begin
30: --
31: hr_utility.set_location ('Entering ' || l_proc, 5);
32: --
33: While l_no_slaves loop
34: --
35: l_no_slaves := false;

Line 61: hr_utility.set_location ('Leaving ' || l_proc, 10);

57: End if;
58: --
59: End loop;
60: --
61: hr_utility.set_location ('Leaving ' || l_proc, 10);
62: --
63: end check_all_slaves_finished;
64: --
65: -- ----------------------------------------------------------------------------

Line 80: hr_utility.set_location ('Entering ' || l_proc, 5);

76: --
77: begin
78: --
79: --
80: hr_utility.set_location ('Entering ' || l_proc, 5);
81: --
82: --
83: delete /*+ parallel(a) */ from per_contact_relationships a
84: where a.contact_person_id is not null

Line 96: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
99: --
100: -- ----------------------------------------------------------------------------

Line 115: hr_utility.set_location ('Entering ' || l_proc, 5);

111: --
112: --
113: begin
114: --
115: hr_utility.set_location ('Entering ' || l_proc, 5);
116: --
117: --
118: DELETE FROM ben_cbr_quald_bnf a
119: WHERE NOT EXISTS (SELECT 1

Line 126: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
129: --
130: -- ----------------------------------------------------------------------------

Line 145: hr_utility.set_location ('Entering ' || l_proc, 5);

141: --
142: begin
143: --
144: --
145: hr_utility.set_location ('Entering ' || l_proc, 5);
146: --
147: --
148: DELETE FROM ben_crt_ordr a
149: WHERE NOT EXISTS (SELECT 1

Line 154: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
157: --
158: -- ----------------------------------------------------------------------------

Line 173: hr_utility.set_location ('Entering ' || l_proc, 5);

169: --
170: begin
171: --
172: --
173: hr_utility.set_location ('Entering ' || l_proc, 5);
174: --
175: --
176: DELETE FROM ben_crt_ordr_cvrd_per a
177: WHERE NOT EXISTS (SELECT 1

Line 182: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
185: --
186: -- ----------------------------------------------------------------------------

Line 201: hr_utility.set_location ('Entering ' || l_proc, 5);

197: --
198: begin
199: --
200: --
201: hr_utility.set_location ('Entering ' || l_proc, 5);
202: --
203: --
204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a
205: WHERE a.dpnt_person_id IS NOT NULL

Line 210: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
213: --
214: -- ----------------------------------------------------------------------------

Line 229: hr_utility.set_location ('Entering ' || l_proc, 5);

225: --
226: begin
227: --
228: --
229: hr_utility.set_location ('Entering ' || l_proc, 5);
230: --
231: --
232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a
233: WHERE a.person_id IS NOT NULL

Line 238: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
241: --
242: -- ----------------------------------------------------------------------------

Line 257: hr_utility.set_location ('Entering ' || l_proc, 5);

253: --
254: begin
255: --
256: --
257: hr_utility.set_location ('Entering ' || l_proc, 5);
258: --
259: --
260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a
261: WHERE a.person_id IS NOT NULL

Line 266: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
269: --
270: -- ----------------------------------------------------------------------------

Line 285: hr_utility.set_location ('Entering ' || l_proc, 5);

281: --
282: begin
283: --
284: --
285: hr_utility.set_location ('Entering ' || l_proc, 5);
286: --
287: --
288: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_dtl a
289: WHERE a.person_id IS NOT NULL

Line 295: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
298: --
299: -- ----------------------------------------------------------------------------

Line 314: hr_utility.set_location ('Entering ' || l_proc, 5);

310: --
311: begin
312: --
313: --
314: hr_utility.set_location ('Entering ' || l_proc, 5);
315: --
316: --
317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a
318: WHERE a.person_id IS NOT NULL

Line 323: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
326: --
327: -- ----------------------------------------------------------------------------

Line 342: hr_utility.set_location ('Entering ' || l_proc, 5);

338: --
339: begin
340: --
341: --
342: hr_utility.set_location ('Entering ' || l_proc, 5);
343: --
344: --
345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a
346: WHERE a.person_id IS NOT NULL

Line 351: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
354: --
355: -- ----------------------------------------------------------------------------

Line 370: hr_utility.set_location ('Entering ' || l_proc, 5);

366: --
367: begin
368: --
369: --
370: hr_utility.set_location ('Entering ' || l_proc, 5);
371: --
372: --
373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a
374: WHERE a.person_id IS NOT NULL

Line 379: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
382: --
383: -- ----------------------------------------------------------------------------

Line 398: hr_utility.set_location ('Entering ' || l_proc, 5);

394: --
395: begin
396: --
397: --
398: hr_utility.set_location ('Entering ' || l_proc, 5);
399: --
400: --
401: DELETE FROM ben_per_bnfts_bal_f a
402: WHERE NOT EXISTS (SELECT 1

Line 407: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
410: --
411: -- ----------------------------------------------------------------------------

Line 426: hr_utility.set_location ('Entering ' || l_proc, 5);

422: --
423: begin
424: --
425: --
426: hr_utility.set_location ('Entering ' || l_proc, 5);
427: --
428: --
429: DELETE FROM ben_per_dlvry_mthd_f a
430: WHERE NOT EXISTS (SELECT 1

Line 435: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
438: --
439: -- ----------------------------------------------------------------------------

Line 454: hr_utility.set_location ('Entering ' || l_proc, 5);

450: --
451: begin
452: --
453: --
454: hr_utility.set_location ('Entering ' || l_proc, 5);
455: --
456: --
457: DELETE FROM ben_per_pin_f a
458: WHERE NOT EXISTS (SELECT 1

Line 463: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
466: --
467: -- ----------------------------------------------------------------------------

Line 482: hr_utility.set_location ('Entering ' || l_proc, 5);

478: --
479: begin
480: --
481: --
482: hr_utility.set_location ('Entering ' || l_proc, 5);
483: --
484: --
485: DELETE FROM ben_pl_bnf_f a
486: WHERE NOT EXISTS (

Line 493: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
496: --
497: -- ----------------------------------------------------------------------------

Line 512: hr_utility.set_location ('Entering ' || l_proc, 5);

508: --
509: begin
510: --
511: --
512: hr_utility.set_location ('Entering ' || l_proc, 5);
513: --
514: --
515: DELETE FROM ben_prtt_reimbmt_rqst_f a
516: WHERE NOT EXISTS (

Line 525: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
528: --
529: -- ----------------------------------------------------------------------------

Line 544: hr_utility.set_location ('Entering ' || l_proc, 5);

540: --
541: begin
542: --
543: --
544: hr_utility.set_location ('Entering ' || l_proc, 5);
545: --
546: --
547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a
548: WHERE a.person_id IS NOT NULL

Line 553: hr_utility.set_location ('Leaving ' || l_proc, 10);

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;
556: --
557: -- ----------------------------------------------------------------------------

Line 595: hr_utility.set_location ('Entering ' || l_proc, 5);

591: FROM per_all_people_f per);
592: --
593: begin
594: --
595: hr_utility.set_location ('Entering ' || l_proc, 5);
596: --
597: --
598: OPEN c1 ;
599: LOOP

Line 680: hr_utility.set_location ('Leaving ' || l_proc, 10);

676: end loop;
677: --
678: CLOSE c1;
679: --
680: hr_utility.set_location ('Leaving ' || l_proc, 10);
681: --
682: end delete_benefit_actions;
683: --
684: -- ----------------------------------------------------------------------------

Line 722: hr_utility.set_location ('Entering ' || l_proc, 5);

718: FROM per_all_people_f per);
719: --
720: begin
721: --
722: hr_utility.set_location ('Entering ' || l_proc, 5);
723: --
724: --
725: OPEN c2 ;
726: LOOP

Line 815: hr_utility.set_location ('Leaving ' || l_proc, 10);

811: end loop;
812: --
813: CLOSE c2;
814: --
815: hr_utility.set_location ('Leaving ' || l_proc, 10);
816: --
817: end delete_per_in_ler;
818: --
819: -- ----------------------------------------------------------------------------

Line 851: hr_utility.set_location ('Entering ' || l_proc, 5);

847: FROM per_all_people_f per);
848: --
849: begin
850: --
851: hr_utility.set_location ('Entering ' || l_proc, 5);
852: --
853: --
854: OPEN c3 ;
855: LOOP

Line 900: hr_utility.set_location ('Leaving ' || l_proc, 10);

896: end loop;
897: --
898: CLOSE c3;
899: --
900: hr_utility.set_location ('Leaving ' || l_proc, 10);
901: --
902: end delete_prtt_enrt_rslt_f;
903: --
904: -- ----------------------------------------------------------------------------

Line 933: hr_utility.set_location ('Entering ' || l_proc, 5);

929: WHERE per.person_id = a.dpnt_person_id);
930: --
931: begin
932: --
933: hr_utility.set_location ('Entering ' || l_proc, 5);
934: --
935: --
936: OPEN c4 ;
937: LOOP

Line 969: hr_utility.set_location ('Leaving ' || l_proc, 10);

965: end loop;
966: --
967: CLOSE c4;
968: --
969: hr_utility.set_location ('Leaving ' || l_proc, 10);
970: --
971: end delete_elig_cvrd_dpnt_f;
972: --
973: -- ----------------------------------------------------------------------------

Line 1003: hr_utility.set_location ('Entering ' || l_proc, 5);

999: WHERE per.person_id = a.person_id);
1000: --
1001: begin
1002: --
1003: hr_utility.set_location ('Entering ' || l_proc, 5);
1004: --
1005: --
1006: OPEN c5 ;
1007: LOOP

Line 1040: hr_utility.set_location ('Leaving ' || l_proc, 10);

1036: end loop;
1037: --
1038: CLOSE c5;
1039: --
1040: hr_utility.set_location ('Leaving ' || l_proc, 10);
1041: --
1042: end delete_per_cm_f;
1043: --
1044: -- -----------------------------------------------------------------------------

Line 1065: hr_utility.set_location ('Entering ' || l_proc, 5);

1061: l_title_text varchar2(85);
1062: --
1063: begin
1064: --
1065: hr_utility.set_location ('Entering ' || l_proc, 5);
1066: --
1067: l_title_text := 'Number of rows deleted from the following tables :';
1068: --
1069: if p_thread_id = 1 then

Line 1138: hr_utility.set_location ('Leaving ' || l_proc, 10);

1134: delete_per_con ;
1135: --
1136: end if;
1137: --
1138: hr_utility.set_location ('Leaving ' || l_proc, 10);
1139: --
1140: end do_multithread;
1141: --
1142: -- ----------------------------------------------------------------------------

Line 1168: hr_utility.set_location ('Entering ' || l_proc, 5);

1164: -- Cursor Declaration.
1165: --
1166: begin
1167: --
1168: hr_utility.set_location ('Entering ' || l_proc, 5);
1169: --
1170: l_effective_date := trunc(sysdate);
1171: l_parent_request_id := fnd_global.conc_request_id;
1172: --

Line 1204: hr_utility.set_location('Submitting request ' || l_count, 10);

1200: loop
1201: --
1202: -- We start submitting threads from TWO as the main process will act as first thread.
1203: --
1204: hr_utility.set_location('Submitting request ' || l_count, 10);
1205: --
1206: l_request_id := fnd_request.submit_request
1207: (application => 'BEN'
1208: ,program => 'BEDEORTHRD'

Line 1224: hr_utility.set_location('Submitting the master process', 10);

1220: end loop;
1221: --
1222: -- Carry on with the master.
1223: --
1224: hr_utility.set_location('Submitting the master process', 10);
1225: --
1226: do_multithread
1227: (errbuf => errbuf
1228: ,retcode => retcode

Line 1236: hr_utility.set_location ('Leaving ' || l_proc, 10);

1232: -- Check if all the slave processes are finished.
1233: --
1234: check_all_slaves_finished(p_rpt_flag => TRUE);
1235: --
1236: hr_utility.set_location ('Leaving ' || l_proc, 10);
1237: --
1238: exception
1239: --
1240: when others then