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

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

Line: 10


PROCEDURE Update_Row
(   p_Assignment_rec                IN  MRP_Src_Assignment_PUB.Assignment_Rec_Type
)
IS
BEGIN

    UPDATE  MRP_SR_ASSIGNMENTS
    SET     ASSIGNMENT_ID                  = p_Assignment_rec.Assignment_Id
    ,       ASSIGNMENT_SET_ID              = p_Assignment_rec.Assignment_Set_Id
    ,       ASSIGNMENT_TYPE                = p_Assignment_rec.Assignment_Type
    ,       ATTRIBUTE1                     = p_Assignment_rec.Attribute1
    ,       ATTRIBUTE10                    = p_Assignment_rec.Attribute10
    ,       ATTRIBUTE11                    = p_Assignment_rec.Attribute11
    ,       ATTRIBUTE12                    = p_Assignment_rec.Attribute12
    ,       ATTRIBUTE13                    = p_Assignment_rec.Attribute13
    ,       ATTRIBUTE14                    = p_Assignment_rec.Attribute14
    ,       ATTRIBUTE15                    = p_Assignment_rec.Attribute15
    ,       ATTRIBUTE2                     = p_Assignment_rec.Attribute2
    ,       ATTRIBUTE3                     = p_Assignment_rec.Attribute3
    ,       ATTRIBUTE4                     = p_Assignment_rec.Attribute4
    ,       ATTRIBUTE5                     = p_Assignment_rec.Attribute5
    ,       ATTRIBUTE6                     = p_Assignment_rec.Attribute6
    ,       ATTRIBUTE7                     = p_Assignment_rec.Attribute7
    ,       ATTRIBUTE8                     = p_Assignment_rec.Attribute8
    ,       ATTRIBUTE9                     = p_Assignment_rec.Attribute9
    ,       ATTRIBUTE_CATEGORY             = p_Assignment_rec.Attribute_Category
    ,       CATEGORY_ID                    = p_Assignment_rec.Category_Id
    ,       CATEGORY_SET_ID                = p_Assignment_rec.Category_Set_Id
    ,       CREATED_BY                     = p_Assignment_rec.Created_By
    ,       CREATION_DATE                  = p_Assignment_rec.Creation_Date
    ,       CUSTOMER_ID                    = p_Assignment_rec.Customer_Id
    ,       INVENTORY_ITEM_ID              = p_Assignment_rec.Inventory_Item_Id
    ,       LAST_UPDATED_BY                = p_Assignment_rec.Last_Updated_By
    ,       LAST_UPDATE_DATE               = p_Assignment_rec.Last_Update_Date
    ,       LAST_UPDATE_LOGIN              = p_Assignment_rec.Last_Update_Login
    ,       ORGANIZATION_ID                = p_Assignment_rec.Organization_Id
    ,       PROGRAM_APPLICATION_ID         = p_Assignment_rec.Program_Application_Id
    ,       PROGRAM_ID                     = p_Assignment_rec.Program_Id
    ,       PROGRAM_UPDATE_DATE            = p_Assignment_rec.Program_Update_Date
    ,       REQUEST_ID                     = p_Assignment_rec.Request_Id
    ,       SECONDARY_INVENTORY            = p_Assignment_rec.Secondary_Inventory
    ,       SHIP_TO_SITE_ID                = p_Assignment_rec.Ship_To_Site_Id
    ,       SOURCING_RULE_ID               = p_Assignment_rec.Sourcing_Rule_Id
    ,       SOURCING_RULE_TYPE             = p_Assignment_rec.Sourcing_Rule_Type
    WHERE   ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
    ;

Line: 65


            ,   'Update_Row'
            );

Line: 71


END Update_Row;

Line: 75


