','') ver_text,
3118: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ltrim(ut.object_text),
3119: ' | ',' '),'||||||||
3120: |||||||
|
|||
|
|||
|
||||
3121: ||||||||||||||||
3122: ||
||
||
||
||||||
Line 3550: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,' | ',' '),
3546:
3547: AND (
3548: (NVL(VER.DISPLAY_NAME,ART.ARTICLE_TITLE) <> to_char(UT.OBJECT_TITLE)) OR
3549: (NVL(ver.insert_by_reference,'N') = 'Y' AND
3550: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3551: '
||||||||
3552: |||||||
|
|||
|
|||
|
|||||
3553: |||||||||||||||
3554: ||
||
||
||
||||||
Line 3563: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3559: ||||||||||||||||
3560: |
|
||
||
||
||||||
3561: |
||
||
||
||
|
|([[:cntrl:]])',''),unistr('\00a0'),' '),' ',''), '&|&||||||','')),-1) <> 0) OR
3562: (NVL(ver.insert_by_reference,'N') <> 'Y' AND
3563: NVL(dbms_lob.compare(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(ut.object_text,'&NBSP;| ',' '),
3564: '||||||||
3565: |||||||
|
|||
|
|||
|
|||||
3566: |||||||||||||||
3567: ||
||
||
||
||||||
Line 3902: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
3898: where document_type = p_document_type
3899: and document_id = p_document_id
3900: and object_type = 'ARTICLE'
3901: and action = 'UPDATED'
3902: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
3903:
3904: for ibr_csr in is_article_ibr(l_user_access) loop
3905: insert into okc_review_messages (
3906: review_messages_id,