DBA Data[Home] [Help]

APPS.OKL_SID_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_sid_pvt_w as
2: /* $Header: OKLISIDS.pls 120.1 2005/07/14 12:00:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_sid_pvt_w as
2: /* $Header: OKLISIDS.pls 120.1 2005/07/14 12:00:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_sid_pvt_w as
2: /* $Header: OKLISIDS.pls 120.1 2005/07/14 12:00:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLISIDS.pls 120.1 2005/07/14 12:00:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sid_pvt.sidv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500

Line 29: , a26 JTF_NUMBER_TABLE

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

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 33: , a30 JTF_NUMBER_TABLE

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE

Line 35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a1 out nocopy JTF_NUMBER_TABLE

32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_DATE_TABLE

Line 37: , a2 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_DATE_TABLE
41: , a6 out nocopy JTF_DATE_TABLE

Line 38: , a3 out nocopy JTF_NUMBER_TABLE

34: );
35: procedure rosetta_table_copy_out_p2(t okl_sid_pvt.sidv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_DATE_TABLE
41: , a6 out nocopy JTF_DATE_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE

Line 42: , a7 out nocopy JTF_NUMBER_TABLE

38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_DATE_TABLE
41: , a6 out nocopy JTF_DATE_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 61: , a26 out nocopy JTF_NUMBER_TABLE

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

Line 63: , a28 out nocopy JTF_NUMBER_TABLE

59: , a24 out nocopy JTF_VARCHAR2_TABLE_500
60: , a25 out nocopy JTF_VARCHAR2_TABLE_500
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:

Line 65: , a30 out nocopy JTF_NUMBER_TABLE

61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE

64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_NUMBER_TABLE
72: , a4 JTF_VARCHAR2_TABLE_100

Line 69: , a1 JTF_NUMBER_TABLE

65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_NUMBER_TABLE
72: , a4 JTF_VARCHAR2_TABLE_100
73: , a5 JTF_DATE_TABLE

Line 70: , a2 JTF_NUMBER_TABLE

66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_NUMBER_TABLE
72: , a4 JTF_VARCHAR2_TABLE_100
73: , a5 JTF_DATE_TABLE
74: , a6 JTF_DATE_TABLE

Line 71: , a3 JTF_NUMBER_TABLE

67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sid_pvt.sid_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_NUMBER_TABLE
72: , a4 JTF_VARCHAR2_TABLE_100
73: , a5 JTF_DATE_TABLE
74: , a6 JTF_DATE_TABLE
75: , a7 JTF_NUMBER_TABLE

Line 75: , a7 JTF_NUMBER_TABLE

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

Line 94: , a26 JTF_NUMBER_TABLE

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

Line 96: , a28 JTF_NUMBER_TABLE

92: , a24 JTF_VARCHAR2_TABLE_500
93: , a25 JTF_VARCHAR2_TABLE_500
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 98: , a30 JTF_NUMBER_TABLE

94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a1 out nocopy JTF_NUMBER_TABLE

97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a5 out nocopy JTF_DATE_TABLE

Line 102: , a2 out nocopy JTF_NUMBER_TABLE

98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a5 out nocopy JTF_DATE_TABLE
106: , a6 out nocopy JTF_DATE_TABLE

Line 103: , a3 out nocopy JTF_NUMBER_TABLE

99: );
100: procedure rosetta_table_copy_out_p5(t okl_sid_pvt.sid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a5 out nocopy JTF_DATE_TABLE
106: , a6 out nocopy JTF_DATE_TABLE
107: , a7 out nocopy JTF_NUMBER_TABLE

Line 107: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 126: , a26 out nocopy JTF_NUMBER_TABLE

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

Line 128: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 130: , a30 out nocopy JTF_NUMBER_TABLE

126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE

Line 133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE

129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE

Line 134: , a1 JTF_NUMBER_TABLE

130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100

Line 135: , a2 JTF_NUMBER_TABLE

131: );
132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_DATE_TABLE

Line 136: , a3 JTF_NUMBER_TABLE

132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_DATE_TABLE
140: , a7 JTF_DATE_TABLE

Line 137: , a4 JTF_NUMBER_TABLE

133: procedure rosetta_table_copy_in_p8(t out nocopy okl_sid_pvt.okl_sidh_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_DATE_TABLE
140: , a7 JTF_DATE_TABLE
141: , a8 JTF_NUMBER_TABLE

Line 141: , a8 JTF_NUMBER_TABLE

137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_DATE_TABLE
140: , a7 JTF_DATE_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100
143: , a10 JTF_VARCHAR2_TABLE_100
144: , a11 JTF_VARCHAR2_TABLE_100
145: , a12 JTF_VARCHAR2_TABLE_500

Line 160: , a27 JTF_NUMBER_TABLE

156: , a23 JTF_VARCHAR2_TABLE_500
157: , a24 JTF_VARCHAR2_TABLE_500
158: , a25 JTF_VARCHAR2_TABLE_500
159: , a26 JTF_VARCHAR2_TABLE_500
160: , a27 JTF_NUMBER_TABLE
161: , a28 JTF_DATE_TABLE
162: , a29 JTF_NUMBER_TABLE
163: , a30 JTF_DATE_TABLE
164: , a31 JTF_NUMBER_TABLE

Line 162: , a29 JTF_NUMBER_TABLE

158: , a25 JTF_VARCHAR2_TABLE_500
159: , a26 JTF_VARCHAR2_TABLE_500
160: , a27 JTF_NUMBER_TABLE
161: , a28 JTF_DATE_TABLE
162: , a29 JTF_NUMBER_TABLE
163: , a30 JTF_DATE_TABLE
164: , a31 JTF_NUMBER_TABLE
165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 164: , a31 JTF_NUMBER_TABLE

160: , a27 JTF_NUMBER_TABLE
161: , a28 JTF_DATE_TABLE
162: , a29 JTF_NUMBER_TABLE
163: , a30 JTF_DATE_TABLE
164: , a31 JTF_NUMBER_TABLE
165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE

Line 166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

162: , a29 JTF_NUMBER_TABLE
163: , a30 JTF_DATE_TABLE
164: , a31 JTF_NUMBER_TABLE
165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE
169: , a3 out nocopy JTF_NUMBER_TABLE
170: , a4 out nocopy JTF_NUMBER_TABLE

Line 167: , a1 out nocopy JTF_NUMBER_TABLE

163: , a30 JTF_DATE_TABLE
164: , a31 JTF_NUMBER_TABLE
165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE
169: , a3 out nocopy JTF_NUMBER_TABLE
170: , a4 out nocopy JTF_NUMBER_TABLE
171: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 168: , a2 out nocopy JTF_NUMBER_TABLE

164: , a31 JTF_NUMBER_TABLE
165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE
169: , a3 out nocopy JTF_NUMBER_TABLE
170: , a4 out nocopy JTF_NUMBER_TABLE
171: , a5 out nocopy JTF_VARCHAR2_TABLE_100
172: , a6 out nocopy JTF_DATE_TABLE

Line 169: , a3 out nocopy JTF_NUMBER_TABLE

165: );
166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE
169: , a3 out nocopy JTF_NUMBER_TABLE
170: , a4 out nocopy JTF_NUMBER_TABLE
171: , a5 out nocopy JTF_VARCHAR2_TABLE_100
172: , a6 out nocopy JTF_DATE_TABLE
173: , a7 out nocopy JTF_DATE_TABLE

Line 170: , a4 out nocopy JTF_NUMBER_TABLE

166: procedure rosetta_table_copy_out_p8(t okl_sid_pvt.okl_sidh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
167: , a1 out nocopy JTF_NUMBER_TABLE
168: , a2 out nocopy JTF_NUMBER_TABLE
169: , a3 out nocopy JTF_NUMBER_TABLE
170: , a4 out nocopy JTF_NUMBER_TABLE
171: , a5 out nocopy JTF_VARCHAR2_TABLE_100
172: , a6 out nocopy JTF_DATE_TABLE
173: , a7 out nocopy JTF_DATE_TABLE
174: , a8 out nocopy JTF_NUMBER_TABLE

Line 174: , a8 out nocopy JTF_NUMBER_TABLE

170: , a4 out nocopy JTF_NUMBER_TABLE
171: , a5 out nocopy JTF_VARCHAR2_TABLE_100
172: , a6 out nocopy JTF_DATE_TABLE
173: , a7 out nocopy JTF_DATE_TABLE
174: , a8 out nocopy JTF_NUMBER_TABLE
175: , a9 out nocopy JTF_VARCHAR2_TABLE_100
176: , a10 out nocopy JTF_VARCHAR2_TABLE_100
177: , a11 out nocopy JTF_VARCHAR2_TABLE_100
178: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 193: , a27 out nocopy JTF_NUMBER_TABLE

189: , a23 out nocopy JTF_VARCHAR2_TABLE_500
190: , a24 out nocopy JTF_VARCHAR2_TABLE_500
191: , a25 out nocopy JTF_VARCHAR2_TABLE_500
192: , a26 out nocopy JTF_VARCHAR2_TABLE_500
193: , a27 out nocopy JTF_NUMBER_TABLE
194: , a28 out nocopy JTF_DATE_TABLE
195: , a29 out nocopy JTF_NUMBER_TABLE
196: , a30 out nocopy JTF_DATE_TABLE
197: , a31 out nocopy JTF_NUMBER_TABLE

Line 195: , a29 out nocopy JTF_NUMBER_TABLE

191: , a25 out nocopy JTF_VARCHAR2_TABLE_500
192: , a26 out nocopy JTF_VARCHAR2_TABLE_500
193: , a27 out nocopy JTF_NUMBER_TABLE
194: , a28 out nocopy JTF_DATE_TABLE
195: , a29 out nocopy JTF_NUMBER_TABLE
196: , a30 out nocopy JTF_DATE_TABLE
197: , a31 out nocopy JTF_NUMBER_TABLE
198: );
199:

Line 197: , a31 out nocopy JTF_NUMBER_TABLE

193: , a27 out nocopy JTF_NUMBER_TABLE
194: , a28 out nocopy JTF_DATE_TABLE
195: , a29 out nocopy JTF_NUMBER_TABLE
196: , a30 out nocopy JTF_DATE_TABLE
197: , a31 out nocopy JTF_NUMBER_TABLE
198: );
199:
200: procedure insert_row(p_api_version NUMBER
201: , p_init_msg_list VARCHAR2

Line 273: , p5_a0 JTF_NUMBER_TABLE

269: , p_init_msg_list VARCHAR2
270: , x_return_status out nocopy VARCHAR2
271: , x_msg_count out nocopy NUMBER
272: , x_msg_data out nocopy VARCHAR2
273: , p5_a0 JTF_NUMBER_TABLE
274: , p5_a1 JTF_NUMBER_TABLE
275: , p5_a2 JTF_NUMBER_TABLE
276: , p5_a3 JTF_NUMBER_TABLE
277: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 274: , p5_a1 JTF_NUMBER_TABLE

270: , x_return_status out nocopy VARCHAR2
271: , x_msg_count out nocopy NUMBER
272: , x_msg_data out nocopy VARCHAR2
273: , p5_a0 JTF_NUMBER_TABLE
274: , p5_a1 JTF_NUMBER_TABLE
275: , p5_a2 JTF_NUMBER_TABLE
276: , p5_a3 JTF_NUMBER_TABLE
277: , p5_a4 JTF_VARCHAR2_TABLE_100
278: , p5_a5 JTF_DATE_TABLE

Line 275: , p5_a2 JTF_NUMBER_TABLE

271: , x_msg_count out nocopy NUMBER
272: , x_msg_data out nocopy VARCHAR2
273: , p5_a0 JTF_NUMBER_TABLE
274: , p5_a1 JTF_NUMBER_TABLE
275: , p5_a2 JTF_NUMBER_TABLE
276: , p5_a3 JTF_NUMBER_TABLE
277: , p5_a4 JTF_VARCHAR2_TABLE_100
278: , p5_a5 JTF_DATE_TABLE
279: , p5_a6 JTF_DATE_TABLE

Line 276: , p5_a3 JTF_NUMBER_TABLE

272: , x_msg_data out nocopy VARCHAR2
273: , p5_a0 JTF_NUMBER_TABLE
274: , p5_a1 JTF_NUMBER_TABLE
275: , p5_a2 JTF_NUMBER_TABLE
276: , p5_a3 JTF_NUMBER_TABLE
277: , p5_a4 JTF_VARCHAR2_TABLE_100
278: , p5_a5 JTF_DATE_TABLE
279: , p5_a6 JTF_DATE_TABLE
280: , p5_a7 JTF_NUMBER_TABLE

Line 280: , p5_a7 JTF_NUMBER_TABLE

276: , p5_a3 JTF_NUMBER_TABLE
277: , p5_a4 JTF_VARCHAR2_TABLE_100
278: , p5_a5 JTF_DATE_TABLE
279: , p5_a6 JTF_DATE_TABLE
280: , p5_a7 JTF_NUMBER_TABLE
281: , p5_a8 JTF_VARCHAR2_TABLE_100
282: , p5_a9 JTF_VARCHAR2_TABLE_100
283: , p5_a10 JTF_VARCHAR2_TABLE_100
284: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 299: , p5_a26 JTF_NUMBER_TABLE

295: , p5_a22 JTF_VARCHAR2_TABLE_500
296: , p5_a23 JTF_VARCHAR2_TABLE_500
297: , p5_a24 JTF_VARCHAR2_TABLE_500
298: , p5_a25 JTF_VARCHAR2_TABLE_500
299: , p5_a26 JTF_NUMBER_TABLE
300: , p5_a27 JTF_DATE_TABLE
301: , p5_a28 JTF_NUMBER_TABLE
302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE

Line 301: , p5_a28 JTF_NUMBER_TABLE

297: , p5_a24 JTF_VARCHAR2_TABLE_500
298: , p5_a25 JTF_VARCHAR2_TABLE_500
299: , p5_a26 JTF_NUMBER_TABLE
300: , p5_a27 JTF_DATE_TABLE
301: , p5_a28 JTF_NUMBER_TABLE
302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 303: , p5_a30 JTF_NUMBER_TABLE

299: , p5_a26 JTF_NUMBER_TABLE
300: , p5_a27 JTF_DATE_TABLE
301: , p5_a28 JTF_NUMBER_TABLE
302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 304: , p6_a0 out nocopy JTF_NUMBER_TABLE

300: , p5_a27 JTF_DATE_TABLE
301: , p5_a28 JTF_NUMBER_TABLE
302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p6_a1 out nocopy JTF_NUMBER_TABLE

301: , p5_a28 JTF_NUMBER_TABLE
302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a5 out nocopy JTF_DATE_TABLE

Line 306: , p6_a2 out nocopy JTF_NUMBER_TABLE

302: , p5_a29 JTF_DATE_TABLE
303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a5 out nocopy JTF_DATE_TABLE
310: , p6_a6 out nocopy JTF_DATE_TABLE

Line 307: , p6_a3 out nocopy JTF_NUMBER_TABLE

303: , p5_a30 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a5 out nocopy JTF_DATE_TABLE
310: , p6_a6 out nocopy JTF_DATE_TABLE
311: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 311: , p6_a7 out nocopy JTF_NUMBER_TABLE

307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a5 out nocopy JTF_DATE_TABLE
310: , p6_a6 out nocopy JTF_DATE_TABLE
311: , p6_a7 out nocopy JTF_NUMBER_TABLE
312: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 330: , p6_a26 out nocopy JTF_NUMBER_TABLE

326: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
327: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
328: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
329: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
330: , p6_a26 out nocopy JTF_NUMBER_TABLE
331: , p6_a27 out nocopy JTF_DATE_TABLE
332: , p6_a28 out nocopy JTF_NUMBER_TABLE
333: , p6_a29 out nocopy JTF_DATE_TABLE
334: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 332: , p6_a28 out nocopy JTF_NUMBER_TABLE

328: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
329: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
330: , p6_a26 out nocopy JTF_NUMBER_TABLE
331: , p6_a27 out nocopy JTF_DATE_TABLE
332: , p6_a28 out nocopy JTF_NUMBER_TABLE
333: , p6_a29 out nocopy JTF_DATE_TABLE
334: , p6_a30 out nocopy JTF_NUMBER_TABLE
335: );
336: procedure lock_row(p_api_version NUMBER

Line 334: , p6_a30 out nocopy JTF_NUMBER_TABLE

330: , p6_a26 out nocopy JTF_NUMBER_TABLE
331: , p6_a27 out nocopy JTF_DATE_TABLE
332: , p6_a28 out nocopy JTF_NUMBER_TABLE
333: , p6_a29 out nocopy JTF_DATE_TABLE
334: , p6_a30 out nocopy JTF_NUMBER_TABLE
335: );
336: procedure lock_row(p_api_version NUMBER
337: , p_init_msg_list VARCHAR2
338: , x_return_status out nocopy VARCHAR2

Line 378: , p5_a0 JTF_NUMBER_TABLE

374: , p_init_msg_list VARCHAR2
375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_NUMBER_TABLE
382: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 379: , p5_a1 JTF_NUMBER_TABLE

375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_NUMBER_TABLE
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_DATE_TABLE

Line 380: , p5_a2 JTF_NUMBER_TABLE

376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_NUMBER_TABLE
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_DATE_TABLE
384: , p5_a6 JTF_DATE_TABLE

Line 381: , p5_a3 JTF_NUMBER_TABLE

377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_NUMBER_TABLE
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_DATE_TABLE
384: , p5_a6 JTF_DATE_TABLE
385: , p5_a7 JTF_NUMBER_TABLE

Line 385: , p5_a7 JTF_NUMBER_TABLE

381: , p5_a3 JTF_NUMBER_TABLE
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_DATE_TABLE
384: , p5_a6 JTF_DATE_TABLE
385: , p5_a7 JTF_NUMBER_TABLE
386: , p5_a8 JTF_VARCHAR2_TABLE_100
387: , p5_a9 JTF_VARCHAR2_TABLE_100
388: , p5_a10 JTF_VARCHAR2_TABLE_100
389: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 404: , p5_a26 JTF_NUMBER_TABLE

400: , p5_a22 JTF_VARCHAR2_TABLE_500
401: , p5_a23 JTF_VARCHAR2_TABLE_500
402: , p5_a24 JTF_VARCHAR2_TABLE_500
403: , p5_a25 JTF_VARCHAR2_TABLE_500
404: , p5_a26 JTF_NUMBER_TABLE
405: , p5_a27 JTF_DATE_TABLE
406: , p5_a28 JTF_NUMBER_TABLE
407: , p5_a29 JTF_DATE_TABLE
408: , p5_a30 JTF_NUMBER_TABLE

Line 406: , p5_a28 JTF_NUMBER_TABLE

402: , p5_a24 JTF_VARCHAR2_TABLE_500
403: , p5_a25 JTF_VARCHAR2_TABLE_500
404: , p5_a26 JTF_NUMBER_TABLE
405: , p5_a27 JTF_DATE_TABLE
406: , p5_a28 JTF_NUMBER_TABLE
407: , p5_a29 JTF_DATE_TABLE
408: , p5_a30 JTF_NUMBER_TABLE
409: );
410: procedure update_row(p_api_version NUMBER

Line 408: , p5_a30 JTF_NUMBER_TABLE

404: , p5_a26 JTF_NUMBER_TABLE
405: , p5_a27 JTF_DATE_TABLE
406: , p5_a28 JTF_NUMBER_TABLE
407: , p5_a29 JTF_DATE_TABLE
408: , p5_a30 JTF_NUMBER_TABLE
409: );
410: procedure update_row(p_api_version NUMBER
411: , p_init_msg_list VARCHAR2
412: , x_return_status out nocopy VARCHAR2

Line 483: , p5_a0 JTF_NUMBER_TABLE

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

Line 484: , p5_a1 JTF_NUMBER_TABLE

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

Line 485: , p5_a2 JTF_NUMBER_TABLE

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

Line 486: , p5_a3 JTF_NUMBER_TABLE

482: , x_msg_data out nocopy VARCHAR2
483: , p5_a0 JTF_NUMBER_TABLE
484: , p5_a1 JTF_NUMBER_TABLE
485: , p5_a2 JTF_NUMBER_TABLE
486: , p5_a3 JTF_NUMBER_TABLE
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_DATE_TABLE
489: , p5_a6 JTF_DATE_TABLE
490: , p5_a7 JTF_NUMBER_TABLE

Line 490: , p5_a7 JTF_NUMBER_TABLE

486: , p5_a3 JTF_NUMBER_TABLE
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_DATE_TABLE
489: , p5_a6 JTF_DATE_TABLE
490: , p5_a7 JTF_NUMBER_TABLE
491: , p5_a8 JTF_VARCHAR2_TABLE_100
492: , p5_a9 JTF_VARCHAR2_TABLE_100
493: , p5_a10 JTF_VARCHAR2_TABLE_100
494: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 509: , p5_a26 JTF_NUMBER_TABLE

505: , p5_a22 JTF_VARCHAR2_TABLE_500
506: , p5_a23 JTF_VARCHAR2_TABLE_500
507: , p5_a24 JTF_VARCHAR2_TABLE_500
508: , p5_a25 JTF_VARCHAR2_TABLE_500
509: , p5_a26 JTF_NUMBER_TABLE
510: , p5_a27 JTF_DATE_TABLE
511: , p5_a28 JTF_NUMBER_TABLE
512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE

Line 511: , p5_a28 JTF_NUMBER_TABLE

507: , p5_a24 JTF_VARCHAR2_TABLE_500
508: , p5_a25 JTF_VARCHAR2_TABLE_500
509: , p5_a26 JTF_NUMBER_TABLE
510: , p5_a27 JTF_DATE_TABLE
511: , p5_a28 JTF_NUMBER_TABLE
512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 513: , p5_a30 JTF_NUMBER_TABLE

509: , p5_a26 JTF_NUMBER_TABLE
510: , p5_a27 JTF_DATE_TABLE
511: , p5_a28 JTF_NUMBER_TABLE
512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE
516: , p6_a2 out nocopy JTF_NUMBER_TABLE
517: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 514: , p6_a0 out nocopy JTF_NUMBER_TABLE

510: , p5_a27 JTF_DATE_TABLE
511: , p5_a28 JTF_NUMBER_TABLE
512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE
516: , p6_a2 out nocopy JTF_NUMBER_TABLE
517: , p6_a3 out nocopy JTF_NUMBER_TABLE
518: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 515: , p6_a1 out nocopy JTF_NUMBER_TABLE

511: , p5_a28 JTF_NUMBER_TABLE
512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE
516: , p6_a2 out nocopy JTF_NUMBER_TABLE
517: , p6_a3 out nocopy JTF_NUMBER_TABLE
518: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a5 out nocopy JTF_DATE_TABLE

Line 516: , p6_a2 out nocopy JTF_NUMBER_TABLE

512: , p5_a29 JTF_DATE_TABLE
513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE
516: , p6_a2 out nocopy JTF_NUMBER_TABLE
517: , p6_a3 out nocopy JTF_NUMBER_TABLE
518: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a5 out nocopy JTF_DATE_TABLE
520: , p6_a6 out nocopy JTF_DATE_TABLE

Line 517: , p6_a3 out nocopy JTF_NUMBER_TABLE

513: , p5_a30 JTF_NUMBER_TABLE
514: , p6_a0 out nocopy JTF_NUMBER_TABLE
515: , p6_a1 out nocopy JTF_NUMBER_TABLE
516: , p6_a2 out nocopy JTF_NUMBER_TABLE
517: , p6_a3 out nocopy JTF_NUMBER_TABLE
518: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a5 out nocopy JTF_DATE_TABLE
520: , p6_a6 out nocopy JTF_DATE_TABLE
521: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 521: , p6_a7 out nocopy JTF_NUMBER_TABLE

517: , p6_a3 out nocopy JTF_NUMBER_TABLE
518: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a5 out nocopy JTF_DATE_TABLE
520: , p6_a6 out nocopy JTF_DATE_TABLE
521: , p6_a7 out nocopy JTF_NUMBER_TABLE
522: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
523: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 540: , p6_a26 out nocopy JTF_NUMBER_TABLE

536: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
537: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
538: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
539: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
540: , p6_a26 out nocopy JTF_NUMBER_TABLE
541: , p6_a27 out nocopy JTF_DATE_TABLE
542: , p6_a28 out nocopy JTF_NUMBER_TABLE
543: , p6_a29 out nocopy JTF_DATE_TABLE
544: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 542: , p6_a28 out nocopy JTF_NUMBER_TABLE

538: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
539: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
540: , p6_a26 out nocopy JTF_NUMBER_TABLE
541: , p6_a27 out nocopy JTF_DATE_TABLE
542: , p6_a28 out nocopy JTF_NUMBER_TABLE
543: , p6_a29 out nocopy JTF_DATE_TABLE
544: , p6_a30 out nocopy JTF_NUMBER_TABLE
545: );
546: procedure delete_row(p_api_version NUMBER

Line 544: , p6_a30 out nocopy JTF_NUMBER_TABLE

540: , p6_a26 out nocopy JTF_NUMBER_TABLE
541: , p6_a27 out nocopy JTF_DATE_TABLE
542: , p6_a28 out nocopy JTF_NUMBER_TABLE
543: , p6_a29 out nocopy JTF_DATE_TABLE
544: , p6_a30 out nocopy JTF_NUMBER_TABLE
545: );
546: procedure delete_row(p_api_version NUMBER
547: , p_init_msg_list VARCHAR2
548: , x_return_status out nocopy VARCHAR2

Line 588: , p5_a0 JTF_NUMBER_TABLE

584: , p_init_msg_list VARCHAR2
585: , x_return_status out nocopy VARCHAR2
586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
588: , p5_a0 JTF_NUMBER_TABLE
589: , p5_a1 JTF_NUMBER_TABLE
590: , p5_a2 JTF_NUMBER_TABLE
591: , p5_a3 JTF_NUMBER_TABLE
592: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 589: , p5_a1 JTF_NUMBER_TABLE

585: , x_return_status out nocopy VARCHAR2
586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
588: , p5_a0 JTF_NUMBER_TABLE
589: , p5_a1 JTF_NUMBER_TABLE
590: , p5_a2 JTF_NUMBER_TABLE
591: , p5_a3 JTF_NUMBER_TABLE
592: , p5_a4 JTF_VARCHAR2_TABLE_100
593: , p5_a5 JTF_DATE_TABLE

Line 590: , p5_a2 JTF_NUMBER_TABLE

586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
588: , p5_a0 JTF_NUMBER_TABLE
589: , p5_a1 JTF_NUMBER_TABLE
590: , p5_a2 JTF_NUMBER_TABLE
591: , p5_a3 JTF_NUMBER_TABLE
592: , p5_a4 JTF_VARCHAR2_TABLE_100
593: , p5_a5 JTF_DATE_TABLE
594: , p5_a6 JTF_DATE_TABLE

Line 591: , p5_a3 JTF_NUMBER_TABLE

587: , x_msg_data out nocopy VARCHAR2
588: , p5_a0 JTF_NUMBER_TABLE
589: , p5_a1 JTF_NUMBER_TABLE
590: , p5_a2 JTF_NUMBER_TABLE
591: , p5_a3 JTF_NUMBER_TABLE
592: , p5_a4 JTF_VARCHAR2_TABLE_100
593: , p5_a5 JTF_DATE_TABLE
594: , p5_a6 JTF_DATE_TABLE
595: , p5_a7 JTF_NUMBER_TABLE

Line 595: , p5_a7 JTF_NUMBER_TABLE

591: , p5_a3 JTF_NUMBER_TABLE
592: , p5_a4 JTF_VARCHAR2_TABLE_100
593: , p5_a5 JTF_DATE_TABLE
594: , p5_a6 JTF_DATE_TABLE
595: , p5_a7 JTF_NUMBER_TABLE
596: , p5_a8 JTF_VARCHAR2_TABLE_100
597: , p5_a9 JTF_VARCHAR2_TABLE_100
598: , p5_a10 JTF_VARCHAR2_TABLE_100
599: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 614: , p5_a26 JTF_NUMBER_TABLE

610: , p5_a22 JTF_VARCHAR2_TABLE_500
611: , p5_a23 JTF_VARCHAR2_TABLE_500
612: , p5_a24 JTF_VARCHAR2_TABLE_500
613: , p5_a25 JTF_VARCHAR2_TABLE_500
614: , p5_a26 JTF_NUMBER_TABLE
615: , p5_a27 JTF_DATE_TABLE
616: , p5_a28 JTF_NUMBER_TABLE
617: , p5_a29 JTF_DATE_TABLE
618: , p5_a30 JTF_NUMBER_TABLE

Line 616: , p5_a28 JTF_NUMBER_TABLE

612: , p5_a24 JTF_VARCHAR2_TABLE_500
613: , p5_a25 JTF_VARCHAR2_TABLE_500
614: , p5_a26 JTF_NUMBER_TABLE
615: , p5_a27 JTF_DATE_TABLE
616: , p5_a28 JTF_NUMBER_TABLE
617: , p5_a29 JTF_DATE_TABLE
618: , p5_a30 JTF_NUMBER_TABLE
619: );
620: procedure validate_row(p_api_version NUMBER

Line 618: , p5_a30 JTF_NUMBER_TABLE

614: , p5_a26 JTF_NUMBER_TABLE
615: , p5_a27 JTF_DATE_TABLE
616: , p5_a28 JTF_NUMBER_TABLE
617: , p5_a29 JTF_DATE_TABLE
618: , p5_a30 JTF_NUMBER_TABLE
619: );
620: procedure validate_row(p_api_version NUMBER
621: , p_init_msg_list VARCHAR2
622: , x_return_status out nocopy VARCHAR2

Line 662: , p5_a0 JTF_NUMBER_TABLE

658: , p_init_msg_list VARCHAR2
659: , x_return_status out nocopy VARCHAR2
660: , x_msg_count out nocopy NUMBER
661: , x_msg_data out nocopy VARCHAR2
662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_NUMBER_TABLE
666: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 663: , p5_a1 JTF_NUMBER_TABLE

659: , x_return_status out nocopy VARCHAR2
660: , x_msg_count out nocopy NUMBER
661: , x_msg_data out nocopy VARCHAR2
662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_NUMBER_TABLE
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_DATE_TABLE

Line 664: , p5_a2 JTF_NUMBER_TABLE

660: , x_msg_count out nocopy NUMBER
661: , x_msg_data out nocopy VARCHAR2
662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_NUMBER_TABLE
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_DATE_TABLE
668: , p5_a6 JTF_DATE_TABLE

Line 665: , p5_a3 JTF_NUMBER_TABLE

661: , x_msg_data out nocopy VARCHAR2
662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_NUMBER_TABLE
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_DATE_TABLE
668: , p5_a6 JTF_DATE_TABLE
669: , p5_a7 JTF_NUMBER_TABLE

Line 669: , p5_a7 JTF_NUMBER_TABLE

665: , p5_a3 JTF_NUMBER_TABLE
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_DATE_TABLE
668: , p5_a6 JTF_DATE_TABLE
669: , p5_a7 JTF_NUMBER_TABLE
670: , p5_a8 JTF_VARCHAR2_TABLE_100
671: , p5_a9 JTF_VARCHAR2_TABLE_100
672: , p5_a10 JTF_VARCHAR2_TABLE_100
673: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 688: , p5_a26 JTF_NUMBER_TABLE

684: , p5_a22 JTF_VARCHAR2_TABLE_500
685: , p5_a23 JTF_VARCHAR2_TABLE_500
686: , p5_a24 JTF_VARCHAR2_TABLE_500
687: , p5_a25 JTF_VARCHAR2_TABLE_500
688: , p5_a26 JTF_NUMBER_TABLE
689: , p5_a27 JTF_DATE_TABLE
690: , p5_a28 JTF_NUMBER_TABLE
691: , p5_a29 JTF_DATE_TABLE
692: , p5_a30 JTF_NUMBER_TABLE

Line 690: , p5_a28 JTF_NUMBER_TABLE

686: , p5_a24 JTF_VARCHAR2_TABLE_500
687: , p5_a25 JTF_VARCHAR2_TABLE_500
688: , p5_a26 JTF_NUMBER_TABLE
689: , p5_a27 JTF_DATE_TABLE
690: , p5_a28 JTF_NUMBER_TABLE
691: , p5_a29 JTF_DATE_TABLE
692: , p5_a30 JTF_NUMBER_TABLE
693: );
694: end okl_sid_pvt_w;

Line 692: , p5_a30 JTF_NUMBER_TABLE

688: , p5_a26 JTF_NUMBER_TABLE
689: , p5_a27 JTF_DATE_TABLE
690: , p5_a28 JTF_NUMBER_TABLE
691: , p5_a29 JTF_DATE_TABLE
692: , p5_a30 JTF_NUMBER_TABLE
693: );
694: end okl_sid_pvt_w;