eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_DVC_INTG_PVT SQL Statements

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

Line: 6


ACTION_INSERT_RESPONSE CONSTANT VARCHAR2(30) := 'INSERT_RESPONSE';

Line: 7


ACTION_UPDATE_RESPONSE CONSTANT VARCHAR2(30) := 'UPDATE_RESPONSE';

Line: 8


ACTION_INSERT_REQUEST CONSTANT VARCHAR2(30) := 'INSERT_REQUEST';

Line: 9


ACTION_UPDATE_DEVICE_STATUS CONSTANT VARCHAR2(30) := 'UPDATE_DEVICE_STATUS';

Line: 10


ACTION_UPDATE_DEVICE_RESPONSE CONSTANT VARCHAR2(30) := 'UPDATE_DEVICE_RESPONSE';

Line: 28


cursor c_get_device_details is select name from wms_devices_vl where device_id = P_DEVICE_ID;

Line: 194


	DELETE FROM GMO_DEVICE_RESPONSES_T WHERE REQUEST_ID IN
    (SELECT REQUEST_ID FROM GMO_DEVICE_REQUESTS_T
      WHERE CREATION_DATE < l_cleanup_to_date );

Line: 198


	DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE < l_cleanup_to_date;

Line: 228


	IF (P_ACTION = ACTION_INSERT_RESPONSE) then
		insert into gmo_device_responses_t
			(
				RESPONSE_ID,
				REQUEST_ID,
				RESP_COMP_CODE,
				RESP_COMP_CODE_VALUE,
				CREATED_BY,
				CREATION_DATE,
				LAST_UPDATED_BY,
				LAST_UPDATE_LOGIN,
				LAST_UPDATE_DATE
			) values(
				GMO_DEVICE_RESPONSES_T_S.nextval,
				P_REQUEST_ID,
				P_RESP_COMP_CODE,
				P_RESP_COMP_CODE_VALUE,
				FND_GLOBAL.USER_ID,
				sysdate,
				FND_GLOBAL.USER_ID,
				FND_GLOBAL.LOGIN_ID,
				sysdate
			);

Line: 251


	ELSIF (P_ACTION = ACTION_UPDATE_RESPONSE) then

		update gmo_device_responses_t set
			RESP_COMP_CODE_VALUE = P_RESP_COMP_CODE_VALUE,
			LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
			LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
			LAST_UPDATE_DATE = sysdate
		where REQUEST_ID = P_REQUEST_ID
		and RESP_COMP_CODE = P_RESP_COMP_CODE;

Line: 296


	IF (P_ACTION = ACTION_INSERT_REQUEST) then

		INSERT INTO GMO_DEVICE_REQUESTS_T (REQUEST_ID, DEVICE_ID, REQUESTER, RESPONSE_STATUS, DEVICE_STATUS, REQUEST_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE)
		VALUES (P_REQUEST_ID, P_DEVICE_ID, P_REQUESTER, '', P_DEVICE_STATUS, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, SYSDATE);

Line: 301


	ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_STATUS) then

		UPDATE GMO_DEVICE_REQUESTS_T SET
			DEVICE_STATUS = P_DEVICE_STATUS,
			LAST_UPDATE_DATE = sysdate,
			LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
			LAST_UPDATED_BY = FND_GLOBAL.USER_ID
			WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;

Line: 310


	ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_RESPONSE) then
		-- update process_device_response
		UPDATE GMO_DEVICE_REQUESTS_T SET
			RESPONSE_STATUS = FND_API.G_RET_STS_SUCCESS,
			LAST_UPDATE_DATE = sysdate,
			LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
			LAST_UPDATED_BY = FND_GLOBAL.USER_ID
		WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;

Line: 381


cursor c_get_msg_component is select RESP_COMP_CODE_VALUE, RESP_COMP_CODE_UOM from gmp_resource_device_messages where resource_id = P_RESOURCE_ID and device_id = P_DEVICE_ID and process_param_id = L_PARAM_ID AND EVENT_ID = P_EVENT_ID;

Line: 382


cursor c_get_parameter_details is select parameter_name from gmp_process_parameters where parameter_id = l_param_id;

Line: 599


cursor c_get_org_details is select organization_code from mtl_parameters where organization_id = P_ORGANIZATION_ID;

Line: 600


cursor c_get_device_details is select output_method, output_method_id, name, subinventory_code from wms_devices_vl where device_id = P_DEVICE_ID;

