APPS.CSI_SOURCE_IB_TYPES_PKG SQL Statements

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

Line: 14

PROCEDURE Insert_Row(
          p_TRANSACTION_TYPE_ID    NUMBER,
          px_SUB_TYPE_ID   IN OUT NOCOPY NUMBER,
          p_DEFAULT_FLAG    VARCHAR2,
          p_UPDATE_IB_FLAG    VARCHAR2)

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

Line: 28

   INSERT INTO CSI_SOURCE_IB_TYPES(
           TRANSACTION_TYPE_ID,
           SUB_TYPE_ID,
           DEFAULT_FLAG,
           UPDATE_IB_FLAG
          ) VALUES (
           decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_TYPE_ID),
           px_SUB_TYPE_ID,
           decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
           decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG));

Line: 38

End Insert_Row;

Line: 40

PROCEDURE Update_Row(
          p_TRANSACTION_TYPE_ID    NUMBER,
          p_SUB_TYPE_ID    NUMBER,
          p_DEFAULT_FLAG    VARCHAR2,
          p_UPDATE_IB_FLAG    VARCHAR2)

 IS
 BEGIN
    Update CSI_SOURCE_IB_TYPES
    SET
              SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
              DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
              UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG)
    where SUB_TYPE_ID = p_SUB_TYPE_ID;

Line: 58

END Update_Row;

Line: 60

PROCEDURE Delete_Row(
    p_SUB_TYPE_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM CSI_SOURCE_IB_TYPES
    WHERE SUB_TYPE_ID = p_SUB_TYPE_ID;

Line: 69

 END Delete_Row;

Line: 75

          p_UPDATE_IB_FLAG    VARCHAR2)

 IS
   CURSOR C IS
        SELECT *
         FROM CSI_SOURCE_IB_TYPES
        WHERE SUB_TYPE_ID =  p_SUB_TYPE_ID
        FOR UPDATE of SUB_TYPE_ID NOWAIT;

Line: 89

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

Line: 101

       AND (    ( Recinfo.UPDATE_IB_FLAG = p_UPDATE_IB_FLAG)
            OR (    ( Recinfo.UPDATE_IB_FLAG IS NULL )
                AND (  p_UPDATE_IB_FLAG IS NULL )))
       ) then
       return;