DBA Data[Home] [Help]

APPS.OKE_MILPAC_INTG_WF dependencies on FND_ATTACHED_DOCUMENTS

Line 235: , fnd_attached_documents_s.nextval attached_document_id

231: CURSOR f IS
232: SELECT form_header_number
233: , print_form_code
234: , k_header_id
235: , fnd_attached_documents_s.nextval attached_document_id
236: FROM oke_k_form_headers
237: WHERE form_header_id = FormHeaderID;
238: frec f%rowtype;
239:

Line 274: FROM fnd_attached_documents

270: CLOSE f;
271:
272: SELECT nvl(max(seq_num) , 0) + 1
273: INTO SeqNum
274: FROM fnd_attached_documents
275: WHERE entity_name = 'OKE_K_FORM_HEADERS'
276: AND pk1_value = frec.print_form_code
277: AND pk2_value = to_char(frec.k_header_id)
278: AND pk3_value is null;

Line 290: fnd_attached_documents_pkg.insert_row

286: fnd_message.set_token('FORM' , frec.form_header_number);
287: fnd_message.set_token('DATE' , FND_DATE.date_to_displaydt( FormCreationDate ) );
288: AttachmentDesc := fnd_message.get;
289:
290: fnd_attached_documents_pkg.insert_row
291: ( X_ROWID => RowID
292: , X_ATTACHED_DOCUMENT_ID => frec.attached_document_id
293: , X_DOCUMENT_ID => DocumentID
294: , X_CREATION_DATE => sysdate