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.MRP_SHIPPING_ORG_HANDLERS SQL Statements

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

Line: 10


PROCEDURE Update_Row
(   p_Shipping_Org_rec              IN  MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
)
IS
BEGIN

    UPDATE  MRP_SR_SOURCE_ORG
    SET     SR_SOURCE_ID                   = p_Shipping_Org_rec.Sr_Source_Id
    ,       ALLOCATION_PERCENT             = p_Shipping_Org_rec.Allocation_Percent
    ,       ATTRIBUTE1                     = p_Shipping_Org_rec.Attribute1
    ,       ATTRIBUTE10                    = p_Shipping_Org_rec.Attribute10
    ,       ATTRIBUTE11                    = p_Shipping_Org_rec.Attribute11
    ,       ATTRIBUTE12                    = p_Shipping_Org_rec.Attribute12
    ,       ATTRIBUTE13                    = p_Shipping_Org_rec.Attribute13
    ,       ATTRIBUTE14                    = p_Shipping_Org_rec.Attribute14
    ,       ATTRIBUTE15                    = p_Shipping_Org_rec.Attribute15
    ,       ATTRIBUTE2                     = p_Shipping_Org_rec.Attribute2
    ,       ATTRIBUTE3                     = p_Shipping_Org_rec.Attribute3
    ,       ATTRIBUTE4                     = p_Shipping_Org_rec.Attribute4
    ,       ATTRIBUTE5                     = p_Shipping_Org_rec.Attribute5
    ,       ATTRIBUTE6                     = p_Shipping_Org_rec.Attribute6
    ,       ATTRIBUTE7                     = p_Shipping_Org_rec.Attribute7
    ,       ATTRIBUTE8                     = p_Shipping_Org_rec.Attribute8
    ,       ATTRIBUTE9                     = p_Shipping_Org_rec.Attribute9
    ,       ATTRIBUTE_CATEGORY             = p_Shipping_Org_rec.Attribute_Category
    ,       CREATED_BY                     = p_Shipping_Org_rec.Created_By
    ,       CREATION_DATE                  = p_Shipping_Org_rec.Creation_Date
    ,       LAST_UPDATED_BY                = p_Shipping_Org_rec.Last_Updated_By
    ,       LAST_UPDATE_DATE               = p_Shipping_Org_rec.Last_Update_Date
    ,       LAST_UPDATE_LOGIN              = p_Shipping_Org_rec.Last_Update_Login
    ,       PROGRAM_APPLICATION_ID         = p_Shipping_Org_rec.Program_Application_Id
    ,       PROGRAM_ID                     = p_Shipping_Org_rec.Program_Id
    ,       PROGRAM_UPDATE_DATE            = p_Shipping_Org_rec.Program_Update_Date
    ,       RANK                           = p_Shipping_Org_rec.Rank
    ,       REQUEST_ID                     = p_Shipping_Org_rec.Request_Id
    ,       SECONDARY_INVENTORY            = p_Shipping_Org_rec.Secondary_Inventory
    ,       SHIP_METHOD                    = p_Shipping_Org_rec.Ship_Method
    ,       SOURCE_ORGANIZATION_ID         = p_Shipping_Org_rec.Source_Organization_Id
    ,       SOURCE_TYPE                    = p_Shipping_Org_rec.Source_Type
    ,       SR_RECEIPT_ID                  = p_Shipping_Org_rec.Sr_Receipt_Id
    ,       VENDOR_ID                      = p_Shipping_Org_rec.Vendor_Id
    ,       VENDOR_SITE_ID                 = p_Shipping_Org_rec.Vendor_Site_Id
    WHERE   SR_SOURCE_ID = p_Shipping_Org_rec.Sr_Source_Id
    ;

Line: 63


            ,   'Update_Row'
            );

Line: 69


END Update_Row;

Line: 73


