APPS.OZF_PRODUCT_ALLOCATIONS_PKG SQL Statements

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

Line: 26

PROCEDURE Insert_Row(
          px_product_allocation_id   IN OUT NOCOPY NUMBER,
          p_allocation_for                         VARCHAR2,
          p_allocation_for_id                      NUMBER,
          p_fund_id                                NUMBER,
          p_item_type                              VARCHAR2,
          p_item_id                                NUMBER,
          p_selected_flag                          VARCHAR2,
          p_target                                 NUMBER,
          p_lysp_sales                             NUMBER,
          p_parent_product_allocation_id           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: 68

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

Line: 75

   INSERT INTO ozf_product_allocations(
           product_allocation_id,
           allocation_for,
           allocation_for_id,
           fund_id,
           item_type,
           item_id,
           selected_flag,
           target,
           lysp_sales,
           parent_product_allocation_id,
           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_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_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_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
           DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
           DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
           DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
           DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
           DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
           DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
           px_object_version_number,
           DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
           DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
           DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
           DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
           DECODE( p_last_update_login, FND_API.G_MISS_NUM, 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: 147

END Insert_Row;

Line: 164

PROCEDURE Update_Row(
          p_product_allocation_id                  NUMBER,
          p_allocation_for                         VARCHAR2,
          p_allocation_for_id                      NUMBER,
          p_fund_id                                NUMBER,
          p_item_type                              VARCHAR2,
          p_item_id                                NUMBER,
          p_selected_flag                          VARCHAR2,
          p_target                                 NUMBER,
          p_lysp_sales                             NUMBER,
          p_parent_product_allocation_id           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_product_allocations
    SET
              product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
              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),
              fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
              item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
              item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
              selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
              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),
              parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
              object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
              last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
              last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
              last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, 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 product_allocation_id = p_product_allocation_id;

Line: 239

END Update_Row;

Line: 256

PROCEDURE Delete_Row(
    p_product_allocation_id  NUMBER,
    p_object_version_number  NUMBER)
 IS
 BEGIN
   DELETE FROM ozf_product_allocations
    WHERE product_allocation_id = p_product_allocation_id
    AND object_version_number = p_object_version_number;

Line: 267

 END Delete_Row ;

Line: 290

        SELECT *
         FROM ozf_product_allocations
        WHERE product_allocation_id =  p_product_allocation_id
        AND object_version_number = p_object_version_number
        FOR UPDATE OF product_allocation_id NOWAIT;