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.

[Home] [Help]

APPS.AHL_WARRANTY_ENTITLEMENTS_PKG SQL Statements

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

Line: 4


PROCEDURE Insert_Row (
    x_row_id                   IN  OUT  NOCOPY  VARCHAR2,
    x_warranty_entitlement_id  IN               NUMBER,
    x_object_version_number    IN               NUMBER,
    x_warranty_contract_id     IN               NUMBER,
    x_old_warranty_contract_id IN               NUMBER,
    x_entitlement_status_code  IN               VARCHAR2,
    x_warranty_claim_id        IN               NUMBER,
    x_po_header_id             IN               NUMBER,
    x_sr_incident_id           IN               NUMBER,
    x_visit_task_id            IN               NUMBER,
    x_workorder_id             IN               NUMBER,
    x_osp_order_line_id        IN               NUMBER,
    x_warranty_labour_capture  IN               VARCHAR2,
    x_warranty_mtl_capture     IN               VARCHAR2,
    x_order_claim_amount       IN               NUMBER,
    x_attribute_category       IN               VARCHAR2,
    x_attribute1               IN               VARCHAR2,
    x_attribute2               IN               VARCHAR2,
    x_attribute3               IN               VARCHAR2,
    x_attribute4               IN               VARCHAR2,
    x_attribute5               IN               VARCHAR2,
    x_attribute6               IN               VARCHAR2,
    x_attribute7               IN               VARCHAR2,
    x_attribute8               IN               VARCHAR2,
    x_attribute9               IN               VARCHAR2,
    x_attribute10              IN               VARCHAR2,
    x_attribute11              IN               VARCHAR2,
    x_attribute12              IN               VARCHAR2,
    x_attribute13              IN               VARCHAR2,
    x_attribute14              IN               VARCHAR2,
    x_attribute15              IN               VARCHAR2,
    x_creation_date            IN               DATE,
    x_created_by               IN               NUMBER,
    x_last_update_date         IN               DATE,
    x_last_updated_by          IN               NUMBER,
    x_last_update_login        IN               NUMBER
) IS

CURSOR c IS
    SELECT ROWID
    FROM   ahl_warranty_entitlements
    WHERE  warranty_entitlement_id   = x_warranty_entitlement_id;

Line: 49


    INSERT INTO ahl_warranty_entitlements (
        warranty_entitlement_id,
        object_version_number,
        warranty_contract_id,
        old_warranty_contract_id,
        entitlement_status_code,
        warranty_claim_id,
        po_header_id,
        sr_incident_id,
        visit_task_id,
        workorder_id,
        osp_order_line_id,
        warranty_labour_capture,
        warranty_mtl_capture,
        order_claim_amount,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        creation_date,
        created_by,
        last_update_date,
        last_updated_by,
        last_update_login
    ) VALUES (
        x_warranty_entitlement_id,
        x_object_version_number,
        x_warranty_contract_id,
        x_old_warranty_contract_id,
        x_entitlement_status_code,
        x_warranty_claim_id,
        x_po_header_id,
        x_sr_incident_id,
        x_visit_task_id,
        x_workorder_id,
        x_osp_order_line_id,
        x_warranty_labour_capture,
        x_warranty_mtl_capture,
        x_order_claim_amount,
        x_attribute_category,
        x_attribute1,
        x_attribute2,
        x_attribute3,
        x_attribute4,
        x_attribute5,
        x_attribute6,
        x_attribute7,
        x_attribute8,
        x_attribute9,
        x_attribute10,
        x_attribute11,
        x_attribute12,
        x_attribute13,
        x_attribute14,
        x_attribute15,
        x_creation_date,
        x_created_by,
        x_last_update_date,
        x_last_updated_by,
        x_last_update_login
    );

Line: 131


END Insert_Row;

