DBA Data[Home] [Help]

APPS.FND_WF_STANDARD dependencies on FND_CONCURRENT

Line 102: from fnd_concurrent_requests fr1, fnd_concurrent_requests fr2

98: complete_status varchar2(10):=null;
99:
100: cursor avgCPtime(c_reqID in number) is
101: select avg(fr1.actual_completion_date - fr1.actual_start_date)
102: from fnd_concurrent_requests fr1, fnd_concurrent_requests fr2
103: where fr2.request_id = c_reqID
104: and fr1.concurrent_program_id = fr2.concurrent_program_id
105: and fr1.program_application_id = fr2.program_application_id
106: and fr1.actual_start_date is not null

Line 120: if (fnd_concurrent.get_request_status(REQUEST_ID => req_id,

116: else
117: req_id := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,
118: 'REQUEST_ID');
119:
120: if (fnd_concurrent.get_request_status(REQUEST_ID => req_id,
121: PHASE => phase,
122: STATUS => s0,
123: DEV_PHASE => devphase,
124: DEV_STATUS => complete_status,