APPS.CSP_USG_TRANSACTION_TYPES_PKG SQL Statements

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

Line: 14

PROCEDURE Insert_Row(
          px_USG_TRANSACTION_TYPE_ID IN OUT NOCOPY NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
	 ,p_FORECAST_RULE_ID NUMBER
	 ,p_TRANSACTION_TYPE_ID NUMBER)
 IS
   CURSOR C2 IS SELECT CSP_USG_TRANSACTION_TYPES_S1.nextval FROM sys.dual;

Line: 31

   INSERT INTO CSP_USG_TRANSACTION_TYPES(
           USG_TRANSACTION_TYPE_ID
          ,LAST_UPDATE_DATE
          ,LAST_UPDATED_BY
          ,CREATION_DATE
          ,CREATED_BY
          ,LAST_UPDATE_LOGIN
	  ,FORECAST_RULE_ID
	  ,TRANSACTION_TYPE_ID
          ) VALUES (
           px_USG_TRANSACTION_TYPE_ID
          ,p_LAST_UPDATE_DATE
          ,p_LAST_UPDATED_BY
          ,p_CREATION_DATE
          ,p_CREATED_BY
          ,p_LAST_UPDATE_LOGIN
	  ,p_FORECAST_RULE_ID
	  ,p_TRANSACTION_TYPE_ID);

Line: 49

END Insert_Row;

Line: 51

Procedure Update_Row(
	  p_USG_TRANSACTION_TYPE_ID NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
	 ,p_FORECAST_RULE_ID NUMBER
	 ,p_TRANSACTION_TYPE_ID NUMBER)
IS
BEGIN
    Update CSP_USG_TRANSACTION_TYPES
    SET
        LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
       ,LAST_UPDATED_BY = p_LAST_UPDATED_BY
       ,CREATION_DATE = p_CREATION_DATE
       ,CREATED_BY =  p_CREATED_BY
       ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
       ,FORECAST_RULE_ID = p_FORECAST_RULE_ID
       ,TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID
    where USG_TRANSACTION_TYPE_ID = p_USG_TRANSACTION_TYPE_ID;

Line: 76

END Update_Row;

Line: 78

PROCEDURE Delete_Row(
    p_USG_TRANSACTION_TYPE_ID  NUMBER)
IS
BEGIN
    DELETE FROM CSP_USG_TRANSACTION_TYPES
    WHERE USG_TRANSACTION_TYPE_ID = p_USG_TRANSACTION_TYPE_ID;

Line: 87

END Delete_Row;

Line: 91

         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_CREATED_BY    NUMBER
         ,p_LAST_UPDATE_LOGIN    NUMBER
	 ,p_FORECAST_RULE_ID NUMBER
	 ,p_TRANSACTION_TYPE_ID NUMBER)
IS
   CURSOR C IS
       SELECT *
       FROM CSP_USG_TRANSACTION_TYPES
       WHERE USG_TRANSACTION_TYPE_ID =  p_USG_TRANSACTION_TYPE_ID
       FOR UPDATE of USG_TRANSACTION_TYPE_ID NOWAIT;

Line: 110

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

Line: 116

       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.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY 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_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.FORECAST_RULE_ID = p_FORECAST_RULE_ID)
            OR (    ( Recinfo.FORECAST_RULE_ID IS NULL )
                AND (  p_FORECAST_RULE_ID IS NULL )))
       AND (    ( Recinfo.TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID)
            OR (    ( Recinfo.TRANSACTION_TYPE_ID IS NULL )
                AND (  p_TRANSACTION_TYPE_ID IS NULL )))
        ) then
        return;