APPS.MRP_ASSIGNMENT_PVT SQL Statements

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

Line: 50

    ELSIF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE
    OR    l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE
    THEN

        l_Assignment_Set_rec.db_flag := FND_API.G_TRUE;

Line: 153

        IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN

            MRP_Validate_Assignment_Set.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_Assignment_Set_rec          => l_Assignment_Set_rec
            );

Line: 182

        IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_DELETE THEN

            MRP_Assignment_Set_Handlers.Delete_Row
            (   p_Assignment_Set_Id           => l_Assignment_Set_rec.Assignment_Set_Id
            );

Line: 192

            l_Assignment_Set_rec.last_update_date := SYSDATE;

Line: 193

            l_Assignment_Set_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 194

            l_Assignment_Set_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 196

            IF l_Assignment_Set_rec.operation = MRP_Globals.G_OPR_UPDATE THEN

                MRP_Assignment_Set_Handlers.Update_Row (l_Assignment_Set_rec);

Line: 205

                MRP_Assignment_Set_Handlers.Insert_Row (l_Assignment_Set_rec);

Line: 313

        ELSIF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE
        OR    l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE
        THEN

            l_Assignment_rec.db_flag := FND_API.G_TRUE;

Line: 416

            IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN

                MRP_Validate_Assignment.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_Assignment_rec              => l_Assignment_rec
                );

Line: 445

            IF l_Assignment_rec.operation = MRP_Globals.G_OPR_DELETE THEN

                MRP_Assignment_Handlers.Delete_Row
                (   p_Assignment_Id               => l_Assignment_rec.Assignment_Id
                );

Line: 455

                l_Assignment_rec.last_update_date := SYSDATE;

Line: 456

                l_Assignment_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 457

                l_Assignment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 459

                IF l_Assignment_rec.operation = MRP_Globals.G_OPR_UPDATE THEN

                    MRP_Assignment_Handlers.Update_Row (l_Assignment_rec);

Line: 468

                    MRP_Assignment_Handlers.Insert_Row (l_Assignment_rec);

Line: 702

            SELECT organization_id
	    INTO   l_src_rule_org_id
	    FROM   MRP_SOURCING_RULES
	    WHERE  sourcing_rule_id = l_Assignment_rec.sourcing_rule_id;

Line: 754

            SELECT organization_id
            INTO   l_organization_id
            FROM   mrp_cust_sup_org_v
            WHERE  Customer_Id = to_char(l_Assignment_rec.Customer_Id)
            AND    Ship_To_Site_Id = to_char(l_Assignment_rec.Ship_To_Site_Id);

Line: 762

               UPDATE mrp_sr_assignments
               SET    organization_id = l_organization_id
               WHERE  assignment_id = l_Assignment_rec.assignment_id;