[Home] [Help]
PACKAGE: APPS.OKL_SEC_INVESTOR_REVENUE_PVT_W
Source
1 package okl_sec_investor_revenue_pvt_w as
2 /* $Header: OKLESZRS.pls 120.2 2005/10/30 03:21:05 appldev noship $ */
3 procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 );
16 procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_NUMBER_TABLE
18 , a2 out nocopy JTF_VARCHAR2_TABLE_100
19 , a3 out nocopy JTF_NUMBER_TABLE
20 , a4 out nocopy JTF_NUMBER_TABLE
21 , a5 out nocopy JTF_NUMBER_TABLE
22 , a6 out nocopy JTF_NUMBER_TABLE
23 , a7 out nocopy JTF_DATE_TABLE
24 , a8 out nocopy JTF_DATE_TABLE
25 , a9 out nocopy JTF_DATE_TABLE
26 , a10 out nocopy JTF_VARCHAR2_TABLE_100
27 , a11 out nocopy JTF_VARCHAR2_TABLE_100
28 );
29
30 procedure create_investor_revenue(p_api_version NUMBER
31 , p_init_msg_list VARCHAR2
32 , x_return_status out nocopy VARCHAR2
33 , x_msg_count out nocopy NUMBER
34 , x_msg_data out nocopy VARCHAR2
35 , p6_a0 out nocopy NUMBER
36 , p6_a1 out nocopy NUMBER
37 , p6_a2 out nocopy VARCHAR2
38 , p6_a3 out nocopy NUMBER
39 , p6_a4 out nocopy NUMBER
40 , p6_a5 out nocopy NUMBER
41 , p6_a6 out nocopy NUMBER
42 , p6_a7 out nocopy DATE
43 , p6_a8 out nocopy DATE
44 , p6_a9 out nocopy DATE
45 , p6_a10 out nocopy VARCHAR2
46 , p6_a11 out nocopy VARCHAR2
47 , p5_a0 NUMBER := 0-1962.0724
48 , p5_a1 NUMBER := 0-1962.0724
49 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50 , p5_a3 NUMBER := 0-1962.0724
51 , p5_a4 NUMBER := 0-1962.0724
52 , p5_a5 NUMBER := 0-1962.0724
53 , p5_a6 NUMBER := 0-1962.0724
54 , p5_a7 DATE := fnd_api.g_miss_date
55 , p5_a8 DATE := fnd_api.g_miss_date
56 , p5_a9 DATE := fnd_api.g_miss_date
57 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
58 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
59 );
60 procedure update_investor_revenue(p_api_version NUMBER
61 , p_init_msg_list VARCHAR2
62 , x_return_status out nocopy VARCHAR2
63 , x_msg_count out nocopy NUMBER
64 , x_msg_data out nocopy VARCHAR2
65 , p6_a0 out nocopy NUMBER
66 , p6_a1 out nocopy NUMBER
67 , p6_a2 out nocopy VARCHAR2
68 , p6_a3 out nocopy NUMBER
69 , p6_a4 out nocopy NUMBER
70 , p6_a5 out nocopy NUMBER
71 , p6_a6 out nocopy NUMBER
72 , p6_a7 out nocopy DATE
73 , p6_a8 out nocopy DATE
74 , p6_a9 out nocopy DATE
75 , p6_a10 out nocopy VARCHAR2
76 , p6_a11 out nocopy VARCHAR2
77 , p5_a0 NUMBER := 0-1962.0724
78 , p5_a1 NUMBER := 0-1962.0724
79 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a3 NUMBER := 0-1962.0724
81 , p5_a4 NUMBER := 0-1962.0724
82 , p5_a5 NUMBER := 0-1962.0724
83 , p5_a6 NUMBER := 0-1962.0724
84 , p5_a7 DATE := fnd_api.g_miss_date
85 , p5_a8 DATE := fnd_api.g_miss_date
86 , p5_a9 DATE := fnd_api.g_miss_date
87 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
88 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
89 );
90 procedure delete_investor_revenue(p_api_version NUMBER
91 , p_init_msg_list VARCHAR2
92 , x_return_status out nocopy VARCHAR2
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 , p5_a0 NUMBER := 0-1962.0724
96 , p5_a1 NUMBER := 0-1962.0724
97 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a3 NUMBER := 0-1962.0724
99 , p5_a4 NUMBER := 0-1962.0724
100 , p5_a5 NUMBER := 0-1962.0724
101 , p5_a6 NUMBER := 0-1962.0724
102 , p5_a7 DATE := fnd_api.g_miss_date
103 , p5_a8 DATE := fnd_api.g_miss_date
104 , p5_a9 DATE := fnd_api.g_miss_date
105 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
107 );
108 procedure create_investor_revenue(p_api_version NUMBER
109 , p_init_msg_list VARCHAR2
110 , x_return_status out nocopy VARCHAR2
111 , x_msg_count out nocopy NUMBER
112 , x_msg_data out nocopy VARCHAR2
113 , p5_a0 JTF_NUMBER_TABLE
114 , p5_a1 JTF_NUMBER_TABLE
115 , p5_a2 JTF_VARCHAR2_TABLE_100
116 , p5_a3 JTF_NUMBER_TABLE
117 , p5_a4 JTF_NUMBER_TABLE
118 , p5_a5 JTF_NUMBER_TABLE
119 , p5_a6 JTF_NUMBER_TABLE
120 , p5_a7 JTF_DATE_TABLE
121 , p5_a8 JTF_DATE_TABLE
122 , p5_a9 JTF_DATE_TABLE
123 , p5_a10 JTF_VARCHAR2_TABLE_100
124 , p5_a11 JTF_VARCHAR2_TABLE_100
125 , p6_a0 out nocopy JTF_NUMBER_TABLE
126 , p6_a1 out nocopy JTF_NUMBER_TABLE
127 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128 , p6_a3 out nocopy JTF_NUMBER_TABLE
129 , p6_a4 out nocopy JTF_NUMBER_TABLE
130 , p6_a5 out nocopy JTF_NUMBER_TABLE
131 , p6_a6 out nocopy JTF_NUMBER_TABLE
132 , p6_a7 out nocopy JTF_DATE_TABLE
133 , p6_a8 out nocopy JTF_DATE_TABLE
134 , p6_a9 out nocopy JTF_DATE_TABLE
135 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
137 );
138 procedure update_investor_revenue(p_api_version NUMBER
139 , p_init_msg_list VARCHAR2
140 , x_return_status out nocopy VARCHAR2
141 , x_msg_count out nocopy NUMBER
142 , x_msg_data out nocopy VARCHAR2
143 , p5_a0 JTF_NUMBER_TABLE
144 , p5_a1 JTF_NUMBER_TABLE
145 , p5_a2 JTF_VARCHAR2_TABLE_100
146 , p5_a3 JTF_NUMBER_TABLE
147 , p5_a4 JTF_NUMBER_TABLE
148 , p5_a5 JTF_NUMBER_TABLE
149 , p5_a6 JTF_NUMBER_TABLE
150 , p5_a7 JTF_DATE_TABLE
151 , p5_a8 JTF_DATE_TABLE
152 , p5_a9 JTF_DATE_TABLE
153 , p5_a10 JTF_VARCHAR2_TABLE_100
154 , p5_a11 JTF_VARCHAR2_TABLE_100
155 , p6_a0 out nocopy JTF_NUMBER_TABLE
156 , p6_a1 out nocopy JTF_NUMBER_TABLE
157 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
158 , p6_a3 out nocopy JTF_NUMBER_TABLE
159 , p6_a4 out nocopy JTF_NUMBER_TABLE
160 , p6_a5 out nocopy JTF_NUMBER_TABLE
161 , p6_a6 out nocopy JTF_NUMBER_TABLE
162 , p6_a7 out nocopy JTF_DATE_TABLE
163 , p6_a8 out nocopy JTF_DATE_TABLE
164 , p6_a9 out nocopy JTF_DATE_TABLE
165 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
166 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
167 );
168 procedure delete_investor_revenue(p_api_version NUMBER
169 , p_init_msg_list VARCHAR2
170 , x_return_status out nocopy VARCHAR2
171 , x_msg_count out nocopy NUMBER
172 , x_msg_data out nocopy VARCHAR2
173 , p5_a0 JTF_NUMBER_TABLE
174 , p5_a1 JTF_NUMBER_TABLE
175 , p5_a2 JTF_VARCHAR2_TABLE_100
176 , p5_a3 JTF_NUMBER_TABLE
177 , p5_a4 JTF_NUMBER_TABLE
178 , p5_a5 JTF_NUMBER_TABLE
179 , p5_a6 JTF_NUMBER_TABLE
180 , p5_a7 JTF_DATE_TABLE
181 , p5_a8 JTF_DATE_TABLE
182 , p5_a9 JTF_DATE_TABLE
183 , p5_a10 JTF_VARCHAR2_TABLE_100
184 , p5_a11 JTF_VARCHAR2_TABLE_100
185 );
186 end okl_sec_investor_revenue_pvt_w;