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 2360: insert /+ append / into PJI_HELPER_BATCH_MAP

2356: 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);')) then
2357: return;
2358: end if;
2359:
2360: insert /*+ append */ into PJI_HELPER_BATCH_MAP
2361: (
2362: BATCH_ID,
2363: WORKER_ID,
2364: STATUS

Line 2408: from PJI_HELPER_BATCH_MAP

2404: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
2405:
2406: select count(*)
2407: into l_leftover_batches
2408: from PJI_HELPER_BATCH_MAP
2409: where WORKER_ID = p_worker_id and
2410: STATUS = 'P';
2411:
2412: l_helper_batch_id := 0;

Line 2422: from PJI_HELPER_BATCH_MAP

2418: l_leftover_batches := l_leftover_batches - 1;
2419:
2420: select BATCH_ID
2421: into l_helper_batch_id
2422: from PJI_HELPER_BATCH_MAP
2423: where WORKER_ID = p_worker_id and
2424: STATUS = 'P' and
2425: ROWNUM = 1;
2426:

Line 2429: update PJI_HELPER_BATCH_MAP

2425: ROWNUM = 1;
2426:
2427: else
2428:
2429: update PJI_HELPER_BATCH_MAP
2430: set WORKER_ID = p_worker_id,
2431: STATUS = 'P'
2432: where WORKER_ID is null and
2433: ROWNUM = 1

Line 2451: update PJI_HELPER_BATCH_MAP

2447: from PJI_FM_REXT_CDL cdl
2448: where cdl.PJI_SUMMARIZED_FLAG = 'N' and
2449: cdl.BATCH_ID = l_helper_batch_id);
2450:
2451: update PJI_HELPER_BATCH_MAP
2452: set STATUS = 'C'
2453: where WORKER_ID = p_worker_id and
2454: BATCH_ID = l_helper_batch_id;
2455:

Line 2462: from PJI_HELPER_BATCH_MAP

2458: else
2459:
2460: select count(*)
2461: into l_row_count
2462: from PJI_HELPER_BATCH_MAP
2463: where nvl(STATUS, 'X') <> 'C';
2464:
2465: if (l_row_count = 0) then
2466:

Line 2531: 'PJI_HELPER_BATCH_MAP',

2527: return;
2528: end if;
2529:
2530: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
2531: 'PJI_HELPER_BATCH_MAP',
2532: 'NORMAL',
2533: null);
2534:
2535: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

Line 3578: insert /+ append / into PJI_HELPER_BATCH_MAP

3574: 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);')) then
3575: return;
3576: end if;
3577:
3578: insert /*+ append */ into PJI_HELPER_BATCH_MAP
3579: (
3580: BATCH_ID,
3581: WORKER_ID,
3582: STATUS

Line 3626: from PJI_HELPER_BATCH_MAP

3622: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
3623:
3624: select count(*)
3625: into l_leftover_batches
3626: from PJI_HELPER_BATCH_MAP
3627: where WORKER_ID = p_worker_id and
3628: STATUS = 'P';
3629:
3630: l_helper_batch_id := 0;

Line 3640: from PJI_HELPER_BATCH_MAP

3636: l_leftover_batches := l_leftover_batches - 1;
3637:
3638: select BATCH_ID
3639: into l_helper_batch_id
3640: from PJI_HELPER_BATCH_MAP
3641: where WORKER_ID = p_worker_id and
3642: STATUS = 'P' and
3643: ROWNUM = 1;
3644:

Line 3647: update PJI_HELPER_BATCH_MAP

3643: ROWNUM = 1;
3644:
3645: else
3646:
3647: update PJI_HELPER_BATCH_MAP
3648: set WORKER_ID = p_worker_id,
3649: STATUS = 'P'
3650: where WORKER_ID is null and
3651: ROWNUM = 1

Line 3671: update PJI_HELPER_BATCH_MAP

3667: -- the AR snapshots for now.
3668: AND ar.pji_summarized_flag = 'O'
3669: AND ar.batch_id = l_helper_batch_id);
3670:
3671: update PJI_HELPER_BATCH_MAP
3672: set STATUS = 'C'
3673: where WORKER_ID = p_worker_id and
3674: BATCH_ID = l_helper_batch_id;
3675:

Line 3682: from PJI_HELPER_BATCH_MAP

3678: else
3679:
3680: select count(*)
3681: into l_row_count
3682: from PJI_HELPER_BATCH_MAP
3683: where nvl(STATUS, 'X') <> 'C';
3684:
3685: if (l_row_count = 0) then
3686:

Line 3751: 'PJI_HELPER_BATCH_MAP',

3747: return;
3748: end if;
3749:
3750: PJI_PROCESS_UTIL.TRUNC_INT_TABLE('PJI',
3751: 'PJI_HELPER_BATCH_MAP',
3752: 'NORMAL',
3753: null);
3754:
3755: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,