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_IBA_PLCMNT_PVT_W

Source


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