15:
16:
17: PROCEDURE convert_blob_to_clob
18: ( p_api_version IN NUMBER ,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
23: x_return_status OUT NOCOPY VARCHAR2,
16:
17: PROCEDURE convert_blob_to_clob
18: ( p_api_version IN NUMBER ,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
17: PROCEDURE convert_blob_to_clob
18: ( p_api_version IN NUMBER ,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2
26: );
27:
28: PROCEDURE convert_clob_to_xmltype
29: ( p_api_version IN NUMBER ,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
27:
28: PROCEDURE convert_clob_to_xmltype
29: ( p_api_version IN NUMBER ,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
28: PROCEDURE convert_clob_to_xmltype
29: ( p_api_version IN NUMBER ,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE convert_blob_to_xmltype
40: ( p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
45: x_return_status OUT NOCOPY VARCHAR2,
38:
39: PROCEDURE convert_blob_to_xmltype
40: ( p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
39: PROCEDURE convert_blob_to_xmltype
40: ( p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_exp_imp_id IN CN_COPY_REQUESTS_ALL.EXP_IMP_REQUEST_ID%TYPE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2