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

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

Line: 16


PROCEDURE Insert_Row(
          px_STRATEGY_USER_ITEM_ID   IN OUT NOCOPY NUMBER
         ,p_STRATEGY_ID    NUMBER
         ,p_WORK_ITEM_TEMP_ID    NUMBER
         ,p_WORK_ITEM_ORDER    NUMBER
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_PROGRAM_ID    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER
         ,p_REQUEST_ID    NUMBER
         ,p_STRATEGY_TEMPLATE_ID    NUMBER
         ,p_PROGRAM_UPDATE_DATE    DATE
         ,p_PROGRAM_APPLICATION_ID    NUMBER
         ,p_OPERATION    VARCHAR2
	 ,p_pre_execution_wait NUMBER
	 ,p_post_execution_wait NUMBER
         ,p_pre_execution_time_uom VARCHAR2
	 ,p_execution_time_uom VARCHAR2
	 ,p_xdo_template_id NUMBER
	 ,p_optional_yn VARCHAR2
	 ,p_optional_wait_time NUMBER
	 ,p_optional_wait_time_uom VARCHAR2
	 ,p_notify_yn VARCHAR2
	 ,p_escalate_yn VARCHAR2
	 ,p_escalate_wait_time NUMBER
	 ,p_escalate_wait_time_uom VARCHAR2
	 ,p_resource_id NUMBER
	 ,p_custom_workflow_type VARCHAR2)

 IS
   CURSOR C2 IS SELECT IEX_STRATEGY_USER_ITEMS_S.nextval FROM sys.dual;

Line: 56


   INSERT INTO IEX_STRATEGY_USER_ITEMS(
           STRATEGY_USER_ITEM_ID
          ,STRATEGY_ID
          ,WORK_ITEM_TEMP_ID
          ,WORK_ITEM_ORDER
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_LOGIN
          ,CREATION_DATE
          ,CREATED_BY
          ,LAST_UPDATE_DATE
          ,PROGRAM_ID
          ,OBJECT_VERSION_NUMBER
          ,REQUEST_ID
          ,STRATEGY_TEMPLATE_ID
          ,PROGRAM_UPDATE_DATE
          , PROGRAM_APPLICATION_ID
          , OPERATION
	  , pre_execution_wait
	  , post_execution_wait
	  , pre_execution_time_uom
	  , execution_time_uom
	  , xdo_temp_id
	  , optional_yn
	  , optional_wait_time
	  , optional_wait_time_uom
	  , notify_yn
	  , escalate_yn
	  , escalate_wait_time
	  , escalate_wait_time_uom
	  , resource_id
	  , custom_workflow_type
          ) VALUES (
           px_STRATEGY_USER_ITEM_ID
          ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
          ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
          ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
          ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
          ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
          ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
          ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
          ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
          ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
          ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
          ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
          ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
          ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
          ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
          ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
	  ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
	  ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
	  ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
	  ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
	  ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
	  ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
	  ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
	  ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
	  ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
	  ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
	  ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
	  ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
	  ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
	  ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));

Line: 118


End Insert_Row;

Line: 120


PROCEDURE Update_Row(
          p_STRATEGY_USER_ITEM_ID    NUMBER
         ,p_STRATEGY_ID    NUMBER
         ,p_WORK_ITEM_TEMP_ID    NUMBER
         ,p_WORK_ITEM_ORDER    NUMBER
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
     --    ,p_CREATION_DATE    DATE
     --    ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_PROGRAM_ID    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER
         ,p_REQUEST_ID    NUMBER
         ,p_STRATEGY_TEMPLATE_ID    NUMBER
         ,p_PROGRAM_UPDATE_DATE    DATE
         ,p_PROGRAM_APPLICATION_ID    NUMBER
         ,p_OPERATION    VARCHAR2
	 ,p_pre_execution_wait NUMBER
	 ,p_post_execution_wait NUMBER
	 ,p_pre_execution_time_uom VARCHAR2
	 ,p_execution_time_uom VARCHAR2
	 ,p_xdo_template_id NUMBER
	 ,p_optional_yn VARCHAR2
	 ,p_optional_wait_time NUMBER
	 ,p_optional_wait_time_uom VARCHAR2
	 ,p_notify_yn VARCHAR2
	 ,p_escalate_yn VARCHAR2
	 ,p_escalate_wait_time NUMBER
	 ,p_escalate_wait_time_uom VARCHAR2
	 ,p_resource_id NUMBER
	 ,p_custom_workflow_type VARCHAR2)

