1 PACKAGE GCS_LEX_MAP_COLUMNS_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcslxmcs.pls 115.2 2003/08/13 17:54:55 mikeward noship $ */
3 --
4 -- Package
5 -- gcs_lex_map_columns_pkg
6 -- Purpose
7 -- Package procedures for Lexical Mapping Columns
8 -- History
9 -- 23-JUN-03 M Ward Created
10 -- 28-JUL-03 M Ward Added translate_row
11 --
12
13 --
14 -- Procedure
15 -- Insert_Row
16 -- Purpose
17 -- Inserts a row into the gcs_lex_map_columns table.
18 -- Arguments
19 -- row_id Row ID of the inserted row.
20 -- structure_id ID of the structure.
21 -- column_name Name of the column.
22 -- column_type_code Type of column (V, N, D).
23 -- write_flag Read-only or read-write.
24 -- error_code_column_flag Whether or not this is an error code column.
25 -- last_update_date Last time the column was updated.
26 -- last_updated_by User last updating this column.
27 -- last_update_login Login of the person last updating this column.
28 -- creation_date Time this column was created.
29 -- created_by User who created this column.
30 -- Example
31 -- GCS_LEX_MAP_COLUMNS_PKG.Insert_Row(...);
32 -- Notes
33 --
34 PROCEDURE Insert_Row( row_id IN OUT NOCOPY VARCHAR2,
35 structure_id NUMBER,
36 column_name VARCHAR2,
37 column_type_code VARCHAR2,
38 write_flag VARCHAR2,
39 error_code_column_flag VARCHAR2,
40 last_update_date DATE,
41 last_updated_by NUMBER,
42 last_update_login NUMBER,
43 creation_date DATE,
44 created_by NUMBER);
45
46 --
47 -- Procedure
48 -- Update_Row
49 -- Purpose
50 -- Updates a row in the gcs_lex_map_columns table.
51 -- Arguments
52 -- structure_id ID of the structure.
53 -- column_name Name of the column.
54 -- column_type_code Type of column (V, N, D).
55 -- write_flag Read-only or read-write.
56 -- error_code_column_flag Whether or not this is an error code column.
57 -- last_update_date Last time the column was updated.
58 -- last_updated_by User last updating this column.
59 -- last_update_login Login of the person last updating this column.
60 -- Example
61 -- GCS_LEX_MAP_COLUMNS_PKG.Update_Row(...);
62 -- Notes
63 --
64 PROCEDURE Update_Row( structure_id NUMBER,
65 column_name VARCHAR2,
66 column_type_code VARCHAR2,
67 write_flag VARCHAR2,
68 error_code_column_flag VARCHAR2,
69 last_update_date DATE,
70 last_updated_by NUMBER,
71 last_update_login NUMBER);
72
73 --
74 -- Procedure
75 -- Load_Row
76 -- Purpose
77 -- Loads a row into the gcs_lex_map_columns table.
78 -- Arguments
79 -- structure_name Name of the structure.
80 -- column_name Name of the column.
81 -- owner Whether this is custom or seed data.
82 -- last_update_date Last time the column was updated.
83 -- column_type_code Type of column (V, N, D).
84 -- write_flag Read-only or read-write.
85 -- error_code_column_flag Whether or not this is an error code column.
86 -- custom_mode Whether or not to force a load.
87 -- Example
88 -- GCS_LEX_MAP_COLUMNS_PKG.Load_Row(...);
89 -- Notes
90 --
91 PROCEDURE Load_Row( structure_name VARCHAR2,
92 column_name VARCHAR2,
93 owner VARCHAR2,
94 last_update_date VARCHAR2,
95 column_type_code VARCHAR2,
96 write_flag VARCHAR2,
97 error_code_column_flag VARCHAR2,
98 custom_mode VARCHAR2);
99
100 --
101 -- Procedure
102 -- Translate_Row
103 -- Purpose
104 -- Updates translated infromation for a row in the
105 -- gcs_lex_map_columns table.
106 -- Arguments
107 -- structure_name Name of the structure.
108 -- column_name Name of the column.
109 -- owner Whether this is custom or seed data.
110 -- last_update_date Last time the column was updated.
111 -- custom_mode Whether or not to force a load.
112 -- Example
113 -- GCS_LEX_MAP_COLUMNS_PKG.Translate_Row(...);
114 -- Notes
115 --
116 PROCEDURE Translate_Row( structure_name VARCHAR2,
117 column_name VARCHAR2,
118 owner VARCHAR2,
119 last_update_date VARCHAR2,
120 custom_mode VARCHAR2);
121
122 END GCS_LEX_MAP_COLUMNS_PKG;
[Home] [Help]