1 package body cs_ib_fetch_pkg as
2 /* $Header: csifetb.pls 115.27 2003/12/03 19:00:00 spariti ship $ */
3
4
5 procedure getContactTypes( x_contacttypes OUT contact_type_info_csr_type ) is
6 begin
7
8 null;
9
10 end;
11
12 /* Added by arajagop for CSI implemenation */
13 procedure getSystems(customer_id_in in number ,
14 csi_enabled in varchar2,
15 user_id in number,
16 x_systeminfo OUT system_info_csr_type ) is
17
18 BEGIN
19
20 null;
21
22 END;
23
24
25 procedure getSystems(customer_id_in in number ,
26 x_systeminfo OUT system_info_csr_type ) is
27
28 begin
29 null;
30
31 end;
32
33
34 procedure getConfigTypes(x_configtype_info OUT config_type_info_csr_type) is
35 begin
36
37 null;
38
39 end;
40
41 procedure getContracts(product_id IN number,
42 listOfContracts OUT varchar2
43 ) is
44
45 begin
46 null;
47
48 end;
49
50
51 procedure getNotes(productId in number,
52 x_notestype OUT notes_info_csr_type) is
53 begin
54 null;
55
56 end;
57
58 /**
59 * Added by Xiangyang Li(xili) for CSI Handling
60 * - 12/28/2000
61 */
62 procedure getproduct( product_id in number,
63 customer_id in number,
64 user_id in number,
65 csi_enabled in varchar2,
66 x_proddetail OUT product_info_csr_type,
67 x_contactinfo OUT contacts_info_csr_type,
68 x_statusinfo OUT status_info_csr_type,
69 x_contacttypes OUT contact_type_info_csr_type,
70 x_notestype OUT notes_info_csr_type,
71 x_configtype_info OUT config_type_info_csr_type,
72 x_systeminfo OUT system_info_csr_type,
73 x_unit_of_measure OUT varchar2,
74 x_contracts OUT varchar2 ) is
75 begin
76 null;
77
78 end;
79
80
81 procedure getproduct( product_id in number,
82 customer_id in number,
83 x_proddetail OUT product_info_csr_type,
84 x_contactinfo OUT contacts_info_csr_type,
85 x_statusinfo OUT status_info_csr_type,
86 x_contacttypes OUT contact_type_info_csr_type,
87 x_notestype OUT notes_info_csr_type,
88 x_configtype_info OUT config_type_info_csr_type,
89 x_systeminfo OUT system_info_csr_type,
90 x_unit_of_measure OUT varchar2,
91 x_contracts OUT varchar2 ) is
92
93 begin
94 null;
95 end;
96
97 procedure getAddressList(x_address OUT address_info_csr_type) is
98 begin
99 null;
100
101 end;
102
103 procedure getStatusList(x_status OUT status_info_csr_type) is
104 begin
105 null;
106
107 end;
108
109
110 procedure getRevisionList(inv_item_id in number ,
111 x_revisioninfo OUT revision_info_csr_type) is
112 begin
113 null;
114
115 end;
116
117 procedure getUnitOfMeasures(invItemId number,
118 x_uominfo OUT uom_info_csr_type) is
119 begin
120 null;
121
122 end;
123
124 procedure getProductTypes(x_product_type_info OUT product_type_info_csr_type) is
125 begin
126
127 null;
128
129 end;
130
131
132
133 procedure getProductInfo(product_id in number,
134 x_productinfo OUT product_info_csr_type) is
135 begin
136
137 null;
138
139 end;
140
141
142 procedure getPatches(product_id in number,
143 inventory_item in number,
144 x_patch_products out product_info_csr_type ) is
145 begin
146 null;
147
148 end;
149
150 /****** arajagop : Added for CSI implementaion **/
151 procedure getProductHierarchy(product_id in number,
152 parent_id in number,
153 root_id in number,
154 inv_item_id in number,
155 customer_id in number,
156 csi_enabled in varchar2 DEFAULT FND_API.G_FALSE,
157 user_id in number,
158 x_prodinfo OUT product_info_csr_type,
159 x_parentinfo OUT product_info_csr_type,
160 x_rootinfo OUT product_info_csr_type,
161 x_statusinfo OUT status_info_csr_type,
162 x_contacttypes OUT contact_type_info_csr_type,
163 x_revisioninfo OUT revision_info_csr_type,
164 x_uominfo OUT uom_info_csr_type,
165 x_product_type_info OUT product_type_info_csr_type,
166 x_systeminfo OUT system_info_csr_type,
167 x_configtype_info OUT config_type_info_csr_type) is
168 BEGIN
169
170 null;
171
172 END;
173
174 procedure getProductHierarchy(product_id in number,
175 parent_id in number,
176 root_id in number,
177 inv_item_id in number,
178 customer_id in number,
179 x_prodinfo OUT product_info_csr_type,
180 x_parentinfo OUT product_info_csr_type,
181 x_rootinfo OUT product_info_csr_type,
182 x_statusinfo OUT status_info_csr_type,
183 x_contacttypes OUT contact_type_info_csr_type,
184 x_revisioninfo OUT revision_info_csr_type,
185 x_uominfo OUT uom_info_csr_type,
186 x_product_type_info OUT product_type_info_csr_type,
187 x_systeminfo OUT system_info_csr_type,
188 x_configtype_info OUT config_type_info_csr_type) is
189 BEGIN
190
191 null;
192
193 END;
194
195 procedure getSearchProductScreenInfo(customer_id in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%type,
196 x_party_name out HZ_PARTIES.PARTY_NAME%type,
197 x_product_type_info OUT product_type_info_csr_type,
198 x_systeminfo OUT system_info_csr_type,
199 x_status out status_info_csr_type) is
200 begin
201
202 null;
203
204 end;
205
206 /**
207 * Added by Xiangyang Li(xili) for CSI Handling
208 * - 12/28/2000
209 */
210 procedure getSearchProductScreenInfo(customer_id in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%type,
211 user_id in number,
212 csi_enabled in varchar2 DEFAULT FND_API.G_FALSE,
213 x_party_name out HZ_PARTIES.PARTY_NAME%type,
214 x_product_type_info OUT product_type_info_csr_type,
215 x_systeminfo OUT system_info_csr_type,
216 x_status out status_info_csr_type) is
217 begin
218
219 null;
220
221 end;
222
223 procedure getDownLoadStatus(x_status OUT status_info_csr_type) is
224
225 begin
226
227 null;
228
229 end;
230
231
232 procedure getPatchChildren(product_id in number,
233 x_proddetail OUT product_info_csr_type ) is
234
235 begin
236
237 null;
238
239 end;
240
241 procedure getPatchInventoryId(x_inventory_item_id out number ) is
242
243 begin
244
245 null;
246
247 end;
248
249 end cs_ib_fetch_pkg;
250