APPS.CSF_REQUESTS_PVT dependencies on CSF_R_MESSAGES
Line 470: , csf_r_messages_s1.NEXTVAL message_id
466: l_api_version CONSTANT NUMBER := 1.0;
467:
468: CURSOR c_message(p_request_id NUMBER) IS
469: SELECT request_task_id 470: , csf_r_messages_s1.NEXTVAL message_id 471: FROM csf_r_request_tasks
472: WHERE sched_request_id = p_request_id
473: AND ROWNUM = 1; -- there should be one task per request
474:
Line 501: INSERT INTO csf_r_messages
497: RAISE NO_DATA_FOUND;
498: END IF;
499: CLOSE c_message;
500: 501: INSERT INTO csf_r_messages 502: (
503: message_id
504: , request_task_id
505: , name