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

Source


1 package ams_cat_activity_pvt_w as
2   /* $Header: amswcacs.pls 120.1 2005/11/23 05:22 vmodur noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ams_cat_activity_pvt.cat_activity_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_200
14     , a11 JTF_VARCHAR2_TABLE_200
15     , a12 JTF_VARCHAR2_TABLE_200
16     , a13 JTF_VARCHAR2_TABLE_200
17     , a14 JTF_VARCHAR2_TABLE_200
18     , a15 JTF_VARCHAR2_TABLE_200
19     , a16 JTF_VARCHAR2_TABLE_200
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
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     );
29   procedure rosetta_table_copy_out_p3(t ams_cat_activity_pvt.cat_activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30     , a1 out nocopy JTF_NUMBER_TABLE
31     , a2 out nocopy JTF_NUMBER_TABLE
32     , a3 out nocopy JTF_NUMBER_TABLE
33     , a4 out nocopy JTF_DATE_TABLE
34     , a5 out nocopy JTF_NUMBER_TABLE
35     , a6 out nocopy JTF_DATE_TABLE
36     , a7 out nocopy JTF_NUMBER_TABLE
37     , a8 out nocopy JTF_NUMBER_TABLE
38     , a9 out nocopy JTF_VARCHAR2_TABLE_100
39     , a10 out nocopy JTF_VARCHAR2_TABLE_200
40     , a11 out nocopy JTF_VARCHAR2_TABLE_200
41     , a12 out nocopy JTF_VARCHAR2_TABLE_200
42     , a13 out nocopy JTF_VARCHAR2_TABLE_200
43     , a14 out nocopy JTF_VARCHAR2_TABLE_200
44     , a15 out nocopy JTF_VARCHAR2_TABLE_200
45     , a16 out nocopy JTF_VARCHAR2_TABLE_200
46     , a17 out nocopy JTF_VARCHAR2_TABLE_200
47     , a18 out nocopy JTF_VARCHAR2_TABLE_200
48     , a19 out nocopy JTF_VARCHAR2_TABLE_200
49     , a20 out nocopy JTF_VARCHAR2_TABLE_200
50     , a21 out nocopy JTF_VARCHAR2_TABLE_200
51     , a22 out nocopy JTF_VARCHAR2_TABLE_200
52     , a23 out nocopy JTF_VARCHAR2_TABLE_200
53     , a24 out nocopy JTF_VARCHAR2_TABLE_200
54     );
55 
56   procedure create_cat_activity(p_api_version_number  NUMBER
57     , p_init_msg_list  VARCHAR2
58     , p_commit  VARCHAR2
59     , p_validation_level  NUMBER
60     , x_return_status out nocopy  VARCHAR2
61     , x_msg_count out nocopy  NUMBER
62     , x_msg_data out nocopy  VARCHAR2
63     , x_cat_activity_id out nocopy  NUMBER
64     , p7_a0  NUMBER := 0-1962.0724
65     , p7_a1  NUMBER := 0-1962.0724
66     , p7_a2  NUMBER := 0-1962.0724
67     , p7_a3  NUMBER := 0-1962.0724
68     , p7_a4  DATE := fnd_api.g_miss_date
69     , p7_a5  NUMBER := 0-1962.0724
70     , p7_a6  DATE := fnd_api.g_miss_date
71     , p7_a7  NUMBER := 0-1962.0724
72     , p7_a8  NUMBER := 0-1962.0724
73     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
83     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
89   );
90   procedure update_cat_activity(p_api_version_number  NUMBER
91     , p_init_msg_list  VARCHAR2
92     , p_commit  VARCHAR2
93     , p_validation_level  NUMBER
94     , x_return_status out nocopy  VARCHAR2
95     , x_msg_count out nocopy  NUMBER
96     , x_msg_data out nocopy  VARCHAR2
97     , x_object_version_number out nocopy  NUMBER
98     , p7_a0  NUMBER := 0-1962.0724
99     , p7_a1  NUMBER := 0-1962.0724
100     , p7_a2  NUMBER := 0-1962.0724
101     , p7_a3  NUMBER := 0-1962.0724
102     , p7_a4  DATE := fnd_api.g_miss_date
103     , p7_a5  NUMBER := 0-1962.0724
104     , p7_a6  DATE := fnd_api.g_miss_date
105     , p7_a7  NUMBER := 0-1962.0724
106     , p7_a8  NUMBER := 0-1962.0724
107     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
108     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
109     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
110     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
111     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
113     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
114     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
115     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
116     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
117     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
118     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
119     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
120     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
121     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
122     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
123   );
124   procedure validate_cat_activity(p_api_version_number  NUMBER
125     , p_init_msg_list  VARCHAR2
126     , p_validation_level  NUMBER
127     , x_return_status out nocopy  VARCHAR2
128     , x_msg_count out nocopy  NUMBER
129     , x_msg_data out nocopy  VARCHAR2
130     , p3_a0  NUMBER := 0-1962.0724
131     , p3_a1  NUMBER := 0-1962.0724
132     , p3_a2  NUMBER := 0-1962.0724
133     , p3_a3  NUMBER := 0-1962.0724
134     , p3_a4  DATE := fnd_api.g_miss_date
135     , p3_a5  NUMBER := 0-1962.0724
136     , p3_a6  DATE := fnd_api.g_miss_date
137     , p3_a7  NUMBER := 0-1962.0724
138     , p3_a8  NUMBER := 0-1962.0724
139     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
140     , p3_a10  VARCHAR2 := fnd_api.g_miss_char
141     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
142     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
143     , p3_a13  VARCHAR2 := fnd_api.g_miss_char
144     , p3_a14  VARCHAR2 := fnd_api.g_miss_char
145     , p3_a15  VARCHAR2 := fnd_api.g_miss_char
146     , p3_a16  VARCHAR2 := fnd_api.g_miss_char
147     , p3_a17  VARCHAR2 := fnd_api.g_miss_char
148     , p3_a18  VARCHAR2 := fnd_api.g_miss_char
149     , p3_a19  VARCHAR2 := fnd_api.g_miss_char
150     , p3_a20  VARCHAR2 := fnd_api.g_miss_char
151     , p3_a21  VARCHAR2 := fnd_api.g_miss_char
152     , p3_a22  VARCHAR2 := fnd_api.g_miss_char
153     , p3_a23  VARCHAR2 := fnd_api.g_miss_char
154     , p3_a24  VARCHAR2 := fnd_api.g_miss_char
155   );
156   procedure check_cat_activity_items(p_validation_mode  VARCHAR2
157     , x_return_status out nocopy  VARCHAR2
158     , p0_a0  NUMBER := 0-1962.0724
159     , p0_a1  NUMBER := 0-1962.0724
160     , p0_a2  NUMBER := 0-1962.0724
161     , p0_a3  NUMBER := 0-1962.0724
162     , p0_a4  DATE := fnd_api.g_miss_date
163     , p0_a5  NUMBER := 0-1962.0724
164     , p0_a6  DATE := fnd_api.g_miss_date
165     , p0_a7  NUMBER := 0-1962.0724
166     , p0_a8  NUMBER := 0-1962.0724
167     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
168     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
169     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
171     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
172     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
173     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
174     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
175     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
176     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
178     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
179     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
180     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
181     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
183   );
184   procedure validate_cat_activity_rec(p_api_version_number  NUMBER
185     , p_init_msg_list  VARCHAR2
186     , x_return_status out nocopy  VARCHAR2
187     , x_msg_count out nocopy  NUMBER
188     , x_msg_data out nocopy  VARCHAR2
189     , p5_a0  NUMBER := 0-1962.0724
190     , p5_a1  NUMBER := 0-1962.0724
191     , p5_a2  NUMBER := 0-1962.0724
192     , p5_a3  NUMBER := 0-1962.0724
193     , p5_a4  DATE := fnd_api.g_miss_date
194     , p5_a5  NUMBER := 0-1962.0724
195     , p5_a6  DATE := fnd_api.g_miss_date
196     , p5_a7  NUMBER := 0-1962.0724
197     , p5_a8  NUMBER := 0-1962.0724
198     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
200     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
201     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
202     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
205     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
206     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
207     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
208     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
209     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
210     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
213     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
214   );
215 end ams_cat_activity_pvt_w;