eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_SEARCHMESSAGE_PVT dependencies on DBMS_SQL

Line 110: l_cursorID := DBMS_SQL.OPEN_CURSOR;

106: IF p_recepients is not null and nvl(p_cc_flag,' ')='Y' then
107: l_str:=l_str||' AND (upper(a.to_str) like :tostr OR upper(a.cc_str) like :tostr)';
108: END IF;
109: END IF; -- End if for p_email_queue<>'I'
110: l_cursorID := DBMS_SQL.OPEN_CURSOR;
111: DBMS_SQL.PARSE(l_cursorID, l_str, DBMS_SQL.native);
112: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':id', p_email_account_id);
113: IF p_email_queue <>'I' THEN
114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);

Line 111: DBMS_SQL.PARSE(l_cursorID, l_str, DBMS_SQL.native);

107: l_str:=l_str||' AND (upper(a.to_str) like :tostr OR upper(a.cc_str) like :tostr)';
108: END IF;
109: END IF; -- End if for p_email_queue<>'I'
110: l_cursorID := DBMS_SQL.OPEN_CURSOR;
111: DBMS_SQL.PARSE(l_cursorID, l_str, DBMS_SQL.native);
112: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':id', p_email_account_id);
113: IF p_email_queue <>'I' THEN
114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);
115: END IF;

Line 112: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':id', p_email_account_id);

108: END IF;
109: END IF; -- End if for p_email_queue<>'I'
110: l_cursorID := DBMS_SQL.OPEN_CURSOR;
111: DBMS_SQL.PARSE(l_cursorID, l_str, DBMS_SQL.native);
112: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':id', p_email_account_id);
113: IF p_email_queue <>'I' THEN
114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);
115: END IF;
116: IF p_resource_id is not null then

Line 114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);

110: l_cursorID := DBMS_SQL.OPEN_CURSOR;
111: DBMS_SQL.PARSE(l_cursorID, l_str, DBMS_SQL.native);
112: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':id', p_email_account_id);
113: IF p_email_queue <>'I' THEN
114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);
115: END IF;
116: IF p_resource_id is not null then
117: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':resource_id', p_resource_id);
118: END IF;

Line 117: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':resource_id', p_resource_id);

113: IF p_email_queue <>'I' THEN
114: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':q_status', p_email_queue);
115: END IF;
116: IF p_resource_id is not null then
117: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':resource_id', p_resource_id);
118: END IF;
119: If p_sent_date_from is not null then
120: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':f_dt', p_sent_date_from);
121: end if;

Line 120: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':f_dt', p_sent_date_from);

116: IF p_resource_id is not null then
117: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':resource_id', p_resource_id);
118: END IF;
119: If p_sent_date_from is not null then
120: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':f_dt', p_sent_date_from);
121: end if;
122:
123: if p_sent_date_to is not null then
124: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':t_dt', p_sent_date_to);

Line 124: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':t_dt', p_sent_date_to);

120: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':f_dt', p_sent_date_from);
121: end if;
122:
123: if p_sent_date_to is not null then
124: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':t_dt', p_sent_date_to);
125: end if;
126: IF p_subject is not null then
127: l_subject1:=upper(p_subject);
128: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':subject', l_subject1);

Line 128: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':subject', l_subject1);

124: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':t_dt', p_sent_date_to);
125: end if;
126: IF p_subject is not null then
127: l_subject1:=upper(p_subject);
128: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':subject', l_subject1);
129: END IF;
130: IF p_from_str is not null then
131: l_from_str1:='%'||upper(p_from_str)||'%';
132: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':from1', l_from_str1);

Line 132: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':from1', l_from_str1);

128: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':subject', l_subject1);
129: END IF;
130: IF p_from_str is not null then
131: l_from_str1:='%'||upper(p_from_str)||'%';
132: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':from1', l_from_str1);
133: END IF;
134: IF p_recepients is not null then
135: l_to_str1:='%'||upper(p_recepients)||'%';
136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);

Line 136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);

132: DBMS_SQL.BIND_VARIABLE(l_cursorid, ':from1', l_from_str1);
133: END IF;
134: IF p_recepients is not null then
135: l_to_str1:='%'||upper(p_recepients)||'%';
136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);
137: END IF;
138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);

Line 138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);

134: IF p_recepients is not null then
135: l_to_str1:='%'||upper(p_recepients)||'%';
136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);
137: END IF;
138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);

Line 139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);

135: l_to_str1:='%'||upper(p_recepients)||'%';
136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);
137: END IF;
138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);

Line 140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);

136: DBMS_SQL.BIND_VARIABLE(l_cursorid,':tostr',l_to_str1);
137: END IF;
138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:

Line 141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);

137: END IF;
138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:
145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);

138: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:
145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
146: LOOP

Line 143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);

139: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_ih_media_item_id);
140: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_from_str,2000);
141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:
145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
146: LOOP
147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN

Line 145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

141: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_to_str,2000);
142: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_subject,2000);
143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:
145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
146: LOOP
147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN
148: EXIT;
149: END IF;

Line 147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN

143: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_sent_date,60);
144:
145: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
146: LOOP
147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN
148: EXIT;
149: END IF;
150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);

Line 150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);

146: LOOP
147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN
148: EXIT;
149: END IF;
150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);

Line 151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);

147: IF (DBMS_SQL.FETCH_ROWS(l_cursorid) = 0) THEN
148: EXIT;
149: END IF;
150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);
155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);

Line 152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);

148: EXIT;
149: END IF;
150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);
155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);
156:

Line 153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);

149: END IF;
150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);
155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);
156:
157: x_message_tbl(l_counter).message_id:=l_message_id;

Line 154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);

150: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);
155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);
156:
157: x_message_tbl(l_counter).message_id:=l_message_id;
158: x_message_tbl(l_counter).ih_media_item_id:=l_ih_media_item_id;

Line 155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);

151: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_ih_media_item_id);
152: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_from_str);
153: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_to_str);
154: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_subject);
155: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_sent_date);
156:
157: x_message_tbl(l_counter).message_id:=l_message_id;
158: x_message_tbl(l_counter).ih_media_item_id:=l_ih_media_item_id;
159: x_message_tbl(l_counter).from_str:=l_from_str;

Line 166: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

162: x_message_tbl(l_counter).sent_date:=l_sent_date;
163: l_counter:=l_counter+1;
164: END LOOP;
165:
166: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
167:
168: IF p_commit='T' THEN
169: COMMIT WORK;
170: END IF;