[Home] [Help]
PACKAGE: APPS.AHL_RA_NR_PROFILE_PVT_W
Source
1 package ahl_ra_nr_profile_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWNRPS.pls 120.0.12020000.2 2012/12/13 06:29:37 shnatu noship $ */
3 procedure rosetta_table_copy_in_p4(t out nocopy ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_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_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_300
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_VARCHAR2_TABLE_300
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_VARCHAR2_TABLE_100
33 );
34 procedure rosetta_table_copy_out_p4(t ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35 , a1 out nocopy JTF_NUMBER_TABLE
36 , a2 out nocopy JTF_DATE_TABLE
37 , a3 out nocopy JTF_NUMBER_TABLE
38 , a4 out nocopy JTF_DATE_TABLE
39 , a5 out nocopy JTF_NUMBER_TABLE
40 , a6 out nocopy JTF_NUMBER_TABLE
41 , a7 out nocopy JTF_NUMBER_TABLE
42 , a8 out nocopy JTF_VARCHAR2_TABLE_100
43 , a9 out nocopy JTF_VARCHAR2_TABLE_100
44 , a10 out nocopy JTF_NUMBER_TABLE
45 , a11 out nocopy JTF_VARCHAR2_TABLE_300
46 , a12 out nocopy JTF_VARCHAR2_TABLE_100
47 , a13 out nocopy JTF_VARCHAR2_TABLE_100
48 , a14 out nocopy JTF_NUMBER_TABLE
49 , a15 out nocopy JTF_VARCHAR2_TABLE_300
50 , a16 out nocopy JTF_VARCHAR2_TABLE_100
51 , a17 out nocopy JTF_NUMBER_TABLE
52 , a18 out nocopy JTF_NUMBER_TABLE
53 , a19 out nocopy JTF_NUMBER_TABLE
54 , a20 out nocopy JTF_VARCHAR2_TABLE_200
55 , a21 out nocopy JTF_NUMBER_TABLE
56 , a22 out nocopy JTF_VARCHAR2_TABLE_200
57 , a23 out nocopy JTF_VARCHAR2_TABLE_100
58 , a24 out nocopy JTF_VARCHAR2_TABLE_100
59 , a25 out nocopy JTF_DATE_TABLE
60 , a26 out nocopy JTF_DATE_TABLE
61 , a27 out nocopy JTF_NUMBER_TABLE
62 , a28 out nocopy JTF_VARCHAR2_TABLE_100
63 , a29 out nocopy JTF_VARCHAR2_TABLE_100
64 );
65
66 procedure rosetta_table_copy_in_p6(t out nocopy ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 JTF_NUMBER_TABLE
67 , a1 JTF_NUMBER_TABLE
68 , a2 JTF_NUMBER_TABLE
69 , a3 JTF_VARCHAR2_TABLE_100
70 );
71 procedure rosetta_table_copy_out_p6(t ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72 , a1 out nocopy JTF_NUMBER_TABLE
73 , a2 out nocopy JTF_NUMBER_TABLE
74 , a3 out nocopy JTF_VARCHAR2_TABLE_100
75 );
76
77 procedure rosetta_table_copy_in_p8(t out nocopy ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 JTF_NUMBER_TABLE
78 , a1 JTF_NUMBER_TABLE
79 , a2 JTF_NUMBER_TABLE
80 , a3 JTF_VARCHAR2_TABLE_100
81 , a4 JTF_VARCHAR2_TABLE_100
82 );
83 procedure rosetta_table_copy_out_p8(t ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
84 , a1 out nocopy JTF_NUMBER_TABLE
85 , a2 out nocopy JTF_NUMBER_TABLE
86 , a3 out nocopy JTF_VARCHAR2_TABLE_100
87 , a4 out nocopy JTF_VARCHAR2_TABLE_100
88 );
89
90 procedure populate_prof_res_req(p_mr_header_id NUMBER
91 , p_instance_id NUMBER
92 , p_ue_id NUMBER
93 , p_plan_id NUMBER
94 , x_return_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , p7_a0 out nocopy JTF_NUMBER_TABLE
98 , p7_a1 out nocopy JTF_NUMBER_TABLE
99 , p7_a2 out nocopy JTF_NUMBER_TABLE
100 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
101 );
102 procedure populate_prof_mat_req(p_mr_header_id NUMBER
103 , p_instance_id NUMBER
104 , p_ue_id NUMBER
105 , p_plan_id NUMBER
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 , p7_a0 out nocopy JTF_NUMBER_TABLE
110 , p7_a1 out nocopy JTF_NUMBER_TABLE
111 , p7_a2 out nocopy JTF_NUMBER_TABLE
112 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
113 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
114 );
115 procedure process_nr_profile(p_api_version NUMBER
116 , p_init_msg_list VARCHAR2
117 , p_commit 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 , p7_a0 in out nocopy NUMBER
123 , p7_a1 in out nocopy NUMBER
124 , p7_a2 in out nocopy DATE
125 , p7_a3 in out nocopy NUMBER
126 , p7_a4 in out nocopy DATE
127 , p7_a5 in out nocopy NUMBER
128 , p7_a6 in out nocopy NUMBER
129 , p7_a7 in out nocopy VARCHAR2
130 , p7_a8 in out nocopy VARCHAR2
131 , p7_a9 in out nocopy VARCHAR2
132 , p7_a10 in out nocopy VARCHAR2
133 , p7_a11 in out nocopy NUMBER
134 , p7_a12 in out nocopy VARCHAR2
135 , p7_a13 in out nocopy VARCHAR2
136 , p7_a14 in out nocopy VARCHAR2
137 , p7_a15 in out nocopy VARCHAR2
138 , p7_a16 in out nocopy VARCHAR2
139 , p7_a17 in out nocopy VARCHAR2
140 , p7_a18 in out nocopy VARCHAR2
141 , p7_a19 in out nocopy VARCHAR2
142 , p7_a20 in out nocopy VARCHAR2
143 , p7_a21 in out nocopy VARCHAR2
144 , p7_a22 in out nocopy VARCHAR2
145 , p7_a23 in out nocopy VARCHAR2
146 , p7_a24 in out nocopy VARCHAR2
147 , p7_a25 in out nocopy VARCHAR2
148 , p7_a26 in out nocopy VARCHAR2
149 , p7_a27 in out nocopy VARCHAR2
150 , p7_a28 in out nocopy VARCHAR2
151 );
152 procedure add_details_to_prof(p_api_version NUMBER
153 , p_init_msg_list VARCHAR2
154 , p_commit VARCHAR2
155 , p_validation_level NUMBER
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 , p7_a0 in out nocopy JTF_NUMBER_TABLE
160 , p7_a1 in out nocopy JTF_NUMBER_TABLE
161 , p7_a2 in out nocopy JTF_DATE_TABLE
162 , p7_a3 in out nocopy JTF_NUMBER_TABLE
163 , p7_a4 in out nocopy JTF_DATE_TABLE
164 , p7_a5 in out nocopy JTF_NUMBER_TABLE
165 , p7_a6 in out nocopy JTF_NUMBER_TABLE
166 , p7_a7 in out nocopy JTF_NUMBER_TABLE
167 , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
168 , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
169 , p7_a10 in out nocopy JTF_NUMBER_TABLE
170 , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_300
171 , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
172 , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
173 , p7_a14 in out nocopy JTF_NUMBER_TABLE
174 , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_300
175 , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
176 , p7_a17 in out nocopy JTF_NUMBER_TABLE
177 , p7_a18 in out nocopy JTF_NUMBER_TABLE
178 , p7_a19 in out nocopy JTF_NUMBER_TABLE
179 , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
180 , p7_a21 in out nocopy JTF_NUMBER_TABLE
181 , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
182 , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_100
183 , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_100
184 , p7_a25 in out nocopy JTF_DATE_TABLE
185 , p7_a26 in out nocopy JTF_DATE_TABLE
186 , p7_a27 in out nocopy JTF_NUMBER_TABLE
187 , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100
188 , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
189 );
190 end ahl_ra_nr_profile_pvt_w;