[Home] [Help]
PACKAGE: APPS.OKC_K_ARTICLE_PUB
Source
1 package OKC_K_ARTICLE_PUB as
2 /*$Header: OKCPCATS.pls 120.0 2005/05/25 23:05:05 appldev noship $*/
3 -- simple entity object subtype definitions
4 subtype catv_rec_type is OKC_K_ARTICLE_PVT.catv_rec_type;
5 subtype catv_tbl_type is OKC_K_ARTICLE_PVT.catv_tbl_type;
6 subtype atnv_rec_type is OKC_K_ARTICLE_PVT.atnv_rec_type;
7 subtype atnv_tbl_type is OKC_K_ARTICLE_PVT.atnv_tbl_type;
8
9 -- global variables for user hooks
10 g_catv_rec catv_rec_type;
11 g_atnv_rec atnv_rec_type;
12
13 -- public procedure declarations
14 procedure add_language;
15 procedure create_k_article(p_api_version IN NUMBER,
16 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2,
20 p_catv_rec IN catv_rec_type,
21 x_catv_rec OUT NOCOPY catv_rec_type);
22 procedure lock_k_article(p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_catv_rec IN catv_rec_type);
28 procedure update_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 x_catv_rec OUT NOCOPY catv_rec_type);
35 procedure delete_k_article(p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_catv_rec IN catv_rec_type);
41 procedure validate_k_article(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_catv_rec IN catv_rec_type);
47 procedure create_article_translation(p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_atnv_rec IN atnv_rec_type,
53 x_atnv_rec OUT NOCOPY atnv_rec_type);
54 procedure lock_article_translation(p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_atnv_rec IN atnv_rec_type);
60 procedure delete_article_translation(p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_atnv_rec IN atnv_rec_type);
66 procedure validate_article_translation(p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_atnv_rec IN atnv_rec_type);
72 procedure create_k_article(p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_catv_tbl IN catv_tbl_type,
78 x_catv_tbl OUT NOCOPY catv_tbl_type);
79 procedure lock_k_article(p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_catv_tbl IN catv_tbl_type);
85 procedure update_k_article(p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_catv_tbl IN catv_tbl_type,
91 x_catv_tbl OUT NOCOPY catv_tbl_type);
92 procedure delete_k_article(p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_catv_tbl IN catv_tbl_type);
98 procedure validate_k_article(p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_catv_tbl IN catv_tbl_type);
104 procedure create_article_translation(p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_atnv_tbl IN atnv_tbl_type,
110 x_atnv_tbl OUT NOCOPY atnv_tbl_type);
111 procedure lock_article_translation(p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_atnv_tbl IN atnv_tbl_type);
117 procedure delete_article_translation(p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_atnv_tbl IN atnv_tbl_type);
123 procedure validate_article_translation(p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_atnv_tbl IN atnv_tbl_type);
129 function std_art_name(p_sav_sae_id IN NUMBER) return varchar2;
130
131 FUNCTION get_rec (
132 p_id IN NUMBER,
133 p_major_version IN NUMBER := NULL,
134 x_no_data_found OUT NOCOPY BOOLEAN
135 ) RETURN catv_rec_type;
136 FUNCTION get_rec (
137 p_id IN NUMBER,
138 p_major_version IN NUMBER := NULL
139 ) RETURN catv_rec_type;
140
141 end OKC_K_ARTICLE_PUB;