APPS.OKL_SUBSIDY_PROCESS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_subsidy_process_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLESBPS.pls 115.0 2003/09/19 22:57:36 avsingh noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_subsidy_process_pvt.asbv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100

Line 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_DATE_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE

Line 26: , a23 JTF_VARCHAR2_TABLE_100

22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100

Line 27: , a24 JTF_VARCHAR2_TABLE_100

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100

Line 28: , a25 JTF_VARCHAR2_TABLE_100

24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: );

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

31: , a28 JTF_VARCHAR2_TABLE_100
32: );
33: procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_200
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_200
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE
43: , a10 out nocopy JTF_NUMBER_TABLE

Line 49: , a16 out nocopy JTF_VARCHAR2_TABLE_100

45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_300
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_DATE_TABLE
52: , a19 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE

Line 50: , a17 out nocopy JTF_VARCHAR2_TABLE_100

46: , a13 out nocopy JTF_VARCHAR2_TABLE_300
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_DATE_TABLE
52: , a19 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a21 out nocopy JTF_VARCHAR2_TABLE_100

50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_DATE_TABLE
52: , a19 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a22 out nocopy JTF_VARCHAR2_TABLE_100

51: , a18 out nocopy JTF_DATE_TABLE
52: , a19 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE

Line 56: , a23 out nocopy JTF_VARCHAR2_TABLE_100

52: , a19 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a24 out nocopy JTF_VARCHAR2_TABLE_100

53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_100
61: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a25 out nocopy JTF_VARCHAR2_TABLE_100

54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_100
61: , a28 out nocopy JTF_VARCHAR2_TABLE_100
62: );

Line 60: , a27 out nocopy JTF_VARCHAR2_TABLE_100

56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_100
61: , a28 out nocopy JTF_VARCHAR2_TABLE_100
62: );
63:
64: procedure get_subsidy_amount(p_api_version NUMBER

Line 61: , a28 out nocopy JTF_VARCHAR2_TABLE_100

57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
58: , a25 out nocopy JTF_VARCHAR2_TABLE_100
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_100
61: , a28 out nocopy JTF_VARCHAR2_TABLE_100
62: );
63:
64: procedure get_subsidy_amount(p_api_version NUMBER
65: , p_init_msg_list VARCHAR2

Line 108: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

104: , x_msg_data out nocopy VARCHAR2
105: , p_asset_cle_id NUMBER
106: , p6_a0 out nocopy JTF_NUMBER_TABLE
107: , p6_a1 out nocopy JTF_NUMBER_TABLE
108: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
110: , p6_a4 out nocopy JTF_NUMBER_TABLE
111: , p6_a5 out nocopy JTF_NUMBER_TABLE
112: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

108: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
110: , p6_a4 out nocopy JTF_NUMBER_TABLE
111: , p6_a5 out nocopy JTF_NUMBER_TABLE
112: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , p6_a7 out nocopy JTF_NUMBER_TABLE
114: , p6_a8 out nocopy JTF_NUMBER_TABLE
115: , p6_a9 out nocopy JTF_NUMBER_TABLE
116: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 122: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

118: , p6_a12 out nocopy JTF_NUMBER_TABLE
119: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
120: , p6_a14 out nocopy JTF_NUMBER_TABLE
121: , p6_a15 out nocopy JTF_NUMBER_TABLE
122: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a18 out nocopy JTF_DATE_TABLE
125: , p6_a19 out nocopy JTF_DATE_TABLE
126: , p6_a20 out nocopy JTF_NUMBER_TABLE

Line 123: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

119: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
120: , p6_a14 out nocopy JTF_NUMBER_TABLE
121: , p6_a15 out nocopy JTF_NUMBER_TABLE
122: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a18 out nocopy JTF_DATE_TABLE
125: , p6_a19 out nocopy JTF_DATE_TABLE
126: , p6_a20 out nocopy JTF_NUMBER_TABLE
127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

123: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a18 out nocopy JTF_DATE_TABLE
125: , p6_a19 out nocopy JTF_DATE_TABLE
126: , p6_a20 out nocopy JTF_NUMBER_TABLE
127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

124: , p6_a18 out nocopy JTF_DATE_TABLE
125: , p6_a19 out nocopy JTF_DATE_TABLE
126: , p6_a20 out nocopy JTF_NUMBER_TABLE
127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

125: , p6_a19 out nocopy JTF_DATE_TABLE
126: , p6_a20 out nocopy JTF_NUMBER_TABLE
127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE
133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100

126: , p6_a20 out nocopy JTF_NUMBER_TABLE
127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE
133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

127: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE
133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
135: );

Line 133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

