APPS.MSC_PERS_QUERIES dependencies on MSC_GET_NAME

Line 160: msc_get_name.execute_dsql(l_sql_stmt);

156: ' FROM '||p_item_view||
157: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
158: put_line(l_sql_stmt);
159: --KSA_DEBUG(SYSDATE,'*1* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
160: msc_get_name.execute_dsql(l_sql_stmt);
161: elsif (p_query_type = p_res_type) then
162: l_sql_stmt := l_insert_begin||l_res_cols||l_insert_end||
163: l_select_begin||l_summary_col||l_res_cols||l_who_cols||
164: ' FROM '||p_res_view||

Line 167: msc_get_name.execute_dsql(l_sql_stmt);

163: l_select_begin||l_summary_col||l_res_cols||l_who_cols||
164: ' FROM '||p_res_view||
165: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
166: put_line(l_sql_stmt);
167: msc_get_name.execute_dsql(l_sql_stmt);
168: elsif (p_query_type = p_supp_type) then
169: l_sql_stmt := l_insert_begin||l_supp_cols||l_insert_end||
170: l_select_begin||l_summary_col||l_supp_cols||l_who_cols||
171: ' FROM '||p_supp_view||

Line 174: msc_get_name.execute_dsql(l_sql_stmt);

170: l_select_begin||l_summary_col||l_supp_cols||l_who_cols||
171: ' FROM '||p_supp_view||
172: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
173: put_line(l_sql_stmt);
174: msc_get_name.execute_dsql(l_sql_stmt);
175: ELSIF (p_query_type = p_order_type) then
176: l_sql_stmt := l_insert_begin||l_order_cols||l_insert_end||
177: l_select_begin||l_summary_col||l_Order_cols1||l_who_cols||
178: ' FROM '||p_order_view||

Line 182: msc_get_name.execute_dsql(l_sql_stmt);

178: ' FROM '||p_order_view||
179: ' WHERE plan_id = '||p_plan_id||' AND '||p_where_clause;
180: --KSA_DEBUG(SYSDATE,'l_sql_stmt is '||l_sql_stmt,'populate_result_table');
181: put_line(l_sql_stmt);
182: msc_get_name.execute_dsql(l_sql_stmt);
183: elsif (p_query_type IN (p_excp_type,p_wl_type)) then
184: --KSA_DEBUG(SYSDATE,' p_query_type <> '||p_query_type,'populate_result_table');
185: IF l_temp_query_type = p_wl_type THEN
186: IF p_query_type <> p_wl_type THEN

Line 310: msc_get_name.execute_dsql(l_sql_stmt);

306: END IF;
307: end if;
308: put_line(l_sql_stmt);
309: --KSA_DEBUG(SYSDATE,'*1* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
310: msc_get_name.execute_dsql(l_sql_stmt);
311:
312: end loop;
313: close c_excp_types;
314:

Line 465: msc_get_name.execute_dsql(l_sql_stmt);

461: END IF;
462: end if;
463: put_line(l_sql_stmt);
464: --KSA_DEBUG(SYSDATE,'*2* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
465: msc_get_name.execute_dsql(l_sql_stmt);
466:
467: end loop;
468: close c_excp_types;
469:

Line 532: msc_get_name.execute_dsql(l_sql_stmt);

528: l_who_cols||
529: ' FROM '||p_item_attributes_view||
530: ' where simulation_set_id is NULL and plan_id = '||p_plan_id||' and '||p_where_clause;
531:
532: msc_get_name.execute_dsql(l_sql_stmt);
533:
534: return;
535:
536: elsif (p_query_type = p_shipment_type) then

Line 544: msc_get_name.execute_dsql(l_sql_stmt);

540: ' where plan_id = '||p_plan_id||' and '||p_where_clause ||
541: ' GROUP BY PLAN_ID, SHIPMENT_ID, FROM_ORG_ID, FROM_ORG_INSTANCE_ID, '||
542: ' TO_ORG_ID, TO_ORG_INSTANCE_ID, ORGANIZATION_ID, SR_INSTANCE_ID ';
543: put_line(l_sql_stmt);
544: msc_get_name.execute_dsql(l_sql_stmt);
545: end if;
546:
547:
548: update msc_personal_queries