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.PJI_FM_EXTR dependencies on PJI_HELPER_BATCH_MAP

Line 192: insert /+ append / into PJI_HELPER_BATCH_MAP

188: 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_PRE(p_worker_id);')) then
189: return;
190: end if;
191:
192: insert /*+ append */ into PJI_HELPER_BATCH_MAP
193: (
194: BATCH_ID,
195: WORKER_ID,
196: STATUS

Line 240: from PJI_HELPER_BATCH_MAP

236: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
237:
238: select count(*)
239: into l_leftover_batches
240: from PJI_HELPER_BATCH_MAP
241: where WORKER_ID = p_worker_id and
242: STATUS = 'P';
243:
244: l_helper_batch_id := 0;

Line 254: from PJI_HELPER_BATCH_MAP

250: l_leftover_batches := l_leftover_batches - 1;
251:
252: select BATCH_ID
253: into l_helper_batch_id
254: from PJI_HELPER_BATCH_MAP
255: where WORKER_ID = p_worker_id and
256: STATUS = 'P' and
257: ROWNUM = 1;
258:

Line 261: update PJI_HELPER_BATCH_MAP

257: ROWNUM = 1;
258:
259: else
260:
261: update PJI_HELPER_BATCH_MAP
262: set WORKER_ID = p_worker_id,
263: STATUS = 'P'
264: where WORKER_ID is null and
265: ROWNUM = 1

Line 283: update PJI_HELPER_BATCH_MAP

279: from PJI_FM_EXTR_FUNDG fnd
280: where fnd.pji_summarized_flag is not null and
281: fnd.batch_id = l_helper_batch_id);
282:
283: update PJI_HELPER_BATCH_MAP
284: set STATUS = 'C'
285: where WORKER_ID = p_worker_id and
286: BATCH_ID = l_helper_batch_id;
287:

Line 294: from PJI_HELPER_BATCH_MAP

290: else
291:
292: select count(*)
293: into l_row_count
294: from PJI_HELPER_BATCH_MAP
295: where nvl(STATUS, 'X') <> 'C';
296:
297: if (l_row_count = 0) then
298:

Line 363: 'PJI_HELPER_BATCH_MAP',

359: return;
360: end if;
361:
362: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
363: 'PJI_HELPER_BATCH_MAP',
364: 'NORMAL',
365: null);
366:
367: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 661: insert /+ append / into PJI_HELPER_BATCH_MAP

657: 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_PRE(p_worker_id);')) then
658: return;
659: end if;
660:
661: insert /*+ append */ into PJI_HELPER_BATCH_MAP
662: (
663: BATCH_ID,
664: WORKER_ID,
665: STATUS

Line 711: from PJI_HELPER_BATCH_MAP

707: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
708:
709: select count(*)
710: into l_leftover_batches
711: from PJI_HELPER_BATCH_MAP
712: where WORKER_ID = p_worker_id and
713: STATUS = 'P';
714:
715: l_helper_batch_id := 0;

Line 725: from PJI_HELPER_BATCH_MAP

721: l_leftover_batches := l_leftover_batches - 1;
722:
723: select BATCH_ID
724: into l_helper_batch_id
725: from PJI_HELPER_BATCH_MAP
726: where WORKER_ID = p_worker_id and
727: STATUS = 'P' and
728: ROWNUM = 1;
729:

Line 732: update PJI_HELPER_BATCH_MAP

728: ROWNUM = 1;
729:
730: else
731:
732: update PJI_HELPER_BATCH_MAP
733: set WORKER_ID = p_worker_id,
734: STATUS = 'P'
735: where WORKER_ID is null and
736: ROWNUM = 1

Line 763: update PJI_HELPER_BATCH_MAP

759: from PJI_FM_EXTR_DREVN
760: where line_source_type = 'L'
761: and batch_id = l_helper_batch_id);
762:
763: update PJI_HELPER_BATCH_MAP
764: set STATUS = 'C'
765: where WORKER_ID = p_worker_id and
766: BATCH_ID = l_helper_batch_id;
767:

Line 774: from PJI_HELPER_BATCH_MAP

770: else
771:
772: select count(*)
773: into l_row_count
774: from PJI_HELPER_BATCH_MAP
775: where nvl(STATUS, 'X') <> 'C';
776:
777: if (l_row_count = 0) then
778:

Line 843: 'PJI_HELPER_BATCH_MAP',

839: return;
840: end if;
841:
842: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
843: 'PJI_HELPER_BATCH_MAP',
844: 'NORMAL',
845: null);
846:
847: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 2373: insert /+ append / into PJI_HELPER_BATCH_MAP

2369: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);')) then
2370: return;
2371: end if;
2372:
2373: insert /*+ append */ into PJI_HELPER_BATCH_MAP
2374: (
2375: BATCH_ID,
2376: WORKER_ID,
2377: STATUS

Line 2421: from PJI_HELPER_BATCH_MAP

2417: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2418:
2419: select count(*)
2420: into l_leftover_batches
2421: from PJI_HELPER_BATCH_MAP
2422: where WORKER_ID = p_worker_id and
2423: STATUS = 'P';
2424:
2425: l_helper_batch_id := 0;

Line 2435: from PJI_HELPER_BATCH_MAP

2431: l_leftover_batches := l_leftover_batches - 1;
2432:
2433: select BATCH_ID
2434: into l_helper_batch_id
2435: from PJI_HELPER_BATCH_MAP
2436: where WORKER_ID = p_worker_id and
2437: STATUS = 'P' and
2438: ROWNUM = 1;
2439:

Line 2442: update PJI_HELPER_BATCH_MAP

2438: ROWNUM = 1;
2439:
2440: else
2441:
2442: update PJI_HELPER_BATCH_MAP
2443: set WORKER_ID = p_worker_id,
2444: STATUS = 'P'
2445: where WORKER_ID is null and
2446: ROWNUM = 1

Line 2464: update PJI_HELPER_BATCH_MAP

2460: from PJI_FM_REXT_CDL cdl
2461: where cdl.PJI_SUMMARIZED_FLAG = 'N' and
2462: cdl.BATCH_ID = l_helper_batch_id);
2463:
2464: update PJI_HELPER_BATCH_MAP
2465: set STATUS = 'C'
2466: where WORKER_ID = p_worker_id and
2467: BATCH_ID = l_helper_batch_id;
2468:

Line 2475: from PJI_HELPER_BATCH_MAP

2471: else
2472:
2473: select count(*)
2474: into l_row_count
2475: from PJI_HELPER_BATCH_MAP
2476: where nvl(STATUS, 'X') <> 'C';
2477:
2478: if (l_row_count = 0) then
2479:

Line 2544: 'PJI_HELPER_BATCH_MAP',

2540: return;
2541: end if;
2542:
2543: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2544: 'PJI_HELPER_BATCH_MAP',
2545: 'NORMAL',
2546: null);
2547:
2548: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 3591: insert /+ append / into PJI_HELPER_BATCH_MAP

3587: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);')) then
3588: return;
3589: end if;
3590:
3591: insert /*+ append */ into PJI_HELPER_BATCH_MAP
3592: (
3593: BATCH_ID,
3594: WORKER_ID,
3595: STATUS

Line 3639: from PJI_HELPER_BATCH_MAP

3635: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
3636:
3637: select count(*)
3638: into l_leftover_batches
3639: from PJI_HELPER_BATCH_MAP
3640: where WORKER_ID = p_worker_id and
3641: STATUS = 'P';
3642:
3643: l_helper_batch_id := 0;

Line 3653: from PJI_HELPER_BATCH_MAP

3649: l_leftover_batches := l_leftover_batches - 1;
3650:
3651: select BATCH_ID
3652: into l_helper_batch_id
3653: from PJI_HELPER_BATCH_MAP
3654: where WORKER_ID = p_worker_id and
3655: STATUS = 'P' and
3656: ROWNUM = 1;
3657:

Line 3660: update PJI_HELPER_BATCH_MAP

3656: ROWNUM = 1;
3657:
3658: else
3659:
3660: update PJI_HELPER_BATCH_MAP
3661: set WORKER_ID = p_worker_id,
3662: STATUS = 'P'
3663: where WORKER_ID is null and
3664: ROWNUM = 1

Line 3684: update PJI_HELPER_BATCH_MAP

3680: -- the AR snapshots for now.
3681: AND ar.pji_summarized_flag = 'O'
3682: AND ar.batch_id = l_helper_batch_id);
3683:
3684: update PJI_HELPER_BATCH_MAP
3685: set STATUS = 'C'
3686: where WORKER_ID = p_worker_id and
3687: BATCH_ID = l_helper_batch_id;
3688:

Line 3695: from PJI_HELPER_BATCH_MAP

3691: else
3692:
3693: select count(*)
3694: into l_row_count
3695: from PJI_HELPER_BATCH_MAP
3696: where nvl(STATUS, 'X') <> 'C';
3697:
3698: if (l_row_count = 0) then
3699:

Line 3764: 'PJI_HELPER_BATCH_MAP',

3760: return;
3761: end if;
3762:
3763: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
3764: 'PJI_HELPER_BATCH_MAP',
3765: 'NORMAL',
3766: null);
3767:
3768: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,