APPS.ASF_USER_PREFERENCE_PUB SQL Statements

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

Line: 53

       INSERT INTO ASF_USER_PREFERENCE(
          preference_id,
          user_id,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login,
          owner_table_name,
          owner_table_id,
          category,
          preference_code,
          preference_value,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15
          ) VALUES (
           ASF_USER_PREFERENCE_S.NEXTVAL,
           decode( l_user_preference_rec.user_id, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.user_id),

           decode( l_user_preference_rec.created_by, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.created_by),
           decode( l_user_preference_rec.creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), l_user_preference_rec.creation_date),
           decode( l_user_preference_rec.last_updated_by, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.last_updated_by),
           decode( l_user_preference_rec.last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), l_user_preference_rec.last_update_date),
           decode( l_user_preference_rec.last_update_login, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.last_update_login),

           decode( l_user_preference_rec.owner_table_name, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.owner_table_name),
           decode( l_user_preference_rec.owner_table_id, FND_API.G_MISS_NUM, NULL, l_user_preference_rec.owner_table_id),
           decode( l_user_preference_rec.category, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.category),
           decode( l_user_preference_rec.preference_code, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.preference_code),
           decode( l_user_preference_rec.preference_value, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.preference_value),
           decode( l_user_preference_rec.attribute_category, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute_category),
           decode( l_user_preference_rec.attribute1, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute1),
           decode( l_user_preference_rec.attribute2, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute2),
           decode( l_user_preference_rec.attribute3, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute3),
           decode( l_user_preference_rec.attribute4, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute4),
           decode( l_user_preference_rec.attribute5, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute5),
           decode( l_user_preference_rec.attribute6, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute6),
           decode( l_user_preference_rec.attribute7, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute7),
           decode( l_user_preference_rec.attribute8, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute8),
           decode( l_user_preference_rec.attribute9, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute9),
           decode( l_user_preference_rec.attribute10, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute10),
           decode( l_user_preference_rec.attribute11, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute11),
           decode( l_user_preference_rec.attribute12, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute12),
           decode( l_user_preference_rec.attribute13, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute13),
           decode( l_user_preference_rec.attribute14, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute14),
           decode( l_user_preference_rec.attribute15, FND_API.G_MISS_CHAR, NULL, l_user_preference_rec.attribute15)
           );

Line: 192

PROCEDURE UPDATE_PREFERENCE(
    p_user_preference_rec           IN    USER_PREFERENCE_REC_TYPE := G_MISS_USER_PREFERENCE_REC,
    x_return_status                OUT NOCOPY    VARCHAR2,
    x_msg_count	                   OUT NOCOPY    NUMBER,
    x_msg_data	                   OUT NOCOPY    VARCHAR2)
IS
l_debug BOOLEAN;

Line: 199

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

Line: 206

      SAVEPOINT UPDATE_PREFERENCE_PUB;

Line: 236

             SELECT preference_id
             INTO l_preference_id
             FROM  ASF_USER_PREFERENCE
             WHERE USER_ID = l_user_preference_rec.user_id
               AND OWNER_TABLE_NAME = G_OWNER_TABLE_NAME
               AND PREFERENCE_CODE = l_user_preference_rec.preference_code
               AND OWNER_TABLE_ID= l_user_preference_rec.owner_table_id;

