PACKAGE: APPS.OKL_VP_K_ARTICLE_PUB

Source

1 PACKAGE OKL_VP_K_ARTICLE_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKLPCARS.pls 120.1 2005/08/04 01:30:27 manumanu noship $*/
3 -- simple entity object subtype definitions
4 SUBTYPE catv_rec_type is OKL_VP_K_ARTICLE_PVT.catv_rec_type;
5 SUBTYPE catv_tbl_type is OKL_VP_K_ARTICLE_PVT.catv_tbl_type;
6 
7 -- global variables for user hooks
8 g_catv_rec 			catv_rec_type;
9 
10   -- public procedure declarations
11 procedure add_language;
12 procedure create_k_article(p_api_version	IN	NUMBER,
13                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
14                            x_return_status	OUT NOCOPY	VARCHAR2,
15                            x_msg_count	OUT NOCOPY	NUMBER,
16                            x_msg_data	OUT NOCOPY	VARCHAR2,
17                            p_catv_rec	IN	catv_rec_type,
18                            x_catv_rec	OUT NOCOPY	catv_rec_type);
19 
20 procedure update_k_article(p_api_version	IN	NUMBER,
21                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
22                            x_return_status	OUT NOCOPY	VARCHAR2,
23                            x_msg_count	OUT NOCOPY	NUMBER,
24                            x_msg_data	OUT NOCOPY	VARCHAR2,
25                            p_catv_rec	IN	catv_rec_type,
26                            x_catv_rec	OUT NOCOPY	catv_rec_type);
27 
28 procedure delete_k_article(p_api_version	IN	NUMBER,
29                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
30                            x_return_status	OUT NOCOPY	VARCHAR2,
31                            x_msg_count	OUT NOCOPY	NUMBER,
32                            x_msg_data	OUT NOCOPY	VARCHAR2,
33                            p_catv_rec	IN	catv_rec_type);
34 
35 
36 procedure create_k_article(p_api_version	IN	NUMBER,
37                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
38                            x_return_status	OUT NOCOPY	VARCHAR2,
39                            x_msg_count	OUT NOCOPY	NUMBER,
40                            x_msg_data	OUT NOCOPY	VARCHAR2,
41                            p_catv_tbl	IN	catv_tbl_type,
42                            x_catv_tbl	OUT NOCOPY	catv_tbl_type);
43 
44 procedure update_k_article(p_api_version	IN	NUMBER,
45                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
46                            x_return_status	OUT NOCOPY	VARCHAR2,
47                            x_msg_count	OUT NOCOPY	NUMBER,
48                            x_msg_data	OUT NOCOPY	VARCHAR2,
49                            p_catv_tbl	IN	catv_tbl_type,
50                            x_catv_tbl	OUT NOCOPY	catv_tbl_type);
51 
52 procedure delete_k_article(p_api_version	IN	NUMBER,
53                            p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
54                            x_return_status	OUT NOCOPY	VARCHAR2,
55                            x_msg_count	OUT NOCOPY	NUMBER,
56                            x_msg_data	OUT NOCOPY	VARCHAR2,
57                            p_catv_tbl	IN	catv_tbl_type);
58 
59 
60 function std_art_name(p_sav_sae_id IN NUMBER) return varchar2;
61 
62 FUNCTION Copy_Articles_Text(p_id NUMBER,lang VARCHAR2,p_text VARCHAR2 ) RETURN VARCHAR2;
63 
64 END; -- Package Specification OKL_VP_K_ARTICLE_PUB