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.CN_PLANCOPY_UTIL_PVT dependencies on XMLTYPE

Line 141: FUNCTION clob_to_xmltype (clob_in IN CLOB)

137: RETURN v_clob;
138: END blob_to_clob;
139:
140:
141: FUNCTION clob_to_xmltype (clob_in IN CLOB)
142: RETURN XMLTYPE
143: AS
144: v_xmltype XMLTYPE;
145: BEGIN

Line 142: RETURN XMLTYPE

138: END blob_to_clob;
139:
140:
141: FUNCTION clob_to_xmltype (clob_in IN CLOB)
142: RETURN XMLTYPE
143: AS
144: v_xmltype XMLTYPE;
145: BEGIN
146: v_xmltype := XMLTYPE(clob_in);

Line 144: v_xmltype XMLTYPE;

140:
141: FUNCTION clob_to_xmltype (clob_in IN CLOB)
142: RETURN XMLTYPE
143: AS
144: v_xmltype XMLTYPE;
145: BEGIN
146: v_xmltype := XMLTYPE(clob_in);
147: RETURN v_xmltype;
148: END clob_to_xmltype;

Line 146: v_xmltype := XMLTYPE(clob_in);

142: RETURN XMLTYPE
143: AS
144: v_xmltype XMLTYPE;
145: BEGIN
146: v_xmltype := XMLTYPE(clob_in);
147: RETURN v_xmltype;
148: END clob_to_xmltype;
149:
150: PROCEDURE convert_blob_to_clob

Line 147: RETURN v_xmltype;

