APPS.MSC_PERS_QUERIES dependencies on MSC_PQ_TYPES

Line 72: FROM msc_pq_types

68: l_source_type number;
69:
70: CURSOR cur_priority(p_query_id NUMBER,p_detail_query_id NUMBER) IS
71: SELECT NVL(priority,999)
72: FROM msc_pq_types
73: WHERE query_id= p_query_id
74: AND NVL(detail_query_id,query_id) = p_detail_query_id;
75:
76: cursor c_groupby (l_query_id in number,

Line 94: from msc_pq_types

90: WHERE QUERY_ID = l_query;
91:
92: cursor c_excp_types (l_query_id number) is
93: select source_type, object_type, sequence_id,NVL(priority,999), frequency
94: from msc_pq_types
95: where query_id = l_query_id;
96:
97: CURSOR c_frequency(p_query_id NUMBER, p_detail_query_id IN NUMBER) is
98: SELECT frequency

Line 99: FROM msc_pq_types

95: where query_id = l_query_id;
96:
97: CURSOR c_frequency(p_query_id NUMBER, p_detail_query_id IN NUMBER) is
98: SELECT frequency
99: FROM msc_pq_types
100: WHERE query_id = p_query_id
101: AND detail_query_id = p_detail_query_id;
102:
103: l_group_by varchar2(30);

Line 105: l_seq_id number; -- sequence_id in msc_pq_types

101: AND detail_query_id = p_detail_query_id;
102:
103: l_group_by varchar2(30);
104: l_seq number;
105: l_seq_id number; -- sequence_id in msc_pq_types
106:
107: l_source number;
108: l_object number;
109:

Line 714: from msc_pq_types

710: SEQUENCE_ID, AND_OR_FLAG, CREATION_DATE,
711: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
712: CUSTOMIZED_TEXT, OBJECT_TYPE_TEXT, ACTIVE_FLAG,
713: DETAIL_QUERY_ID,FREQUENCY,PRIORITY
714: from msc_pq_types
715: where query_id = p_query;
716:
717: cursor c_pers_criteria (p_query in number) is
718: select SEQUENCE, FOLDER_ID, OBJECT_SEQUENCE_ID,

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

769: rec_pers_queries.AUTO_RELEASE,rec_pers_queries.GROUP_ID,rec_pers_queries.UPDATED_FLAG);
770:
771: for rec_pq_types in c_pq_types(p_query_id)
772: loop
773: INSERT INTO MSC_PQ_TYPES (QUERY_ID, SOURCE_TYPE, OBJECT_TYPE,
774: SEQUENCE_ID, AND_OR_FLAG, CREATION_DATE,
775: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
776: CUSTOMIZED_TEXT, OBJECT_TYPE_TEXT, ACTIVE_FLAG,
777: DETAIL_QUERY_ID,FREQUENCY,PRIORITY)

Line 889: delete from msc_pq_types

885: begin
886: delete from msc_personal_queries
887: where query_id = p_query_id;
888:
889: delete from msc_pq_types
890: where query_id = p_query_id;
891:
892: delete from msc_selection_criteria
893: where folder_id = p_query_id;