APPS.CSF_REQUESTS_PVT dependencies on CSF_R_REQUEST_TASKS

Line 105: -- insert task into the csf_r_request_tasks table

101: END
102: )
103: RETURNING sched_request_id INTO x_request_id;
104:
105: -- insert task into the csf_r_request_tasks table
106: INSERT INTO csf_r_request_tasks(
107: request_task_id
108: , sched_request_id
109: , task_id

Line 106: INSERT INTO csf_r_request_tasks(

102: )
103: RETURNING sched_request_id INTO x_request_id;
104:
105: -- insert task into the csf_r_request_tasks table
106: INSERT INTO csf_r_request_tasks(
107: request_task_id
108: , sched_request_id
109: , task_id
110: , object_version_number

Line 113: csf_r_request_tasks_s1.NEXTVAL

109: , task_id
110: , object_version_number
111: )
112: VALUES (
113: csf_r_request_tasks_s1.NEXTVAL
114: , x_request_id
115: , p_object_id
116: , 1
117: )

Line 471: FROM csf_r_request_tasks

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:
475: l_rec c_message%ROWTYPE;