APPS.CSF_REQUESTS_PVT dependencies on CSF_R_MESSAGES
Line 448: , csf_r_messages_s1.NEXTVAL message_id
444: l_api_version CONSTANT NUMBER := 1.0;
445:
446: CURSOR c_message(p_request_id NUMBER) IS
447: SELECT request_task_id 448: , csf_r_messages_s1.NEXTVAL message_id 449: FROM csf_r_request_tasks
450: WHERE sched_request_id = p_request_id
451: AND ROWNUM = 1; -- there should be one task per request
452:
Line 479: INSERT INTO csf_r_messages
475: RAISE NO_DATA_FOUND;
476: END IF;
477: CLOSE c_message;
478: 479: INSERT INTO csf_r_messages 480: (
481: message_id
482: , request_task_id
483: , name