[Home] [Help]
PACKAGE: APPS.OKL_FMLA_OPRNDS_PUB_W
Source
1 package okl_fmla_oprnds_pub_w as
2 /* $Header: OKLUFODS.pls 120.1 2005/07/12 07:06:54 asawanka noship $ */
3 procedure insert_fmla_oprnds(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 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 NUMBER := 0-1962.0724
21 , p5_a3 NUMBER := 0-1962.0724
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_fmla_oprnds(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_NUMBER_TABLE
37 , p5_a3 JTF_NUMBER_TABLE
38 , p5_a4 JTF_VARCHAR2_TABLE_800
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_NUMBER_TABLE
47 , p6_a3 out nocopy JTF_NUMBER_TABLE
48 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_800
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_fmla_oprnds(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 NUMBER := 0-1962.0724
63 , p5_a3 NUMBER := 0-1962.0724
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_fmla_oprnds(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_NUMBER_TABLE
79 , p5_a3 JTF_NUMBER_TABLE
80 , p5_a4 JTF_VARCHAR2_TABLE_800
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_fmla_oprnds(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 NUMBER
95 , p6_a3 out nocopy NUMBER
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 NUMBER := 0-1962.0724
105 , p5_a3 NUMBER := 0-1962.0724
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_fmla_oprnds(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_NUMBER_TABLE
121 , p5_a3 JTF_NUMBER_TABLE
122 , p5_a4 JTF_VARCHAR2_TABLE_800
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_NUMBER_TABLE
131 , p6_a3 out nocopy JTF_NUMBER_TABLE
132 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_800
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_fmla_oprnds(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 NUMBER := 0-1962.0724
147 , p5_a3 NUMBER := 0-1962.0724
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_fmla_oprnds(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_NUMBER_TABLE
163 , p5_a3 JTF_NUMBER_TABLE
164 , p5_a4 JTF_VARCHAR2_TABLE_800
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_fmla_oprnds(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 NUMBER := 0-1962.0724
179 , p5_a3 NUMBER := 0-1962.0724
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_fmla_oprnds(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_NUMBER_TABLE
195 , p5_a3 JTF_NUMBER_TABLE
196 , p5_a4 JTF_VARCHAR2_TABLE_800
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_fmla_oprnds_pub_w;