APPS.MSC_E1APS_DSMCOLL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

				select MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scrName,'001','',WSURL) into ReturnStr from dual;

Line: 34

					select instr(ReturnStr,'#') into StartIndex from dual;

Line: 35

					select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line: 40

			select instr(ReturnStr,'#') into StartIndex from dual;

Line: 41

			select substr(ReturnStr,0,StartIndex-1) into SessionNum from dual;

Line: 42

			select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line: 95

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = parInstanceID;

Line: 119

		select ATTRIBUTE14,ATTRIBUTE13 into source_file,destination_file from MSC_APPS_INSTANCES where INSTANCE_ID = parInstanceID;

Line: 131

				select MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(WSURL,2) into ReturnStr from dual;

Line: 135

				select instr(ReturnStr,'#') into StartIndex from dual;

Line: 136

				select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line: 141

			  select instr(ReturnStr,'#') into StartIndex from dual;

Line: 142

				select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;

Line: 252

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = parInstanceID;