APPS.OKL_SUBSIDY_PROCESS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_subsidy_process_pvt.asbv_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 7: , a4 JTF_NUMBER_TABLE

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
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 8: , a5 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
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

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
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

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
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 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
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_300

Line 13: , a10 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
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
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

Line 23: , a20 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
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_NUMBER_TABLE

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: );
33: procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 33: procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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
36: , a3 out nocopy JTF_VARCHAR2_TABLE_200
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 34: , a1 out nocopy 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
36: , a3 out nocopy JTF_VARCHAR2_TABLE_200
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

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
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE

Line 38: , a5 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
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_NUMBER_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

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
44: , a11 out nocopy JTF_NUMBER_TABLE

Line 41: , a8 out nocopy JTF_NUMBER_TABLE

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
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_NUMBER_TABLE

Line 42: , a9 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
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 43: , a10 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
44: , a11 out nocopy JTF_NUMBER_TABLE
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_300
47: , a14 out nocopy JTF_NUMBER_TABLE

Line 44: , a11 out nocopy JTF_NUMBER_TABLE

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
44: , a11 out nocopy JTF_NUMBER_TABLE
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

Line 45: , a12 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
44: , a11 out nocopy JTF_NUMBER_TABLE
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

Line 47: , a14 out nocopy JTF_NUMBER_TABLE

43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_NUMBER_TABLE
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

Line 48: , a15 out nocopy JTF_NUMBER_TABLE

44: , a11 out nocopy JTF_NUMBER_TABLE
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

Line 53: , a20 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
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a26 out nocopy JTF_NUMBER_TABLE

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: );
63:

Line 106: , p6_a0 out nocopy JTF_NUMBER_TABLE

102: , x_return_status out nocopy VARCHAR2
103: , x_msg_count out nocopy NUMBER
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

Line 107: , p6_a1 out nocopy JTF_NUMBER_TABLE

103: , x_msg_count out nocopy NUMBER
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

Line 110: , p6_a4 out nocopy JTF_NUMBER_TABLE

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
113: , p6_a7 out nocopy JTF_NUMBER_TABLE
114: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 111: , p6_a5 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
113: , p6_a7 out nocopy JTF_NUMBER_TABLE
114: , p6_a8 out nocopy JTF_NUMBER_TABLE
115: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 113: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 114: , p6_a8 out nocopy JTF_NUMBER_TABLE

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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
118: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 115: , p6_a9 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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
118: , p6_a12 out nocopy JTF_NUMBER_TABLE
119: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 116: , p6_a10 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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 117: , p6_a11 out nocopy JTF_NUMBER_TABLE

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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 118: , p6_a12 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
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 120: , p6_a14 out nocopy JTF_NUMBER_TABLE

116: , p6_a10 out nocopy JTF_NUMBER_TABLE
117: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 121: , p6_a15 out nocopy JTF_NUMBER_TABLE

117: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 126: , p6_a20 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
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

Line 132: , p6_a26 out nocopy JTF_NUMBER_TABLE

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: );
136: procedure get_contract_subsidy_amount(p_api_version NUMBER

Line 142: , p6_a0 out nocopy JTF_NUMBER_TABLE

138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
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

Line 143: , p6_a1 out nocopy JTF_NUMBER_TABLE

139: , x_msg_count out nocopy NUMBER
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

Line 146: , p6_a4 out nocopy JTF_NUMBER_TABLE

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
149: , p6_a7 out nocopy JTF_NUMBER_TABLE
150: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 147: , p6_a5 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
149: , p6_a7 out nocopy JTF_NUMBER_TABLE
150: , p6_a8 out nocopy JTF_NUMBER_TABLE
151: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 149: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 150: , p6_a8 out nocopy JTF_NUMBER_TABLE

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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
154: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 151: , p6_a9 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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
154: , p6_a12 out nocopy JTF_NUMBER_TABLE
155: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 152: , p6_a10 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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 153: , p6_a11 out nocopy JTF_NUMBER_TABLE

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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 154: , p6_a12 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
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 156: , p6_a14 out nocopy JTF_NUMBER_TABLE

152: , p6_a10 out nocopy JTF_NUMBER_TABLE
153: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 157: , p6_a15 out nocopy JTF_NUMBER_TABLE

153: , p6_a11 out nocopy JTF_NUMBER_TABLE
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

Line 162: , p6_a20 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
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

Line 168: , p6_a26 out nocopy JTF_NUMBER_TABLE

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: );
172: procedure get_partial_subsidy_amount(p_api_version NUMBER

Line 179: , p7_a0 out nocopy JTF_NUMBER_TABLE

175: , x_msg_count out nocopy NUMBER
176: , x_msg_data out nocopy VARCHAR2
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

Line 180: , p7_a1 out nocopy JTF_NUMBER_TABLE

176: , x_msg_data out nocopy VARCHAR2
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

Line 183: , p7_a4 out nocopy JTF_NUMBER_TABLE

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
186: , p7_a7 out nocopy JTF_NUMBER_TABLE
187: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 184: , p7_a5 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
186: , p7_a7 out nocopy JTF_NUMBER_TABLE
187: , p7_a8 out nocopy JTF_NUMBER_TABLE
188: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 186: , p7_a7 out nocopy JTF_NUMBER_TABLE

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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE

Line 187: , p7_a8 out nocopy JTF_NUMBER_TABLE

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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
191: , p7_a12 out nocopy JTF_NUMBER_TABLE

Line 188: , p7_a9 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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
191: , p7_a12 out nocopy JTF_NUMBER_TABLE
192: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 189: , p7_a10 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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
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

Line 190: , p7_a11 out nocopy JTF_NUMBER_TABLE

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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
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

Line 191: , p7_a12 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
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
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

Line 193: , p7_a14 out nocopy JTF_NUMBER_TABLE

189: , p7_a10 out nocopy JTF_NUMBER_TABLE
190: , p7_a11 out nocopy JTF_NUMBER_TABLE
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

Line 194: , p7_a15 out nocopy JTF_NUMBER_TABLE

190: , p7_a11 out nocopy JTF_NUMBER_TABLE
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

Line 199: , p7_a20 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
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

Line 205: , p7_a26 out nocopy JTF_NUMBER_TABLE

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: );
209: end okl_subsidy_process_pvt_w;