APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_DOCUMENTS_TL

Line 446: select count(*) into v_steps_attach_cnt from fnd_documents_tl where document_id in (

442: FOR step_attach_rec IN c_steps_attach LOOP
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

Line 908: Update fnd_documents_tl because FND_API inserts newly generated

904: p_Fnd_Attachment_rec.short_text
905: );
906: else
907: /*
908: Update fnd_documents_tl because FND_API inserts newly generated
909: media_id into that table.
910: */
911: update fnd_documents_tl
912: set media_id = p_Fnd_Attachment_rec.media_id

Line 911: update fnd_documents_tl

907: /*
908: Update fnd_documents_tl because FND_API inserts newly generated
909: media_id into that table.
910: */
911: update fnd_documents_tl
912: set media_id = p_Fnd_Attachment_rec.media_id
913: where document_id = x_document_id;
914:
915: end if;

Line 923: update fnd_documents_tl

919: table handler has generated a fnd_lobs_s.nextval but that's not what shoule be the
920: reference to the FND_LOBS table - because the upload program has already generated a
921: sequence */
922: /**
923: update fnd_documents_tl
924: set media_id = p_Fnd_Attachment_rec.media_id
925: where document_id = l_document_id;
926: **/
927: null;