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_RECEIVING_ORG_HANDLERS SQL Statements

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

Line: 10


PROCEDURE Update_Row
(   p_Receiving_Org_rec             IN  MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
)
IS
BEGIN

    UPDATE  MRP_SR_RECEIPT_ORG
    SET     SR_RECEIPT_ID                  = p_Receiving_Org_rec.Sr_Receipt_Id
    ,       ATTRIBUTE1                     = p_Receiving_Org_rec.Attribute1
    ,       ATTRIBUTE10                    = p_Receiving_Org_rec.Attribute10
    ,       ATTRIBUTE11                    = p_Receiving_Org_rec.Attribute11
    ,       ATTRIBUTE12                    = p_Receiving_Org_rec.Attribute12
    ,       ATTRIBUTE13                    = p_Receiving_Org_rec.Attribute13
    ,       ATTRIBUTE14                    = p_Receiving_Org_rec.Attribute14
    ,       ATTRIBUTE15                    = p_Receiving_Org_rec.Attribute15
    ,       ATTRIBUTE2                     = p_Receiving_Org_rec.Attribute2
    ,       ATTRIBUTE3                     = p_Receiving_Org_rec.Attribute3
    ,       ATTRIBUTE4                     = p_Receiving_Org_rec.Attribute4
    ,       ATTRIBUTE5                     = p_Receiving_Org_rec.Attribute5
    ,       ATTRIBUTE6                     = p_Receiving_Org_rec.Attribute6
    ,       ATTRIBUTE7                     = p_Receiving_Org_rec.Attribute7
    ,       ATTRIBUTE8                     = p_Receiving_Org_rec.Attribute8
    ,       ATTRIBUTE9                     = p_Receiving_Org_rec.Attribute9
    ,       ATTRIBUTE_CATEGORY             = p_Receiving_Org_rec.Attribute_Category
    ,       CREATED_BY                     = p_Receiving_Org_rec.Created_By
    ,       CREATION_DATE                  = p_Receiving_Org_rec.Creation_Date
    ,       DISABLE_DATE                   = p_Receiving_Org_rec.Disable_Date
    ,       EFFECTIVE_DATE                 = p_Receiving_Org_rec.Effective_Date
    ,       LAST_UPDATED_BY                = p_Receiving_Org_rec.Last_Updated_By
    ,       LAST_UPDATE_DATE               = p_Receiving_Org_rec.Last_Update_Date
    ,       LAST_UPDATE_LOGIN              = p_Receiving_Org_rec.Last_Update_Login
    ,       PROGRAM_APPLICATION_ID         = p_Receiving_Org_rec.Program_Application_Id
    ,       PROGRAM_ID                     = p_Receiving_Org_rec.Program_Id
    ,       PROGRAM_UPDATE_DATE            = p_Receiving_Org_rec.Program_Update_Date
    ,       RECEIPT_ORGANIZATION_ID        = p_Receiving_Org_rec.Receipt_Organization_Id
    ,       REQUEST_ID                     = p_Receiving_Org_rec.Request_Id
    ,       SOURCING_RULE_ID               = p_Receiving_Org_rec.Sourcing_Rule_Id
    WHERE   SR_RECEIPT_ID = p_Receiving_Org_rec.Sr_Receipt_Id
    ;

Line: 58


            ,   'Update_Row'
            );

Line: 64


END Update_Row;

Line: 68


