[Home] [Help]
PACKAGE: APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT_W
Source
1 PACKAGE ahl_mr_loop_chain_relns_pvt_w AUTHID CURRENT_USER AS
2 /* $Header: AHLWLCRS.pls 120.0.12020000.2 2012/12/14 09:47:43 shnatu noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_mr_loop_chain_relns_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_mr_loop_chain_relns_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_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_VARCHAR2_TABLE_100
31 , a3 JTF_VARCHAR2_TABLE_100
32 , a4 JTF_NUMBER_TABLE
33 , a5 JTF_VARCHAR2_TABLE_100
34 , a6 JTF_VARCHAR2_TABLE_100
35 , a7 JTF_VARCHAR2_TABLE_100
36 , a8 JTF_VARCHAR2_TABLE_2000
37 , a9 JTF_VARCHAR2_TABLE_100
38 , a10 JTF_DATE_TABLE
39 , a11 JTF_DATE_TABLE
40 , a12 JTF_NUMBER_TABLE
41 , a13 JTF_VARCHAR2_TABLE_100
42 );
43 procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44 , a1 out nocopy JTF_NUMBER_TABLE
45 , a2 out nocopy JTF_VARCHAR2_TABLE_100
46 , a3 out nocopy JTF_VARCHAR2_TABLE_100
47 , a4 out nocopy JTF_NUMBER_TABLE
48 , a5 out nocopy JTF_VARCHAR2_TABLE_100
49 , a6 out nocopy JTF_VARCHAR2_TABLE_100
50 , a7 out nocopy JTF_VARCHAR2_TABLE_100
51 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
52 , a9 out nocopy JTF_VARCHAR2_TABLE_100
53 , a10 out nocopy JTF_DATE_TABLE
54 , a11 out nocopy JTF_DATE_TABLE
55 , a12 out nocopy JTF_NUMBER_TABLE
56 , a13 out nocopy JTF_VARCHAR2_TABLE_100
57 );
58
59 procedure rosetta_table_copy_in_p5(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 JTF_NUMBER_TABLE
60 , a1 JTF_NUMBER_TABLE
61 , a2 JTF_NUMBER_TABLE
62 , a3 JTF_VARCHAR2_TABLE_100
63 );
64 procedure rosetta_table_copy_out_p5(t ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_NUMBER_TABLE
66 , a2 out nocopy JTF_NUMBER_TABLE
67 , a3 out nocopy JTF_VARCHAR2_TABLE_100
68 );
69
70 procedure rosetta_table_copy_in_p6(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 JTF_NUMBER_TABLE);
71 procedure rosetta_table_copy_out_p6(t ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
72
73 procedure rosetta_table_copy_in_p7(t out nocopy ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 JTF_VARCHAR2_TABLE_100);
74 procedure rosetta_table_copy_out_p7(t ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75
76 procedure validate_loop_chain(p_api_version NUMBER
77 , p_init_msg_list VARCHAR2
78 , p_commit VARCHAR2
79 , p_validation_level NUMBER
80 , p_page_mode VARCHAR2
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100
84 , x_mr_header_id out nocopy JTF_NUMBER_TABLE
85 , p9_a0 JTF_NUMBER_TABLE
86 , p9_a1 JTF_NUMBER_TABLE
87 , p9_a2 JTF_NUMBER_TABLE
88 , p9_a3 JTF_VARCHAR2_TABLE_100
89 );
90 procedure get_start_mr_relns(p_mr_header_id NUMBER
91 , p_rel_code VARCHAR2
92 , p2_a0 out nocopy JTF_NUMBER_TABLE
93 , p2_a1 out nocopy JTF_NUMBER_TABLE
94 , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
95 , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
96 , p2_a4 out nocopy JTF_NUMBER_TABLE
97 , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
98 , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
99 , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
100 , p2_a8 out nocopy JTF_VARCHAR2_TABLE_2000
101 , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
102 , p2_a10 out nocopy JTF_DATE_TABLE
103 , p2_a11 out nocopy JTF_DATE_TABLE
104 , p2_a12 out nocopy JTF_NUMBER_TABLE
105 , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 );
110 procedure get_cm_affected_items(p_api_version NUMBER
111 , p_init_msg_list VARCHAR2
112 , p_commit VARCHAR2
113 , p_validation_level NUMBER
114 , x_return_status out nocopy VARCHAR2
115 , x_msg_count out nocopy NUMBER
116 , x_msg_data out nocopy VARCHAR2
117 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
118 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
119 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_4000
120 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
121 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
122 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
123 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
124 , p7_a7 out nocopy JTF_NUMBER_TABLE
125 , p7_a8 out nocopy JTF_NUMBER_TABLE
126 , p7_a9 out nocopy JTF_NUMBER_TABLE
127 , p7_a10 out nocopy JTF_NUMBER_TABLE
128 , p8_a0 JTF_NUMBER_TABLE
129 , p8_a1 JTF_NUMBER_TABLE
130 , p8_a2 JTF_VARCHAR2_TABLE_100
131 , p8_a3 JTF_VARCHAR2_TABLE_100
132 , p8_a4 JTF_NUMBER_TABLE
133 , p8_a5 JTF_VARCHAR2_TABLE_100
134 , p8_a6 JTF_VARCHAR2_TABLE_100
135 , p8_a7 JTF_VARCHAR2_TABLE_100
136 , p8_a8 JTF_VARCHAR2_TABLE_2000
137 , p8_a9 JTF_VARCHAR2_TABLE_100
138 , p8_a10 JTF_DATE_TABLE
139 , p8_a11 JTF_DATE_TABLE
140 , p8_a12 JTF_NUMBER_TABLE
141 , p8_a13 JTF_VARCHAR2_TABLE_100
142 );
143 procedure view_mr_loop_chain(p_api_version NUMBER
144 , p_init_msg_list VARCHAR2
145 , p_commit VARCHAR2
146 , p_validation_level NUMBER
147 , x_return_status out nocopy VARCHAR2
148 , x_msg_count out nocopy NUMBER
149 , x_msg_data out nocopy VARCHAR2
150 , p_start_mr_reln_id NUMBER
151 , p_relationship VARCHAR2
152 , p_mr_header_id NUMBER
153 , p_ue_id NUMBER
154 , p_calling_module VARCHAR2
155 , p_item_instance_id NUMBER
156 , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
157 , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
158 , p13_a2 out nocopy JTF_VARCHAR2_TABLE_4000
159 , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
160 , p13_a4 out nocopy JTF_VARCHAR2_TABLE_400
161 , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
162 , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
163 , p13_a7 out nocopy JTF_NUMBER_TABLE
164 , p13_a8 out nocopy JTF_NUMBER_TABLE
165 , p13_a9 out nocopy JTF_NUMBER_TABLE
166 , p13_a10 out nocopy JTF_NUMBER_TABLE
167 , p14_a0 out nocopy JTF_NUMBER_TABLE
168 , p14_a1 out nocopy JTF_NUMBER_TABLE
169 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
170 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
171 , p14_a4 out nocopy JTF_NUMBER_TABLE
172 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
173 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
174 , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
175 , p14_a8 out nocopy JTF_VARCHAR2_TABLE_2000
176 , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
177 , p14_a10 out nocopy JTF_DATE_TABLE
178 , p14_a11 out nocopy JTF_DATE_TABLE
179 , p14_a12 out nocopy JTF_NUMBER_TABLE
180 , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100
181 );
182 procedure get_valid_loop_chain_relns(p_mr_header_id NUMBER
183 , p_effective_from DATE
184 , p_effective_to DATE
185 , p_rel_code VARCHAR2
186 , x_return_status out nocopy VARCHAR2
187 , x_msg_count out nocopy NUMBER
188 , x_msg_data out nocopy VARCHAR2
189 , p7_a0 out nocopy JTF_NUMBER_TABLE
190 , p7_a1 out nocopy JTF_NUMBER_TABLE
191 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
192 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
193 , p7_a4 out nocopy JTF_NUMBER_TABLE
194 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
195 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
196 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
197 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000
198 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
199 , p7_a10 out nocopy JTF_DATE_TABLE
200 , p7_a11 out nocopy JTF_DATE_TABLE
201 , p7_a12 out nocopy JTF_NUMBER_TABLE
202 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
203 );
204 end ahl_mr_loop_chain_relns_pvt_w;