APPS.AML_SALES_LEAD_TIMEFRAMES_PKG SQL Statements

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

Line: 19

PROCEDURE Insert_Row(
          px_TIMEFRAME_ID   IN OUT NOCOPY NUMBER
         ,p_DECISION_TIMEFRAME_CODE    VARCHAR2
         ,p_TIMEFRAME_DAYS    NUMBER
         ,p_CREATION_DATE in DATE
  	 ,p_CREATED_BY in NUMBER
  	 ,p_LAST_UPDATE_DATE in DATE
  	 ,p_LAST_UPDATED_BY in NUMBER
  	 ,p_LAST_UPDATE_LOGIN in NUMBER
  	 ,p_ENABLED_FLAG in VARCHAR2)

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

Line: 38

   INSERT INTO AML_SALES_LEAD_TIMEFRAMES(
           TIMEFRAME_ID
          ,DECISION_TIMEFRAME_CODE
           ,TIMEFRAME_DAYS
           ,CREATION_DATE
	    ,CREATED_BY
	    ,LAST_UPDATE_DATE
	    ,LAST_UPDATED_BY
    	    ,LAST_UPDATE_LOGIN
    	    , ENABLED_FLAG
          ) VALUES (
           px_TIMEFRAME_ID
          ,decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE)
          ,decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, NULL, p_TIMEFRAME_DAYS)
          , 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_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_enabled_flag, FND_API.G_MISS_CHAR, 'N', p_enabled_flag));

Line: 59

End Insert_Row;

Line: 61

PROCEDURE Update_Row(
          p_TIMEFRAME_ID    NUMBER
         ,p_DECISION_TIMEFRAME_CODE    VARCHAR2
         ,p_TIMEFRAME_DAYS    NUMBER
         ,p_CREATION_DATE in DATE
  	 ,p_CREATED_BY in NUMBER
  	 ,p_LAST_UPDATE_DATE in DATE
  	 ,p_LAST_UPDATED_BY in NUMBER
  	 ,p_LAST_UPDATE_LOGIN in NUMBER
  	 ,p_ENABLED_FLAG in VARCHAR2)

IS
BEGIN
    Update AML_SALES_LEAD_TIMEFRAMES
    SET
        DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE)
       ,TIMEFRAME_DAYS = decode( p_TIMEFRAME_DAYS, FND_API.G_MISS_NUM, TIMEFRAME_DAYS, p_TIMEFRAME_DAYS)
       , 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)
       , 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)
	, enabled_flag = DECODE(p_enabled_flag,FND_API.G_MISS_CHAR,ENABLED_FLAG, p_enabled_flag)


    where TIMEFRAME_ID = p_TIMEFRAME_ID;

Line: 91

END Update_Row;

Line: 93

PROCEDURE Delete_Row(
    p_TIMEFRAME_ID  NUMBER)
IS
BEGIN
    DELETE FROM AML_SALES_LEAD_TIMEFRAMES
    WHERE TIMEFRAME_ID = p_TIMEFRAME_ID;

Line: 102

END Delete_Row;

Line: 110

  	 ,p_LAST_UPDATE_DATE in DATE
  	 ,p_LAST_UPDATED_BY in NUMBER
  	 ,p_LAST_UPDATE_LOGIN in NUMBER
  	 ,p_ENABLED_FLAG in VARCHAR2)

 IS
   CURSOR C IS
       SELECT *
       FROM AML_SALES_LEAD_TIMEFRAMES
       WHERE TIMEFRAME_ID =  p_TIMEFRAME_ID
       FOR UPDATE of TIMEFRAME_ID NOWAIT;

Line: 127

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

Line: 145

	  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.last_update_login = p_last_update_login)
	    OR ((Recinfo.last_update_login IS NULL)
		AND ( p_last_update_login IS NULL)))
	  AND           ((Recinfo.enabled_flag = p_enabled_flag)
	    OR ((Recinfo.enabled_flag IS NULL)
		AND ( p_enabled_flag IS NULL)))

        ) then
        return;

Line: 178

    CURSOR c_get_last_updated (c_rank_id NUMBER) IS
        SELECT last_updated_by
        FROM AML_SALES_LEAD_TIMEFRAMES
        WHERE timeframe_id = x_timeframe_id;

Line: 182

    l_last_updated_by  NUMBER;

Line: 189

    OPEN c_get_last_updated (x_TIMEFRAME_ID);

Line: 190

    FETCH c_get_last_updated INTO l_last_updated_by;

Line: 191

    CLOSE c_get_last_updated;

Line: 193

    IF nvl(l_last_updated_by, 1) = 1
    THEN
        if (X_OWNER = 'SEED') then
            user_id := 1;

Line: 199

        Update_Row(p_TIMEFRAME_ID            => x_TIMEFRAME_ID,
                   p_DECISION_TIMEFRAME_CODE          => x_DECISION_TIMEFRAME_CODE,
                   p_TIMEFRAME_DAYS          => x_TIMEFRAME_DAYS,
                   p_CREATION_DATE      =>  FND_API.G_MISS_DATE,
                   p_CREATED_BY          => FND_API.G_MISS_NUM,
                   p_LAST_UPDATE_DATE   => sysdate,
                   p_LAST_UPDATED_BY    => user_id,
                   p_LAST_UPDATE_LOGIN  => 0,
                   p_ENABLED_FLAG	=> x_ENABLED_FLAG
                   );

Line: 216

            Insert_Row(px_TIMEFRAME_ID            => x_TIMEFRAME_ID,
                       p_DECISION_TIMEFRAME_CODE          => x_DECISION_TIMEFRAME_CODE,
                       p_TIMEFRAME_DAYS          => x_TIMEFRAME_DAYS,
                       p_creation_date      => sysdate,
                       p_created_by         => 0,
                       p_LAST_UPDATE_DATE   => sysdate,
                       p_LAST_UPDATED_BY    => user_id,
                       p_LAST_UPDATE_LOGIN  => 0,
                       p_ENABLED_FLAG	    => x_ENABLED_FLAG
                       );