APPS.IRC_JPS_GENERATOR dependencies on IRC_DOCUMENTS

Line 463: from irc_documents

459: ,p_overwrite boolean default true) is
460: --
461: cursor get_first_resume is
462: select document_id
463: from irc_documents
464: where person_id=p_person_id
465: and type='AUTO_RESUME'
466: and nvl(assignment_id,-1)=nvl(p_assignment_id,-1)
467: order by creation_date asc;

Line 540: update irc_documents

536: open get_first_resume;
537: fetch get_first_resume into l_document_id;
538: if get_first_resume%found then
539: l_overwriting:=true;
540: update irc_documents
541: set binary_doc=l_binary_doc
542: ,character_doc=empty_clob()
543: ,parsed_xml=l_parsed_xml
544: ,mime_type='text/html'

Line 566: update irc_documents

562: ,p_description=>l_description
563: ,p_document_id=>l_document_id
564: ,p_object_version_number=>l_ovn);
565: --
566: update irc_documents
567: set binary_doc=l_binary_doc
568: ,parsed_xml=l_parsed_xml
569: where document_id=l_document_id;
570: end if;