1: package as_osi_lead_pub_w AUTHID CURRENT_USER as
2: /* $Header: asxolpas.pls 115.2 2002/12/10 01:32:25 kichan ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: asxolpas.pls 115.2 2002/12/10 01:32:25 kichan ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 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_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 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_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 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_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_2000
29: , a26 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_2000
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_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_2000
38: , a35 JTF_VARCHAR2_TABLE_2000
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_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_2000
38: , a35 JTF_VARCHAR2_TABLE_2000
39: , a36 JTF_VARCHAR2_TABLE_2000
36: , a33 JTF_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_2000
38: , a35 JTF_VARCHAR2_TABLE_2000
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_2000
38: , a35 JTF_VARCHAR2_TABLE_2000
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: );
38: , a35 JTF_VARCHAR2_TABLE_2000
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_DATE_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: );
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_DATE_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_DATE_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_DATE_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
51: , a5 out nocopy JTF_NUMBER_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
55: , a9 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
56: , a10 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
57: , a11 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
58: , a12 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
59: , a13 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
60: , a14 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
61: , a15 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
62: , a16 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
63: , a17 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
64: , a18 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
65: , a19 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
66: , a20 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
67: , a21 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
68: , a22 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
69: , a23 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
70: , a24 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
78: , a32 out nocopy JTF_VARCHAR2_TABLE_100
71: , a25 out nocopy JTF_VARCHAR2_TABLE_100
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
78: , a32 out nocopy JTF_VARCHAR2_TABLE_100
79: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a26 out nocopy JTF_VARCHAR2_TABLE_100
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
78: , a32 out nocopy JTF_VARCHAR2_TABLE_100
79: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a27 out nocopy JTF_VARCHAR2_TABLE_100
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
78: , a32 out nocopy JTF_VARCHAR2_TABLE_100
79: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
81: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a28 out nocopy JTF_VARCHAR2_TABLE_100
75: , a29 out nocopy JTF_VARCHAR2_TABLE_100
76: , a30 out nocopy JTF_VARCHAR2_TABLE_100
77: , a31 out nocopy JTF_VARCHAR2_TABLE_100
78: , a32 out nocopy JTF_VARCHAR2_TABLE_100
79: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
81: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
81: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a37 out nocopy JTF_VARCHAR2_TABLE_100
84: , a38 out nocopy JTF_VARCHAR2_TABLE_100
85: , a39 out nocopy JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
80: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
81: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a37 out nocopy JTF_VARCHAR2_TABLE_100
84: , a38 out nocopy JTF_VARCHAR2_TABLE_100
85: , a39 out nocopy JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
81: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a37 out nocopy JTF_VARCHAR2_TABLE_100
84: , a38 out nocopy JTF_VARCHAR2_TABLE_100
85: , a39 out nocopy JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
82: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a37 out nocopy JTF_VARCHAR2_TABLE_100
84: , a38 out nocopy JTF_VARCHAR2_TABLE_100
85: , a39 out nocopy JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
83: , a37 out nocopy JTF_VARCHAR2_TABLE_100
84: , a38 out nocopy JTF_VARCHAR2_TABLE_100
85: , a39 out nocopy JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
91: , a1 JTF_VARCHAR2_TABLE_100
86: , a40 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
91: , a1 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
87: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
91: , a1 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
89:
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
91: , a1 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
90: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
91: , a1 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
98: , a1 JTF_VARCHAR2_TABLE_100
93: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
98: , a1 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
98: , a1 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
98: , a1 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
98: , a1 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: );
105:
98: , a1 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: );
105:
106: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
99: , a2 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: );
105:
106: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_VARCHAR2_TABLE_100
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: );
105:
106: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_VARCHAR2_TABLE_200
109: );
110: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: );
105:
106: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_VARCHAR2_TABLE_200
109: );
110: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
106: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_VARCHAR2_TABLE_200
109: );
110: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_200
113: );
114:
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_VARCHAR2_TABLE_200
109: );
110: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_200
113: );
114:
115: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_200
113: );
114:
115: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_200
113: );
114:
115: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
113: );
114:
115: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: );
123:
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: );
123:
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: );
123:
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
125: , a1 JTF_VARCHAR2_TABLE_100
120: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: );
123:
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
125: , a1 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: );
123:
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
125: , a1 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
129: );
123:
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
125: , a1 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130:
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
124: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
125: , a1 JTF_VARCHAR2_TABLE_100
126: );
127: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130:
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
132: , a1 JTF_VARCHAR2_TABLE_100
127: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130:
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
132: , a1 JTF_VARCHAR2_TABLE_100
133: );
134: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
128: , a1 out nocopy JTF_VARCHAR2_TABLE_100
129: );
130:
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
132: , a1 JTF_VARCHAR2_TABLE_100
133: );
134: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: );
130:
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
132: , a1 JTF_VARCHAR2_TABLE_100
133: );
134: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: );
137:
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
131: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
132: , a1 JTF_VARCHAR2_TABLE_100
133: );
134: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: );
137:
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_VARCHAR2_TABLE_100
134: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: );
137:
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_VARCHAR2_TABLE_100
140: );
141: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: );
137:
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_VARCHAR2_TABLE_100
140: );
141: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_100
143: );
137:
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_VARCHAR2_TABLE_100
140: );
141: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_100
143: );
144:
145: procedure osi_lead_fetch(p_api_version_number NUMBER
138: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_VARCHAR2_TABLE_100
140: );
141: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_100
143: );
144:
145: procedure osi_lead_fetch(p_api_version_number NUMBER
146: , p_lead_id VARCHAR2
185: , p2_a38 out nocopy VARCHAR2
186: , p2_a39 out nocopy VARCHAR2
187: , p2_a40 out nocopy VARCHAR2
188: , p2_a41 out nocopy VARCHAR2
189: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
190: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
191: );
192: procedure osi_lead_fetch_all(p_api_version_number NUMBER
193: , p_lead_id VARCHAR2
186: , p2_a39 out nocopy VARCHAR2
187: , p2_a40 out nocopy VARCHAR2
188: , p2_a41 out nocopy VARCHAR2
189: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
190: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
191: );
192: procedure osi_lead_fetch_all(p_api_version_number NUMBER
193: , p_lead_id VARCHAR2
194: , p2_a0 out nocopy DATE
232: , p2_a38 out nocopy VARCHAR2
233: , p2_a39 out nocopy VARCHAR2
234: , p2_a40 out nocopy VARCHAR2
235: , p2_a41 out nocopy VARCHAR2
236: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
233: , p2_a39 out nocopy VARCHAR2
234: , p2_a40 out nocopy VARCHAR2
235: , p2_a41 out nocopy VARCHAR2
236: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
234: , p2_a40 out nocopy VARCHAR2
235: , p2_a41 out nocopy VARCHAR2
236: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
235: , p2_a41 out nocopy VARCHAR2
236: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
236: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
237: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
239: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
242: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
243: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
247: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
249: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
251: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
253: );
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
254: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
260: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
261: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
270: );
263: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure osi_lead_update(p_api_version_number NUMBER
264: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure osi_lead_update(p_api_version_number NUMBER
272: , p_init_msg_list VARCHAR2
265: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure osi_lead_update(p_api_version_number NUMBER
272: , p_init_msg_list VARCHAR2
273: , p_commit VARCHAR2
270: );
271: procedure osi_lead_update(p_api_version_number NUMBER
272: , p_init_msg_list VARCHAR2
273: , p_commit VARCHAR2
274: , p4_a0 JTF_VARCHAR2_TABLE_100
275: , p4_a1 JTF_VARCHAR2_TABLE_100
276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy VARCHAR2
278: , x_msg_data out nocopy VARCHAR2
271: procedure osi_lead_update(p_api_version_number NUMBER
272: , p_init_msg_list VARCHAR2
273: , p_commit VARCHAR2
274: , p4_a0 JTF_VARCHAR2_TABLE_100
275: , p4_a1 JTF_VARCHAR2_TABLE_100
276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy VARCHAR2
278: , x_msg_data out nocopy VARCHAR2
279: , p3_a0 DATE := fnd_api.g_miss_date
319: , p3_a40 VARCHAR2 := fnd_api.g_miss_char
320: , p3_a41 VARCHAR2 := fnd_api.g_miss_char
321: );
322: procedure osi_cvb_fetch(p_api_version_number NUMBER
323: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
324: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
325: );
326: procedure osi_cnb_fetch(p_api_version_number NUMBER
327: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
320: , p3_a41 VARCHAR2 := fnd_api.g_miss_char
321: );
322: procedure osi_cvb_fetch(p_api_version_number NUMBER
323: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
324: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
325: );
326: procedure osi_cnb_fetch(p_api_version_number NUMBER
327: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
323: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
324: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
325: );
326: procedure osi_cnb_fetch(p_api_version_number NUMBER
327: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
329: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
330: );
331: procedure osi_lkp_fetch(p_api_version_number NUMBER
324: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
325: );
326: procedure osi_cnb_fetch(p_api_version_number NUMBER
327: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
329: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
330: );
331: procedure osi_lkp_fetch(p_api_version_number NUMBER
332: , p_osi_lkp_type VARCHAR2
325: );
326: procedure osi_cnb_fetch(p_api_version_number NUMBER
327: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
329: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
330: );
331: procedure osi_lkp_fetch(p_api_version_number NUMBER
332: , p_osi_lkp_type VARCHAR2
333: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
329: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
330: );
331: procedure osi_lkp_fetch(p_api_version_number NUMBER
332: , p_osi_lkp_type VARCHAR2
333: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
334: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
335: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
336: );
337: procedure osi_nam_fetch(p_api_version_number NUMBER
330: );
331: procedure osi_lkp_fetch(p_api_version_number NUMBER
332: , p_osi_lkp_type VARCHAR2
333: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
334: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
335: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
336: );
337: procedure osi_nam_fetch(p_api_version_number NUMBER
338: , p_osi_nam_type VARCHAR2
335: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
336: );
337: procedure osi_nam_fetch(p_api_version_number NUMBER
338: , p_osi_nam_type VARCHAR2
339: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
340: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
341: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
342: );
343: end as_osi_lead_pub_w;
336: );
337: procedure osi_nam_fetch(p_api_version_number NUMBER
338: , p_osi_nam_type VARCHAR2
339: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
340: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
341: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
342: );
343: end as_osi_lead_pub_w;
337: procedure osi_nam_fetch(p_api_version_number NUMBER
338: , p_osi_nam_type VARCHAR2
339: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
340: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
341: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
342: );
343: end as_osi_lead_pub_w;