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 180: FUNCTION clob_to_xmltype (clob_in IN CLOB)

176:
177: END blob_to_clob;
178:
179:
180: FUNCTION clob_to_xmltype (clob_in IN CLOB)
181: RETURN XMLTYPE
182: AS
183: v_xmltype XMLTYPE;
184: BEGIN

Line 181: RETURN XMLTYPE

177: END blob_to_clob;
178:
179:
180: FUNCTION clob_to_xmltype (clob_in IN CLOB)
181: RETURN XMLTYPE
182: AS
183: v_xmltype XMLTYPE;
184: BEGIN
185: v_xmltype := XMLTYPE(clob_in);

Line 183: v_xmltype XMLTYPE;

179:
180: FUNCTION clob_to_xmltype (clob_in IN CLOB)
181: RETURN XMLTYPE
182: AS
183: v_xmltype XMLTYPE;
184: BEGIN
185: v_xmltype := XMLTYPE(clob_in);
186: RETURN v_xmltype;
187: END clob_to_xmltype;

Line 185: v_xmltype := XMLTYPE(clob_in);

181: RETURN XMLTYPE
182: AS
183: v_xmltype XMLTYPE;
184: BEGIN
185: v_xmltype := XMLTYPE(clob_in);
186: RETURN v_xmltype;
187: END clob_to_xmltype;
188:
189: PROCEDURE convert_blob_to_clob

Line 186: RETURN v_xmltype;

182: AS
183: v_xmltype XMLTYPE;
184: BEGIN
185: v_xmltype := XMLTYPE(clob_in);
186: RETURN v_xmltype;
187: END clob_to_xmltype;
188:
189: PROCEDURE convert_blob_to_clob
190: ( p_api_version IN NUMBER ,

Line 187: END clob_to_xmltype;

183: v_xmltype XMLTYPE;
184: BEGIN
185: v_xmltype := XMLTYPE(clob_in);
186: RETURN v_xmltype;
187: END clob_to_xmltype;
188:
189: PROCEDURE convert_blob_to_clob
190: ( p_api_version IN NUMBER ,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

Line 292: PROCEDURE convert_clob_to_xmltype

288: END convert_blob_to_clob;
289:
290:
291:
292: PROCEDURE convert_clob_to_xmltype
293: ( p_api_version IN NUMBER ,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
296: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2
301: )
302: IS
303: l_api_name CONSTANT VARCHAR2(30) := 'convert_clob_to_xmltype';
304: l_api_version CONSTANT NUMBER := 1.0;
305:
306: l_xmltype xmltype;
307: l_clob clob;

Line 306: l_xmltype xmltype;

302: IS
303: l_api_name CONSTANT VARCHAR2(30) := 'convert_clob_to_xmltype';
304: l_api_version CONSTANT NUMBER := 1.0;
305:
306: l_xmltype xmltype;
307: l_clob clob;
308: BEGIN
309:
310: -- Standard Start of API savepoint

Line 311: SAVEPOINT convert_clob_to_xmltype;

307: l_clob clob;
308: BEGIN
309:
310: -- Standard Start of API savepoint
311: SAVEPOINT convert_clob_to_xmltype;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call
315: (l_api_version ,

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

327: -- Initialize API return status to success
328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: -- ******* API Begins ************
331: -- TODO : Error handling, waiting for xmltype to be added
332:
333: select file_content_clob into l_clob from cn_copy_requests_all
334: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
335:

Line 336: l_xmltype := XMLTYPE(l_clob);

332:
333: select file_content_clob into l_clob from cn_copy_requests_all
334: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
335:
336: l_xmltype := XMLTYPE(l_clob);
337:
338: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
339:
340: -- ******* End of API body. ********

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

334: where EXP_IMP_REQUEST_ID = p_exp_imp_id;
335:
336: l_xmltype := XMLTYPE(l_clob);
337:
338: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
339:
340: -- ******* End of API body. ********
341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN

Line 354: ROLLBACK TO convert_clob_to_xmltype;

350: p_encoded => FND_API.G_FALSE );
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: ROLLBACK TO convert_clob_to_xmltype;
355: x_return_status := FND_API.G_RET_STS_ERROR ;
356: FND_MSG_PUB.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data ,

Line 361: ROLLBACK TO convert_clob_to_xmltype;

357: (p_count => x_msg_count ,
358: p_data => x_msg_data ,
359: p_encoded => FND_API.G_FALSE );
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO convert_clob_to_xmltype;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: FND_MSG_PUB.count_and_get
364: (p_count => x_msg_count ,
365: p_data => x_msg_data ,

Line 368: ROLLBACK TO convert_clob_to_xmltype;

364: (p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE );
367: WHEN OTHERS THEN
368: ROLLBACK TO convert_clob_to_xmltype;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: IF FND_MSG_PUB.check_msg_level
371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: THEN

Line 381: END convert_clob_to_xmltype;

377: FND_MSG_PUB.count_and_get
378: (p_count => x_msg_count ,
379: p_data => x_msg_data ,
380: p_encoded => FND_API.G_FALSE );
381: END convert_clob_to_xmltype;
382:
383:
384: PROCEDURE convert_blob_to_xmltype
385: ( p_api_version IN NUMBER ,

Line 384: PROCEDURE convert_blob_to_xmltype

380: p_encoded => FND_API.G_FALSE );
381: END convert_clob_to_xmltype;
382:
383:
384: PROCEDURE convert_blob_to_xmltype
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2
393: )
394: IS
395: l_api_name CONSTANT VARCHAR2(30) := 'convert_blob_to_xmltype';
396: l_api_version CONSTANT NUMBER := 1.0;
397: l_return_status VARCHAR2(2000);
398: l_msg_count NUMBER;
399: l_msg_data VARCHAR2(2000);

Line 404: SAVEPOINT convert_blob_to_xmltype;

400:
401: BEGIN
402:
403: -- Standard Start of API savepoint
404: SAVEPOINT convert_blob_to_xmltype;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call
408: (l_api_version ,

Line 444: convert_clob_to_xmltype(p_api_version,

440: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443:
444: convert_clob_to_xmltype(p_api_version,
445: p_init_msg_list,
446: p_commit,
447: p_validation_level,
448: p_exp_imp_id,

Line 475: ROLLBACK TO convert_blob_to_xmltype;

471: p_encoded => FND_API.G_FALSE );
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO convert_blob_to_xmltype;
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: FND_MSG_PUB.count_and_get
478: (p_count => x_msg_count ,
479: p_data => x_msg_data ,

Line 482: ROLLBACK TO convert_blob_to_xmltype;

478: (p_count => x_msg_count ,
479: p_data => x_msg_data ,
480: p_encoded => FND_API.G_FALSE );
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO convert_blob_to_xmltype;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: FND_MSG_PUB.count_and_get
485: (p_count => x_msg_count ,
486: p_data => x_msg_data ,

Line 489: ROLLBACK TO convert_blob_to_xmltype;

485: (p_count => x_msg_count ,
486: p_data => x_msg_data ,
487: p_encoded => FND_API.G_FALSE );
488: WHEN OTHERS THEN
489: ROLLBACK TO convert_blob_to_xmltype;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: IF FND_MSG_PUB.check_msg_level
492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
493: THEN

Line 502: END convert_blob_to_xmltype;

498: FND_MSG_PUB.count_and_get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: END convert_blob_to_xmltype;
503:
504:
505: FUNCTION check_name_length (p_name VARCHAR2, p_org_id NUMBER,p_type varchar2,p_prefix varchar2)
506: RETURN VARCHAR2 IS