APPS.MSC_E1_APS_PDP SQL Statements

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

Line: 28

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

Line: 33

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

Line: 34

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

Line: 39

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

Line: 40

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

Line: 41

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

Line: 77

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

Line: 81

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

Line: 82

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

Line: 87

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

Line: 88

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

Line: 89

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

Line: 105

				sql_cnd := 'select INSTR('''||ws_prf||''','''||srch_str||''') from dual';

Line: 185

		updateFlag    NUMBER(2) ; /* Bug#9757888  To Update TP_SITE_CODE */

Line: 308

			select instance_code into l_instance_code from msc_apps_instances
				where instance_id = parInstanceID;

Line: 357

		-- Items will also be run after ATP Rules whenever ATP Rules is selected to update ATP Rule ID in system_items
		-- set parameters for items to Yes

		/*Dependency Check for ATP Rules */
		IF parItems = MSC_UTIL.SYS_YES THEN
			locAtpRule := MSC_UTIL.SYS_YES;

Line: 588

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

Line: 592

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

Line: 593

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

Line: 599

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

Line: 600

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

Line: 615

			DELETE FROM MSC_ST_PRICE_LIST;

Line: 620

                    MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSC_ST_PRICE_LIST');

Line: 624

			MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSC_ST_PRICE_LIST');

Line: 635

			SELECT INSTANCE_CODE into parInstanceCode FROM MSC_APPS_INSTANCES
			WHERE  INSTANCE_ID = parInstanceId;

Line: 646

			DELETE FROM MSC_ST_CALENDARS
			WHERE SR_INSTANCE_CODE like parInstanceCode AND  PROCESS_FLAG =1;

Line: 651

                    MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows deleted from MSC_ST_CALENDARS');

Line: 733

				-- Bug#9842448  Stage05 to Update TP_SITE_CODE
				MSC_UTIL.MSC_DEBUG('Updating TP_SITE_CODE with LOCATION');

Line: 735

				updateFlag:= MSC_UTIL.SYS_NO;

Line: 736

				setreq_success:=fnd_submit.submit_program('MSC','MSCE1TPSITECODE','Stage05', parInstanceID,updateFlag);

Line: 839

				-- Bug#9842448  Stage90 to Update TP_SITE_CODE
				MSC_UTIL.MSC_DEBUG('Updating TP_SITE_CODE with BILL_TO OR SHIP_TO');

Line: 841

				updateFlag:= MSC_UTIL.SYS_YES;

Line: 843

				setreq_success:=fnd_submit.submit_program('MSC','MSCE1TPSITECODE','Stage90', parInstanceID,updateFlag);