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
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,
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,
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,
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,