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.CSI_TRANSACTIONS_PVT_W

Source


1 package csi_transactions_pvt_w as
2   /* $Header: csivtxws.pls 120.12 2008/01/15 03:31:55 devijay ship $ */
3   procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     );
6   procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7     , a1 out nocopy JTF_VARCHAR2_TABLE_100
8     );
9 
10   procedure get_transactions(p_api_version_number  NUMBER
11     , p_init_msg_list  VARCHAR2
12     , p_commit  VARCHAR2
13     , p_validation_level  NUMBER
14     , p_rec_requested  NUMBER
15     , p_start_rec_prt  NUMBER
16     , p_return_tot_count  VARCHAR2
17     , x_return_status out nocopy  VARCHAR2
18     , x_msg_count out nocopy  NUMBER
19     , x_msg_data out nocopy  VARCHAR2
20     , p12_a0 out nocopy JTF_NUMBER_TABLE
21     , p12_a1 out nocopy JTF_DATE_TABLE
22     , p12_a2 out nocopy JTF_DATE_TABLE
23     , p12_a3 out nocopy JTF_NUMBER_TABLE
24     , p12_a4 out nocopy JTF_NUMBER_TABLE
25     , p12_a5 out nocopy JTF_NUMBER_TABLE
26     , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27     , p12_a7 out nocopy JTF_NUMBER_TABLE
28     , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29     , p12_a9 out nocopy JTF_NUMBER_TABLE
30     , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31     , p12_a11 out nocopy JTF_NUMBER_TABLE
32     , p12_a12 out nocopy JTF_NUMBER_TABLE
33     , p12_a13 out nocopy JTF_NUMBER_TABLE
34     , p12_a14 out nocopy JTF_NUMBER_TABLE
35     , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36     , p12_a16 out nocopy JTF_NUMBER_TABLE
37     , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38     , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39     , p12_a19 out nocopy JTF_NUMBER_TABLE
40     , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
41     , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
42     , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
43     , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
44     , p12_a24 out nocopy JTF_VARCHAR2_TABLE_200
45     , p12_a25 out nocopy JTF_VARCHAR2_TABLE_200
46     , p12_a26 out nocopy JTF_VARCHAR2_TABLE_200
47     , p12_a27 out nocopy JTF_VARCHAR2_TABLE_200
48     , p12_a28 out nocopy JTF_VARCHAR2_TABLE_200
49     , p12_a29 out nocopy JTF_VARCHAR2_TABLE_200
50     , p12_a30 out nocopy JTF_VARCHAR2_TABLE_200
51     , p12_a31 out nocopy JTF_VARCHAR2_TABLE_200
52     , p12_a32 out nocopy JTF_VARCHAR2_TABLE_200
53     , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
54     , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
55     , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
56     , p12_a36 out nocopy JTF_NUMBER_TABLE
57     , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58     , p12_a38 out nocopy JTF_NUMBER_TABLE
59     , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60     , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61     , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62     , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
63     , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
64     , x_returned_rec_count out nocopy  NUMBER
65     , x_next_rec_ptr out nocopy  NUMBER
66     , x_tot_rec_count out nocopy  NUMBER
67     , p4_a0  NUMBER := 0-1962.0724
68     , p4_a1  NUMBER := 0-1962.0724
69     , p4_a2  NUMBER := 0-1962.0724
70     , p4_a3  NUMBER := 0-1962.0724
71     , p4_a4  VARCHAR2 := fnd_api.g_miss_char
72     , p4_a5  NUMBER := 0-1962.0724
73     , p4_a6  VARCHAR2 := fnd_api.g_miss_char
74     , p4_a7  NUMBER := 0-1962.0724
75     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
76     , p4_a9  DATE := fnd_api.g_miss_date
77     , p4_a10  NUMBER := 0-1962.0724
78     , p4_a11  NUMBER := 0-1962.0724
79     , p4_a12  DATE := fnd_api.g_miss_date
80     , p4_a13  DATE := fnd_api.g_miss_date
81     , p4_a14  NUMBER := 0-1962.0724
82     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
83     , p8_a0  VARCHAR2 := fnd_api.g_miss_char
84     , p8_a1  VARCHAR2 := fnd_api.g_miss_char
85   );
86   procedure create_transaction(p_api_version  NUMBER
87     , p_init_msg_list  VARCHAR2
88     , p_commit  VARCHAR2
89     , p_validation_level  NUMBER
90     , p_success_if_exists_flag  VARCHAR2
91     , p5_a0 in out nocopy  NUMBER
92     , p5_a1 in out nocopy  DATE
93     , p5_a2 in out nocopy  DATE
94     , p5_a3 in out nocopy  NUMBER
95     , p5_a4 in out nocopy  NUMBER
96     , p5_a5 in out nocopy  NUMBER
97     , p5_a6 in out nocopy  VARCHAR2
98     , p5_a7 in out nocopy  NUMBER
99     , p5_a8 in out nocopy  VARCHAR2
100     , p5_a9 in out nocopy  NUMBER
101     , p5_a10 in out nocopy  VARCHAR2
102     , p5_a11 in out nocopy  NUMBER
103     , p5_a12 in out nocopy  NUMBER
104     , p5_a13 in out nocopy  NUMBER
105     , p5_a14 in out nocopy  NUMBER
106     , p5_a15 in out nocopy  VARCHAR2
107     , p5_a16 in out nocopy  NUMBER
108     , p5_a17 in out nocopy  VARCHAR2
109     , p5_a18 in out nocopy  VARCHAR2
110     , p5_a19 in out nocopy  NUMBER
111     , p5_a20 in out nocopy  VARCHAR2
112     , p5_a21 in out nocopy  VARCHAR2
113     , p5_a22 in out nocopy  VARCHAR2
114     , p5_a23 in out nocopy  VARCHAR2
115     , p5_a24 in out nocopy  VARCHAR2
116     , p5_a25 in out nocopy  VARCHAR2
117     , p5_a26 in out nocopy  VARCHAR2
118     , p5_a27 in out nocopy  VARCHAR2
119     , p5_a28 in out nocopy  VARCHAR2
120     , p5_a29 in out nocopy  VARCHAR2
121     , p5_a30 in out nocopy  VARCHAR2
122     , p5_a31 in out nocopy  VARCHAR2
123     , p5_a32 in out nocopy  VARCHAR2
124     , p5_a33 in out nocopy  VARCHAR2
125     , p5_a34 in out nocopy  VARCHAR2
126     , p5_a35 in out nocopy  VARCHAR2
127     , p5_a36 in out nocopy  NUMBER
128     , p5_a37 in out nocopy  VARCHAR2
129     , p5_a38 in out nocopy  DATE
130     , p5_a39 in out nocopy  NUMBER
131     , x_return_status out nocopy  VARCHAR2
132     , x_msg_count out nocopy  NUMBER
133     , x_msg_data out nocopy  VARCHAR2
134   );
135   procedure update_transactions(p_api_version  NUMBER
136     , p_init_msg_list  VARCHAR2
137     , p_commit  VARCHAR2
138     , p_validation_level  NUMBER
139     , x_return_status out nocopy  VARCHAR2
140     , x_msg_count out nocopy  NUMBER
141     , x_msg_data out nocopy  VARCHAR2
142     , p4_a0  NUMBER := 0-1962.0724
143     , p4_a1  DATE := fnd_api.g_miss_date
144     , p4_a2  DATE := fnd_api.g_miss_date
145     , p4_a3  NUMBER := 0-1962.0724
146     , p4_a4  NUMBER := 0-1962.0724
147     , p4_a5  NUMBER := 0-1962.0724
148     , p4_a6  VARCHAR2 := fnd_api.g_miss_char
149     , p4_a7  NUMBER := 0-1962.0724
150     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
151     , p4_a9  NUMBER := 0-1962.0724
152     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
153     , p4_a11  NUMBER := 0-1962.0724
154     , p4_a12  NUMBER := 0-1962.0724
155     , p4_a13  NUMBER := 0-1962.0724
156     , p4_a14  NUMBER := 0-1962.0724
157     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
158     , p4_a16  NUMBER := 0-1962.0724
159     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
160     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
161     , p4_a19  NUMBER := 0-1962.0724
162     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
163     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
164     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
165     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
166     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
167     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
168     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
169     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
170     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
171     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
172     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
173     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
174     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
175     , p4_a33  VARCHAR2 := fnd_api.g_miss_char
176     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
177     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
178     , p4_a36  NUMBER := 0-1962.0724
179     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
180     , p4_a38  DATE := fnd_api.g_miss_date
181     , p4_a39  NUMBER := 0-1962.0724
182   );
183   procedure create_txn_error(p_api_version  NUMBER
184     , p_init_msg_list  VARCHAR2
185     , p_commit  VARCHAR2
186     , p_validation_level  NUMBER
187     , x_return_status out nocopy  VARCHAR2
188     , x_msg_count out nocopy  NUMBER
189     , x_msg_data out nocopy  VARCHAR2
190     , x_transaction_error_id out nocopy  NUMBER
191     , p4_a0  NUMBER := 0-1962.0724
192     , p4_a1  NUMBER := 0-1962.0724
193     , p4_a2  NUMBER := 0-1962.0724
194     , p4_a3  VARCHAR2 := fnd_api.g_miss_char
195     , p4_a4  VARCHAR2 := fnd_api.g_miss_char
196     , p4_a5  NUMBER := 0-1962.0724
197     , p4_a6  VARCHAR2 := fnd_api.g_miss_char
198     , p4_a7  NUMBER := 0-1962.0724
199     , p4_a8  DATE := fnd_api.g_miss_date
200     , p4_a9  NUMBER := 0-1962.0724
201     , p4_a10  DATE := fnd_api.g_miss_date
202     , p4_a11  NUMBER := 0-1962.0724
203     , p4_a12  NUMBER := 0-1962.0724
204     , p4_a13  NUMBER := 0-1962.0724
205     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
206     , p4_a15  NUMBER := 0-1962.0724
207     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
208     , p4_a17  NUMBER := 0-1962.0724
209     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
210     , p4_a19  NUMBER := 0-1962.0724
211     , p4_a20  NUMBER := 0-1962.0724
212     , p4_a21  NUMBER := 0-1962.0724
213     , p4_a22  NUMBER := 0-1962.0724
214     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
215     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
216     , p4_a25  NUMBER := 0-1962.0724
217     , p4_a26  NUMBER := 0-1962.0724
218     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
219     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
220     , p4_a29  DATE := fnd_api.g_miss_date
221     , p4_a30  NUMBER := 0-1962.0724
222     , p4_a31  NUMBER := 0-1962.0724
223     , p4_a32  NUMBER := 0-1962.0724
224     , p4_a33  NUMBER := 0-1962.0724
225     , p4_a34  NUMBER := 0-1962.0724
226     , p4_a35  NUMBER := 0-1962.0724
227     , p4_a36  NUMBER := 0-1962.0724
228     , p4_a37  NUMBER := 0-1962.0724
229     , p4_a38  VARCHAR2 := fnd_api.g_miss_char
230   );
231 end csi_transactions_pvt_w;