APPS.PJI_PROCESS_UTIL dependencies on PJI_SYSTEM_PRC_STATUS

Line 146: from PJI_SYSTEM_PRC_STATUS

142: end if;
143:
144: select count(*)
145: into l_count
146: from PJI_SYSTEM_PRC_STATUS
147: where PROCESS_NAME = p_process and
148: STEP_NAME = p_step;
149:
150: if (l_count = 0) then

Line 158: from PJI_SYSTEM_PRC_STATUS

154: select STEP_STATUS,
155: STEP_SEQ
156: into l_status,
157: l_seq
158: from PJI_SYSTEM_PRC_STATUS
159: where PROCESS_NAME = p_process and
160: STEP_NAME = p_step;
161:
162: if (l_status = 'C') then -- Step is complete, do not need to run it again.

Line 166: update PJI_SYSTEM_PRC_STATUS

162: if (l_status = 'C') then -- Step is complete, do not need to run it again.
163: return false;
164: else
165:
166: update PJI_SYSTEM_PRC_STATUS
167: set START_DATE = sysdate
168: where PROCESS_NAME = p_process and
169: STEP_NAME = p_step and
170: START_DATE is null;

Line 201: update PJI_SYSTEM_PRC_STATUS

197: else
198: return;
199: end if;
200:
201: update PJI_SYSTEM_PRC_STATUS
202: set STEP_STATUS = 'C',
203: END_DATE = sysdate
204: where PROCESS_NAME = p_process and
205: STEP_NAME = p_step;

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

216: --
217: -- This utility is for debugging purposes.
218: -- If check step is not set to 'Y' any step can be run in
219: -- the summarization process without looking at
220: -- PJI_SYSTEM_PRC_STATUS to see if the step has run before.
221: -- ----------------------------------------------------------
222: procedure CHECK_STEP (p_check_step in varchar2 default 'Y') is
223:
224: begin

Line 246: from PJI_SYSTEM_PRC_STATUS

242:
243: begin
244:
245: delete
246: from PJI_SYSTEM_PRC_STATUS
247: where PROCESS_NAME = p_process;
248:
249: delete
250: from PJI_SYSTEM_PARAMETERS

Line 324: insert into PJI_SYSTEM_PRC_STATUS

320: else
321: l_extraction_type := 0;
322: end if;
323:
324: insert into PJI_SYSTEM_PRC_STATUS
325: (
326: PROCESS_NAME,
327: STEP_NAME,
328: STEP_STATUS,

Line 349: from PJI_SYSTEM_PRC_STATUS

345: bitand(to_number(STEP_TYPE), l_extraction_type) = l_extraction_type and
346: (STEP_NAME,
347: STEP_SEQ) not in (select STEP_NAME,
348: STEP_SEQ
349: from PJI_SYSTEM_PRC_STATUS
350: where PROCESS_NAME = p_process);
351:
352: end ADD_STEPS;
353:

Line 371: from PJI_SYSTEM_PRC_STATUS

367: begin
368:
369: select count(*)
370: into l_count
371: from PJI_SYSTEM_PRC_STATUS
372: where PROCESS_NAME = p_process;
373:
374: if (l_count = 0) then
375: return true;

Line 487: from PJI_SYSTEM_PRC_STATUS

483: while not l_done loop
484:
485: select count(*)
486: into l_worker_count
487: from PJI_SYSTEM_PRC_STATUS
488: where PROCESS_NAME like p_process || '%' and
489: STEP_NAME = p_step;
490:
491: if (l_worker_count > 0) then

Line 505: from PJI_SYSTEM_PRC_STATUS

501: while not l_done loop
502:
503: select count(*)
504: into l_worker_count
505: from PJI_SYSTEM_PRC_STATUS
506: where PROCESS_NAME like p_process || '%' and
507: STEP_NAME = p_step and
508: STEP_STATUS is null;
509: