[Home] [Help]
PACKAGE: APPS.OKC_SECTIONS_PUB
Source
1 PACKAGE OKC_SECTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPSCNS.pls 120.0 2005/05/25 19:09:44 appldev noship $ */
3
4 subtype scnv_rec_type is okc_sections_pvt.scnv_rec_type;
5 subtype scnv_tbl_type is okc_sections_pvt.scnv_tbl_type;
6 subtype sccv_rec_type is okc_sections_pvt.sccv_rec_type;
7 subtype sccv_tbl_type is okc_sections_pvt.sccv_tbl_type;
8
9 -- Global variables for user hooks
10 g_pkg_name CONSTANT VARCHAR2(200) := 'OKC_SECTIONS_PUB';
11 g_app_name CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12
13 g_scnv_rec scnv_rec_type;
14 g_scnv_tbl scnv_tbl_type;
15 g_sccv_rec sccv_rec_type;
16 g_sccv_tbl sccv_tbl_type;
17
18 PROCEDURE create_section(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_scnv_rec IN scnv_rec_type,
25 x_scnv_rec OUT NOCOPY scnv_rec_type);
26
27 PROCEDURE create_section(
28 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_scnv_tbl IN scnv_tbl_type,
34 x_scnv_tbl OUT NOCOPY scnv_tbl_type);
35
36 PROCEDURE update_section(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_scnv_rec IN scnv_rec_type,
43 x_scnv_rec OUT NOCOPY scnv_rec_type);
44
45 PROCEDURE update_section(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_scnv_tbl IN scnv_tbl_type,
52 x_scnv_tbl OUT NOCOPY scnv_tbl_type);
53
54 PROCEDURE delete_section(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_scnv_rec IN scnv_rec_type);
61
62 PROCEDURE delete_section(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_scnv_tbl IN scnv_tbl_type);
69
70 PROCEDURE lock_section(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_scnv_rec IN scnv_rec_type);
77
78 PROCEDURE lock_section(
79 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_scnv_tbl IN scnv_tbl_type);
85
86 PROCEDURE validate_section(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_scnv_rec IN scnv_rec_type);
93
94 PROCEDURE validate_section(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_scnv_tbl IN scnv_tbl_type);
101
102 PROCEDURE create_section_content(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_sccv_rec IN sccv_rec_type,
109 x_sccv_rec OUT NOCOPY sccv_rec_type);
110
111 PROCEDURE create_section_content(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_sccv_tbl IN sccv_tbl_type,
118 x_sccv_tbl OUT NOCOPY sccv_tbl_type);
119
120 PROCEDURE update_section_content(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_sccv_rec IN sccv_rec_type,
127 x_sccv_rec OUT NOCOPY sccv_rec_type);
128
129 PROCEDURE update_section_content(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_sccv_tbl IN sccv_tbl_type,
136 x_sccv_tbl OUT NOCOPY sccv_tbl_type);
137
138 PROCEDURE delete_section_content(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_sccv_rec IN sccv_rec_type);
145
146 PROCEDURE delete_section_content(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_sccv_tbl IN sccv_tbl_type);
153
154 PROCEDURE lock_section_content(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_sccv_rec IN sccv_rec_type);
161
162 PROCEDURE lock_section_content(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_sccv_tbl IN sccv_tbl_type);
169
170 PROCEDURE validate_section_content(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_sccv_rec IN sccv_rec_type);
177
178 PROCEDURE validate_section_content(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_sccv_tbl IN sccv_tbl_type);
185
186 PROCEDURE add_language;
187
188 END OKC_SECTIONS_PUB;