[Home] [Help]
85:
86: cursor c_groupby (l_query_id in number,
87: l_source_type in number, l_object_type in number) is
88: select group_by, sequence
89: from msc_selection_criteria_v
90: where folder_id = l_query_id
91: and nvl(source_type, -1) = nvl(l_source_type, -1)
92: and nvl(object_type, -1) = nvl(l_object_type, -1)
93: and nvl(count_by, 2) = 1
784: AND_OR, COUNT_BY, SEARCH_QUERY_ID,
785: SEARCH_QUERY_NAME, DEFAULT_FLAG,
786: PUBLIC_FLAG, FROM_FIELD_VALUE, TO_FIELD_VALUE,
787: OBJECT_TYPE, SOURCE_TYPE, ACTIVE_FLAG
788: from msc_selection_criteria
789: where folder_id = p_query;
790:
791: cursor c_among_criteria(p_query_id in number) is
792: select SEQUENCE,FIELD_NAME, OR_VALUES,
856: end if;
857:
858: for rec_pers_criteria in c_pers_criteria(p_query_id)
859: loop
860: INSERT INTO msc_selection_criteria
861: (SEQUENCE, FOLDER_ID, OBJECT_SEQUENCE_ID, FIELD_NAME, FIELD_TYPE,
862: HIDDEN_FROM_FIELD, CONDITION,
863: FROM_FIELD, TO_FIELD, FOLDER_OBJECT,
864: TREE_NODE, CREATION_DATE, CREATED_BY,
975:
976: delete from msc_pq_types
977: where query_id = p_query_id;
978:
979: delete from msc_selection_criteria
980: where folder_id = p_query_id;
981:
982: delete from msc_among_values
983: where folder_id = p_query_id;