APPS.PJI_PROCESS_UTIL dependencies on PJI_SYSTEM_PRC_STATUS

Line 174: from PJI_SYSTEM_PRC_STATUS

170: end if;
171:
172: select count(*)
173: into l_count
174: from PJI_SYSTEM_PRC_STATUS
175: where PROCESS_NAME = p_process and
176: STEP_NAME = p_step;
177:
178: if (l_count = 0) then

Line 186: from PJI_SYSTEM_PRC_STATUS

182: select STEP_STATUS,
183: STEP_SEQ
184: into l_status,
185: l_seq
186: from PJI_SYSTEM_PRC_STATUS
187: where PROCESS_NAME = p_process and
188: STEP_NAME = p_step;
189:
190: if (l_status = 'C') then -- Step is complete, do not need to run it again.

Line 194: update PJI_SYSTEM_PRC_STATUS

190: if (l_status = 'C') then -- Step is complete, do not need to run it again.
191: return false;
192: else
193:
194: update PJI_SYSTEM_PRC_STATUS
195: set START_DATE = sysdate
196: where PROCESS_NAME = p_process and
197: STEP_NAME = p_step and
198: START_DATE is null;

Line 249: update PJI_SYSTEM_PRC_STATUS

245: else
246: return;
247: end if;
248:
249: update PJI_SYSTEM_PRC_STATUS
250: set STEP_STATUS = 'C',
251: END_DATE = sysdate
252: where PROCESS_NAME = p_process and
253: STEP_NAME = p_step;

Line 270: -- PJI_SYSTEM_PRC_STATUS to see if the step has run before.

266: --
267: -- This utility is for debugging purposes.
268: -- If check step is not set to 'Y' any step can be run in
269: -- the summarization process without looking at
270: -- PJI_SYSTEM_PRC_STATUS to see if the step has run before.
271: -- ----------------------------------------------------------
272: procedure CHECK_STEP (p_check_step in varchar2 default 'Y') is
273:
274: begin

Line 306: from PJI_SYSTEM_PRC_STATUS

302: else
303: /* Added for bug 13030627 */
304:
305: delete
306: from PJI_SYSTEM_PRC_STATUS
307: where PROCESS_NAME = p_process;
308:
309: delete
310: from PJI_SYSTEM_PARAMETERS

Line 386: insert into PJI_SYSTEM_PRC_STATUS

382: else
383: l_extraction_type := 0;
384: end if;
385:
386: insert into PJI_SYSTEM_PRC_STATUS
387: (
388: PROCESS_NAME,
389: STEP_NAME,
390: STEP_STATUS,

Line 411: from PJI_SYSTEM_PRC_STATUS

407: bitand(to_number(STEP_TYPE), l_extraction_type) = l_extraction_type and
408: (STEP_NAME,
409: STEP_SEQ) not in (select STEP_NAME,
410: STEP_SEQ
411: from PJI_SYSTEM_PRC_STATUS
412: where PROCESS_NAME = p_process);
413:
414: end ADD_STEPS;
415:

Line 433: from PJI_SYSTEM_PRC_STATUS

429: begin
430:
431: select count(*)
432: into l_count
433: from PJI_SYSTEM_PRC_STATUS
434: where PROCESS_NAME = p_process;
435:
436: if (l_count = 0) then
437: return true;

Line 585: from PJI_SYSTEM_PRC_STATUS

581: while not l_done loop
582:
583: select count(*)
584: into l_worker_count
585: from PJI_SYSTEM_PRC_STATUS
586: where PROCESS_NAME like p_process || '%' and
587: STEP_NAME = p_step;
588:
589: if (l_worker_count > 0) then

Line 603: from PJI_SYSTEM_PRC_STATUS

599: while not l_done loop
600:
601: select count(*)
602: into l_worker_count
603: from PJI_SYSTEM_PRC_STATUS
604: where PROCESS_NAME like p_process || '%' and
605: STEP_NAME = p_step and
606: STEP_STATUS is null;
607: