APPS.CS_FORUM_MESSAGES_PKG dependencies on DBMS_LOB

Line 287: dbms_lob.compare(X_DESCRIPTION, tlinfo.DESCRIPTION,

283: if (tlinfo.BASELANG = 'Y') then
284: if ( ((tlinfo.NAME = X_NAME)
285: OR ((tlinfo.NAME is null) AND (X_NAME is null)))
286: AND ((
287: dbms_lob.compare(X_DESCRIPTION, tlinfo.DESCRIPTION,
288: dbms_lob.getlength(X_DESCRIPTION),1,1)=0 )
289: --tlinfo.DESCRIPTION = X_DESCRIPTION)
290: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
291: ) then

Line 288: dbms_lob.getlength(X_DESCRIPTION),1,1)=0 )

284: if ( ((tlinfo.NAME = X_NAME)
285: OR ((tlinfo.NAME is null) AND (X_NAME is null)))
286: AND ((
287: dbms_lob.compare(X_DESCRIPTION, tlinfo.DESCRIPTION,
288: dbms_lob.getlength(X_DESCRIPTION),1,1)=0 )
289: --tlinfo.DESCRIPTION = X_DESCRIPTION)
290: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
291: ) then
292: null;

Line 441: dbms_lob.compare(SUBB.DESCRIPTION, SUBT.DESCRIPTION,

437: and (SUBB.NAME <> SUBT.NAME
438: or (SUBB.NAME is null and SUBT.NAME is not null)
439: or (SUBB.NAME is not null and SUBT.NAME is null)
440: or --SUBB.DESCRIPTION <> SUBT.DESCRIPTION
441: dbms_lob.compare(SUBB.DESCRIPTION, SUBT.DESCRIPTION,
442: dbms_lob.getlength(SUBB.DESCRIPTION), 1, 1) <> 0
443: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
444: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
445: ));

Line 442: dbms_lob.getlength(SUBB.DESCRIPTION), 1, 1) <> 0

438: or (SUBB.NAME is null and SUBT.NAME is not null)
439: or (SUBB.NAME is not null and SUBT.NAME is null)
440: or --SUBB.DESCRIPTION <> SUBT.DESCRIPTION
441: dbms_lob.compare(SUBB.DESCRIPTION, SUBT.DESCRIPTION,
442: dbms_lob.getlength(SUBB.DESCRIPTION), 1, 1) <> 0
443: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
444: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
445: ));
446:

Line 531: dbms_lob.createtemporary(l_clob, TRUE, DBMS_LOB.SESSION);

527: end if;
528:
529: if( X_DESCRIPTION is not null) then
530:
531: dbms_lob.createtemporary(l_clob, TRUE, DBMS_LOB.SESSION);
532: l_offset := 1;
533: l_amt := length(x_description);
534: dbms_lob.write(l_clob, l_amt, l_offset, x_description);
535:

Line 534: dbms_lob.write(l_clob, l_amt, l_offset, x_description);

530:
531: dbms_lob.createtemporary(l_clob, TRUE, DBMS_LOB.SESSION);
532: l_offset := 1;
533: l_amt := length(x_description);
534: dbms_lob.write(l_clob, l_amt, l_offset, x_description);
535:
536: end if;
537:
538: CS_FORUM_MESSAGES_PKG.Update_Row(

Line 576: dbms_lob.freetemporary(l_clob);

572: X_Last_Update_Login => 0);
573:
574:
575: if(x_description is not null) then
576: dbms_lob.freetemporary(l_clob);
577: end if;
578:
579: end LOAD_ROW;
580: