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_LTP_MATRL_AVAL_PUB_W

Source


1 package ahl_ltp_matrl_aval_pub_w as
2   /* $Header: AHLWMTAS.pls 120.1 2008/02/25 11:38:08 rnahata ship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_VARCHAR2_TABLE_2000
21     , a18 JTF_VARCHAR2_TABLE_100
22     );
23   procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
24     , a1 out nocopy JTF_NUMBER_TABLE
25     , a2 out nocopy JTF_NUMBER_TABLE
26     , a3 out nocopy JTF_VARCHAR2_TABLE_100
27     , a4 out nocopy JTF_NUMBER_TABLE
28     , a5 out nocopy JTF_NUMBER_TABLE
29     , a6 out nocopy JTF_NUMBER_TABLE
30     , a7 out nocopy JTF_NUMBER_TABLE
31     , a8 out nocopy JTF_VARCHAR2_TABLE_100
32     , a9 out nocopy JTF_VARCHAR2_TABLE_100
33     , a10 out nocopy JTF_VARCHAR2_TABLE_100
34     , a11 out nocopy JTF_DATE_TABLE
35     , a12 out nocopy JTF_NUMBER_TABLE
36     , a13 out nocopy JTF_NUMBER_TABLE
37     , a14 out nocopy JTF_DATE_TABLE
38     , a15 out nocopy JTF_VARCHAR2_TABLE_100
39     , a16 out nocopy JTF_NUMBER_TABLE
40     , a17 out nocopy JTF_VARCHAR2_TABLE_2000
41     , a18 out nocopy JTF_VARCHAR2_TABLE_100
42     );
43 
44   procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
45     , a1 JTF_NUMBER_TABLE
46     , a2 JTF_NUMBER_TABLE
47     , a3 JTF_VARCHAR2_TABLE_100
48     , a4 JTF_VARCHAR2_TABLE_100
49     , a5 JTF_VARCHAR2_TABLE_100
50     , a6 JTF_NUMBER_TABLE
51     , a7 JTF_NUMBER_TABLE
52     , a8 JTF_NUMBER_TABLE
53     , a9 JTF_VARCHAR2_TABLE_100
54     , a10 JTF_DATE_TABLE
55     , a11 JTF_VARCHAR2_TABLE_100
56     , a12 JTF_NUMBER_TABLE
57     , a13 JTF_DATE_TABLE
58     , a14 JTF_VARCHAR2_TABLE_300
59     , a15 JTF_NUMBER_TABLE
60     );
61   procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
62     , a1 out nocopy JTF_NUMBER_TABLE
63     , a2 out nocopy JTF_NUMBER_TABLE
64     , a3 out nocopy JTF_VARCHAR2_TABLE_100
65     , a4 out nocopy JTF_VARCHAR2_TABLE_100
66     , a5 out nocopy JTF_VARCHAR2_TABLE_100
67     , a6 out nocopy JTF_NUMBER_TABLE
68     , a7 out nocopy JTF_NUMBER_TABLE
69     , a8 out nocopy JTF_NUMBER_TABLE
70     , a9 out nocopy JTF_VARCHAR2_TABLE_100
71     , a10 out nocopy JTF_DATE_TABLE
72     , a11 out nocopy JTF_VARCHAR2_TABLE_100
73     , a12 out nocopy JTF_NUMBER_TABLE
74     , a13 out nocopy JTF_DATE_TABLE
75     , a14 out nocopy JTF_VARCHAR2_TABLE_300
76     , a15 out nocopy JTF_NUMBER_TABLE
77     );
78 
79   procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
80     , a1 JTF_NUMBER_TABLE
81     , a2 JTF_NUMBER_TABLE
82     , a3 JTF_VARCHAR2_TABLE_100
83     , a4 JTF_NUMBER_TABLE
84     , a5 JTF_NUMBER_TABLE
85     , a6 JTF_NUMBER_TABLE
86     , a7 JTF_VARCHAR2_TABLE_300
87     , a8 JTF_VARCHAR2_TABLE_100
88     , a9 JTF_VARCHAR2_TABLE_100
89     , a10 JTF_VARCHAR2_TABLE_100
90     , a11 JTF_DATE_TABLE
91     , a12 JTF_NUMBER_TABLE
92     , a13 JTF_NUMBER_TABLE
93     , a14 JTF_DATE_TABLE
94     , a15 JTF_VARCHAR2_TABLE_100
95     , a16 JTF_VARCHAR2_TABLE_100
96     , a17 JTF_VARCHAR2_TABLE_100
97     , a18 JTF_NUMBER_TABLE
98     , a19 JTF_VARCHAR2_TABLE_2000
99     );
100   procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
101     , a1 out nocopy JTF_NUMBER_TABLE
102     , a2 out nocopy JTF_NUMBER_TABLE
103     , a3 out nocopy JTF_VARCHAR2_TABLE_100
104     , a4 out nocopy JTF_NUMBER_TABLE
105     , a5 out nocopy JTF_NUMBER_TABLE
106     , a6 out nocopy JTF_NUMBER_TABLE
107     , a7 out nocopy JTF_VARCHAR2_TABLE_300
108     , a8 out nocopy JTF_VARCHAR2_TABLE_100
109     , a9 out nocopy JTF_VARCHAR2_TABLE_100
110     , a10 out nocopy JTF_VARCHAR2_TABLE_100
111     , a11 out nocopy JTF_DATE_TABLE
112     , a12 out nocopy JTF_NUMBER_TABLE
113     , a13 out nocopy JTF_NUMBER_TABLE
114     , a14 out nocopy JTF_DATE_TABLE
115     , a15 out nocopy JTF_VARCHAR2_TABLE_100
116     , a16 out nocopy JTF_VARCHAR2_TABLE_100
117     , a17 out nocopy JTF_VARCHAR2_TABLE_100
118     , a18 out nocopy JTF_NUMBER_TABLE
119     , a19 out nocopy JTF_VARCHAR2_TABLE_2000
120     );
121 
122   procedure check_material_aval(p_api_version  NUMBER
123     , p_init_msg_list  VARCHAR2
124     , p_commit  VARCHAR2
125     , p_validation_level  NUMBER
126     , p_module_type  VARCHAR2
127     , p5_a0 in out nocopy JTF_NUMBER_TABLE
128     , p5_a1 in out nocopy JTF_NUMBER_TABLE
129     , p5_a2 in out nocopy JTF_NUMBER_TABLE
130     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
131     , p5_a4 in out nocopy JTF_NUMBER_TABLE
132     , p5_a5 in out nocopy JTF_NUMBER_TABLE
133     , p5_a6 in out nocopy JTF_NUMBER_TABLE
134     , p5_a7 in out nocopy JTF_NUMBER_TABLE
135     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
136     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
137     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
138     , p5_a11 in out nocopy JTF_DATE_TABLE
139     , p5_a12 in out nocopy JTF_NUMBER_TABLE
140     , p5_a13 in out nocopy JTF_NUMBER_TABLE
141     , p5_a14 in out nocopy JTF_DATE_TABLE
142     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
143     , p5_a16 in out nocopy JTF_NUMBER_TABLE
144     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_2000
145     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
146     , x_return_status out nocopy  VARCHAR2
147     , x_msg_count out nocopy  NUMBER
148     , x_msg_data out nocopy  VARCHAR2
149   );
150   procedure get_visit_task_materials(p_api_version  NUMBER
151     , p_init_msg_list  VARCHAR2
152     , p_commit  VARCHAR2
153     , p_validation_level  NUMBER
154     , p_module_type  VARCHAR2
155     , p_visit_id  NUMBER
156     , p6_a0 out nocopy JTF_NUMBER_TABLE
157     , p6_a1 out nocopy JTF_NUMBER_TABLE
158     , p6_a2 out nocopy JTF_NUMBER_TABLE
159     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
160     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
161     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
162     , p6_a6 out nocopy JTF_NUMBER_TABLE
163     , p6_a7 out nocopy JTF_NUMBER_TABLE
164     , p6_a8 out nocopy JTF_NUMBER_TABLE
165     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
166     , p6_a10 out nocopy JTF_DATE_TABLE
167     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
168     , p6_a12 out nocopy JTF_NUMBER_TABLE
169     , p6_a13 out nocopy JTF_DATE_TABLE
170     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
171     , p6_a15 out nocopy JTF_NUMBER_TABLE
172     , x_return_status out nocopy  VARCHAR2
173     , x_msg_count out nocopy  NUMBER
174     , x_msg_data out nocopy  VARCHAR2
175   );
176   procedure check_materials_for_all(p_api_version  NUMBER
177     , p_init_msg_list  VARCHAR2
178     , p_commit  VARCHAR2
179     , p_validation_level  NUMBER
180     , p_module_type  VARCHAR2
181     , p_visit_id  NUMBER
182     , p6_a0 out nocopy JTF_NUMBER_TABLE
183     , p6_a1 out nocopy JTF_NUMBER_TABLE
184     , p6_a2 out nocopy JTF_NUMBER_TABLE
185     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
186     , p6_a4 out nocopy JTF_NUMBER_TABLE
187     , p6_a5 out nocopy JTF_NUMBER_TABLE
188     , p6_a6 out nocopy JTF_NUMBER_TABLE
189     , p6_a7 out nocopy JTF_NUMBER_TABLE
190     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
191     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
192     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
193     , p6_a11 out nocopy JTF_DATE_TABLE
194     , p6_a12 out nocopy JTF_NUMBER_TABLE
195     , p6_a13 out nocopy JTF_NUMBER_TABLE
196     , p6_a14 out nocopy JTF_DATE_TABLE
197     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
198     , p6_a16 out nocopy JTF_NUMBER_TABLE
199     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
200     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
201     , x_return_status out nocopy  VARCHAR2
202     , x_msg_count out nocopy  NUMBER
203     , x_msg_data out nocopy  VARCHAR2
204   );
205   procedure schedule_planned_matrls(p_api_version  NUMBER
206     , p_init_msg_list  VARCHAR2
207     , p_commit  VARCHAR2
208     , p_validation_level  NUMBER
209     , p_module_type  VARCHAR2
210     , p5_a0 in out nocopy JTF_NUMBER_TABLE
211     , p5_a1 in out nocopy JTF_NUMBER_TABLE
212     , p5_a2 in out nocopy JTF_NUMBER_TABLE
213     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
214     , p5_a4 in out nocopy JTF_NUMBER_TABLE
215     , p5_a5 in out nocopy JTF_NUMBER_TABLE
216     , p5_a6 in out nocopy JTF_NUMBER_TABLE
217     , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
218     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
219     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
220     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
221     , p5_a11 in out nocopy JTF_DATE_TABLE
222     , p5_a12 in out nocopy JTF_NUMBER_TABLE
223     , p5_a13 in out nocopy JTF_NUMBER_TABLE
224     , p5_a14 in out nocopy JTF_DATE_TABLE
225     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
226     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
227     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
228     , p5_a18 in out nocopy JTF_NUMBER_TABLE
229     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_2000
230     , x_return_status out nocopy  VARCHAR2
231     , x_msg_count out nocopy  NUMBER
232     , x_msg_data out nocopy  VARCHAR2
233   );
234   procedure schedule_all_materials(p_api_version  NUMBER
235     , p_init_msg_list  VARCHAR2
236     , p_commit  VARCHAR2
237     , p_validation_level  NUMBER
238     , p_module_type  VARCHAR2
239     , p_visit_id  NUMBER
240     , p6_a0 out nocopy JTF_NUMBER_TABLE
241     , p6_a1 out nocopy JTF_NUMBER_TABLE
242     , p6_a2 out nocopy JTF_NUMBER_TABLE
243     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
244     , p6_a4 out nocopy JTF_NUMBER_TABLE
245     , p6_a5 out nocopy JTF_NUMBER_TABLE
246     , p6_a6 out nocopy JTF_NUMBER_TABLE
247     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
248     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
250     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
251     , p6_a11 out nocopy JTF_DATE_TABLE
252     , p6_a12 out nocopy JTF_NUMBER_TABLE
253     , p6_a13 out nocopy JTF_NUMBER_TABLE
254     , p6_a14 out nocopy JTF_DATE_TABLE
255     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
256     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
257     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
258     , p6_a18 out nocopy JTF_NUMBER_TABLE
259     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
260     , x_return_status out nocopy  VARCHAR2
261     , x_msg_count out nocopy  NUMBER
262     , x_msg_data out nocopy  VARCHAR2
263   );
264 end ahl_ltp_matrl_aval_pub_w;