APPS.IGS_EN_GS_ATTRIB_VAL dependencies on IGS_EN_ATTRIB_VALUES

Line 33: FROM igs_en_attrib_values

29:
30:
31: CURSOR c_rowid IS
32: SELECT rowid
33: FROM igs_en_attrib_values
34: WHERE obj_type_id = p_obj_type_id
35: AND obj_id = p_obj_id
36: AND attrib_id = p_attrib_id
37: AND version = p_version;

Line 42: FROM igs_en_attrib_values

38:
39:
40: CURSOR c_exists IS
41: SELECT 'Y'
42: FROM igs_en_attrib_values
43: WHERE obj_type_id = p_obj_type_id
44: AND obj_id = p_obj_id
45: AND attrib_id = p_attrib_id
46: AND version = p_version;

Line 101: IGS_EN_ATTRIB_VALUES_PKG.UPDATE_ROW(

97: FETCH c_rowid INTO l_rowid;
98: CLOSE c_rowid;
99:
100: -- Updating the current row
101: IGS_EN_ATTRIB_VALUES_PKG.UPDATE_ROW(
102: X_ROWID => l_rowid ,
103: X_OBJ_TYPE_ID => p_obj_type_id ,
104: X_OBJ_ID => p_obj_id ,
105: X_ATTRIB_ID => p_attrib_id ,

Line 112: IGS_EN_ATTRIB_VALUES_PKG.INSERT_ROW(

108: );
109: x_return_code := 'S01';
110: ELSE
111: -- Inserting the record
112: IGS_EN_ATTRIB_VALUES_PKG.INSERT_ROW(
113: X_ROWID => l_rowid ,
114: X_OBJ_TYPE_ID => p_obj_type_id ,
115: X_OBJ_ID => p_obj_id ,
116: X_ATTRIB_ID => p_attrib_id ,

Line 145: FROM igs_en_attrib_values

141:
142: -- Cursor to get the value from the attributes table
143: CURSOR c_attr_val IS
144: SELECT value
145: FROM igs_en_attrib_values
146: WHERE obj_type_id = p_obj_type_id
147: AND obj_id = p_obj_id
148: AND attrib_id = p_attrib_id
149: AND version = p_version;