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