PROCEDURE Insert_Row
(   p_Assignment_rec                IN  MRP_Src_Assignment_PUB.Assignment_Rec_Type
)
IS
BEGIN

    INSERT  INTO MRP_SR_ASSIGNMENTS
    (       ASSIGNMENT_ID
    ,       ASSIGNMENT_SET_ID
    ,       ASSIGNMENT_TYPE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CATEGORY_ID
    ,       CATEGORY_SET_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CUSTOMER_ID
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_TO_SITE_ID
    ,       SOURCING_RULE_ID
    ,       SOURCING_RULE_TYPE
    )
    VALUES
    (       p_Assignment_rec.Assignment_Id
    ,       p_Assignment_rec.Assignment_Set_Id
    ,       p_Assignment_rec.Assignment_Type
    ,       p_Assignment_rec.Attribute1
    ,       p_Assignment_rec.Attribute10
    ,       p_Assignment_rec.Attribute11
    ,       p_Assignment_rec.Attribute12
    ,       p_Assignment_rec.Attribute13
    ,       p_Assignment_rec.Attribute14
    ,       p_Assignment_rec.Attribute15
    ,       p_Assignment_rec.Attribute2
    ,       p_Assignment_rec.Attribute3
    ,       p_Assignment_rec.Attribute4
    ,       p_Assignment_rec.Attribute5
    ,       p_Assignment_rec.Attribute6
    ,       p_Assignment_rec.Attribute7
    ,       p_Assignment_rec.Attribute8
    ,       p_Assignment_rec.Attribute9
    ,       p_Assignment_rec.Attribute_Category
    ,       p_Assignment_rec.Category_Id
    ,       p_Assignment_rec.Category_Set_Id
    ,       p_Assignment_rec.Created_By
    ,       p_Assignment_rec.Creation_Date
    ,       p_Assignment_rec.Customer_Id
    ,       p_Assignment_rec.Inventory_Item_Id
    ,       p_Assignment_rec.Last_Updated_By
    ,       p_Assignment_rec.Last_Update_Date
    ,       p_Assignment_rec.Last_Update_Login
    ,       p_Assignment_rec.Organization_Id
    ,       p_Assignment_rec.Program_Application_Id
    ,       p_Assignment_rec.Program_Id
    ,       p_Assignment_rec.Program_Update_Date
    ,       p_Assignment_rec.Request_Id
    ,       p_Assignment_rec.Secondary_Inventory
    ,       p_Assignment_rec.Ship_To_Site_Id
    ,       p_Assignment_rec.Sourcing_Rule_Id
    ,       p_Assignment_rec.Sourcing_Rule_Type
    );

Line: 168


            ,   'Insert_Row'
            );

Line: 174


END Insert_Row;

Line: 178


PROCEDURE Delete_Row
(   p_Assignment_Id                 IN  NUMBER
)
IS
BEGIN

    DELETE  FROM MRP_SR_ASSIGNMENTS
    WHERE   ASSIGNMENT_ID = p_Assignment_Id
    ;

Line: 196


            ,   'Delete_Row'
            );

Line: 202


END Delete_Row;

Line: 216


    SELECT  ASSIGNMENT_ID
    ,       ASSIGNMENT_SET_ID
    ,       ASSIGNMENT_TYPE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CATEGORY_ID
    ,       CATEGORY_SET_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CUSTOMER_ID
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_TO_SITE_ID
    ,       SOURCING_RULE_ID
    ,       SOURCING_RULE_TYPE
    INTO    l_Assignment_rec.Assignment_Id
    ,       l_Assignment_rec.Assignment_Set_Id
    ,       l_Assignment_rec.Assignment_Type
    ,       l_Assignment_rec.Attribute1
    ,       l_Assignment_rec.Attribute10
    ,       l_Assignment_rec.Attribute11
    ,       l_Assignment_rec.Attribute12
    ,       l_Assignment_rec.Attribute13
    ,       l_Assignment_rec.Attribute14
    ,       l_Assignment_rec.Attribute15
    ,       l_Assignment_rec.Attribute2
    ,       l_Assignment_rec.Attribute3
    ,       l_Assignment_rec.Attribute4
    ,       l_Assignment_rec.Attribute5
    ,       l_Assignment_rec.Attribute6
    ,       l_Assignment_rec.Attribute7
    ,       l_Assignment_rec.Attribute8
    ,       l_Assignment_rec.Attribute9
    ,       l_Assignment_rec.Attribute_Category
    ,       l_Assignment_rec.Category_Id
    ,       l_Assignment_rec.Category_Set_Id
    ,       l_Assignment_rec.Created_By
    ,       l_Assignment_rec.Creation_Date
    ,       l_Assignment_rec.Customer_Id
    ,       l_Assignment_rec.Inventory_Item_Id
    ,       l_Assignment_rec.Last_Updated_By
    ,       l_Assignment_rec.Last_Update_Date
    ,       l_Assignment_rec.Last_Update_Login
    ,       l_Assignment_rec.Organization_Id
    ,       l_Assignment_rec.Program_Application_Id
    ,       l_Assignment_rec.Program_Id
    ,       l_Assignment_rec.Program_Update_Date
    ,       l_Assignment_rec.Request_Id
    ,       l_Assignment_rec.Secondary_Inventory
    ,       l_Assignment_rec.Ship_To_Site_Id
    ,       l_Assignment_rec.Sourcing_Rule_Id
    ,       l_Assignment_rec.Sourcing_Rule_Type
    FROM    MRP_SR_ASSIGNMENTS
    WHERE   ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
        FOR UPDATE NOWAIT;

