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.WIP_WS_PTPKPI_PK dependencies on WIP_CONSTANTS

Line 52: if (g_logLevel <= wip_constants.trace_logging) then

48: l_conc_status boolean;
49: l_org_ptpkpi_rec org_ptpkpi_rec_type;
50:
51: Begin
52: if (g_logLevel <= wip_constants.trace_logging) then
53:
54: l_params(1).paramName := 'p_org_id';
55: l_params(1).paramValue := p_org_id;
56:

Line 276: if(p_org_ptpkpi_rec.inc_released_jobs = WIP_CONSTANTS.YES) then

272: FUNCTION get_pref_job_statuses(
273: p_org_ptpkpi_rec IN org_ptpkpi_rec_type) RETURN VARCHAR2 IS
274: status_str VARCHAR2(240) := null;
275: BEGIN
276: if(p_org_ptpkpi_rec.inc_released_jobs = WIP_CONSTANTS.YES) then
277: status_str := to_char(wip_constants.RELEASED);
278: end if;
279:
280: if(p_org_ptpkpi_rec.inc_unreleased_jobs = WIP_CONSTANTS.YES) then

Line 277: status_str := to_char(wip_constants.RELEASED);

273: p_org_ptpkpi_rec IN org_ptpkpi_rec_type) RETURN VARCHAR2 IS
274: status_str VARCHAR2(240) := null;
275: BEGIN
276: if(p_org_ptpkpi_rec.inc_released_jobs = WIP_CONSTANTS.YES) then
277: status_str := to_char(wip_constants.RELEASED);
278: end if;
279:
280: if(p_org_ptpkpi_rec.inc_unreleased_jobs = WIP_CONSTANTS.YES) then
281: if(status_str is not null) then

Line 280: if(p_org_ptpkpi_rec.inc_unreleased_jobs = WIP_CONSTANTS.YES) then

276: if(p_org_ptpkpi_rec.inc_released_jobs = WIP_CONSTANTS.YES) then
277: status_str := to_char(wip_constants.RELEASED);
278: end if;
279:
280: if(p_org_ptpkpi_rec.inc_unreleased_jobs = WIP_CONSTANTS.YES) then
281: if(status_str is not null) then
282: status_str := status_str||',';
283: end if;
284: status_str := status_str || to_char(wip_constants.UNRELEASED);

Line 284: status_str := status_str || to_char(wip_constants.UNRELEASED);

280: if(p_org_ptpkpi_rec.inc_unreleased_jobs = WIP_CONSTANTS.YES) then
281: if(status_str is not null) then
282: status_str := status_str||',';
283: end if;
284: status_str := status_str || to_char(wip_constants.UNRELEASED);
285: end if;
286:
287: if(p_org_ptpkpi_rec.inc_onhold_jobs = WIP_CONSTANTS.YES) then
288: if(status_str is not null) then

Line 287: if(p_org_ptpkpi_rec.inc_onhold_jobs = WIP_CONSTANTS.YES) then

283: end if;
284: status_str := status_str || to_char(wip_constants.UNRELEASED);
285: end if;
286:
287: if(p_org_ptpkpi_rec.inc_onhold_jobs = WIP_CONSTANTS.YES) then
288: if(status_str is not null) then
289: status_str := status_str||',';
290: end if;
291: status_str := status_str || to_char(wip_constants.HOLD);

Line 291: status_str := status_str || to_char(wip_constants.HOLD);

287: if(p_org_ptpkpi_rec.inc_onhold_jobs = WIP_CONSTANTS.YES) then
288: if(status_str is not null) then
289: status_str := status_str||',';
290: end if;
291: status_str := status_str || to_char(wip_constants.HOLD);
292: end if;
293:
294: if (p_org_ptpkpi_rec.inc_completed_jobs = WIP_CONSTANTS.YES) then
295: if(status_str is not null) then

Line 294: if (p_org_ptpkpi_rec.inc_completed_jobs = WIP_CONSTANTS.YES) then

290: end if;
291: status_str := status_str || to_char(wip_constants.HOLD);
292: end if;
293:
294: if (p_org_ptpkpi_rec.inc_completed_jobs = WIP_CONSTANTS.YES) then
295: if(status_str is not null) then
296: status_str := status_str||',';
297: end if;
298: status_str := status_str || to_char(wip_constants.COMPLETED);

Line 298: status_str := status_str || to_char(wip_constants.COMPLETED);

294: if (p_org_ptpkpi_rec.inc_completed_jobs = WIP_CONSTANTS.YES) then
295: if(status_str is not null) then
296: status_str := status_str||',';
297: end if;
298: status_str := status_str || to_char(wip_constants.COMPLETED);
299: end if;
300: if status_str is null then
301: status_str := 'null';
302: end if;

Line 312: if (p_org_ptpkpi_rec.inc_standard_jobs = WIP_CONSTANTS.YES) then

308: job_type_str VARCHAR2(240) := null;
309: BEGIN
310: wip_ws_util.trace_log('include std jobs = '||p_org_ptpkpi_rec.inc_standard_jobs);
311: wip_ws_util.trace_log('include non std jobs = '||p_org_ptpkpi_rec.inc_nonstd_jobs);
312: if (p_org_ptpkpi_rec.inc_standard_jobs = WIP_CONSTANTS.YES) then
313: job_type_str := to_char(wip_constants.STANDARD);
314: end if;
315: if (p_org_ptpkpi_rec.inc_nonstd_jobs = WIP_CONSTANTS.YES) then
316: if (job_type_str is not null) then

Line 313: job_type_str := to_char(wip_constants.STANDARD);

309: BEGIN
310: wip_ws_util.trace_log('include std jobs = '||p_org_ptpkpi_rec.inc_standard_jobs);
311: wip_ws_util.trace_log('include non std jobs = '||p_org_ptpkpi_rec.inc_nonstd_jobs);
312: if (p_org_ptpkpi_rec.inc_standard_jobs = WIP_CONSTANTS.YES) then
313: job_type_str := to_char(wip_constants.STANDARD);
314: end if;
315: if (p_org_ptpkpi_rec.inc_nonstd_jobs = WIP_CONSTANTS.YES) then
316: if (job_type_str is not null) then
317: job_type_str := job_type_str||',';

Line 315: if (p_org_ptpkpi_rec.inc_nonstd_jobs = WIP_CONSTANTS.YES) then

311: wip_ws_util.trace_log('include non std jobs = '||p_org_ptpkpi_rec.inc_nonstd_jobs);
312: if (p_org_ptpkpi_rec.inc_standard_jobs = WIP_CONSTANTS.YES) then
313: job_type_str := to_char(wip_constants.STANDARD);
314: end if;
315: if (p_org_ptpkpi_rec.inc_nonstd_jobs = WIP_CONSTANTS.YES) then
316: if (job_type_str is not null) then
317: job_type_str := job_type_str||',';
318: end if;
319: job_type_str := job_type_str||to_char(wip_constants.NONSTANDARD);

Line 319: job_type_str := job_type_str||to_char(wip_constants.NONSTANDARD);

315: if (p_org_ptpkpi_rec.inc_nonstd_jobs = WIP_CONSTANTS.YES) then
316: if (job_type_str is not null) then
317: job_type_str := job_type_str||',';
318: end if;
319: job_type_str := job_type_str||to_char(wip_constants.NONSTANDARD);
320: end if;
321:
322: return job_type_str;
323: END get_job_types;