1 PACKAGE oe_install_base_util AUTHID CURRENT_USER AS
2 /* $Header: OEXUINSS.pls 120.1 2005/08/03 13:23:10 vmalapat noship $*/
3
4 -- This is the Global PL/SQL table for the returned set of Instances
5 -- From the Instance Query Form
6
7 g_returned_inst_tbl csi_datastructures_pub.instance_cz_tbl;
8
9 -- This record holds the data that is selected from the Install Base Reconfiguration UI
10
11 TYPE instance_rec_type IS RECORD
12 (
13 ITEM_INSTANCE_ID NUMBER := NULL,
14 CONFIG_INSTANCE_HDR_ID NUMBER := NULL,
15 CONFIG_INSTANCE_REV_NUMBER NUMBER := NULL,
16 CONFIG_INSTANCE_ITEM_ID NUMBER := NULL,
17 -- Next 3 are optional
18 BILL_TO_SITE_USE_ID NUMBER := NULL,
19 SHIP_TO_SITE_USE_ID NUMBER := NULL,
20 INSTANCE_NAME VARCHAR2(240) := NULL
21 );
22
23 TYPE instance_tbl_type IS TABLE OF csi_datastructures_pub.instance_cz_rec
24 INDEX BY BINARY_INTEGER;
25
26
27 -- This record type is used to populate the values for the new columns introduced
28 -- in order_lines and order_header tables for 11.5.10.
29
30 TYPE partner_order_rec IS RECORD
31 (
32 IB_OWNER VARCHAR2(30) := NULL,
33 -- Bug 3281397 IB_INSTALLED_AT_LOCATION NUMBER := NULL,
34 -- Bug 3281397 IB_CURRENT_LOCATION NUMBER := NULL,
35 IB_INSTALLED_AT_LOCATION VARCHAR2(30) := NULL,
36 IB_CURRENT_LOCATION VARCHAR2(30) := NULL,
37 END_CUSTOMER_ID NUMBER := NULL,
38 END_CUSTOMER_CONTACT_ID NUMBER := NULL,
39 END_CUSTOMER_SITE_USE_ID NUMBER := NULL,
40 SOLD_TO_SITE_USE_ID NUMBER := NULL
41 );
42
43 TYPE partner_order_tbl IS TABLE OF partner_order_rec INDEX BY BINARY_INTEGER;
44
45 PROCEDURE get_partner_ord_rec (
46 p_order_line_id IN number,
47 x_partner_order_rec OUT NOCOPY partner_order_rec);
48
49 PROCEDURE return_selected_instances(
50 l_returned_inst_tbl IN csi_datastructures_pub.instance_cz_tbl);
51
52 PROCEDURE get_returned_instances(
53 l_read_inst_tbl IN OUT NOCOPY csi_datastructures_pub.instance_cz_tbl );
54
55 END oe_install_base_util;