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 173: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN

169: 'CSM_LOBS_PKG.APPLY_INSERT',
170: FND_LOG.LEVEL_PROCEDURE );
171:
172: --if attachments are not part of what we support then we leave
173: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
174:
175: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'||
176: ' as we are not supporting Attachment for the entity' || TO_CHAR(p_record.entity_name);
177: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE );

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

198: ELSIF p_record.entity_name = 'CS_INCIDENTS' THEN
199: l_function_name := 'CSXSRISR';
200: END IF;
201:
202: ELSIF p_record.entity_name = 'CSF_DEBRIEF_HEADERS' THEN
203: --Else is for signature upload for debrief
204: l_category_name := 'SIGNATURE';
205: l_file_name := 'INTERNAL';
206: l_file_content_type := 'image/bmp';

Line 207: l_entity_name := 'CSF_DEBRIEF_HEADERS';

203: --Else is for signature upload for debrief
204: l_category_name := 'SIGNATURE';
205: l_file_name := 'INTERNAL';
206: l_file_content_type := 'image/bmp';
207: l_entity_name := 'CSF_DEBRIEF_HEADERS';
208: l_function_name := 'CSFFEDBF';
209: -- Bug 5726888
210: l_data_type_id :=6;
211: --required only for signature...