DBA Data[Home] [Help]

APPS.DOM_DOCUMENT_UTIL dependencies on ENG_WORKFLOW_UTIL

Line 251: IF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED ) THEN

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

Line 253: ELSIF ( p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_IN_PROGRESS ) 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(*)

Line 255: ELSIF (p_wf_route_status = ENG_WORKFLOW_UTIL.G_RT_COMPLETED) THEN

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