','') ver_text,
3227: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ltrim(ut.object_text),
3228: ' | ',' '),'||||||||
3229: |||||||
|
|||
|
|||
|
||||
3230: ||||||||||||||||
3231: ||
||
||
||
||||||
Line 3696: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,' | ',' '),
3692:
3693: AND (
3694: (NVL(VER.DISPLAY_NAME,ART.ARTICLE_TITLE) <> to_char(UT.OBJECT_TITLE)) OR
3695: (NVL(ver.insert_by_reference,'N') = 'Y' AND
3696: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3697: '
||||||||
3698: |||||||
|
|||
|
|||
|
|||||
3699: |||||||||||||||
3700: ||
||
||
||
||||||
Line 3711: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3707: |
|
||
||
||
||||||
3708: |
||
||
||
||
|
|([[:cntrl:]])',''),unistr('\00a0'),' '),' ',''),
3709: '&|&|||||||||','')),-1) <> 0) OR
3710: (NVL(ver.insert_by_reference,'N') <> 'Y' AND
3711: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3712: '||||||||
3713: |||||||
|
|||
|
|||
|
|||||
3714: |||||||||||||||
3715: ||
||
||
||
||||||
Line 4063: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
4059: where document_type = p_document_type
4060: and document_id = p_document_id
4061: and object_type = 'ARTICLE'
4062: and action = 'UPDATED'
4063: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
4064:
4065: for ibr_csr in is_article_ibr(l_user_access) loop
4066: insert into okc_review_messages (
4067: review_messages_id,