IS
BEGIN
    Update IEX_STRATEGY_USER_ITEMS
    SET
        STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
       ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
       ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
       ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
       ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
     --  ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
    --   ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
       ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
       ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
       ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
       ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
       ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
       ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
       ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
       ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
       ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
       ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
       ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
       ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
       ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
       ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
       ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
       ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
       ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
       ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
       ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
       ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
       ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
       ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)
    where STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;

Line: 190


END Update_Row;

Line: 192


PROCEDURE Delete_Row(
    p_STRATEGY_USER_ITEM_ID  NUMBER)
IS
BEGIN
    DELETE FROM IEX_STRATEGY_USER_ITEMS
    WHERE STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;

Line: 201


END Delete_Row;

Line: 208


         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_PROGRAM_ID    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER
         ,p_REQUEST_ID    NUMBER
         ,p_STRATEGY_TEMPLATE_ID    NUMBER
         ,p_PROGRAM_UPDATE_DATE    DATE
         ,p_PROGRAM_APPLICATION_ID    NUMBER
         ,p_OPERATION    VARCHAR2
	 ,p_pre_execution_wait NUMBER
	 ,p_post_execution_wait NUMBER
	 ,p_pre_execution_time_uom VARCHAR2
	 ,p_execution_time_uom VARCHAR2
	 ,p_xdo_template_id NUMBER
	 ,p_optional_yn VARCHAR2
	 ,p_optional_wait_time NUMBER
	 ,p_optional_wait_time_uom VARCHAR2
	 ,p_notify_yn VARCHAR2
	 ,p_escalate_yn VARCHAR2
	 ,p_escalate_wait_time NUMBER
	 ,p_escalate_wait_time_uom VARCHAR2
	 ,p_resource_id NUMBER
	 ,p_custom_workflow_type VARCHAR2)

 IS
   CURSOR C IS
       SELECT *
       FROM IEX_STRATEGY_USER_ITEMS
       WHERE STRATEGY_USER_ITEM_ID =  p_STRATEGY_USER_ITEM_ID
       FOR UPDATE of STRATEGY_USER_ITEM_ID NOWAIT;

Line: 247


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

Line: 262


       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.CREATION_DATE = p_CREATION_DATE)
            OR (    ( Recinfo.CREATION_DATE IS NULL )
                AND (  p_CREATION_DATE IS NULL )))
       AND (    ( Recinfo.CREATED_BY = p_CREATED_BY)
            OR (    ( Recinfo.CREATED_BY IS NULL )
                AND (  p_CREATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
            OR (    ( Recinfo.PROGRAM_ID IS NULL )
                AND (  p_PROGRAM_ID IS NULL )))
       AND (    ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
            OR (    ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
                AND (  p_OBJECT_VERSION_NUMBER IS NULL )))
       AND (    ( Recinfo.REQUEST_ID = p_REQUEST_ID)
            OR (    ( Recinfo.REQUEST_ID IS NULL )
                AND (  p_REQUEST_ID IS NULL )))
       AND (    ( Recinfo.STRATEGY_TEMPLATE_ID = p_STRATEGY_TEMPLATE_ID)
            OR (    ( Recinfo.STRATEGY_TEMPLATE_ID IS NULL )
                AND (  p_STRATEGY_TEMPLATE_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
            OR (    ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
                AND (  p_PROGRAM_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
            OR (    ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
                AND (  p_PROGRAM_APPLICATION_ID IS NULL )))
       AND (    ( Recinfo.OPERATION = p_OPERATION)
            OR (    ( Recinfo.OPERATION IS NULL )
                AND (  p_OPERATION IS NULL )))
        ) then
        return;