APPS.CSI_I_EXT_ATTRIB_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_EXTENDED_ATTRIBS_PKG';

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 ,

Line 51: CURSOR c2 IS SELECT csi_i_extended_attribs_s.NEXTVAL FROM sys.dual;

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;

Line 58: INSERT INTO csi_i_extended_attribs(

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,

Line 168: UPDATE csi_i_extended_attribs

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),

Line 214: DELETE FROM csi_i_extended_attribs

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;