APPS.CSM_LOBS_EVENT_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 143: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'

139: AND fnddoccat_tl.category_id = fnddoc.category_id
140: AND fnddoccat_tl.language = asg.language
141: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
142: AND fnddoccat_tl.name = 'SIGNATURE'
143: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
144: AND fnddoc.datatype_id =6
145: AND doctype.datatype_id = fnddoc.datatype_id
146: AND doctype.language = asg.language
147: AND acc.user_id = asg.user_id

Line 561: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'

557: AND fnddoccat_tl.language = asg.language
558: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
559: AND asg.user_id = b_user_id
560: AND fnddoccat_tl.name = 'SIGNATURE'
561: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
562: AND fnddoc.datatype_id =6
563: AND doctype.datatype_id = fnddoc.datatype_id
564: AND doctype.language = asg.language
565: AND acc.user_id = asg.user_id;

Line 865: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,

861: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
862: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
863: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
864: fnddoc.document_id,fnddoc_tl.title
865: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
866: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
867: -- fnd_lobs lobs,
868: fnd_document_categories_tl fnddoccat_tl,
869: csm_debrief_headers_acc acc,asg_user asg,

Line 875: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'

871: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
872: AND acc.debrief_header_id = dbfhdr.debrief_header_id
873: AND acc.user_id = b_user_id
874: AND asg.user_id = b_user_id
875: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
876: AND fndatt.pk1_value = dbfhdr.debrief_header_id
877: AND fndatt.document_id = fnddoc_tl.document_id
878: AND fnddoc_tl.document_id = fnddoc.document_id
879: AND fnddoc_tl.language = b_lang

Line 1260: csf_debrief_headers dbh

1256: CURSOR l_signature_csr(b_task_assignment_id IN number, b_user_id IN number)
1257: IS
1258: SELECT acc.access_id, acc.user_id
1259: FROM csm_fnd_lobs_acc acc,
1260: csf_debrief_headers dbh
1261: WHERE acc.user_id = b_user_id
1262: AND acc.entity_name = 'CSF_DEBRIEF_HEADERS'
1263: AND dbh.task_assignment_id = b_task_assignment_id
1264: AND acc.pk1_value = to_char(dbh.debrief_header_id);

Line 1262: AND acc.entity_name = 'CSF_DEBRIEF_HEADERS'

1258: SELECT acc.access_id, acc.user_id
1259: FROM csm_fnd_lobs_acc acc,
1260: csf_debrief_headers dbh
1261: WHERE acc.user_id = b_user_id
1262: AND acc.entity_name = 'CSF_DEBRIEF_HEADERS'
1263: AND dbh.task_assignment_id = b_task_assignment_id
1264: AND acc.pk1_value = to_char(dbh.debrief_header_id);
1265:
1266: --Cursor for SR attachments

Line 1568: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'

1564: AND fnddoccat_tl.language = asg.language
1565: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
1566: AND acc.debrief_header_id = b_debrief_id
1567: AND fnddoccat_tl.name = 'SIGNATURE'
1568: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
1569: AND fnddoc.datatype_id =b_data_typeid
1570: AND doctype.datatype_id = fnddoc.datatype_id
1571: AND doctype.language = asg.language
1572: AND acc.user_id = asg.user_id

Line 1689: IF p_entity_name = 'CSF_DEBRIEF_HEADERS' THEN

1685:
1686: END IF;
1687:
1688: --Bug 5726888
1689: IF p_entity_name = 'CSF_DEBRIEF_HEADERS' THEN
1690: --- SIGNATURE DOWNLOAD
1691: OPEN c_Signature(p_PK1_value, p_user_id,p_data_typeid);
1692: FETCH c_Signature BULK COLLECT INTO l_tab_access_id, l_tab_file_id, l_tab_user_id, l_tab_name,
1693: l_tab_description, l_tab_language, l_tab_entity_name, l_tab_pk1_value,