245: l_progress VARCHAR2(500) := '000';
246: l_document_id number;
247: l_item_key wf_items.item_key%TYPE;
248: l_next_approver_id number;
249: l_next_approver_name per_employees_current_x.full_name%TYPE;
250: l_next_approver_user_name VARCHAR2(100);
251: l_next_approver_disp_name VARCHAR2(240);
252: l_orig_system VARCHAR2(48);
253: l_org_id number;
2191: -------------------------------------------------------------------------------
2192: FUNCTION position_has_valid_approvers( documentId NUMBER, documentType VARCHAR2 )RETURN VARCHAR2 is
2193:
2194: l_next_approver_id number;
2195: l_next_approver_name per_employees_current_x.full_name%TYPE;
2196: l_position_has_valid_approvers VARCHAR2(10);
2197: l_approver_index NUMBER;
2198:
2199: l_first_approver_id NUMBER;