Line: 421


    AND (   (l_Assignment_rec.Last_Updated_By =
             p_Assignment_rec.Last_Updated_By) OR
            ((p_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Last_Updated_By IS NULL) AND
                (p_Assignment_rec.Last_Updated_By IS NULL))))
    AND (   (l_Assignment_rec.Last_Update_Date =
             p_Assignment_rec.Last_Update_Date) OR
            ((p_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Assignment_rec.Last_Update_Date IS NULL) AND
                (p_Assignment_rec.Last_Update_Date IS NULL))))
    AND (   (l_Assignment_rec.Last_Update_Login =
             p_Assignment_rec.Last_Update_Login) OR
            ((p_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Last_Update_Login IS NULL) AND
                (p_Assignment_rec.Last_Update_Login IS NULL))))
    AND (   (l_Assignment_rec.Organization_Id =
             p_Assignment_rec.Organization_Id) OR
            ((p_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Organization_Id IS NULL) AND
                (p_Assignment_rec.Organization_Id IS NULL))))
    AND (   (l_Assignment_rec.Program_Application_Id =
             p_Assignment_rec.Program_Application_Id) OR
            ((p_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Program_Application_Id IS NULL) AND
                (p_Assignment_rec.Program_Application_Id IS NULL))))
    AND (   (l_Assignment_rec.Program_Id =
             p_Assignment_rec.Program_Id) OR
            ((p_Assignment_rec.Program_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Program_Id IS NULL) AND
                (p_Assignment_rec.Program_Id IS NULL))))
    AND (   (l_Assignment_rec.Program_Update_Date =
             p_Assignment_rec.Program_Update_Date) OR
            ((p_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
            (   (l_Assignment_rec.Program_Update_Date IS NULL) AND
                (p_Assignment_rec.Program_Update_Date IS NULL))))
    AND (   (l_Assignment_rec.Request_Id =
             p_Assignment_rec.Request_Id) OR
            ((p_Assignment_rec.Request_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Request_Id IS NULL) AND
                (p_Assignment_rec.Request_Id IS NULL))))
    AND (   (l_Assignment_rec.Secondary_Inventory =
             p_Assignment_rec.Secondary_Inventory) OR
            ((p_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR
            (   (l_Assignment_rec.Secondary_Inventory IS NULL) AND
                (p_Assignment_rec.Secondary_Inventory IS NULL))))
    AND (   (l_Assignment_rec.Ship_To_Site_Id =
             p_Assignment_rec.Ship_To_Site_Id) OR
            ((p_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Ship_To_Site_Id IS NULL) AND
                (p_Assignment_rec.Ship_To_Site_Id IS NULL))))
    AND (   (l_Assignment_rec.Sourcing_Rule_Id =
             p_Assignment_rec.Sourcing_Rule_Id) OR
            ((p_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Sourcing_Rule_Id IS NULL) AND
                (p_Assignment_rec.Sourcing_Rule_Id IS NULL))))
    AND (   (l_Assignment_rec.Sourcing_Rule_Type =
             p_Assignment_rec.Sourcing_Rule_Type) OR
            ((p_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR
            (   (l_Assignment_rec.Sourcing_Rule_Type IS NULL) AND
                (p_Assignment_rec.Sourcing_Rule_Type IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Assignment_rec               := l_Assignment_rec;

Line: 519


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

Line: 634


    SELECT  ASSIGNMENT_ID
    ,       ASSIGNMENT_SET_ID
    ,       ASSIGNMENT_TYPE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CATEGORY_ID
    ,       CATEGORY_SET_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CUSTOMER_ID
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_TO_SITE_ID
    ,       SOURCING_RULE_ID
    ,       SOURCING_RULE_TYPE
    FROM    MRP_SR_ASSIGNMENTS
    WHERE ( ASSIGNMENT_ID = p_Assignment_Id
    )
    OR (    ASSIGNMENT_SET_ID = p_Assignment_Set_Id
    );

Line: 731


        l_Assignment_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 732


        l_Assignment_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 733


        l_Assignment_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 737


        l_Assignment_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 804


    SELECT  ASSIGNMENT_ID
    ,       ASSIGNMENT_SET_ID
    ,       ASSIGNMENT_TYPE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CATEGORY_ID
    ,       CATEGORY_SET_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CUSTOMER_ID
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       SECONDARY_INVENTORY
    ,       SHIP_TO_SITE_ID
    ,       SOURCING_RULE_ID
    ,       SOURCING_RULE_TYPE
    FROM    MRP_SR_ASSIGNMENTS
    WHERE ( ASSIGNMENT_ID = p_Assignment_Id
    )
    OR (    ASSIGNMENT_SET_ID = p_Assignment_Set_Id
    );

Line: 902


        l_Assignment_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;

Line: 903


        l_Assignment_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 904


        l_Assignment_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 908


        l_Assignment_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;