[Home] [Help]
PACKAGE: APPS.CN_PLANCOPY_UTIL_PVT
Source
1 PACKAGE CN_PLANCOPY_UTIL_PVT AS
2 /*$Header: cnpcutls.pls 120.3 2007/08/07 17:44:55 sbadami noship $*/
3
4 PROCEDURE get_unique_name_for_component (
5 p_id IN NUMBER,
6 p_org_id IN NUMBER,
7 p_type IN VARCHAR2,
8 p_suffix IN VARCHAR2,
9 p_prefix IN VARCHAR2,
10 x_name OUT NOCOPY VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2
14 );
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,
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,
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,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50
51 FUNCTION check_name_length (p_name VARCHAR2, p_org_id NUMBER,p_type varchar2,p_prefix varchar2)
52 RETURN VARCHAR2;
53
54 END CN_PLANCOPY_UTIL_PVT;