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.WSH_CC_REQUEST_SETUPS_PKG SQL Statements

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

Line: 7


 /* 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;

Line: 44


 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 ;

Line: 72


   l_api_name        CONSTANT VARCHAR2(30)      := 'Insert_Row';

Line: 96


  select wsh_cc_request_setups_s.nextval into l_CC_Request_Sequence_ID from dual;

Line: 100


    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
    ) ;

Line: 149


     FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');

Line: 199


End Insert_Row;

Line: 201


 /* 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;

Line: 239


 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'  ;

Line: 292


 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 ;

Line: 317


     FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');

Line: 371


End Update_Row;

Line: 373


 /* 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;

Line: 412


 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'  ;

Line: 449


 DELETE from wsh_cc_request_setups
 WHERE cc_request_sequence_id = p_cc_request_sequence_id ;

Line: 452


     FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

Line: 506


End Delete_Row;

Line: 575


   SELECT *
   FROM wsh_cc_request_setups
   WHERE rowid = p_rowid
   FOR UPDATE OF CC_REQUEST_SEQUENCE_ID NOWAIT;

Line: 611


     FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');