[Home] [Help]
PACKAGE: APPS.OKL_LA_PAYMENTS_PVT_W
Source
1 package okl_la_payments_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEPYTS.pls 115.6 2003/11/15 01:28:58 ashariff noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy okl_la_payments_pvt.pym_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_500
5 , a2 JTF_VARCHAR2_TABLE_500
6 , a3 JTF_VARCHAR2_TABLE_500
7 , a4 JTF_VARCHAR2_TABLE_500
8 , a5 JTF_VARCHAR2_TABLE_500
9 , a6 JTF_VARCHAR2_TABLE_100
10 );
11 procedure rosetta_table_copy_out_p3(t okl_la_payments_pvt.pym_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
12 , a1 out nocopy JTF_VARCHAR2_TABLE_500
13 , a2 out nocopy JTF_VARCHAR2_TABLE_500
14 , a3 out nocopy JTF_VARCHAR2_TABLE_500
15 , a4 out nocopy JTF_VARCHAR2_TABLE_500
16 , a5 out nocopy JTF_VARCHAR2_TABLE_500
17 , a6 out nocopy JTF_VARCHAR2_TABLE_100
18 );
19
20 procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE
21 , a1 JTF_NUMBER_TABLE
22 , a2 JTF_NUMBER_TABLE
23 );
24 procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25 , a1 out nocopy JTF_NUMBER_TABLE
26 , a2 out nocopy JTF_NUMBER_TABLE
27 );
28
29 procedure process_payment(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 , p_chr_id NUMBER
35 , p_service_fee_id NUMBER
36 , p_asset_id NUMBER
37 , p_payment_id NUMBER
38 , p10_a0 JTF_NUMBER_TABLE
39 , p10_a1 JTF_VARCHAR2_TABLE_500
40 , p10_a2 JTF_VARCHAR2_TABLE_500
41 , p10_a3 JTF_VARCHAR2_TABLE_500
42 , p10_a4 JTF_VARCHAR2_TABLE_500
43 , p10_a5 JTF_VARCHAR2_TABLE_500
44 , p10_a6 JTF_VARCHAR2_TABLE_100
45 , p_update_type VARCHAR2
46 , p12_a0 out nocopy JTF_NUMBER_TABLE
47 , p12_a1 out nocopy JTF_NUMBER_TABLE
48 , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
49 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
50 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
51 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
52 , p12_a6 out nocopy JTF_VARCHAR2_TABLE_200
53 , p12_a7 out nocopy JTF_VARCHAR2_TABLE_200
54 , p12_a8 out nocopy JTF_VARCHAR2_TABLE_200
55 , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
56 , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
57 , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
58 , p12_a12 out nocopy JTF_NUMBER_TABLE
59 , p12_a13 out nocopy JTF_NUMBER_TABLE
60 , p12_a14 out nocopy JTF_NUMBER_TABLE
61 , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
62 , p12_a16 out nocopy JTF_VARCHAR2_TABLE_2000
63 , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
64 , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
65 , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
66 , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
67 , p12_a21 out nocopy JTF_VARCHAR2_TABLE_500
68 , p12_a22 out nocopy JTF_VARCHAR2_TABLE_500
69 , p12_a23 out nocopy JTF_VARCHAR2_TABLE_500
70 , p12_a24 out nocopy JTF_VARCHAR2_TABLE_500
71 , p12_a25 out nocopy JTF_VARCHAR2_TABLE_500
72 , p12_a26 out nocopy JTF_VARCHAR2_TABLE_500
73 , p12_a27 out nocopy JTF_VARCHAR2_TABLE_500
74 , p12_a28 out nocopy JTF_VARCHAR2_TABLE_500
75 , p12_a29 out nocopy JTF_VARCHAR2_TABLE_500
76 , p12_a30 out nocopy JTF_VARCHAR2_TABLE_500
77 , p12_a31 out nocopy JTF_VARCHAR2_TABLE_500
78 , p12_a32 out nocopy JTF_VARCHAR2_TABLE_500
79 , p12_a33 out nocopy JTF_VARCHAR2_TABLE_500
80 , p12_a34 out nocopy JTF_NUMBER_TABLE
81 , p12_a35 out nocopy JTF_DATE_TABLE
82 , p12_a36 out nocopy JTF_NUMBER_TABLE
83 , p12_a37 out nocopy JTF_DATE_TABLE
84 , p12_a38 out nocopy JTF_NUMBER_TABLE
85 , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
86 , p12_a40 out nocopy JTF_VARCHAR2_TABLE_500
87 , p12_a41 out nocopy JTF_VARCHAR2_TABLE_500
88 , p12_a42 out nocopy JTF_VARCHAR2_TABLE_500
89 , p12_a43 out nocopy JTF_VARCHAR2_TABLE_500
90 , p12_a44 out nocopy JTF_VARCHAR2_TABLE_500
91 , p12_a45 out nocopy JTF_VARCHAR2_TABLE_500
92 , p12_a46 out nocopy JTF_VARCHAR2_TABLE_500
93 , p12_a47 out nocopy JTF_VARCHAR2_TABLE_500
94 , p12_a48 out nocopy JTF_VARCHAR2_TABLE_500
95 , p12_a49 out nocopy JTF_VARCHAR2_TABLE_500
96 , p12_a50 out nocopy JTF_VARCHAR2_TABLE_500
97 , p12_a51 out nocopy JTF_VARCHAR2_TABLE_500
98 , p12_a52 out nocopy JTF_VARCHAR2_TABLE_500
99 , p12_a53 out nocopy JTF_VARCHAR2_TABLE_500
100 , p12_a54 out nocopy JTF_VARCHAR2_TABLE_500
101 , p12_a55 out nocopy JTF_VARCHAR2_TABLE_100
102 , p12_a56 out nocopy JTF_VARCHAR2_TABLE_100
103 , p12_a57 out nocopy JTF_VARCHAR2_TABLE_100
104 , p12_a58 out nocopy JTF_VARCHAR2_TABLE_100
105 , p12_a59 out nocopy JTF_NUMBER_TABLE
106 , p9_a0 VARCHAR2 := fnd_api.g_miss_char
107 , p9_a1 VARCHAR2 := fnd_api.g_miss_char
108 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
109 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
110 , p9_a4 VARCHAR2 := fnd_api.g_miss_char
111 , p9_a5 VARCHAR2 := fnd_api.g_miss_char
112 );
113 procedure process_payment(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 , p_chr_id NUMBER
119 , p_service_fee_id NUMBER
120 , p_asset_id NUMBER
121 , p_payment_id NUMBER
122 , p_update_type VARCHAR2
123 , p10_a0 out nocopy JTF_NUMBER_TABLE
124 , p10_a1 out nocopy JTF_NUMBER_TABLE
125 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
126 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
127 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
128 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
129 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
130 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
131 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_200
132 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
133 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
134 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
135 , p10_a12 out nocopy JTF_NUMBER_TABLE
136 , p10_a13 out nocopy JTF_NUMBER_TABLE
137 , p10_a14 out nocopy JTF_NUMBER_TABLE
138 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
139 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_2000
140 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
141 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
142 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
143 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
144 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
145 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
146 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
147 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
148 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
149 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_500
150 , p10_a27 out nocopy JTF_VARCHAR2_TABLE_500
151 , p10_a28 out nocopy JTF_VARCHAR2_TABLE_500
152 , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
153 , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
154 , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
155 , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
156 , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
157 , p10_a34 out nocopy JTF_NUMBER_TABLE
158 , p10_a35 out nocopy JTF_DATE_TABLE
159 , p10_a36 out nocopy JTF_NUMBER_TABLE
160 , p10_a37 out nocopy JTF_DATE_TABLE
161 , p10_a38 out nocopy JTF_NUMBER_TABLE
162 , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
163 , p10_a40 out nocopy JTF_VARCHAR2_TABLE_500
164 , p10_a41 out nocopy JTF_VARCHAR2_TABLE_500
165 , p10_a42 out nocopy JTF_VARCHAR2_TABLE_500
166 , p10_a43 out nocopy JTF_VARCHAR2_TABLE_500
167 , p10_a44 out nocopy JTF_VARCHAR2_TABLE_500
168 , p10_a45 out nocopy JTF_VARCHAR2_TABLE_500
169 , p10_a46 out nocopy JTF_VARCHAR2_TABLE_500
170 , p10_a47 out nocopy JTF_VARCHAR2_TABLE_500
171 , p10_a48 out nocopy JTF_VARCHAR2_TABLE_500
172 , p10_a49 out nocopy JTF_VARCHAR2_TABLE_500
173 , p10_a50 out nocopy JTF_VARCHAR2_TABLE_500
174 , p10_a51 out nocopy JTF_VARCHAR2_TABLE_500
175 , p10_a52 out nocopy JTF_VARCHAR2_TABLE_500
176 , p10_a53 out nocopy JTF_VARCHAR2_TABLE_500
177 , p10_a54 out nocopy JTF_VARCHAR2_TABLE_500
178 , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
179 , p10_a56 out nocopy JTF_VARCHAR2_TABLE_100
180 , p10_a57 out nocopy JTF_VARCHAR2_TABLE_100
181 , p10_a58 out nocopy JTF_VARCHAR2_TABLE_100
182 , p10_a59 out nocopy JTF_NUMBER_TABLE
183 );
184 procedure delete_payment(p_api_version NUMBER
185 , p_init_msg_list VARCHAR2
186 , x_return_status out nocopy VARCHAR2
187 , x_msg_count out nocopy NUMBER
188 , x_msg_data out nocopy VARCHAR2
189 , p5_a0 JTF_NUMBER_TABLE
190 , p5_a1 JTF_NUMBER_TABLE
191 , p5_a2 JTF_NUMBER_TABLE
192 );
193 end okl_la_payments_pvt_w;