129: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE
133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
135: );
136: procedure get_contract_subsidy_amount(p_api_version NUMBER
137: , p_init_msg_list VARCHAR2

Line 134: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

130: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a26 out nocopy JTF_NUMBER_TABLE
133: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
135: );
136: procedure get_contract_subsidy_amount(p_api_version NUMBER
137: , p_init_msg_list VARCHAR2
138: , x_return_status out nocopy VARCHAR2

Line 144: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

140: , x_msg_data out nocopy VARCHAR2
141: , p_chr_id NUMBER
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE
144: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
146: , p6_a4 out nocopy JTF_NUMBER_TABLE
147: , p6_a5 out nocopy JTF_NUMBER_TABLE
148: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

144: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
146: , p6_a4 out nocopy JTF_NUMBER_TABLE
147: , p6_a5 out nocopy JTF_NUMBER_TABLE
148: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
149: , p6_a7 out nocopy JTF_NUMBER_TABLE
150: , p6_a8 out nocopy JTF_NUMBER_TABLE
151: , p6_a9 out nocopy JTF_NUMBER_TABLE
152: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 158: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

154: , p6_a12 out nocopy JTF_NUMBER_TABLE
155: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
156: , p6_a14 out nocopy JTF_NUMBER_TABLE
157: , p6_a15 out nocopy JTF_NUMBER_TABLE
158: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a18 out nocopy JTF_DATE_TABLE
161: , p6_a19 out nocopy JTF_DATE_TABLE
162: , p6_a20 out nocopy JTF_NUMBER_TABLE

Line 159: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

155: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
156: , p6_a14 out nocopy JTF_NUMBER_TABLE
157: , p6_a15 out nocopy JTF_NUMBER_TABLE
158: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a18 out nocopy JTF_DATE_TABLE
161: , p6_a19 out nocopy JTF_DATE_TABLE
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

159: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a18 out nocopy JTF_DATE_TABLE
161: , p6_a19 out nocopy JTF_DATE_TABLE
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

160: , p6_a18 out nocopy JTF_DATE_TABLE
161: , p6_a19 out nocopy JTF_DATE_TABLE
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

161: , p6_a19 out nocopy JTF_DATE_TABLE
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE
169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100

162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE
169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

163: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE
169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
171: );

Line 169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

165: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE
169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
171: );
172: procedure get_partial_subsidy_amount(p_api_version NUMBER
173: , p_init_msg_list VARCHAR2

Line 170: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

166: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a26 out nocopy JTF_NUMBER_TABLE
169: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
171: );
172: procedure get_partial_subsidy_amount(p_api_version NUMBER
173: , p_init_msg_list VARCHAR2
174: , x_return_status out nocopy VARCHAR2

Line 181: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

177: , p_asset_cle_id NUMBER
178: , p_req_fund_amount NUMBER
179: , p7_a0 out nocopy JTF_NUMBER_TABLE
180: , p7_a1 out nocopy JTF_NUMBER_TABLE
181: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a4 out nocopy JTF_NUMBER_TABLE
184: , p7_a5 out nocopy JTF_NUMBER_TABLE
185: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

181: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a4 out nocopy JTF_NUMBER_TABLE
184: , p7_a5 out nocopy JTF_NUMBER_TABLE
185: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
186: , p7_a7 out nocopy JTF_NUMBER_TABLE
187: , p7_a8 out nocopy JTF_NUMBER_TABLE
188: , p7_a9 out nocopy JTF_NUMBER_TABLE
189: , p7_a10 out nocopy JTF_NUMBER_TABLE

Line 195: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

191: , p7_a12 out nocopy JTF_NUMBER_TABLE
192: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_300
193: , p7_a14 out nocopy JTF_NUMBER_TABLE
194: , p7_a15 out nocopy JTF_NUMBER_TABLE
195: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
196: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a18 out nocopy JTF_DATE_TABLE
198: , p7_a19 out nocopy JTF_DATE_TABLE
199: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 196: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

192: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_300
193: , p7_a14 out nocopy JTF_NUMBER_TABLE
194: , p7_a15 out nocopy JTF_NUMBER_TABLE
195: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
196: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a18 out nocopy JTF_DATE_TABLE
198: , p7_a19 out nocopy JTF_DATE_TABLE
199: , p7_a20 out nocopy JTF_NUMBER_TABLE
200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100

196: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a18 out nocopy JTF_DATE_TABLE
198: , p7_a19 out nocopy JTF_DATE_TABLE
199: , p7_a20 out nocopy JTF_NUMBER_TABLE
200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

197: , p7_a18 out nocopy JTF_DATE_TABLE
198: , p7_a19 out nocopy JTF_DATE_TABLE
199: , p7_a20 out nocopy JTF_NUMBER_TABLE
200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE

Line 202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100

198: , p7_a19 out nocopy JTF_DATE_TABLE
199: , p7_a20 out nocopy JTF_NUMBER_TABLE
200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE
206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

199: , p7_a20 out nocopy JTF_NUMBER_TABLE
200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE
206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
207: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100

200: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE
206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
207: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
208: );

Line 206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100

202: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE
206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
207: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
208: );
209: end okl_subsidy_process_pvt_w;

Line 207: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

203: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a26 out nocopy JTF_NUMBER_TABLE
206: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
207: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
208: );
209: end okl_subsidy_process_pvt_w;