247: IF ( l_status_type = 1 ) THEN
248: l_approval_status := 'C';
249: ELSIF ( l_status_type = 12 ) THEN
250: BEGIN
251: IF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED ) THEN
252: l_approval_status := 'SFR';
253: ELSIF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_IN_PROGRESS ) THEN
254: l_approval_status := 'SFR';
255: ELSIF (p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_COMPLETED) THEN
249: ELSIF ( l_status_type = 12 ) THEN
250: BEGIN
251: IF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED ) THEN
252: l_approval_status := 'SFR';
253: ELSIF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_IN_PROGRESS ) THEN
254: l_approval_status := 'SFR';
255: ELSIF (p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_COMPLETED) THEN
256:
257: SELECT Count(*)
251: IF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED ) THEN
252: l_approval_status := 'SFR';
253: ELSIF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_IN_PROGRESS ) THEN
254: l_approval_status := 'SFR';
255: ELSIF (p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_COMPLETED) THEN
256:
257: SELECT Count(*)
258: INTO l_row_count
259: FROM eng_lifecycle_statuses life,eng_change_statuses_vl stat