1 PACKAGE GCS_LEX_MAP_STRUCTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcslxmss.pls 115.2 2003/08/13 17:54:41 mikeward noship $ */
3 --
4 -- Package
5 -- gcs_lex_map_structs_pkg
6 -- Purpose
7 -- Package procedures for Lexical Mapping Structures
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_structs table.
18 -- Arguments
19 -- row_id Row ID of the inserted row.
20 -- structure_name Name of the structure.
21 -- description Description of the structure.
22 -- table_use_type_code Whether this is a lookup or staging table.
23 -- last_update_date Last time the structure was updated.
24 -- last_updated_by User last updating this structure.
25 -- last_update_login Login of person last updating this structure.
26 -- creation_date Time this structure was created.
27 -- created_by User who created this structure.
28 -- Example
29 -- GCS_LEX_MAP_STRUCTS_PKG.Insert_Row(...);
30 -- Notes
31 --
32 PROCEDURE Insert_Row( row_id IN OUT NOCOPY VARCHAR2,
33 structure_name VARCHAR2,
34 description VARCHAR2,
35 table_use_type_code VARCHAR2,
36 last_update_date DATE,
37 last_updated_by NUMBER,
38 last_update_login NUMBER,
39 creation_date DATE,
40 created_by NUMBER);
41
42 --
43 -- Procedure
44 -- Update_Row
45 -- Purpose
46 -- Updates a row in the gcs_lex_map_structs table.
47 -- Arguments
48 -- structure_name Name of the structure.
49 -- description Description of the structure.
50 -- table_use_type_code Whether this is a lookup or staging table.
51 -- last_update_date Last time the structure was updated.
52 -- last_updated_by User last updating this structure.
53 -- last_update_login Login of person last updating this structure.
54 -- Example
55 -- GCS_LEX_MAP_STRUCTS_PKG.Update_Row(...);
56 -- Notes
57 --
58 PROCEDURE Update_Row( structure_name VARCHAR2,
59 description VARCHAR2,
60 table_use_type_code VARCHAR2,
61 last_update_date DATE,
62 last_updated_by NUMBER,
63 last_update_login NUMBER);
64
65 --
66 -- Procedure
67 -- Load_Row
68 -- Purpose
69 -- Loads a row into the gcs_lex_map_structs table.
70 -- Arguments
71 -- structure_name Name of the structure.
72 -- owner Whether this is custom or seed data.
73 -- last_update_date Last time the structure was updated.
74 -- description Description of the structure.
75 -- table_use_type_code Whether this is a lookup or staging table.
76 -- custom_mode Whether or not to force a load.
77 -- Example
78 -- GCS_LEX_MAP_STRUCTS_PKG.Load_Row(...);
79 -- Notes
80 --
81 PROCEDURE Load_Row( structure_name VARCHAR2,
82 owner VARCHAR2,
83 last_update_date VARCHAR2,
84 description VARCHAR2,
85 table_use_type_code VARCHAR2,
86 custom_mode VARCHAR2);
87
88 --
89 -- Procedure
90 -- Translate_Row
91 -- Purpose
92 -- Updates translated infromation for a row in the
93 -- gcs_lex_map_structs table.
94 -- Arguments
95 -- structure_name Name of the structure.
96 -- owner Whether this is custom or seed data.
97 -- last_update_date Last time the structure was updated.
98 -- custom_mode Whether or not to force a load.
99 -- Example
100 -- GCS_LEX_MAP_STRUCTS_PKG.Translate_Row(...);
101 -- Notes
102 --
103 PROCEDURE Translate_Row( structure_name VARCHAR2,
104 owner VARCHAR2,
105 last_update_date VARCHAR2,
106 custom_mode VARCHAR2);
107
108 END GCS_LEX_MAP_STRUCTS_PKG;