DBA Data[Home] [Help]

APPS.HXC_RDB_PROCESS dependencies on HXC_RDB_PROCESSES

Line 83: INSERT INTO hxc_rdb_processes

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,
85: conc_program_id,
86: conc_program_name,
87: date_start,

Line 129: INSERT INTO hxc_rdb_processes

125: FROM fnd_concurrent_requests
126: WHERE request_id = l_request_id;
127:
128:
129: INSERT INTO hxc_rdb_processes
130: ( request_id,
131: conc_program_id,
132: conc_program_name,
133: date_start,

Line 207: FROM hxc_rdb_processes rdb,

203: IS SELECT status_code,
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

Line 234: UPDATE hxc_rdb_processes

230:
231: IF l_status_tab.COUNT > 0
232: THEN
233: FORALL i IN l_status_tab.FIRST..l_status_tab.LAST
234: UPDATE hxc_rdb_processes
235: SET status = l_status_tab(i),
236: phase = l_phase_tab(i),
237: date_end = l_comp_tab(i)
238: WHERE ROWID = CHARTOROWID(l_row_tab(i));