[Home] [Help]
PACKAGE: APPS.CN_PLANCOPY_UTIL_PVT
Source
1 PACKAGE CN_PLANCOPY_UTIL_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnpcutls.pls 120.3.12020000.2 2012/08/27 08:59:20 nbombili ship $*/
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 --Added by Naren to fix BT issue on 10th March,2012
52
53 PROCEDURE Update_Existing_Expression
54 (p_api_version IN NUMBER ,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
59 p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
60 p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
61 p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
62 p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
63 p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
64 p_sql_select IN VARCHAR2 := NULL,
65 p_sql_from IN VARCHAR2 := NULL,
66 p_piped_expression_disp IN VARCHAR2 := NULL,
67 p_piped_sql_select IN VARCHAR2 := NULL,
68 p_piped_sql_from IN VARCHAR2 := NULL,
69 p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
70 p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
71 p_status IN CN_CALC_SQL_EXPS.STATUS%TYPE,
72 x_return_status OUT NOCOPY VARCHAR2 ,
73 x_msg_count OUT NOCOPY NUMBER ,
74 x_msg_data OUT NOCOPY VARCHAR2 );
75
76 --Addition ends by Naren
77
78
79 FUNCTION check_name_length (p_name VARCHAR2, p_org_id NUMBER,p_type varchar2,p_prefix varchar2)
80 RETURN VARCHAR2;
81
82 END CN_PLANCOPY_UTIL_PVT;