The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Insert_Row Procedure */
/*----------------------------------------------------------*/
/* --
-- Purpose
-- Insert a row into WSH_CC_REQUEST_SETUPS entity
--
-- Input Parameters
-- p_api_version
-- API version number (current version is 1.0)
-- p_init_msg_list (optional, default FND_API.G_FALSE)
-- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
-- if set to FND_API.G_TRUE
-- initialize error message list
-- if set to FND_API.G_FALSE - not initialize error
-- message list
-- p_commit (optional, default FND_API.G_FALSE)
-- whether or not to commit the changes to database
--
-- Input parameters for clear cross setups informations
--
-- Output Parameters
-- x_return_status
-- if the process succeeds, the value is
-- fnd_api.g_ret_sts_success;
PROCEDURE Insert_Row
(
p_api_version IN NUMBER ,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
p_commit IN VARCHAR2 := fnd_api.g_false ,
x_return_status OUT VARCHAR2 ,
x_msg_count OUT NUMBER ,
x_msg_data OUT VARCHAR2 ,
p_APPLICATION_ID IN NUMBER,
p_MASTER_ORGANIZATION_ID IN NUMBER,
p_ORGANIZATION_ID IN NUMBER default null,
p_APPLICATION_USER_ID IN NUMBER default null,
p_REQUEST_TYPE_CODE IN VARCHAR2,
p_REQUEST_VERSION IN VARCHAR2,
p_REQUEST_LANGUAGE IN VARCHAR2,
p_REQUEST_DATE_FORMAT IN VARCHAR2,
p_REQUEST_DEPLOYMENT_MODE IN VARCHAR2,
p_REQUEST_HANDLER IN VARCHAR2,
p_REQUEST_OUTPUT_TYPE IN VARCHAR2,
p_REQUEST_INCLUDE_FLAG IN VARCHAR2,
p_ECCN_CATG_SET_ID IN NUMBER,
p_HTS_CATG_SET_ID IN NUMBER,
p_ADDL_CATG_SET_ID IN NUMBER,
p_ADDITIONAL_ECE_COUNTRY_CHECK IN VARCHAR2,
p_CC_REQUEST_SEQUENCE_ID OUT NUMBER
)
IS
l_CC_REQUEST_SEQUENCE_ID NUMBER ;
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
select wsh_cc_request_setups_s.nextval into l_CC_Request_Sequence_ID from dual;
INSERT INTO Wsh_cc_Request_Setups
( CC_REQUEST_SEQUENCE_ID
,APPLICATION_ID
,MASTER_ORGANIZATION_ID
,ORGANIZATION_ID
,APPLICATION_USER_ID
,REQUEST_TYPE_CODE
,REQUEST_VERSION
,REQUEST_LANGUAGE
,REQUEST_DATE_FORMAT
,REQUEST_DEPLOYMENT_MODE
,REQUEST_HANDLER
,REQUEST_OUTPUT_TYPE
,REQUEST_INCLUDE_FLAG
,ECCN_CATG_SET_ID
,HTS_CATG_SET_ID
,ADDL_CATG_SET_ID
,ADDITIONAL_ECE_COUNTRY_CHECK
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
)
values (
l_CC_REQUEST_SEQUENCE_ID
,p_APPLICATION_ID
,p_MASTER_ORGANIZATION_ID
,p_ORGANIZATION_ID
,p_APPLICATION_USER_ID
,p_REQUEST_TYPE_CODE
,p_REQUEST_VERSION
,p_REQUEST_LANGUAGE
,p_REQUEST_DATE_FORMAT
,p_REQUEST_DEPLOYMENT_MODE
,p_REQUEST_HANDLER
,p_REQUEST_OUTPUT_TYPE
,p_REQUEST_INCLUDE_FLAG
,p_ECCN_CATG_SET_ID
,p_HTS_CATG_SET_ID
,p_ADDL_CATG_SET_ID
,p_ADDITIONAL_ECE_COUNTRY_CHECK
,sysdate
,FND_GLOBAL.user_id
,sysdate
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id
) ;
FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
End Insert_Row;
/* Update_Row Procedure */
/*----------------------------------------------------------*/
/* --
-- Purpose
-- Update a row into WSH_CC_request_setups entity
-- for the given cc request seq id
--
-- Input Parameters
-- p_api_version
-- API version number (current version is 1.0)
-- p_init_msg_list (optional, default FND_API.G_FALSE)
-- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
-- if set to FND_API.G_TRUE
-- initialize error message list
-- if set to FND_API.G_FALSE - not initialize error
-- message list
-- p_commit (optional, default FND_API.G_FALSE)
-- whether or not to commit the changes to database
--
-- Input parameters for clear cross request setups informations
--
--
-- Output Parameters
-- x_return_status
-- if the process succeeds, the value is
-- fnd_api.g_ret_sts_success;
PROCEDURE Update_Row
(
p_api_version IN NUMBER ,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
p_commit IN VARCHAR2 := fnd_api.g_false ,
x_return_status OUT VARCHAR2 ,
x_msg_count OUT NUMBER ,
x_msg_data OUT VARCHAR2 ,
p_APPLICATION_ID IN NUMBER,
p_MASTER_ORGANIZATION_ID IN NUMBER,
p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
p_REQUEST_TYPE_CODE IN VARCHAR2,
p_REQUEST_VERSION IN VARCHAR2,
p_REQUEST_LANGUAGE IN VARCHAR2,
p_REQUEST_DATE_FORMAT IN VARCHAR2,
p_REQUEST_DEPLOYMENT_MODE IN VARCHAR2,
p_REQUEST_HANDLER IN VARCHAR2,
p_REQUEST_OUTPUT_TYPE IN VARCHAR2,
p_REQUEST_INCLUDE_FLAG IN VARCHAR2,
p_ECCN_CATG_SET_ID IN NUMBER,
p_HTS_CATG_SET_ID IN NUMBER,
p_ADDL_CATG_SET_ID IN NUMBER,
p_ADDITIONAL_ECE_COUNTRY_CHECK IN VARCHAR2,
p_CC_REQUEST_SEQUENCE_ID IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row' ;
update wsh_cc_request_setups
SET
MASTER_ORGANIZATION_ID = p_MASTER_ORGANIZATION_ID
,APPLICATION_ID = p_APPLICATION_ID
,ORGANIZATION_ID = decode(p_ORGANIZATION_ID,fnd_api.g_miss_num,
ORGANIZATION_ID,p_ORGANIZATION_ID)
,APPLICATION_USER_ID = decode(p_APPLICATION_USER_ID,fnd_api.g_miss_num,
APPLICATION_USER_ID,p_APPLICATION_USER_ID)
,REQUEST_TYPE_CODE = p_REQUEST_TYPE_CODE
,REQUEST_VERSION = p_REQUEST_VERSION
,REQUEST_LANGUAGE = p_REQUEST_LANGUAGE
,REQUEST_DATE_FORMAT = p_REQUEST_DATE_FORMAT
,REQUEST_DEPLOYMENT_MODE = p_REQUEST_DEPLOYMENT_MODE
,REQUEST_HANDLER = p_REQUEST_HANDLER
,REQUEST_OUTPUT_TYPE = p_REQUEST_OUTPUT_TYPE
,REQUEST_INCLUDE_FLAG = p_REQUEST_INCLUDE_FLAG
,ECCN_CATG_SET_ID = p_ECCN_CATG_SET_ID
,HTS_CATG_SET_ID = p_HTS_CATG_SET_ID
,ADDL_CATG_SET_ID = p_ADDL_CATG_SET_ID
,ADDITIONAL_ECE_COUNTRY_CHECK = p_ADDITIONAL_ECE_COUNTRY_CHECK
,LAST_UPDATE_DATE = sysdate
,LAST_UPDATED_BY = FND_GLOBAL.user_id
,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
where cc_request_sequence_id = p_cc_request_sequence_id ;
FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
End Update_Row;
/* Delete_Row Procedure */
/*----------------------------------------------------------*/
/* --
-- Purpose
-- Delete a row from WSH_CC_Request_Setups entity
-- for the given request seq id
--
-- Input Parameters
-- p_api_version
-- API version number (current version is 1.0)
-- p_init_msg_list (optional, default FND_API.G_FALSE)
-- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
-- if set to FND_API.G_TRUE
-- initialize error message list
-- if set to FND_API.G_FALSE - not initialize error
-- message list
-- p_commit (optional, default FND_API.G_FALSE)
-- whether or not to commit the changes to database
--
-- Input parameters for clear cross users informations
-- p_CC_REQUEST_SEQUENCE_ID -- CC Request Seq Id
--
--
-- Output Parameters
-- x_return_status
-- if the process succeeds, the value is
-- fnd_api.g_ret_sts_success;
PROCEDURE Delete_Row
(
p_api_version IN NUMBER ,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
p_commit IN VARCHAR2 := fnd_api.g_false ,
x_return_status OUT VARCHAR2 ,
x_msg_count OUT NUMBER ,
x_msg_data OUT VARCHAR2 ,
p_CC_REQUEST_SEQUENCE_ID IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row' ;
DELETE from wsh_cc_request_setups
WHERE cc_request_sequence_id = p_cc_request_sequence_id ;
FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
End Delete_Row;
SELECT *
FROM wsh_cc_request_setups
WHERE rowid = p_rowid
FOR UPDATE OF CC_REQUEST_SEQUENCE_ID NOWAIT;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');