DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_ATTACHED_DOCUMENTS

Line 32: entity_name fnd_attached_documents.entity_name%TYPE,

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;

Line 33: pk1_value fnd_attached_documents.pk1_value%TYPE,

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,

Line 34: automatically_added_flag fnd_attached_documents.automatically_added_Flag%TYPE,

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,

Line 177: INSERT INTO fnd_attached_documents (

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,