DBA Data[Home] [Help]

PACKAGE: APPS.OKL_LA_TRADEIN_PVT_W

Source


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
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
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
24     , p_init_msg_list  VARCHAR2
25     , x_return_status out nocopy  VARCHAR2
26     , x_msg_count out nocopy  NUMBER
27     , x_msg_data out nocopy  VARCHAR2
28     , p_chr_id  NUMBER
29     , p7_a0 out nocopy  NUMBER
30     , p7_a1 out nocopy  NUMBER
31     , p7_a2 out nocopy  VARCHAR2
32     , p7_a3 out nocopy  NUMBER
33     , p6_a0  NUMBER := 0-1962.0724
34     , p6_a1  NUMBER := 0-1962.0724
35     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
36     , p6_a3  NUMBER := 0-1962.0724
37   );
38   procedure create_tradein(p_api_version  NUMBER
39     , p_init_msg_list  VARCHAR2
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
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
56     , x_msg_count out nocopy  NUMBER
57     , x_msg_data out nocopy  VARCHAR2
58     , p_chr_id  NUMBER
59     , p7_a0 out nocopy  NUMBER
60     , p7_a1 out nocopy  NUMBER
61     , p7_a2 out nocopy  VARCHAR2
62     , p7_a3 out nocopy  NUMBER
63     , p6_a0  NUMBER := 0-1962.0724
64     , p6_a1  NUMBER := 0-1962.0724
65     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
66     , p6_a3  NUMBER := 0-1962.0724
67   );
68   procedure delete_tradein(p_api_version  NUMBER
69     , p_init_msg_list  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
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
86     , x_msg_count out nocopy  NUMBER
87     , x_msg_data out nocopy  VARCHAR2
88     , p_chr_id  NUMBER
89     , p_tradein_date  date
90     , p_tradein_amount  NUMBER
91     , p_tradein_desc  VARCHAR2
92   );
93 end okl_la_tradein_pvt_w;