DBA Data[Home] [Help]

PACKAGE: APPS.HZ_DUP_PVT_W

Source


1 package hz_dup_pvt_w as
2   /* $Header: ARHWDUPS.pls 120.3 2005/06/18 04:28:08 jhuang ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy hz_dup_pvt.dup_party_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_VARCHAR2_TABLE_100
10     );
11   procedure rosetta_table_copy_out_p1(t hz_dup_pvt.dup_party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
12     , a1 out nocopy JTF_NUMBER_TABLE
13     , a2 out nocopy JTF_VARCHAR2_TABLE_100
14     , a3 out nocopy JTF_VARCHAR2_TABLE_100
15     , a4 out nocopy JTF_NUMBER_TABLE
16     , a5 out nocopy JTF_NUMBER_TABLE
17     , a6 out nocopy JTF_VARCHAR2_TABLE_100
18     );
19 
20   procedure create_dup_set_1(p0_a0  NUMBER
21     , p0_a1  NUMBER
22     , p0_a2  VARCHAR2
23     , p0_a3  NUMBER
24     , p0_a4  VARCHAR2
25     , p1_a0 JTF_NUMBER_TABLE
26     , p1_a1 JTF_NUMBER_TABLE
27     , p1_a2 JTF_VARCHAR2_TABLE_100
28     , p1_a3 JTF_VARCHAR2_TABLE_100
29     , p1_a4 JTF_NUMBER_TABLE
30     , p1_a5 JTF_NUMBER_TABLE
31     , p1_a6 JTF_VARCHAR2_TABLE_100
32     , x_dup_set_id out nocopy  NUMBER
33     , x_return_status out nocopy  VARCHAR2
34     , x_msg_count out nocopy  NUMBER
35     , x_msg_data out nocopy  VARCHAR2
36   );
37   procedure create_dup_batch_2(p0_a0  VARCHAR2
38     , p0_a1  NUMBER
39     , p0_a2  NUMBER
40     , p0_a3  VARCHAR2
41     , p1_a0  NUMBER
42     , p1_a1  NUMBER
43     , p1_a2  VARCHAR2
44     , p1_a3  NUMBER
45     , p1_a4  VARCHAR2
46     , p2_a0 JTF_NUMBER_TABLE
47     , p2_a1 JTF_NUMBER_TABLE
48     , p2_a2 JTF_VARCHAR2_TABLE_100
49     , p2_a3 JTF_VARCHAR2_TABLE_100
50     , p2_a4 JTF_NUMBER_TABLE
51     , p2_a5 JTF_NUMBER_TABLE
52     , p2_a6 JTF_VARCHAR2_TABLE_100
53     , x_dup_batch_id out nocopy  NUMBER
54     , x_dup_set_id out nocopy  NUMBER
55     , x_return_status out nocopy  VARCHAR2
56     , x_msg_count out nocopy  NUMBER
57     , x_msg_data out nocopy  VARCHAR2
58   );
59 end hz_dup_pvt_w;