APPS.XNP_MESSAGE dependencies on DBMS_LOB

Line 383: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc);

379: END LOOP;
380:
381: IF l_rec_found THEN
382:
383: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc);
384:
385: DBMS_LOB.READ(lob_loc => l_lob_loc,
386: amount => l_amount_to_read,
387: offset => 1,

Line 385: DBMS_LOB.READ(lob_loc => l_lob_loc,

381: IF l_rec_found THEN
382:
383: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc);
384:
385: DBMS_LOB.READ(lob_loc => l_lob_loc,
386: amount => l_amount_to_read,
387: offset => 1,
388: buffer => x_msg_text );
389: END IF;

Line 424: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc) ;

420: END IF;
421:
422: CLOSE get_lob_loc ;
423:
424: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc) ;
425:
426: DBMS_LOB.READ(lob_loc => l_lob_loc,
427: amount => l_amount_to_read,
428: offset => 1,

Line 426: DBMS_LOB.READ(lob_loc => l_lob_loc,

422: CLOSE get_lob_loc ;
423:
424: l_amount_to_read := DBMS_LOB.GETLENGTH(l_lob_loc) ;
425:
426: DBMS_LOB.READ(lob_loc => l_lob_loc,
427: amount => l_amount_to_read,
428: offset => 1,
429: buffer => x_msg_text ) ;
430: END get;

Line 599: DBMS_LOB.WRITEAPPEND (lob_loc => l_lob_loc,

595:
596: FOR i IN 1..xdp_utilities.g_message_list.COUNT
597: LOOP
598:
599: DBMS_LOB.WRITEAPPEND (lob_loc => l_lob_loc,
600: amount =>LENGTH(xdp_utilities.g_message_list(i)),
601: buffer =>xdp_utilities.g_message_list(i));
602: END LOOP ;
603: ELSE

Line 604: DBMS_LOB.WRITE (lob_loc => l_lob_loc,

600: amount =>LENGTH(xdp_utilities.g_message_list(i)),
601: buffer =>xdp_utilities.g_message_list(i));
602: END LOOP ;
603: ELSE
604: DBMS_LOB.WRITE (lob_loc => l_lob_loc,
605: amount => LENGTH(p_body_text),
606: offset => 1,
607: buffer => p_body_text) ;
608: END IF ;

Line 2081: DBMS_LOB.FREETEMPORARY(XDP_UTILITIES.G_CLOB);

2077: message_properties => message_properties,
2078: payload => l_event,
2079: msgid => message_handle ) ;
2080:
2081: DBMS_LOB.FREETEMPORARY(XDP_UTILITIES.G_CLOB);
2082:
2083: END PUSH_WF;
2084: --Package initialization code
2085: