255: where ENTITY_NAME='EDR_FILES_B' and
256: pk1_value=p_file_id and
257: document_id in (select document_id from fnd_documents_vl where category_id in
258: (select category_id
259: from fnd_document_categories_vl
260: where name = 'EDR_ISIGN_ADDL_FILES'));
261: l_count number;
262: BEGIN
263:
324: IF (L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS and l_erecord_id is not NULL) THEN
325: -- call copy attachment for each category
326: /* select Catgory id of checklist */
327: select category_id into l_category_id
328: from fnd_document_categories_vl
329: where name = 'EDR_ISIGN_ADDL_FILES';
330:
331: --Bug 4381237: Start
332: --Change the call to edr attachment API
372: where ENTITY_NAME='EDR_FILES_B' and
373: pk1_value=p_file_id and
374: document_id in (select document_id from fnd_documents_vl where category_id in
375: (select category_id
376: from fnd_document_categories_vl
377: where name = 'EDR_ISIGN_ADDL_FILES'));
378: Begin
379:
380: OPEN c1;