APPS.CSM_LOBS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 96: FROM csf_debrief_headers

92: -- use the first debrief header id
93: CURSOR l_debrief_header_id_csr(p_task_assignment_id IN number)
94: IS
95: SELECT debrief_header_id
96: FROM csf_debrief_headers
97: WHERE task_assignment_id = p_task_assignment_id
98: ORDER BY debrief_header_id;
99:
100: -- get max seq no for the debrief_header_id

Line 162: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN

158: 'CSM_LOBS_PKG.APPLY_INSERT',
159: FND_LOG.LEVEL_PROCEDURE );
160:
161: --if attachments are not part of what we support then we leave
162: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
163:
164: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'||
165: ' as we are not supporting Attachment for the entity' || TO_CHAR(p_record.entity_name);
166: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE );

Line 191: ELSIF p_record.entity_name = 'CSF_DEBRIEF_HEADERS' THEN

187: ELSIF p_record.entity_name = 'CS_INCIDENTS' THEN
188: l_function_name := 'CSXSRISR';
189: END IF;
190:
191: ELSIF p_record.entity_name = 'CSF_DEBRIEF_HEADERS' THEN
192: --Else is for signature upload for debrief
193: l_category_name := 'SIGNATURE';
194: l_file_name := 'INTERNAL';
195: l_file_content_type := 'image/bmp';

Line 196: l_entity_name := 'CSF_DEBRIEF_HEADERS';

192: --Else is for signature upload for debrief
193: l_category_name := 'SIGNATURE';
194: l_file_name := 'INTERNAL';
195: l_file_content_type := 'image/bmp';
196: l_entity_name := 'CSF_DEBRIEF_HEADERS';
197: l_function_name := 'CSFFEDBF';
198: -- Bug 5726888
199: l_data_type_id :=6;
200: --required only for signature...