[Home] [Help]
817:
818: -- get values for fnd_user and fnd_login
819: SELECT fnd_global.user_id, fnd_global.login_id
820: INTO l_fnd_user_id, l_fnd_login_id
821: FROM dual;
822:
823: -- First check if there are floating versions in the CO to be implemented.
824: -- if there are flaoting version, check its change policy and ensure that
825: -- it is not under CO Required. If it is CO required, the implementation
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;
888:
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: -- Real code starts here -----------------------------------------------
1103: l_fnd_user_id := fnd_global.user_id; -- -1; -- Bug 3700111
1104: l_fnd_login_id := fnd_global.login_id; -- ''; -- Bug 3700111
1105: select userenv('LANG') into l_language from dual;
1106: select category_id, document_id into l_category_id, l_source_doc_id from fnd_attached_documents where attached_document_id = p_source_attachment_id;
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;
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,
1116: X_attached_document_id => l_attached_doc_id,
1117: X_document_id => l_doc_id,
2422: and action_type in ('ATTACH','CHANGE_REVISION','CHANGE_VERSION_LABEL')
2423: and revised_item_sequence_id in (select decode(l_revised_item_seq_id,null, (select revised_item_sequence_id
2424: from eng_revised_items
2425: where change_id = a.change_id),
2426: l_revised_item_seq_id) from dual);
2427:
2428: l_change_id NUMBER;
2429: l_revised_item_seq_id NUMBER;
2430: l_change_policy VARCHAR2(100);