PROCEDURE Insert_Row
(   p_Shipping_Org_rec              IN  MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
)
IS
BEGIN

    INSERT  INTO MRP_SR_SOURCE_ORG
    (       SR_SOURCE_ID
    ,       ALLOCATION_PERCENT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RANK
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_METHOD
    ,       SOURCE_ORGANIZATION_ID
    ,       SOURCE_TYPE
    ,       SR_RECEIPT_ID
    ,       VENDOR_ID
    ,       VENDOR_SITE_ID
    )
    VALUES
    (       p_Shipping_Org_rec.Sr_Source_Id
    ,       p_Shipping_Org_rec.Allocation_Percent
    ,       p_Shipping_Org_rec.Attribute1
    ,       p_Shipping_Org_rec.Attribute10
    ,       p_Shipping_Org_rec.Attribute11
    ,       p_Shipping_Org_rec.Attribute12
    ,       p_Shipping_Org_rec.Attribute13
    ,       p_Shipping_Org_rec.Attribute14
    ,       p_Shipping_Org_rec.Attribute15
    ,       p_Shipping_Org_rec.Attribute2
    ,       p_Shipping_Org_rec.Attribute3
    ,       p_Shipping_Org_rec.Attribute4
    ,       p_Shipping_Org_rec.Attribute5
    ,       p_Shipping_Org_rec.Attribute6
    ,       p_Shipping_Org_rec.Attribute7
    ,       p_Shipping_Org_rec.Attribute8
    ,       p_Shipping_Org_rec.Attribute9
    ,       p_Shipping_Org_rec.Attribute_Category
    ,       p_Shipping_Org_rec.Created_By
    ,       p_Shipping_Org_rec.Creation_Date
    ,       p_Shipping_Org_rec.Last_Updated_By
    ,       p_Shipping_Org_rec.Last_Update_Date
    ,       p_Shipping_Org_rec.Last_Update_Login
    ,       p_Shipping_Org_rec.Program_Application_Id
    ,       p_Shipping_Org_rec.Program_Id
    ,       p_Shipping_Org_rec.Program_Update_Date
    ,       p_Shipping_Org_rec.Rank
    ,       p_Shipping_Org_rec.Request_Id
    ,       p_Shipping_Org_rec.Secondary_Inventory
    ,       p_Shipping_Org_rec.Ship_Method
    ,       p_Shipping_Org_rec.Source_Organization_Id
    ,       p_Shipping_Org_rec.Source_Type
    ,       p_Shipping_Org_rec.Sr_Receipt_Id
    ,       p_Shipping_Org_rec.Vendor_Id
    ,       p_Shipping_Org_rec.Vendor_Site_Id
    );

Line: 162


            ,   'Insert_Row'
            );

Line: 168


END Insert_Row;

Line: 172


PROCEDURE Delete_Row
(   p_Sr_Source_Id                  IN  NUMBER
)
IS
BEGIN

    DELETE  FROM MRP_SR_SOURCE_ORG
    WHERE   SR_SOURCE_ID = p_Sr_Source_Id
    ;

Line: 190


            ,   'Delete_Row'
            );

Line: 196


END Delete_Row;

Line: 210


    SELECT  SR_SOURCE_ID
    ,       ALLOCATION_PERCENT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RANK
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_METHOD
    ,       SOURCE_ORGANIZATION_ID
    ,       SOURCE_TYPE
    ,       SR_RECEIPT_ID
    ,       VENDOR_ID
    ,       VENDOR_SITE_ID
    INTO    l_Shipping_Org_rec.Sr_Source_Id
    ,       l_Shipping_Org_rec.Allocation_Percent
    ,       l_Shipping_Org_rec.Attribute1
    ,       l_Shipping_Org_rec.Attribute10
    ,       l_Shipping_Org_rec.Attribute11
    ,       l_Shipping_Org_rec.Attribute12
    ,       l_Shipping_Org_rec.Attribute13
    ,       l_Shipping_Org_rec.Attribute14
    ,       l_Shipping_Org_rec.Attribute15
    ,       l_Shipping_Org_rec.Attribute2
    ,       l_Shipping_Org_rec.Attribute3
    ,       l_Shipping_Org_rec.Attribute4
    ,       l_Shipping_Org_rec.Attribute5
    ,       l_Shipping_Org_rec.Attribute6
    ,       l_Shipping_Org_rec.Attribute7
    ,       l_Shipping_Org_rec.Attribute8
    ,       l_Shipping_Org_rec.Attribute9
    ,       l_Shipping_Org_rec.Attribute_Category
    ,       l_Shipping_Org_rec.Created_By
    ,       l_Shipping_Org_rec.Creation_Date
    ,       l_Shipping_Org_rec.Last_Updated_By
    ,       l_Shipping_Org_rec.Last_Update_Date
    ,       l_Shipping_Org_rec.Last_Update_Login
    ,       l_Shipping_Org_rec.Program_Application_Id
    ,       l_Shipping_Org_rec.Program_Id
    ,       l_Shipping_Org_rec.Program_Update_Date
    ,       l_Shipping_Org_rec.Rank
    ,       l_Shipping_Org_rec.Request_Id
    ,       l_Shipping_Org_rec.Secondary_Inventory
    ,       l_Shipping_Org_rec.Ship_Method
    ,       l_Shipping_Org_rec.Source_Organization_Id
    ,       l_Shipping_Org_rec.Source_Type
    ,       l_Shipping_Org_rec.Sr_Receipt_Id
    ,       l_Shipping_Org_rec.Vendor_Id
    ,       l_Shipping_Org_rec.Vendor_Site_Id
    FROM    MRP_SR_SOURCE_ORG
    WHERE   SR_SOURCE_ID = p_Shipping_Org_rec.Sr_Source_Id
        FOR UPDATE NOWAIT;

