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_SEC_AGREEMENT_PVT_W

Source


1 package okl_sec_agreement_pvt_w as
2   /* $Header: OKLESZAS.pls 120.4 2008/01/07 11:07:36 sosharma noship $ */
3   procedure rosetta_table_copy_in_p11(t out nocopy okl_sec_agreement_pvt.secagreement_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_200
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_600
8     , a5 JTF_DATE_TABLE
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_DATE_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_VARCHAR2_TABLE_100
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_NUMBER_TABLE
24     , a21 JTF_VARCHAR2_TABLE_100
25     , a22 JTF_VARCHAR2_TABLE_500
26     , a23 JTF_VARCHAR2_TABLE_500
27     , a24 JTF_VARCHAR2_TABLE_500
28     , a25 JTF_VARCHAR2_TABLE_500
29     , a26 JTF_VARCHAR2_TABLE_500
30     , a27 JTF_VARCHAR2_TABLE_500
31     , a28 JTF_VARCHAR2_TABLE_500
32     , a29 JTF_VARCHAR2_TABLE_500
33     , a30 JTF_VARCHAR2_TABLE_500
34     , a31 JTF_VARCHAR2_TABLE_500
35     , a32 JTF_VARCHAR2_TABLE_500
36     , a33 JTF_VARCHAR2_TABLE_500
37     , a34 JTF_VARCHAR2_TABLE_500
38     , a35 JTF_VARCHAR2_TABLE_500
39     , a36 JTF_VARCHAR2_TABLE_500
40     , a37 JTF_NUMBER_TABLE
41     );
42   procedure rosetta_table_copy_out_p11(t okl_sec_agreement_pvt.secagreement_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43     , a1 out nocopy JTF_VARCHAR2_TABLE_200
44     , a2 out nocopy JTF_NUMBER_TABLE
45     , a3 out nocopy JTF_NUMBER_TABLE
46     , a4 out nocopy JTF_VARCHAR2_TABLE_600
47     , a5 out nocopy JTF_DATE_TABLE
48     , a6 out nocopy JTF_DATE_TABLE
49     , a7 out nocopy JTF_DATE_TABLE
50     , a8 out nocopy JTF_VARCHAR2_TABLE_100
51     , a9 out nocopy JTF_VARCHAR2_TABLE_100
52     , a10 out nocopy JTF_VARCHAR2_TABLE_100
53     , a11 out nocopy JTF_VARCHAR2_TABLE_100
54     , a12 out nocopy JTF_VARCHAR2_TABLE_100
55     , a13 out nocopy JTF_VARCHAR2_TABLE_100
56     , a14 out nocopy JTF_NUMBER_TABLE
57     , a15 out nocopy JTF_DATE_TABLE
58     , a16 out nocopy JTF_NUMBER_TABLE
59     , a17 out nocopy JTF_VARCHAR2_TABLE_100
60     , a18 out nocopy JTF_VARCHAR2_TABLE_100
61     , a19 out nocopy JTF_VARCHAR2_TABLE_100
62     , a20 out nocopy JTF_NUMBER_TABLE
63     , a21 out nocopy JTF_VARCHAR2_TABLE_100
64     , a22 out nocopy JTF_VARCHAR2_TABLE_500
65     , a23 out nocopy JTF_VARCHAR2_TABLE_500
66     , a24 out nocopy JTF_VARCHAR2_TABLE_500
67     , a25 out nocopy JTF_VARCHAR2_TABLE_500
68     , a26 out nocopy JTF_VARCHAR2_TABLE_500
69     , a27 out nocopy JTF_VARCHAR2_TABLE_500
70     , a28 out nocopy JTF_VARCHAR2_TABLE_500
71     , a29 out nocopy JTF_VARCHAR2_TABLE_500
72     , a30 out nocopy JTF_VARCHAR2_TABLE_500
73     , a31 out nocopy JTF_VARCHAR2_TABLE_500
74     , a32 out nocopy JTF_VARCHAR2_TABLE_500
75     , a33 out nocopy JTF_VARCHAR2_TABLE_500
76     , a34 out nocopy JTF_VARCHAR2_TABLE_500
77     , a35 out nocopy JTF_VARCHAR2_TABLE_500
78     , a36 out nocopy JTF_VARCHAR2_TABLE_500
79     , a37 out nocopy JTF_NUMBER_TABLE
80     );
81 
82   procedure create_sec_agreement(p_api_version  NUMBER
83     , p_init_msg_list  VARCHAR2
84     , x_return_status out nocopy  VARCHAR2
85     , x_msg_count out nocopy  NUMBER
86     , x_msg_data out nocopy  VARCHAR2
87     , p6_a0 out nocopy  NUMBER
88     , p6_a1 out nocopy  VARCHAR2
89     , p6_a2 out nocopy  NUMBER
90     , p6_a3 out nocopy  NUMBER
91     , p6_a4 out nocopy  VARCHAR2
92     , p6_a5 out nocopy  DATE
93     , p6_a6 out nocopy  DATE
94     , p6_a7 out nocopy  DATE
95     , p6_a8 out nocopy  VARCHAR2
96     , p6_a9 out nocopy  VARCHAR2
97     , p6_a10 out nocopy  VARCHAR2
98     , p6_a11 out nocopy  VARCHAR2
99     , p6_a12 out nocopy  VARCHAR2
100     , p6_a13 out nocopy  VARCHAR2
101     , p6_a14 out nocopy  NUMBER
102     , p6_a15 out nocopy  DATE
103     , p6_a16 out nocopy  NUMBER
104     , p6_a17 out nocopy  VARCHAR2
105     , p6_a18 out nocopy  VARCHAR2
106     , p6_a19 out nocopy  VARCHAR2
107     , p6_a20 out nocopy  NUMBER
108     , p6_a21 out nocopy  VARCHAR2
109     , p6_a22 out nocopy  VARCHAR2
110     , p6_a23 out nocopy  VARCHAR2
111     , p6_a24 out nocopy  VARCHAR2
112     , p6_a25 out nocopy  VARCHAR2
113     , p6_a26 out nocopy  VARCHAR2
114     , p6_a27 out nocopy  VARCHAR2
115     , p6_a28 out nocopy  VARCHAR2
116     , p6_a29 out nocopy  VARCHAR2
117     , p6_a30 out nocopy  VARCHAR2
118     , p6_a31 out nocopy  VARCHAR2
119     , p6_a32 out nocopy  VARCHAR2
120     , p6_a33 out nocopy  VARCHAR2
121     , p6_a34 out nocopy  VARCHAR2
122     , p6_a35 out nocopy  VARCHAR2
123     , p6_a36 out nocopy  VARCHAR2
124     , p6_a37 out nocopy  NUMBER
125     , p5_a0  NUMBER := 0-1962.0724
126     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
127     , p5_a2  NUMBER := 0-1962.0724
128     , p5_a3  NUMBER := 0-1962.0724
129     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
130     , p5_a5  DATE := fnd_api.g_miss_date
131     , p5_a6  DATE := fnd_api.g_miss_date
132     , p5_a7  DATE := fnd_api.g_miss_date
133     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
134     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
135     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
136     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
137     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
138     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
139     , p5_a14  NUMBER := 0-1962.0724
140     , p5_a15  DATE := fnd_api.g_miss_date
141     , p5_a16  NUMBER := 0-1962.0724
142     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
143     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
144     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
145     , p5_a20  NUMBER := 0-1962.0724
146     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
147     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
148     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
149     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
150     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
151     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
152     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
153     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
154     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
155     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
157     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
158     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
159     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
160     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a37  NUMBER := 0-1962.0724
163   );
164   procedure update_sec_agreement(p_api_version  NUMBER
165     , p_init_msg_list  VARCHAR2
166     , x_return_status out nocopy  VARCHAR2
167     , x_msg_count out nocopy  NUMBER
168     , x_msg_data out nocopy  VARCHAR2
169     , p6_a0 out nocopy  NUMBER
170     , p6_a1 out nocopy  VARCHAR2
171     , p6_a2 out nocopy  NUMBER
172     , p6_a3 out nocopy  NUMBER
173     , p6_a4 out nocopy  VARCHAR2
174     , p6_a5 out nocopy  DATE
175     , p6_a6 out nocopy  DATE
176     , p6_a7 out nocopy  DATE
177     , p6_a8 out nocopy  VARCHAR2
178     , p6_a9 out nocopy  VARCHAR2
179     , p6_a10 out nocopy  VARCHAR2
180     , p6_a11 out nocopy  VARCHAR2
181     , p6_a12 out nocopy  VARCHAR2
182     , p6_a13 out nocopy  VARCHAR2
183     , p6_a14 out nocopy  NUMBER
184     , p6_a15 out nocopy  DATE
185     , p6_a16 out nocopy  NUMBER
186     , p6_a17 out nocopy  VARCHAR2
187     , p6_a18 out nocopy  VARCHAR2
188     , p6_a19 out nocopy  VARCHAR2
189     , p6_a20 out nocopy  NUMBER
190     , p6_a21 out nocopy  VARCHAR2
191     , p6_a22 out nocopy  VARCHAR2
192     , p6_a23 out nocopy  VARCHAR2
193     , p6_a24 out nocopy  VARCHAR2
194     , p6_a25 out nocopy  VARCHAR2
195     , p6_a26 out nocopy  VARCHAR2
196     , p6_a27 out nocopy  VARCHAR2
197     , p6_a28 out nocopy  VARCHAR2
198     , p6_a29 out nocopy  VARCHAR2
199     , p6_a30 out nocopy  VARCHAR2
200     , p6_a31 out nocopy  VARCHAR2
201     , p6_a32 out nocopy  VARCHAR2
202     , p6_a33 out nocopy  VARCHAR2
203     , p6_a34 out nocopy  VARCHAR2
204     , p6_a35 out nocopy  VARCHAR2
205     , p6_a36 out nocopy  VARCHAR2
206     , p6_a37 out nocopy  NUMBER
207     , p5_a0  NUMBER := 0-1962.0724
208     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
209     , p5_a2  NUMBER := 0-1962.0724
210     , p5_a3  NUMBER := 0-1962.0724
211     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a5  DATE := fnd_api.g_miss_date
213     , p5_a6  DATE := fnd_api.g_miss_date
214     , p5_a7  DATE := fnd_api.g_miss_date
215     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
216     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
218     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
219     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
220     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a14  NUMBER := 0-1962.0724
222     , p5_a15  DATE := fnd_api.g_miss_date
223     , p5_a16  NUMBER := 0-1962.0724
224     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a20  NUMBER := 0-1962.0724
228     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
244     , p5_a37  NUMBER := 0-1962.0724
245   );
246 end okl_sec_agreement_pvt_w;