Line: 601


cursor c_get_device_response is select RESP_COMP_CODE_VALUE from gmo_device_responses_t where request_id = l_request_id and RESP_COMP_CODE = l_response_code;

Line: 693


	select sysdate into l_request_start_date from dual;

Line: 709


	POST_REQUEST (P_ACTION => ACTION_INSERT_REQUEST, P_REQUEST_ID => l_request_id, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => P_REQUESTER , P_DEVICE_STATUS => '');

Line: 712


		POST_RESPONSE (P_ACTION => ACTION_INSERT_RESPONSE, P_REQUEST_ID => l_request_id, P_RESP_COMP_CODE => P_MSG_COMPONENT(I), P_RESP_COMP_CODE_VALUE => '');

Line: 722


	POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_STATUS, P_REQUEST_ID => l_request_id, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => P_REQUESTER , P_DEVICE_STATUS => l_return_status);

Line: 749


	   select sysdate into l_request_current_date from dual;

Line: 752


	   select RESPONSE_STATUS into l_response_status from gmo_device_requests_t where request_id = l_request_id;

Line: 958


	select count(*) into l_count from GMO_DEVICE_REQUESTS_T WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;

Line: 967


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'1' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.ORGANIZATION);

Line: 968


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'2' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.ORDER_NUMBER);

Line: 969


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'3' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.ITEM);

Line: 970


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'4' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.BUSINESS_EVENT);

Line: 971


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'10' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.LPN);

Line: 972


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'11' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.LOT);

Line: 973


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'12' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.UOM);

Line: 974


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'13' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.CYCLE_COUNT_ID);

Line: 975


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'14' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.QUANTITY);

Line: 976


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'15' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.REQUESTED_QUANTITY);

Line: 977


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'16' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.WEIGHT);

Line: 978


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'17' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.WEIGHT_UOM_CODE);

Line: 979


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'18' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.VOLUME);

Line: 980


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'19' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.VOLUME_UOM_CODE);

Line: 981


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'20' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.LENGTH);

Line: 982


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'21' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.WIDTH);

Line: 983


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'22' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.HEIGHT);

Line: 984


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'23' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DIMENSIONAL_WEIGHT);

Line: 985


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'24' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DIMENSIONAL_WEIGHT_FACTOR);

Line: 986


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'25' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.NET_WEIGHT);

Line: 987


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'26' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.RECEIVED_REQUEST_DATE_AND_TIME);

Line: 988


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'27' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.MEASUREMENT_DATE_AND_TIME);

Line: 989


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'28' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.RESPONSE_DATE_AND_TIME);

Line: 990


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'29' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.TEMPERATURE);

Line: 991


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'30' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.TEMPERATURE_UOM);

Line: 992


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'31' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.REASON_ID);

Line: 993


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'32' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.REASON_TYPE);

Line: 994


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'33' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.SENSOR_MEASUREMENT_TYPE);

Line: 995


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'34' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.VALUE);

Line: 996


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'35' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.QUALITY);

Line: 997


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'36' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.OPC_VARIANT_CODE);

Line: 998


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'37' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.EPC);

Line: 999


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'38' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.UNUSED);

Line: 1000


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'39' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.BATCH);

Line: 1001


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'40' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_1);

Line: 1002


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'41' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_2);

Line: 1003


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'42' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_3);

Line: 1004


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'43' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_4);

Line: 1005


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'44' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_5);

Line: 1006


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'45' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_6);

Line: 1007


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'46' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_7);

Line: 1008


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'47' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_8);

Line: 1009


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'48' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_9);

Line: 1010


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'49' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_COMPONENT_10);

Line: 1011


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'50' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.RELATION_ID);

Line: 1012


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'51' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.TASK_ID);

Line: 1013


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'52' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.TASK_SUMMARY);

Line: 1014


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'53' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.ORGANIZATION_ID);

Line: 1015


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'54' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.INVENTORY_ITEM_ID);

Line: 1016


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'55' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DEVICE_STATUS);

Line: 1017


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'56' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.TRANSFER_LPN_ID);

Line: 1018


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'57' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DESTINATION_SUBINVENTORY);

Line: 1019


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'58' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DESTINATION_LOCATOR_ID);

Line: 1020


	POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'59' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.SOURCE_LOCATOR_ID);

Line: 1022


	-- update process_device_response
	POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => FND_GLOBAL.USER_ID , P_DEVICE_STATUS => '');