DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_PK dependencies on STANDARD

Line 310: wip_ws_util.trace_log('include std jobs = '||p_org_ptpkpi_rec.inc_standard_jobs);

306: FUNCTION get_job_types(
307: p_org_ptpkpi_rec IN org_ptpkpi_rec_type) RETURN VARCHAR2 IS
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;

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 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;

Line 350: x_org_ptpkpi_rec.inc_standard_jobs :=

346: x_org_ptpkpi_rec.inc_onhold_jobs :=
347: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_onhold_att);
348: x_org_ptpkpi_rec.inc_completed_jobs :=
349: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_completed_att);
350: x_org_ptpkpi_rec.inc_standard_jobs :=
351: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_standard_att);
352: x_org_ptpkpi_rec.inc_nonstd_jobs :=
353: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_nonstd_att);
354: else

Line 351: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_standard_att);

347: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_onhold_att);
348: x_org_ptpkpi_rec.inc_completed_jobs :=
349: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_completed_att);
350: x_org_ptpkpi_rec.inc_standard_jobs :=
351: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_standard_att);
352: x_org_ptpkpi_rec.inc_nonstd_jobs :=
353: WIP_WS_UTIL.GET_MULTIVAL_PREF_VAL_CODE(g_pref_id_ptp, g_pref_level_id_site, l_row_seq_num, g_pref_val_inc_nonstd_att);
354: else
355: x_pref_exists := 'N';