[Home] [Help]
PACKAGE: APPS.AHL_FMP_PVT_W
Source
1 package ahl_fmp_pvt_w as
2 /* $Header: AHLWFMPS.pls 120.0.12000000.3 2007/10/19 23:18:58 sracha ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_4000
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_400
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16 , a1 out nocopy JTF_VARCHAR2_TABLE_100
17 , a2 out nocopy JTF_VARCHAR2_TABLE_4000
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_VARCHAR2_TABLE_400
20 , a5 out nocopy JTF_VARCHAR2_TABLE_300
21 , a6 out nocopy JTF_VARCHAR2_TABLE_100
22 , a7 out nocopy JTF_NUMBER_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_NUMBER_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_NUMBER_TABLE
31 , a3 JTF_VARCHAR2_TABLE_100
32 , a4 JTF_VARCHAR2_TABLE_100
33 , a5 JTF_NUMBER_TABLE
34 , a6 JTF_VARCHAR2_TABLE_100
35 , a7 JTF_VARCHAR2_TABLE_100
36 , a8 JTF_NUMBER_TABLE
37 );
38 procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39 , a1 out nocopy JTF_NUMBER_TABLE
40 , a2 out nocopy JTF_NUMBER_TABLE
41 , a3 out nocopy JTF_VARCHAR2_TABLE_100
42 , a4 out nocopy JTF_VARCHAR2_TABLE_100
43 , a5 out nocopy JTF_NUMBER_TABLE
44 , a6 out nocopy JTF_VARCHAR2_TABLE_100
45 , a7 out nocopy JTF_VARCHAR2_TABLE_100
46 , a8 out nocopy JTF_NUMBER_TABLE
47 );
48
49 procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50 , a1 JTF_NUMBER_TABLE
51 , a2 JTF_NUMBER_TABLE
52 , a3 JTF_NUMBER_TABLE
53 , a4 JTF_NUMBER_TABLE
54 , a5 JTF_VARCHAR2_TABLE_100
55 , a6 JTF_VARCHAR2_TABLE_100
56 , a7 JTF_VARCHAR2_TABLE_100
57 , a8 JTF_VARCHAR2_TABLE_100
58 , a9 JTF_VARCHAR2_TABLE_100
59 );
60 procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61 , a1 out nocopy JTF_NUMBER_TABLE
62 , a2 out nocopy JTF_NUMBER_TABLE
63 , a3 out nocopy JTF_NUMBER_TABLE
64 , a4 out nocopy JTF_NUMBER_TABLE
65 , a5 out nocopy JTF_VARCHAR2_TABLE_100
66 , a6 out nocopy JTF_VARCHAR2_TABLE_100
67 , a7 out nocopy JTF_VARCHAR2_TABLE_100
68 , a8 out nocopy JTF_VARCHAR2_TABLE_100
69 , a9 out nocopy JTF_VARCHAR2_TABLE_100
70 );
71
72 procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
73 , a1 JTF_VARCHAR2_TABLE_200
74 , a2 JTF_VARCHAR2_TABLE_200
75 , a3 JTF_VARCHAR2_TABLE_100
76 , a4 JTF_NUMBER_TABLE
77 , a5 JTF_VARCHAR2_TABLE_300
78 , a6 JTF_VARCHAR2_TABLE_300
79 , a7 JTF_NUMBER_TABLE
80 , a8 JTF_VARCHAR2_TABLE_200
81 , a9 JTF_VARCHAR2_TABLE_2000
82 , a10 JTF_VARCHAR2_TABLE_100
83 , a11 JTF_VARCHAR2_TABLE_100
84 , a12 JTF_NUMBER_TABLE
85 , a13 JTF_DATE_TABLE
86 , a14 JTF_DATE_TABLE
87 , a15 JTF_VARCHAR2_TABLE_100
88 , a16 JTF_VARCHAR2_TABLE_100
89 , a17 JTF_DATE_TABLE
90 , a18 JTF_DATE_TABLE
91 , a19 JTF_VARCHAR2_TABLE_100
92 , a20 JTF_VARCHAR2_TABLE_2000
93 , a21 JTF_DATE_TABLE
94 , a22 JTF_VARCHAR2_TABLE_100
95 , a23 JTF_VARCHAR2_TABLE_500
96 , a24 JTF_NUMBER_TABLE
97 );
98 procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99 , a1 out nocopy JTF_VARCHAR2_TABLE_200
100 , a2 out nocopy JTF_VARCHAR2_TABLE_200
101 , a3 out nocopy JTF_VARCHAR2_TABLE_100
102 , a4 out nocopy JTF_NUMBER_TABLE
103 , a5 out nocopy JTF_VARCHAR2_TABLE_300
104 , a6 out nocopy JTF_VARCHAR2_TABLE_300
105 , a7 out nocopy JTF_NUMBER_TABLE
106 , a8 out nocopy JTF_VARCHAR2_TABLE_200
107 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
108 , a10 out nocopy JTF_VARCHAR2_TABLE_100
109 , a11 out nocopy JTF_VARCHAR2_TABLE_100
110 , a12 out nocopy JTF_NUMBER_TABLE
111 , a13 out nocopy JTF_DATE_TABLE
112 , a14 out nocopy JTF_DATE_TABLE
113 , a15 out nocopy JTF_VARCHAR2_TABLE_100
114 , a16 out nocopy JTF_VARCHAR2_TABLE_100
115 , a17 out nocopy JTF_DATE_TABLE
116 , a18 out nocopy JTF_DATE_TABLE
117 , a19 out nocopy JTF_VARCHAR2_TABLE_100
118 , a20 out nocopy JTF_VARCHAR2_TABLE_2000
119 , a21 out nocopy JTF_DATE_TABLE
120 , a22 out nocopy JTF_VARCHAR2_TABLE_100
121 , a23 out nocopy JTF_VARCHAR2_TABLE_500
122 , a24 out nocopy JTF_NUMBER_TABLE
123 );
124
125 procedure get_mr_affected_items(p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , p_commit VARCHAR2
128 , p_validation_level NUMBER
129 , x_return_status out nocopy VARCHAR2
130 , x_msg_count out nocopy NUMBER
131 , x_msg_data out nocopy VARCHAR2
132 , p_mr_header_id NUMBER
133 , p_mr_effectivity_id NUMBER
134 , p_top_node_flag VARCHAR2
135 , p_unique_inst_flag VARCHAR2
136 , p_sort_flag VARCHAR2
137 , p12_a0 out nocopy JTF_VARCHAR2_TABLE_100
138 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
139 , p12_a2 out nocopy JTF_VARCHAR2_TABLE_4000
140 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
141 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
142 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
143 , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
144 , p12_a7 out nocopy JTF_NUMBER_TABLE
145 , p12_a8 out nocopy JTF_NUMBER_TABLE
146 , p12_a9 out nocopy JTF_NUMBER_TABLE
147 , p12_a10 out nocopy JTF_NUMBER_TABLE
148 );
149 procedure get_applicable_mrs(p_api_version NUMBER
150 , p_init_msg_list VARCHAR2
151 , p_commit VARCHAR2
152 , p_validation_level NUMBER
153 , x_return_status out nocopy VARCHAR2
154 , x_msg_count out nocopy NUMBER
155 , x_msg_data out nocopy VARCHAR2
156 , p_item_instance_id NUMBER
157 , p_mr_header_id NUMBER
158 , p_components_flag VARCHAR2
159 , p_include_donotimplmt VARCHAR2
160 , p_visit_type_code VARCHAR2
161 , p12_a0 out nocopy JTF_NUMBER_TABLE
162 , p12_a1 out nocopy JTF_NUMBER_TABLE
163 , p12_a2 out nocopy JTF_NUMBER_TABLE
164 , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
165 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
166 , p12_a5 out nocopy JTF_NUMBER_TABLE
167 , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
168 , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
169 , p12_a8 out nocopy JTF_NUMBER_TABLE
170 );
171 procedure get_pm_applicable_mrs(p_api_version NUMBER
172 , p_init_msg_list VARCHAR2
173 , p_commit VARCHAR2
174 , p_validation_level NUMBER
175 , x_return_status out nocopy VARCHAR2
176 , x_msg_count out nocopy NUMBER
177 , x_msg_data out nocopy VARCHAR2
178 , p_item_instance_id NUMBER
179 , p8_a0 out nocopy JTF_NUMBER_TABLE
180 , p8_a1 out nocopy JTF_NUMBER_TABLE
181 , p8_a2 out nocopy JTF_NUMBER_TABLE
182 , p8_a3 out nocopy JTF_NUMBER_TABLE
183 , p8_a4 out nocopy JTF_NUMBER_TABLE
184 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
185 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
186 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
187 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
188 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
189 , p9_a0 out nocopy JTF_NUMBER_TABLE
190 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
191 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
192 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
193 , p9_a4 out nocopy JTF_NUMBER_TABLE
194 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
195 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
196 , p9_a7 out nocopy JTF_NUMBER_TABLE
197 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
198 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
199 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
200 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
201 , p9_a12 out nocopy JTF_NUMBER_TABLE
202 , p9_a13 out nocopy JTF_DATE_TABLE
203 , p9_a14 out nocopy JTF_DATE_TABLE
204 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
205 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
206 , p9_a17 out nocopy JTF_DATE_TABLE
207 , p9_a18 out nocopy JTF_DATE_TABLE
208 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
209 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
210 , p9_a21 out nocopy JTF_DATE_TABLE
211 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
212 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
213 , p9_a24 out nocopy JTF_NUMBER_TABLE
214 );
215 end ahl_fmp_pvt_w;