APPS.LNS_CUSTOM_PUB dependencies on DBMS_LOB

Line 5081: l_clob_length := sys.DBMS_LOB.getlength(P_CLOB);

5077: -- START OF BODY OF API
5078: l_COMBINE_INT_WITH_LAST_PRIN := 'N';
5079:
5080: -- read clob
5081: l_clob_length := sys.DBMS_LOB.getlength(P_CLOB);
5082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_clob_length = ' || l_clob_length);
5083:
5084: if l_clob_length > 0 then
5085:

Line 5091: l_end := DBMS_LOB.INSTR (lob_loc => P_CLOB, pattern => FND_GLOBAL.LOCAL_CHR(10), offset => l_start);

5087: l_start := 1;
5088: while l_start > 0 loop
5089:
5090: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_start = ' || l_start);
5091: l_end := DBMS_LOB.INSTR (lob_loc => P_CLOB, pattern => FND_GLOBAL.LOCAL_CHR(10), offset => l_start);
5092: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_end = ' || l_end);
5093:
5094: IF l_end > 0 THEN
5095: l_record :=

Line 5097: DBMS_LOB.SUBSTR (lob_loc => P_CLOB,

5093:
5094: IF l_end > 0 THEN
5095: l_record :=
5096: RTRIM (
5097: DBMS_LOB.SUBSTR (lob_loc => P_CLOB,
5098: amount => LEAST (l_end - l_start, 512),
5099: offset => l_start
5100: ),
5101: FND_GLOBAL.LOCAL_CHR(13) || FND_GLOBAL.LOCAL_CHR(10)

Line 5105: l_record := DBMS_LOB.SUBSTR (lob_loc => P_CLOB,

5101: FND_GLOBAL.LOCAL_CHR(13) || FND_GLOBAL.LOCAL_CHR(10)
5102: );
5103: l_start := l_end + 1;
5104: ELSE
5105: l_record := DBMS_LOB.SUBSTR (lob_loc => P_CLOB,
5106: amount => l_clob_length - l_start + 1,
5107: offset => l_start
5108: );
5109: l_start := 0;