12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: ) as
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p1;
85: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
82: end if;
83: end if;
84: end rosetta_table_copy_in_p1;
85: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
84: end rosetta_table_copy_in_p1;
85: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
90: , a5 out nocopy JTF_NUMBER_TABLE
91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
110: , a25 out nocopy JTF_VARCHAR2_TABLE_100
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
110: , a25 out nocopy JTF_VARCHAR2_TABLE_100
111: ) as
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
110: , a25 out nocopy JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
110: , a25 out nocopy JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
167: a25 := JTF_VARCHAR2_TABLE_100();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
167: a25 := JTF_VARCHAR2_TABLE_100();
168: if t.count > 0 then
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
167: a25 := JTF_VARCHAR2_TABLE_100();
168: if t.count > 0 then
169: a0.extend(t.count);
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
167: a25 := JTF_VARCHAR2_TABLE_100();
168: if t.count > 0 then
169: a0.extend(t.count);
170: a1.extend(t.count);
230: end if;
231: end if;
232: end rosetta_table_copy_out_p1;
233:
234: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE
231: end if;
232: end rosetta_table_copy_out_p1;
233:
234: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE
239: , a5 JTF_DATE_TABLE
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE
239: , a5 JTF_DATE_TABLE
240: , a6 JTF_VARCHAR2_TABLE_100
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_VARCHAR2_TABLE_100
243: ) as
244: ddindx binary_integer; indx binary_integer;
245: begin
265: end loop;
266: end if;
267: end if;
268: end rosetta_table_copy_in_p4;
269: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_VARCHAR2_TABLE_100
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE
266: end if;
267: end if;
268: end rosetta_table_copy_in_p4;
269: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_VARCHAR2_TABLE_100
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_DATE_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_DATE_TABLE
275: , a6 out nocopy JTF_VARCHAR2_TABLE_100
276: , a7 out nocopy JTF_NUMBER_TABLE
277: , a8 out nocopy JTF_VARCHAR2_TABLE_100
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_300();
286: a4 := JTF_DATE_TABLE();
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_300();
286: a4 := JTF_DATE_TABLE();
287: a5 := JTF_DATE_TABLE();
285: a3 := JTF_VARCHAR2_TABLE_300();
286: a4 := JTF_DATE_TABLE();
287: a5 := JTF_DATE_TABLE();
288: a6 := JTF_VARCHAR2_TABLE_100();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
288: a6 := JTF_VARCHAR2_TABLE_100();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_100();
295: a3 := JTF_VARCHAR2_TABLE_300();
296: a4 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_100();
295: a3 := JTF_VARCHAR2_TABLE_300();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_DATE_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_300();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_DATE_TABLE();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then
302: a0.extend(t.count);
303: a1.extend(t.count);
329: end if;
330: end if;
331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
330: end if;
331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if a0 is not null and a0.count > 0 then
350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p6;
354: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin
351: end if;
352: end if;
353: end rosetta_table_copy_in_p6;
354: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: else
363: a0 := JTF_NUMBER_TABLE();
364: a1 := JTF_NUMBER_TABLE();
357: ddindx binary_integer; indx binary_integer;
358: begin
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: else
363: a0 := JTF_NUMBER_TABLE();
364: a1 := JTF_NUMBER_TABLE();
365: if t.count > 0 then
359: if t is null or t.count = 0 then
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: else
363: a0 := JTF_NUMBER_TABLE();
364: a1 := JTF_NUMBER_TABLE();
365: if t.count > 0 then
366: a0.extend(t.count);
367: a1.extend(t.count);
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_NUMBER_TABLE();
362: else
363: a0 := JTF_NUMBER_TABLE();
364: a1 := JTF_NUMBER_TABLE();
365: if t.count > 0 then
366: a0.extend(t.count);
367: a1.extend(t.count);
368: ddindx := t.first;
518: , p_validation_level NUMBER
519: , x_return_status out nocopy VARCHAR2
520: , x_msg_data out nocopy VARCHAR2
521: , x_msg_count out nocopy NUMBER
522: , p7_a0 JTF_NUMBER_TABLE
523: , p7_a1 JTF_NUMBER_TABLE
524: , p7_a2 JTF_DATE_TABLE
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
519: , x_return_status out nocopy VARCHAR2
520: , x_msg_data out nocopy VARCHAR2
521: , x_msg_count out nocopy NUMBER
522: , p7_a0 JTF_NUMBER_TABLE
523: , p7_a1 JTF_NUMBER_TABLE
524: , p7_a2 JTF_DATE_TABLE
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
521: , x_msg_count out nocopy NUMBER
522: , p7_a0 JTF_NUMBER_TABLE
523: , p7_a1 JTF_NUMBER_TABLE
524: , p7_a2 JTF_DATE_TABLE
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
523: , p7_a1 JTF_NUMBER_TABLE
524: , p7_a2 JTF_DATE_TABLE
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
530: , p7_a8 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
524: , p7_a2 JTF_DATE_TABLE
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
530: , p7_a8 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
525: , p7_a3 JTF_NUMBER_TABLE
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
530: , p7_a8 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
533: , p7_a11 JTF_VARCHAR2_TABLE_100
526: , p7_a4 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
530: , p7_a8 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
533: , p7_a11 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
527: , p7_a5 JTF_NUMBER_TABLE
528: , p7_a6 JTF_NUMBER_TABLE
529: , p7_a7 JTF_NUMBER_TABLE
530: , p7_a8 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
533: , p7_a11 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
531: , p7_a9 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
533: , p7_a11 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
532: , p7_a10 JTF_VARCHAR2_TABLE_100
533: , p7_a11 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
533: , p7_a11 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
534: , p7_a12 JTF_DATE_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
535: , p7_a13 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
536: , p7_a14 JTF_NUMBER_TABLE
537: , p7_a15 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
538: , p7_a16 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
545: , p7_a23 JTF_NUMBER_TABLE
546: , p7_a24 JTF_NUMBER_TABLE
539: , p7_a17 JTF_NUMBER_TABLE
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
545: , p7_a23 JTF_NUMBER_TABLE
546: , p7_a24 JTF_NUMBER_TABLE
547: , p7_a25 JTF_VARCHAR2_TABLE_100
540: , p7_a18 JTF_NUMBER_TABLE
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
545: , p7_a23 JTF_NUMBER_TABLE
546: , p7_a24 JTF_NUMBER_TABLE
547: , p7_a25 JTF_VARCHAR2_TABLE_100
548: , p_mode VARCHAR2
541: , p7_a19 JTF_VARCHAR2_TABLE_100
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
545: , p7_a23 JTF_NUMBER_TABLE
546: , p7_a24 JTF_NUMBER_TABLE
547: , p7_a25 JTF_VARCHAR2_TABLE_100
548: , p_mode VARCHAR2
549: , x_error_index out nocopy NUMBER
542: , p7_a20 JTF_NUMBER_TABLE
543: , p7_a21 JTF_NUMBER_TABLE
544: , p7_a22 JTF_NUMBER_TABLE
545: , p7_a23 JTF_NUMBER_TABLE
546: , p7_a24 JTF_NUMBER_TABLE
547: , p7_a25 JTF_VARCHAR2_TABLE_100
548: , p_mode VARCHAR2
549: , x_error_index out nocopy NUMBER
550: )
725: , p_validation_level NUMBER
726: , x_return_status out nocopy VARCHAR2
727: , x_msg_data out nocopy VARCHAR2
728: , x_msg_count out nocopy NUMBER
729: , p7_a0 JTF_NUMBER_TABLE
730: , p7_a1 JTF_NUMBER_TABLE
731: , p7_a2 JTF_DATE_TABLE
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
726: , x_return_status out nocopy VARCHAR2
727: , x_msg_data out nocopy VARCHAR2
728: , x_msg_count out nocopy NUMBER
729: , p7_a0 JTF_NUMBER_TABLE
730: , p7_a1 JTF_NUMBER_TABLE
731: , p7_a2 JTF_DATE_TABLE
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
728: , x_msg_count out nocopy NUMBER
729: , p7_a0 JTF_NUMBER_TABLE
730: , p7_a1 JTF_NUMBER_TABLE
731: , p7_a2 JTF_DATE_TABLE
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
730: , p7_a1 JTF_NUMBER_TABLE
731: , p7_a2 JTF_DATE_TABLE
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
737: , p7_a8 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
731: , p7_a2 JTF_DATE_TABLE
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
737: , p7_a8 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
732: , p7_a3 JTF_NUMBER_TABLE
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
737: , p7_a8 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
740: , p7_a11 JTF_VARCHAR2_TABLE_100
733: , p7_a4 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
737: , p7_a8 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
740: , p7_a11 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
734: , p7_a5 JTF_NUMBER_TABLE
735: , p7_a6 JTF_NUMBER_TABLE
736: , p7_a7 JTF_NUMBER_TABLE
737: , p7_a8 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
740: , p7_a11 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
738: , p7_a9 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
740: , p7_a11 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
739: , p7_a10 JTF_VARCHAR2_TABLE_100
740: , p7_a11 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
740: , p7_a11 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
741: , p7_a12 JTF_DATE_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
742: , p7_a13 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
743: , p7_a14 JTF_NUMBER_TABLE
744: , p7_a15 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
745: , p7_a16 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
752: , p7_a23 JTF_NUMBER_TABLE
753: , p7_a24 JTF_NUMBER_TABLE
746: , p7_a17 JTF_NUMBER_TABLE
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
752: , p7_a23 JTF_NUMBER_TABLE
753: , p7_a24 JTF_NUMBER_TABLE
754: , p7_a25 JTF_VARCHAR2_TABLE_100
747: , p7_a18 JTF_NUMBER_TABLE
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
752: , p7_a23 JTF_NUMBER_TABLE
753: , p7_a24 JTF_NUMBER_TABLE
754: , p7_a25 JTF_VARCHAR2_TABLE_100
755: , p_mode VARCHAR2
748: , p7_a19 JTF_VARCHAR2_TABLE_100
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
752: , p7_a23 JTF_NUMBER_TABLE
753: , p7_a24 JTF_NUMBER_TABLE
754: , p7_a25 JTF_VARCHAR2_TABLE_100
755: , p_mode VARCHAR2
756: , x_error_index out nocopy NUMBER
749: , p7_a20 JTF_NUMBER_TABLE
750: , p7_a21 JTF_NUMBER_TABLE
751: , p7_a22 JTF_NUMBER_TABLE
752: , p7_a23 JTF_NUMBER_TABLE
753: , p7_a24 JTF_NUMBER_TABLE
754: , p7_a25 JTF_VARCHAR2_TABLE_100
755: , p_mode VARCHAR2
756: , x_error_index out nocopy NUMBER
757: )
932: , p_validation_level NUMBER
933: , x_return_status out nocopy VARCHAR2
934: , x_msg_data out nocopy VARCHAR2
935: , x_msg_count out nocopy NUMBER
936: , p7_a0 JTF_NUMBER_TABLE
937: , p7_a1 JTF_NUMBER_TABLE
938: , p7_a2 JTF_DATE_TABLE
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
933: , x_return_status out nocopy VARCHAR2
934: , x_msg_data out nocopy VARCHAR2
935: , x_msg_count out nocopy NUMBER
936: , p7_a0 JTF_NUMBER_TABLE
937: , p7_a1 JTF_NUMBER_TABLE
938: , p7_a2 JTF_DATE_TABLE
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
935: , x_msg_count out nocopy NUMBER
936: , p7_a0 JTF_NUMBER_TABLE
937: , p7_a1 JTF_NUMBER_TABLE
938: , p7_a2 JTF_DATE_TABLE
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
937: , p7_a1 JTF_NUMBER_TABLE
938: , p7_a2 JTF_DATE_TABLE
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
944: , p7_a8 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
938: , p7_a2 JTF_DATE_TABLE
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
944: , p7_a8 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
939: , p7_a3 JTF_NUMBER_TABLE
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
944: , p7_a8 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
947: , p7_a11 JTF_VARCHAR2_TABLE_100
940: , p7_a4 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
944: , p7_a8 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
947: , p7_a11 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
941: , p7_a5 JTF_NUMBER_TABLE
942: , p7_a6 JTF_NUMBER_TABLE
943: , p7_a7 JTF_NUMBER_TABLE
944: , p7_a8 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
947: , p7_a11 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
945: , p7_a9 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
947: , p7_a11 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
946: , p7_a10 JTF_VARCHAR2_TABLE_100
947: , p7_a11 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
947: , p7_a11 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
948: , p7_a12 JTF_DATE_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
949: , p7_a13 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
950: , p7_a14 JTF_NUMBER_TABLE
951: , p7_a15 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
952: , p7_a16 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
959: , p7_a23 JTF_NUMBER_TABLE
960: , p7_a24 JTF_NUMBER_TABLE
953: , p7_a17 JTF_NUMBER_TABLE
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
959: , p7_a23 JTF_NUMBER_TABLE
960: , p7_a24 JTF_NUMBER_TABLE
961: , p7_a25 JTF_VARCHAR2_TABLE_100
954: , p7_a18 JTF_NUMBER_TABLE
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
959: , p7_a23 JTF_NUMBER_TABLE
960: , p7_a24 JTF_NUMBER_TABLE
961: , p7_a25 JTF_VARCHAR2_TABLE_100
962: , p_mode VARCHAR2
955: , p7_a19 JTF_VARCHAR2_TABLE_100
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
959: , p7_a23 JTF_NUMBER_TABLE
960: , p7_a24 JTF_NUMBER_TABLE
961: , p7_a25 JTF_VARCHAR2_TABLE_100
962: , p_mode VARCHAR2
963: , x_error_index out nocopy NUMBER
956: , p7_a20 JTF_NUMBER_TABLE
957: , p7_a21 JTF_NUMBER_TABLE
958: , p7_a22 JTF_NUMBER_TABLE
959: , p7_a23 JTF_NUMBER_TABLE
960: , p7_a24 JTF_NUMBER_TABLE
961: , p7_a25 JTF_VARCHAR2_TABLE_100
962: , p_mode VARCHAR2
963: , x_error_index out nocopy NUMBER
964: )
2544: , p_offer_id NUMBER
2545: , p_resale_flag VARCHAR2
2546: , p_check_all_flag VARCHAR2
2547: , x_performance_flag out nocopy VARCHAR2
2548: , p5_a0 out nocopy JTF_NUMBER_TABLE
2549: , p5_a1 out nocopy JTF_NUMBER_TABLE
2550: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2551: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
2552: , p5_a4 out nocopy JTF_DATE_TABLE
2545: , p_resale_flag VARCHAR2
2546: , p_check_all_flag VARCHAR2
2547: , x_performance_flag out nocopy VARCHAR2
2548: , p5_a0 out nocopy JTF_NUMBER_TABLE
2549: , p5_a1 out nocopy JTF_NUMBER_TABLE
2550: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2551: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
2552: , p5_a4 out nocopy JTF_DATE_TABLE
2553: , p5_a5 out nocopy JTF_DATE_TABLE
2551: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
2552: , p5_a4 out nocopy JTF_DATE_TABLE
2553: , p5_a5 out nocopy JTF_DATE_TABLE
2554: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2555: , p5_a7 out nocopy JTF_NUMBER_TABLE
2556: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2557: )
2558:
2559: as
2594: );
2595: end;
2596:
2597: procedure check_offer_performance_tbl(p_claim_id NUMBER
2598: , p1_a0 out nocopy JTF_NUMBER_TABLE
2599: , p1_a1 out nocopy JTF_NUMBER_TABLE
2600: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
2601: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
2602: , p1_a4 out nocopy JTF_DATE_TABLE
2595: end;
2596:
2597: procedure check_offer_performance_tbl(p_claim_id NUMBER
2598: , p1_a0 out nocopy JTF_NUMBER_TABLE
2599: , p1_a1 out nocopy JTF_NUMBER_TABLE
2600: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
2601: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
2602: , p1_a4 out nocopy JTF_DATE_TABLE
2603: , p1_a5 out nocopy JTF_DATE_TABLE
2601: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
2602: , p1_a4 out nocopy JTF_DATE_TABLE
2603: , p1_a5 out nocopy JTF_DATE_TABLE
2604: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
2605: , p1_a7 out nocopy JTF_NUMBER_TABLE
2606: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
2607: )
2608:
2609: as
2632: );
2633: end;
2634:
2635: procedure check_offer_earning_tbl(p_claim_id NUMBER
2636: , p1_a0 out nocopy JTF_NUMBER_TABLE
2637: , p1_a1 out nocopy JTF_NUMBER_TABLE
2638: )
2639:
2640: as
2633: end;
2634:
2635: procedure check_offer_earning_tbl(p_claim_id NUMBER
2636: , p1_a0 out nocopy JTF_NUMBER_TABLE
2637: , p1_a1 out nocopy JTF_NUMBER_TABLE
2638: )
2639:
2640: as
2641: ddx_offer_earn_tbl ozf_claim_accrual_pvt.offer_earning_tbl_type;