1 package jtf_deliverable_grp_w AUTHID CURRENT_USER as
2 /* $Header: JTFGRDLS.pls 115.9 2004/07/09 18:50:40 applrt ship $ */
3 procedure rosetta_table_copy_in_p1(t out jtf_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_VARCHAR2_TABLE_2000
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 );
13 procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
14 , a1 out JTF_VARCHAR2_TABLE_100
15 , a2 out JTF_VARCHAR2_TABLE_300
16 , a3 out JTF_VARCHAR2_TABLE_100
17 , a4 out JTF_VARCHAR2_TABLE_100
18 , a5 out JTF_VARCHAR2_TABLE_300
19 , a6 out JTF_VARCHAR2_TABLE_2000
20 , a7 out JTF_NUMBER_TABLE
21 , a8 out JTF_VARCHAR2_TABLE_100
22 );
23
24 procedure rosetta_table_copy_in_p3(t out jtf_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE
25 , a1 JTF_VARCHAR2_TABLE_100
26 , a2 JTF_VARCHAR2_TABLE_300
27 , a3 JTF_VARCHAR2_TABLE_100
28 , a4 JTF_VARCHAR2_TABLE_100
29 , a5 JTF_VARCHAR2_TABLE_300
30 , a6 JTF_VARCHAR2_TABLE_2000
31 , a7 JTF_NUMBER_TABLE
32 , a8 JTF_VARCHAR2_TABLE_100
33 , a9 JTF_VARCHAR2_TABLE_300
34 , a10 JTF_NUMBER_TABLE
35 , a11 JTF_VARCHAR2_TABLE_100
36 );
37 procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
38 , a1 out JTF_VARCHAR2_TABLE_100
39 , a2 out JTF_VARCHAR2_TABLE_300
40 , a3 out JTF_VARCHAR2_TABLE_100
41 , a4 out JTF_VARCHAR2_TABLE_100
42 , a5 out JTF_VARCHAR2_TABLE_300
43 , a6 out JTF_VARCHAR2_TABLE_2000
44 , a7 out JTF_NUMBER_TABLE
45 , a8 out JTF_VARCHAR2_TABLE_100
46 , a9 out JTF_VARCHAR2_TABLE_300
47 , a10 out JTF_NUMBER_TABLE
48 , a11 out JTF_VARCHAR2_TABLE_100
49 );
50
51 procedure rosetta_table_copy_in_p5(t out jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
52 , a1 JTF_VARCHAR2_TABLE_300
53 , a2 JTF_NUMBER_TABLE
54 , a3 JTF_VARCHAR2_TABLE_100
55 );
56 procedure rosetta_table_copy_out_p5(t jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
57 , a1 out JTF_VARCHAR2_TABLE_300
58 , a2 out JTF_NUMBER_TABLE
59 , a3 out JTF_VARCHAR2_TABLE_100
60 );
61
62 procedure rosetta_table_copy_in_p6(t out jtf_deliverable_grp.number_table, a0 JTF_NUMBER_TABLE);
63 procedure rosetta_table_copy_out_p6(t jtf_deliverable_grp.number_table, a0 out JTF_NUMBER_TABLE);
64
65 procedure rosetta_table_copy_in_p7(t out jtf_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
66 procedure rosetta_table_copy_out_p7(t jtf_deliverable_grp.varchar2_table_100, a0 out JTF_VARCHAR2_TABLE_100);
67
68 procedure rosetta_table_copy_in_p8(t out jtf_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
69 procedure rosetta_table_copy_out_p8(t jtf_deliverable_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300);
70
71 procedure rosetta_table_copy_in_p9(t out jtf_deliverable_grp.varchar2_table_2000, a0 JTF_VARCHAR2_TABLE_2000);
72 procedure rosetta_table_copy_out_p9(t jtf_deliverable_grp.varchar2_table_2000, a0 out JTF_VARCHAR2_TABLE_2000);
73
74 procedure list_deliverable(p_api_version NUMBER
75 , p_init_msg_list VARCHAR2
76 , x_return_status out VARCHAR2
77 , x_msg_count out NUMBER
78 , x_msg_data out VARCHAR2
79 , p_item_type VARCHAR2
80 , p_item_applicable_to VARCHAR2
81 , p_search_type VARCHAR2
82 , p_search_value VARCHAR2
83 , p_start_id NUMBER
84 , p_batch_size NUMBER
85 , x_row_count out NUMBER
86 , x_dlv_id_tbl out JTF_NUMBER_TABLE
87 , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
88 , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
89 , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
90 , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
91 , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
92 , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
93 , x_version_tbl out JTF_NUMBER_TABLE
94 , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
95 , x_file_id_tbl out JTF_NUMBER_TABLE
96 );
97 procedure list_deliverable(p_api_version NUMBER
98 , p_init_msg_list VARCHAR2
99 , x_return_status out VARCHAR2
100 , x_msg_count out NUMBER
101 , x_msg_data out VARCHAR2
102 , p_category_id NUMBER
103 , p_item_type VARCHAR2
104 , p_item_applicable_to VARCHAR2
105 , p_search_type VARCHAR2
106 , p_search_value VARCHAR2
107 , p_start_id NUMBER
108 , p_batch_size NUMBER
109 , x_row_count out NUMBER
110 , x_dlv_id_tbl out JTF_NUMBER_TABLE
111 , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
112 , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
113 , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
114 , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
115 , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
116 , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
117 , x_version_tbl out JTF_NUMBER_TABLE
118 , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
119 , x_file_id_tbl out JTF_NUMBER_TABLE
120 );
121 procedure save_deliverable(p_api_version NUMBER
122 , p_init_msg_list VARCHAR2
123 , p_commit VARCHAR2
124 , x_return_status out VARCHAR2
125 , x_msg_count out NUMBER
126 , x_msg_data out VARCHAR2
127 , p6_a0 in out NUMBER
128 , p6_a1 in out VARCHAR2
129 , p6_a2 in out VARCHAR2
130 , p6_a3 in out VARCHAR2
131 , p6_a4 in out VARCHAR2
132 , p6_a5 in out VARCHAR2
133 , p6_a6 in out VARCHAR2
134 , p6_a7 in out NUMBER
135 , p6_a8 in out VARCHAR2
136 );
137 procedure save_deliverable(p_api_version NUMBER
138 , p_init_msg_list VARCHAR2
139 , p_commit VARCHAR2
140 , x_return_status out VARCHAR2
141 , x_msg_count out NUMBER
142 , x_msg_data out VARCHAR2
143 , p6_a0 in out JTF_NUMBER_TABLE
144 , p6_a1 in out JTF_VARCHAR2_TABLE_100
145 , p6_a2 in out JTF_VARCHAR2_TABLE_300
146 , p6_a3 in out JTF_VARCHAR2_TABLE_100
147 , p6_a4 in out JTF_VARCHAR2_TABLE_100
148 , p6_a5 in out JTF_VARCHAR2_TABLE_300
149 , p6_a6 in out JTF_VARCHAR2_TABLE_2000
150 , p6_a7 in out JTF_NUMBER_TABLE
151 , p6_a8 in out JTF_VARCHAR2_TABLE_100
152 );
153 procedure save_deliverable(p_api_version NUMBER
154 , p_init_msg_list VARCHAR2
155 , p_commit VARCHAR2
156 , x_return_status out VARCHAR2
157 , x_msg_count out NUMBER
158 , x_msg_data out VARCHAR2
159 , p6_a0 in out NUMBER
160 , p6_a1 in out VARCHAR2
161 , p6_a2 in out VARCHAR2
162 , p6_a3 in out VARCHAR2
163 , p6_a4 in out VARCHAR2
164 , p6_a5 in out VARCHAR2
165 , p6_a6 in out VARCHAR2
166 , p6_a7 in out NUMBER
167 , p6_a8 in out VARCHAR2
168 , p6_a9 in out VARCHAR2
169 , p6_a10 in out NUMBER
170 , p6_a11 in out VARCHAR2
171 );
172 procedure save_deliverable(p_api_version NUMBER
173 , p_init_msg_list VARCHAR2
174 , p_commit VARCHAR2
175 , x_return_status out VARCHAR2
176 , x_msg_count out NUMBER
177 , x_msg_data out VARCHAR2
178 , p6_a0 in out JTF_NUMBER_TABLE
179 , p6_a1 in out JTF_VARCHAR2_TABLE_100
180 , p6_a2 in out JTF_VARCHAR2_TABLE_300
181 , p6_a3 in out JTF_VARCHAR2_TABLE_100
182 , p6_a4 in out JTF_VARCHAR2_TABLE_100
183 , p6_a5 in out JTF_VARCHAR2_TABLE_300
184 , p6_a6 in out JTF_VARCHAR2_TABLE_2000
185 , p6_a7 in out JTF_NUMBER_TABLE
186 , p6_a8 in out JTF_VARCHAR2_TABLE_100
187 , p6_a9 in out JTF_VARCHAR2_TABLE_300
188 , p6_a10 in out JTF_NUMBER_TABLE
189 , p6_a11 in out JTF_VARCHAR2_TABLE_100
190 );
191 procedure delete_deliverable(p_api_version NUMBER
192 , p_init_msg_list VARCHAR2
193 , p_commit VARCHAR2
194 , x_return_status out VARCHAR2
195 , x_msg_count out NUMBER
196 , x_msg_data out VARCHAR2
197 , p6_a0 in out JTF_NUMBER_TABLE
198 , p6_a1 in out JTF_VARCHAR2_TABLE_300
199 , p6_a2 in out JTF_NUMBER_TABLE
200 , p6_a3 in out JTF_VARCHAR2_TABLE_100
201 );
202 end jtf_deliverable_grp_w;