Line: 167


    SELECT        object_version_number,
                  warranty_contract_id,
                  old_warranty_contract_id,
                  entitlement_status_code,
                  warranty_claim_id,
                  po_header_id,
                  sr_incident_id,
                  visit_task_id,
                  workorder_id,
                  osp_order_line_id,
                  warranty_labour_capture,
                  warranty_mtl_capture,
                  order_claim_amount,
                  attribute_category,
                  attribute1,
                  attribute2,
                  attribute3,
                  attribute4,
                  attribute5,
                  attribute6,
                  attribute7,
                  attribute8,
                  attribute9,
                  attribute10,
                  attribute11,
                  attribute12,
                  attribute13,
                  attribute14,
                  attribute15
    FROM          ahl_warranty_entitlements
    WHERE         warranty_entitlement_id   = x_warranty_entitlement_id
    FOR UPDATE OF warranty_entitlement_id NOWAIT;

Line: 207


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

Line: 278


PROCEDURE Update_Row (
    x_warranty_entitlement_id  IN               NUMBER,
    x_object_version_number    IN               NUMBER,
    x_warranty_contract_id     IN               NUMBER,
    x_old_warranty_contract_id IN               NUMBER,
    x_entitlement_status_code  IN               VARCHAR2,
    x_warranty_claim_id        IN               NUMBER,
    x_po_header_id             IN               NUMBER,
    x_sr_incident_id           IN               NUMBER,
    x_visit_task_id            IN               NUMBER,
    x_workorder_id             IN               NUMBER,
    x_osp_order_line_id        IN               NUMBER,
    x_warranty_labour_capture  IN               VARCHAR2,
    x_warranty_mtl_capture     IN               VARCHAR2,
    x_order_claim_amount       IN               NUMBER,
    x_attribute_category       IN               VARCHAR2,
    x_attribute1               IN               VARCHAR2,
    x_attribute2               IN               VARCHAR2,
    x_attribute3               IN               VARCHAR2,
    x_attribute4               IN               VARCHAR2,
    x_attribute5               IN               VARCHAR2,
    x_attribute6               IN               VARCHAR2,
    x_attribute7               IN               VARCHAR2,
    x_attribute8               IN               VARCHAR2,
    x_attribute9               IN               VARCHAR2,
    x_attribute10              IN               VARCHAR2,
    x_attribute11              IN               VARCHAR2,
    x_attribute12              IN               VARCHAR2,
    x_attribute13              IN               VARCHAR2,
    x_attribute14              IN               VARCHAR2,
    x_attribute15              IN               VARCHAR2,
    x_last_update_date         IN               DATE,
    x_last_updated_by          IN               NUMBER,
    x_last_update_login        IN               NUMBER
) IS
BEGIN
    UPDATE ahl_warranty_entitlements SET
           object_version_number    = x_object_version_number,
           warranty_contract_id     = x_warranty_contract_id,
           old_warranty_contract_id = x_old_warranty_contract_id,
           entitlement_status_code  = x_entitlement_status_code,
           warranty_claim_id        = x_warranty_claim_id,
           po_header_id             = x_po_header_id,
           sr_incident_id           = x_sr_incident_id,
           visit_task_id            = x_visit_task_id,
           workorder_id             = x_workorder_id,
           osp_order_line_id        = x_osp_order_line_id,
           warranty_labour_capture  = x_warranty_labour_capture,
           warranty_mtl_capture     = x_warranty_mtl_capture,
           order_claim_amount       = x_order_claim_amount,
           attribute_category       = x_attribute_category,
           attribute1               = x_attribute1,
           attribute2               = x_attribute2,
           attribute3               = x_attribute3,
           attribute4               = x_attribute4,
           attribute5               = x_attribute5,
           attribute6               = x_attribute6,
           attribute7               = x_attribute7,
           attribute8               = x_attribute8,
           attribute9               = x_attribute9,
           attribute10              = x_attribute10,
           attribute11              = x_attribute11,
           attribute12              = x_attribute12,
           attribute13              = x_attribute13,
           attribute14              = x_attribute14,
           attribute15              = x_attribute15,
           last_update_date         = x_last_update_date,
           last_updated_by          = x_last_updated_by,
           last_update_login        = x_last_update_login
    WHERE  warranty_entitlement_id  = x_warranty_entitlement_id;

Line: 352


END Update_Row;

Line: 354


PROCEDURE Delete_Row (
    x_warranty_entitlement_id  IN               NUMBER
) IS
BEGIN
    DELETE FROM ahl_warranty_entitlements
    WHERE warranty_entitlement_id = x_warranty_entitlement_id;

Line: 364


END Delete_Row;