DBA Data[Home] [Help]

PACKAGE: APPS.IEX_DUNNING_PUB_W

Source


1 package iex_dunning_pub_w as
2   /* $Header: iexwduns.pls 120.6 2005/07/07 19:59:13 ctlee ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy iex_dunning_pub.ag_dn_xref_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_DATE_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_NUMBER_TABLE
20     );
21   procedure rosetta_table_copy_out_p1(t iex_dunning_pub.ag_dn_xref_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
22     , a1 out nocopy JTF_NUMBER_TABLE
23     , a2 out nocopy JTF_NUMBER_TABLE
24     , a3 out nocopy JTF_VARCHAR2_TABLE_100
25     , a4 out nocopy JTF_NUMBER_TABLE
26     , a5 out nocopy JTF_VARCHAR2_TABLE_100
27     , a6 out nocopy JTF_NUMBER_TABLE
28     , a7 out nocopy JTF_NUMBER_TABLE
29     , a8 out nocopy JTF_NUMBER_TABLE
30     , a9 out nocopy JTF_NUMBER_TABLE
31     , a10 out nocopy JTF_VARCHAR2_TABLE_100
32     , a11 out nocopy JTF_NUMBER_TABLE
33     , a12 out nocopy JTF_DATE_TABLE
34     , a13 out nocopy JTF_NUMBER_TABLE
35     , a14 out nocopy JTF_DATE_TABLE
36     , a15 out nocopy JTF_NUMBER_TABLE
37     , a16 out nocopy JTF_NUMBER_TABLE
38     );
39 
40   procedure rosetta_table_copy_in_p2(t out nocopy iex_dunning_pub.ag_dn_xref_id_tbl_type, a0 JTF_NUMBER_TABLE);
41   procedure rosetta_table_copy_out_p2(t iex_dunning_pub.ag_dn_xref_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
42 
43   procedure rosetta_table_copy_in_p8(t out nocopy iex_dunning_pub.dunning_tbl_type, a0 JTF_NUMBER_TABLE
44     , a1 JTF_NUMBER_TABLE
45     , a2 JTF_VARCHAR2_TABLE_100
46     , a3 JTF_DATE_TABLE
47     , a4 JTF_VARCHAR2_TABLE_300
48     , a5 JTF_NUMBER_TABLE
49     , a6 JTF_NUMBER_TABLE
50     , a7 JTF_NUMBER_TABLE
51     , a8 JTF_NUMBER_TABLE
52     , a9 JTF_NUMBER_TABLE
53     , a10 JTF_NUMBER_TABLE
54     , a11 JTF_VARCHAR2_TABLE_100
55     , a12 JTF_VARCHAR2_TABLE_100
56     , a13 JTF_NUMBER_TABLE
57     , a14 JTF_VARCHAR2_TABLE_100
58     , a15 JTF_NUMBER_TABLE
59     , a16 JTF_VARCHAR2_TABLE_100
60     , a17 JTF_DATE_TABLE
61     , a18 JTF_NUMBER_TABLE
62     , a19 JTF_DATE_TABLE
63     , a20 JTF_NUMBER_TABLE
64     , a21 JTF_NUMBER_TABLE
65     , a22 JTF_NUMBER_TABLE
66     , a23 JTF_VARCHAR2_TABLE_100
67     , a24 JTF_NUMBER_TABLE
68     , a25 JTF_NUMBER_TABLE
69     );
70   procedure rosetta_table_copy_out_p8(t iex_dunning_pub.dunning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71     , a1 out nocopy JTF_NUMBER_TABLE
72     , a2 out nocopy JTF_VARCHAR2_TABLE_100
73     , a3 out nocopy JTF_DATE_TABLE
74     , a4 out nocopy JTF_VARCHAR2_TABLE_300
75     , a5 out nocopy JTF_NUMBER_TABLE
76     , a6 out nocopy JTF_NUMBER_TABLE
77     , a7 out nocopy JTF_NUMBER_TABLE
78     , a8 out nocopy JTF_NUMBER_TABLE
79     , a9 out nocopy JTF_NUMBER_TABLE
80     , a10 out nocopy JTF_NUMBER_TABLE
81     , a11 out nocopy JTF_VARCHAR2_TABLE_100
82     , a12 out nocopy JTF_VARCHAR2_TABLE_100
83     , a13 out nocopy JTF_NUMBER_TABLE
84     , a14 out nocopy JTF_VARCHAR2_TABLE_100
85     , a15 out nocopy JTF_NUMBER_TABLE
86     , a16 out nocopy JTF_VARCHAR2_TABLE_100
87     , a17 out nocopy JTF_DATE_TABLE
88     , a18 out nocopy JTF_NUMBER_TABLE
89     , a19 out nocopy JTF_DATE_TABLE
90     , a20 out nocopy JTF_NUMBER_TABLE
91     , a21 out nocopy JTF_NUMBER_TABLE
92     , a22 out nocopy JTF_NUMBER_TABLE
93     , a23 out nocopy JTF_VARCHAR2_TABLE_100
94     , a24 out nocopy JTF_NUMBER_TABLE
95     , a25 out nocopy JTF_NUMBER_TABLE
96     );
97 
98   procedure rosetta_table_copy_in_p9(t out nocopy iex_dunning_pub.delid_numlist, a0 JTF_NUMBER_TABLE);
99   procedure rosetta_table_copy_out_p9(t iex_dunning_pub.delid_numlist, a0 out nocopy JTF_NUMBER_TABLE);
100 
101   procedure create_ag_dn_xref(p_api_version  NUMBER
102     , p_init_msg_list  VARCHAR2
103     , p_commit  VARCHAR2
104     , p3_a0 JTF_NUMBER_TABLE
105     , p3_a1 JTF_NUMBER_TABLE
106     , p3_a2 JTF_NUMBER_TABLE
107     , p3_a3 JTF_VARCHAR2_TABLE_100
108     , p3_a4 JTF_NUMBER_TABLE
109     , p3_a5 JTF_VARCHAR2_TABLE_100
110     , p3_a6 JTF_NUMBER_TABLE
111     , p3_a7 JTF_NUMBER_TABLE
112     , p3_a8 JTF_NUMBER_TABLE
113     , p3_a9 JTF_NUMBER_TABLE
114     , p3_a10 JTF_VARCHAR2_TABLE_100
115     , p3_a11 JTF_NUMBER_TABLE
116     , p3_a12 JTF_DATE_TABLE
117     , p3_a13 JTF_NUMBER_TABLE
118     , p3_a14 JTF_DATE_TABLE
119     , p3_a15 JTF_NUMBER_TABLE
120     , p3_a16 JTF_NUMBER_TABLE
121     , x_return_status out nocopy  VARCHAR2
122     , x_msg_count out nocopy  NUMBER
123     , x_msg_data out nocopy  VARCHAR2
124     , x_ag_dn_xref_id_tbl out nocopy JTF_NUMBER_TABLE
125   );
126   procedure update_ag_dn_xref(p_api_version  NUMBER
127     , p_init_msg_list  VARCHAR2
128     , p_commit  VARCHAR2
129     , p3_a0 JTF_NUMBER_TABLE
130     , p3_a1 JTF_NUMBER_TABLE
131     , p3_a2 JTF_NUMBER_TABLE
132     , p3_a3 JTF_VARCHAR2_TABLE_100
133     , p3_a4 JTF_NUMBER_TABLE
134     , p3_a5 JTF_VARCHAR2_TABLE_100
135     , p3_a6 JTF_NUMBER_TABLE
136     , p3_a7 JTF_NUMBER_TABLE
137     , p3_a8 JTF_NUMBER_TABLE
138     , p3_a9 JTF_NUMBER_TABLE
139     , p3_a10 JTF_VARCHAR2_TABLE_100
140     , p3_a11 JTF_NUMBER_TABLE
141     , p3_a12 JTF_DATE_TABLE
142     , p3_a13 JTF_NUMBER_TABLE
143     , p3_a14 JTF_DATE_TABLE
144     , p3_a15 JTF_NUMBER_TABLE
145     , p3_a16 JTF_NUMBER_TABLE
146     , x_return_status out nocopy  VARCHAR2
147     , x_msg_count out nocopy  NUMBER
148     , x_msg_data out nocopy  VARCHAR2
149   );
150 end iex_dunning_pub_w;