APPS.OZF_TIME_ALLOCATIONS_PKG SQL Statements

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

Line: 25

PROCEDURE Insert_Row(
          px_time_allocation_id    IN OUT NOCOPY NUMBER,
          p_allocation_for                       VARCHAR2,
          p_allocation_for_id                    NUMBER,
          p_time_id                              NUMBER,
          p_period_type_id                       NUMBER,
          p_target                               NUMBER,
          p_lysp_sales                           NUMBER,
          px_object_version_number IN OUT NOCOPY NUMBER,
          p_creation_date                        DATE,
          p_created_by                           NUMBER,
          p_last_update_date                     DATE,
          p_last_updated_by                      NUMBER,
          p_last_update_login                    NUMBER,
          p_attribute_category                   VARCHAR2,
          p_attribute1                           VARCHAR2,
          p_attribute2                           VARCHAR2,
          p_attribute3                           VARCHAR2,
          p_attribute4                           VARCHAR2,
          p_attribute5                           VARCHAR2,
          p_attribute6                           VARCHAR2,
          p_attribute7                           VARCHAR2,
          p_attribute8                           VARCHAR2,
          p_attribute9                           VARCHAR2,
          p_attribute10                          VARCHAR2,
          p_attribute11                          VARCHAR2,
          p_attribute12                          VARCHAR2,
          p_attribute13                          VARCHAR2,
          p_attribute14                          VARCHAR2,
          p_attribute15                          VARCHAR2,
          px_org_id                IN OUT NOCOPY NUMBER
          )
 IS
   x_rowid    VARCHAR2(30);

Line: 66

       SELECT NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
       INTO px_org_id
       FROM DUAL;

Line: 74

   INSERT INTO ozf_time_allocations(
           time_allocation_id,
           allocation_for,
           allocation_for_id,
           time_id,
           period_type_id,
           target,
           lysp_sales,
           object_version_number,
           creation_date,
           created_by,
           last_update_date,
           last_updated_by,
           last_update_login,
           attribute_category,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15,
           org_id)
    VALUES
         (
           DECODE( px_time_allocation_id, FND_API.G_MISS_NUM, NULL, px_time_allocation_id),
           DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
           DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
           DECODE( p_time_id, FND_API.G_MISS_NUM, NULL, p_time_id),
           DECODE( p_period_type_id, FND_API.G_MISS_NUM, NULL, p_period_type_id),
           DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
           DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
           px_object_version_number,
           DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
           DECODE( p_created_by, null, FND_GLOBAL.USER_ID, p_created_by),
           DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
           DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
           DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
           DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
           DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
           DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
           DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
           DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
           DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
           DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
           DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
           DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
           DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
           DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
           DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
           DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
           DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
           DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
           DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
           px_org_id
         );

Line: 139

END Insert_Row;

Line: 156

PROCEDURE Update_Row(
          p_time_allocation_id         NUMBER,
          p_allocation_for             VARCHAR2,
          p_allocation_for_id          NUMBER,
          p_time_id                    NUMBER,
          p_period_type_id             NUMBER,
          p_target                     NUMBER,
          p_lysp_sales                 NUMBER,
          p_object_version_number   IN NUMBER,
          p_last_update_date           DATE,
          p_last_updated_by            NUMBER,
          p_last_update_login          NUMBER,
          p_attribute_category         VARCHAR2,
          p_attribute1                 VARCHAR2,
          p_attribute2                 VARCHAR2,
          p_attribute3                 VARCHAR2,
          p_attribute4                 VARCHAR2,
          p_attribute5                 VARCHAR2,
          p_attribute6                 VARCHAR2,
          p_attribute7                 VARCHAR2,
          p_attribute8                 VARCHAR2,
          p_attribute9                 VARCHAR2,
          p_attribute10                VARCHAR2,
          p_attribute11                VARCHAR2,
          p_attribute12                VARCHAR2,
          p_attribute13                VARCHAR2,
          p_attribute14                VARCHAR2,
          p_attribute15                VARCHAR2
          )
 IS
 BEGIN
    Update ozf_time_allocations
    SET
              allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
              allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
              time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),
              period_type_id = DECODE( p_period_type_id, null, period_type_id, FND_API.G_MISS_NUM, null, p_period_type_id),
              target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
              lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
              object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
              last_update_date = DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
              last_updated_by = DECODE( p_last_updated_by, null, FND_GLOBAL.USER_ID, p_last_updated_by),
              last_update_login = DECODE( p_last_update_login, null, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
              attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
              attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
              attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
              attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
              attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
              attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
              attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
              attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
              attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
              attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
              attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
              attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
              attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
              attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
              attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
              attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
   WHERE time_allocation_id = p_time_allocation_id;

Line: 224

END Update_Row;

Line: 241

PROCEDURE Delete_Row(
    p_time_allocation_id  NUMBER,
    p_object_version_number  NUMBER)
 IS
 BEGIN
   DELETE FROM ozf_time_allocations
    WHERE time_allocation_id = p_time_allocation_id
    AND object_version_number = p_object_version_number;

Line: 252

 END Delete_Row ;

Line: 275

        SELECT *
         FROM ozf_time_allocations
        WHERE time_allocation_id =  p_time_allocation_id
        AND object_version_number = p_object_version_number
        FOR UPDATE OF time_allocation_id NOWAIT;