APPS.IRC_JPS_GENERATOR dependencies on IRC_DOCUMENTS

Line 471: from irc_documents

467: ,p_stylesheet_content clob default null) is
468: --
469: cursor get_first_resume is
470: select document_id
471: from irc_documents
472: where person_id=p_person_id
473: and type='AUTO_RESUME'
474: and nvl(assignment_id,-1)=nvl(p_assignment_id,-1)
475: order by creation_date asc;

Line 549: update irc_documents

545: open get_first_resume;
546: fetch get_first_resume into l_document_id;
547: if get_first_resume%found then
548: l_overwriting:=true;
549: update irc_documents
550: set binary_doc=l_binary_doc
551: ,character_doc=empty_clob()
552: ,parsed_xml=l_parsed_xml
553: ,mime_type='text/html'

Line 575: update irc_documents

571: ,p_description=>l_description
572: ,p_document_id=>l_document_id
573: ,p_object_version_number=>l_ovn);
574: --
575: update irc_documents
576: set binary_doc=l_binary_doc
577: ,parsed_xml=l_parsed_xml
578: where document_id=l_document_id;
579: end if;