APPS.MWA_NOTIFICATION_API dependencies on DBMS_LOB

Line 122: dbms_lob.read (eventData, temp_number, 1 ,temp_string);

118:
119: eventData := WF_EVENT_T.getEventData(p_event);
120:
121: temp_number := 8;
122: dbms_lob.read (eventData, temp_number, 1 ,temp_string);
123: username_size := decodedLength(temp_string);
124:
125: temp_number := 8;
126: dbms_lob.read (eventData, temp_number, 9 ,temp_string);

Line 126: dbms_lob.read (eventData, temp_number, 9 ,temp_string);

122: dbms_lob.read (eventData, temp_number, 1 ,temp_string);
123: username_size := decodedLength(temp_string);
124:
125: temp_number := 8;
126: dbms_lob.read (eventData, temp_number, 9 ,temp_string);
127: subject_size := decodedLength(temp_string);
128:
129: temp_number := 8;
130: dbms_lob.read (eventData, temp_number, 17 ,temp_string);

Line 130: dbms_lob.read (eventData, temp_number, 17 ,temp_string);

126: dbms_lob.read (eventData, temp_number, 9 ,temp_string);
127: subject_size := decodedLength(temp_string);
128:
129: temp_number := 8;
130: dbms_lob.read (eventData, temp_number, 17 ,temp_string);
131: content_size := decodedLength(temp_string);
132:
133: dbms_lob.read (eventData, username_size, 25, username);
134: dbms_lob.read (eventData, subject_size, 25 + username_size, subject);

Line 133: dbms_lob.read (eventData, username_size, 25, username);

129: temp_number := 8;
130: dbms_lob.read (eventData, temp_number, 17 ,temp_string);
131: content_size := decodedLength(temp_string);
132:
133: dbms_lob.read (eventData, username_size, 25, username);
134: dbms_lob.read (eventData, subject_size, 25 + username_size, subject);
135: dbms_lob.read (eventData, content_size, 25 + username_size + subject_size,
136: content);
137:

Line 134: dbms_lob.read (eventData, subject_size, 25 + username_size, subject);

130: dbms_lob.read (eventData, temp_number, 17 ,temp_string);
131: content_size := decodedLength(temp_string);
132:
133: dbms_lob.read (eventData, username_size, 25, username);
134: dbms_lob.read (eventData, subject_size, 25 + username_size, subject);
135: dbms_lob.read (eventData, content_size, 25 + username_size + subject_size,
136: content);
137:
138: --finally fire the notification

Line 135: dbms_lob.read (eventData, content_size, 25 + username_size + subject_size,

131: content_size := decodedLength(temp_string);
132:
133: dbms_lob.read (eventData, username_size, 25, username);
134: dbms_lob.read (eventData, subject_size, 25 + username_size, subject);
135: dbms_lob.read (eventData, content_size, 25 + username_size + subject_size,
136: content);
137:
138: --finally fire the notification
139: fireNotification(subject, username, 'EMAIL', content);

Line 175: dbms_lob.createTemporary(eventData, FALSE, DBMS_LOB.CALL);

171: mesg varchar2(15);
172:
173: begin
174:
175: dbms_lob.createTemporary(eventData, FALSE, DBMS_LOB.CALL);
176:
177: username_size := length (username);
178: subject_size := length (subject);
179: content_size := length (content);

Line 185: dbms_lob.write (eventData, 8 , 1, username_encoded);

181: username_encoded := calculateLength (username);
182: subject_encoded := calculateLength (subject);
183: content_encoded := calculateLength (content);
184:
185: dbms_lob.write (eventData, 8 , 1, username_encoded);
186: dbms_lob.write (eventData, 8 , 9, subject_encoded);
187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);

Line 186: dbms_lob.write (eventData, 8 , 9, subject_encoded);

182: subject_encoded := calculateLength (subject);
183: content_encoded := calculateLength (content);
184:
185: dbms_lob.write (eventData, 8 , 1, username_encoded);
186: dbms_lob.write (eventData, 8 , 9, subject_encoded);
187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);
190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);

Line 187: dbms_lob.write (eventData, 8 , 17, content_encoded);

183: content_encoded := calculateLength (content);
184:
185: dbms_lob.write (eventData, 8 , 1, username_encoded);
186: dbms_lob.write (eventData, 8 , 9, subject_encoded);
187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);
190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);
191: dbms_lob.write (eventData, content_size , 25 + username_size + subject_size,

Line 189: dbms_lob.write (eventData, username_size , 25, username);

185: dbms_lob.write (eventData, 8 , 1, username_encoded);
186: dbms_lob.write (eventData, 8 , 9, subject_encoded);
187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);
190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);
191: dbms_lob.write (eventData, content_size , 25 + username_size + subject_size,
192: content);
193:

Line 190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);

186: dbms_lob.write (eventData, 8 , 9, subject_encoded);
187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);
190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);
191: dbms_lob.write (eventData, content_size , 25 + username_size + subject_size,
192: content);
193:
194:

Line 191: dbms_lob.write (eventData, content_size , 25 + username_size + subject_size,

187: dbms_lob.write (eventData, 8 , 17, content_encoded);
188:
189: dbms_lob.write (eventData, username_size , 25, username);
190: dbms_lob.write (eventData, subject_size , 25 + username_size, subject);
191: dbms_lob.write (eventData, content_size , 25 + username_size + subject_size,
192: content);
193:
194:
195: WF_EVENT.Raise('oracle.apps.mwa.notification', 'notification', eventData );