Line: 269

                UPDATE ASF_USER_PREFERENCE
                SET
                  last_updated_by = decode( l_user_preference_rec.last_updated_by, FND_API.G_MISS_NUM, last_updated_by, l_user_preference_rec.last_updated_by),
                  last_update_date = decode( l_user_preference_rec.last_update_date, FND_API.G_MISS_DATE, SYSDATE, l_user_preference_rec.last_update_date),
                  last_update_login = decode( l_user_preference_rec.last_update_login, FND_API.G_MISS_NUM, last_update_login, l_user_preference_rec.last_update_login),
                  category = decode( l_user_preference_rec.category, FND_API.G_MISS_CHAR, category, l_user_preference_rec.category),
                  preference_code = decode( l_user_preference_rec.preference_code, FND_API.G_MISS_CHAR, preference_code, l_user_preference_rec.preference_code),
                  preference_value = decode( l_user_preference_rec.preference_value, FND_API.G_MISS_CHAR, preference_value, l_user_preference_rec.preference_value),
                  attribute_category = decode( l_user_preference_rec.attribute_category, FND_API.G_MISS_CHAR, attribute_category, l_user_preference_rec.attribute_category),
                  attribute1 = decode( l_user_preference_rec.attribute1, FND_API.G_MISS_CHAR, attribute1, l_user_preference_rec.attribute1),
                  attribute2 = decode( l_user_preference_rec.attribute2, FND_API.G_MISS_CHAR, attribute2, l_user_preference_rec.attribute2),
                  attribute3 = decode( l_user_preference_rec.attribute3, FND_API.G_MISS_CHAR, attribute3, l_user_preference_rec.attribute3),
                  attribute4 = decode( l_user_preference_rec.attribute4, FND_API.G_MISS_CHAR, attribute4, l_user_preference_rec.attribute4),
                  attribute5 = decode( l_user_preference_rec.attribute5, FND_API.G_MISS_CHAR, attribute5, l_user_preference_rec.attribute5),
                  attribute6 = decode( l_user_preference_rec.attribute6, FND_API.G_MISS_CHAR, attribute6, l_user_preference_rec.attribute6),
                  attribute7 = decode( l_user_preference_rec.attribute7, FND_API.G_MISS_CHAR, attribute7, l_user_preference_rec.attribute7),
                  attribute8 = decode( l_user_preference_rec.attribute8, FND_API.G_MISS_CHAR, attribute8, l_user_preference_rec.attribute8),
                  attribute9 = decode( l_user_preference_rec.attribute9, FND_API.G_MISS_CHAR, attribute9, l_user_preference_rec.attribute9),
                  attribute10 = decode( l_user_preference_rec.attribute10, FND_API.G_MISS_CHAR, attribute10, l_user_preference_rec.attribute10),
                  attribute11 = decode( l_user_preference_rec.attribute11, FND_API.G_MISS_CHAR, attribute11, l_user_preference_rec.attribute11),
                  attribute12 = decode( l_user_preference_rec.attribute12, FND_API.G_MISS_CHAR, attribute12, l_user_preference_rec.attribute12),
                  attribute13 = decode( l_user_preference_rec.attribute13, FND_API.G_MISS_CHAR, attribute13, l_user_preference_rec.attribute13),
                  attribute14 = decode( l_user_preference_rec.attribute14, FND_API.G_MISS_CHAR, attribute14, l_user_preference_rec.attribute14),
                  attribute15 = decode( l_user_preference_rec.attribute15, FND_API.G_MISS_CHAR, attribute15, l_user_preference_rec.attribute15)
                WHERE PREFERENCE_ID = l_preference_id;

