APPS.MSC_PERS_QUERIES dependencies on MSC_PQ_TYPES

Line 82: FROM msc_pq_types

78: l_source_type number;
79:
80: CURSOR cur_priority(p_query_id NUMBER,p_detail_query_id NUMBER) IS
81: SELECT NVL(priority,999)
82: FROM msc_pq_types
83: WHERE query_id= p_query_id
84: AND NVL(detail_query_id,query_id) = p_detail_query_id;
85:
86: cursor c_groupby (l_query_id in number,

Line 104: from msc_pq_types

100: WHERE QUERY_ID = l_query;
101:
102: cursor c_excp_types (l_query_id number) is
103: select source_type, object_type, sequence_id,NVL(priority,999), frequency
104: from msc_pq_types
105: where query_id = l_query_id;
106:
107: CURSOR c_frequency(p_query_id NUMBER, p_detail_query_id IN NUMBER) is
108: SELECT frequency

Line 109: FROM msc_pq_types

105: where query_id = l_query_id;
106:
107: CURSOR c_frequency(p_query_id NUMBER, p_detail_query_id IN NUMBER) is
108: SELECT frequency
109: FROM msc_pq_types
110: WHERE query_id = p_query_id
111: AND detail_query_id = p_detail_query_id;
112:
113: l_group_by varchar2(30);

Line 115: l_seq_id number; -- sequence_id in msc_pq_types

111: AND detail_query_id = p_detail_query_id;
112:
113: l_group_by varchar2(30);
114: l_seq number;
115: l_seq_id number; -- sequence_id in msc_pq_types
116:
117: l_source number;
118: l_object number;
119:

Line 774: from msc_pq_types

770: SEQUENCE_ID, AND_OR_FLAG, CREATION_DATE,
771: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
772: CUSTOMIZED_TEXT, OBJECT_TYPE_TEXT, ACTIVE_FLAG,
773: DETAIL_QUERY_ID,FREQUENCY,PRIORITY
774: from msc_pq_types
775: where query_id = p_query;
776:
777: cursor c_pers_criteria (p_query in number) is
778: select SEQUENCE, FOLDER_ID, OBJECT_SEQUENCE_ID,

Line 841: INSERT INTO MSC_PQ_TYPES (QUERY_ID, SOURCE_TYPE, OBJECT_TYPE,

837: rec_pers_queries.AUTO_RELEASE,rec_pers_queries.GROUP_ID,rec_pers_queries.UPDATED_FLAG);
838:
839: for rec_pq_types in c_pq_types(p_query_id)
840: loop
841: INSERT INTO MSC_PQ_TYPES (QUERY_ID, SOURCE_TYPE, OBJECT_TYPE,
842: SEQUENCE_ID, AND_OR_FLAG, CREATION_DATE,
843: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
844: CUSTOMIZED_TEXT, OBJECT_TYPE_TEXT, ACTIVE_FLAG,
845: DETAIL_QUERY_ID,FREQUENCY,PRIORITY)

Line 976: delete from msc_pq_types

972: begin
973: delete from msc_personal_queries
974: where query_id = p_query_id;
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;