[Home] [Help]
443:
444: if(step_attach_rec.steps_attachment_url IS NOT NULL) THEN
445:
446: select count(*) into v_steps_attach_cnt from fnd_documents_tl where document_id in (
447: SELECT document_id FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROJECT_STEP'
448: AND PK1_VALUE = step_attach_rec.audit_project_id
449: AND PK2_VALUE = step_attach_rec.organization_id
450: AND PK3_VALUE = step_attach_rec.task_id AND PK4_VALUE = step_attach_rec.audit_procedure_rev_id
451: AND PK5_VALUE = step_attach_rec.step_id) and file_name = step_attach_rec.steps_attachment_url
451: AND PK5_VALUE = step_attach_rec.step_id) and file_name = step_attach_rec.steps_attachment_url
452: and language(+)= userenv('LANG');
453: if v_steps_attach_cnt = 0 then
454: BEGIN
455: SELECT MAX(SEQ_NUM) INTO L_SEQ_NUM FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME='AMW_PROJECT_STEP'
456: AND PK1_VALUE = step_attach_rec.audit_project_id
457: AND PK2_VALUE = step_attach_rec.organization_id
458: AND PK3_VALUE = step_attach_rec.task_id AND PK4_VALUE = step_attach_rec.audit_procedure_rev_id
459: AND PK5_VALUE = step_attach_rec.step_id;
813: l_Fnd_Attachment_rec fnd_attachment_rec_type;
814: l_create_Attached_Doc boolean := true;
815:
816: CURSOR c_attached_doc_id IS
817: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
818: FROM dual;
819:
820: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
821: SELECT 1
818: FROM dual;
819:
820: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
821: SELECT 1
822: FROM FND_ATTACHED_DOCUMENTS
823: WHERE document_id = l_id;
824:
825: BEGIN
826: -- Standard Start of API savepoint
959: x_attached_document_id := l_attached_document_id;
960:
961:
962: /* Populate FND Attachments */
963: fnd_attached_documents_pkg.Insert_Row
964: ( x_rowid => l_row_id,
965: X_attached_document_id => l_attached_document_ID,
966: X_document_id => x_document_ID,
967: X_creation_date => sysdate,