1: PACKAGE OKL_LA_TRADEIN_PVT_W as
2: /* $Header: OKLETRIS.pls 120.0 2005/11/12 00:58:05 smereddy noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
1: PACKAGE OKL_LA_TRADEIN_PVT_W as
2: /* $Header: OKLETRIS.pls 120.0 2005/11/12 00:58:05 smereddy noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2: /* $Header: OKLETRIS.pls 120.0 2005/11/12 00:58:05 smereddy noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
7: );
8: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: );
18: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: );
18: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
14: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: );
18: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_VARCHAR2_TABLE_100
21: );
22:
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: );
18: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_VARCHAR2_TABLE_100
21: );
22:
23: procedure create_tradein(p_api_version NUMBER
40: , x_return_status out nocopy VARCHAR2
41: , x_msg_count out nocopy NUMBER
42: , x_msg_data out nocopy VARCHAR2
43: , p_chr_id NUMBER
44: , p6_a0 JTF_NUMBER_TABLE
45: , p6_a1 JTF_NUMBER_TABLE
46: , p6_a2 JTF_VARCHAR2_TABLE_200
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
41: , x_msg_count out nocopy NUMBER
42: , x_msg_data out nocopy VARCHAR2
43: , p_chr_id NUMBER
44: , p6_a0 JTF_NUMBER_TABLE
45: , p6_a1 JTF_NUMBER_TABLE
46: , p6_a2 JTF_VARCHAR2_TABLE_200
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
49: , p7_a1 out nocopy JTF_NUMBER_TABLE
43: , p_chr_id NUMBER
44: , p6_a0 JTF_NUMBER_TABLE
45: , p6_a1 JTF_NUMBER_TABLE
46: , p6_a2 JTF_VARCHAR2_TABLE_200
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
49: , p7_a1 out nocopy JTF_NUMBER_TABLE
50: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , p7_a3 out nocopy JTF_NUMBER_TABLE
44: , p6_a0 JTF_NUMBER_TABLE
45: , p6_a1 JTF_NUMBER_TABLE
46: , p6_a2 JTF_VARCHAR2_TABLE_200
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
49: , p7_a1 out nocopy JTF_NUMBER_TABLE
50: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , p7_a3 out nocopy JTF_NUMBER_TABLE
52: );
45: , p6_a1 JTF_NUMBER_TABLE
46: , p6_a2 JTF_VARCHAR2_TABLE_200
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
49: , p7_a1 out nocopy JTF_NUMBER_TABLE
50: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , p7_a3 out nocopy JTF_NUMBER_TABLE
52: );
53: procedure delete_tradein(p_api_version NUMBER
47: , p6_a3 JTF_NUMBER_TABLE
48: , p7_a0 out nocopy JTF_NUMBER_TABLE
49: , p7_a1 out nocopy JTF_NUMBER_TABLE
50: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
51: , p7_a3 out nocopy JTF_NUMBER_TABLE
52: );
53: procedure delete_tradein(p_api_version NUMBER
54: , p_init_msg_list VARCHAR2
55: , x_return_status out nocopy VARCHAR2
70: , x_return_status out nocopy VARCHAR2
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p_chr_id NUMBER
74: , p6_a0 JTF_NUMBER_TABLE
75: , p6_a1 JTF_NUMBER_TABLE
76: , p6_a2 JTF_VARCHAR2_TABLE_200
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p_chr_id NUMBER
74: , p6_a0 JTF_NUMBER_TABLE
75: , p6_a1 JTF_NUMBER_TABLE
76: , p6_a2 JTF_VARCHAR2_TABLE_200
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_NUMBER_TABLE
73: , p_chr_id NUMBER
74: , p6_a0 JTF_NUMBER_TABLE
75: , p6_a1 JTF_NUMBER_TABLE
76: , p6_a2 JTF_VARCHAR2_TABLE_200
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_NUMBER_TABLE
80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
81: , p7_a3 out nocopy JTF_NUMBER_TABLE
74: , p6_a0 JTF_NUMBER_TABLE
75: , p6_a1 JTF_NUMBER_TABLE
76: , p6_a2 JTF_VARCHAR2_TABLE_200
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_NUMBER_TABLE
80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
81: , p7_a3 out nocopy JTF_NUMBER_TABLE
82: );
75: , p6_a1 JTF_NUMBER_TABLE
76: , p6_a2 JTF_VARCHAR2_TABLE_200
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_NUMBER_TABLE
80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
81: , p7_a3 out nocopy JTF_NUMBER_TABLE
82: );
83: procedure update_contract(p_api_version NUMBER
77: , p6_a3 JTF_NUMBER_TABLE
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_NUMBER_TABLE
80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
81: , p7_a3 out nocopy JTF_NUMBER_TABLE
82: );
83: procedure update_contract(p_api_version NUMBER
84: , p_init_msg_list VARCHAR2
85: , x_return_status out nocopy VARCHAR2