[Home] [Help]
PACKAGE: APPS.OKL_CONTEXT_GROUPS_PUB_W
Source
1 package okl_context_groups_pub_w as
2 /* $Header: OKLUCGRS.pls 120.1 2005/07/08 10:20:01 asawanka noship $ */
3 procedure insert_context_groups(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy VARCHAR2
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy VARCHAR2
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy DATE
15 , p6_a7 out nocopy NUMBER
16 , p6_a8 out nocopy DATE
17 , p6_a9 out nocopy NUMBER
18 , p5_a0 NUMBER := 0-1962.0724
19 , p5_a1 NUMBER := 0-1962.0724
20 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
21 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
22 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
23 , p5_a5 NUMBER := 0-1962.0724
24 , p5_a6 DATE := fnd_api.g_miss_date
25 , p5_a7 NUMBER := 0-1962.0724
26 , p5_a8 DATE := fnd_api.g_miss_date
27 , p5_a9 NUMBER := 0-1962.0724
28 );
29 procedure insert_context_groups(p_api_version NUMBER
30 , p_init_msg_list VARCHAR2
31 , x_return_status out nocopy VARCHAR2
32 , x_msg_count out nocopy NUMBER
33 , x_msg_data out nocopy VARCHAR2
34 , p5_a0 JTF_NUMBER_TABLE
35 , p5_a1 JTF_NUMBER_TABLE
36 , p5_a2 JTF_VARCHAR2_TABLE_100
37 , p5_a3 JTF_VARCHAR2_TABLE_200
38 , p5_a4 JTF_VARCHAR2_TABLE_2000
39 , p5_a5 JTF_NUMBER_TABLE
40 , p5_a6 JTF_DATE_TABLE
41 , p5_a7 JTF_NUMBER_TABLE
42 , p5_a8 JTF_DATE_TABLE
43 , p5_a9 JTF_NUMBER_TABLE
44 , p6_a0 out nocopy JTF_NUMBER_TABLE
45 , p6_a1 out nocopy JTF_NUMBER_TABLE
46 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
47 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
48 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
49 , p6_a5 out nocopy JTF_NUMBER_TABLE
50 , p6_a6 out nocopy JTF_DATE_TABLE
51 , p6_a7 out nocopy JTF_NUMBER_TABLE
52 , p6_a8 out nocopy JTF_DATE_TABLE
53 , p6_a9 out nocopy JTF_NUMBER_TABLE
54 );
55 procedure lock_context_groups(p_api_version NUMBER
56 , p_init_msg_list VARCHAR2
57 , x_return_status out nocopy VARCHAR2
58 , x_msg_count out nocopy NUMBER
59 , x_msg_data out nocopy VARCHAR2
60 , p5_a0 NUMBER := 0-1962.0724
61 , p5_a1 NUMBER := 0-1962.0724
62 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
63 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
65 , p5_a5 NUMBER := 0-1962.0724
66 , p5_a6 DATE := fnd_api.g_miss_date
67 , p5_a7 NUMBER := 0-1962.0724
68 , p5_a8 DATE := fnd_api.g_miss_date
69 , p5_a9 NUMBER := 0-1962.0724
70 );
71 procedure lock_context_groups(p_api_version NUMBER
72 , p_init_msg_list VARCHAR2
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 , p5_a0 JTF_NUMBER_TABLE
77 , p5_a1 JTF_NUMBER_TABLE
78 , p5_a2 JTF_VARCHAR2_TABLE_100
79 , p5_a3 JTF_VARCHAR2_TABLE_200
80 , p5_a4 JTF_VARCHAR2_TABLE_2000
81 , p5_a5 JTF_NUMBER_TABLE
82 , p5_a6 JTF_DATE_TABLE
83 , p5_a7 JTF_NUMBER_TABLE
84 , p5_a8 JTF_DATE_TABLE
85 , p5_a9 JTF_NUMBER_TABLE
86 );
87 procedure update_context_groups(p_api_version NUMBER
88 , p_init_msg_list VARCHAR2
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , p6_a0 out nocopy NUMBER
93 , p6_a1 out nocopy NUMBER
94 , p6_a2 out nocopy VARCHAR2
95 , p6_a3 out nocopy VARCHAR2
96 , p6_a4 out nocopy VARCHAR2
97 , p6_a5 out nocopy NUMBER
98 , p6_a6 out nocopy DATE
99 , p6_a7 out nocopy NUMBER
100 , p6_a8 out nocopy DATE
101 , p6_a9 out nocopy NUMBER
102 , p5_a0 NUMBER := 0-1962.0724
103 , p5_a1 NUMBER := 0-1962.0724
104 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
107 , p5_a5 NUMBER := 0-1962.0724
108 , p5_a6 DATE := fnd_api.g_miss_date
109 , p5_a7 NUMBER := 0-1962.0724
110 , p5_a8 DATE := fnd_api.g_miss_date
111 , p5_a9 NUMBER := 0-1962.0724
112 );
113 procedure update_context_groups(p_api_version NUMBER
114 , p_init_msg_list VARCHAR2
115 , x_return_status out nocopy VARCHAR2
116 , x_msg_count out nocopy NUMBER
117 , x_msg_data out nocopy VARCHAR2
118 , p5_a0 JTF_NUMBER_TABLE
119 , p5_a1 JTF_NUMBER_TABLE
120 , p5_a2 JTF_VARCHAR2_TABLE_100
121 , p5_a3 JTF_VARCHAR2_TABLE_200
122 , p5_a4 JTF_VARCHAR2_TABLE_2000
123 , p5_a5 JTF_NUMBER_TABLE
124 , p5_a6 JTF_DATE_TABLE
125 , p5_a7 JTF_NUMBER_TABLE
126 , p5_a8 JTF_DATE_TABLE
127 , p5_a9 JTF_NUMBER_TABLE
128 , p6_a0 out nocopy JTF_NUMBER_TABLE
129 , p6_a1 out nocopy JTF_NUMBER_TABLE
130 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
133 , p6_a5 out nocopy JTF_NUMBER_TABLE
134 , p6_a6 out nocopy JTF_DATE_TABLE
135 , p6_a7 out nocopy JTF_NUMBER_TABLE
136 , p6_a8 out nocopy JTF_DATE_TABLE
137 , p6_a9 out nocopy JTF_NUMBER_TABLE
138 );
139 procedure delete_context_groups(p_api_version NUMBER
140 , p_init_msg_list VARCHAR2
141 , x_return_status out nocopy VARCHAR2
142 , x_msg_count out nocopy NUMBER
143 , x_msg_data out nocopy VARCHAR2
144 , p5_a0 NUMBER := 0-1962.0724
145 , p5_a1 NUMBER := 0-1962.0724
146 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
147 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a5 NUMBER := 0-1962.0724
150 , p5_a6 DATE := fnd_api.g_miss_date
151 , p5_a7 NUMBER := 0-1962.0724
152 , p5_a8 DATE := fnd_api.g_miss_date
153 , p5_a9 NUMBER := 0-1962.0724
154 );
155 procedure delete_context_groups(p_api_version NUMBER
156 , p_init_msg_list VARCHAR2
157 , x_return_status out nocopy VARCHAR2
158 , x_msg_count out nocopy NUMBER
159 , x_msg_data out nocopy VARCHAR2
160 , p5_a0 JTF_NUMBER_TABLE
161 , p5_a1 JTF_NUMBER_TABLE
162 , p5_a2 JTF_VARCHAR2_TABLE_100
163 , p5_a3 JTF_VARCHAR2_TABLE_200
164 , p5_a4 JTF_VARCHAR2_TABLE_2000
165 , p5_a5 JTF_NUMBER_TABLE
166 , p5_a6 JTF_DATE_TABLE
167 , p5_a7 JTF_NUMBER_TABLE
168 , p5_a8 JTF_DATE_TABLE
169 , p5_a9 JTF_NUMBER_TABLE
170 );
171 procedure validate_context_groups(p_api_version NUMBER
172 , p_init_msg_list VARCHAR2
173 , x_return_status out nocopy VARCHAR2
174 , x_msg_count out nocopy NUMBER
175 , x_msg_data out nocopy VARCHAR2
176 , p5_a0 NUMBER := 0-1962.0724
177 , p5_a1 NUMBER := 0-1962.0724
178 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
180 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
181 , p5_a5 NUMBER := 0-1962.0724
182 , p5_a6 DATE := fnd_api.g_miss_date
183 , p5_a7 NUMBER := 0-1962.0724
184 , p5_a8 DATE := fnd_api.g_miss_date
185 , p5_a9 NUMBER := 0-1962.0724
186 );
187 procedure validate_context_groups(p_api_version NUMBER
188 , p_init_msg_list VARCHAR2
189 , x_return_status out nocopy VARCHAR2
190 , x_msg_count out nocopy NUMBER
191 , x_msg_data out nocopy VARCHAR2
192 , p5_a0 JTF_NUMBER_TABLE
193 , p5_a1 JTF_NUMBER_TABLE
194 , p5_a2 JTF_VARCHAR2_TABLE_100
195 , p5_a3 JTF_VARCHAR2_TABLE_200
196 , p5_a4 JTF_VARCHAR2_TABLE_2000
197 , p5_a5 JTF_NUMBER_TABLE
198 , p5_a6 JTF_DATE_TABLE
199 , p5_a7 JTF_NUMBER_TABLE
200 , p5_a8 JTF_DATE_TABLE
201 , p5_a9 JTF_NUMBER_TABLE
202 );
203 end okl_context_groups_pub_w;