[Home] [Help]
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
492: AND fnddoccat_tl.language = asg.language
493: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
494: AND asg.user_id = b_user_id
495: AND fnddoccat_tl.name = 'SIGNATURE'
496: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
497: AND fnddoc.datatype_id =6
498: AND doctype.datatype_id = fnddoc.datatype_id
499: AND doctype.language = asg.language
500: AND acc.user_id = asg.user_id;
796: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
797: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
798: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
799: fnddoc.document_id,fnddoc_tl.title
800: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
801: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
802: -- fnd_lobs lobs,
803: fnd_document_categories_tl fnddoccat_tl,
804: csm_debrief_headers_acc acc,asg_user asg,
806: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
807: AND acc.debrief_header_id = dbfhdr.debrief_header_id
808: AND acc.user_id = b_user_id
809: AND asg.user_id = b_user_id
810: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
811: AND fndatt.pk1_value = dbfhdr.debrief_header_id
812: AND fndatt.document_id = fnddoc_tl.document_id
813: AND fnddoc_tl.document_id = fnddoc.document_id
814: AND fnddoc_tl.language = b_lang
1191: CURSOR l_signature_csr(b_task_assignment_id IN number, b_user_id IN number)
1192: IS
1193: SELECT acc.access_id, acc.user_id
1194: FROM csm_fnd_lobs_acc acc,
1195: csf_debrief_headers dbh
1196: WHERE acc.user_id = b_user_id
1197: AND acc.entity_name = 'CSF_DEBRIEF_HEADERS'
1198: AND dbh.task_assignment_id = b_task_assignment_id
1199: AND acc.pk1_value = to_char(dbh.debrief_header_id);
1193: SELECT acc.access_id, acc.user_id
1194: FROM csm_fnd_lobs_acc acc,
1195: csf_debrief_headers dbh
1196: WHERE acc.user_id = b_user_id
1197: AND acc.entity_name = 'CSF_DEBRIEF_HEADERS'
1198: AND dbh.task_assignment_id = b_task_assignment_id
1199: AND acc.pk1_value = to_char(dbh.debrief_header_id);
1200:
1201: --Cursor for SR attachments
1499: AND fnddoccat_tl.language = asg.language
1500: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
1501: AND acc.debrief_header_id = b_debrief_id
1502: AND fnddoccat_tl.name = 'SIGNATURE'
1503: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
1504: AND fnddoc.datatype_id =b_data_typeid
1505: AND doctype.datatype_id = fnddoc.datatype_id
1506: AND doctype.language = asg.language
1507: AND acc.user_id = asg.user_id
1620:
1621: END IF;
1622:
1623: --Bug 5726888
1624: IF p_entity_name = 'CSF_DEBRIEF_HEADERS' THEN
1625: --- SIGNATURE DOWNLOAD
1626: OPEN c_Signature(p_PK1_value, p_user_id,p_data_typeid);
1627: FETCH c_Signature BULK COLLECT INTO l_tab_access_id, l_tab_file_id, l_tab_user_id, l_tab_name,
1628: l_tab_description, l_tab_language, l_tab_entity_name, l_tab_pk1_value,