143: AS
144: v_xmltype XMLTYPE;
145: BEGIN
146: v_xmltype := XMLTYPE(clob_in);
147: RETURN v_xmltype;
148: END clob_to_xmltype;
149:
150: PROCEDURE convert_blob_to_clob
151: ( p_api_version IN NUMBER ,

Line 148: END clob_to_xmltype;

144: v_xmltype XMLTYPE;
145: BEGIN
146: v_xmltype := XMLTYPE(clob_in);
147: RETURN v_xmltype;
148: END clob_to_xmltype;
149:
150: PROCEDURE convert_blob_to_clob
151: ( p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

Line 244: PROCEDURE convert_clob_to_xmltype

240: END convert_blob_to_clob;
241:
242:
243:
244: PROCEDURE convert_clob_to_xmltype
245: ( p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 255: l_api_name CONSTANT VARCHAR2(30) := 'convert_clob_to_xmltype';

251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2
253: )
254: IS
255: l_api_name CONSTANT VARCHAR2(30) := 'convert_clob_to_xmltype';
256: l_api_version CONSTANT NUMBER := 1.0;
257:
258: l_xmltype xmltype;
259: l_clob clob;

Line 258: l_xmltype xmltype;

254: IS
255: l_api_name CONSTANT VARCHAR2(30) := 'convert_clob_to_xmltype';
256: l_api_version CONSTANT NUMBER := 1.0;
257:
258: l_xmltype xmltype;
259: l_clob clob;
260: BEGIN
261:
262: -- Standard Start of API savepoint

Line 263: SAVEPOINT convert_clob_to_xmltype;

259: l_clob clob;
260: BEGIN
261:
262: -- Standard Start of API savepoint
263: SAVEPOINT convert_clob_to_xmltype;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call
267: (l_api_version ,

Line 283: -- TODO : Error handling, waiting for xmltype to be added

279: -- Initialize API return status to success
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: -- ******* API Begins ************
283: -- TODO : Error handling, waiting for xmltype to be added
284:
285: select file_content_clob into l_clob from cn_copy_requests_all
286: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
287:

Line 288: l_xmltype := XMLTYPE(l_clob);

284:
285: select file_content_clob into l_clob from cn_copy_requests_all
286: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
287:
288: l_xmltype := XMLTYPE(l_clob);
289:
290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
291:
292: -- ******* End of API body. ********

Line 290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;

286: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
287:
288: l_xmltype := XMLTYPE(l_clob);
289:
290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
291:
292: -- ******* End of API body. ********
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN

Line 306: ROLLBACK TO convert_clob_to_xmltype;

302: p_encoded => FND_API.G_FALSE );
303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO convert_clob_to_xmltype;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.count_and_get
309: (p_count => x_msg_count ,
310: p_data => x_msg_data ,

Line 313: ROLLBACK TO convert_clob_to_xmltype;

309: (p_count => x_msg_count ,
310: p_data => x_msg_data ,
311: p_encoded => FND_API.G_FALSE );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO convert_clob_to_xmltype;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.count_and_get
316: (p_count => x_msg_count ,
317: p_data => x_msg_data ,

Line 320: ROLLBACK TO convert_clob_to_xmltype;

316: (p_count => x_msg_count ,
317: p_data => x_msg_data ,
318: p_encoded => FND_API.G_FALSE );
319: WHEN OTHERS THEN
320: ROLLBACK TO convert_clob_to_xmltype;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN

Line 333: END convert_clob_to_xmltype;

329: FND_MSG_PUB.count_and_get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data ,
332: p_encoded => FND_API.G_FALSE );
333: END convert_clob_to_xmltype;
334:
335:
336: PROCEDURE convert_blob_to_xmltype
337: ( p_api_version IN NUMBER ,

Line 336: PROCEDURE convert_blob_to_xmltype

332: p_encoded => FND_API.G_FALSE );
333: END convert_clob_to_xmltype;
334:
335:
336: PROCEDURE convert_blob_to_xmltype
337: ( p_api_version IN NUMBER ,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 347: l_api_name CONSTANT VARCHAR2(30) := 'convert_blob_to_xmltype';

343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2
345: )
346: IS
347: l_api_name CONSTANT VARCHAR2(30) := 'convert_blob_to_xmltype';
348: l_api_version CONSTANT NUMBER := 1.0;
349: l_return_status VARCHAR2(2000);
350: l_msg_count NUMBER;
351: l_msg_data VARCHAR2(2000);

Line 356: SAVEPOINT convert_blob_to_xmltype;

352:
353: BEGIN
354:
355: -- Standard Start of API savepoint
356: SAVEPOINT convert_blob_to_xmltype;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call
360: (l_api_version ,

Line 396: convert_clob_to_xmltype(p_api_version,

392: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
393: END IF;
394:
395:
396: convert_clob_to_xmltype(p_api_version,
397: p_init_msg_list,
398: p_commit,
399: p_validation_level,
400: p_exp_imp_id,

Line 427: ROLLBACK TO convert_blob_to_xmltype;

423: p_encoded => FND_API.G_FALSE );
424:
425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: ROLLBACK TO convert_blob_to_xmltype;
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: FND_MSG_PUB.count_and_get
430: (p_count => x_msg_count ,
431: p_data => x_msg_data ,

Line 434: ROLLBACK TO convert_blob_to_xmltype;

430: (p_count => x_msg_count ,
431: p_data => x_msg_data ,
432: p_encoded => FND_API.G_FALSE );
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: ROLLBACK TO convert_blob_to_xmltype;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: FND_MSG_PUB.count_and_get
437: (p_count => x_msg_count ,
438: p_data => x_msg_data ,

Line 441: ROLLBACK TO convert_blob_to_xmltype;

437: (p_count => x_msg_count ,
438: p_data => x_msg_data ,
439: p_encoded => FND_API.G_FALSE );
440: WHEN OTHERS THEN
441: ROLLBACK TO convert_blob_to_xmltype;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
443: IF FND_MSG_PUB.check_msg_level
444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
445: THEN

Line 454: END convert_blob_to_xmltype;

450: FND_MSG_PUB.count_and_get
451: (p_count => x_msg_count ,
452: p_data => x_msg_data ,
453: p_encoded => FND_API.G_FALSE );
454: END convert_blob_to_xmltype;
455:
456:
457: FUNCTION check_name_length (p_name VARCHAR2, p_org_id NUMBER,p_type varchar2,p_prefix varchar2)
458: RETURN VARCHAR2 IS