[Home] [Help]
PACKAGE: APPS.OKC_CHANGE_REQUEST_PUB
Source
1 package OKC_CHANGE_REQUEST_PUB AUTHID CURRENT_USER as
2 /* $Header: OKCPCRTS.pls 120.0 2005/05/26 09:39:03 appldev noship $ */
3 -- simple entity object subtype definitions
4 subtype crtv_rec_type is OKC_CHANGE_REQUEST_PVT.crtv_rec_type;
5 subtype crtv_tbl_type is OKC_CHANGE_REQUEST_PVT.crtv_tbl_type;
6 subtype corv_rec_type is OKC_CHANGE_REQUEST_PVT.corv_rec_type;
7 subtype corv_tbl_type is OKC_CHANGE_REQUEST_PVT.corv_tbl_type;
8 subtype cprv_rec_type is OKC_CHANGE_REQUEST_PVT.cprv_rec_type;
9 subtype cprv_tbl_type is OKC_CHANGE_REQUEST_PVT.cprv_tbl_type;
10
11 -- global variables
12 g_crtv_rec crtv_rec_type;
13 g_corv_rec corv_rec_type;
14 g_cprv_rec cprv_rec_type;
15
16 -- public procedure declarations
17 procedure add_language;
18 procedure create_change_request(p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_crtv_rec IN crtv_rec_type,
24 x_crtv_rec OUT NOCOPY crtv_rec_type);
25 procedure create_change_request(p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_crtv_tbl IN crtv_tbl_type,
31 x_crtv_tbl OUT NOCOPY crtv_tbl_type);
32 procedure update_change_request(p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_crtv_rec IN crtv_rec_type,
38 x_crtv_rec OUT NOCOPY crtv_rec_type);
39 procedure update_change_request(p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_crtv_tbl IN crtv_tbl_type,
45 x_crtv_tbl OUT NOCOPY crtv_tbl_type);
46 procedure delete_change_request(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_crtv_rec IN crtv_rec_type);
52 procedure delete_change_request(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_crtv_tbl IN crtv_tbl_type);
58 procedure lock_change_request(p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
64 p_crtv_rec IN crtv_rec_type);
65 procedure lock_change_request(p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
71 p_crtv_tbl IN crtv_tbl_type);
72 procedure validate_change_request(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_crtv_rec IN crtv_rec_type);
78 procedure validate_change_request(p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_crtv_tbl IN crtv_tbl_type);
84 procedure create_change(p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_corv_rec IN corv_rec_type,
90 x_corv_rec OUT NOCOPY corv_rec_type);
91 procedure create_change(p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_corv_tbl IN corv_tbl_type,
97 x_corv_tbl OUT NOCOPY corv_tbl_type);
98 procedure update_change(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_corv_rec IN corv_rec_type,
104 x_corv_rec OUT NOCOPY corv_rec_type);
105 procedure update_change(p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_corv_tbl IN corv_tbl_type,
111 x_corv_tbl OUT NOCOPY corv_tbl_type);
112 procedure delete_change(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_corv_rec IN corv_rec_type);
118 procedure delete_change(p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_corv_tbl IN corv_tbl_type);
124 procedure lock_change(p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_corv_rec IN corv_rec_type);
130 procedure lock_change(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_corv_tbl IN corv_tbl_type);
136 procedure validate_change(p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_corv_rec IN corv_rec_type);
142 procedure validate_change(p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_corv_tbl IN corv_tbl_type);
148 procedure create_change_party_role(p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_cprv_rec IN cprv_rec_type,
154 x_cprv_rec OUT NOCOPY cprv_rec_type);
155 procedure create_change_party_role(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_cprv_tbl IN cprv_tbl_type,
161 x_cprv_tbl OUT NOCOPY cprv_tbl_type);
162 procedure update_change_party_role(p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_cprv_rec IN cprv_rec_type,
168 x_cprv_rec OUT NOCOPY cprv_rec_type);
169 procedure update_change_party_role(p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_cprv_tbl IN cprv_tbl_type,
175 x_cprv_tbl OUT NOCOPY cprv_tbl_type);
176 procedure delete_change_party_role(p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_cprv_rec IN cprv_rec_type);
182 procedure delete_change_party_role(p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_cprv_tbl IN cprv_tbl_type);
188 procedure lock_change_party_role(p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_cprv_rec IN cprv_rec_type);
194 procedure lock_change_party_role(p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_cprv_tbl IN cprv_tbl_type);
200 procedure validate_change_party_role(p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_cprv_rec IN cprv_rec_type);
206 procedure validate_change_party_role(p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_cprv_tbl IN cprv_tbl_type);
212
213 procedure put(p varchar2);
214 function get return varchar2;
215 function reset return varchar2;
216
217 end OKC_CHANGE_REQUEST_PUB;