DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on DBMS_LOB

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

68:
69: IF ( p_action = 'BEGIN' ) THEN
70:
71: -- Empty the LOB, if this is the first chunk of text to append
72: DBMS_LOB.Trim ( lob_loc => x_tlob, newlen => 0 );
73:
74: g_Buffer := p_string;
75: g_Buffer_Length := -1;
76:

Line 90: DBMS_LOB.Write ( lob_loc => x_tlob

86: -- Write buffer to LOB if required
87:
88: IF ( g_Buffer_Length + l_String_Length >= l_Max_Length ) THEN
89: IF ( start_writing ) THEN
90: DBMS_LOB.Write ( lob_loc => x_tlob
91: , amount => Length (g_Buffer)
92: , offset => l_offset
93: , buffer => g_Buffer
94: );

Line 96: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

92: , offset => l_offset
93: , buffer => g_Buffer
94: );
95: ELSE
96: DBMS_LOB.WriteAppend ( lob_loc => x_tlob
97: , amount => Length (g_Buffer)
98: , buffer => g_Buffer
99: );
100: END IF;

Line 113: DBMS_LOB.Write ( lob_loc => x_tlob

109:
110: IF ( p_action = 'END' ) THEN
111: start_writing := ( g_Buffer_Length = -1 );
112: IF ( start_writing ) THEN
113: DBMS_LOB.Write ( lob_loc => x_tlob
114: , amount => Length (g_Buffer)
115: , offset => l_offset
116: , buffer => g_Buffer
117: );

Line 119: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

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