eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_AMORT_HOLD_SETUPS_PUB_W

Source


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