APPS.JTA_SYNC_TASK_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

2: /* $Header: jtavstws.pls 120.2 2006/04/27 01:09 deeprao ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000

Line 13: , a10 JTF_DATE_TABLE

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE

Line 14: , a11 JTF_DATE_TABLE

10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE

Line 15: , a12 JTF_DATE_TABLE

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

Line 16: , a13 JTF_DATE_TABLE

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

Line 17: , a14 JTF_DATE_TABLE

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

Line 18: , a15 JTF_DATE_TABLE

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

Line 22: , a19 JTF_DATE_TABLE

18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_2000

Line 33: , a30 JTF_DATE_TABLE

29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_VARCHAR2_TABLE_2000
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100

Line 34: , a31 JTF_DATE_TABLE

30: , a27 JTF_VARCHAR2_TABLE_2000
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100

Line 48: , a3 out nocopy JTF_DATE_TABLE

44: );
45: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: , a3 out nocopy JTF_DATE_TABLE
49: , a4 out nocopy JTF_NUMBER_TABLE
50: , a5 out nocopy JTF_VARCHAR2_TABLE_100
51: , a6 out nocopy JTF_VARCHAR2_TABLE_100
52: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 55: , a10 out nocopy JTF_DATE_TABLE

51: , a6 out nocopy JTF_VARCHAR2_TABLE_100
52: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
54: , a9 out nocopy JTF_VARCHAR2_TABLE_100
55: , a10 out nocopy JTF_DATE_TABLE
56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE

Line 56: , a11 out nocopy JTF_DATE_TABLE

52: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
54: , a9 out nocopy JTF_VARCHAR2_TABLE_100
55: , a10 out nocopy JTF_DATE_TABLE
56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE
60: , a15 out nocopy JTF_DATE_TABLE

Line 57: , a12 out nocopy JTF_DATE_TABLE

53: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
54: , a9 out nocopy JTF_VARCHAR2_TABLE_100
55: , a10 out nocopy JTF_DATE_TABLE
56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE
60: , a15 out nocopy JTF_DATE_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE

Line 58: , a13 out nocopy JTF_DATE_TABLE

54: , a9 out nocopy JTF_VARCHAR2_TABLE_100
55: , a10 out nocopy JTF_DATE_TABLE
56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE
60: , a15 out nocopy JTF_DATE_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE

Line 59: , a14 out nocopy JTF_DATE_TABLE

55: , a10 out nocopy JTF_DATE_TABLE
56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE
60: , a15 out nocopy JTF_DATE_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE
63: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a15 out nocopy JTF_DATE_TABLE

56: , a11 out nocopy JTF_DATE_TABLE
57: , a12 out nocopy JTF_DATE_TABLE
58: , a13 out nocopy JTF_DATE_TABLE
59: , a14 out nocopy JTF_DATE_TABLE
60: , a15 out nocopy JTF_DATE_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE
63: , a18 out nocopy JTF_VARCHAR2_TABLE_100
64: , a19 out nocopy JTF_DATE_TABLE

Line 64: , a19 out nocopy JTF_DATE_TABLE

60: , a15 out nocopy JTF_DATE_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE
63: , a18 out nocopy JTF_VARCHAR2_TABLE_100
64: , a19 out nocopy JTF_DATE_TABLE
65: , a20 out nocopy JTF_VARCHAR2_TABLE_100
66: , a21 out nocopy JTF_VARCHAR2_TABLE_300
67: , a22 out nocopy JTF_NUMBER_TABLE
68: , a23 out nocopy JTF_VARCHAR2_TABLE_2000

Line 75: , a30 out nocopy JTF_DATE_TABLE

71: , a26 out nocopy JTF_VARCHAR2_TABLE_300
72: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a28 out nocopy JTF_VARCHAR2_TABLE_100
74: , a29 out nocopy JTF_NUMBER_TABLE
75: , a30 out nocopy JTF_DATE_TABLE
76: , a31 out nocopy JTF_DATE_TABLE
77: , a32 out nocopy JTF_VARCHAR2_TABLE_100
78: , a33 out nocopy JTF_VARCHAR2_TABLE_100
79: , a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a31 out nocopy JTF_DATE_TABLE

72: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a28 out nocopy JTF_VARCHAR2_TABLE_100
74: , a29 out nocopy JTF_NUMBER_TABLE
75: , a30 out nocopy JTF_DATE_TABLE
76: , a31 out nocopy JTF_DATE_TABLE
77: , a32 out nocopy JTF_VARCHAR2_TABLE_100
78: , a33 out nocopy JTF_VARCHAR2_TABLE_100
79: , a34 out nocopy JTF_VARCHAR2_TABLE_100
80: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , a1 JTF_DATE_TABLE

85: , a40 out nocopy JTF_NUMBER_TABLE
86: );
87:
88: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
89: , a1 JTF_DATE_TABLE
90: );
91: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_DATE_TABLE
93: );

Line 92: , a1 out nocopy JTF_DATE_TABLE

88: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
89: , a1 JTF_DATE_TABLE
90: );
91: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_DATE_TABLE
93: );
94:
95: procedure get_count(p_request_type VARCHAR2
96: , p_syncanchor date

Line 107: , p2_a3 out nocopy JTF_DATE_TABLE

103: , p_syncanchor date
104: , p2_a0 out nocopy JTF_NUMBER_TABLE
105: , p2_a1 out nocopy JTF_NUMBER_TABLE
106: , p2_a2 out nocopy JTF_NUMBER_TABLE
107: , p2_a3 out nocopy JTF_DATE_TABLE
108: , p2_a4 out nocopy JTF_NUMBER_TABLE
109: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
110: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 114: , p2_a10 out nocopy JTF_DATE_TABLE

110: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_2000
112: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_4000
113: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , p2_a10 out nocopy JTF_DATE_TABLE
115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE

Line 115: , p2_a11 out nocopy JTF_DATE_TABLE

111: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_2000
112: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_4000
113: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , p2_a10 out nocopy JTF_DATE_TABLE
115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE
119: , p2_a15 out nocopy JTF_DATE_TABLE

Line 116: , p2_a12 out nocopy JTF_DATE_TABLE

112: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_4000
113: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , p2_a10 out nocopy JTF_DATE_TABLE
115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE
119: , p2_a15 out nocopy JTF_DATE_TABLE
120: , p2_a16 out nocopy JTF_NUMBER_TABLE

Line 117: , p2_a13 out nocopy JTF_DATE_TABLE

113: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , p2_a10 out nocopy JTF_DATE_TABLE
115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE
119: , p2_a15 out nocopy JTF_DATE_TABLE
120: , p2_a16 out nocopy JTF_NUMBER_TABLE
121: , p2_a17 out nocopy JTF_NUMBER_TABLE

Line 118: , p2_a14 out nocopy JTF_DATE_TABLE

114: , p2_a10 out nocopy JTF_DATE_TABLE
115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE
119: , p2_a15 out nocopy JTF_DATE_TABLE
120: , p2_a16 out nocopy JTF_NUMBER_TABLE
121: , p2_a17 out nocopy JTF_NUMBER_TABLE
122: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , p2_a15 out nocopy JTF_DATE_TABLE

115: , p2_a11 out nocopy JTF_DATE_TABLE
116: , p2_a12 out nocopy JTF_DATE_TABLE
117: , p2_a13 out nocopy JTF_DATE_TABLE
118: , p2_a14 out nocopy JTF_DATE_TABLE
119: , p2_a15 out nocopy JTF_DATE_TABLE
120: , p2_a16 out nocopy JTF_NUMBER_TABLE
121: , p2_a17 out nocopy JTF_NUMBER_TABLE
122: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
123: , p2_a19 out nocopy JTF_DATE_TABLE

Line 123: , p2_a19 out nocopy JTF_DATE_TABLE

119: , p2_a15 out nocopy JTF_DATE_TABLE
120: , p2_a16 out nocopy JTF_NUMBER_TABLE
121: , p2_a17 out nocopy JTF_NUMBER_TABLE
122: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
123: , p2_a19 out nocopy JTF_DATE_TABLE
124: , p2_a20 out nocopy JTF_VARCHAR2_TABLE_100
125: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_300
126: , p2_a22 out nocopy JTF_NUMBER_TABLE
127: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_2000

Line 134: , p2_a30 out nocopy JTF_DATE_TABLE

130: , p2_a26 out nocopy JTF_VARCHAR2_TABLE_300
131: , p2_a27 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p2_a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , p2_a29 out nocopy JTF_NUMBER_TABLE
134: , p2_a30 out nocopy JTF_DATE_TABLE
135: , p2_a31 out nocopy JTF_DATE_TABLE
136: , p2_a32 out nocopy JTF_VARCHAR2_TABLE_100
137: , p2_a33 out nocopy JTF_VARCHAR2_TABLE_100
138: , p2_a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , p2_a31 out nocopy JTF_DATE_TABLE

131: , p2_a27 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p2_a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , p2_a29 out nocopy JTF_NUMBER_TABLE
134: , p2_a30 out nocopy JTF_DATE_TABLE
135: , p2_a31 out nocopy JTF_DATE_TABLE
136: , p2_a32 out nocopy JTF_VARCHAR2_TABLE_100
137: , p2_a33 out nocopy JTF_VARCHAR2_TABLE_100
138: , p2_a34 out nocopy JTF_VARCHAR2_TABLE_100
139: , p2_a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , p3_a1 out nocopy JTF_DATE_TABLE

142: , p2_a38 out nocopy JTF_VARCHAR2_TABLE_100
143: , p2_a39 out nocopy JTF_NUMBER_TABLE
144: , p2_a40 out nocopy JTF_NUMBER_TABLE
145: , p3_a0 out nocopy JTF_NUMBER_TABLE
146: , p3_a1 out nocopy JTF_DATE_TABLE
147: );
148: procedure create_ids(p_num_req NUMBER
149: , p1_a0 in out nocopy JTF_NUMBER_TABLE
150: , p1_a1 in out nocopy JTF_NUMBER_TABLE

Line 152: , p1_a3 in out nocopy JTF_DATE_TABLE

148: procedure create_ids(p_num_req NUMBER
149: , p1_a0 in out nocopy JTF_NUMBER_TABLE
150: , p1_a1 in out nocopy JTF_NUMBER_TABLE
151: , p1_a2 in out nocopy JTF_NUMBER_TABLE
152: , p1_a3 in out nocopy JTF_DATE_TABLE
153: , p1_a4 in out nocopy JTF_NUMBER_TABLE
154: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 159: , p1_a10 in out nocopy JTF_DATE_TABLE

155: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
157: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
158: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p1_a10 in out nocopy JTF_DATE_TABLE
160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE

Line 160: , p1_a11 in out nocopy JTF_DATE_TABLE

156: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
157: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
158: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p1_a10 in out nocopy JTF_DATE_TABLE
160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE
164: , p1_a15 in out nocopy JTF_DATE_TABLE

Line 161: , p1_a12 in out nocopy JTF_DATE_TABLE

157: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
158: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p1_a10 in out nocopy JTF_DATE_TABLE
160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE
164: , p1_a15 in out nocopy JTF_DATE_TABLE
165: , p1_a16 in out nocopy JTF_NUMBER_TABLE

Line 162: , p1_a13 in out nocopy JTF_DATE_TABLE

158: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p1_a10 in out nocopy JTF_DATE_TABLE
160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE
164: , p1_a15 in out nocopy JTF_DATE_TABLE
165: , p1_a16 in out nocopy JTF_NUMBER_TABLE
166: , p1_a17 in out nocopy JTF_NUMBER_TABLE

Line 163: , p1_a14 in out nocopy JTF_DATE_TABLE

159: , p1_a10 in out nocopy JTF_DATE_TABLE
160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE
164: , p1_a15 in out nocopy JTF_DATE_TABLE
165: , p1_a16 in out nocopy JTF_NUMBER_TABLE
166: , p1_a17 in out nocopy JTF_NUMBER_TABLE
167: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , p1_a15 in out nocopy JTF_DATE_TABLE

160: , p1_a11 in out nocopy JTF_DATE_TABLE
161: , p1_a12 in out nocopy JTF_DATE_TABLE
162: , p1_a13 in out nocopy JTF_DATE_TABLE
163: , p1_a14 in out nocopy JTF_DATE_TABLE
164: , p1_a15 in out nocopy JTF_DATE_TABLE
165: , p1_a16 in out nocopy JTF_NUMBER_TABLE
166: , p1_a17 in out nocopy JTF_NUMBER_TABLE
167: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p1_a19 in out nocopy JTF_DATE_TABLE

Line 168: , p1_a19 in out nocopy JTF_DATE_TABLE

164: , p1_a15 in out nocopy JTF_DATE_TABLE
165: , p1_a16 in out nocopy JTF_NUMBER_TABLE
166: , p1_a17 in out nocopy JTF_NUMBER_TABLE
167: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p1_a19 in out nocopy JTF_DATE_TABLE
169: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
171: , p1_a22 in out nocopy JTF_NUMBER_TABLE
172: , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 179: , p1_a30 in out nocopy JTF_DATE_TABLE

175: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
176: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
177: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p1_a29 in out nocopy JTF_NUMBER_TABLE
179: , p1_a30 in out nocopy JTF_DATE_TABLE
180: , p1_a31 in out nocopy JTF_DATE_TABLE
181: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 180: , p1_a31 in out nocopy JTF_DATE_TABLE

176: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
177: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p1_a29 in out nocopy JTF_NUMBER_TABLE
179: , p1_a30 in out nocopy JTF_DATE_TABLE
180: , p1_a31 in out nocopy JTF_DATE_TABLE
181: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100

Line 194: , p0_a3 in out nocopy JTF_DATE_TABLE

190: );
191: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
192: , p0_a1 in out nocopy JTF_NUMBER_TABLE
193: , p0_a2 in out nocopy JTF_NUMBER_TABLE
194: , p0_a3 in out nocopy JTF_DATE_TABLE
195: , p0_a4 in out nocopy JTF_NUMBER_TABLE
196: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
197: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 201: , p0_a10 in out nocopy JTF_DATE_TABLE

197: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
199: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
200: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p0_a10 in out nocopy JTF_DATE_TABLE
202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE

Line 202: , p0_a11 in out nocopy JTF_DATE_TABLE

198: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
199: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
200: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p0_a10 in out nocopy JTF_DATE_TABLE
202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE
206: , p0_a15 in out nocopy JTF_DATE_TABLE

Line 203: , p0_a12 in out nocopy JTF_DATE_TABLE

199: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
200: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p0_a10 in out nocopy JTF_DATE_TABLE
202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE
206: , p0_a15 in out nocopy JTF_DATE_TABLE
207: , p0_a16 in out nocopy JTF_NUMBER_TABLE

Line 204: , p0_a13 in out nocopy JTF_DATE_TABLE

200: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p0_a10 in out nocopy JTF_DATE_TABLE
202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE
206: , p0_a15 in out nocopy JTF_DATE_TABLE
207: , p0_a16 in out nocopy JTF_NUMBER_TABLE
208: , p0_a17 in out nocopy JTF_NUMBER_TABLE

Line 205: , p0_a14 in out nocopy JTF_DATE_TABLE

201: , p0_a10 in out nocopy JTF_DATE_TABLE
202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE
206: , p0_a15 in out nocopy JTF_DATE_TABLE
207: , p0_a16 in out nocopy JTF_NUMBER_TABLE
208: , p0_a17 in out nocopy JTF_NUMBER_TABLE
209: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 206: , p0_a15 in out nocopy JTF_DATE_TABLE

202: , p0_a11 in out nocopy JTF_DATE_TABLE
203: , p0_a12 in out nocopy JTF_DATE_TABLE
204: , p0_a13 in out nocopy JTF_DATE_TABLE
205: , p0_a14 in out nocopy JTF_DATE_TABLE
206: , p0_a15 in out nocopy JTF_DATE_TABLE
207: , p0_a16 in out nocopy JTF_NUMBER_TABLE
208: , p0_a17 in out nocopy JTF_NUMBER_TABLE
209: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p0_a19 in out nocopy JTF_DATE_TABLE

Line 210: , p0_a19 in out nocopy JTF_DATE_TABLE

206: , p0_a15 in out nocopy JTF_DATE_TABLE
207: , p0_a16 in out nocopy JTF_NUMBER_TABLE
208: , p0_a17 in out nocopy JTF_NUMBER_TABLE
209: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p0_a19 in out nocopy JTF_DATE_TABLE
211: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
213: , p0_a22 in out nocopy JTF_NUMBER_TABLE
214: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 221: , p0_a30 in out nocopy JTF_DATE_TABLE

217: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
218: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
219: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p0_a29 in out nocopy JTF_NUMBER_TABLE
221: , p0_a30 in out nocopy JTF_DATE_TABLE
222: , p0_a31 in out nocopy JTF_DATE_TABLE
223: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 222: , p0_a31 in out nocopy JTF_DATE_TABLE

218: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
219: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p0_a29 in out nocopy JTF_NUMBER_TABLE
221: , p0_a30 in out nocopy JTF_DATE_TABLE
222: , p0_a31 in out nocopy JTF_DATE_TABLE
223: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
226: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100

Line 233: , p1_a1 JTF_DATE_TABLE

229: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p0_a39 in out nocopy JTF_NUMBER_TABLE
231: , p0_a40 in out nocopy JTF_NUMBER_TABLE
232: , p1_a0 JTF_NUMBER_TABLE
233: , p1_a1 JTF_DATE_TABLE
234: );
235: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
236: , p0_a1 in out nocopy JTF_NUMBER_TABLE
237: , p0_a2 in out nocopy JTF_NUMBER_TABLE

Line 238: , p0_a3 in out nocopy JTF_DATE_TABLE

234: );
235: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
236: , p0_a1 in out nocopy JTF_NUMBER_TABLE
237: , p0_a2 in out nocopy JTF_NUMBER_TABLE
238: , p0_a3 in out nocopy JTF_DATE_TABLE
239: , p0_a4 in out nocopy JTF_NUMBER_TABLE
240: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
241: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
242: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 245: , p0_a10 in out nocopy JTF_DATE_TABLE

241: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
242: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
243: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
244: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p0_a10 in out nocopy JTF_DATE_TABLE
246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE

Line 246: , p0_a11 in out nocopy JTF_DATE_TABLE

242: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
243: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
244: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p0_a10 in out nocopy JTF_DATE_TABLE
246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE
250: , p0_a15 in out nocopy JTF_DATE_TABLE

Line 247: , p0_a12 in out nocopy JTF_DATE_TABLE

243: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
244: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p0_a10 in out nocopy JTF_DATE_TABLE
246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE
250: , p0_a15 in out nocopy JTF_DATE_TABLE
251: , p0_a16 in out nocopy JTF_NUMBER_TABLE

Line 248: , p0_a13 in out nocopy JTF_DATE_TABLE

244: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p0_a10 in out nocopy JTF_DATE_TABLE
246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE
250: , p0_a15 in out nocopy JTF_DATE_TABLE
251: , p0_a16 in out nocopy JTF_NUMBER_TABLE
252: , p0_a17 in out nocopy JTF_NUMBER_TABLE

Line 249: , p0_a14 in out nocopy JTF_DATE_TABLE

245: , p0_a10 in out nocopy JTF_DATE_TABLE
246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE
250: , p0_a15 in out nocopy JTF_DATE_TABLE
251: , p0_a16 in out nocopy JTF_NUMBER_TABLE
252: , p0_a17 in out nocopy JTF_NUMBER_TABLE
253: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 250: , p0_a15 in out nocopy JTF_DATE_TABLE

246: , p0_a11 in out nocopy JTF_DATE_TABLE
247: , p0_a12 in out nocopy JTF_DATE_TABLE
248: , p0_a13 in out nocopy JTF_DATE_TABLE
249: , p0_a14 in out nocopy JTF_DATE_TABLE
250: , p0_a15 in out nocopy JTF_DATE_TABLE
251: , p0_a16 in out nocopy JTF_NUMBER_TABLE
252: , p0_a17 in out nocopy JTF_NUMBER_TABLE
253: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p0_a19 in out nocopy JTF_DATE_TABLE

Line 254: , p0_a19 in out nocopy JTF_DATE_TABLE

250: , p0_a15 in out nocopy JTF_DATE_TABLE
251: , p0_a16 in out nocopy JTF_NUMBER_TABLE
252: , p0_a17 in out nocopy JTF_NUMBER_TABLE
253: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p0_a19 in out nocopy JTF_DATE_TABLE
255: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
256: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
257: , p0_a22 in out nocopy JTF_NUMBER_TABLE
258: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 265: , p0_a30 in out nocopy JTF_DATE_TABLE

261: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
262: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
263: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
264: , p0_a29 in out nocopy JTF_NUMBER_TABLE
265: , p0_a30 in out nocopy JTF_DATE_TABLE
266: , p0_a31 in out nocopy JTF_DATE_TABLE
267: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p0_a31 in out nocopy JTF_DATE_TABLE

262: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
263: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
264: , p0_a29 in out nocopy JTF_NUMBER_TABLE
265: , p0_a30 in out nocopy JTF_DATE_TABLE
266: , p0_a31 in out nocopy JTF_DATE_TABLE
267: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100