APPS.MSC_E1APS_DEMCL dependencies on MSD_DEM_DEMANTRA_UTILITIES

Line 381: || MSD_DEM_DEMANTRA_UTILITIES.GET_DEMANTRA_SCHEMA

377: END IF;
378: /* Truncating T_SRC_SALES_TMPL table */
379: Begin
380: l_sql:= 'Truncate table '
381: || MSD_DEM_DEMANTRA_UTILITIES.GET_DEMANTRA_SCHEMA
382: || '.T_SRC_SALES_TMPL';
383: EXECUTE immediate l_sql;
384: EXCEPTION
385: WHEN OTHERS THEN

Line 1149: g_demantra_schema:=MSD_DEM_DEMANTRA_UTILITIES.GET_DEMANTRA_SCHEMA;

1145: RETCODE := MSC_UTIL.G_ERROR;
1146: RETURN;
1147: END IF;
1148: END IF;
1149: g_demantra_schema:=MSD_DEM_DEMANTRA_UTILITIES.GET_DEMANTRA_SCHEMA;
1150: x_org_sql := 'select t_ep_organization_ep_id from ' || g_demantra_schema
1151: ||'.t_ep_organization where organization IN ( select organization_code from msc_trading_partners '
1152: ||'where sr_instance_id = ' || p_instance_id|| ' and partner_type=3) order by t_ep_organization_ep_id' ;
1153: