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_SERVICE_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_SERVICE_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 service 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_SERVICE_TYPE_CODE       IN VARCHAR2,
   p_SERVICE_VERSION         IN VARCHAR2 default null,
   p_SERVICE_HANDLER         IN VARCHAR2,
   p_SERVICE_DEFAULT_THRESHOLD  IN NUMBER default null,
   p_COUNTRY_MATCH_FLAG      IN VARCHAR2 default null,
   p_RED_FLAG                IN VARCHAR2 default null,
   p_SHIP_FROM_COUNTRY_SCHEME  IN VARCHAR2 default null,
   p_SHIP_FROM_COUNTRY_DOMAIN  IN VARCHAR2 default null,
   p_SHIP_TO_COUNTRY_SCHEME    IN VARCHAR2 default null,
   p_SHIP_TO_COUNTRY_DOMAIN    IN VARCHAR2 default null,
   p_CHARGE_SCHEME             IN VARCHAR2 default null,
   p_CHARGE_DOMAIN             IN VARCHAR2 default null,
   p_SERVICE_PRIORITY          IN NUMBER   default null,
   p_WF_ITEM_TYPE              IN VARCHAR2 default null,
   p_WF_ACTIVITY               IN VARCHAR2 default null,
   p_CC_SERVICE_SEQUENCE_ID  OUT  NUMBER
  )
IS
   l_CC_SERVICE_SEQUENCE_ID NUMBER ;

Line: 75


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

Line: 99


  select wsh_cc_service_setups_s.nextval into l_CC_Service_Sequence_ID from dual;

Line: 103


    INSERT INTO Wsh_cc_Service_Setups
    ( CC_SERVICE_SEQUENCE_ID
     ,APPLICATION_ID
     ,MASTER_ORGANIZATION_ID
     ,ORGANIZATION_ID
     ,APPLICATION_USER_ID
     ,SERVICE_TYPE_CODE
     ,SERVICE_VERSION
     ,SERVICE_HANDLER
     ,SERVICE_DEFAULT_THRESHOLD
     ,COUNTRY_MATCH_FLAG
     ,RED_FLAG
     ,SHIP_FROM_COUNTRY_SCHEME
     ,SHIP_FROM_COUNTRY_DOMAIN
     ,SHIP_TO_COUNTRY_SCHEME
     ,SHIP_TO_COUNTRY_DOMAIN
     ,CHARGE_SCHEME
     ,CHARGE_DOMAIN
     ,SERVICE_PRIORITY
     ,WF_ITEM_TYPE
     ,WF_ACTIVITY
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_LOGIN
     )
    values (
     l_CC_SERVICE_SEQUENCE_ID
    ,p_APPLICATION_ID
    ,p_MASTER_ORGANIZATION_ID
    ,p_ORGANIZATION_ID
    ,p_APPLICATION_USER_ID
    ,p_SERVICE_TYPE_CODE
    ,p_SERVICE_VERSION
    ,p_SERVICE_HANDLER
    ,p_SERVICE_DEFAULT_THRESHOLD
    ,p_COUNTRY_MATCH_FLAG
    ,p_RED_FLAG
    ,p_SHIP_FROM_COUNTRY_SCHEME
    ,p_SHIP_FROM_COUNTRY_DOMAIN
    ,p_SHIP_TO_COUNTRY_SCHEME
    ,p_SHIP_TO_COUNTRY_DOMAIN
    ,p_CHARGE_SCHEME
    ,p_CHARGE_DOMAIN
    ,p_SERVICE_PRIORITY
    ,p_WF_ITEM_TYPE
    ,p_WF_ACTIVITY
    ,sysdate
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.user_id
    ,FND_GLOBAL.login_id
    ) ;

Line: 158


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

Line: 208


End Insert_Row;

