163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
164: BEGIN
165:
166: IF (p_funcmode = 'RUN') THEN
167: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,
168: P_LAB_PROCESS_NAME,
169: P_LAB_ACTIVITY_NAME,
170: P_TABLE_NAME,
171: P_WHERE_CLAUSE,
170: P_TABLE_NAME,
171: P_WHERE_CLAUSE,
172: P_DATA_STRING,
173: p_wf_data_string);
174: IF gma_wfstd_p.check_activity_approval_req(p_lab_wf_item_type,
175: p_lab_process_name,
176: p_lab_activity_name,
177: p_data_string) = 'Y'
178: THEN
175: p_lab_process_name,
176: p_lab_activity_name,
177: p_data_string) = 'Y'
178: THEN
179: gma_wfstd_p.get_role (p_lab_wf_item_type,
180: p_lab_process_name,
181: p_lab_activity_name,
182: p_data_string,
183: P_role);