76: SELECT phase_code,
77: status_code
78: INTO l_phase,
79: l_status
80: FROM fnd_concurrent_requests
81: WHERE request_id = l_request_id;
82:
83: INSERT INTO hxc_rdb_processes
84: ( request_id,
121: SELECT phase_code,
122: status_code
123: INTO l_phase,
124: l_status
125: FROM fnd_concurrent_requests
126: WHERE request_id = l_request_id;
127:
128:
129: INSERT INTO hxc_rdb_processes
204: phase_code,
205: actual_completion_date,
206: ROWIDTOCHAR(rdb.rowid)
207: FROM hxc_rdb_processes rdb,
208: fnd_concurrent_requests fnd
209: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
210: AND rdb.request_id = fnd.request_id
211: AND fnd.requested_by = rdb.ret_user_id
212: AND rdb.phase <> 'C';