DBA Data[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;