APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on FND_ATTACHED_DOCUMENTS_S

Line 883: -- select fnd_attached_documents_s.nextval

879: IF l_action_type = 'ATTACH' THEN
880:
881: -- Swarnali - no longer needed with the new DOM package
882:
883: -- select fnd_attached_documents_s.nextval
884: -- into l_attachment_id from dual;
885:
886: -- insert into swarb values(2, 'inside attach ->', to_char(l_attachment_id));
887: -- commit;

Line 1111: select fnd_attached_documents_s.nextval

1107: select datatype_id, security_type, dm_node, dm_folder_path, dm_type, dm_document_id, dm_version_number
1108: into l_datatype_id, l_security_type, l_dm_node, l_dm_folder_path, l_dm_type, l_dm_document_id, l_dm_version_number
1109: from fnd_documents where document_id = l_source_doc_id;
1110: select file_name, description, media_id into l_file_name, l_description, l_media_id from fnd_documents_tl where document_id = l_source_doc_id and language = userenv('LANG');
1111: select fnd_attached_documents_s.nextval
1112: into l_attached_doc_id
1113: from dual;
1114: fnd_attached_documents_pkg.Insert_Row(
1115: X_Rowid => l_row_id,

Line 1159: update fnd_attached_documents set category_id = l_category_id, status = p_source_status where attached_document_id = l_attached_doc_id;

1155: X_doc_attribute14 => null,
1156: X_doc_attribute15 => null,
1157: X_create_doc => 'Y' -- Fix for 3762710
1158: );
1159: update fnd_attached_documents set category_id = l_category_id, status = p_source_status where attached_document_id = l_attached_doc_id;
1160: update fnd_documents set dm_node = l_dm_node, dm_folder_path = l_dm_folder_path, dm_type = l_dm_type, dm_document_id = l_dm_document_id, dm_version_number = l_dm_version_number where document_id = l_doc_id;
1161: x_new_attachment_id := l_attached_doc_id;
1162:
1163: -- Standard ending code ------------------------------------------------

Line 1248: -- vamohan: Fix for 3471772: commented out previous line since for a CO, once att changes are implemented, approval status in FND_ATTACHED_DOCUMENTS should be nulled out

1244: end if;
1245: elsif(l_base_change_mgmt_type_code = 'CHANGE_ORDER') then
1246: if(p_header_status = G_ENG_NOT_SUBMITTED) then
1247: x_attachment_status := G_APPROVED; -- x_attachment_status := G_PENDING_CHANGE;
1248: -- vamohan: Fix for 3471772: commented out previous line since for a CO, once att changes are implemented, approval status in FND_ATTACHED_DOCUMENTS should be nulled out
1249: return;
1250: elsif(p_header_status = G_ENG_APPR_APPROVED) then
1251: x_attachment_status := G_APPROVED;
1252: return;