1 PACKAGE gl_encumbrance_types_pkg AS
2 /* $Header: glietdfs.pls 120.4 2005/12/19 23:01:42 djogg ship $ */
3 --
4 -- Package
5 -- gl_encumbrance_types
6 -- Purpose
7 -- To implement various data checking needed for the
8 -- gl_encumbrance_types table
9 -- History
10 -- 12-21-93 S. J. Mueller Created
11 --
12
13 --
14 -- Procedure
15 -- check_unique_name
16 -- Purpose
17 -- Checks to make sure the given encumbrance_type is
18 -- unique within gl_encumbrance_types.
19 -- History
20 -- 12-21-93 S. J. Mueller Created
21 -- Arguments
22 -- name The encumbrance type to be checked
23 -- rowid The ID of the row to be checked
24 -- Example
25 -- gl_encumbrance_types.check_unique_name('SuperObligation', 'ABD0123');
26 -- Notes
27 --
28 PROCEDURE check_unique_name(x_name VARCHAR2,
29 x_row_id VARCHAR2);
30
31 --
32 -- Procedure
33 -- check_unique_id
34 -- Purpose
35 -- Checks to make sure the encumbrance_type_id is
36 -- unique within gl_encumbrance_types.
37 -- History
38 -- 13-JUL-94 E Wilson Created
39 -- Arguments
40 -- etid The encumbrance type id to be checked
41 -- rowid The ID of the row to be checked
42 -- Example
43 -- gl_encumbrance_types.check_unique_id(1, 'ABD0123');
44 -- Notes
45 --
46 PROCEDURE check_unique_id(x_etid NUMBER,
47 x_row_id VARCHAR2);
48
49 --
50 -- Procedure
51 -- get_unique_id
52 -- Purpose
53 -- Gets a unique encumbrance type id for a new encumbrance type.
54 -- History
55 -- 12-21-93 S. J. Mueller Created
56 -- Arguments
57 -- none
58 -- Example
59 -- gl_encumbrance_types_pkg.get_unique_id(encumbrance_type_id);
60 -- Notes
61 --
62 PROCEDURE get_unique_id(x_encumbrance_type_id IN OUT NOCOPY NUMBER);
63
64
65 --
66 -- Procedure
67 -- select_columns
68 -- Purpose
69 -- Gets the values of some columns from gl_encumbrance_types associated
70 -- with the given encumbrance.
71 -- History
72 -- 01-NOV-94 D. J. Ogg Created.
73 -- Arguments
74 -- x_encumbrance_type_id ID of the desired encumbrance type
75 -- x_encumbrance_type Name of the encumbrance type
76 --
77 PROCEDURE select_columns(
78 x_encumbrance_type_id NUMBER,
79 x_encumbrance_type IN OUT NOCOPY VARCHAR2);
80
81 --
82 -- Function
83 -- get_enc_type_all
84 -- Purpose
85 -- Gets the "ALL" value for encumbrance type. Fix for bug #401290:
86 -- for support for different languages.
87 -- History
88 -- 09/12/96 W Ho Created
89 -- Arguments
90 -- enc_type
91 -- Returns
92 -- TRUE if found, FALSE if not found.
93 -- The encumbrance type for "ALL" is returned through the parameter
94 -- enc_type.
95 --
96 FUNCTION get_enc_type_all(enc_type IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
97
98 --
99 -- Procedure
100 -- insert_row
101 -- Purpose
102 -- Inserts a new row into GL_ENCUMBRANCE_TYPES table
103 -- History
104 -- 16-JUL-1999 K Vora Created
105 -- Arguments
106 -- x_rowid Rowid
107 -- x_encumbrance_type_id ID of the encumbrance type
108 -- x_encumbrance_type_key Key of the encumbrance type
109 -- x_encumbrance_type Name of the encumbrance type
110 -- x_enabled_flag Enabled flag
111 -- x_last_update_date
112 -- x_last_updated_by
113 -- x_creation_date
114 -- x_created_by
115 -- x_last_update_login
116 -- x_description
117 PROCEDURE insert_row(
118 x_rowid IN OUT NOCOPY VARCHAR2,
119 x_encumbrance_type_id IN OUT NOCOPY NUMBER,
120 x_encumbrance_type_key IN OUT NOCOPY VARCHAR2,
121 x_encumbrance_type IN VARCHAR2,
122 x_enabled_flag IN VARCHAR2,
123 x_last_update_date IN DATE,
124 x_last_updated_by IN NUMBER,
125 x_creation_date IN DATE,
126 x_created_by IN NUMBER,
127 x_last_update_login IN NUMBER,
128 x_description IN VARCHAR2);
129
130 --
131 -- Procedure
132 -- update_row
133 -- Purpose
134 -- Updates a row in GL_ENCUMBRANCE_TYPES table
135 -- History
136 -- 16-JUL-1999 K Vora Created
137 -- Arguments
138 -- x_encumbrance_type_id ID of the encumbrance type
139 -- x_encumbrance_type Name of the encumbrance type
140 -- x_enabled_flag Enabled flag
141 -- x_last_update_date
142 -- x_last_updated_by
143 -- x_last_update_login
144 -- x_description Description
145 -- x_force_edits Y - load row
146 -- NULL - load row only if owner is SEED
147 PROCEDURE update_row(
148 x_encumbrance_type_id IN NUMBER,
149 x_encumbrance_type IN VARCHAR2,
150 x_enabled_flag IN VARCHAR2,
151 x_last_update_date IN DATE,
152 x_last_updated_by IN NUMBER,
153 x_last_update_login IN NUMBER,
154 x_description IN VARCHAR2);
155 --
156 -- Procedure
157 -- load_row
158 -- Purpose
159 -- Load row procedure for NLS changes.
160 -- History
161 -- 16-JUL-1999 K Vora Created
162 -- Arguments
163 -- x_encumbrance_type_key Key of the encumbrance type
164 -- x_owner Indicates seed data or custom data
165 -- x_encumbrance_type Name of the encumbrance type
166 -- x_description Description
167 -- x_enabled_flag Enabled flag
168 -- Note
169 PROCEDURE load_row(
170 y_encumbrance_type_key IN VARCHAR2,
171 y_owner IN VARCHAR2,
172 y_encumbrance_type IN VARCHAR2,
173 y_description IN VARCHAR2,
174 y_enabled_flag IN VARCHAR2,
175 y_force_edits IN VARCHAR2 default 'N');
176
177 --
178 -- Procedure
179 -- translate_row
180 -- Purpose
181 -- Translate row procedure for NLS changes.
182 -- History
183 -- 16-JUL-1999 K Vora Created
184 -- Arguments
185 -- x_encumbrance_type_key ID of the encumbrance type
186 -- x_owner Indicates seed data or custom data
187 -- x_encumbrance_type Name of the encumbrance type
188 -- x_description Description
189 -- x_enabled_flag Enabled flag
190 -- x_force_edits Y - load row
191 -- NULL - load row only if owner is SEED
192 PROCEDURE translate_row(
193 x_encumbrance_type_key IN VARCHAR2,
194 x_owner IN VARCHAR2,
195 x_encumbrance_type IN VARCHAR2,
196 x_description IN VARCHAR2,
197 x_enabled_flag IN VARCHAR2,
198 x_force_edits IN VARCHAR2 default 'N');
199
200 END gl_encumbrance_types_pkg;