1 PACKAGE WSH_BULK_TYPES_GRP as
2 /* $Header: WSHBTGPS.pls 120.0 2005/05/26 18:03:56 appldev noship $ */
3
4
5 --===================
6 -- PUBLIC VARS
7 --===================
8
9
10 TYPE action_parameters_rectype IS RECORD (
11 Caller VARCHAR2(50),
12 Entity VARCHAR2(50),
13 Phase NUMBER,
14 action_code VARCHAR2(50),
15 Org_id NUMBER,
16 shipment_header_id NUMBER,
17 ib_txn_history_id NUMBER,
18 ship_from_location_id NUMBER -- IB-Phase-2
19 );
20
21
22 TYPE Bulk_process_out_rec_type IS RECORD (
23 dummy NUMBER
24 );
25
26 Type char1_Nested_Tab_Type IS TABLE OF VARCHAR2(1);
27 Type char150_Nested_Tab_Type IS TABLE OF VARCHAR2(150);
28 Type char30_Nested_Tab_Type IS TABLE OF VARCHAR2(30);
29 Type date_Nested_Tab_Type IS TABLE OF DATE;
30 Type number_Nested_Tab_Type IS TABLE OF NUMBER;
31
32 Type char3_Nested_Tab_Type IS TABLE OF VARCHAR2(3); -- J-IB-NPARIKH
33
34
35 --HVOP: ITS heali
36 TYPE tbl_num is table of number INDEX BY BINARY_INTEGER;
37 TYPE tbl_num1 is table of number(1) INDEX BY BINARY_INTEGER;
38 TYPE tbl_v1 is table of varchar2(1) INDEX BY BINARY_INTEGER;
39 TYPE tbl_v3 is table of varchar2(3) INDEX BY BINARY_INTEGER;
40 TYPE tbl_v10 is table of varchar2(10) INDEX BY BINARY_INTEGER;
41 TYPE tbl_v20 is table of varchar2(20) INDEX BY BINARY_INTEGER;
42 TYPE tbl_v25 is table of varchar2(25) INDEX BY BINARY_INTEGER;
43 TYPE tbl_v30 is table of varchar2(30) INDEX BY BINARY_INTEGER;
44 TYPE tbl_v32 is table of varchar2(32) INDEX BY BINARY_INTEGER;
45 TYPE tbl_v40 is table of varchar2(40) INDEX BY BINARY_INTEGER;
46 TYPE tbl_v50 is table of varchar2(50) INDEX BY BINARY_INTEGER; -- J-IB-NPARIKH
47 -- HW OPMCONV. New length for lot of 80
48 TYPE tbl_v80 is table of varchar2(80) INDEX BY BINARY_INTEGER;
49 TYPE tbl_v150 is table of varchar2(150) INDEX BY BINARY_INTEGER;
50 TYPE tbl_v240 is table of varchar2(240) INDEX BY BINARY_INTEGER;
51 TYPE tbl_v2000 is table of varchar2(2000) INDEX BY BINARY_INTEGER;
52 TYPE tbl_date is table of date INDEX BY BINARY_INTEGER;
53 --HVOP: ITS heali
54
55
56 END WSH_BULK_TYPES_GRP;