DBA Data[Home] [Help]

APPS.OKL_TBC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_tbc_pvt_w as
2: /* $Header: OKLITBCS.pls 120.5 2007/03/12 10:24:12 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tbc_pvt.tbcv_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100

Line 43: , a40 JTF_VARCHAR2_TABLE_100

39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: );

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p2(t okl_tbc_pvt.tbcv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 45: , a42 JTF_VARCHAR2_TABLE_100

41: , a38 JTF_DATE_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p2(t okl_tbc_pvt.tbcv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p2(t okl_tbc_pvt.tbcv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE

Line 49: , a1 out nocopy JTF_VARCHAR2_TABLE_100

45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p2(t okl_tbc_pvt.tbcv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a5 out nocopy JTF_VARCHAR2_TABLE_100

49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a6 out nocopy JTF_VARCHAR2_TABLE_100

50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE

Line 55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE

Line 56: , a8 out nocopy JTF_VARCHAR2_TABLE_100

52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_NUMBER_TABLE

Line 57: , a9 out nocopy JTF_VARCHAR2_TABLE_100

53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_VARCHAR2_TABLE_100
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_NUMBER_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE

Line 62: , a14 out nocopy JTF_VARCHAR2_TABLE_100

58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_NUMBER_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_VARCHAR2_TABLE_500
64: , a16 out nocopy JTF_VARCHAR2_TABLE_500
65: , a17 out nocopy JTF_VARCHAR2_TABLE_500
66: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 84: , a36 out nocopy JTF_VARCHAR2_TABLE_100

80: , a32 out nocopy JTF_NUMBER_TABLE
81: , a33 out nocopy JTF_DATE_TABLE
82: , a34 out nocopy JTF_NUMBER_TABLE
83: , a35 out nocopy JTF_NUMBER_TABLE
84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_DATE_TABLE
87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , a37 out nocopy JTF_VARCHAR2_TABLE_100

81: , a33 out nocopy JTF_DATE_TABLE
82: , a34 out nocopy JTF_NUMBER_TABLE
83: , a35 out nocopy JTF_NUMBER_TABLE
84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_DATE_TABLE
87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , a40 out nocopy JTF_VARCHAR2_TABLE_100

84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_DATE_TABLE
87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_VARCHAR2_TABLE_100
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );

Line 89: , a41 out nocopy JTF_VARCHAR2_TABLE_100

85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_DATE_TABLE
87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_VARCHAR2_TABLE_100
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:

Line 90: , a42 out nocopy JTF_VARCHAR2_TABLE_100

86: , a38 out nocopy JTF_DATE_TABLE
87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_VARCHAR2_TABLE_100
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbc_pvt.tbc_tbl_type, a0 JTF_VARCHAR2_TABLE_300

Line 91: , a43 out nocopy JTF_VARCHAR2_TABLE_100

87: , a39 out nocopy JTF_DATE_TABLE
88: , a40 out nocopy JTF_VARCHAR2_TABLE_100
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_VARCHAR2_TABLE_100
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbc_pvt.tbc_tbl_type, a0 JTF_VARCHAR2_TABLE_300
95: , a1 JTF_VARCHAR2_TABLE_100

Line 95: , a1 JTF_VARCHAR2_TABLE_100

91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbc_pvt.tbc_tbl_type, a0 JTF_VARCHAR2_TABLE_300
95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_100

Line 99: , a5 JTF_VARCHAR2_TABLE_100

95: , a1 JTF_VARCHAR2_TABLE_100
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_100
100: , a6 JTF_VARCHAR2_TABLE_100
101: , a7 JTF_VARCHAR2_TABLE_100
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_VARCHAR2_TABLE_100

Line 100: , a6 JTF_VARCHAR2_TABLE_100

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

Line 101: , a7 JTF_VARCHAR2_TABLE_100

97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_100
100: , a6 JTF_VARCHAR2_TABLE_100
101: , a7 JTF_VARCHAR2_TABLE_100
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_VARCHAR2_TABLE_100
104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_NUMBER_TABLE

Line 102: , a8 JTF_VARCHAR2_TABLE_100

98: , a4 JTF_NUMBER_TABLE
99: , a5 JTF_VARCHAR2_TABLE_100
100: , a6 JTF_VARCHAR2_TABLE_100
101: , a7 JTF_VARCHAR2_TABLE_100
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_VARCHAR2_TABLE_100
104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_NUMBER_TABLE
106: , a12 JTF_NUMBER_TABLE

Line 103: , a9 JTF_VARCHAR2_TABLE_100

99: , a5 JTF_VARCHAR2_TABLE_100
100: , a6 JTF_VARCHAR2_TABLE_100
101: , a7 JTF_VARCHAR2_TABLE_100
102: , a8 JTF_VARCHAR2_TABLE_100
103: , a9 JTF_VARCHAR2_TABLE_100
104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_NUMBER_TABLE
106: , a12 JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE

Line 108: , a14 JTF_VARCHAR2_TABLE_100

104: , a10 JTF_NUMBER_TABLE
105: , a11 JTF_NUMBER_TABLE
106: , a12 JTF_NUMBER_TABLE
107: , a13 JTF_NUMBER_TABLE
108: , a14 JTF_VARCHAR2_TABLE_100
109: , a15 JTF_VARCHAR2_TABLE_500
110: , a16 JTF_VARCHAR2_TABLE_500
111: , a17 JTF_VARCHAR2_TABLE_500
112: , a18 JTF_VARCHAR2_TABLE_500

Line 130: , a36 JTF_VARCHAR2_TABLE_100

126: , a32 JTF_NUMBER_TABLE
127: , a33 JTF_DATE_TABLE
128: , a34 JTF_NUMBER_TABLE
129: , a35 JTF_NUMBER_TABLE
130: , a36 JTF_VARCHAR2_TABLE_100
131: , a37 JTF_VARCHAR2_TABLE_100
132: , a38 JTF_DATE_TABLE
133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100

Line 131: , a37 JTF_VARCHAR2_TABLE_100

127: , a33 JTF_DATE_TABLE
128: , a34 JTF_NUMBER_TABLE
129: , a35 JTF_NUMBER_TABLE
130: , a36 JTF_VARCHAR2_TABLE_100
131: , a37 JTF_VARCHAR2_TABLE_100
132: , a38 JTF_DATE_TABLE
133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100
135: , a41 JTF_VARCHAR2_TABLE_100

Line 134: , a40 JTF_VARCHAR2_TABLE_100

130: , a36 JTF_VARCHAR2_TABLE_100
131: , a37 JTF_VARCHAR2_TABLE_100
132: , a38 JTF_DATE_TABLE
133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100
135: , a41 JTF_VARCHAR2_TABLE_100
136: , a42 JTF_VARCHAR2_TABLE_100
137: , a43 JTF_VARCHAR2_TABLE_100
138: );

Line 135: , a41 JTF_VARCHAR2_TABLE_100

131: , a37 JTF_VARCHAR2_TABLE_100
132: , a38 JTF_DATE_TABLE
133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100
135: , a41 JTF_VARCHAR2_TABLE_100
136: , a42 JTF_VARCHAR2_TABLE_100
137: , a43 JTF_VARCHAR2_TABLE_100
138: );
139: procedure rosetta_table_copy_out_p5(t okl_tbc_pvt.tbc_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 136: , a42 JTF_VARCHAR2_TABLE_100

132: , a38 JTF_DATE_TABLE
133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100
135: , a41 JTF_VARCHAR2_TABLE_100
136: , a42 JTF_VARCHAR2_TABLE_100
137: , a43 JTF_VARCHAR2_TABLE_100
138: );
139: procedure rosetta_table_copy_out_p5(t okl_tbc_pvt.tbc_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
140: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a43 JTF_VARCHAR2_TABLE_100

133: , a39 JTF_DATE_TABLE
134: , a40 JTF_VARCHAR2_TABLE_100
135: , a41 JTF_VARCHAR2_TABLE_100
136: , a42 JTF_VARCHAR2_TABLE_100
137: , a43 JTF_VARCHAR2_TABLE_100
138: );
139: procedure rosetta_table_copy_out_p5(t okl_tbc_pvt.tbc_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
140: , a1 out nocopy JTF_VARCHAR2_TABLE_100
141: , a2 out nocopy JTF_NUMBER_TABLE

Line 140: , a1 out nocopy JTF_VARCHAR2_TABLE_100

136: , a42 JTF_VARCHAR2_TABLE_100
137: , a43 JTF_VARCHAR2_TABLE_100
138: );
139: procedure rosetta_table_copy_out_p5(t okl_tbc_pvt.tbc_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
140: , a1 out nocopy JTF_VARCHAR2_TABLE_100
141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_NUMBER_TABLE
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , a5 out nocopy JTF_VARCHAR2_TABLE_100

140: , a1 out nocopy JTF_VARCHAR2_TABLE_100
141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_NUMBER_TABLE
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , a6 out nocopy JTF_VARCHAR2_TABLE_100

141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_NUMBER_TABLE
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_NUMBER_TABLE

Line 146: , a7 out nocopy JTF_VARCHAR2_TABLE_100

142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_NUMBER_TABLE
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_NUMBER_TABLE
150: , a11 out nocopy JTF_NUMBER_TABLE

Line 147: , a8 out nocopy JTF_VARCHAR2_TABLE_100

143: , a4 out nocopy JTF_NUMBER_TABLE
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_NUMBER_TABLE
150: , a11 out nocopy JTF_NUMBER_TABLE
151: , a12 out nocopy JTF_NUMBER_TABLE

Line 148: , a9 out nocopy JTF_VARCHAR2_TABLE_100

144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_NUMBER_TABLE
150: , a11 out nocopy JTF_NUMBER_TABLE
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_NUMBER_TABLE

Line 153: , a14 out nocopy JTF_VARCHAR2_TABLE_100

149: , a10 out nocopy JTF_NUMBER_TABLE
150: , a11 out nocopy JTF_NUMBER_TABLE
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_NUMBER_TABLE
153: , a14 out nocopy JTF_VARCHAR2_TABLE_100
154: , a15 out nocopy JTF_VARCHAR2_TABLE_500
155: , a16 out nocopy JTF_VARCHAR2_TABLE_500
156: , a17 out nocopy JTF_VARCHAR2_TABLE_500
157: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 175: , a36 out nocopy JTF_VARCHAR2_TABLE_100

171: , a32 out nocopy JTF_NUMBER_TABLE
172: , a33 out nocopy JTF_DATE_TABLE
173: , a34 out nocopy JTF_NUMBER_TABLE
174: , a35 out nocopy JTF_NUMBER_TABLE
175: , a36 out nocopy JTF_VARCHAR2_TABLE_100
176: , a37 out nocopy JTF_VARCHAR2_TABLE_100
177: , a38 out nocopy JTF_DATE_TABLE
178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , a37 out nocopy JTF_VARCHAR2_TABLE_100

172: , a33 out nocopy JTF_DATE_TABLE
173: , a34 out nocopy JTF_NUMBER_TABLE
174: , a35 out nocopy JTF_NUMBER_TABLE
175: , a36 out nocopy JTF_VARCHAR2_TABLE_100
176: , a37 out nocopy JTF_VARCHAR2_TABLE_100
177: , a38 out nocopy JTF_DATE_TABLE
178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100
180: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , a40 out nocopy JTF_VARCHAR2_TABLE_100

175: , a36 out nocopy JTF_VARCHAR2_TABLE_100
176: , a37 out nocopy JTF_VARCHAR2_TABLE_100
177: , a38 out nocopy JTF_DATE_TABLE
178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100
180: , a41 out nocopy JTF_VARCHAR2_TABLE_100
181: , a42 out nocopy JTF_VARCHAR2_TABLE_100
182: , a43 out nocopy JTF_VARCHAR2_TABLE_100
183: );

Line 180: , a41 out nocopy JTF_VARCHAR2_TABLE_100

176: , a37 out nocopy JTF_VARCHAR2_TABLE_100
177: , a38 out nocopy JTF_DATE_TABLE
178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100
180: , a41 out nocopy JTF_VARCHAR2_TABLE_100
181: , a42 out nocopy JTF_VARCHAR2_TABLE_100
182: , a43 out nocopy JTF_VARCHAR2_TABLE_100
183: );
184:

Line 181: , a42 out nocopy JTF_VARCHAR2_TABLE_100

177: , a38 out nocopy JTF_DATE_TABLE
178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100
180: , a41 out nocopy JTF_VARCHAR2_TABLE_100
181: , a42 out nocopy JTF_VARCHAR2_TABLE_100
182: , a43 out nocopy JTF_VARCHAR2_TABLE_100
183: );
184:
185: procedure insert_row(p_api_version NUMBER

Line 182: , a43 out nocopy JTF_VARCHAR2_TABLE_100

178: , a39 out nocopy JTF_DATE_TABLE
179: , a40 out nocopy JTF_VARCHAR2_TABLE_100
180: , a41 out nocopy JTF_VARCHAR2_TABLE_100
181: , a42 out nocopy JTF_VARCHAR2_TABLE_100
182: , a43 out nocopy JTF_VARCHAR2_TABLE_100
183: );
184:
185: procedure insert_row(p_api_version NUMBER
186: , p_init_msg_list VARCHAR2

Line 285: , p5_a1 JTF_VARCHAR2_TABLE_100

281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_VARCHAR2_TABLE_300
285: , p5_a1 JTF_VARCHAR2_TABLE_100
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 289: , p5_a5 JTF_VARCHAR2_TABLE_100

285: , p5_a1 JTF_VARCHAR2_TABLE_100
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_VARCHAR2_TABLE_100
293: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 290: , p5_a6 JTF_VARCHAR2_TABLE_100

286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_VARCHAR2_TABLE_100
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_NUMBER_TABLE

Line 291: , p5_a7 JTF_VARCHAR2_TABLE_100

287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_VARCHAR2_TABLE_100
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_NUMBER_TABLE
295: , p5_a11 JTF_NUMBER_TABLE

Line 292: , p5_a8 JTF_VARCHAR2_TABLE_100

288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_VARCHAR2_TABLE_100
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_NUMBER_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_NUMBER_TABLE

Line 293: , p5_a9 JTF_VARCHAR2_TABLE_100

289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_VARCHAR2_TABLE_100
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_NUMBER_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_NUMBER_TABLE
297: , p5_a13 JTF_NUMBER_TABLE

Line 298: , p5_a14 JTF_VARCHAR2_TABLE_100

294: , p5_a10 JTF_NUMBER_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_NUMBER_TABLE
297: , p5_a13 JTF_NUMBER_TABLE
298: , p5_a14 JTF_VARCHAR2_TABLE_100
299: , p5_a15 JTF_VARCHAR2_TABLE_500
300: , p5_a16 JTF_VARCHAR2_TABLE_500
301: , p5_a17 JTF_VARCHAR2_TABLE_500
302: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 320: , p5_a36 JTF_VARCHAR2_TABLE_100

316: , p5_a32 JTF_NUMBER_TABLE
317: , p5_a33 JTF_DATE_TABLE
318: , p5_a34 JTF_NUMBER_TABLE
319: , p5_a35 JTF_NUMBER_TABLE
320: , p5_a36 JTF_VARCHAR2_TABLE_100
321: , p5_a37 JTF_VARCHAR2_TABLE_100
322: , p5_a38 JTF_DATE_TABLE
323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 321: , p5_a37 JTF_VARCHAR2_TABLE_100

317: , p5_a33 JTF_DATE_TABLE
318: , p5_a34 JTF_NUMBER_TABLE
319: , p5_a35 JTF_NUMBER_TABLE
320: , p5_a36 JTF_VARCHAR2_TABLE_100
321: , p5_a37 JTF_VARCHAR2_TABLE_100
322: , p5_a38 JTF_DATE_TABLE
323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100
325: , p5_a41 JTF_VARCHAR2_TABLE_100

Line 324: , p5_a40 JTF_VARCHAR2_TABLE_100

320: , p5_a36 JTF_VARCHAR2_TABLE_100
321: , p5_a37 JTF_VARCHAR2_TABLE_100
322: , p5_a38 JTF_DATE_TABLE
323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100
325: , p5_a41 JTF_VARCHAR2_TABLE_100
326: , p5_a42 JTF_VARCHAR2_TABLE_100
327: , p5_a43 JTF_VARCHAR2_TABLE_100
328: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 325: , p5_a41 JTF_VARCHAR2_TABLE_100

321: , p5_a37 JTF_VARCHAR2_TABLE_100
322: , p5_a38 JTF_DATE_TABLE
323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100
325: , p5_a41 JTF_VARCHAR2_TABLE_100
326: , p5_a42 JTF_VARCHAR2_TABLE_100
327: , p5_a43 JTF_VARCHAR2_TABLE_100
328: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: , p5_a42 JTF_VARCHAR2_TABLE_100

322: , p5_a38 JTF_DATE_TABLE
323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100
325: , p5_a41 JTF_VARCHAR2_TABLE_100
326: , p5_a42 JTF_VARCHAR2_TABLE_100
327: , p5_a43 JTF_VARCHAR2_TABLE_100
328: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 327: , p5_a43 JTF_VARCHAR2_TABLE_100

323: , p5_a39 JTF_DATE_TABLE
324: , p5_a40 JTF_VARCHAR2_TABLE_100
325: , p5_a41 JTF_VARCHAR2_TABLE_100
326: , p5_a42 JTF_VARCHAR2_TABLE_100
327: , p5_a43 JTF_VARCHAR2_TABLE_100
328: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

325: , p5_a41 JTF_VARCHAR2_TABLE_100
326: , p5_a42 JTF_VARCHAR2_TABLE_100
327: , p5_a43 JTF_VARCHAR2_TABLE_100
328: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_NUMBER_TABLE
332: , p6_a4 out nocopy JTF_NUMBER_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

329: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_NUMBER_TABLE
332: , p6_a4 out nocopy JTF_NUMBER_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_NUMBER_TABLE
332: , p6_a4 out nocopy JTF_NUMBER_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

331: , p6_a3 out nocopy JTF_NUMBER_TABLE
332: , p6_a4 out nocopy JTF_NUMBER_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a10 out nocopy JTF_NUMBER_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

332: , p6_a4 out nocopy JTF_NUMBER_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a10 out nocopy JTF_NUMBER_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a10 out nocopy JTF_NUMBER_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_NUMBER_TABLE
341: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 342: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

338: , p6_a10 out nocopy JTF_NUMBER_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_NUMBER_TABLE
341: , p6_a13 out nocopy JTF_NUMBER_TABLE
342: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
346: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 364: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

360: , p6_a32 out nocopy JTF_NUMBER_TABLE
361: , p6_a33 out nocopy JTF_DATE_TABLE
362: , p6_a34 out nocopy JTF_NUMBER_TABLE
363: , p6_a35 out nocopy JTF_NUMBER_TABLE
364: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
366: , p6_a38 out nocopy JTF_DATE_TABLE
367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 365: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

361: , p6_a33 out nocopy JTF_DATE_TABLE
362: , p6_a34 out nocopy JTF_NUMBER_TABLE
363: , p6_a35 out nocopy JTF_NUMBER_TABLE
364: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
366: , p6_a38 out nocopy JTF_DATE_TABLE
367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

364: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
366: , p6_a38 out nocopy JTF_DATE_TABLE
367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
372: );

Line 369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100

365: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
366: , p6_a38 out nocopy JTF_DATE_TABLE
367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
372: );
373: procedure lock_row(p_api_version NUMBER

Line 370: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

366: , p6_a38 out nocopy JTF_DATE_TABLE
367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
372: );
373: procedure lock_row(p_api_version NUMBER
374: , p_init_msg_list VARCHAR2

Line 371: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

367: , p6_a39 out nocopy JTF_DATE_TABLE
368: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
369: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
372: );
373: procedure lock_row(p_api_version NUMBER
374: , p_init_msg_list VARCHAR2
375: , x_return_status out nocopy VARCHAR2

Line 429: , p5_a1 JTF_VARCHAR2_TABLE_100

425: , x_return_status out nocopy VARCHAR2
426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_VARCHAR2_TABLE_300
429: , p5_a1 JTF_VARCHAR2_TABLE_100
430: , p5_a2 JTF_NUMBER_TABLE
431: , p5_a3 JTF_NUMBER_TABLE
432: , p5_a4 JTF_NUMBER_TABLE
433: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 433: , p5_a5 JTF_VARCHAR2_TABLE_100

429: , p5_a1 JTF_VARCHAR2_TABLE_100
430: , p5_a2 JTF_NUMBER_TABLE
431: , p5_a3 JTF_NUMBER_TABLE
432: , p5_a4 JTF_NUMBER_TABLE
433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_100
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 434: , p5_a6 JTF_VARCHAR2_TABLE_100

430: , p5_a2 JTF_NUMBER_TABLE
431: , p5_a3 JTF_NUMBER_TABLE
432: , p5_a4 JTF_NUMBER_TABLE
433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_100
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_NUMBER_TABLE

Line 435: , p5_a7 JTF_VARCHAR2_TABLE_100

431: , p5_a3 JTF_NUMBER_TABLE
432: , p5_a4 JTF_NUMBER_TABLE
433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_100
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_NUMBER_TABLE
439: , p5_a11 JTF_NUMBER_TABLE

Line 436: , p5_a8 JTF_VARCHAR2_TABLE_100

432: , p5_a4 JTF_NUMBER_TABLE
433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_100
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_NUMBER_TABLE
439: , p5_a11 JTF_NUMBER_TABLE
440: , p5_a12 JTF_NUMBER_TABLE

Line 437: , p5_a9 JTF_VARCHAR2_TABLE_100

433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_100
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_NUMBER_TABLE
439: , p5_a11 JTF_NUMBER_TABLE
440: , p5_a12 JTF_NUMBER_TABLE
441: , p5_a13 JTF_NUMBER_TABLE

Line 442: , p5_a14 JTF_VARCHAR2_TABLE_100

438: , p5_a10 JTF_NUMBER_TABLE
439: , p5_a11 JTF_NUMBER_TABLE
440: , p5_a12 JTF_NUMBER_TABLE
441: , p5_a13 JTF_NUMBER_TABLE
442: , p5_a14 JTF_VARCHAR2_TABLE_100
443: , p5_a15 JTF_VARCHAR2_TABLE_500
444: , p5_a16 JTF_VARCHAR2_TABLE_500
445: , p5_a17 JTF_VARCHAR2_TABLE_500
446: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 464: , p5_a36 JTF_VARCHAR2_TABLE_100

460: , p5_a32 JTF_NUMBER_TABLE
461: , p5_a33 JTF_DATE_TABLE
462: , p5_a34 JTF_NUMBER_TABLE
463: , p5_a35 JTF_NUMBER_TABLE
464: , p5_a36 JTF_VARCHAR2_TABLE_100
465: , p5_a37 JTF_VARCHAR2_TABLE_100
466: , p5_a38 JTF_DATE_TABLE
467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 465: , p5_a37 JTF_VARCHAR2_TABLE_100

461: , p5_a33 JTF_DATE_TABLE
462: , p5_a34 JTF_NUMBER_TABLE
463: , p5_a35 JTF_NUMBER_TABLE
464: , p5_a36 JTF_VARCHAR2_TABLE_100
465: , p5_a37 JTF_VARCHAR2_TABLE_100
466: , p5_a38 JTF_DATE_TABLE
467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100
469: , p5_a41 JTF_VARCHAR2_TABLE_100

Line 468: , p5_a40 JTF_VARCHAR2_TABLE_100

464: , p5_a36 JTF_VARCHAR2_TABLE_100
465: , p5_a37 JTF_VARCHAR2_TABLE_100
466: , p5_a38 JTF_DATE_TABLE
467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100
469: , p5_a41 JTF_VARCHAR2_TABLE_100
470: , p5_a42 JTF_VARCHAR2_TABLE_100
471: , p5_a43 JTF_VARCHAR2_TABLE_100
472: );

Line 469: , p5_a41 JTF_VARCHAR2_TABLE_100

465: , p5_a37 JTF_VARCHAR2_TABLE_100
466: , p5_a38 JTF_DATE_TABLE
467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100
469: , p5_a41 JTF_VARCHAR2_TABLE_100
470: , p5_a42 JTF_VARCHAR2_TABLE_100
471: , p5_a43 JTF_VARCHAR2_TABLE_100
472: );
473: procedure update_row(p_api_version NUMBER

Line 470: , p5_a42 JTF_VARCHAR2_TABLE_100

466: , p5_a38 JTF_DATE_TABLE
467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100
469: , p5_a41 JTF_VARCHAR2_TABLE_100
470: , p5_a42 JTF_VARCHAR2_TABLE_100
471: , p5_a43 JTF_VARCHAR2_TABLE_100
472: );
473: procedure update_row(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2

Line 471: , p5_a43 JTF_VARCHAR2_TABLE_100

467: , p5_a39 JTF_DATE_TABLE
468: , p5_a40 JTF_VARCHAR2_TABLE_100
469: , p5_a41 JTF_VARCHAR2_TABLE_100
470: , p5_a42 JTF_VARCHAR2_TABLE_100
471: , p5_a43 JTF_VARCHAR2_TABLE_100
472: );
473: procedure update_row(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2

Line 573: , p5_a1 JTF_VARCHAR2_TABLE_100

569: , x_return_status out nocopy VARCHAR2
570: , x_msg_count out nocopy NUMBER
571: , x_msg_data out nocopy VARCHAR2
572: , p5_a0 JTF_VARCHAR2_TABLE_300
573: , p5_a1 JTF_VARCHAR2_TABLE_100
574: , p5_a2 JTF_NUMBER_TABLE
575: , p5_a3 JTF_NUMBER_TABLE
576: , p5_a4 JTF_NUMBER_TABLE
577: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 577: , p5_a5 JTF_VARCHAR2_TABLE_100

573: , p5_a1 JTF_VARCHAR2_TABLE_100
574: , p5_a2 JTF_NUMBER_TABLE
575: , p5_a3 JTF_NUMBER_TABLE
576: , p5_a4 JTF_NUMBER_TABLE
577: , p5_a5 JTF_VARCHAR2_TABLE_100
578: , p5_a6 JTF_VARCHAR2_TABLE_100
579: , p5_a7 JTF_VARCHAR2_TABLE_100
580: , p5_a8 JTF_VARCHAR2_TABLE_100
581: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 578: , p5_a6 JTF_VARCHAR2_TABLE_100

574: , p5_a2 JTF_NUMBER_TABLE
575: , p5_a3 JTF_NUMBER_TABLE
576: , p5_a4 JTF_NUMBER_TABLE
577: , p5_a5 JTF_VARCHAR2_TABLE_100
578: , p5_a6 JTF_VARCHAR2_TABLE_100
579: , p5_a7 JTF_VARCHAR2_TABLE_100
580: , p5_a8 JTF_VARCHAR2_TABLE_100
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE

Line 579: , p5_a7 JTF_VARCHAR2_TABLE_100

575: , p5_a3 JTF_NUMBER_TABLE
576: , p5_a4 JTF_NUMBER_TABLE
577: , p5_a5 JTF_VARCHAR2_TABLE_100
578: , p5_a6 JTF_VARCHAR2_TABLE_100
579: , p5_a7 JTF_VARCHAR2_TABLE_100
580: , p5_a8 JTF_VARCHAR2_TABLE_100
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_NUMBER_TABLE

Line 580: , p5_a8 JTF_VARCHAR2_TABLE_100

576: , p5_a4 JTF_NUMBER_TABLE
577: , p5_a5 JTF_VARCHAR2_TABLE_100
578: , p5_a6 JTF_VARCHAR2_TABLE_100
579: , p5_a7 JTF_VARCHAR2_TABLE_100
580: , p5_a8 JTF_VARCHAR2_TABLE_100
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_NUMBER_TABLE
584: , p5_a12 JTF_NUMBER_TABLE

Line 581: , p5_a9 JTF_VARCHAR2_TABLE_100

577: , p5_a5 JTF_VARCHAR2_TABLE_100
578: , p5_a6 JTF_VARCHAR2_TABLE_100
579: , p5_a7 JTF_VARCHAR2_TABLE_100
580: , p5_a8 JTF_VARCHAR2_TABLE_100
581: , p5_a9 JTF_VARCHAR2_TABLE_100
582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_NUMBER_TABLE
584: , p5_a12 JTF_NUMBER_TABLE
585: , p5_a13 JTF_NUMBER_TABLE

Line 586: , p5_a14 JTF_VARCHAR2_TABLE_100

582: , p5_a10 JTF_NUMBER_TABLE
583: , p5_a11 JTF_NUMBER_TABLE
584: , p5_a12 JTF_NUMBER_TABLE
585: , p5_a13 JTF_NUMBER_TABLE
586: , p5_a14 JTF_VARCHAR2_TABLE_100
587: , p5_a15 JTF_VARCHAR2_TABLE_500
588: , p5_a16 JTF_VARCHAR2_TABLE_500
589: , p5_a17 JTF_VARCHAR2_TABLE_500
590: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 608: , p5_a36 JTF_VARCHAR2_TABLE_100

604: , p5_a32 JTF_NUMBER_TABLE
605: , p5_a33 JTF_DATE_TABLE
606: , p5_a34 JTF_NUMBER_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_VARCHAR2_TABLE_100
609: , p5_a37 JTF_VARCHAR2_TABLE_100
610: , p5_a38 JTF_DATE_TABLE
611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 609: , p5_a37 JTF_VARCHAR2_TABLE_100

605: , p5_a33 JTF_DATE_TABLE
606: , p5_a34 JTF_NUMBER_TABLE
607: , p5_a35 JTF_NUMBER_TABLE
608: , p5_a36 JTF_VARCHAR2_TABLE_100
609: , p5_a37 JTF_VARCHAR2_TABLE_100
610: , p5_a38 JTF_DATE_TABLE
611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100
613: , p5_a41 JTF_VARCHAR2_TABLE_100

Line 612: , p5_a40 JTF_VARCHAR2_TABLE_100

608: , p5_a36 JTF_VARCHAR2_TABLE_100
609: , p5_a37 JTF_VARCHAR2_TABLE_100
610: , p5_a38 JTF_DATE_TABLE
611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100
613: , p5_a41 JTF_VARCHAR2_TABLE_100
614: , p5_a42 JTF_VARCHAR2_TABLE_100
615: , p5_a43 JTF_VARCHAR2_TABLE_100
616: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 613: , p5_a41 JTF_VARCHAR2_TABLE_100

609: , p5_a37 JTF_VARCHAR2_TABLE_100
610: , p5_a38 JTF_DATE_TABLE
611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100
613: , p5_a41 JTF_VARCHAR2_TABLE_100
614: , p5_a42 JTF_VARCHAR2_TABLE_100
615: , p5_a43 JTF_VARCHAR2_TABLE_100
616: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 614: , p5_a42 JTF_VARCHAR2_TABLE_100

610: , p5_a38 JTF_DATE_TABLE
611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100
613: , p5_a41 JTF_VARCHAR2_TABLE_100
614: , p5_a42 JTF_VARCHAR2_TABLE_100
615: , p5_a43 JTF_VARCHAR2_TABLE_100
616: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 615: , p5_a43 JTF_VARCHAR2_TABLE_100

611: , p5_a39 JTF_DATE_TABLE
612: , p5_a40 JTF_VARCHAR2_TABLE_100
613: , p5_a41 JTF_VARCHAR2_TABLE_100
614: , p5_a42 JTF_VARCHAR2_TABLE_100
615: , p5_a43 JTF_VARCHAR2_TABLE_100
616: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a2 out nocopy JTF_NUMBER_TABLE
619: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

613: , p5_a41 JTF_VARCHAR2_TABLE_100
614: , p5_a42 JTF_VARCHAR2_TABLE_100
615: , p5_a43 JTF_VARCHAR2_TABLE_100
616: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a2 out nocopy JTF_NUMBER_TABLE
619: , p6_a3 out nocopy JTF_NUMBER_TABLE
620: , p6_a4 out nocopy JTF_NUMBER_TABLE
621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

617: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a2 out nocopy JTF_NUMBER_TABLE
619: , p6_a3 out nocopy JTF_NUMBER_TABLE
620: , p6_a4 out nocopy JTF_NUMBER_TABLE
621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

618: , p6_a2 out nocopy JTF_NUMBER_TABLE
619: , p6_a3 out nocopy JTF_NUMBER_TABLE
620: , p6_a4 out nocopy JTF_NUMBER_TABLE
621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

619: , p6_a3 out nocopy JTF_NUMBER_TABLE
620: , p6_a4 out nocopy JTF_NUMBER_TABLE
621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a10 out nocopy JTF_NUMBER_TABLE
627: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

620: , p6_a4 out nocopy JTF_NUMBER_TABLE
621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a10 out nocopy JTF_NUMBER_TABLE
627: , p6_a11 out nocopy JTF_NUMBER_TABLE
628: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

621: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a10 out nocopy JTF_NUMBER_TABLE
627: , p6_a11 out nocopy JTF_NUMBER_TABLE
628: , p6_a12 out nocopy JTF_NUMBER_TABLE
629: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 630: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

626: , p6_a10 out nocopy JTF_NUMBER_TABLE
627: , p6_a11 out nocopy JTF_NUMBER_TABLE
628: , p6_a12 out nocopy JTF_NUMBER_TABLE
629: , p6_a13 out nocopy JTF_NUMBER_TABLE
630: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
632: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
633: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
634: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 652: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

648: , p6_a32 out nocopy JTF_NUMBER_TABLE
649: , p6_a33 out nocopy JTF_DATE_TABLE
650: , p6_a34 out nocopy JTF_NUMBER_TABLE
651: , p6_a35 out nocopy JTF_NUMBER_TABLE
652: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
653: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a38 out nocopy JTF_DATE_TABLE
655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 653: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

649: , p6_a33 out nocopy JTF_DATE_TABLE
650: , p6_a34 out nocopy JTF_NUMBER_TABLE
651: , p6_a35 out nocopy JTF_NUMBER_TABLE
652: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
653: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a38 out nocopy JTF_DATE_TABLE
655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

652: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
653: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a38 out nocopy JTF_DATE_TABLE
655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
660: );

Line 657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100

653: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a38 out nocopy JTF_DATE_TABLE
655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
660: );
661: procedure delete_row(p_api_version NUMBER

Line 658: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

654: , p6_a38 out nocopy JTF_DATE_TABLE
655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
660: );
661: procedure delete_row(p_api_version NUMBER
662: , p_init_msg_list VARCHAR2

Line 659: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

655: , p6_a39 out nocopy JTF_DATE_TABLE
656: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
660: );
661: procedure delete_row(p_api_version NUMBER
662: , p_init_msg_list VARCHAR2
663: , x_return_status out nocopy VARCHAR2

Line 717: , p5_a1 JTF_VARCHAR2_TABLE_100

713: , x_return_status out nocopy VARCHAR2
714: , x_msg_count out nocopy NUMBER
715: , x_msg_data out nocopy VARCHAR2
716: , p5_a0 JTF_VARCHAR2_TABLE_300
717: , p5_a1 JTF_VARCHAR2_TABLE_100
718: , p5_a2 JTF_NUMBER_TABLE
719: , p5_a3 JTF_NUMBER_TABLE
720: , p5_a4 JTF_NUMBER_TABLE
721: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 721: , p5_a5 JTF_VARCHAR2_TABLE_100

717: , p5_a1 JTF_VARCHAR2_TABLE_100
718: , p5_a2 JTF_NUMBER_TABLE
719: , p5_a3 JTF_NUMBER_TABLE
720: , p5_a4 JTF_NUMBER_TABLE
721: , p5_a5 JTF_VARCHAR2_TABLE_100
722: , p5_a6 JTF_VARCHAR2_TABLE_100
723: , p5_a7 JTF_VARCHAR2_TABLE_100
724: , p5_a8 JTF_VARCHAR2_TABLE_100
725: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 722: , p5_a6 JTF_VARCHAR2_TABLE_100

718: , p5_a2 JTF_NUMBER_TABLE
719: , p5_a3 JTF_NUMBER_TABLE
720: , p5_a4 JTF_NUMBER_TABLE
721: , p5_a5 JTF_VARCHAR2_TABLE_100
722: , p5_a6 JTF_VARCHAR2_TABLE_100
723: , p5_a7 JTF_VARCHAR2_TABLE_100
724: , p5_a8 JTF_VARCHAR2_TABLE_100
725: , p5_a9 JTF_VARCHAR2_TABLE_100
726: , p5_a10 JTF_NUMBER_TABLE

Line 723: , p5_a7 JTF_VARCHAR2_TABLE_100

719: , p5_a3 JTF_NUMBER_TABLE
720: , p5_a4 JTF_NUMBER_TABLE
721: , p5_a5 JTF_VARCHAR2_TABLE_100
722: , p5_a6 JTF_VARCHAR2_TABLE_100
723: , p5_a7 JTF_VARCHAR2_TABLE_100
724: , p5_a8 JTF_VARCHAR2_TABLE_100
725: , p5_a9 JTF_VARCHAR2_TABLE_100
726: , p5_a10 JTF_NUMBER_TABLE
727: , p5_a11 JTF_NUMBER_TABLE

Line 724: , p5_a8 JTF_VARCHAR2_TABLE_100

720: , p5_a4 JTF_NUMBER_TABLE
721: , p5_a5 JTF_VARCHAR2_TABLE_100
722: , p5_a6 JTF_VARCHAR2_TABLE_100
723: , p5_a7 JTF_VARCHAR2_TABLE_100
724: , p5_a8 JTF_VARCHAR2_TABLE_100
725: , p5_a9 JTF_VARCHAR2_TABLE_100
726: , p5_a10 JTF_NUMBER_TABLE
727: , p5_a11 JTF_NUMBER_TABLE
728: , p5_a12 JTF_NUMBER_TABLE

Line 725: , p5_a9 JTF_VARCHAR2_TABLE_100

721: , p5_a5 JTF_VARCHAR2_TABLE_100
722: , p5_a6 JTF_VARCHAR2_TABLE_100
723: , p5_a7 JTF_VARCHAR2_TABLE_100
724: , p5_a8 JTF_VARCHAR2_TABLE_100
725: , p5_a9 JTF_VARCHAR2_TABLE_100
726: , p5_a10 JTF_NUMBER_TABLE
727: , p5_a11 JTF_NUMBER_TABLE
728: , p5_a12 JTF_NUMBER_TABLE
729: , p5_a13 JTF_NUMBER_TABLE

Line 730: , p5_a14 JTF_VARCHAR2_TABLE_100

726: , p5_a10 JTF_NUMBER_TABLE
727: , p5_a11 JTF_NUMBER_TABLE
728: , p5_a12 JTF_NUMBER_TABLE
729: , p5_a13 JTF_NUMBER_TABLE
730: , p5_a14 JTF_VARCHAR2_TABLE_100
731: , p5_a15 JTF_VARCHAR2_TABLE_500
732: , p5_a16 JTF_VARCHAR2_TABLE_500
733: , p5_a17 JTF_VARCHAR2_TABLE_500
734: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 752: , p5_a36 JTF_VARCHAR2_TABLE_100

748: , p5_a32 JTF_NUMBER_TABLE
749: , p5_a33 JTF_DATE_TABLE
750: , p5_a34 JTF_NUMBER_TABLE
751: , p5_a35 JTF_NUMBER_TABLE
752: , p5_a36 JTF_VARCHAR2_TABLE_100
753: , p5_a37 JTF_VARCHAR2_TABLE_100
754: , p5_a38 JTF_DATE_TABLE
755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 753: , p5_a37 JTF_VARCHAR2_TABLE_100

749: , p5_a33 JTF_DATE_TABLE
750: , p5_a34 JTF_NUMBER_TABLE
751: , p5_a35 JTF_NUMBER_TABLE
752: , p5_a36 JTF_VARCHAR2_TABLE_100
753: , p5_a37 JTF_VARCHAR2_TABLE_100
754: , p5_a38 JTF_DATE_TABLE
755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100
757: , p5_a41 JTF_VARCHAR2_TABLE_100

Line 756: , p5_a40 JTF_VARCHAR2_TABLE_100

752: , p5_a36 JTF_VARCHAR2_TABLE_100
753: , p5_a37 JTF_VARCHAR2_TABLE_100
754: , p5_a38 JTF_DATE_TABLE
755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100
757: , p5_a41 JTF_VARCHAR2_TABLE_100
758: , p5_a42 JTF_VARCHAR2_TABLE_100
759: , p5_a43 JTF_VARCHAR2_TABLE_100
760: );

Line 757: , p5_a41 JTF_VARCHAR2_TABLE_100

753: , p5_a37 JTF_VARCHAR2_TABLE_100
754: , p5_a38 JTF_DATE_TABLE
755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100
757: , p5_a41 JTF_VARCHAR2_TABLE_100
758: , p5_a42 JTF_VARCHAR2_TABLE_100
759: , p5_a43 JTF_VARCHAR2_TABLE_100
760: );
761: procedure validate_row(p_api_version NUMBER

Line 758: , p5_a42 JTF_VARCHAR2_TABLE_100

754: , p5_a38 JTF_DATE_TABLE
755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100
757: , p5_a41 JTF_VARCHAR2_TABLE_100
758: , p5_a42 JTF_VARCHAR2_TABLE_100
759: , p5_a43 JTF_VARCHAR2_TABLE_100
760: );
761: procedure validate_row(p_api_version NUMBER
762: , p_init_msg_list VARCHAR2

Line 759: , p5_a43 JTF_VARCHAR2_TABLE_100

755: , p5_a39 JTF_DATE_TABLE
756: , p5_a40 JTF_VARCHAR2_TABLE_100
757: , p5_a41 JTF_VARCHAR2_TABLE_100
758: , p5_a42 JTF_VARCHAR2_TABLE_100
759: , p5_a43 JTF_VARCHAR2_TABLE_100
760: );
761: procedure validate_row(p_api_version NUMBER
762: , p_init_msg_list VARCHAR2
763: , x_return_status out nocopy VARCHAR2

Line 817: , p5_a1 JTF_VARCHAR2_TABLE_100

813: , x_return_status out nocopy VARCHAR2
814: , x_msg_count out nocopy NUMBER
815: , x_msg_data out nocopy VARCHAR2
816: , p5_a0 JTF_VARCHAR2_TABLE_300
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_NUMBER_TABLE
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 821: , p5_a5 JTF_VARCHAR2_TABLE_100

817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_NUMBER_TABLE
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_VARCHAR2_TABLE_100
824: , p5_a8 JTF_VARCHAR2_TABLE_100
825: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 822: , p5_a6 JTF_VARCHAR2_TABLE_100

818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_NUMBER_TABLE
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_VARCHAR2_TABLE_100
824: , p5_a8 JTF_VARCHAR2_TABLE_100
825: , p5_a9 JTF_VARCHAR2_TABLE_100
826: , p5_a10 JTF_NUMBER_TABLE

Line 823: , p5_a7 JTF_VARCHAR2_TABLE_100

819: , p5_a3 JTF_NUMBER_TABLE
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_VARCHAR2_TABLE_100
824: , p5_a8 JTF_VARCHAR2_TABLE_100
825: , p5_a9 JTF_VARCHAR2_TABLE_100
826: , p5_a10 JTF_NUMBER_TABLE
827: , p5_a11 JTF_NUMBER_TABLE

Line 824: , p5_a8 JTF_VARCHAR2_TABLE_100

820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_VARCHAR2_TABLE_100
824: , p5_a8 JTF_VARCHAR2_TABLE_100
825: , p5_a9 JTF_VARCHAR2_TABLE_100
826: , p5_a10 JTF_NUMBER_TABLE
827: , p5_a11 JTF_NUMBER_TABLE
828: , p5_a12 JTF_NUMBER_TABLE

Line 825: , p5_a9 JTF_VARCHAR2_TABLE_100

821: , p5_a5 JTF_VARCHAR2_TABLE_100
822: , p5_a6 JTF_VARCHAR2_TABLE_100
823: , p5_a7 JTF_VARCHAR2_TABLE_100
824: , p5_a8 JTF_VARCHAR2_TABLE_100
825: , p5_a9 JTF_VARCHAR2_TABLE_100
826: , p5_a10 JTF_NUMBER_TABLE
827: , p5_a11 JTF_NUMBER_TABLE
828: , p5_a12 JTF_NUMBER_TABLE
829: , p5_a13 JTF_NUMBER_TABLE

Line 830: , p5_a14 JTF_VARCHAR2_TABLE_100

826: , p5_a10 JTF_NUMBER_TABLE
827: , p5_a11 JTF_NUMBER_TABLE
828: , p5_a12 JTF_NUMBER_TABLE
829: , p5_a13 JTF_NUMBER_TABLE
830: , p5_a14 JTF_VARCHAR2_TABLE_100
831: , p5_a15 JTF_VARCHAR2_TABLE_500
832: , p5_a16 JTF_VARCHAR2_TABLE_500
833: , p5_a17 JTF_VARCHAR2_TABLE_500
834: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 852: , p5_a36 JTF_VARCHAR2_TABLE_100

848: , p5_a32 JTF_NUMBER_TABLE
849: , p5_a33 JTF_DATE_TABLE
850: , p5_a34 JTF_NUMBER_TABLE
851: , p5_a35 JTF_NUMBER_TABLE
852: , p5_a36 JTF_VARCHAR2_TABLE_100
853: , p5_a37 JTF_VARCHAR2_TABLE_100
854: , p5_a38 JTF_DATE_TABLE
855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 853: , p5_a37 JTF_VARCHAR2_TABLE_100

849: , p5_a33 JTF_DATE_TABLE
850: , p5_a34 JTF_NUMBER_TABLE
851: , p5_a35 JTF_NUMBER_TABLE
852: , p5_a36 JTF_VARCHAR2_TABLE_100
853: , p5_a37 JTF_VARCHAR2_TABLE_100
854: , p5_a38 JTF_DATE_TABLE
855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100
857: , p5_a41 JTF_VARCHAR2_TABLE_100

Line 856: , p5_a40 JTF_VARCHAR2_TABLE_100

852: , p5_a36 JTF_VARCHAR2_TABLE_100
853: , p5_a37 JTF_VARCHAR2_TABLE_100
854: , p5_a38 JTF_DATE_TABLE
855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100
857: , p5_a41 JTF_VARCHAR2_TABLE_100
858: , p5_a42 JTF_VARCHAR2_TABLE_100
859: , p5_a43 JTF_VARCHAR2_TABLE_100
860: );

Line 857: , p5_a41 JTF_VARCHAR2_TABLE_100

853: , p5_a37 JTF_VARCHAR2_TABLE_100
854: , p5_a38 JTF_DATE_TABLE
855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100
857: , p5_a41 JTF_VARCHAR2_TABLE_100
858: , p5_a42 JTF_VARCHAR2_TABLE_100
859: , p5_a43 JTF_VARCHAR2_TABLE_100
860: );
861: end okl_tbc_pvt_w;

Line 858: , p5_a42 JTF_VARCHAR2_TABLE_100

854: , p5_a38 JTF_DATE_TABLE
855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100
857: , p5_a41 JTF_VARCHAR2_TABLE_100
858: , p5_a42 JTF_VARCHAR2_TABLE_100
859: , p5_a43 JTF_VARCHAR2_TABLE_100
860: );
861: end okl_tbc_pvt_w;

Line 859: , p5_a43 JTF_VARCHAR2_TABLE_100

855: , p5_a39 JTF_DATE_TABLE
856: , p5_a40 JTF_VARCHAR2_TABLE_100
857: , p5_a41 JTF_VARCHAR2_TABLE_100
858: , p5_a42 JTF_VARCHAR2_TABLE_100
859: , p5_a43 JTF_VARCHAR2_TABLE_100
860: );
861: end okl_tbc_pvt_w;