Line: 386


    AND (   (l_Shipping_Org_rec.Last_Updated_By =
             p_Shipping_Org_rec.Last_Updated_By) OR
            ((p_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Last_Updated_By IS NULL) AND
                (p_Shipping_Org_rec.Last_Updated_By IS NULL))))
    AND (   (l_Shipping_Org_rec.Last_Update_Date =
             p_Shipping_Org_rec.Last_Update_Date) OR
            ((p_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Shipping_Org_rec.Last_Update_Date IS NULL) AND
                (p_Shipping_Org_rec.Last_Update_Date IS NULL))))
    AND (   (l_Shipping_Org_rec.Last_Update_Login =
             p_Shipping_Org_rec.Last_Update_Login) OR
            ((p_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Last_Update_Login IS NULL) AND
                (p_Shipping_Org_rec.Last_Update_Login IS NULL))))
    AND (   (l_Shipping_Org_rec.Program_Application_Id =
             p_Shipping_Org_rec.Program_Application_Id) OR
            ((p_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Program_Application_Id IS NULL) AND
                (p_Shipping_Org_rec.Program_Application_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Program_Id =
             p_Shipping_Org_rec.Program_Id) OR
            ((p_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Program_Id IS NULL) AND
                (p_Shipping_Org_rec.Program_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Program_Update_Date =
             p_Shipping_Org_rec.Program_Update_Date) OR
            ((p_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Shipping_Org_rec.Program_Update_Date IS NULL) AND
                (p_Shipping_Org_rec.Program_Update_Date IS NULL))))
    AND (   (l_Shipping_Org_rec.Rank =
             p_Shipping_Org_rec.Rank) OR
            ((p_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Rank IS NULL) AND
                (p_Shipping_Org_rec.Rank IS NULL))))
    AND (   (l_Shipping_Org_rec.Request_Id =
             p_Shipping_Org_rec.Request_Id) OR
            ((p_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Request_Id IS NULL) AND
                (p_Shipping_Org_rec.Request_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Secondary_Inventory =
             p_Shipping_Org_rec.Secondary_Inventory) OR
            ((p_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR
            (   (l_Shipping_Org_rec.Secondary_Inventory IS NULL) AND
                (p_Shipping_Org_rec.Secondary_Inventory IS NULL))))
    AND (   (l_Shipping_Org_rec.Ship_Method =
             p_Shipping_Org_rec.Ship_Method) OR
            ((p_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR) OR
            (   (l_Shipping_Org_rec.Ship_Method IS NULL) AND
                (p_Shipping_Org_rec.Ship_Method IS NULL))))
    AND (   (l_Shipping_Org_rec.Source_Organization_Id =
             p_Shipping_Org_rec.Source_Organization_Id) OR
            ((p_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Source_Organization_Id IS NULL) AND
                (p_Shipping_Org_rec.Source_Organization_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Source_Type =
             p_Shipping_Org_rec.Source_Type) OR
            ((p_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Source_Type IS NULL) AND
                (p_Shipping_Org_rec.Source_Type IS NULL))))
    AND (   (l_Shipping_Org_rec.Sr_Receipt_Id =
             p_Shipping_Org_rec.Sr_Receipt_Id) OR
            ((p_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Sr_Receipt_Id IS NULL) AND
                (p_Shipping_Org_rec.Sr_Receipt_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Vendor_Id =
             p_Shipping_Org_rec.Vendor_Id) OR
            ((p_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Vendor_Id IS NULL) AND
                (p_Shipping_Org_rec.Vendor_Id IS NULL))))
    AND (   (l_Shipping_Org_rec.Vendor_Site_Id =
             p_Shipping_Org_rec.Vendor_Site_Id) OR
            ((p_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM) OR
            (   (l_Shipping_Org_rec.Vendor_Site_Id IS NULL) AND
                (p_Shipping_Org_rec.Vendor_Site_Id IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Shipping_Org_rec             := l_Shipping_Org_rec;

Line: 499


            FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');

Line: 614


    SELECT  SR_SOURCE_ID
    ,       ALLOCATION_PERCENT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RANK
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_METHOD
    ,       SOURCE_ORGANIZATION_ID
    ,       SOURCE_TYPE
    ,       SR_RECEIPT_ID
    ,       VENDOR_ID
    ,       VENDOR_SITE_ID
    FROM    MRP_SR_SOURCE_ORG
    WHERE ( SR_SOURCE_ID = p_Sr_Source_Id
    )
    OR (    SR_RECEIPT_ID = p_Sr_Receipt_Id
    );

Line: 704


        l_Shipping_Org_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 705


        l_Shipping_Org_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 706


        l_Shipping_Org_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 709


        l_Shipping_Org_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 780


    SELECT  SR_SOURCE_ID
    ,       ALLOCATION_PERCENT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RANK
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_METHOD
    ,       SOURCE_ORGANIZATION_ID
    ,       SOURCE_TYPE
    ,       SR_RECEIPT_ID
    ,       VENDOR_ID
    ,       VENDOR_SITE_ID
    FROM    MRP_SR_SOURCE_ORG
    WHERE ( SR_SOURCE_ID = p_Sr_Source_Id
    )
    OR (    SR_RECEIPT_ID = p_Sr_Receipt_Id
    );

Line: 871


        l_Shipping_Org_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 872


        l_Shipping_Org_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 873


        l_Shipping_Org_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 876


        l_Shipping_Org_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;