APPS.MSC_PERS_QUERIES dependencies on MSC_GET_NAME

Line 206: msc_get_name.execute_dsql(l_sql_stmt);

202: ' FROM '||p_item_view||
203: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
204: put_line(l_sql_stmt);
205: --KSA_DEBUG(SYSDATE,'*1* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
206: msc_get_name.execute_dsql(l_sql_stmt);
207: end;
208: elsif (p_query_type = p_res_type) then
209: l_sql_stmt := l_insert_begin||l_res_cols||l_insert_end||
210: l_select_begin||l_summary_col||l_res_cols||l_who_cols||

Line 214: msc_get_name.execute_dsql(l_sql_stmt);

210: l_select_begin||l_summary_col||l_res_cols||l_who_cols||
211: ' FROM '||p_res_view||
212: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
213: put_line(l_sql_stmt);
214: msc_get_name.execute_dsql(l_sql_stmt);
215: elsif (p_query_type = p_supp_type) then
216: l_sql_stmt := l_insert_begin||l_supp_cols||l_insert_end||
217: l_select_begin||l_summary_col||l_supp_cols||l_who_cols||
218: ' FROM '||p_supp_view||

Line 221: msc_get_name.execute_dsql(l_sql_stmt);

217: l_select_begin||l_summary_col||l_supp_cols||l_who_cols||
218: ' FROM '||p_supp_view||
219: ' where plan_id = '||p_plan_id||' and '||p_where_clause;
220: put_line(l_sql_stmt);
221: msc_get_name.execute_dsql(l_sql_stmt);
222: ELSIF (p_query_type = p_order_type) then
223: declare
224: l_summary_col2 varchar2(10) := '-99,';
225: begin

Line 235: msc_get_name.execute_dsql(l_sql_stmt);

231: ' FROM '||p_order_view||
232: ' WHERE plan_id = '||p_plan_id||' AND '||p_where_clause;
233: --KSA_DEBUG(SYSDATE,'l_sql_stmt is '||l_sql_stmt,'populate_result_table');
234: put_line(l_sql_stmt);
235: msc_get_name.execute_dsql(l_sql_stmt);
236: end;
237: elsif (p_query_type IN (p_excp_type,p_wl_type)) then
238: --KSA_DEBUG(SYSDATE,' p_query_type <> '||p_query_type,'populate_result_table');
239: IF l_temp_query_type = p_wl_type THEN

Line 367: msc_get_name.execute_dsql(l_sql_stmt);

363: END IF;
364: end if;
365: put_line(l_sql_stmt);
366: --KSA_DEBUG(SYSDATE,'*1* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
367: msc_get_name.execute_dsql(l_sql_stmt);
368:
369: end loop;
370: close c_excp_types;
371:

Line 525: msc_get_name.execute_dsql(l_sql_stmt);

521: END IF;
522: end if;
523: put_line(l_sql_stmt);
524: --KSA_DEBUG(SYSDATE,'*2* l_sql_stmt <> '||l_sql_stmt,'populate_result_table');
525: msc_get_name.execute_dsql(l_sql_stmt);
526:
527: end loop;
528: close c_excp_types;
529:

Line 592: msc_get_name.execute_dsql(l_sql_stmt);

588: l_who_cols||
589: ' FROM '||p_item_attributes_view||
590: ' where simulation_set_id is NULL and plan_id = '||p_plan_id||' and '||p_where_clause;
591:
592: msc_get_name.execute_dsql(l_sql_stmt);
593:
594: return;
595:
596: elsif (p_query_type = p_shipment_type) then

Line 604: msc_get_name.execute_dsql(l_sql_stmt);

600: ' where plan_id = '||p_plan_id||' and '||p_where_clause ||
601: ' GROUP BY PLAN_ID, SHIPMENT_ID, FROM_ORG_ID, FROM_ORG_INSTANCE_ID, '||
602: ' TO_ORG_ID, TO_ORG_INSTANCE_ID, ORGANIZATION_ID, SR_INSTANCE_ID ';
603: put_line(l_sql_stmt);
604: msc_get_name.execute_dsql(l_sql_stmt);
605: end if;
606:
607:
608: update msc_personal_queries

Line 1077: msc_get_name.execute_dsql(l_Insert_stmt||l_sql_stmt);

1073: 'exception_count, priority, summary_data'||
1074: l_new_group_by_cols2||
1075: 'created_by, creation_date, '||
1076: 'last_updated_by,last_update_date)';
1077: msc_get_name.execute_dsql(l_Insert_stmt||l_sql_stmt);
1078:
1079: exception
1080: when others then
1081: --KSA_DEBUG(SYSDATE,' l_Insert_stmt >> '||l_Insert_stmt,'Summarize_wklst_results');

Line 1109: msc_get_name.org_code

1105: l_new_group_by_col := FALSE;
1106: IF l_group_by = 'ORGANIZATION_CODE' THEN
1107: l_new_group_by_col1 := 'GROUPBY_ORG';
1108: l_new_group_by_col1 := 'nvl(MPR.GROUPBY_ORG,
1109: msc_get_name.org_code
1110: (MPR.organization_id,
1111: MPR.sr_instance_id)) GROUPBY_ORG';
1112: l_new_group_by_col2 := 'GROUPBY_ORG';
1113: l_new_group_by_col := true;