APPS.OKL_SIP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_sip_pvt_w as
2: /* $Header: OKLISIPS.pls 120.1 2005/10/30 04:01:01 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_sip_pvt_w as
2: /* $Header: OKLISIPS.pls 120.1 2005/10/30 04:01:01 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE

Line 38: , a35 JTF_NUMBER_TABLE

34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 40: , a37 JTF_NUMBER_TABLE

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a1 out nocopy JTF_NUMBER_TABLE

39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 54: , a12 out nocopy JTF_NUMBER_TABLE

50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE

Line 55: , a13 out nocopy JTF_NUMBER_TABLE

51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , a14 out nocopy JTF_NUMBER_TABLE

52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
60: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 57: , a15 out nocopy JTF_NUMBER_TABLE

53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
60: , a18 out nocopy JTF_VARCHAR2_TABLE_500
61: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 75: , a33 out nocopy JTF_NUMBER_TABLE

71: , a29 out nocopy JTF_VARCHAR2_TABLE_500
72: , a30 out nocopy JTF_VARCHAR2_TABLE_500
73: , a31 out nocopy JTF_VARCHAR2_TABLE_500
74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE

Line 77: , a35 out nocopy JTF_NUMBER_TABLE

73: , a31 out nocopy JTF_VARCHAR2_TABLE_500
74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:

Line 79: , a37 out nocopy JTF_NUMBER_TABLE

75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200

Line 82: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE

78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_2000
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_100

Line 88: , a6 JTF_NUMBER_TABLE

84: , a2 JTF_VARCHAR2_TABLE_2000
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_100
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE

Line 90: , a8 JTF_NUMBER_TABLE

86: , a4 JTF_VARCHAR2_TABLE_100
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 92: , a10 JTF_NUMBER_TABLE

88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 100: , a6 out nocopy JTF_NUMBER_TABLE

96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: , a10 out nocopy JTF_NUMBER_TABLE

Line 102: , a8 out nocopy JTF_NUMBER_TABLE

98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: , a10 out nocopy JTF_NUMBER_TABLE
105: );
106:

Line 104: , a10 out nocopy JTF_NUMBER_TABLE

100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: , a10 out nocopy JTF_NUMBER_TABLE
105: );
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE

Line 107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE

103: , a9 out nocopy JTF_DATE_TABLE
104: , a10 out nocopy JTF_NUMBER_TABLE
105: );
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE

Line 108: , a1 JTF_NUMBER_TABLE

104: , a10 out nocopy JTF_NUMBER_TABLE
105: );
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE

Line 116: , a9 JTF_NUMBER_TABLE

112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
120: , a13 JTF_DATE_TABLE

Line 117: , a10 JTF_NUMBER_TABLE

113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
120: , a13 JTF_DATE_TABLE
121: , a14 JTF_VARCHAR2_TABLE_100

Line 118: , a11 JTF_NUMBER_TABLE

114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
120: , a13 JTF_DATE_TABLE
121: , a14 JTF_VARCHAR2_TABLE_100
122: , a15 JTF_VARCHAR2_TABLE_500

Line 119: , a12 JTF_NUMBER_TABLE

115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
120: , a13 JTF_DATE_TABLE
121: , a14 JTF_VARCHAR2_TABLE_100
122: , a15 JTF_VARCHAR2_TABLE_500
123: , a16 JTF_VARCHAR2_TABLE_500

Line 137: , a30 JTF_NUMBER_TABLE

133: , a26 JTF_VARCHAR2_TABLE_500
134: , a27 JTF_VARCHAR2_TABLE_500
135: , a28 JTF_VARCHAR2_TABLE_500
136: , a29 JTF_VARCHAR2_TABLE_500
137: , a30 JTF_NUMBER_TABLE
138: , a31 JTF_DATE_TABLE
139: , a32 JTF_NUMBER_TABLE
140: , a33 JTF_DATE_TABLE
141: , a34 JTF_NUMBER_TABLE

Line 139: , a32 JTF_NUMBER_TABLE

135: , a28 JTF_VARCHAR2_TABLE_500
136: , a29 JTF_VARCHAR2_TABLE_500
137: , a30 JTF_NUMBER_TABLE
138: , a31 JTF_DATE_TABLE
139: , a32 JTF_NUMBER_TABLE
140: , a33 JTF_DATE_TABLE
141: , a34 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 141: , a34 JTF_NUMBER_TABLE

137: , a30 JTF_NUMBER_TABLE
138: , a31 JTF_DATE_TABLE
139: , a32 JTF_NUMBER_TABLE
140: , a33 JTF_DATE_TABLE
141: , a34 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

139: , a32 JTF_NUMBER_TABLE
140: , a33 JTF_DATE_TABLE
141: , a34 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE

Line 144: , a1 out nocopy JTF_NUMBER_TABLE

140: , a33 JTF_DATE_TABLE
141: , a34 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE

Line 152: , a9 out nocopy JTF_NUMBER_TABLE

148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
156: , a13 out nocopy JTF_DATE_TABLE

Line 153: , a10 out nocopy JTF_NUMBER_TABLE

149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
156: , a13 out nocopy JTF_DATE_TABLE
157: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a11 out nocopy JTF_NUMBER_TABLE

150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
156: , a13 out nocopy JTF_DATE_TABLE
157: , a14 out nocopy JTF_VARCHAR2_TABLE_100
158: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 155: , a12 out nocopy JTF_NUMBER_TABLE

151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
156: , a13 out nocopy JTF_DATE_TABLE
157: , a14 out nocopy JTF_VARCHAR2_TABLE_100
158: , a15 out nocopy JTF_VARCHAR2_TABLE_500
159: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 173: , a30 out nocopy JTF_NUMBER_TABLE

169: , a26 out nocopy JTF_VARCHAR2_TABLE_500
170: , a27 out nocopy JTF_VARCHAR2_TABLE_500
171: , a28 out nocopy JTF_VARCHAR2_TABLE_500
172: , a29 out nocopy JTF_VARCHAR2_TABLE_500
173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_NUMBER_TABLE
176: , a33 out nocopy JTF_DATE_TABLE
177: , a34 out nocopy JTF_NUMBER_TABLE

Line 175: , a32 out nocopy JTF_NUMBER_TABLE

171: , a28 out nocopy JTF_VARCHAR2_TABLE_500
172: , a29 out nocopy JTF_VARCHAR2_TABLE_500
173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_NUMBER_TABLE
176: , a33 out nocopy JTF_DATE_TABLE
177: , a34 out nocopy JTF_NUMBER_TABLE
178: );
179:

Line 177: , a34 out nocopy JTF_NUMBER_TABLE

173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_NUMBER_TABLE
176: , a33 out nocopy JTF_DATE_TABLE
177: , a34 out nocopy JTF_NUMBER_TABLE
178: );
179:
180: procedure insert_row(p_api_version NUMBER
181: , p_init_msg_list VARCHAR2

Line 267: , p5_a0 JTF_NUMBER_TABLE

263: , p_init_msg_list VARCHAR2
264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_100
271: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a1 JTF_NUMBER_TABLE

264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_100
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 279: , p5_a12 JTF_NUMBER_TABLE

275: , p5_a8 JTF_DATE_TABLE
276: , p5_a9 JTF_VARCHAR2_TABLE_100
277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
283: , p5_a16 JTF_DATE_TABLE

Line 280: , p5_a13 JTF_NUMBER_TABLE

276: , p5_a9 JTF_VARCHAR2_TABLE_100
277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
283: , p5_a16 JTF_DATE_TABLE
284: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 281: , p5_a14 JTF_NUMBER_TABLE

277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
283: , p5_a16 JTF_DATE_TABLE
284: , p5_a17 JTF_VARCHAR2_TABLE_100
285: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 282: , p5_a15 JTF_NUMBER_TABLE

278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
283: , p5_a16 JTF_DATE_TABLE
284: , p5_a17 JTF_VARCHAR2_TABLE_100
285: , p5_a18 JTF_VARCHAR2_TABLE_500
286: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 300: , p5_a33 JTF_NUMBER_TABLE

296: , p5_a29 JTF_VARCHAR2_TABLE_500
297: , p5_a30 JTF_VARCHAR2_TABLE_500
298: , p5_a31 JTF_VARCHAR2_TABLE_500
299: , p5_a32 JTF_VARCHAR2_TABLE_500
300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE

Line 302: , p5_a35 JTF_NUMBER_TABLE

298: , p5_a31 JTF_VARCHAR2_TABLE_500
299: , p5_a32 JTF_VARCHAR2_TABLE_500
300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 304: , p5_a37 JTF_NUMBER_TABLE

300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p6_a0 out nocopy JTF_NUMBER_TABLE

301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p6_a1 out nocopy JTF_NUMBER_TABLE

302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 317: , p6_a12 out nocopy JTF_NUMBER_TABLE

313: , p6_a8 out nocopy JTF_DATE_TABLE
314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
321: , p6_a16 out nocopy JTF_DATE_TABLE

Line 318: , p6_a13 out nocopy JTF_NUMBER_TABLE

314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
321: , p6_a16 out nocopy JTF_DATE_TABLE
322: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p6_a14 out nocopy JTF_NUMBER_TABLE

315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
321: , p6_a16 out nocopy JTF_DATE_TABLE
322: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
323: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 320: , p6_a15 out nocopy JTF_NUMBER_TABLE

316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
321: , p6_a16 out nocopy JTF_DATE_TABLE
322: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
323: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 338: , p6_a33 out nocopy JTF_NUMBER_TABLE

334: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
335: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
337: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 340: , p6_a35 out nocopy JTF_NUMBER_TABLE

336: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
337: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER

Line 342: , p6_a37 out nocopy JTF_NUMBER_TABLE

338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2

Line 393: , p5_a0 JTF_NUMBER_TABLE

389: , p_init_msg_list VARCHAR2
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_100
397: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 394: , p5_a1 JTF_NUMBER_TABLE

390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_100
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 405: , p5_a12 JTF_NUMBER_TABLE

401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_VARCHAR2_TABLE_100
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
409: , p5_a16 JTF_DATE_TABLE

Line 406: , p5_a13 JTF_NUMBER_TABLE

402: , p5_a9 JTF_VARCHAR2_TABLE_100
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
409: , p5_a16 JTF_DATE_TABLE
410: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 407: , p5_a14 JTF_NUMBER_TABLE

403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
409: , p5_a16 JTF_DATE_TABLE
410: , p5_a17 JTF_VARCHAR2_TABLE_100
411: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 408: , p5_a15 JTF_NUMBER_TABLE

404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
409: , p5_a16 JTF_DATE_TABLE
410: , p5_a17 JTF_VARCHAR2_TABLE_100
411: , p5_a18 JTF_VARCHAR2_TABLE_500
412: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 426: , p5_a33 JTF_NUMBER_TABLE

422: , p5_a29 JTF_VARCHAR2_TABLE_500
423: , p5_a30 JTF_VARCHAR2_TABLE_500
424: , p5_a31 JTF_VARCHAR2_TABLE_500
425: , p5_a32 JTF_VARCHAR2_TABLE_500
426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE

Line 428: , p5_a35 JTF_NUMBER_TABLE

424: , p5_a31 JTF_VARCHAR2_TABLE_500
425: , p5_a32 JTF_VARCHAR2_TABLE_500
426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE
431: );
432: procedure update_row(p_api_version NUMBER

Line 430: , p5_a37 JTF_NUMBER_TABLE

426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE
431: );
432: procedure update_row(p_api_version NUMBER
433: , p_init_msg_list VARCHAR2
434: , x_return_status out nocopy VARCHAR2

Line 519: , p5_a0 JTF_NUMBER_TABLE

515: , p_init_msg_list VARCHAR2
516: , x_return_status out nocopy VARCHAR2
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_100
523: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 520: , p5_a1 JTF_NUMBER_TABLE

516: , x_return_status out nocopy VARCHAR2
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_100
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 531: , p5_a12 JTF_NUMBER_TABLE

527: , p5_a8 JTF_DATE_TABLE
528: , p5_a9 JTF_VARCHAR2_TABLE_100
529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
535: , p5_a16 JTF_DATE_TABLE

Line 532: , p5_a13 JTF_NUMBER_TABLE

528: , p5_a9 JTF_VARCHAR2_TABLE_100
529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
535: , p5_a16 JTF_DATE_TABLE
536: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 533: , p5_a14 JTF_NUMBER_TABLE

529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
535: , p5_a16 JTF_DATE_TABLE
536: , p5_a17 JTF_VARCHAR2_TABLE_100
537: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 534: , p5_a15 JTF_NUMBER_TABLE

530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
535: , p5_a16 JTF_DATE_TABLE
536: , p5_a17 JTF_VARCHAR2_TABLE_100
537: , p5_a18 JTF_VARCHAR2_TABLE_500
538: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 552: , p5_a33 JTF_NUMBER_TABLE

548: , p5_a29 JTF_VARCHAR2_TABLE_500
549: , p5_a30 JTF_VARCHAR2_TABLE_500
550: , p5_a31 JTF_VARCHAR2_TABLE_500
551: , p5_a32 JTF_VARCHAR2_TABLE_500
552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE

Line 554: , p5_a35 JTF_NUMBER_TABLE

550: , p5_a31 JTF_VARCHAR2_TABLE_500
551: , p5_a32 JTF_VARCHAR2_TABLE_500
552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 556: , p5_a37 JTF_NUMBER_TABLE

552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 557: , p6_a0 out nocopy JTF_NUMBER_TABLE

553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 558: , p6_a1 out nocopy JTF_NUMBER_TABLE

554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 569: , p6_a12 out nocopy JTF_NUMBER_TABLE

565: , p6_a8 out nocopy JTF_DATE_TABLE
566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
573: , p6_a16 out nocopy JTF_DATE_TABLE

Line 570: , p6_a13 out nocopy JTF_NUMBER_TABLE

566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
573: , p6_a16 out nocopy JTF_DATE_TABLE
574: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 571: , p6_a14 out nocopy JTF_NUMBER_TABLE

567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
573: , p6_a16 out nocopy JTF_DATE_TABLE
574: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 572: , p6_a15 out nocopy JTF_NUMBER_TABLE

568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
573: , p6_a16 out nocopy JTF_DATE_TABLE
574: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
576: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 590: , p6_a33 out nocopy JTF_NUMBER_TABLE

586: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 592: , p6_a35 out nocopy JTF_NUMBER_TABLE

588: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE
595: );
596: procedure delete_row(p_api_version NUMBER

Line 594: , p6_a37 out nocopy JTF_NUMBER_TABLE

590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE
595: );
596: procedure delete_row(p_api_version NUMBER
597: , p_init_msg_list VARCHAR2
598: , x_return_status out nocopy VARCHAR2

Line 645: , p5_a0 JTF_NUMBER_TABLE

641: , p_init_msg_list VARCHAR2
642: , x_return_status out nocopy VARCHAR2
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_100
649: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 646: , p5_a1 JTF_NUMBER_TABLE

642: , x_return_status out nocopy VARCHAR2
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_100
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 657: , p5_a12 JTF_NUMBER_TABLE

653: , p5_a8 JTF_DATE_TABLE
654: , p5_a9 JTF_VARCHAR2_TABLE_100
655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
661: , p5_a16 JTF_DATE_TABLE

Line 658: , p5_a13 JTF_NUMBER_TABLE

654: , p5_a9 JTF_VARCHAR2_TABLE_100
655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
661: , p5_a16 JTF_DATE_TABLE
662: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 659: , p5_a14 JTF_NUMBER_TABLE

655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
661: , p5_a16 JTF_DATE_TABLE
662: , p5_a17 JTF_VARCHAR2_TABLE_100
663: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 660: , p5_a15 JTF_NUMBER_TABLE

656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
661: , p5_a16 JTF_DATE_TABLE
662: , p5_a17 JTF_VARCHAR2_TABLE_100
663: , p5_a18 JTF_VARCHAR2_TABLE_500
664: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 678: , p5_a33 JTF_NUMBER_TABLE

674: , p5_a29 JTF_VARCHAR2_TABLE_500
675: , p5_a30 JTF_VARCHAR2_TABLE_500
676: , p5_a31 JTF_VARCHAR2_TABLE_500
677: , p5_a32 JTF_VARCHAR2_TABLE_500
678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE

Line 680: , p5_a35 JTF_NUMBER_TABLE

676: , p5_a31 JTF_VARCHAR2_TABLE_500
677: , p5_a32 JTF_VARCHAR2_TABLE_500
678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE
683: );
684: procedure validate_row(p_api_version NUMBER

Line 682: , p5_a37 JTF_NUMBER_TABLE

678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE
683: );
684: procedure validate_row(p_api_version NUMBER
685: , p_init_msg_list VARCHAR2
686: , x_return_status out nocopy VARCHAR2

Line 733: , p5_a0 JTF_NUMBER_TABLE

729: , p_init_msg_list VARCHAR2
730: , x_return_status out nocopy VARCHAR2
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_100
737: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 734: , p5_a1 JTF_NUMBER_TABLE

730: , x_return_status out nocopy VARCHAR2
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_100
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 745: , p5_a12 JTF_NUMBER_TABLE

741: , p5_a8 JTF_DATE_TABLE
742: , p5_a9 JTF_VARCHAR2_TABLE_100
743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
749: , p5_a16 JTF_DATE_TABLE

Line 746: , p5_a13 JTF_NUMBER_TABLE

742: , p5_a9 JTF_VARCHAR2_TABLE_100
743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
749: , p5_a16 JTF_DATE_TABLE
750: , p5_a17 JTF_VARCHAR2_TABLE_100

Line 747: , p5_a14 JTF_NUMBER_TABLE

743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
749: , p5_a16 JTF_DATE_TABLE
750: , p5_a17 JTF_VARCHAR2_TABLE_100
751: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 748: , p5_a15 JTF_NUMBER_TABLE

744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
749: , p5_a16 JTF_DATE_TABLE
750: , p5_a17 JTF_VARCHAR2_TABLE_100
751: , p5_a18 JTF_VARCHAR2_TABLE_500
752: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 766: , p5_a33 JTF_NUMBER_TABLE

762: , p5_a29 JTF_VARCHAR2_TABLE_500
763: , p5_a30 JTF_VARCHAR2_TABLE_500
764: , p5_a31 JTF_VARCHAR2_TABLE_500
765: , p5_a32 JTF_VARCHAR2_TABLE_500
766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE

Line 768: , p5_a35 JTF_NUMBER_TABLE

764: , p5_a31 JTF_VARCHAR2_TABLE_500
765: , p5_a32 JTF_VARCHAR2_TABLE_500
766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE
771: );
772: end okl_sip_pvt_w;

Line 770: , p5_a37 JTF_NUMBER_TABLE

766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE
771: );
772: end okl_sip_pvt_w;