[Home] [Help]
PACKAGE: APPS.GCS_DATA_TYPE_CODES_PKG
Source
1 PACKAGE GCS_DATA_TYPE_CODES_PKG AS
2 /* $Header: gcsdatatypess.pls 120.2 2006/04/18 11:35:34 vkosuri noship $ */
3 TYPE r_datatype_info IS RECORD(
4 data_type_id NUMBER(15),
5 data_type_code VARCHAR2(30),
6 enforce_balancing_flag VARCHAR2(1),
7 apply_elim_rules_flag VARCHAR2(1),
8 apply_cons_rules_flag VARCHAR2(1),
9 source_dataset_code NUMBER(15));
10
11 TYPE t_datatype_info IS TABLE OF r_datatype_info;
12
13 g_datatype_info t_datatype_info;
14
15 --
16 -- Procedure
17 -- Insert_Row
18 -- Purpose
19 -- Inserts a row into the gcs_data_type_codes_b table.
20 -- Arguments
21 -- row_id
22 -- data_type_id
23 -- data_type_code
24 -- enforce_balancing_flag
25 -- apply_elim_rules_flag
26 -- apply_cons_rules_flag
27 -- source_dataset_code
28 -- data_type_name
29 -- description
30 -- creation_date
31 -- created_by
32 -- last_update_date
33 -- last_updated_by
34 -- last_update_login
35 -- object_version_number
36 -- Example
37 -- GCS_DATA_TYPE_CODES_PKG.Insert_Row(...);
38 -- Notes
39 --
40
41 PROCEDURE Insert_Row(row_id IN OUT NOCOPY VARCHAR2,
42 data_type_id NUMBER,
43 data_type_code VARCHAR2,
44 enforce_balancing_flag VARCHAR2,
45 apply_elim_rules_flag VARCHAR2,
46 apply_cons_rules_flag VARCHAR2,
47 source_dataset_code NUMBER,
48 data_type_name VARCHAR2,
49 description VARCHAR2,
50 creation_date DATE,
51 created_by NUMBER,
52 last_update_date DATE,
53 last_updated_by NUMBER,
54 last_update_login NUMBER,
55 object_version_number NUMBER);
56
57 --
58 -- Procedure
59 -- Update_Row
60 -- Purpose
61 -- Updates a row in the gcs_data_type_codes_b table.
62 -- Arguments
63 -- row_id
64 -- data_type_code
65 -- enforce_balancing_flag
66 -- apply_elim_rules_flag
67 -- apply_cons_rules_flag
68 -- source_dataset_code
69 -- data_type_name
70 -- description
71 -- creation_date
72 -- created_by
73 -- last_update_date
74 -- last_updated_by
75 -- last_update_login
76 -- object_version_number
77 -- Example
78 -- GCS_DATA_TYPE_CODES_PKG.Update_Row(...);
79 -- Notes
80 --
81 PROCEDURE Update_Row(row_id IN OUT NOCOPY VARCHAR2,
82 data_type_id NUMBER,
83 data_type_code VARCHAR2,
84 enforce_balancing_flag VARCHAR2,
85 apply_elim_rules_flag VARCHAR2,
86 apply_cons_rules_flag VARCHAR2,
87 source_dataset_code NUMBER,
88 data_type_name VARCHAR2,
89 description VARCHAR2,
90 creation_date DATE,
91 created_by NUMBER,
92 last_update_date DATE,
93 last_updated_by NUMBER,
94 last_update_login NUMBER,
95 object_version_number NUMBER);
96
97 --
98 -- Procedure
99 -- Load_Row
100 -- Purpose
101 -- Loads a row into the gcs_data_type_codes_b table.
102 -- Arguments
103 -- data_type_code
104 -- owner
105 -- last_update_date
106 -- enforce_balancing_flag
107 -- apply_elim_rules_flag
108 -- apply_cons_rules_flag
109 -- source_dataset_code
110 -- object_version_number
111 -- data_type_name
112 -- description
113
114 -- Example
115 -- GCS_DATA_TYPE_CODES_PKG.Load_Row(...);
116 -- Notes
117 --
118
119 -- Bugfix 5155519 : source_dataset_display_code instead of source_dataset_code in the signature.
120
121 PROCEDURE Load_Row(data_type_id NUMBER,
122 owner VARCHAR2,
123 last_update_date VARCHAR2,
124 custom_mode VARCHAR2,
125 data_type_code VARCHAR2,
126 enforce_balancing_flag VARCHAR2,
127 apply_elim_rules_flag VARCHAR2,
128 apply_cons_rules_flag VARCHAR2,
129 source_dataset_display_code VARCHAR2,
130 object_version_number NUMBER,
131 data_type_name VARCHAR2,
132 description VARCHAR2);
133
134 --
135 -- Procedure
136 -- Translate_Row
137 -- Purpose
138 -- Updates translated infromation for a row in the
139 -- gcs_data_type_codes_tl table.
140 -- Arguments
141 -- data_type_code
142 -- owner
143 -- last_update_date
144 -- data_type_name
145 -- description
146 -- Example
147 -- GCS_DATA_TYPE_CODES_PKG.Translate_Row(...);
148 -- Notes
149 --
150 PROCEDURE Translate_Row(data_type_id NUMBER,
151 owner VARCHAR2,
152 last_update_date VARCHAR2,
153 custom_mode VARCHAR2,
154 data_type_name VARCHAR2,
155 description VARCHAR2);
156
157 -- Procedure
158 -- ADD_LANGUAGE
159 -- Arguments
160
161 -- Example
162 -- GCS_DATA_TYPE_CODES_PKG.ADD_LANGUAGE();
163 -- Notes
164 --
165
166 PROCEDURE ADD_LANGUAGE;
167
168 END GCS_DATA_TYPE_CODES_PKG;