[Home] [Help]
184: LocalEventRecord c_get_event%ROWTYPE;
185:
186: /* Used to get the next attached_document_id for a new attachment SKARIMIS*/
187: CURSOR c_get_id IS
188: SELECT fnd_attached_documents_s.nextval
189: FROM dual;
190:
191: /* Used to check if the attribute is required in the flexfield */
192: CURSOR c_get_flex1 IS
398: -- we would have to insert a row in:
399: -- edr_files_b/tl
400: -- fnd_documents
401: --fnd_lobs
402: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
403:
404: --CJ look at the new definition of this package
405: --it would not have the BLOB col FILE_DATA
406: --change this call accordingly
440: X_LAST_UPDATED_BY=>p_last_updated_by,
441: X_LAST_UPDATE_LOGIN =>p_last_update_login);
442:
443: --CJ now that the row is inserted in edr_files table
444: -- we have insert into fn_documents, fnd_attached_documents
445: -- and fnd_lobs
446:
447: --CJ to insert in fnd_documents and fnd_attached_dcouments
448: --use FND_ATTACHED_DOCUMENTS_PKG.Insert_Row
444: -- we have insert into fn_documents, fnd_attached_documents
445: -- and fnd_lobs
446:
447: --CJ to insert in fnd_documents and fnd_attached_dcouments
448: --use FND_ATTACHED_DOCUMENTS_PKG.Insert_Row
449: -- i am attaching the java code to help u understand
450: -- the parameters to be passed
451:
452: OPEN c_get_id;
452: OPEN c_get_id;
453: FETCH c_get_id INTO l_attached_document_id;
454: CLOSE c_get_id;
455:
456: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(X_Rowid=>l_row_id,
457: X_attached_document_id=>l_attached_document_id,
458: X_document_id=>x_document_id,
459: X_creation_date=>p_creation_date,
460: X_created_by=>p_created_by,
741:
742: /* ------------------ CURSORS ---------------------- */
743: CURSOR c_get_event_key IS
744: SELECT file_id
745: FROM fnd_attached_documents f, edr_files_b e
746: WHERE entity_name = p_entity_name
747: AND pk1_value = p_pk1_value
748: AND NVL(pk2_value,' ') = NVL(p_pk2_value,' ')
749: AND NVL(pk3_value,' ') = NVL(p_pk3_value,' ')