PROCEDURE Insert_Row
(   p_Receiving_Org_rec             IN  MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
)
IS
BEGIN

    INSERT  INTO MRP_SR_RECEIPT_ORG
    (       SR_RECEIPT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISABLE_DATE
    ,       EFFECTIVE_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RECEIPT_ORGANIZATION_ID
    ,       REQUEST_ID
    ,       SOURCING_RULE_ID
    )
    VALUES
    (       p_Receiving_Org_rec.Sr_Receipt_Id
    ,       p_Receiving_Org_rec.Attribute1
    ,       p_Receiving_Org_rec.Attribute10
    ,       p_Receiving_Org_rec.Attribute11
    ,       p_Receiving_Org_rec.Attribute12
    ,       p_Receiving_Org_rec.Attribute13
    ,       p_Receiving_Org_rec.Attribute14
    ,       p_Receiving_Org_rec.Attribute15
    ,       p_Receiving_Org_rec.Attribute2
    ,       p_Receiving_Org_rec.Attribute3
    ,       p_Receiving_Org_rec.Attribute4
    ,       p_Receiving_Org_rec.Attribute5
    ,       p_Receiving_Org_rec.Attribute6
    ,       p_Receiving_Org_rec.Attribute7
    ,       p_Receiving_Org_rec.Attribute8
    ,       p_Receiving_Org_rec.Attribute9
    ,       p_Receiving_Org_rec.Attribute_Category
    ,       p_Receiving_Org_rec.Created_By
    ,       p_Receiving_Org_rec.Creation_Date
    ,       p_Receiving_Org_rec.Disable_Date
    ,       p_Receiving_Org_rec.Effective_Date
    ,       p_Receiving_Org_rec.Last_Updated_By
    ,       p_Receiving_Org_rec.Last_Update_Date
    ,       p_Receiving_Org_rec.Last_Update_Login
    ,       p_Receiving_Org_rec.Program_Application_Id
    ,       p_Receiving_Org_rec.Program_Id
    ,       p_Receiving_Org_rec.Program_Update_Date
    ,       p_Receiving_Org_rec.Receipt_Organization_Id
    ,       p_Receiving_Org_rec.Request_Id
    ,       p_Receiving_Org_rec.Sourcing_Rule_Id
    );

Line: 147


            ,   'Insert_Row'
            );

Line: 153


END Insert_Row;

Line: 157


PROCEDURE Delete_Row
(   p_Sr_Receipt_Id                 IN  NUMBER
)
IS

l_sr_source_id          NUMBER := FND_API.G_MISS_NUM;

Line: 165


SELECT SR_SOURCE_ID
FROM   MRP_SR_SOURCE_ORG
WHERE  SR_RECEIPT_ID = p_Sr_Receipt_Id;

Line: 183


	MRP_Shipping_Org_Handlers.Delete_Row (
                	p_Sr_Source_Id => l_sr_source_id );

Line: 191


    DELETE  FROM MRP_SR_RECEIPT_ORG
    WHERE   SR_RECEIPT_ID = p_Sr_Receipt_Id
    ;

Line: 203


            ,   'Delete_Row'
            );

Line: 209


END Delete_Row;

Line: 223


    SELECT  SR_RECEIPT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISABLE_DATE
    ,       EFFECTIVE_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RECEIPT_ORGANIZATION_ID
    ,       REQUEST_ID
    ,       SOURCING_RULE_ID
    INTO    l_Receiving_Org_rec.Sr_Receipt_Id
    ,       l_Receiving_Org_rec.Attribute1
    ,       l_Receiving_Org_rec.Attribute10
    ,       l_Receiving_Org_rec.Attribute11
    ,       l_Receiving_Org_rec.Attribute12
    ,       l_Receiving_Org_rec.Attribute13
    ,       l_Receiving_Org_rec.Attribute14
    ,       l_Receiving_Org_rec.Attribute15
    ,       l_Receiving_Org_rec.Attribute2
    ,       l_Receiving_Org_rec.Attribute3
    ,       l_Receiving_Org_rec.Attribute4
    ,       l_Receiving_Org_rec.Attribute5
    ,       l_Receiving_Org_rec.Attribute6
    ,       l_Receiving_Org_rec.Attribute7
    ,       l_Receiving_Org_rec.Attribute8
    ,       l_Receiving_Org_rec.Attribute9
    ,       l_Receiving_Org_rec.Attribute_Category
    ,       l_Receiving_Org_rec.Created_By
    ,       l_Receiving_Org_rec.Creation_Date
    ,       l_Receiving_Org_rec.Disable_Date
    ,       l_Receiving_Org_rec.Effective_Date
    ,       l_Receiving_Org_rec.Last_Updated_By
    ,       l_Receiving_Org_rec.Last_Update_Date
    ,       l_Receiving_Org_rec.Last_Update_Login
    ,       l_Receiving_Org_rec.Program_Application_Id
    ,       l_Receiving_Org_rec.Program_Id
    ,       l_Receiving_Org_rec.Program_Update_Date
    ,       l_Receiving_Org_rec.Receipt_Organization_Id
    ,       l_Receiving_Org_rec.Request_Id
    ,       l_Receiving_Org_rec.Sourcing_Rule_Id
    FROM    MRP_SR_RECEIPT_ORG
    WHERE   SR_RECEIPT_ID = p_Receiving_Org_rec.Sr_Receipt_Id
        FOR UPDATE NOWAIT;

