532: 'L_Q=>'||L_Q);
533: END IF;
534: if (L_Q = '!') then
535: begin
536: --- Bug#33096950 - wf_purge.total(l_wf_name,l_key);
537: wf_purge.total(l_wf_name,l_key,runtimeonly=>TRUE);
538: exception
539: when others then
540: begin
533: END IF;
534: if (L_Q = '!') then
535: begin
536: --- Bug#33096950 - wf_purge.total(l_wf_name,l_key);
537: wf_purge.total(l_wf_name,l_key,runtimeonly=>TRUE);
538: exception
539: when others then
540: begin
541: -- for Bug#3096950 - wf_purge.totalPerm(l_wf_name,l_key);
537: wf_purge.total(l_wf_name,l_key,runtimeonly=>TRUE);
538: exception
539: when others then
540: begin
541: -- for Bug#3096950 - wf_purge.totalPerm(l_wf_name,l_key);
542: wf_purge.totalPerm(l_wf_name,l_key,runtimeonly=>TRUE);
543: exception
544: when others then
545: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
538: exception
539: when others then
540: begin
541: -- for Bug#3096950 - wf_purge.totalPerm(l_wf_name,l_key);
542: wf_purge.totalPerm(l_wf_name,l_key,runtimeonly=>TRUE);
543: exception
544: when others then
545: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
546: p_msg_name => G_WF_NOT_PURGED,
1154: if (L_FINAL_APPROVER_UNAME = L_INITIATOR_NAME) then
1155: L_FINAL_APPROVER_UNAME := NULL;
1156: end if;
1157: begin
1158: --Bug#3096950 - wf_purge.total(l_wf_name_active,l_key);
1159: wf_purge.total(l_wf_name_active,l_key,runtimeonly=>TRUE);
1160: exception
1161: when others then
1162: begin
1155: L_FINAL_APPROVER_UNAME := NULL;
1156: end if;
1157: begin
1158: --Bug#3096950 - wf_purge.total(l_wf_name_active,l_key);
1159: wf_purge.total(l_wf_name_active,l_key,runtimeonly=>TRUE);
1160: exception
1161: when others then
1162: begin
1163: --for Bug#3096950 - wf_purge.totalPerm(l_wf_name_active,l_key);
1159: wf_purge.total(l_wf_name_active,l_key,runtimeonly=>TRUE);
1160: exception
1161: when others then
1162: begin
1163: --for Bug#3096950 - wf_purge.totalPerm(l_wf_name_active,l_key);
1164: wf_purge.totalPerm(l_wf_name_active, l_key, runtimeonly=>TRUE);
1165: exception
1166: when others then
1167: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1160: exception
1161: when others then
1162: begin
1163: --for Bug#3096950 - wf_purge.totalPerm(l_wf_name_active,l_key);
1164: wf_purge.totalPerm(l_wf_name_active, l_key, runtimeonly=>TRUE);
1165: exception
1166: when others then
1167: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1168: p_msg_name => G_WF_NOT_PURGED,