[Home] [Help]
PACKAGE: APPS.GCS_CATEGORIES_PKG
Source
1 PACKAGE GCS_CATEGORIES_PKG AS
2 /* $Header: gcscategorys.pls 120.1 2005/10/30 05:17:06 appldev noship $ */
3 TYPE r_category_info IS RECORD
4 (category_code VARCHAR2(80),
5 category_number NUMBER(15),
6 net_to_re_flag VARCHAR2(1),
7 target_entity_code VARCHAR2(30),
8 support_multi_parents_flag VARCHAR2(1));
9
10 TYPE t_category_info IS TABLE OF r_category_info;
11
12 g_oper_category_info t_category_info;
13 g_cons_category_info t_category_info;
14
15
16 --
17 -- Procedure
18 -- Insert_Row
19 -- Purpose
20 -- Inserts a row into the gcs_categories_b table.
21 -- Arguments
22 -- row_id
23 -- category_code
24 -- category_number
25 -- net_to_re_flag
26 -- target_entity_code
27 -- category_type_code
28 -- associated_object_id
29 -- org_output_code
30 -- support_multi_parents_flag
31 -- enabled_flag
32 -- specific_intercompany_id
33 -- category_name
34 -- description
35 -- creation_date
36 -- created_by
37 -- last_update_date
38 -- last_updated_by
39 -- last_update_login
40 -- object_version_number
41 -- Example
42 -- GCS_CATEGORIES_PKG.Insert_Row(...);
43 -- Notes
44 --
45 PROCEDURE Insert_Row( row_id IN OUT NOCOPY VARCHAR2,
46 category_code VARCHAR2,
47 category_number NUMBER,
48 net_to_re_flag VARCHAR2,
49 target_entity_code VARCHAR2,
50 category_type_code VARCHAR2,
51 associated_object_id NUMBER,
52 org_output_code VARCHAR2,
53 support_multi_parents_flag VARCHAR2,
54 enabled_flag VARCHAR2,
55 specific_intercompany_id NUMBER,
56 category_name VARCHAR2,
57 description VARCHAR2,
58 creation_date DATE,
59 created_by NUMBER,
60 last_update_date DATE,
61 last_updated_by NUMBER,
62 last_update_login NUMBER,
63 object_version_number NUMBER);
64
65 --
66 -- Procedure
67 -- Update_Row
68 -- Purpose
69 -- Updates a row in the gcs_categories_b table.
70 -- Arguments
71 -- category_code
72 -- category_number
73 -- net_to_re_flag
74 -- target_entity_code
75 -- category_type_code
76 -- associated_object_id
77 -- org_output_code
78 -- support_multi_parents_flag
79 -- enabled_flag
80 -- specific_intercompany_id
81 -- category_name
82 -- description
83 -- last_update_date
84 -- last_udpated_by
85 -- last_update_login
86 -- Example
87 -- GCS_CATEGORIES_PKG.Update_Row(...);
88 -- Notes
89 --
90 PROCEDURE Update_Row( row_id IN OUT NOCOPY VARCHAR2,
91 category_code VARCHAR2,
92 category_number NUMBER,
93 net_to_re_flag VARCHAR2,
94 target_entity_code VARCHAR2,
95 category_type_code VARCHAR2,
96 associated_object_id NUMBER,
97 org_output_code VARCHAR2,
98 support_multi_parents_flag VARCHAR2,
99 enabled_flag VARCHAR2,
100 specific_intercompany_id NUMBER,
101 category_name VARCHAR2,
102 description VARCHAR2,
103 creation_date DATE,
104 created_by NUMBER,
105 last_update_date DATE,
106 last_updated_by NUMBER,
107 last_update_login NUMBER,
108 object_version_number NUMBER);
109
110 --
111 -- Procedure
112 -- Load_Row
113 -- Purpose
114 -- Loads a row into the gcs_categories_b table.
115 -- Arguments
116 -- category_code
117 -- owner
118 -- last_update_date
119 -- category_number
120 -- net_to_re_flag
121 -- target_entity_code
122 -- category_type_code
123 -- associated_object_id
124 -- org_output_code
125 -- support_multi_parents_flag
126 -- enabled_flag
127 -- specific_intercompany_id
128 -- category_name
129 -- description
130
131 -- Example
132 -- GCS_CATEGORIES_PKG.Load_Row(...);
133 -- Notes
134 --
135 PROCEDURE Load_Row( category_code VARCHAR2,
136 owner VARCHAR2,
137 last_update_date VARCHAR2,
138 custom_mode VARCHAR2,
139 category_number NUMBER,
140 net_to_re_flag VARCHAR2,
141 target_entity_code VARCHAR2,
142 category_type_code VARCHAR2,
143 associated_object_id NUMBER,
144 org_output_code VARCHAR2,
145 support_multi_parents_flag VARCHAR2,
146 enabled_flag VARCHAR2,
147 specific_intercompany_id NUMBER,
148 category_name VARCHAR2,
149 description VARCHAR2,
150 object_version_number NUMBER);
151
152 --
153 -- Procedure
154 -- Translate_Row
155 -- Purpose
156 -- Updates translated infromation for a row in the
157 -- gcs_categories_tl table.
158 -- Arguments
159 -- category_code
160 -- owner
161 -- last_update_date
162 -- category_name
163 -- description
164 -- Example
165 -- GCS_CATEGORIES_PKG.Translate_Row(...);
166 -- Notes
167 --
168 PROCEDURE Translate_Row( category_code VARCHAR2,
169 owner VARCHAR2,
170 last_update_date VARCHAR2,
171 custom_mode VARCHAR2,
172 category_name VARCHAR2,
173 description VARCHAR2);
174
175
176
177 -- Procedure
178 -- ADD_LANGUAGE
179 -- Arguments
180
181 -- Example
182 -- GCS_CATEGORIES_PKG.ADD_LANGUAGE();
183 -- Notes
184 --
185
186 PROCEDURE ADD_LANGUAGE ;
187
188
189 END GCS_CATEGORIES_PKG;