APPS.MRP_SOURCING_RULE_UTIL SQL Statements

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

Line: 129

        IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Updated_By,p_old_Sourcing_Rule_rec.Last_Updated_By)
        THEN
            NULL;

Line: 134

        IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Date,p_old_Sourcing_Rule_rec.Last_Update_Date)
        THEN
            NULL;

Line: 139

        IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Login,p_old_Sourcing_Rule_rec.Last_Update_Login)
        THEN
            NULL;

Line: 164

        IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Update_Date,p_old_Sourcing_Rule_rec.Program_Update_Date)
        THEN
            NULL;

Line: 229

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        NULL;

Line: 231

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        NULL;

Line: 233

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        NULL;

Line: 243

    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        NULL;

Line: 372

    IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Updated_By,p_old_Sourcing_Rule_rec.Last_Updated_By)
    THEN
        NULL;

Line: 377

    IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Date,p_old_Sourcing_Rule_rec.Last_Update_Date)
    THEN
        NULL;

Line: 382

    IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Login,p_old_Sourcing_Rule_rec.Last_Update_Login)
    THEN
        NULL;

Line: 407

    IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Update_Date,p_old_Sourcing_Rule_rec.Program_Update_Date)
    THEN
        NULL;

Line: 524

    IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
        l_Sourcing_Rule_rec.Last_Updated_By := p_old_Sourcing_Rule_rec.Last_Updated_By;

Line: 528

    IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
        l_Sourcing_Rule_rec.Last_Update_Date := p_old_Sourcing_Rule_rec.Last_Update_Date;

Line: 532

    IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
        l_Sourcing_Rule_rec.Last_Update_Login := p_old_Sourcing_Rule_rec.Last_Update_Login;

Line: 552

    IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
        l_Sourcing_Rule_rec.Program_Update_Date := p_old_Sourcing_Rule_rec.Program_Update_Date;

Line: 665

    IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
        l_Sourcing_Rule_rec.Last_Updated_By := NULL;

Line: 669

    IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
        l_Sourcing_Rule_rec.Last_Update_Date := NULL;

Line: 673

    IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
        l_Sourcing_Rule_rec.Last_Update_Login := NULL;

Line: 693

    IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
        l_Sourcing_Rule_rec.Program_Update_Date := NULL;