1: package okl_la_asset_pvt_w as
2: /* $Header: OKLELAAS.pls 120.5 2007/03/12 05:55:36 rviriyal ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
2: /* $Header: OKLELAAS.pls 120.5 2007/03/12 05:55:36 rviriyal ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
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 okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
13: procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_NUMBER_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
24: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300
32: , a8 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300
32: , a8 JTF_NUMBER_TABLE
33: , a9 JTF_NUMBER_TABLE
26: , a2 JTF_VARCHAR2_TABLE_100
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300
32: , a8 JTF_NUMBER_TABLE
33: , a9 JTF_NUMBER_TABLE
34: , a10 JTF_DATE_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300
32: , a8 JTF_NUMBER_TABLE
33: , a9 JTF_NUMBER_TABLE
34: , a10 JTF_DATE_TABLE
35: , a11 JTF_DATE_TABLE
36: , a12 JTF_DATE_TABLE
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_VARCHAR2_TABLE_300
32: , a8 JTF_NUMBER_TABLE
33: , a9 JTF_NUMBER_TABLE
34: , a10 JTF_DATE_TABLE
35: , a11 JTF_DATE_TABLE
36: , a12 JTF_DATE_TABLE
37: , a13 JTF_DATE_TABLE
38: , a14 JTF_DATE_TABLE
39: , a15 JTF_DATE_TABLE
40: , a16 JTF_VARCHAR2_TABLE_100
41: , a17 JTF_VARCHAR2_TABLE_2000
42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
39: , a15 JTF_DATE_TABLE
40: , a16 JTF_VARCHAR2_TABLE_100
41: , a17 JTF_VARCHAR2_TABLE_2000
42: , a18 JTF_NUMBER_TABLE
43: , a19 JTF_NUMBER_TABLE
44: , a20 JTF_VARCHAR2_TABLE_100
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
45: , a21 JTF_VARCHAR2_TABLE_100
46: , a22 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
48: procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
59: , a11 out nocopy JTF_DATE_TABLE
60: , a12 out nocopy JTF_DATE_TABLE
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_DATE_TABLE
59: , a11 out nocopy JTF_DATE_TABLE
60: , a12 out nocopy JTF_DATE_TABLE
61: , a13 out nocopy JTF_DATE_TABLE
62: , a14 out nocopy JTF_DATE_TABLE
63: , a15 out nocopy JTF_DATE_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_DATE_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a18 out nocopy JTF_NUMBER_TABLE
67: , a19 out nocopy JTF_NUMBER_TABLE
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_VARCHAR2_TABLE_100
71: );
75: , x_return_status out nocopy VARCHAR2
76: , x_msg_count out nocopy NUMBER
77: , x_msg_data out nocopy VARCHAR2
78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a8 out nocopy JTF_NUMBER_TABLE
79: , p6_a1 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a8 out nocopy JTF_NUMBER_TABLE
87: , p6_a9 out nocopy JTF_NUMBER_TABLE
80: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a8 out nocopy JTF_NUMBER_TABLE
87: , p6_a9 out nocopy JTF_NUMBER_TABLE
88: , p6_a10 out nocopy JTF_DATE_TABLE
82: , p6_a4 out nocopy JTF_NUMBER_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a8 out nocopy JTF_NUMBER_TABLE
87: , p6_a9 out nocopy JTF_NUMBER_TABLE
88: , p6_a10 out nocopy JTF_DATE_TABLE
89: , p6_a11 out nocopy JTF_DATE_TABLE
90: , p6_a12 out nocopy JTF_DATE_TABLE
83: , p6_a5 out nocopy JTF_NUMBER_TABLE
84: , p6_a6 out nocopy JTF_NUMBER_TABLE
85: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a8 out nocopy JTF_NUMBER_TABLE
87: , p6_a9 out nocopy JTF_NUMBER_TABLE
88: , p6_a10 out nocopy JTF_DATE_TABLE
89: , p6_a11 out nocopy JTF_DATE_TABLE
90: , p6_a12 out nocopy JTF_DATE_TABLE
91: , p6_a13 out nocopy JTF_DATE_TABLE
92: , p6_a14 out nocopy JTF_DATE_TABLE
93: , p6_a15 out nocopy JTF_DATE_TABLE
94: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a15 out nocopy JTF_DATE_TABLE
94: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96: , p6_a18 out nocopy JTF_NUMBER_TABLE
97: , p6_a19 out nocopy JTF_NUMBER_TABLE
98: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
137: , p_init_msg_list VARCHAR2
138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a1 JTF_VARCHAR2_TABLE_100
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_VARCHAR2_TABLE_100
150: );
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_NUMBER_TABLE
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_NUMBER_TABLE
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_VARCHAR2_TABLE_100
150: );
151: end okl_la_asset_pvt_w;