APPS.GR_ATTACH_DOCUMENTS_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 68: FROM fnd_attached_documents

64:
65: /* Used to see if this attachment already exists */
66: CURSOR c_attachment_exists IS
67: SELECT rowid, attached_document_id, seq_num
68: FROM fnd_attached_documents
69: WHERE entity_name = l_entity_name AND
70: NVL(pk1_value,'NULL') = NVL(l_pk1_value,'NULL') AND
71: NVL(pk2_value,'NULL') = NVL(l_pk2_value,'NULL') AND
72: NVL(pk3_value,'NULL') = NVL(l_pk3_value,'NULL') AND

Line 84: SELECT fnd_attached_documents_s.nextval

80: attribute5 = l_doc.doc_attribute5;
81:
82: /* Used to get the next attached_document_id for a new attachment */
83: CURSOR c_get_id IS
84: SELECT fnd_attached_documents_s.nextval
85: FROM dual;
86:
87: /* Used to get the next sequence number for a new attachment */
88: CURSOR c_get_seq IS

Line 90: FROM fnd_attached_documents

86:
87: /* Used to get the next sequence number for a new attachment */
88: CURSOR c_get_seq IS
89: SELECT NVL(max(seq_num),0) + 10
90: FROM fnd_attached_documents
91: WHERE entity_name = l_entity_name AND
92: NVL(pk1_value,'NULL') = NVL(l_pk1_value,'NULL') AND
93: NVL(pk2_value,'NULL') = NVL(l_pk2_value,'NULL') AND
94: NVL(pk3_value,'NULL') = NVL(l_pk3_value,'NULL') AND

Line 226: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(X_Rowid => l_Rowid,

222:
223: /* M. Grosser 11-Jan-2004 BUG 3359911 - Modified to correct overwrite of document
224: description
225: */
226: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(X_Rowid => l_Rowid,
227: X_attached_document_id => l_attached_document_id,
228: X_document_id => l_doc.document_id,
229: X_creation_date => SYSDATE,
230: X_created_by => l_doc.created_by,

Line 273: fnd_attached_documents_pkg.update_row(

269: X_attribute15 => l_doc.doc_attribute15,
270: X_create_doc => 'N');
271: ELSE
272: /* The attachment already exists so we will just update it with the new file */
273: fnd_attached_documents_pkg.update_row(
274: X_rowid => l_Rowid,
275: X_attached_document_id => l_attached_document_id,
276: X_document_id => l_document_id,
277: X_last_update_date => SYSDATE,