eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AHL_DI_SUBSCRIPTION_PUB_W

Source


1 package ahl_di_subscription_pub_w AUTHID CURRENT_USER as
2   /* $Header: AHLSUBWS.pls 115.10 2003/07/28 07:30:56 pbarman noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, 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_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_400
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_300
15     , a12 JTF_VARCHAR2_TABLE_400
16     , a13 JTF_DATE_TABLE
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_100
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_VARCHAR2_TABLE_200
25     , a22 JTF_VARCHAR2_TABLE_200
26     , a23 JTF_VARCHAR2_TABLE_200
27     , a24 JTF_VARCHAR2_TABLE_200
28     , a25 JTF_VARCHAR2_TABLE_200
29     , a26 JTF_VARCHAR2_TABLE_200
30     , a27 JTF_VARCHAR2_TABLE_200
31     , a28 JTF_VARCHAR2_TABLE_200
32     , a29 JTF_VARCHAR2_TABLE_200
33     , a30 JTF_VARCHAR2_TABLE_200
34     , a31 JTF_VARCHAR2_TABLE_200
35     , a32 JTF_VARCHAR2_TABLE_200
36     , a33 JTF_VARCHAR2_TABLE_200
37     , a34 JTF_VARCHAR2_TABLE_200
38     , a35 JTF_VARCHAR2_TABLE_200
39     , a36 JTF_VARCHAR2_TABLE_100
40     , a37 JTF_VARCHAR2_TABLE_100
41     , a38 JTF_VARCHAR2_TABLE_2000
42     , a39 JTF_NUMBER_TABLE
43     , a40 JTF_VARCHAR2_TABLE_100
44     );
45   procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE
46     , a1 out nocopy JTF_NUMBER_TABLE
47     , a2 out nocopy JTF_VARCHAR2_TABLE_100
48     , a3 out nocopy JTF_VARCHAR2_TABLE_100
49     , a4 out nocopy JTF_NUMBER_TABLE
50     , a5 out nocopy JTF_VARCHAR2_TABLE_100
51     , a6 out nocopy JTF_VARCHAR2_TABLE_400
52     , a7 out nocopy JTF_NUMBER_TABLE
53     , a8 out nocopy JTF_VARCHAR2_TABLE_100
54     , a9 out nocopy JTF_VARCHAR2_TABLE_100
55     , a10 out nocopy JTF_NUMBER_TABLE
56     , a11 out nocopy JTF_VARCHAR2_TABLE_300
57     , a12 out nocopy JTF_VARCHAR2_TABLE_400
58     , a13 out nocopy JTF_DATE_TABLE
59     , a14 out nocopy JTF_DATE_TABLE
60     , a15 out nocopy JTF_VARCHAR2_TABLE_100
61     , a16 out nocopy JTF_VARCHAR2_TABLE_100
62     , a17 out nocopy JTF_VARCHAR2_TABLE_100
63     , a18 out nocopy JTF_VARCHAR2_TABLE_100
64     , a19 out nocopy JTF_VARCHAR2_TABLE_100
65     , a20 out nocopy JTF_VARCHAR2_TABLE_100
66     , a21 out nocopy JTF_VARCHAR2_TABLE_200
67     , a22 out nocopy JTF_VARCHAR2_TABLE_200
68     , a23 out nocopy JTF_VARCHAR2_TABLE_200
69     , a24 out nocopy JTF_VARCHAR2_TABLE_200
70     , a25 out nocopy JTF_VARCHAR2_TABLE_200
71     , a26 out nocopy JTF_VARCHAR2_TABLE_200
72     , a27 out nocopy JTF_VARCHAR2_TABLE_200
73     , a28 out nocopy JTF_VARCHAR2_TABLE_200
74     , a29 out nocopy JTF_VARCHAR2_TABLE_200
75     , a30 out nocopy JTF_VARCHAR2_TABLE_200
76     , a31 out nocopy JTF_VARCHAR2_TABLE_200
77     , a32 out nocopy JTF_VARCHAR2_TABLE_200
78     , a33 out nocopy JTF_VARCHAR2_TABLE_200
79     , a34 out nocopy JTF_VARCHAR2_TABLE_200
80     , a35 out nocopy JTF_VARCHAR2_TABLE_200
81     , a36 out nocopy JTF_VARCHAR2_TABLE_100
82     , a37 out nocopy JTF_VARCHAR2_TABLE_100
83     , a38 out nocopy JTF_VARCHAR2_TABLE_2000
84     , a39 out nocopy JTF_NUMBER_TABLE
85     , a40 out nocopy JTF_VARCHAR2_TABLE_100
86     );
87 
88   procedure create_subscription(p_api_version  NUMBER
89     , p_init_msg_list  VARCHAR2
90     , p_commit  VARCHAR2
91     , p_validate_only  VARCHAR2
92     , p_validation_level  NUMBER
93     , p5_a0 in out nocopy JTF_NUMBER_TABLE
94     , p5_a1 in out nocopy JTF_NUMBER_TABLE
95     , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
96     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
97     , p5_a4 in out nocopy JTF_NUMBER_TABLE
98     , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
99     , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
100     , p5_a7 in out nocopy JTF_NUMBER_TABLE
101     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
102     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
103     , p5_a10 in out nocopy JTF_NUMBER_TABLE
104     , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300
105     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_400
106     , p5_a13 in out nocopy JTF_DATE_TABLE
107     , p5_a14 in out nocopy JTF_DATE_TABLE
108     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
109     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
110     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
111     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
112     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
113     , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_100
114     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
115     , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
116     , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
117     , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
118     , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_200
119     , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_200
120     , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_200
121     , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_200
122     , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_200
123     , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_200
124     , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
125     , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
126     , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
127     , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_200
128     , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_200
129     , p5_a36 in out nocopy JTF_VARCHAR2_TABLE_100
130     , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
131     , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_2000
132     , p5_a39 in out nocopy JTF_NUMBER_TABLE
133     , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
134     , p_module_type  VARCHAR2
135     , x_return_status out nocopy  VARCHAR2
136     , x_msg_count out nocopy  NUMBER
137     , x_msg_data out nocopy  VARCHAR2
138   );
139   procedure modify_subscription(p_api_version  NUMBER
140     , p_init_msg_list  VARCHAR2
141     , p_commit  VARCHAR2
142     , p_validate_only  VARCHAR2
143     , p_validation_level  NUMBER
144     , p5_a0 in out nocopy JTF_NUMBER_TABLE
145     , p5_a1 in out nocopy JTF_NUMBER_TABLE
146     , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
147     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
148     , p5_a4 in out nocopy JTF_NUMBER_TABLE
149     , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
150     , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
151     , p5_a7 in out nocopy JTF_NUMBER_TABLE
152     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
153     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
154     , p5_a10 in out nocopy JTF_NUMBER_TABLE
155     , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300
156     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_400
157     , p5_a13 in out nocopy JTF_DATE_TABLE
158     , p5_a14 in out nocopy JTF_DATE_TABLE
159     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
160     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
161     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
162     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
163     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
164     , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_100
165     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
166     , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
167     , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
168     , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
169     , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_200
170     , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_200
171     , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_200
172     , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_200
173     , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_200
174     , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_200
175     , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
176     , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
177     , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
178     , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_200
179     , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_200
180     , p5_a36 in out nocopy JTF_VARCHAR2_TABLE_100
181     , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
182     , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_2000
183     , p5_a39 in out nocopy JTF_NUMBER_TABLE
184     , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
185     , p_module_type  VARCHAR2
186     , x_return_status out nocopy  VARCHAR2
187     , x_msg_count out nocopy  NUMBER
188     , x_msg_data out nocopy  VARCHAR2
189   );
190 end ahl_di_subscription_pub_w;