The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scenario_name,scenario_version,scenario_param,wsurl)
INTO return_str
FROM dual;
SELECT instr(return_str,'#')
INTO start_index
FROM dual;
SELECT SUBSTR(return_str,start_index+1,1800)
INTO err_message
FROM dual;
SELECT instr(return_str,'#')
INTO start_index
FROM dual;
SELECT SUBSTR(return_str,0,start_index-1)
INTO session_num
FROM dual;
SELECT SUBSTR(return_str,start_index+1,1800)
INTO err_message
FROM dual;
select instance_code into l_instance_code
from msc_apps_instances
where instance_id = p_instance_id;
DELETE
FROM MSD_DEM_PRICE_LISTS;
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
/* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
BEGIN
INSERT
INTO MSD_DEM_PRICE_LISTS
( PRICE_LIST_NAME ,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY
)
SELECT DISTINCT PRICE_LIST_NAME,
-1 ,
SYSDATE ,
-1 ,
SYSDATE ,
-1
FROM MSC_ST_PRICE_LIST;
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
SELECT COUNT(*)
INTO total_rows
FROM MSD_DEM_PRICE_LISTS;
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
select instance_code into l_instance_code
from msc_apps_instances
where instance_id = p_instance_id;
select instance_code into l_instance_code from msc_apps_instances
where instance_id = p_instance_id;
SELECT ATTRIBUTE13,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14
INTO p_data_path ,
p_control_path ,
destination_file,
source_file
FROM MSC_APPS_INSTANCES
WHERE INSTANCE_ID = p_instance_id;
DELETE
FROM MSD_DEM_CALENDARS;
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
INSERT
INTO MSD_DEM_CALENDARS
(
INSTANCE ,
CALENDAR_TYPE ,
CALENDAR_CODE ,
LAST_UPDATE_DATE,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN
)
SELECT MAI.INSTANCE_CODE ,
'Manufacturing' ,
MC.CALENDAR_CODE ,
MC.LAST_UPDATE_DATE,
MC.LAST_UPDATED_BY ,
MC.CREATION_DATE ,
MC.CREATED_BY ,
MC.LAST_UPDATE_LOGIN
FROM MSC_CALENDARS MC,
MSC_APPS_INSTANCES MAI
WHERE MC.SR_INSTANCE_ID = p_instance_id
AND MAI.INSTANCE_ID = MC.SR_INSTANCE_ID;
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instance_code into l_instance_code from msc_apps_instances
where instance_id = p_instance_id;
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
SELECT ATTRIBUTE14,
ATTRIBUTE13
INTO source_file,
destination_file
FROM MSC_APPS_INSTANCES
WHERE INSTANCE_ID = p_instance_id;
select instance_code into l_instance_code from msc_apps_instances
where instance_id = p_instance_id;
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instance_code into l_instance_code from msc_apps_instances
where instance_id = p_instance_id;
x_org_sql := 'select t_ep_organization_ep_id from ' || g_demantra_schema
||'.t_ep_organization where organization IN ( select organization_code from msc_trading_partners '
||'where sr_instance_id = ' || p_instance_id|| ' and partner_type=3) order by t_ep_organization_ep_id' ;
x_sql := 'select id from '|| g_demantra_schema ||'.TRANSFER_QUERY where query_name like ''AIA-Forecast data''';
x_sql := 'select filter_id from '|| g_demantra_schema ||'.transfer_query_filters where id = ' || g_data_profile_id ;
x_sql := 'Delete from ' || g_demantra_schema ||'.transfer_query_filter_m where filter_id = ' || g_filter_id ;
x_sql := 'INSERT INTO ' || g_demantra_schema ||'.transfer_query_filter_m VALUES('||g_filter_id ||','||g_member_id || ')';
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
select instance_code into l_instance_code
from msc_apps_instances
where instance_id = p_instance_id;
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
scenario_name := 'LOADDMDELETEPROMOPRICINGDATATOE1PKG';
select instance_code into l_instance_code
from msc_apps_instances
where instance_id = p_instance_id;
SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
INTO ReturnStr
FROM dual;
select instr(ReturnStr,'#') into StartIndex from dual;
select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;