283: l_value varchar2(255);
284: begin
285: l_value:=get_value(p_num,wf_string);
286: if l_value is not null then
287: if l_value = 'OKC_API.G_MISS_NUM' then
288: return OKC_API.G_MISS_NUM;
289: end if;
290: if l_value = 'NULL' then
291: return null;
284: begin
285: l_value:=get_value(p_num,wf_string);
286: if l_value is not null then
287: if l_value = 'OKC_API.G_MISS_NUM' then
288: return OKC_API.G_MISS_NUM;
289: end if;
290: if l_value = 'NULL' then
291: return null;
292: end if;
300: l_value varchar2(255);
301: begin
302: l_value:=get_value(p_num,wf_string);
303: if l_value is not null then
304: if l_value = 'OKC_API.G_MISS_DATE' then
305: return OKC_API.G_MISS_DATE;
306: end if;
307: if l_value = 'NULL' then
308: return null;
301: begin
302: l_value:=get_value(p_num,wf_string);
303: if l_value is not null then
304: if l_value = 'OKC_API.G_MISS_DATE' then
305: return OKC_API.G_MISS_DATE;
306: end if;
307: if l_value = 'NULL' then
308: return null;
309: end if;
317: l_value varchar2(255);
318: begin
319: l_value:=get_value(p_num,wf_string);
320: if l_value is not null then
321: if l_value = 'OKC_API.G_MISS_CHAR' then
322: return OKC_API.G_MISS_CHAR;
323: end if;
324: if l_value = 'NULL' then
325: return null;
318: begin
319: l_value:=get_value(p_num,wf_string);
320: if l_value is not null then
321: if l_value = 'OKC_API.G_MISS_CHAR' then
322: return OKC_API.G_MISS_CHAR;
323: end if;
324: if l_value = 'NULL' then
325: return null;
326: end if;
389: if p_prebuilt_wf_plsql is null then return null; -- no prebuilt - go out
390: end if;
391: l_plsql := p_prebuilt_wf_plsql;
392: -- add standard trail
393: l_plsql := l_plsql|| 'P_INIT_MSG_LIST => OKC_API.G_FALSE, '||
394: 'X_RETURN_STATUS => :V_RETURN_STATUS, '||
395: 'X_MSG_COUNT => V_MSG_COUNT, '||
396: 'X_MSG_DATA => V_MSG_DATA);';
397: l_plsql := 'Begin ' ||l_plsql||' End;'; -- add block frame