APPS.OKC_AQ_PVT dependencies on DBMS_LOB

Line 135: DBMS_LOB.createtemporary ( l_char_clob.body

131: END IF;
132:
133:
134: l_char_clob := system.okc_aq_msg_typ(empty_clob());
135: DBMS_LOB.createtemporary ( l_char_clob.body
136: , TRUE
137: , DBMS_LOB.session );
138: DBMS_LOB.write ( l_char_clob.body
139: , length(p_msg)

Line 137: , DBMS_LOB.session );

133:
134: l_char_clob := system.okc_aq_msg_typ(empty_clob());
135: DBMS_LOB.createtemporary ( l_char_clob.body
136: , TRUE
137: , DBMS_LOB.session );
138: DBMS_LOB.write ( l_char_clob.body
139: , length(p_msg)
140: , 1
141: , p_msg );

Line 138: DBMS_LOB.write ( l_char_clob.body

134: l_char_clob := system.okc_aq_msg_typ(empty_clob());
135: DBMS_LOB.createtemporary ( l_char_clob.body
136: , TRUE
137: , DBMS_LOB.session );
138: DBMS_LOB.write ( l_char_clob.body
139: , length(p_msg)
140: , 1
141: , p_msg );
142: x_char_clob := l_char_clob;

Line 175: dbms_lob.createtemporary(l_clob_msg.body,TRUE,dbms_lob.session);

171: END IF;
172:
173:
174: l_clob_msg := system.okc_aq_msg_typ (empty_clob());
175: dbms_lob.createtemporary(l_clob_msg.body,TRUE,dbms_lob.session);
176: l_clob_msg := p_clob_msg;
177: l_amount := DBMS_LOB.getlength ( l_clob_msg.body );
178: -- read clob message into char variable
179: DBMS_LOB.read ( l_clob_msg.body

Line 177: l_amount := DBMS_LOB.getlength ( l_clob_msg.body );

173:
174: l_clob_msg := system.okc_aq_msg_typ (empty_clob());
175: dbms_lob.createtemporary(l_clob_msg.body,TRUE,dbms_lob.session);
176: l_clob_msg := p_clob_msg;
177: l_amount := DBMS_LOB.getlength ( l_clob_msg.body );
178: -- read clob message into char variable
179: DBMS_LOB.read ( l_clob_msg.body
180: , l_amount
181: , 1

Line 179: DBMS_LOB.read ( l_clob_msg.body

175: dbms_lob.createtemporary(l_clob_msg.body,TRUE,dbms_lob.session);
176: l_clob_msg := p_clob_msg;
177: l_amount := DBMS_LOB.getlength ( l_clob_msg.body );
178: -- read clob message into char variable
179: DBMS_LOB.read ( l_clob_msg.body
180: , l_amount
181: , 1
182: , x_char_msg);
183: IF (l_debug = 'Y') THEN