Line: 210


 /* Update_Row Procedure                                     */
 /*----------------------------------------------------------*/
 /*  --
   -- Purpose
   --  Update a row into WSH_CC_service_setups entity
   --  for the given cc service 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 service setups informations
   --
   --
   -- Output Parameters
   --   x_return_status
   --       if the process succeeds, the value is
   --           fnd_api.g_ret_sts_success;

Line: 248


 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_SERVICE_TYPE_CODE       IN VARCHAR2,
   p_SERVICE_VERSION         IN VARCHAR2 default null,
   p_SERVICE_HANDLER         IN VARCHAR2,
   p_SERVICE_DEFAULT_THRESHOLD  IN NUMBER,
   p_COUNTRY_MATCH_FLAG      IN VARCHAR2,
   p_RED_FLAG                IN VARCHAR2,
   p_SHIP_FROM_COUNTRY_SCHEME  IN VARCHAR2,
   p_SHIP_FROM_COUNTRY_DOMAIN  IN VARCHAR2,
   p_SHIP_TO_COUNTRY_SCHEME    IN VARCHAR2,
   p_SHIP_TO_COUNTRY_DOMAIN    IN VARCHAR2,
   p_CHARGE_SCHEME             IN VARCHAR2,
   p_CHARGE_DOMAIN             IN VARCHAR2,
   p_SERVICE_PRIORITY          IN NUMBER,
   p_WF_ITEM_TYPE              IN VARCHAR2,
   p_WF_ACTIVITY               IN VARCHAR2,
   p_CC_SERVICE_SEQUENCE_ID  IN  NUMBER
  )
IS
   l_api_name        CONSTANT VARCHAR2(30) := 'Update_Row'  ;

Line: 304


 update wsh_cc_service_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)
 ,SERVICE_TYPE_CODE = p_SERVICE_TYPE_CODE
 ,SERVICE_VERSION =   p_SERVICE_VERSION
 ,SERVICE_HANDLER =  p_SERVICE_HANDLER
 ,SERVICE_DEFAULT_THRESHOLD = p_SERVICE_DEFAULT_THRESHOLD
 ,COUNTRY_MATCH_FLAG = p_COUNTRY_MATCH_FLAG
 ,RED_FLAG = p_RED_FLAG
 ,SHIP_FROM_COUNTRY_SCHEME = p_SHIP_FROM_COUNTRY_SCHEME
 ,SHIP_FROM_COUNTRY_DOMAIN = p_SHIP_FROM_COUNTRY_DOMAIN
 ,SHIP_TO_COUNTRY_SCHEME = p_SHIP_TO_COUNTRY_SCHEME
 ,SHIP_TO_COUNTRY_DOMAIN = p_SHIP_TO_COUNTRY_DOMAIN
 ,CHARGE_SCHEME = p_CHARGE_SCHEME
 ,CHARGE_DOMAIN =  p_CHARGE_DOMAIN
 ,SERVICE_PRIORITY = p_SERVICE_PRIORITY
 ,WF_ITEM_TYPE = p_WF_ITEM_TYPE
 ,WF_ACTIVITY = p_WF_ACTIVITY
 ,LAST_UPDATE_DATE         = sysdate
 ,LAST_UPDATED_BY          = FND_GLOBAL.user_id
 ,LAST_UPDATE_LOGIN        = FND_GLOBAL.login_id
  where cc_service_sequence_id = p_cc_service_sequence_id ;

Line: 332


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

Line: 386


End Update_Row;

Line: 388


 /* Delete_Row Procedure                                     */
 /*----------------------------------------------------------*/
 /*  --
   -- Purpose
   --  Delete a row from WSH_CC_Service_Setups entity
   --  for the given  service 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_SERVICE_SEQUENCE_ID  -- CC Service Seq Id
   --
   --
   -- Output Parameters
   --   x_return_status
   --       if the process succeeds, the value is
   --           fnd_api.g_ret_sts_success;

Line: 427


 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_SERVICE_SEQUENCE_ID     IN  NUMBER
  )
IS
   l_api_name        CONSTANT VARCHAR2(30) := 'Delete_Row'  ;

Line: 464


 DELETE from wsh_cc_service_setups
 WHERE cc_service_sequence_id = p_cc_service_sequence_id ;

Line: 467


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

Line: 521


End Delete_Row;

Line: 593


   SELECT *
   FROM wsh_cc_service_setups
   WHERE rowid = p_rowid
   FOR UPDATE OF CC_SERVICE_SEQUENCE_ID NOWAIT;

Line: 629


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