Line: 394


    AND (   (l_Receiving_Org_rec.Last_Updated_By =
             p_Receiving_Org_rec.Last_Updated_By) OR
            ((p_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Last_Updated_By IS NULL) AND
                (p_Receiving_Org_rec.Last_Updated_By IS NULL))))
    AND (   (l_Receiving_Org_rec.Last_Update_Date =
             p_Receiving_Org_rec.Last_Update_Date) OR
            ((p_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Receiving_Org_rec.Last_Update_Date IS NULL) AND
                (p_Receiving_Org_rec.Last_Update_Date IS NULL))))
    AND (   (l_Receiving_Org_rec.Last_Update_Login =
             p_Receiving_Org_rec.Last_Update_Login) OR
            ((p_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Last_Update_Login IS NULL) AND
                (p_Receiving_Org_rec.Last_Update_Login IS NULL))))
    AND (   (l_Receiving_Org_rec.Program_Application_Id =
             p_Receiving_Org_rec.Program_Application_Id) OR
            ((p_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Program_Application_Id IS NULL) AND
                (p_Receiving_Org_rec.Program_Application_Id IS NULL))))
    AND (   (l_Receiving_Org_rec.Program_Id =
             p_Receiving_Org_rec.Program_Id) OR
            ((p_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Program_Id IS NULL) AND
                (p_Receiving_Org_rec.Program_Id IS NULL))))
    AND (   (l_Receiving_Org_rec.Program_Update_Date =
             p_Receiving_Org_rec.Program_Update_Date) OR
            ((p_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Receiving_Org_rec.Program_Update_Date IS NULL) AND
                (p_Receiving_Org_rec.Program_Update_Date IS NULL))))
    AND (   (l_Receiving_Org_rec.Receipt_Organization_Id =
             p_Receiving_Org_rec.Receipt_Organization_Id) OR
            ((p_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Receipt_Organization_Id IS NULL) AND
                (p_Receiving_Org_rec.Receipt_Organization_Id IS NULL))))
    AND (   (l_Receiving_Org_rec.Request_Id =
             p_Receiving_Org_rec.Request_Id) OR
            ((p_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Request_Id IS NULL) AND
                (p_Receiving_Org_rec.Request_Id IS NULL))))
    AND (   (l_Receiving_Org_rec.Sourcing_Rule_Id =
             p_Receiving_Org_rec.Sourcing_Rule_Id) OR
            ((p_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR
            (   (l_Receiving_Org_rec.Sourcing_Rule_Id IS NULL) AND
                (p_Receiving_Org_rec.Sourcing_Rule_Id IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Receiving_Org_rec            := l_Receiving_Org_rec;

Line: 477


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

Line: 592


    SELECT  SR_RECEIPT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISABLE_DATE
    ,       EFFECTIVE_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RECEIPT_ORGANIZATION_ID
    ,       REQUEST_ID
    ,       SOURCING_RULE_ID
    FROM    MRP_SR_RECEIPT_ORG
    WHERE ( SR_RECEIPT_ID = p_Sr_Receipt_Id
    )
    OR (    SOURCING_RULE_ID = p_Sourcing_Rule_Id
    );

Line: 678


        l_Receiving_Org_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 679


        l_Receiving_Org_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 680


        l_Receiving_Org_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 683


        l_Receiving_Org_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 748


    SELECT  SR_RECEIPT_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DISABLE_DATE
    ,       EFFECTIVE_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       RECEIPT_ORGANIZATION_ID
    ,       REQUEST_ID
    ,       SOURCING_RULE_ID
    FROM    MRP_SR_RECEIPT_ORG
    WHERE ( SR_RECEIPT_ID = p_Sr_Receipt_Id
    )
    OR (    SOURCING_RULE_ID = p_Sourcing_Rule_Id
    );

Line: 835


        l_Receiving_Org_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 836


        l_Receiving_Org_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 837


        l_Receiving_Org_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 840


        l_Receiving_Org_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;