APPS.ENG_CHANGE_TEXT_UTIL dependencies on DBMS_LOB

Line 92: DBMS_LOB.Trim ( lob_loc => x_tlob, newlen => 0 );

88:
89: IF ( p_action = 'BEGIN' ) THEN
90:
91: -- Empty the LOB, if this is the first chunk of text to append
92: DBMS_LOB.Trim ( lob_loc => x_tlob, newlen => 0 );
93:
94: g_Buffer := p_string;
95: g_Buffer_Length := -1;
96:

Line 110: DBMS_LOB.Write ( lob_loc => x_tlob

106: -- Write buffer to LOB if required
107:
108: IF ( g_Buffer_Length + l_String_Length >= l_Max_Length ) THEN
109: IF ( start_writing ) THEN
110: DBMS_LOB.Write ( lob_loc => x_tlob
111: , amount => Length (g_Buffer)
112: , offset => l_offset
113: , buffer => g_Buffer
114: );

Line 116: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

112: , offset => l_offset
113: , buffer => g_Buffer
114: );
115: ELSE
116: DBMS_LOB.WriteAppend ( lob_loc => x_tlob
117: , amount => Length (g_Buffer)
118: , buffer => g_Buffer
119: );
120: END IF;

Line 133: DBMS_LOB.Write ( lob_loc => x_tlob

129:
130: IF ( p_action = 'END' ) THEN
131: start_writing := ( g_Buffer_Length = -1 );
132: IF ( start_writing ) THEN
133: DBMS_LOB.Write ( lob_loc => x_tlob
134: , amount => Length (g_Buffer)
135: , offset => l_offset
136: , buffer => g_Buffer
137: );

Line 139: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

135: , offset => l_offset
136: , buffer => g_Buffer
137: );
138: ELSE
139: DBMS_LOB.WriteAppend ( lob_loc => x_tlob
140: , amount => Length (g_Buffer)
141: , buffer => g_Buffer
142: );
143: END IF;

Line 352: DBMS_LOB.Read ( lob_loc => p_tlob_loc

348: --DBMS_OUTPUT.put_line('LOB contents:');
349:
350: -- Read portions of LOB
351: LOOP
352: DBMS_LOB.Read ( lob_loc => p_tlob_loc
353: , amount => l_amount
354: , offset => l_offset
355: , buffer => l_buffer
356: );