42: close att_func_exists;
43: -- if it doesn't exist then add it
44: select fnd_attachment_functions_s.nextval
45: into l_attachment_function_id
46: from sys.dual;
47: --
48: insert into fnd_attachment_functions (
49: attachment_function_id,
50: function_type,
128: close category_exists;
129: -- if not associated, then add it
130: select fnd_doc_category_usages_s.nextval
131: into l_doc_category_usages_id
132: from sys.dual;
133: --
134: INSERT INTO fnd_doc_category_usages(
135: doc_category_usage_id,
136: category_id,
206: close block_exists;
207: -- if it doesn't then add it
208: select fnd_attachment_blocks_s.nextval
209: into l_attachment_blk_id
210: from sys.dual;
211: --
212: INSERT INTO fnd_attachment_blocks (
213: attachment_blk_id,
214: attachment_function_id,
304: close entity_exists;
305: -- if not then add it
306: select fnd_document_entities_s.nextval
307: into l_document_entity_id
308: from sys.dual;
309: --
310: insert into fnd_document_entities (
311: DOCUMENT_ENTITY_ID,
312: DATA_OBJECT_CODE,
420: close block_entity_exists;
421: -- if it is not then add it
422: select fnd_attachment_blk_entities_s.nextval
423: into l_attachment_blk_entity_id
424: from sys.dual;
425: --
426: INSERT INTO fnd_attachment_blk_entities (
427: attachment_blk_entity_id,
428: attachment_blk_id,