28: last_update_date DATE,
29: last_updated_by NUMBER,
30: last_update_login NUMBER,
31: seq_num NUMBER,
32: entity_name fnd_attached_documents.entity_name%TYPE,
33: pk1_value fnd_attached_documents.pk1_value%TYPE,
34: automatically_added_flag fnd_attached_documents.automatically_added_Flag%TYPE,
35: attachment_category_id NUMBER);
36: TYPE t_attachdoc IS TABLE OF l_attachdoc INDEX BY BINARY_INTEGER;
29: last_updated_by NUMBER,
30: last_update_login NUMBER,
31: seq_num NUMBER,
32: entity_name fnd_attached_documents.entity_name%TYPE,
33: pk1_value fnd_attached_documents.pk1_value%TYPE,
34: automatically_added_flag fnd_attached_documents.automatically_added_Flag%TYPE,
35: attachment_category_id NUMBER);
36: TYPE t_attachdoc IS TABLE OF l_attachdoc INDEX BY BINARY_INTEGER;
37: TYPE l_lob IS RECORD (post_state NUMBER,
30: last_update_login NUMBER,
31: seq_num NUMBER,
32: entity_name fnd_attached_documents.entity_name%TYPE,
33: pk1_value fnd_attached_documents.pk1_value%TYPE,
34: automatically_added_flag fnd_attached_documents.automatically_added_Flag%TYPE,
35: attachment_category_id NUMBER);
36: TYPE t_attachdoc IS TABLE OF l_attachdoc INDEX BY BINARY_INTEGER;
37: TYPE l_lob IS RECORD (post_state NUMBER,
38: file_id NUMBER,
173: -- Now create attached document row
174: FOR k IN gt_attachdoc.FIRST..gt_attachdoc.LAST
175: LOOP
176: IF gt_doc(i).document_id = gt_attachdoc(k).document_id THEN --- found a matching document, create now.
177: INSERT INTO fnd_attached_documents (
178: attached_document_id,
179: document_id,
180: creation_date,
181: created_by,