89: IS
90:
91: BEGIN
92:
93: INSERT INTO cs_qm_folder_filters
94: (folder_filter_id, user_folder_id, function_filter_id,
95: filter_operator, filter_value, filter_value_id,
96: last_update_date, last_updated_by, last_update_login,
97: creation_date, created_by, object_version_number)
95: filter_operator, filter_value, filter_value_id,
96: last_update_date, last_updated_by, last_update_login,
97: creation_date, created_by, object_version_number)
98: VALUES
99: (cs_qm_folder_filters_s.nextVal, l_user_folder_id, l_function_filter_id,
100: '=', l_filter_value, l_filter_value_id,
101: sysdate, l_user_id, l_user_id, sysdate, l_user_id, 1);
102: COMMIT;
103:
113: IS
114:
115: BEGIN
116:
117: UPDATE cs_qm_folder_filters
118: SET filter_value = l_filter_value,
119: filter_value_id = l_filter_value_id
120: WHERE user_folder_id = l_user_folder_id
121: AND function_filter_id = l_function_filter_id;
143: AND folder_name = l_folder_name;
144:
145: FOR filter_item in filter_rec LOOP
146:
147: INSERT INTO cs_qm_folder_filters
148: (folder_filter_id, user_folder_id, function_filter_id, filter_operator,
149: filter_value,
150: last_update_date, last_updated_by, last_update_login,
151: creation_date, created_by, object_version_number)
149: filter_value,
150: last_update_date, last_updated_by, last_update_login,
151: creation_date, created_by, object_version_number)
152: VALUES
153: (cs_qm_folder_filters_s.nextVal, l_user_folder_id,
154: filter_item.function_filter_id, '=', '',
155: sysdate, l_user_id, l_user_id, sysdate, l_user_id, 1);
156: COMMIT;
157: