[Home] [Help]
PACKAGE BODY: APPS.CSI_I_EXT_ATTRIB_PKG
Source
1 PACKAGE BODY CSI_I_EXT_ATTRIB_PKG AS
2 /* $Header: csitieab.pls 115.4 2003/09/04 00:18:12 sguthiva ship $ */
3 -- Start of Comments
4 -- Package name : CSI_I_EXT_ATTRIB_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- END of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_EXTENDED_ATTRIBS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitieab.pls';
13
14 PROCEDURE Insert_Row(
15 px_attribute_id IN OUT NOCOPY NUMBER ,
16 p_attribute_level VARCHAR2,
17 p_master_organization_id NUMBER ,
18 p_inventory_item_id NUMBER ,
19 p_item_category_id NUMBER ,
20 p_instance_id NUMBER ,
21 p_attribute_code VARCHAR2,
22 p_attribute_name VARCHAR2,
23 p_attribute_category VARCHAR2,
24 p_description VARCHAR2,
25 p_active_start_date DATE ,
26 p_active_end_date DATE ,
27 p_context VARCHAR2,
28 p_attribute1 VARCHAR2,
29 p_attribute2 VARCHAR2,
30 p_attribute3 VARCHAR2,
31 p_attribute4 VARCHAR2,
32 p_attribute5 VARCHAR2,
33 p_attribute6 VARCHAR2,
34 p_attribute7 VARCHAR2,
35 p_attribute8 VARCHAR2,
36 p_attribute9 VARCHAR2,
37 p_attribute10 VARCHAR2,
38 p_attribute11 VARCHAR2,
39 p_attribute12 VARCHAR2,
40 p_attribute13 VARCHAR2,
41 p_attribute14 VARCHAR2,
42 p_attribute15 VARCHAR2,
43 p_created_by NUMBER ,
44 p_creation_date DATE ,
45 p_last_updated_by NUMBER ,
46 p_last_update_date DATE ,
47 p_last_update_login NUMBER ,
48 p_object_version_number NUMBER)
49
50 IS
51 CURSOR c2 IS SELECT csi_i_extended_attribs_s.NEXTVAL FROM sys.dual;
52 BEGIN
53 IF (px_attribute_id IS NULL) OR (px_attribute_id = fnd_api.g_miss_num) THEN
54 OPEN c2;
55 FETCH c2 into px_attribute_id;
56 CLOSE c2;
57 END IF;
58 INSERT INTO csi_i_extended_attribs(
59 attribute_id,
60 attribute_level,
61 master_organization_id,
62 inventory_item_id,
63 item_category_id,
64 instance_id,
65 attribute_code,
66 attribute_name,
67 attribute_category,
68 description,
69 active_start_date,
70 active_end_date,
71 context,
72 attribute1,
73 attribute2,
74 attribute3,
75 attribute4,
76 attribute5,
77 attribute6,
78 attribute7,
79 attribute8,
80 attribute9,
81 attribute10,
82 attribute11,
83 attribute12,
84 attribute13,
85 attribute14,
86 attribute15,
87 created_by,
88 creation_date,
89 last_updated_by,
90 last_update_date,
91 last_update_login,
92 object_version_number
93 ) VALUES (
94 px_attribute_id,
95 decode( p_attribute_level, fnd_api.g_miss_char, NULL, p_attribute_level),
96 decode( p_master_organization_id, fnd_api.g_miss_num, NULL, p_master_organization_id),
97 decode( p_inventory_item_id, fnd_api.g_miss_num, NULL, p_inventory_item_id),
98 decode( p_item_category_id, fnd_api.g_miss_num, NULL, p_item_category_id),
99 decode( p_instance_id, fnd_api.g_miss_num, NULL, p_instance_id),
100 decode( p_attribute_code, fnd_api.g_miss_char, NULL, p_attribute_code),
101 decode( p_attribute_name, fnd_api.g_miss_char, NULL, p_attribute_name),
102 decode( p_attribute_category, fnd_api.g_miss_char, NULL, p_attribute_category),
103 decode( p_description, fnd_api.g_miss_char, NULL, p_description),
104 decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
105 decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
106 decode( p_context, fnd_api.g_miss_char, NULL, p_context),
107 decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
108 decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
109 decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
110 decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
111 decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
112 decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
113 decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
114 decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
115 decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
116 decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
117 decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
118 decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
119 decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
120 decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
121 decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
122 decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
123 decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
124 decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
125 decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
126 decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
127 decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
128 END insert_row;
129
130 PROCEDURE update_row(
131 p_attribute_id NUMBER ,
132 p_attribute_level VARCHAR2,
133 p_master_organization_id NUMBER ,
134 p_inventory_item_id NUMBER ,
135 p_item_category_id NUMBER ,
136 p_instance_id NUMBER ,
137 p_attribute_code VARCHAR2,
138 p_attribute_name VARCHAR2,
139 p_attribute_category VARCHAR2,
140 p_description VARCHAR2,
141 p_active_start_date DATE ,
142 p_active_end_date DATE ,
143 p_context VARCHAR2,
144 p_attribute1 VARCHAR2,
145 p_attribute2 VARCHAR2,
146 p_attribute3 VARCHAR2,
147 p_attribute4 VARCHAR2,
148 p_attribute5 VARCHAR2,
149 p_attribute6 VARCHAR2,
150 p_attribute7 VARCHAR2,
151 p_attribute8 VARCHAR2,
152 p_attribute9 VARCHAR2,
153 p_attribute10 VARCHAR2,
154 p_attribute11 VARCHAR2,
155 p_attribute12 VARCHAR2,
156 p_attribute13 VARCHAR2,
157 p_attribute14 VARCHAR2,
158 p_attribute15 VARCHAR2,
159 p_created_by NUMBER ,
160 p_creation_date DATE ,
161 p_last_updated_by NUMBER ,
162 p_last_update_date DATE ,
163 p_last_update_login NUMBER ,
164 p_object_version_number NUMBER)
165
166 IS
167 BEGIN
168 UPDATE csi_i_extended_attribs
169 SET
170 attribute_level = decode( p_attribute_level, fnd_api.g_miss_char, attribute_level, p_attribute_level),
171 master_organization_id = decode( p_master_organization_id, fnd_api.g_miss_num, master_organization_id, p_master_organization_id),
172 inventory_item_id = decode( p_inventory_item_id, fnd_api.g_miss_num, inventory_item_id, p_inventory_item_id),
173 item_category_id = decode( p_item_category_id, fnd_api.g_miss_num, item_category_id, p_item_category_id),
174 instance_id = decode( p_instance_id, fnd_api.g_miss_num, instance_id, p_instance_id),
175 attribute_code = decode( p_attribute_code, fnd_api.g_miss_char, attribute_code, p_attribute_code),
176 attribute_name = decode( p_attribute_name, fnd_api.g_miss_char, attribute_name, p_attribute_name),
177 attribute_category = decode( p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category),
178 description = decode( p_description, fnd_api.g_miss_char, description, p_description),
179 active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
180 active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
181 context = decode( p_context, fnd_api.g_miss_char, context, p_context),
182 attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
183 attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
184 attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
185 attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
186 attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
187 attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
188 attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
189 attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
190 attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
191 attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
192 attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
193 attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
194 attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
195 attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
196 attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
197 created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
198 creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
199 last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
200 last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
201 last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
202 object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
203 WHERE attribute_id = p_attribute_id;
204
205 IF (SQL%NOTFOUND) THEN
206 RAISE no_data_found;
207 END IF;
208 END update_row;
209
210 PROCEDURE delete_row(
211 p_attribute_id NUMBER)
212 IS
213 BEGIN
214 DELETE FROM csi_i_extended_attribs
215 WHERE attribute_id = p_attribute_id;
216 IF (SQL%NOTFOUND) THEN
217 RAISE no_data_found;
218 END IF;
219 END delete_row;
220
221
222 END csi_i_ext_attrib_pkg;