DBA Data[Home] [Help]

APPS.MRP_SHIPPING_ORG_UTIL SQL Statements

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

Line: 129

        IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Updated_By,p_old_Shipping_Org_rec.Last_Updated_By)
        THEN
            NULL;
Line: 134

        IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Date,p_old_Shipping_Org_rec.Last_Update_Date)
        THEN
            NULL;
Line: 139

        IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Login,p_old_Shipping_Org_rec.Last_Update_Login)
        THEN
            NULL;
Line: 154

        IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Update_Date,p_old_Shipping_Org_rec.Program_Update_Date)
        THEN
            NULL;
Line: 244

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        NULL;
Line: 246

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        NULL;
Line: 248

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        NULL;
Line: 254

    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        NULL;
Line: 407

    IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Updated_By,p_old_Shipping_Org_rec.Last_Updated_By)
    THEN
        NULL;
Line: 412

    IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Date,p_old_Shipping_Org_rec.Last_Update_Date)
    THEN
        NULL;
Line: 417

    IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Login,p_old_Shipping_Org_rec.Last_Update_Login)
    THEN
        NULL;
Line: 432

    IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Update_Date,p_old_Shipping_Org_rec.Program_Update_Date)
    THEN
        NULL;
Line: 574

    IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
        l_Shipping_Org_rec.Last_Updated_By := p_old_Shipping_Org_rec.Last_Updated_By;
Line: 578

    IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
        l_Shipping_Org_rec.Last_Update_Date := p_old_Shipping_Org_rec.Last_Update_Date;
Line: 582

    IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
        l_Shipping_Org_rec.Last_Update_Login := p_old_Shipping_Org_rec.Last_Update_Login;
Line: 594

    IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
        l_Shipping_Org_rec.Program_Update_Date := p_old_Shipping_Org_rec.Program_Update_Date;
Line: 727

    IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
        l_Shipping_Org_rec.Last_Updated_By := NULL;
Line: 731

    IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
        l_Shipping_Org_rec.Last_Update_Date := NULL;
Line: 735

    IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
        l_Shipping_Org_rec.Last_Update_Login := NULL;
Line: 747

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