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_FUNDING_CHECKLIST_PVT_W

Source


1 package okl_funding_checklist_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLECLFS.pls 115.1 2003/02/27 00:56:11 cklee noship $ */
3   procedure rosetta_table_copy_in_p14(t out nocopy okl_funding_checklist_pvt.rulv_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_200
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_500
10     , a7 JTF_VARCHAR2_TABLE_500
11     , a8 JTF_VARCHAR2_TABLE_500
12     , a9 JTF_VARCHAR2_TABLE_500
13     , a10 JTF_VARCHAR2_TABLE_500
14     , a11 JTF_VARCHAR2_TABLE_500
15     , a12 JTF_VARCHAR2_TABLE_500
16     , a13 JTF_VARCHAR2_TABLE_500
17     , a14 JTF_VARCHAR2_TABLE_500
18     , a15 JTF_VARCHAR2_TABLE_500
19     , a16 JTF_VARCHAR2_TABLE_500
20     , a17 JTF_VARCHAR2_TABLE_500
21     , a18 JTF_VARCHAR2_TABLE_500
22     , a19 JTF_VARCHAR2_TABLE_500
23     , a20 JTF_VARCHAR2_TABLE_500
24     , a21 JTF_NUMBER_TABLE
25     );
26   procedure rosetta_table_copy_out_p14(t okl_funding_checklist_pvt.rulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27     , a1 out nocopy JTF_VARCHAR2_TABLE_100
28     , a2 out nocopy JTF_VARCHAR2_TABLE_200
29     , a3 out nocopy JTF_NUMBER_TABLE
30     , a4 out nocopy JTF_NUMBER_TABLE
31     , a5 out nocopy JTF_VARCHAR2_TABLE_100
32     , a6 out nocopy JTF_VARCHAR2_TABLE_500
33     , a7 out nocopy JTF_VARCHAR2_TABLE_500
34     , a8 out nocopy JTF_VARCHAR2_TABLE_500
35     , a9 out nocopy JTF_VARCHAR2_TABLE_500
36     , a10 out nocopy JTF_VARCHAR2_TABLE_500
37     , a11 out nocopy JTF_VARCHAR2_TABLE_500
38     , a12 out nocopy JTF_VARCHAR2_TABLE_500
39     , a13 out nocopy JTF_VARCHAR2_TABLE_500
40     , a14 out nocopy JTF_VARCHAR2_TABLE_500
41     , a15 out nocopy JTF_VARCHAR2_TABLE_500
42     , a16 out nocopy JTF_VARCHAR2_TABLE_500
43     , a17 out nocopy JTF_VARCHAR2_TABLE_500
44     , a18 out nocopy JTF_VARCHAR2_TABLE_500
45     , a19 out nocopy JTF_VARCHAR2_TABLE_500
46     , a20 out nocopy JTF_VARCHAR2_TABLE_500
47     , a21 out nocopy JTF_NUMBER_TABLE
48     );
49 
50   procedure create_funding_chklst(p_api_version  NUMBER
51     , p_init_msg_list  VARCHAR2
52     , x_return_status out nocopy  VARCHAR2
53     , x_msg_count out nocopy  NUMBER
54     , x_msg_data out nocopy  VARCHAR2
55     , p5_a0 JTF_NUMBER_TABLE
56     , p5_a1 JTF_VARCHAR2_TABLE_100
57     , p5_a2 JTF_VARCHAR2_TABLE_200
58     , p5_a3 JTF_NUMBER_TABLE
59     , p5_a4 JTF_NUMBER_TABLE
60     , p5_a5 JTF_VARCHAR2_TABLE_100
61     , p5_a6 JTF_VARCHAR2_TABLE_500
62     , p5_a7 JTF_VARCHAR2_TABLE_500
63     , p5_a8 JTF_VARCHAR2_TABLE_500
64     , p5_a9 JTF_VARCHAR2_TABLE_500
65     , p5_a10 JTF_VARCHAR2_TABLE_500
66     , p5_a11 JTF_VARCHAR2_TABLE_500
67     , p5_a12 JTF_VARCHAR2_TABLE_500
68     , p5_a13 JTF_VARCHAR2_TABLE_500
69     , p5_a14 JTF_VARCHAR2_TABLE_500
70     , p5_a15 JTF_VARCHAR2_TABLE_500
71     , p5_a16 JTF_VARCHAR2_TABLE_500
72     , p5_a17 JTF_VARCHAR2_TABLE_500
73     , p5_a18 JTF_VARCHAR2_TABLE_500
74     , p5_a19 JTF_VARCHAR2_TABLE_500
75     , p5_a20 JTF_VARCHAR2_TABLE_500
76     , p5_a21 JTF_NUMBER_TABLE
77     , p6_a0 out nocopy JTF_NUMBER_TABLE
78     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
79     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
80     , p6_a3 out nocopy JTF_NUMBER_TABLE
81     , p6_a4 out nocopy JTF_NUMBER_TABLE
82     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
83     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
84     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
85     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
86     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
87     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
88     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
89     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
90     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
91     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
92     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
93     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
94     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
95     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
96     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
97     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
98     , p6_a21 out nocopy JTF_NUMBER_TABLE
99   );
100   procedure update_funding_chklst(p_api_version  NUMBER
101     , p_init_msg_list  VARCHAR2
102     , x_return_status out nocopy  VARCHAR2
103     , x_msg_count out nocopy  NUMBER
104     , x_msg_data out nocopy  VARCHAR2
105     , p5_a0 JTF_NUMBER_TABLE
106     , p5_a1 JTF_VARCHAR2_TABLE_100
107     , p5_a2 JTF_VARCHAR2_TABLE_200
108     , p5_a3 JTF_NUMBER_TABLE
109     , p5_a4 JTF_NUMBER_TABLE
110     , p5_a5 JTF_VARCHAR2_TABLE_100
111     , p5_a6 JTF_VARCHAR2_TABLE_500
112     , p5_a7 JTF_VARCHAR2_TABLE_500
113     , p5_a8 JTF_VARCHAR2_TABLE_500
114     , p5_a9 JTF_VARCHAR2_TABLE_500
115     , p5_a10 JTF_VARCHAR2_TABLE_500
116     , p5_a11 JTF_VARCHAR2_TABLE_500
117     , p5_a12 JTF_VARCHAR2_TABLE_500
118     , p5_a13 JTF_VARCHAR2_TABLE_500
119     , p5_a14 JTF_VARCHAR2_TABLE_500
120     , p5_a15 JTF_VARCHAR2_TABLE_500
121     , p5_a16 JTF_VARCHAR2_TABLE_500
122     , p5_a17 JTF_VARCHAR2_TABLE_500
123     , p5_a18 JTF_VARCHAR2_TABLE_500
124     , p5_a19 JTF_VARCHAR2_TABLE_500
125     , p5_a20 JTF_VARCHAR2_TABLE_500
126     , p5_a21 JTF_NUMBER_TABLE
127     , p6_a0 out nocopy JTF_NUMBER_TABLE
128     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
129     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
130     , p6_a3 out nocopy JTF_NUMBER_TABLE
131     , p6_a4 out nocopy JTF_NUMBER_TABLE
132     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
133     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
134     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
135     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
136     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
137     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
138     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
139     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
140     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
141     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
142     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
143     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
144     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
145     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
146     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
147     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
148     , p6_a21 out nocopy JTF_NUMBER_TABLE
149   );
150   procedure delete_funding_chklst(p_api_version  NUMBER
151     , p_init_msg_list  VARCHAR2
152     , x_return_status out nocopy  VARCHAR2
153     , x_msg_count out nocopy  NUMBER
154     , x_msg_data out nocopy  VARCHAR2
155     , p5_a0 JTF_NUMBER_TABLE
156     , p5_a1 JTF_VARCHAR2_TABLE_100
157     , p5_a2 JTF_VARCHAR2_TABLE_200
158     , p5_a3 JTF_NUMBER_TABLE
159     , p5_a4 JTF_NUMBER_TABLE
160     , p5_a5 JTF_VARCHAR2_TABLE_100
161     , p5_a6 JTF_VARCHAR2_TABLE_500
162     , p5_a7 JTF_VARCHAR2_TABLE_500
163     , p5_a8 JTF_VARCHAR2_TABLE_500
164     , p5_a9 JTF_VARCHAR2_TABLE_500
165     , p5_a10 JTF_VARCHAR2_TABLE_500
166     , p5_a11 JTF_VARCHAR2_TABLE_500
167     , p5_a12 JTF_VARCHAR2_TABLE_500
168     , p5_a13 JTF_VARCHAR2_TABLE_500
169     , p5_a14 JTF_VARCHAR2_TABLE_500
170     , p5_a15 JTF_VARCHAR2_TABLE_500
171     , p5_a16 JTF_VARCHAR2_TABLE_500
172     , p5_a17 JTF_VARCHAR2_TABLE_500
173     , p5_a18 JTF_VARCHAR2_TABLE_500
174     , p5_a19 JTF_VARCHAR2_TABLE_500
175     , p5_a20 JTF_VARCHAR2_TABLE_500
176     , p5_a21 JTF_NUMBER_TABLE
177   );
178   procedure approve_funding_chklst(p_api_version  NUMBER
179     , p_init_msg_list  VARCHAR2
180     , x_return_status out nocopy  VARCHAR2
181     , x_msg_count out nocopy  NUMBER
182     , x_msg_data out nocopy  VARCHAR2
183     , p5_a0  NUMBER := 0-1962.0724
184     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
185     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
186     , p5_a3  NUMBER := 0-1962.0724
187     , p5_a4  NUMBER := 0-1962.0724
188     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
190     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
192     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
193     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
194     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
195     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
196     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
197     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
198     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
200     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
201     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
202     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a21  NUMBER := 0-1962.0724
205   );
206 end okl_funding_checklist_pvt_w;