1: package okl_am_asset_relocation_pvt_w as
2: /* $Header: OKLEARES.pls 120.3 2005/12/05 07:13:09 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_am_asset_relocation_pvt_w as
2: /* $Header: OKLEARES.pls 120.3 2005/12/05 07:13:09 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_am_asset_relocation_pvt.falo_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
15: procedure rosetta_table_copy_out_p1(t okl_am_asset_relocation_pvt.falo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
28: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_asset_relocation_pvt.ialo_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: );
36:
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: );
36:
37: procedure relocate_installed_item(p_api_version NUMBER
30: , a2 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p3(t okl_am_asset_relocation_pvt.ialo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: );
36:
37: procedure relocate_installed_item(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2
38: , p_init_msg_list VARCHAR2
39: , x_return_status out nocopy VARCHAR2
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p5_a0 JTF_NUMBER_TABLE
43: , p5_a1 JTF_NUMBER_TABLE
44: , p5_a2 JTF_NUMBER_TABLE
45: );
46: procedure relocate_fixed_asset(p_api_version NUMBER
39: , x_return_status out nocopy VARCHAR2
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p5_a0 JTF_NUMBER_TABLE
43: , p5_a1 JTF_NUMBER_TABLE
44: , p5_a2 JTF_NUMBER_TABLE
45: );
46: procedure relocate_fixed_asset(p_api_version NUMBER
47: , p_init_msg_list VARCHAR2
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p5_a0 JTF_NUMBER_TABLE
43: , p5_a1 JTF_NUMBER_TABLE
44: , p5_a2 JTF_NUMBER_TABLE
45: );
46: procedure relocate_fixed_asset(p_api_version NUMBER
47: , p_init_msg_list VARCHAR2
48: , x_return_status out nocopy VARCHAR2
47: , p_init_msg_list VARCHAR2
48: , x_return_status out nocopy VARCHAR2
49: , x_msg_count out nocopy NUMBER
50: , x_msg_data out nocopy VARCHAR2
51: , p5_a0 JTF_NUMBER_TABLE
52: , p5_a1 JTF_NUMBER_TABLE
53: , p5_a2 JTF_VARCHAR2_TABLE_100
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
48: , x_return_status out nocopy VARCHAR2
49: , x_msg_count out nocopy NUMBER
50: , x_msg_data out nocopy VARCHAR2
51: , p5_a0 JTF_NUMBER_TABLE
52: , p5_a1 JTF_NUMBER_TABLE
53: , p5_a2 JTF_VARCHAR2_TABLE_100
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
51: , p5_a0 JTF_NUMBER_TABLE
52: , p5_a1 JTF_NUMBER_TABLE
53: , p5_a2 JTF_VARCHAR2_TABLE_100
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
52: , p5_a1 JTF_NUMBER_TABLE
53: , p5_a2 JTF_VARCHAR2_TABLE_100
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
53: , p5_a2 JTF_VARCHAR2_TABLE_100
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
61: , p5_a10 JTF_NUMBER_TABLE
54: , p5_a3 JTF_VARCHAR2_TABLE_100
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
61: , p5_a10 JTF_NUMBER_TABLE
62: );
55: , p5_a4 JTF_NUMBER_TABLE
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
61: , p5_a10 JTF_NUMBER_TABLE
62: );
63: procedure change_fa_location(p_api_version NUMBER
56: , p5_a5 JTF_NUMBER_TABLE
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
61: , p5_a10 JTF_NUMBER_TABLE
62: );
63: procedure change_fa_location(p_api_version NUMBER
64: , p_init_msg_list VARCHAR2
57: , p5_a6 JTF_NUMBER_TABLE
58: , p5_a7 JTF_NUMBER_TABLE
59: , p5_a8 JTF_NUMBER_TABLE
60: , p5_a9 JTF_NUMBER_TABLE
61: , p5_a10 JTF_NUMBER_TABLE
62: );
63: procedure change_fa_location(p_api_version NUMBER
64: , p_init_msg_list VARCHAR2
65: , x_return_status out nocopy VARCHAR2
64: , p_init_msg_list VARCHAR2
65: , x_return_status out nocopy VARCHAR2
66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p5_a0 JTF_NUMBER_TABLE
69: , p5_a1 JTF_NUMBER_TABLE
70: , p5_a2 JTF_VARCHAR2_TABLE_100
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
65: , x_return_status out nocopy VARCHAR2
66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p5_a0 JTF_NUMBER_TABLE
69: , p5_a1 JTF_NUMBER_TABLE
70: , p5_a2 JTF_VARCHAR2_TABLE_100
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
68: , p5_a0 JTF_NUMBER_TABLE
69: , p5_a1 JTF_NUMBER_TABLE
70: , p5_a2 JTF_VARCHAR2_TABLE_100
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
69: , p5_a1 JTF_NUMBER_TABLE
70: , p5_a2 JTF_VARCHAR2_TABLE_100
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
70: , p5_a2 JTF_VARCHAR2_TABLE_100
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
78: , p5_a10 JTF_NUMBER_TABLE
71: , p5_a3 JTF_VARCHAR2_TABLE_100
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
78: , p5_a10 JTF_NUMBER_TABLE
79: );
72: , p5_a4 JTF_NUMBER_TABLE
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
78: , p5_a10 JTF_NUMBER_TABLE
79: );
80: end okl_am_asset_relocation_pvt_w;
73: , p5_a5 JTF_NUMBER_TABLE
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
78: , p5_a10 JTF_NUMBER_TABLE
79: );
80: end okl_am_asset_relocation_pvt_w;
74: , p5_a6 JTF_NUMBER_TABLE
75: , p5_a7 JTF_NUMBER_TABLE
76: , p5_a8 JTF_NUMBER_TABLE
77: , p5_a9 JTF_NUMBER_TABLE
78: , p5_a10 JTF_NUMBER_TABLE
79: );
80: end okl_am_asset_relocation_pvt_w;