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_ACTRESOURCE_PUB_W

Source


1 package ams_actresource_pub_w AUTHID CURRENT_USER as
2   /* $Header: amswrscs.pls 115.8 2002/11/16 01:47:21 dbiswas ship $ */
3   procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_actresource_pub.act_resource_rec_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_DATE_TABLE
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_4000
20     , a17 JTF_VARCHAR2_TABLE_100
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     , 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     );
37   procedure rosetta_table_copy_out_p3(t ams_actresource_pub.act_resource_rec_tbl, a0 OUT NOCOPY JTF_NUMBER_TABLE
38     , a1 OUT NOCOPY JTF_DATE_TABLE
39     , a2 OUT NOCOPY JTF_NUMBER_TABLE
40     , a3 OUT NOCOPY JTF_DATE_TABLE
41     , a4 OUT NOCOPY JTF_NUMBER_TABLE
42     , a5 OUT NOCOPY JTF_NUMBER_TABLE
43     , a6 OUT NOCOPY JTF_NUMBER_TABLE
44     , a7 OUT NOCOPY JTF_NUMBER_TABLE
45     , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46     , a9 OUT NOCOPY JTF_NUMBER_TABLE
47     , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48     , a11 OUT NOCOPY JTF_NUMBER_TABLE
49     , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50     , a13 OUT NOCOPY JTF_DATE_TABLE
51     , a14 OUT NOCOPY JTF_DATE_TABLE
52     , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53     , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
54     , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
55     , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_200
56     , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_200
57     , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_200
58     , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_200
59     , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_200
60     , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_200
61     , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_200
62     , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_200
63     , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_200
64     , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_200
65     , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_200
66     , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
67     , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_200
68     , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_200
69     , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
70     );
71 
72   procedure create_act_resource(p_api_version  NUMBER
73     , p_init_msg_list  VARCHAR2
74     , p_commit  VARCHAR2
75     , p_validation_level  NUMBER
76     , x_return_status OUT NOCOPY  VARCHAR2
77     , x_msg_count OUT NOCOPY  NUMBER
78     , x_msg_data OUT NOCOPY  VARCHAR2
79     , x_act_resource_id OUT NOCOPY  NUMBER
80     , p7_a0  NUMBER := 0-1962.0724
81     , p7_a1  DATE := fnd_api.g_miss_date
82     , p7_a2  NUMBER := 0-1962.0724
83     , p7_a3  DATE := fnd_api.g_miss_date
84     , p7_a4  NUMBER := 0-1962.0724
85     , p7_a5  NUMBER := 0-1962.0724
86     , p7_a6  NUMBER := 0-1962.0724
87     , p7_a7  NUMBER := 0-1962.0724
88     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
89     , p7_a9  NUMBER := 0-1962.0724
90     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a11  NUMBER := 0-1962.0724
92     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a13  DATE := fnd_api.g_miss_date
94     , p7_a14  DATE := fnd_api.g_miss_date
95     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
100     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
107     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
108     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
109     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
110     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
111     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
113   );
114   procedure update_act_resource(p_api_version  NUMBER
115     , p_init_msg_list  VARCHAR2
116     , p_commit  VARCHAR2
117     , p_validation_level  NUMBER
118     , x_return_status OUT NOCOPY  VARCHAR2
119     , x_msg_count OUT NOCOPY  NUMBER
120     , x_msg_data OUT NOCOPY  VARCHAR2
121     , p7_a0  NUMBER := 0-1962.0724
122     , p7_a1  DATE := fnd_api.g_miss_date
123     , p7_a2  NUMBER := 0-1962.0724
124     , p7_a3  DATE := fnd_api.g_miss_date
125     , p7_a4  NUMBER := 0-1962.0724
126     , p7_a5  NUMBER := 0-1962.0724
127     , p7_a6  NUMBER := 0-1962.0724
128     , p7_a7  NUMBER := 0-1962.0724
129     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
130     , p7_a9  NUMBER := 0-1962.0724
131     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
132     , p7_a11  NUMBER := 0-1962.0724
133     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
134     , p7_a13  DATE := fnd_api.g_miss_date
135     , p7_a14  DATE := fnd_api.g_miss_date
136     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
137     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
138     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
139     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
140     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
142     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
146     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
147     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
148     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
149     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
150     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
151     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
152     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
153     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
154   );
155   procedure validate_act_resource(p_api_version  NUMBER
156     , p_init_msg_list  VARCHAR2
157     , p_validation_level  NUMBER
158     , x_return_status OUT NOCOPY  VARCHAR2
159     , x_msg_count OUT NOCOPY  NUMBER
160     , x_msg_data OUT NOCOPY  VARCHAR2
161     , p6_a0  NUMBER := 0-1962.0724
162     , p6_a1  DATE := fnd_api.g_miss_date
163     , p6_a2  NUMBER := 0-1962.0724
164     , p6_a3  DATE := fnd_api.g_miss_date
165     , p6_a4  NUMBER := 0-1962.0724
166     , p6_a5  NUMBER := 0-1962.0724
167     , p6_a6  NUMBER := 0-1962.0724
168     , p6_a7  NUMBER := 0-1962.0724
169     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
170     , p6_a9  NUMBER := 0-1962.0724
171     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
172     , p6_a11  NUMBER := 0-1962.0724
173     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
174     , p6_a13  DATE := fnd_api.g_miss_date
175     , p6_a14  DATE := fnd_api.g_miss_date
176     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
177     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
178     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
179     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
180     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
181     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
182     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
183     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
184     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
185     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
186     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
187     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
188     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
189     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
190     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
191     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
192     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
193     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
194   );
195 end ams_actresource_pub_w;