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

Line 103: IF DBMS_LOB.GETLENGTH(p_element_desc) > 0 AND

99: p_element_name,
100: p_element_type_id,
101: p_access_level) LOOP
102:
103: IF DBMS_LOB.GETLENGTH(p_element_desc) > 0 AND
104: rec.description IS NULL THEN
105:
106: NULL;
107:

Line 109: (p_element_desc IS NULL AND (DBMS_LOB.GETLENGTH(rec.description) = 0) ) OR

105:
106: NULL;
107:
108: ELSIF (p_element_desc IS NULL AND rec.description IS NULL) OR
109: (p_element_desc IS NULL AND (DBMS_LOB.GETLENGTH(rec.description) = 0) ) OR
110: ((DBMS_LOB.GETLENGTH(p_element_desc) = 0) AND rec.description IS NULL ) OR
111: (DBMS_LOB.COMPARE(p_element_desc, rec.description) = 0 ) THEN
112:
113: RETURN rec.element_id;

Line 110: ((DBMS_LOB.GETLENGTH(p_element_desc) = 0) AND rec.description IS NULL ) OR

106: NULL;
107:
108: ELSIF (p_element_desc IS NULL AND rec.description IS NULL) OR
109: (p_element_desc IS NULL AND (DBMS_LOB.GETLENGTH(rec.description) = 0) ) OR
110: ((DBMS_LOB.GETLENGTH(p_element_desc) = 0) AND rec.description IS NULL ) OR
111: (DBMS_LOB.COMPARE(p_element_desc, rec.description) = 0 ) THEN
112:
113: RETURN rec.element_id;
114:

Line 111: (DBMS_LOB.COMPARE(p_element_desc, rec.description) = 0 ) THEN

107:
108: ELSIF (p_element_desc IS NULL AND rec.description IS NULL) OR
109: (p_element_desc IS NULL AND (DBMS_LOB.GETLENGTH(rec.description) = 0) ) OR
110: ((DBMS_LOB.GETLENGTH(p_element_desc) = 0) AND rec.description IS NULL ) OR
111: (DBMS_LOB.COMPARE(p_element_desc, rec.description) = 0 ) THEN
112:
113: RETURN rec.element_id;
114:
115: END IF;

Line 232: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);

228: RETURN -1;
229: END IF;
230:
231: IF(p_desc IS NOT NULL) THEN
232: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
233: l_offset := 1;
234: l_amt := length(p_desc);
235: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);
236: END IF;

Line 235: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);

231: IF(p_desc IS NOT NULL) THEN
232: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
233: l_offset := 1;
234: l_amt := length(p_desc);
235: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);
236: END IF;
237:
238: l_element_id := Create_Element_CLOB(
239: p_element_type_id => p_element_type_id,

Line 265: DBMS_LOB.freetemporary(l_clob);

261: p_end_active_date => p_end_active_date,
262: p_content_type => p_content_type );
263:
264: IF(p_desc IS NOT NULL) THEN
265: DBMS_LOB.freetemporary(l_clob);
266: END IF;
267:
268: RETURN l_element_id;
269:

Line 275: DBMS_LOB.freetemporary(l_clob);

271: WHEN FND_API.g_exc_error THEN
272: RETURN ERROR_STATUS;
273: WHEN others THEN
274: IF(l_clob IS NOT NULL) THEN
275: DBMS_LOB.freetemporary(l_clob);
276: END IF;
277: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
278: RETURN ERROR_STATUS;
279:

Line 408: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);

404: END IF;
405:
406: -- write desc to clob
407: IF(p_desc IS NOT NULL) THEN
408: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
409: l_offset := 1;
410: l_amt := length(p_desc);
411: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);
412: END IF;

Line 411: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);

407: IF(p_desc IS NOT NULL) THEN
408: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
409: l_offset := 1;
410: l_amt := length(p_desc);
411: DBMS_LOB.write(l_clob, l_amt, l_offset, p_desc);
412: END IF;
413:
414: l_ret := Update_Element_CLOB(
415: P_ELEMENT_ID => p_element_id,

Line 443: DBMS_LOB.freetemporary(l_clob);

439: P_END_ACTIVE_DATE => p_end_active_date,
440: P_CONTENT_TYPE => p_content_type );
441:
442: IF(p_desc IS NOT NULL) THEN
443: DBMS_LOB.freetemporary(l_clob);
444: END IF;
445:
446: RETURN l_ret;
447: EXCEPTION

Line 450: DBMS_LOB.freetemporary(l_clob);

446: RETURN l_ret;
447: EXCEPTION
448: WHEN others THEN
449: IF(l_clob IS NOT NULL) THEN
450: DBMS_LOB.freetemporary(l_clob);
451: END IF;
452: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
453: RETURN ERROR_STATUS;
454: END Update_Element;

Line 766: DBMS_LOB.CREATETEMPORARY(c1,true);

762: IS
763: c1 CLOB;
764: BEGIN
765:
766: DBMS_LOB.CREATETEMPORARY(c1,true);
767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
768: DBMS_LOB.WRITE(c1,1,1,' ');
769: RETURN c1;
770:

Line 767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);

763: c1 CLOB;
764: BEGIN
765:
766: DBMS_LOB.CREATETEMPORARY(c1,true);
767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
768: DBMS_LOB.WRITE(c1,1,1,' ');
769: RETURN c1;
770:
771: END create_clob;

Line 768: DBMS_LOB.WRITE(c1,1,1,' ');

764: BEGIN
765:
766: DBMS_LOB.CREATETEMPORARY(c1,true);
767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
768: DBMS_LOB.WRITE(c1,1,1,' ');
769: RETURN c1;
770:
771: END create_clob;
772: