1 PACKAGE PON_NEG_COPY_DATATYPES_GRP AUTHID CURRENT_USER AS
2 --$Header: PONGCDTS.pls 120.0 2005/06/01 20:52:36 appldev noship $
3
4 -- Start of comments
5 -- API name : PON_NEG_COPY_DATATYPES_GRP
6 --
7 -- Type : Group
8 --
9 -- Pre-reqs : None
10 --
11 -- Function : Declares a set of tables for holding different kind of datatypes and
12 -- used as placeholders while creating a negotiation from a
13 -- given auction_header_id (PON_NEGOTIATION_COPY_GRP package)
14 -- with given auction_header_id (p_source_auction_header_id)
15 --
16 -- It has got tables for NUMBER, DATE and different lengths of VARCHARs
17 --
18 -- End of comments
19
20 TYPE NUMBER_TYPE IS TABLE OF NUMBER
21 INDEX BY BINARY_INTEGER;
22
23 TYPE SIMPLE_DATE_TYPE IS TABLE OF DATE
24 INDEX BY BINARY_INTEGER;
25
26 TYPE VARCHAR1_TYPE IS TABLE OF VARCHAR2(1)
27 INDEX BY BINARY_INTEGER;
28
29 TYPE VARCHAR20_TYPE IS TABLE OF VARCHAR2(20)
30 INDEX BY BINARY_INTEGER;
31
32 TYPE VARCHAR50_TYPE IS TABLE OF VARCHAR2(50)
33 INDEX BY BINARY_INTEGER;
34
35 TYPE VARCHAR100_TYPE IS TABLE OF VARCHAR2(100)
36 INDEX BY BINARY_INTEGER;
37
38 TYPE VARCHAR300_TYPE IS TABLE OF VARCHAR2(300)
39 INDEX BY BINARY_INTEGER;
40
41 TYPE VARCHAR1000_TYPE IS TABLE OF VARCHAR2(1000)
42 INDEX BY BINARY_INTEGER;
43
44 TYPE VARCHAR2000_TYPE IS TABLE OF VARCHAR2(2000)
45 INDEX BY BINARY_INTEGER;
46
47 TYPE VARCHAR2500_TYPE IS TABLE OF VARCHAR2(2500)
48 INDEX BY BINARY_INTEGER;
49
50 TYPE VARCHAR4000_TYPE IS TABLE OF VARCHAR2(4000)
51 INDEX BY BINARY_INTEGER;
52
53 END PON_NEG_COPY_DATATYPES_GRP;
[Home] [Help]