APPS.MSC_PQ_UTILS dependencies on MSC_PERS_QUERIES

Line 2009: msc_pers_queries.populate_result_table(p_query_id,

2005: where_clause_segment := ' ( -99 = -99 ) ';
2006: END IF;
2007: where_clause_segment := ' ( '||where_clause_segment||' ) ';
2008: -- KSA_DEBUG(SYSDATE,'w clause <> '||where_clause_segment,'execute_one');
2009: msc_pers_queries.populate_result_table(p_query_id,
2010: p_query_type,
2011: p_plan_id,
2012: where_clause_segment,
2013: p_execute_flag,

Line 2031: msc_pers_queries.populate_result_table

2027: --msc_popup_pvt.g_order_where_clause := ' AND '||where_clause_segment;
2028: /* Not required to populate results table if executed from UI.*/
2029: --KSA_DEBUG(SYSDATE,'*2* w clause <> '||where_clause_segment,'execute_one');
2030: IF p_calledFromUI <> 1 THEN
2031: msc_pers_queries.populate_result_table
2032: (p_query_id,
2033: p_query_type,
2034: p_plan_id,
2035: where_clause_segment,

Line 2043: msc_pers_queries.populate_result_table(p_query_id,

2039:
2040: ELSIF p_query_type = 12 THEN
2041: retrieve_values(p_query_id);
2042: where_clause_segment := build_where_clause_new(p_query_id, 100, l_category_id);
2043: msc_pers_queries.populate_result_table(p_query_id,
2044: p_query_type, -1,where_clause_segment,
2045: p_execute_flag, p_master_query_id, p_partOfWorklist);
2046:
2047:

Line 2077: msc_pers_queries.populate_result_table(p_query_id,

2073: END IF;
2074: IF where_clause_segment IS NOT NULL THEN
2075: where_clause_segment := ' ( '||where_clause_segment||' ) ';
2076: -- KSA_DEBUG(SYSDATE,'*3* w clause <> '||where_clause_segment,'execute_one');
2077: msc_pers_queries.populate_result_table(p_query_id,
2078: p_query_type,
2079: p_plan_id,
2080: where_clause_segment,
2081: p_execute_flag,

Line 2086: msc_pers_queries.populate_result_table(p_query_id,

2082: l_master_query_id);
2083: END IF;
2084: IF where_clause_segment2 IS NOT NULL THEN
2085: where_clause_segment2 := ' ( '||where_clause_segment2||' ) ';
2086: msc_pers_queries.populate_result_table(p_query_id,
2087: p_query_type, -1,where_clause_segment2,
2088: p_execute_flag,l_master_query_id);
2089: END IF;
2090: END IF;