DBA Data[Home] [Help]

APPS.AMS_ATTACHMENT_PVT dependencies on FND_DOCUMENTS_PKG

Line 104: AMS_UTILITY_PVT.debug_message( 'Private API: Calling table handler fnd_documents_pkg.insert_row');

100: END IF;
101:
102: -- Debug Message
103: IF (AMS_DEBUG_HIGH_ON) THEN
104: AMS_UTILITY_PVT.debug_message( 'Private API: Calling table handler fnd_documents_pkg.insert_row');
105: END IF;
106:
107: l_media_id := p_Fnd_Attachment_rec.media_id;
108:

Line 110: fnd_documents_pkg.insert_row(

106:
107: l_media_id := p_Fnd_Attachment_rec.media_id;
108:
109: -- Invoke table handler
110: fnd_documents_pkg.insert_row(
111: X_rowid => l_row_id,
112: X_document_id => x_document_id,
113: X_creation_date => sysdate,
114: X_created_by => FND_GLOBAL.USER_ID,

Line 155: /* For File we have already generated a file id - the fnd_documents_pkg.insert_row

151:
152: end if;
153:
154: elsif (p_Fnd_Attachment_rec.datatype_id = 6) then /* File */
155: /* For File we have already generated a file id - the fnd_documents_pkg.insert_row
156: table handler has generated a fnd_lobs_s.nextval but that's not what shoule be the
157: reference to the FND_LOBS table - because the upload program has already generated a
158: sequence */
159: /**

Line 408: -- Invoke table handler(fnd_documents_pkg.update_row)

404: from dual;
405: end if;
406: end if;
407:
408: -- Invoke table handler(fnd_documents_pkg.update_row)
409: fnd_documents_pkg.update_row(
410: X_document_id => p_Fnd_Attachment_rec.document_id,
411: X_last_update_date => sysdate,
412: X_last_updated_by => FND_GLOBAL.USER_ID,

Line 409: fnd_documents_pkg.update_row(

405: end if;
406: end if;
407:
408: -- Invoke table handler(fnd_documents_pkg.update_row)
409: fnd_documents_pkg.update_row(
410: X_document_id => p_Fnd_Attachment_rec.document_id,
411: X_last_update_date => sysdate,
412: X_last_updated_by => FND_GLOBAL.USER_ID,
413: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 639: FND_DOCUMENTS_PKG.Delete_Row(

635: end if;
636:
637: if (l_use_fnd_api) then
638:
639: FND_DOCUMENTS_PKG.Delete_Row(
640: X_document_id => p_document_id,
641: X_datatype_id => p_datatype_id,
642: delete_ref_Flag => p_delete_attachment_ref_flag
643: );

Line 660: FND_DOCUMENTS_PKG.Delete_Row(

656:
657:
658: ELSE
659: /* For URL calling the FND API */
660: FND_DOCUMENTS_PKG.Delete_Row(
661: X_document_id => p_document_id,
662: X_datatype_id => p_datatype_id,
663: delete_ref_Flag => p_delete_attachment_ref_flag
664: );