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.ICX_DATATEMPLATE_PKG dependencies on DBMS_LOB

Line 206: dbms_lob.createtemporary(clob_addr, true);

202:
203: if l_addr_sql is not null then
204: l_sql := l_addr_sql || l_where_sql;
205:
206: dbms_lob.createtemporary(clob_addr, true);
207: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
208: open c_addr for l_sql using reqHeaderId, l_attr_grp_id;
209: loop
210: fetch c_addr into l_address;

Line 207: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);

203: if l_addr_sql is not null then
204: l_sql := l_addr_sql || l_where_sql;
205:
206: dbms_lob.createtemporary(clob_addr, true);
207: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
208: open c_addr for l_sql using reqHeaderId, l_attr_grp_id;
209: loop
210: fetch c_addr into l_address;
211: exit when c_addr%notfound;

Line 213: dbms_lob.writeappend(clob_addr, length(l_address), l_address);

209: loop
210: fetch c_addr into l_address;
211: exit when c_addr%notfound;
212: if l_address is not null then
213: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
214: end if;
215: end loop;
216: dbms_lob.close(clob_addr);
217: end if;

Line 216: dbms_lob.close(clob_addr);

212: if l_address is not null then
213: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
214: end if;
215: end loop;
216: dbms_lob.close(clob_addr);
217: end if;
218: return(clob_addr);
219: END GET_ADDRESSXML;
220:

Line 262: dbms_lob.createtemporary(clob_cnt, true);

258:
259: if l_cnt_sql is not null then
260: l_sql := l_cnt_sql || l_where_sql;
261:
262: dbms_lob.createtemporary(clob_cnt, true);
263: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
264: open c_cnt for l_sql using reqHeaderId, l_attr_grp_id;
265: loop
266: fetch c_cnt into l_cnt;

Line 263: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);

259: if l_cnt_sql is not null then
260: l_sql := l_cnt_sql || l_where_sql;
261:
262: dbms_lob.createtemporary(clob_cnt, true);
263: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
264: open c_cnt for l_sql using reqHeaderId, l_attr_grp_id;
265: loop
266: fetch c_cnt into l_cnt;
267: exit when c_cnt%notfound;

Line 269: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);

265: loop
266: fetch c_cnt into l_cnt;
267: exit when c_cnt%notfound;
268: if l_cnt is not null then
269: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
270: end if;
271: end loop;
272: dbms_lob.close(clob_cnt);
273: end if;

Line 272: dbms_lob.close(clob_cnt);

268: if l_cnt is not null then
269: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
270: end if;
271: end loop;
272: dbms_lob.close(clob_cnt);
273: end if;
274: return(clob_cnt);
275: END GET_CONTACTSXML;
276:

Line 331: dbms_lob.createtemporary(clob_auth_1, true);

327: where jbt.job_id(+) =pa.job_id and jbt.language=userenv(''LANG'')
328: and sysdate between nvl(pa.effective_start_date,sysdate) and nvl(pa.effective_end_date,sysdate)
329: and pa.person_id =:1';
330:
331: dbms_lob.createtemporary(clob_auth_1, true);
332: dbms_lob.open(clob_auth_1, dbms_lob.lob_readwrite);
333: open c_auth_1 for l_auth_sql_1 using l_auth_id;
334: loop
335: fetch c_auth_1 into l_auth;

Line 332: dbms_lob.open(clob_auth_1, dbms_lob.lob_readwrite);

328: and sysdate between nvl(pa.effective_start_date,sysdate) and nvl(pa.effective_end_date,sysdate)
329: and pa.person_id =:1';
330:
331: dbms_lob.createtemporary(clob_auth_1, true);
332: dbms_lob.open(clob_auth_1, dbms_lob.lob_readwrite);
333: open c_auth_1 for l_auth_sql_1 using l_auth_id;
334: loop
335: fetch c_auth_1 into l_auth;
336: exit when c_auth_1%notfound;

Line 338: dbms_lob.writeappend(clob_auth_1, length(l_auth), l_auth);

334: loop
335: fetch c_auth_1 into l_auth;
336: exit when c_auth_1%notfound;
337: if l_auth is not null then
338: dbms_lob.writeappend(clob_auth_1, length(l_auth), l_auth);
339: end if;
340: end loop;
341: dbms_lob.close(clob_auth_1);
342: end if;

Line 341: dbms_lob.close(clob_auth_1);

337: if l_auth is not null then
338: dbms_lob.writeappend(clob_auth_1, length(l_auth), l_auth);
339: end if;
340: end loop;
341: dbms_lob.close(clob_auth_1);
342: end if;
343:
344:
345: return(clob_auth_1);