1: package okl_ins_quote_pvt_w as
2: /* $Header: OKLEINQS.pls 120.2 2005/09/19 11:35:46 pagarg noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ins_quote_pvt.ipyv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_600
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
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_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
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_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_300
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_300
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_100
52: , a49 JTF_VARCHAR2_TABLE_500
53: , a50 JTF_VARCHAR2_TABLE_500
54: , a51 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_100
52: , a49 JTF_VARCHAR2_TABLE_500
53: , a50 JTF_VARCHAR2_TABLE_500
54: , a51 JTF_VARCHAR2_TABLE_500
55: , a52 JTF_VARCHAR2_TABLE_500
77: , a74 JTF_NUMBER_TABLE
78: , a75 JTF_NUMBER_TABLE
79: );
80: procedure rosetta_table_copy_out_p1(t okl_ins_quote_pvt.ipyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_100
82: , a2 out nocopy JTF_VARCHAR2_TABLE_300
83: , a3 out nocopy JTF_VARCHAR2_TABLE_600
84: , a4 out nocopy JTF_VARCHAR2_TABLE_300
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300
84: , a4 out nocopy JTF_VARCHAR2_TABLE_300
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300
86: , a6 out nocopy JTF_VARCHAR2_TABLE_300
87: , a7 out nocopy JTF_VARCHAR2_TABLE_300
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE
101: , a21 out nocopy JTF_DATE_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE
101: , a21 out nocopy JTF_DATE_TABLE
102: , a22 out nocopy JTF_DATE_TABLE
103: , a23 out nocopy JTF_DATE_TABLE
104: , a24 out nocopy JTF_DATE_TABLE
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
104: , a24 out nocopy JTF_DATE_TABLE
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE
115: , a35 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE
115: , a35 out nocopy JTF_NUMBER_TABLE
116: , a36 out nocopy JTF_NUMBER_TABLE
116: , a36 out nocopy JTF_NUMBER_TABLE
117: , a37 out nocopy JTF_NUMBER_TABLE
118: , a38 out nocopy JTF_NUMBER_TABLE
119: , a39 out nocopy JTF_VARCHAR2_TABLE_300
120: , a40 out nocopy JTF_VARCHAR2_TABLE_100
121: , a41 out nocopy JTF_NUMBER_TABLE
122: , a42 out nocopy JTF_VARCHAR2_TABLE_100
123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE
118: , a38 out nocopy JTF_NUMBER_TABLE
119: , a39 out nocopy JTF_VARCHAR2_TABLE_300
120: , a40 out nocopy JTF_VARCHAR2_TABLE_100
121: , a41 out nocopy JTF_NUMBER_TABLE
122: , a42 out nocopy JTF_VARCHAR2_TABLE_100
123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE
123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE
127: , a47 out nocopy JTF_VARCHAR2_TABLE_100
128: , a48 out nocopy JTF_VARCHAR2_TABLE_100
129: , a49 out nocopy JTF_VARCHAR2_TABLE_500
130: , a50 out nocopy JTF_VARCHAR2_TABLE_500
131: , a51 out nocopy JTF_VARCHAR2_TABLE_500
124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE
127: , a47 out nocopy JTF_VARCHAR2_TABLE_100
128: , a48 out nocopy JTF_VARCHAR2_TABLE_100
129: , a49 out nocopy JTF_VARCHAR2_TABLE_500
130: , a50 out nocopy JTF_VARCHAR2_TABLE_500
131: , a51 out nocopy JTF_VARCHAR2_TABLE_500
132: , a52 out nocopy JTF_VARCHAR2_TABLE_500
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
163: , a5 JTF_NUMBER_TABLE
164: , a6 JTF_NUMBER_TABLE
165: , a7 JTF_VARCHAR2_TABLE_100
166: , a8 JTF_VARCHAR2_TABLE_500
167: , a9 JTF_VARCHAR2_TABLE_500
168: , a10 JTF_VARCHAR2_TABLE_500
169: , a11 JTF_VARCHAR2_TABLE_500
195: , a3 out nocopy JTF_NUMBER_TABLE
196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_NUMBER_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , a8 out nocopy JTF_VARCHAR2_TABLE_500
201: , a9 out nocopy JTF_VARCHAR2_TABLE_500
202: , a10 out nocopy JTF_VARCHAR2_TABLE_500
203: , a11 out nocopy JTF_VARCHAR2_TABLE_500
232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: );
235:
236: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_VARCHAR2_TABLE_200
238: );
239: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
240: , a1 out nocopy JTF_VARCHAR2_TABLE_200
235:
236: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_VARCHAR2_TABLE_200
238: );
239: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
240: , a1 out nocopy JTF_VARCHAR2_TABLE_200
241: );
242:
243: procedure rosetta_table_copy_in_p9(t out nocopy okl_ins_quote_pvt.payment_tbl_type, a0 JTF_NUMBER_TABLE