eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACCOUNT_ALLOCATIONS_PKG SQL Statements

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

Line: 26


PROCEDURE Insert_Row(
          px_account_allocation_id   IN OUT NOCOPY NUMBER,
          p_allocation_for                         VARCHAR2,
          p_allocation_for_id                      NUMBER,
          p_cust_account_id                        NUMBER,
          p_site_use_id                            NUMBER,
          p_site_use_code                          VARCHAR2,
          p_location_id                            NUMBER,
          p_bill_to_site_use_id                    NUMBER,
          p_bill_to_location_id                    NUMBER,
          p_parent_party_id                        NUMBER,
          p_rollup_party_id                        NUMBER,
          p_selected_flag                          VARCHAR2,
          p_target                                 NUMBER,
          p_lysp_sales                             NUMBER,
          p_parent_account_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: 73


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

Line: 80


   INSERT INTO ozf_account_allocations(
           account_allocation_id,
           allocation_for,
           allocation_for_id,
           cust_account_id,
           site_use_id,
           site_use_code,
           location_id,
           bill_to_site_use_id,
           bill_to_location_id,
           parent_party_id,
           rollup_party_id,
           selected_flag,
           target,
           lysp_sales,
           parent_account_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_account_allocation_id, FND_API.G_MISS_NUM, NULL, px_account_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_cust_account_id, FND_API.G_MISS_NUM, NULL, p_cust_account_id),
           DECODE( p_site_use_id, FND_API.G_MISS_NUM, NULL, p_site_use_id),
           DECODE( p_site_use_code, FND_API.g_miss_char, NULL, p_site_use_code),
           DECODE( p_location_id, FND_API.G_MISS_NUM, NULL, p_location_id),
           DECODE( p_bill_to_site_use_id, FND_API.G_MISS_NUM, NULL, p_bill_to_site_use_id),
           DECODE( p_bill_to_location_id, FND_API.G_MISS_NUM, NULL, p_bill_to_location_id),
           DECODE( p_parent_party_id, FND_API.G_MISS_NUM, NULL, p_parent_party_id),
           DECODE( p_rollup_party_id, FND_API.G_MISS_NUM, NULL, p_rollup_party_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_account_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_account_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: 162


END Insert_Row;

Line: 179


PROCEDURE Update_Row(
          p_account_allocation_id                  NUMBER,
          p_allocation_for                         VARCHAR2,
          p_allocation_for_id                      NUMBER,
          p_cust_account_id                        NUMBER,
          p_site_use_id                            NUMBER,
          p_site_use_code                          VARCHAR2,
          p_location_id                            NUMBER,
          p_bill_to_site_use_id                    NUMBER,
          p_bill_to_location_id                    NUMBER,
          p_parent_party_id                        NUMBER,
          p_rollup_party_id                        NUMBER,
          p_selected_flag                          VARCHAR2,
          p_target                                 NUMBER,
          p_lysp_sales                             NUMBER,
          p_parent_account_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_account_allocations
    SET
              account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_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),
              cust_account_id = DECODE( p_cust_account_id, null, cust_account_id, FND_API.G_MISS_NUM, null, p_cust_account_id),
              site_use_id = DECODE( p_site_use_id, null, site_use_id, FND_API.G_MISS_NUM, null, p_site_use_id),
              site_use_code = DECODE( p_site_use_code, null, site_use_code, FND_API.g_miss_char, null, p_site_use_code),
              location_id = DECODE( p_location_id, null, location_id, FND_API.G_MISS_NUM, null, p_location_id),
              bill_to_site_use_id = DECODE( p_bill_to_site_use_id, null, bill_to_site_use_id, FND_API.G_MISS_NUM, null, p_bill_to_site_use_id),
              bill_to_location_id = DECODE( p_bill_to_location_id, null, bill_to_location_id, FND_API.G_MISS_NUM, null, p_bill_to_location_id),
              parent_party_id = DECODE( p_parent_party_id, null, parent_party_id, FND_API.G_MISS_NUM, null, p_parent_party_id),
              rollup_party_id = DECODE( p_rollup_party_id, null, rollup_party_id, FND_API.G_MISS_NUM, null, p_rollup_party_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_account_allocation_id = DECODE(p_parent_account_allocation_id,null,parent_account_allocation_id, FND_API.G_MISS_NUM, null, p_parent_account_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 account_allocation_id = p_account_allocation_id;

Line: 264


END Update_Row;

Line: 281


PROCEDURE Delete_Row(
    p_account_allocation_id  NUMBER,
    p_object_version_number  NUMBER)
 IS
 BEGIN
   DELETE FROM ozf_account_allocations
    WHERE account_allocation_id = p_account_allocation_id
    AND object_version_number = p_object_version_number;

Line: 292


 END Delete_Row ;

Line: 315


        SELECT *
         FROM ozf_account_allocations
        WHERE account_allocation_id =  p_account_allocation_id
        AND object_version_number = p_object_version_number
        FOR UPDATE OF account_allocation_id NOWAIT;