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_SUM_BKLG dependencies on PJI_RM_SUM_MAIN

Line 17: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;

13: l_process varchar2(30);
14:
15: begin
16:
17: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
18:
19: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);')) then
20: return;
21: end if;

Line 77: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;

73: l_extraction_type varchar2(30);
74:
75: begin
76:
77: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
78:
79: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);')) then
80: return;
81: end if;

Line 84: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

80: return;
81: end if;
82:
83: /* l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
84: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
85:
86: -- Update the table pji_pji_proj_batch_map with the
87: -- minimum activity dates for each project in the current batch
88: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) *

Line 126: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;

122: l_process varchar2(30);
123:
124: begin
125:
126: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
127:
128: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);')) then
129: return;
130: end if;

Line 180: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;

176: l_extraction_type varchar2(30);
177:
178: begin
179:
180: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
181:
182: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);')) then
183: return;
184: end if;

Line 187: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

183: return;
184: end if;
185:
186: /* l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
187: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
188:
189: -- Update the table pji_pji_proj_batch_map with the
190: -- minimum funding dates for each project in the current batch
191: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) *

Line 229: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

225: l_extraction_type varchar2(30);
226:
227: begin
228:
229: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
230:
231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
232: ( l_process, 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);'
233: )) then

Line 238: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

234: return;
235: end if;
236:
237: /* l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
238: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
239:
240: UPDATE PJI_PJI_PROJ_BATCH_MAP upd
241: set upd.BACKLOG_EXTRACTION_STATUS=null
242: where upd.project_id in

Line 289: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

285: l_schema varchar2(30);
286:
287: begin
288:
289: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
290:
291: /* PJI_FM_DEBUG.CLEANUP_HOOK(l_process);
292:
293: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

Line 770: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;

766: l_first_currency NUMBER;
767: l_bkt_dual NUMBER :=0;
768: l_called_before VARCHAR2(1) :='N';
769: l_curr_date NUMBER;
770: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;
771: l_record_type VARCHAR2(1);
772: l_ex_drmt_bklg NUMBER;
773: l_ex_strt_bklg NUMBER;
774: l_ex_lost_bklg NUMBER;

Line 1183: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;

1179: l_gl_calendar_id NUMBER := NULL;
1180: l_pa_calendar_id NUMBER := NULL;
1181: l_pa_calendar_flag VARCHAR2(1) := 'N';
1182: l_dbklg_days NUMBER := 0;
1183: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;
1184: --temptemp needs to be PJI_PJI_LAST_EXTR_DATE
1185: last_extr_date DATE := to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD');
1186: l_commit_counter NUMBER := 0;
1187: l_dual_limit NUMBER := 0;

Line 1202: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1198:
1199:
1200: BEGIN
1201:
1202: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1203:
1204: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1205: ( l_process, 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);')) then
1206: return;

Line 1259: (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING') <> 'Y' ) THEN

1255: /* LOOP
1256:
1257: -- Exit if the main process is not running
1258: IF (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1259: (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING') <> 'Y' ) THEN
1260: exit;
1261: END IF;
1262:
1263: l_try_upd_again := 'N';

Line 1319: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);

1315:
1316:
1317: IF ( l_try_upd_again = 'Y' ) Then
1318: -- wait for some time and try again
1319: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);
1320: ELSE -- go ahead with the processing for the record updated
1321:
1322: Select project_id
1323: Into l_curr_project_id

Line 1434: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');

1430: ;
1431:
1432: IF ( l_count_for_upd = 0 ) THEN
1433:
1434: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
1435:
1436: for x in 2 .. l_parallel_processes loop
1437:
1438: update PJI_SYSTEM_PRC_STATUS

Line 1440: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x) and

1436: for x in 2 .. l_parallel_processes loop
1437:
1438: update PJI_SYSTEM_PRC_STATUS
1439: set STEP_STATUS = 'C'
1440: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x) and
1441: STEP_NAME = 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);';
1442:
1443: commit;
1444:

Line 1450: (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING') <> 'Y' ) THEN

1446:
1447: END IF;
1448:
1449: IF (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1450: (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING') <> 'Y' ) THEN
1451: -- no need to raise any error here
1452: null;
1453:
1454: ELSE