APPS.MSC_PQ_UTILS dependencies on MSC_PERS_QUERIES

Line 2041: msc_pers_queries.populate_result_table(p_query_id,

2037: END IF;
2038: where_clause_segment := where_clause_segment|| 'AND CATEGORY_SET_ID = '||g_category_set_id;
2039: where_clause_segment := ' ( '||where_clause_segment||' ) ';
2040: --KSA_DEBUG(SYSDATE,'w clause <> '||where_clause_segment,'execute_one');
2041: msc_pers_queries.populate_result_table(p_query_id,
2042: p_query_type,
2043: p_plan_id,
2044: where_clause_segment,
2045: p_execute_flag,

Line 2067: msc_pers_queries.populate_result_table

2063: --KSA_DEBUG(SYSDATE,'*2* w clause <> '||where_clause_segment,'execute_one');
2064: IF p_calledFromUI <> 1 THEN
2065: where_clause_segment := where_clause_segment|| 'AND CATEGORY_SET_ID = '||g_category_set_id;
2066:
2067: msc_pers_queries.populate_result_table
2068: (p_query_id,
2069: p_query_type,
2070: p_plan_id,
2071: where_clause_segment,

Line 2079: msc_pers_queries.populate_result_table(p_query_id,

2075:
2076: ELSIF p_query_type = 12 THEN
2077: retrieve_values(p_query_id);
2078: where_clause_segment := build_where_clause_new(p_query_id, 100, l_category_id);
2079: msc_pers_queries.populate_result_table(p_query_id,
2080: p_query_type, -1,where_clause_segment,
2081: p_execute_flag, p_master_query_id, p_partOfWorklist);
2082:
2083:

Line 2113: msc_pers_queries.populate_result_table(p_query_id,

2109: END IF;
2110: IF where_clause_segment IS NOT NULL THEN
2111: where_clause_segment := ' ( '||where_clause_segment||' ) ';
2112: --KSA_DEBUG(SYSDATE,'*3* w clause <> '||where_clause_segment,'execute_one');
2113: msc_pers_queries.populate_result_table(p_query_id,
2114: p_query_type,
2115: p_plan_id,
2116: where_clause_segment,
2117: p_execute_flag,

Line 2122: msc_pers_queries.populate_result_table(p_query_id,

2118: l_master_query_id);
2119: END IF;
2120: IF where_clause_segment2 IS NOT NULL THEN
2121: where_clause_segment2 := ' ( '||where_clause_segment2||' ) ';
2122: msc_pers_queries.populate_result_table(p_query_id,
2123: p_query_type, -1,where_clause_segment2,
2124: p_execute_flag,l_master_query_id);
2125: END IF;
2126: END IF;

Line 2133: msc_pers_queries.populate_result_table(p_query_id,

2129: --Run worklist Summarization
2130: -- pass -99
2131: -- -------------------------------
2132: --KSA_DEBUG(SYSDATE,'before execute populate_result_table, '||p_query_id||' l_master_query_id '||l_master_query_id,'execute_one');
2133: msc_pers_queries.populate_result_table(p_query_id,
2134: -99,
2135: p_plan_id,
2136: '',
2137: p_execute_flag,

Line 2281: MSC_pers_queries.purge_plan(p_plan_id);

2277: CLOSE check_release_method;
2278: IF NVL(l_auto_release,0) not in ( 3,4) THEN
2279: RETURN;
2280: END IF;
2281: MSC_pers_queries.purge_plan(p_plan_id);
2282: FOR rec_queries IN cur_queries LOOP
2283: execute_one(p_plan_id,
2284: 2,
2285: 2,