1 package AK_ON_OBJECTS_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpons.pls 120.2 2005/09/02 17:37:44 tshort ship $ */
3
4 --
5 -- Global constants holding the package and file names to be used by
6 -- messaging routines in the case of an unexpected error.
7 --
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_ON_OBJECTS_PUB';
9
10 --
11 -- Global constants for the p_write_mode parameter
12 --
13 G_APPEND CONSTANT VARCHAR2(1) := 'A';
14 G_OVERWRITE CONSTANT VARCHAR2(1) := 'W';
15
16 --
17 -- Max number of values per column (N) in the loader file
18 -- i.e <column_name> = <value1> <value2> ... <valueN>
19 -- This value should equals one more than the max number of extended
20 -- attributes used by the NLS Translation team.
21 -- Regardless of what this value is, all values other than the first
22 -- value are ignored by the UPLOAD APIs.
23 --
24 G_MAX_NUM_LOADER_VALUES CONSTANT NUMBER := 3;
25
26 --
27 -- Date format used in all AK loader routines.
28 --
29 G_DATE_FORMAT CONSTANT VARCHAR2(21) := 'YYYY-MM-DD HH24:MI:SS';
30
31 --
32 -- Flat file format version number
33 --
34 -- 110.1 is the version before JSP changes
35 -- 115.1 is the version after JSP changes
36
37 G_FILE_FORMAT_VER NUMBER := 120.1;
38 G_OLD_FILE_FORMAT_VER1 NUMBER := 110.1;
39 G_OLD_FILE_FORMAT_VER2 NUMBER := 115.1;
40 G_OLD_FILE_FORMAT_VER3 NUMBER := 115.2;
41 G_OLD_FILE_FORMAT_VER4 NUMBER := 115.3;
42 G_OLD_FILE_FORMAT_VER5 NUMBER := 115.4;
43 G_OLD_FILE_FORMAT_VER6 NUMBER := 115.5;
44 G_OLD_FILE_FORMAT_VER7 NUMBER := 115.6;
45 G_OLD_FILE_FORMAT_VER8 NUMBER := 115.7;
46 G_OLD_FILE_FORMAT_VER9 NUMBER := 115.8;
47 G_OLD_FILE_FORMAT_VER10 NUMBER := 115.9;
48 G_OLD_FILE_FORMAT_VER11 NUMBER := 115.10;
49 G_OLD_FILE_FORMAT_VER12 NUMBER := 115.12;
50 G_OLD_FILE_FORMAT_VER14 NUMBER := 115.14;
51 G_OLD_FILE_FORMAT_VER15 NUMBER := 115.15;
52
53 --
54 -- Type definitions
55 --
56 -- buffer for one logical line. Logical lines are made up
57 -- of a single line in a file, or multiple lines in a file which are
58 -- logically one line and were connected with continuation characters ('')
59 --
60 buffer_type_template VARCHAR2(4096);
61 SUBTYPE Buffer_Type IS buffer_type_template%TYPE;
62 --
63 -- Table of buffer lines for logical lines.
64 --
65 TYPE Buffer_Tbl_Type IS TABLE OF Buffer_Type
66 INDEX BY BINARY_INTEGER;
67
68 TYPE loader_temp_rec_type is RECORD (
69 TBL_INDEX NUMBER := NULL,
70 LINE_CONTENT VARCHAR2(2000) := NULL
71 );
72
73 -- Cursor Type and Cursor variable
74 TYPE LoaderCurTyp IS REF CURSOR RETURN loader_temp_rec_type;
75
76 --
77 -- Constants for missing data types
78 --
79 G_MISS_BUFFER_TBL Buffer_Tbl_Type;
80
81 -- Indicate that it's currently uploading or downloading
82 -- valid values should be UPLOAD and DOWNLOAD
83 G_LOAD_MODE VARCHAR2(10);
84 G_UPLOAD_FILE_VERSION NUMBER;
85
86 end AK_ON_OBJECTS_PUB;
[Home] [Help]