APPS.OKL_PAM_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_pam_pvt_w as
2: /* $Header: OKLIPAMS.pls 120.0 2005/07/07 10:40:21 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_pam_pvt_w as
2: /* $Header: OKLIPAMS.pls 120.0 2005/07/07 10:40:21 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_pam_pvt_w as
2: /* $Header: OKLIPAMS.pls 120.0 2005/07/07 10:40:21 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 36: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_NUMBER_TABLE

Line 38: , a2 out nocopy JTF_NUMBER_TABLE

34: , a31 JTF_VARCHAR2_TABLE_2000
35: );
36: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a5 out nocopy JTF_NUMBER_TABLE

37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_DATE_TABLE
44: , a8 out nocopy JTF_DATE_TABLE
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a25 out nocopy JTF_NUMBER_TABLE

57: , a21 out nocopy JTF_VARCHAR2_TABLE_500
58: , a22 out nocopy JTF_VARCHAR2_TABLE_500
59: , a23 out nocopy JTF_VARCHAR2_TABLE_500
60: , a24 out nocopy JTF_VARCHAR2_TABLE_500
61: , a25 out nocopy JTF_NUMBER_TABLE
62: , a26 out nocopy JTF_DATE_TABLE
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE

Line 63: , a27 out nocopy JTF_NUMBER_TABLE

59: , a23 out nocopy JTF_VARCHAR2_TABLE_500
60: , a24 out nocopy JTF_VARCHAR2_TABLE_500
61: , a25 out nocopy JTF_NUMBER_TABLE
62: , a26 out nocopy JTF_DATE_TABLE
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_VARCHAR2_TABLE_300
67: , a31 out nocopy JTF_VARCHAR2_TABLE_2000

Line 65: , a29 out nocopy JTF_NUMBER_TABLE

61: , a25 out nocopy JTF_NUMBER_TABLE
62: , a26 out nocopy JTF_DATE_TABLE
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_VARCHAR2_TABLE_300
67: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
68: );
69:

Line 70: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE

66: , a30 out nocopy JTF_VARCHAR2_TABLE_300
67: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
68: );
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_300
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_VARCHAR2_TABLE_100

Line 72: , a2 JTF_NUMBER_TABLE

68: );
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_300
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_VARCHAR2_TABLE_100
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE

Line 73: , a3 JTF_NUMBER_TABLE

69:
70: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_300
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_VARCHAR2_TABLE_100
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100

Line 76: , a6 JTF_NUMBER_TABLE

72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_VARCHAR2_TABLE_100
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_DATE_TABLE
79: , a9 JTF_DATE_TABLE
80: , a10 JTF_VARCHAR2_TABLE_100

Line 96: , a26 JTF_NUMBER_TABLE

92: , a22 JTF_VARCHAR2_TABLE_500
93: , a23 JTF_VARCHAR2_TABLE_500
94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE

Line 98: , a28 JTF_NUMBER_TABLE

94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: );
102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 100: , a30 JTF_NUMBER_TABLE

96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_DATE_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: );
102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_VARCHAR2_TABLE_300
104: , a2 out nocopy JTF_NUMBER_TABLE

Line 102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE

98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: );
102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_VARCHAR2_TABLE_300
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , a2 out nocopy JTF_NUMBER_TABLE

100: , a30 JTF_NUMBER_TABLE
101: );
102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_VARCHAR2_TABLE_300
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_NUMBER_TABLE

Line 105: , a3 out nocopy JTF_NUMBER_TABLE

101: );
102: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_VARCHAR2_TABLE_300
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_NUMBER_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a6 out nocopy JTF_NUMBER_TABLE

104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_NUMBER_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_DATE_TABLE
111: , a9 out nocopy JTF_DATE_TABLE
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , a26 out nocopy JTF_NUMBER_TABLE

124: , a22 out nocopy JTF_VARCHAR2_TABLE_500
125: , a23 out nocopy JTF_VARCHAR2_TABLE_500
126: , a24 out nocopy JTF_VARCHAR2_TABLE_500
127: , a25 out nocopy JTF_VARCHAR2_TABLE_500
128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_DATE_TABLE
130: , a28 out nocopy JTF_NUMBER_TABLE
131: , a29 out nocopy JTF_DATE_TABLE
132: , a30 out nocopy JTF_NUMBER_TABLE

Line 130: , a28 out nocopy JTF_NUMBER_TABLE

126: , a24 out nocopy JTF_VARCHAR2_TABLE_500
127: , a25 out nocopy JTF_VARCHAR2_TABLE_500
128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_DATE_TABLE
130: , a28 out nocopy JTF_NUMBER_TABLE
131: , a29 out nocopy JTF_DATE_TABLE
132: , a30 out nocopy JTF_NUMBER_TABLE
133: );
134:

Line 132: , a30 out nocopy JTF_NUMBER_TABLE

128: , a26 out nocopy JTF_NUMBER_TABLE
129: , a27 out nocopy JTF_DATE_TABLE
130: , a28 out nocopy JTF_NUMBER_TABLE
131: , a29 out nocopy JTF_DATE_TABLE
132: , a30 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_2000

Line 135: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE

131: , a29 out nocopy JTF_DATE_TABLE
132: , a30 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_2000
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_100

Line 140: , a5 JTF_NUMBER_TABLE

136: , a1 JTF_VARCHAR2_TABLE_2000
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_100
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE

Line 142: , a7 JTF_NUMBER_TABLE

138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_100
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 144: , a9 JTF_NUMBER_TABLE

140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE

142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , a5 out nocopy JTF_NUMBER_TABLE

147: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_DATE_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_DATE_TABLE
155: , a9 out nocopy JTF_NUMBER_TABLE

Line 153: , a7 out nocopy JTF_NUMBER_TABLE

149: , a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_DATE_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_DATE_TABLE
155: , a9 out nocopy JTF_NUMBER_TABLE
156: );
157:

Line 155: , a9 out nocopy JTF_NUMBER_TABLE

151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_DATE_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_DATE_TABLE
155: , a9 out nocopy JTF_NUMBER_TABLE
156: );
157:
158: procedure insert_row(p_api_version NUMBER
159: , p_init_msg_list VARCHAR2

Line 233: , p5_a0 JTF_NUMBER_TABLE

229: , p_init_msg_list VARCHAR2
230: , x_return_status out nocopy VARCHAR2
231: , x_msg_count out nocopy NUMBER
232: , x_msg_data out nocopy VARCHAR2
233: , p5_a0 JTF_NUMBER_TABLE
234: , p5_a1 JTF_NUMBER_TABLE
235: , p5_a2 JTF_NUMBER_TABLE
236: , p5_a3 JTF_VARCHAR2_TABLE_100
237: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 234: , p5_a1 JTF_NUMBER_TABLE

230: , x_return_status out nocopy VARCHAR2
231: , x_msg_count out nocopy NUMBER
232: , x_msg_data out nocopy VARCHAR2
233: , p5_a0 JTF_NUMBER_TABLE
234: , p5_a1 JTF_NUMBER_TABLE
235: , p5_a2 JTF_NUMBER_TABLE
236: , p5_a3 JTF_VARCHAR2_TABLE_100
237: , p5_a4 JTF_VARCHAR2_TABLE_100
238: , p5_a5 JTF_NUMBER_TABLE

Line 235: , p5_a2 JTF_NUMBER_TABLE

231: , x_msg_count out nocopy NUMBER
232: , x_msg_data out nocopy VARCHAR2
233: , p5_a0 JTF_NUMBER_TABLE
234: , p5_a1 JTF_NUMBER_TABLE
235: , p5_a2 JTF_NUMBER_TABLE
236: , p5_a3 JTF_VARCHAR2_TABLE_100
237: , p5_a4 JTF_VARCHAR2_TABLE_100
238: , p5_a5 JTF_NUMBER_TABLE
239: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 238: , p5_a5 JTF_NUMBER_TABLE

234: , p5_a1 JTF_NUMBER_TABLE
235: , p5_a2 JTF_NUMBER_TABLE
236: , p5_a3 JTF_VARCHAR2_TABLE_100
237: , p5_a4 JTF_VARCHAR2_TABLE_100
238: , p5_a5 JTF_NUMBER_TABLE
239: , p5_a6 JTF_VARCHAR2_TABLE_100
240: , p5_a7 JTF_DATE_TABLE
241: , p5_a8 JTF_DATE_TABLE
242: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 258: , p5_a25 JTF_NUMBER_TABLE

254: , p5_a21 JTF_VARCHAR2_TABLE_500
255: , p5_a22 JTF_VARCHAR2_TABLE_500
256: , p5_a23 JTF_VARCHAR2_TABLE_500
257: , p5_a24 JTF_VARCHAR2_TABLE_500
258: , p5_a25 JTF_NUMBER_TABLE
259: , p5_a26 JTF_DATE_TABLE
260: , p5_a27 JTF_NUMBER_TABLE
261: , p5_a28 JTF_DATE_TABLE
262: , p5_a29 JTF_NUMBER_TABLE

Line 260: , p5_a27 JTF_NUMBER_TABLE

256: , p5_a23 JTF_VARCHAR2_TABLE_500
257: , p5_a24 JTF_VARCHAR2_TABLE_500
258: , p5_a25 JTF_NUMBER_TABLE
259: , p5_a26 JTF_DATE_TABLE
260: , p5_a27 JTF_NUMBER_TABLE
261: , p5_a28 JTF_DATE_TABLE
262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_VARCHAR2_TABLE_300
264: , p5_a31 JTF_VARCHAR2_TABLE_2000

Line 262: , p5_a29 JTF_NUMBER_TABLE

258: , p5_a25 JTF_NUMBER_TABLE
259: , p5_a26 JTF_DATE_TABLE
260: , p5_a27 JTF_NUMBER_TABLE
261: , p5_a28 JTF_DATE_TABLE
262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_VARCHAR2_TABLE_300
264: , p5_a31 JTF_VARCHAR2_TABLE_2000
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 265: , p6_a0 out nocopy JTF_NUMBER_TABLE

261: , p5_a28 JTF_DATE_TABLE
262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_VARCHAR2_TABLE_300
264: , p5_a31 JTF_VARCHAR2_TABLE_2000
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p6_a1 out nocopy JTF_NUMBER_TABLE

262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_VARCHAR2_TABLE_300
264: , p5_a31 JTF_VARCHAR2_TABLE_2000
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 267: , p6_a2 out nocopy JTF_NUMBER_TABLE

263: , p5_a30 JTF_VARCHAR2_TABLE_300
264: , p5_a31 JTF_VARCHAR2_TABLE_2000
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a5 out nocopy JTF_NUMBER_TABLE
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 270: , p6_a5 out nocopy JTF_NUMBER_TABLE

266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a5 out nocopy JTF_NUMBER_TABLE
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a7 out nocopy JTF_DATE_TABLE
273: , p6_a8 out nocopy JTF_DATE_TABLE
274: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 290: , p6_a25 out nocopy JTF_NUMBER_TABLE

286: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
288: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a25 out nocopy JTF_NUMBER_TABLE
291: , p6_a26 out nocopy JTF_DATE_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_DATE_TABLE
294: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 292: , p6_a27 out nocopy JTF_NUMBER_TABLE

288: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a25 out nocopy JTF_NUMBER_TABLE
291: , p6_a26 out nocopy JTF_DATE_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_DATE_TABLE
294: , p6_a29 out nocopy JTF_NUMBER_TABLE
295: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
296: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000

Line 294: , p6_a29 out nocopy JTF_NUMBER_TABLE

290: , p6_a25 out nocopy JTF_NUMBER_TABLE
291: , p6_a26 out nocopy JTF_DATE_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_DATE_TABLE
294: , p6_a29 out nocopy JTF_NUMBER_TABLE
295: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
296: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
297: );
298: procedure update_row(p_api_version NUMBER

Line 373: , p5_a0 JTF_NUMBER_TABLE

369: , p_init_msg_list VARCHAR2
370: , x_return_status out nocopy VARCHAR2
371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_NUMBER_TABLE
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 374: , p5_a1 JTF_NUMBER_TABLE

370: , x_return_status out nocopy VARCHAR2
371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_NUMBER_TABLE
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_VARCHAR2_TABLE_100
378: , p5_a5 JTF_NUMBER_TABLE

Line 375: , p5_a2 JTF_NUMBER_TABLE

371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_NUMBER_TABLE
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_VARCHAR2_TABLE_100
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 378: , p5_a5 JTF_NUMBER_TABLE

374: , p5_a1 JTF_NUMBER_TABLE
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_VARCHAR2_TABLE_100
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_VARCHAR2_TABLE_100
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_DATE_TABLE
382: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 398: , p5_a25 JTF_NUMBER_TABLE

394: , p5_a21 JTF_VARCHAR2_TABLE_500
395: , p5_a22 JTF_VARCHAR2_TABLE_500
396: , p5_a23 JTF_VARCHAR2_TABLE_500
397: , p5_a24 JTF_VARCHAR2_TABLE_500
398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_DATE_TABLE
400: , p5_a27 JTF_NUMBER_TABLE
401: , p5_a28 JTF_DATE_TABLE
402: , p5_a29 JTF_NUMBER_TABLE

Line 400: , p5_a27 JTF_NUMBER_TABLE

396: , p5_a23 JTF_VARCHAR2_TABLE_500
397: , p5_a24 JTF_VARCHAR2_TABLE_500
398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_DATE_TABLE
400: , p5_a27 JTF_NUMBER_TABLE
401: , p5_a28 JTF_DATE_TABLE
402: , p5_a29 JTF_NUMBER_TABLE
403: , p5_a30 JTF_VARCHAR2_TABLE_300
404: , p5_a31 JTF_VARCHAR2_TABLE_2000

Line 402: , p5_a29 JTF_NUMBER_TABLE

398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_DATE_TABLE
400: , p5_a27 JTF_NUMBER_TABLE
401: , p5_a28 JTF_DATE_TABLE
402: , p5_a29 JTF_NUMBER_TABLE
403: , p5_a30 JTF_VARCHAR2_TABLE_300
404: , p5_a31 JTF_VARCHAR2_TABLE_2000
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 405: , p6_a0 out nocopy JTF_NUMBER_TABLE

401: , p5_a28 JTF_DATE_TABLE
402: , p5_a29 JTF_NUMBER_TABLE
403: , p5_a30 JTF_VARCHAR2_TABLE_300
404: , p5_a31 JTF_VARCHAR2_TABLE_2000
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 406: , p6_a1 out nocopy JTF_NUMBER_TABLE

402: , p5_a29 JTF_NUMBER_TABLE
403: , p5_a30 JTF_VARCHAR2_TABLE_300
404: , p5_a31 JTF_VARCHAR2_TABLE_2000
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 407: , p6_a2 out nocopy JTF_NUMBER_TABLE

403: , p5_a30 JTF_VARCHAR2_TABLE_300
404: , p5_a31 JTF_VARCHAR2_TABLE_2000
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_NUMBER_TABLE
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 410: , p6_a5 out nocopy JTF_NUMBER_TABLE

406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_NUMBER_TABLE
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a7 out nocopy JTF_DATE_TABLE
413: , p6_a8 out nocopy JTF_DATE_TABLE
414: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 430: , p6_a25 out nocopy JTF_NUMBER_TABLE

426: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
427: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
428: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
429: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a25 out nocopy JTF_NUMBER_TABLE
431: , p6_a26 out nocopy JTF_DATE_TABLE
432: , p6_a27 out nocopy JTF_NUMBER_TABLE
433: , p6_a28 out nocopy JTF_DATE_TABLE
434: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 432: , p6_a27 out nocopy JTF_NUMBER_TABLE

428: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
429: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a25 out nocopy JTF_NUMBER_TABLE
431: , p6_a26 out nocopy JTF_DATE_TABLE
432: , p6_a27 out nocopy JTF_NUMBER_TABLE
433: , p6_a28 out nocopy JTF_DATE_TABLE
434: , p6_a29 out nocopy JTF_NUMBER_TABLE
435: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
436: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000

Line 434: , p6_a29 out nocopy JTF_NUMBER_TABLE

430: , p6_a25 out nocopy JTF_NUMBER_TABLE
431: , p6_a26 out nocopy JTF_DATE_TABLE
432: , p6_a27 out nocopy JTF_NUMBER_TABLE
433: , p6_a28 out nocopy JTF_DATE_TABLE
434: , p6_a29 out nocopy JTF_NUMBER_TABLE
435: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
436: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
437: );
438: procedure delete_row(p_api_version NUMBER

Line 481: , p5_a0 JTF_NUMBER_TABLE

477: , p_init_msg_list VARCHAR2
478: , x_return_status out nocopy VARCHAR2
479: , x_msg_count out nocopy NUMBER
480: , x_msg_data out nocopy VARCHAR2
481: , p5_a0 JTF_NUMBER_TABLE
482: , p5_a1 JTF_NUMBER_TABLE
483: , p5_a2 JTF_NUMBER_TABLE
484: , p5_a3 JTF_VARCHAR2_TABLE_100
485: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 482: , p5_a1 JTF_NUMBER_TABLE

478: , x_return_status out nocopy VARCHAR2
479: , x_msg_count out nocopy NUMBER
480: , x_msg_data out nocopy VARCHAR2
481: , p5_a0 JTF_NUMBER_TABLE
482: , p5_a1 JTF_NUMBER_TABLE
483: , p5_a2 JTF_NUMBER_TABLE
484: , p5_a3 JTF_VARCHAR2_TABLE_100
485: , p5_a4 JTF_VARCHAR2_TABLE_100
486: , p5_a5 JTF_NUMBER_TABLE

Line 483: , p5_a2 JTF_NUMBER_TABLE

479: , x_msg_count out nocopy NUMBER
480: , x_msg_data out nocopy VARCHAR2
481: , p5_a0 JTF_NUMBER_TABLE
482: , p5_a1 JTF_NUMBER_TABLE
483: , p5_a2 JTF_NUMBER_TABLE
484: , p5_a3 JTF_VARCHAR2_TABLE_100
485: , p5_a4 JTF_VARCHAR2_TABLE_100
486: , p5_a5 JTF_NUMBER_TABLE
487: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 486: , p5_a5 JTF_NUMBER_TABLE

482: , p5_a1 JTF_NUMBER_TABLE
483: , p5_a2 JTF_NUMBER_TABLE
484: , p5_a3 JTF_VARCHAR2_TABLE_100
485: , p5_a4 JTF_VARCHAR2_TABLE_100
486: , p5_a5 JTF_NUMBER_TABLE
487: , p5_a6 JTF_VARCHAR2_TABLE_100
488: , p5_a7 JTF_DATE_TABLE
489: , p5_a8 JTF_DATE_TABLE
490: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 506: , p5_a25 JTF_NUMBER_TABLE

502: , p5_a21 JTF_VARCHAR2_TABLE_500
503: , p5_a22 JTF_VARCHAR2_TABLE_500
504: , p5_a23 JTF_VARCHAR2_TABLE_500
505: , p5_a24 JTF_VARCHAR2_TABLE_500
506: , p5_a25 JTF_NUMBER_TABLE
507: , p5_a26 JTF_DATE_TABLE
508: , p5_a27 JTF_NUMBER_TABLE
509: , p5_a28 JTF_DATE_TABLE
510: , p5_a29 JTF_NUMBER_TABLE

Line 508: , p5_a27 JTF_NUMBER_TABLE

504: , p5_a23 JTF_VARCHAR2_TABLE_500
505: , p5_a24 JTF_VARCHAR2_TABLE_500
506: , p5_a25 JTF_NUMBER_TABLE
507: , p5_a26 JTF_DATE_TABLE
508: , p5_a27 JTF_NUMBER_TABLE
509: , p5_a28 JTF_DATE_TABLE
510: , p5_a29 JTF_NUMBER_TABLE
511: , p5_a30 JTF_VARCHAR2_TABLE_300
512: , p5_a31 JTF_VARCHAR2_TABLE_2000

Line 510: , p5_a29 JTF_NUMBER_TABLE

506: , p5_a25 JTF_NUMBER_TABLE
507: , p5_a26 JTF_DATE_TABLE
508: , p5_a27 JTF_NUMBER_TABLE
509: , p5_a28 JTF_DATE_TABLE
510: , p5_a29 JTF_NUMBER_TABLE
511: , p5_a30 JTF_VARCHAR2_TABLE_300
512: , p5_a31 JTF_VARCHAR2_TABLE_2000
513: );
514: end okl_pam_pvt_w;