1 package cs_ib_fetch_pkg AUTHID CURRENT_USER as
2 /* $Header: csifets.pls 115.20 2003/12/03 19:00:15 spariti ship $ */
3 type product_info_csr_type is REF CURSOR;
4 type contacts_info_csr_type is REF CURSOR;
5 type status_info_csr_type is REF CURSOR;
6
7 type address_info_csr_type is REF CURSOR;
8
9 type contact_type_info_csr_type is REF CURSOR;
10
11 type account_info_csr_tpye is REF CURSOR;
12 type notes_info_csr_type is REF CURSOR;
13
14 type revision_info_csr_type is REF CURSOR;
15 type uom_info_csr_type is REF CURSOR;
16 type product_type_info_csr_type is REF CURSOR;
17 type system_info_csr_type is REF CURSOR;
18 type config_type_info_csr_type is REF CURSOR;
19
20 procedure getContactTypes( x_contacttypes OUT contact_type_info_csr_type );
21
22 procedure getproduct( product_id in number,
23 customer_id in number,
24 x_proddetail OUT product_info_csr_type,
25 x_contactinfo OUT contacts_info_csr_type,
26 x_statusinfo OUT status_info_csr_type,
27 x_contacttypes OUT contact_type_info_csr_type,
28 x_notestype OUT notes_info_csr_type,
29 x_configtype_info OUT config_type_info_csr_type,
30 x_systeminfo OUT system_info_csr_type,
31 x_unit_of_measure OUT varchar2,
32 x_contracts OUT varchar2);
33
34 /**
35 * Added by Xiangyang Li(xili) for CSI Handling
36 * - 12/28/2000
37 */
38 procedure getproduct( product_id in number,
39 customer_id in number,
40 user_id in number,
41 csi_enabled in varchar2 DEFAULT FND_API.G_FALSE,
42 x_proddetail OUT product_info_csr_type,
43 x_contactinfo OUT contacts_info_csr_type,
44 x_statusinfo OUT status_info_csr_type,
45 x_contacttypes OUT contact_type_info_csr_type,
46 x_notestype OUT notes_info_csr_type,
47 x_configtype_info OUT config_type_info_csr_type,
48 x_systeminfo OUT system_info_csr_type,
49 x_unit_of_measure OUT varchar2,
50 x_contracts OUT varchar2);
51
52 procedure getContracts(product_id IN number,
53 listOfContracts OUT varchar2 );
54
55 procedure getAddressList(x_address OUT address_info_csr_type );
56
57 procedure getStatusList(x_status OUT status_info_csr_type);
58
59 procedure getProductHierarchy(product_id in number,
60 parent_id in number,
61 root_id in number,
62 inv_item_id in number,
63 customer_id in number,
64 x_prodinfo OUT product_info_csr_type,
65 x_parentinfo OUT product_info_csr_type,
66 x_rootinfo OUT product_info_csr_type,
67 x_statusinfo OUT status_info_csr_type,
68 x_contacttypes OUT contact_type_info_csr_type,
69 x_revisioninfo OUT revision_info_csr_type,
70 x_uominfo OUT uom_info_csr_type,
71 x_product_type_info OUT product_type_info_csr_type,
72 x_systeminfo OUT system_info_csr_type,
73 x_configtype_info OUT config_type_info_csr_type);
74
75 procedure getProductHierarchy(product_id in number,
76 parent_id in number,
77 root_id in number,
78 inv_item_id in number,
79 customer_id in number,
80 csi_enabled in varchar2 DEFAULT FND_API.G_FALSE,
81 user_id in number,
82 x_prodinfo OUT product_info_csr_type,
83 x_parentinfo OUT product_info_csr_type,
84 x_rootinfo OUT product_info_csr_type,
85 x_statusinfo OUT status_info_csr_type,
86 x_contacttypes OUT contact_type_info_csr_type,
87 x_revisioninfo OUT revision_info_csr_type,
88 x_uominfo OUT uom_info_csr_type,
89 x_product_type_info OUT product_type_info_csr_type,
90 x_systeminfo OUT system_info_csr_type,
91 x_configtype_info OUT config_type_info_csr_type);
92
93
94 procedure getSearchProductScreenInfo(customer_id in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%type,
95 x_party_name out HZ_PARTIES.PARTY_NAME%type,
96 x_product_type_info OUT product_type_info_csr_type,
97 x_systeminfo OUT system_info_csr_type,
98 x_status out status_info_csr_type);
99
100 /**
101 * Added by Xiangyang Li(xili) for CSI Handling
102 * - 12/28/2000
103 */
104 procedure getSearchProductScreenInfo(customer_id in HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%type,
105 user_id in number,
106 csi_enabled in varchar2 DEFAULT FND_API.G_FALSE,
107 x_party_name out HZ_PARTIES.PARTY_NAME%type,
108 x_product_type_info OUT product_type_info_csr_type,
109 x_systeminfo OUT system_info_csr_type,
110 x_status out status_info_csr_type);
111
112 procedure getNotes(productId in number,
113 x_notestype OUT notes_info_csr_type);
114
115 procedure getDownLoadStatus(x_status OUT status_info_csr_type);
116
117 procedure getPatchChildren(product_id in number,
118 x_proddetail OUT product_info_csr_type );
119
120 procedure getPatchInventoryId(x_inventory_item_id out number );
121
122 end cs_ib_fetch_pkg;
123