APPS.FND_ATTACHMENT_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 39: fnd_attached_documents fad

35: INTO l_exists
36: FROM fnd_doc_category_usages fdcu,
37: fnd_documents fd,
38: fnd_attachment_functions af,
39: fnd_attached_documents fad
40: WHERE fad.entity_name = l_entity_name
41: AND fad.pk1_value = l_pkey1
42: AND fad.pk2_value = l_pkey2
43: AND fad.pk3_value = l_pkey3

Line 64: fnd_attached_documents fad,

60: SELECT 'Y'
61: INTO l_exists
62: FROM fnd_doc_category_usages fdcu,
63: fnd_documents fd,
64: fnd_attached_documents fad,
65: fnd_attachment_functions af
66: WHERE fad.entity_name = l_entity_name
67: AND fad.pk1_value = l_pkey1
68: AND fad.pk2_value = l_pkey2

Line 91: fnd_attached_documents fad,

87: SELECT 'Y'
88: INTO l_exists
89: FROM fnd_doc_category_usages fdcu,
90: fnd_documents fd,
91: fnd_attached_documents fad,
92: fnd_attachment_functions af
93: WHERE fad.entity_name = l_entity_name
94: AND fad.pk1_value = l_pkey1
95: AND (l_pkey2 IS NULL

Line 162: 'SELECT 1 FROM fnd_attached_documents fad,'||

158: END IF;
159:
160:
161: l_sql_stmt := 'SELECT ''Y'' FROM dual WHERE EXISTS ('||
162: 'SELECT 1 FROM fnd_attached_documents fad,'||
163: 'fnd_doc_category_usages fdcu,'||
164: 'fnd_attachment_functions af,'||
165: 'fnd_documents fd '||
166: 'WHERE fad.entity_name = :ename '||

Line 650: update fnd_attached_documents

646: end if;
647:
648: if (p_from_fk_id <> p_to_fk_id) then
649:
650: update fnd_attached_documents
651: set pk1_value = p_to_fk_id
652: where pk1_value = p_from_fk_id
653: and entity_name = pen;
654: -- For Bulk processing this condition has been removed. Updated ldt to include

Line 675: FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE

671: INDEX BY BINARY_INTEGER;
672: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
673:
674: TYPE PK1_VALUE_LIST_TYPE IS TABLE OF
675: FND_ATTACHED_DOCUMENTS.PK1_VALUE%TYPE
676: INDEX BY BINARY_INTEGER;
677: NUM_COL1_ORIG_LIST PK1_VALUE_LIST_TYPE;
678: NUM_COL1_NEW_LIST PK1_VALUE_LIST_TYPE;
679:

Line 684: FROM FND_ATTACHED_DOCUMENTS yt, ra_customer_merges m

680: l_profile_val VARCHAR2(30);
681: CURSOR merged_records IS
682: SELECT distinct CUSTOMER_MERGE_HEADER_ID
683: ,PK1_VALUE
684: FROM FND_ATTACHED_DOCUMENTS yt, ra_customer_merges m
685: WHERE (
686: yt.PK1_VALUE = m.DUPLICATE_ID
687: AND yt.entity_name = 'AR_CUSTOMERS'
688: ) AND m.process_flag = 'N'

Line 698: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FND_ATTACHED_DOCUMENTS',FALSE);

694: IF process_mode='LOCK' THEN
695: NULL;
696: ELSE
697: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
698: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FND_ATTACHED_DOCUMENTS',FALSE);
699: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
700: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
701:
702: open merged_records;

Line 734: 'FND_ATTACHED_DOCUMENTS',

730: LAST_UPDATE_LOGIN,
731: LAST_UPDATE_DATE,
732: LAST_UPDATED_BY
733: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
734: 'FND_ATTACHED_DOCUMENTS',
735: MERGE_HEADER_ID_LIST(I),
736: NUM_COL1_ORIG_LIST(I),
737: NUM_COL1_NEW_LIST(I),
738: 'U',

Line 749: UPDATE FND_ATTACHED_DOCUMENTS yt SET

745: );
746: END IF;
747:
748: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
749: UPDATE FND_ATTACHED_DOCUMENTS yt SET
750: PK1_VALUE=NUM_COL1_NEW_LIST(I)
751: , SEQ_NUM = seq_num+1
752: , LAST_UPDATE_DATE=SYSDATE
753: , last_updated_by=arp_standard.profile.user_id