Line: 308

        UPDATE ASF_USER_PREFERENCE
           SET
              last_updated_by = decode( l_user_preference_rec.last_updated_by, FND_API.G_MISS_NUM, last_updated_by, l_user_preference_rec.last_updated_by),
              last_update_date = decode( l_user_preference_rec.last_update_date, FND_API.G_MISS_DATE, SYSDATE, l_user_preference_rec.last_update_date),
              last_update_login = decode( l_user_preference_rec.last_update_login, FND_API.G_MISS_NUM, last_update_login, l_user_preference_rec.last_update_login),
              category = decode( l_user_preference_rec.category, FND_API.G_MISS_CHAR, category, l_user_preference_rec.category),
              preference_code = decode( l_user_preference_rec.preference_code, FND_API.G_MISS_CHAR, preference_code, l_user_preference_rec.preference_code),
              preference_value = decode( l_user_preference_rec.preference_value, FND_API.G_MISS_CHAR, preference_value, l_user_preference_rec.preference_value),
              attribute_category = decode( l_user_preference_rec.attribute_category, FND_API.G_MISS_CHAR, attribute_category, l_user_preference_rec.attribute_category),
              attribute1 = decode( l_user_preference_rec.attribute1, FND_API.G_MISS_CHAR, attribute1, l_user_preference_rec.attribute1),
              attribute2 = decode( l_user_preference_rec.attribute2, FND_API.G_MISS_CHAR, attribute2, l_user_preference_rec.attribute2),
              attribute3 = decode( l_user_preference_rec.attribute3, FND_API.G_MISS_CHAR, attribute3, l_user_preference_rec.attribute3),
              attribute4 = decode( l_user_preference_rec.attribute4, FND_API.G_MISS_CHAR, attribute4, l_user_preference_rec.attribute4),
              attribute5 = decode( l_user_preference_rec.attribute5, FND_API.G_MISS_CHAR, attribute5, l_user_preference_rec.attribute5),
              attribute6 = decode( l_user_preference_rec.attribute6, FND_API.G_MISS_CHAR, attribute6, l_user_preference_rec.attribute6),
              attribute7 = decode( l_user_preference_rec.attribute7, FND_API.G_MISS_CHAR, attribute7, l_user_preference_rec.attribute7),
              attribute8 = decode( l_user_preference_rec.attribute8, FND_API.G_MISS_CHAR, attribute8, l_user_preference_rec.attribute8),
              attribute9 = decode( l_user_preference_rec.attribute9, FND_API.G_MISS_CHAR, attribute9, l_user_preference_rec.attribute9),
              attribute10 = decode( l_user_preference_rec.attribute10, FND_API.G_MISS_CHAR, attribute10, l_user_preference_rec.attribute10),
              attribute11 = decode( l_user_preference_rec.attribute11, FND_API.G_MISS_CHAR, attribute11, l_user_preference_rec.attribute11),
              attribute12 = decode( l_user_preference_rec.attribute12, FND_API.G_MISS_CHAR, attribute12, l_user_preference_rec.attribute12),
              attribute13 = decode( l_user_preference_rec.attribute13, FND_API.G_MISS_CHAR, attribute13, l_user_preference_rec.attribute13),
              attribute14 = decode( l_user_preference_rec.attribute14, FND_API.G_MISS_CHAR, attribute14, l_user_preference_rec.attribute14),
              attribute15 = decode( l_user_preference_rec.attribute15, FND_API.G_MISS_CHAR, attribute15, l_user_preference_rec.attribute15)
           WHERE PREFERENCE_ID = l_user_preference_rec.preference_id;

Line: 403

END UPDATE_PREFERENCE;

Line: 404

PROCEDURE DELETE_PREFERENCE(
    p_user_preference_rec           IN    USER_PREFERENCE_REC_TYPE := G_MISS_USER_PREFERENCE_REC,
    x_return_status                OUT NOCOPY    VARCHAR2,
    x_msg_count	                   OUT NOCOPY    NUMBER,
    x_msg_data	                   OUT NOCOPY    VARCHAR2)
IS
l_debug BOOLEAN;

Line: 411

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

Line: 417

      SAVEPOINT DELETE_PREFERENCE_PUB;

Line: 446

             SELECT preference_id
             INTO l_preference_id
             FROM  ASF_USER_PREFERENCE
             WHERE USER_ID = l_user_preference_rec.user_id
               AND OWNER_TABLE_NAME = G_OWNER_TABLE_NAME
               AND PREFERENCE_CODE = l_user_preference_rec.preference_code
               AND OWNER_TABLE_ID= l_user_preference_rec.owner_table_id;

Line: 461

                DELETE FROM ASF_USER_PREFERENCE
                WHERE PREFERENCE_ID = l_preference_id;

Line: 471

                DELETE FROM ASF_USER_PREFERENCE
                WHERE PREFERENCE_ID = l_user_preference_rec.preference_id;

Line: 537

END DELETE_PREFERENCE;