DBA Data[Home] [Help]

APPS.FND_CONCURRENT_BUSINESS_EVENT dependencies on FND_CONC_PROG_ONSITE_INFO

Line 206: from fnd_conc_prog_onsite_info

202: from fnd_concurrent_requests
203: where request_id = p_request_id;
204:
205: select business_event_map into v_event_map_info
206: from fnd_conc_prog_onsite_info
207: where program_application_id = v_program_application_id
208: and concurrent_program_id = v_concurrent_program_id;
209:
210: -- is 'Y' there at the right place for me?

Line 290: from fnd_conc_prog_onsite_info

286:
287: -- check for obvious errors
288: select count(*)
289: into v_temp_count
290: from fnd_conc_prog_onsite_info
291: where program_application_id = p_application_id
292: and concurrent_program_id = p_concurrent_program_id;
293:
294: if (v_temp_count <> 1) then

Line 305: from fnd_conc_prog_onsite_info

301:
302: -- read the current state of the events padded with Ns to make up 50 positions
303: select RPAD(business_event_map, 50, 'N')
304: into v_current_state
305: from fnd_conc_prog_onsite_info
306: where program_application_id = p_application_id
307: and concurrent_program_id = p_concurrent_program_id;
308:
309: -- rpad doesn't work if data was null to begin with...

Line 322: update fnd_conc_prog_onsite_info

318: v_new_char := concat(v_left_char, p_new_status);
319: v_new_char := concat(v_new_char, v_right_char);
320:
321: -- update table with new status
322: update fnd_conc_prog_onsite_info
323: set business_event_map = v_new_char
324: where program_application_id = p_application_id
325: and concurrent_program_id = p_concurrent_program_id;
326: