APPS.OKL_LA_PAYMENTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_payments_pvt.pym_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 11: procedure rosetta_table_copy_out_p3(t okl_la_payments_pvt.pym_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 20: procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 21: , a1 JTF_NUMBER_TABLE

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

Line 22: , a2 JTF_NUMBER_TABLE

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

Line 24: procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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:

Line 25: , a1 out nocopy 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

Line 26: , a2 out nocopy 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

Line 38: , p10_a0 JTF_NUMBER_TABLE

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

Line 46: , p12_a0 out nocopy JTF_NUMBER_TABLE

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

Line 47: , p12_a1 out nocopy JTF_NUMBER_TABLE

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

Line 58: , p12_a12 out nocopy JTF_NUMBER_TABLE

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

Line 59: , p12_a13 out nocopy JTF_NUMBER_TABLE

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

Line 60: , p12_a14 out nocopy JTF_NUMBER_TABLE

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

Line 80: , p12_a34 out nocopy JTF_NUMBER_TABLE

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

Line 82: , p12_a36 out nocopy JTF_NUMBER_TABLE

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

Line 84: , p12_a38 out nocopy JTF_NUMBER_TABLE

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

Line 105: , p12_a59 out nocopy JTF_NUMBER_TABLE

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

Line 123: , p10_a0 out nocopy JTF_NUMBER_TABLE

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

Line 124: , p10_a1 out nocopy JTF_NUMBER_TABLE

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

Line 135: , p10_a12 out nocopy JTF_NUMBER_TABLE

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

Line 136: , p10_a13 out nocopy JTF_NUMBER_TABLE

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

Line 137: , p10_a14 out nocopy JTF_NUMBER_TABLE

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

Line 157: , p10_a34 out nocopy JTF_NUMBER_TABLE

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

Line 159: , p10_a36 out nocopy JTF_NUMBER_TABLE

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

Line 161: , p10_a38 out nocopy JTF_NUMBER_TABLE

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

Line 182: , p10_a59 out nocopy JTF_NUMBER_TABLE

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

Line 189: , p5_a0 JTF_NUMBER_TABLE

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;

Line 190: , p5_a1 JTF_NUMBER_TABLE

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;

Line 191: , p5_a2 JTF_NUMBER_TABLE

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;