APPS.IEM_SEARCHMESSAGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

SAVEPOINT select_mail_count_pvt;

Line: 60

	l_str:='select message_id,ih_media_item_id,from_str,to_str,subject, to_char(to_date(substr(sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH''),''MM/DD/RRRR HH24:MI:SS'')';

Line: 86

	l_str:='select a.message_id,b.ih_media_item_id,a.from_str,a.to_str,a.subject,to_char(to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH''),''MM/DD/RRRR HH24:MI:SS'')';

Line: 179

	ROLLBACK TO select_mail_count_pvt;

Line: 186

	ROLLBACK TO select_mail_count_pvt;

Line: 193

	ROLLBACK TO select_mail_count_pvt;