APPS.MRP_DEFAULT_SHIPPING_ORG SQL Statements

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

Line: 28

    	SELECT mrp_sr_source_org_s.NEXTVAL
	INTO   l_sr_source_id
	FROM   dual;

Line: 210

FUNCTION Get_Last_Updated_By
RETURN NUMBER
IS
BEGIN

    RETURN NULL;

Line: 217

END Get_Last_Updated_By;

Line: 219

FUNCTION Get_Last_Update_Date
RETURN DATE
IS
BEGIN

    RETURN NULL;

Line: 226

END Get_Last_Update_Date;

Line: 228

FUNCTION Get_Last_Update_Login
RETURN NUMBER
IS
BEGIN

    RETURN NULL;

Line: 235

END Get_Last_Update_Login;

Line: 255

FUNCTION Get_Program_Update_Date
RETURN DATE
IS
BEGIN

    RETURN NULL;

Line: 262

END Get_Program_Update_Date;

Line: 824

    IF g_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

        g_Shipping_Org_rec.Last_Updated_By := Get_Last_Updated_By;

Line: 828

        IF g_Shipping_Org_rec.Last_Updated_By IS NOT NULL THEN

            IF  MRP_Validate_Shipping_Org.Val_Last_Updated_By
                ( g_Shipping_Org_rec.Last_Updated_By )
            THEN

                MRP_Shipping_Org_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Shipping_Org_Util.G_LAST_UPDATED_BY
                ,   p_Shipping_Org_rec            => g_Shipping_Org_rec
                ,   x_Shipping_Org_rec            => g_Shipping_Org_rec
                );

Line: 840

                    g_Shipping_Org_rec.Last_Updated_By := NULL;

Line: 847

    IF g_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

        g_Shipping_Org_rec.Last_Update_Date := Get_Last_Update_Date;

Line: 851

        IF g_Shipping_Org_rec.Last_Update_Date IS NOT NULL THEN

            IF  MRP_Validate_Shipping_Org.Val_Last_Update_Date
                ( g_Shipping_Org_rec.Last_Update_Date )
            THEN

                MRP_Shipping_Org_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Shipping_Org_Util.G_LAST_UPDATE_DATE
                ,   p_Shipping_Org_rec            => g_Shipping_Org_rec
                ,   x_Shipping_Org_rec            => g_Shipping_Org_rec
                );

Line: 863

                    g_Shipping_Org_rec.Last_Update_Date := NULL;

Line: 870

    IF g_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

        g_Shipping_Org_rec.Last_Update_Login := Get_Last_Update_Login;

Line: 874

        IF g_Shipping_Org_rec.Last_Update_Login IS NOT NULL THEN

            IF  MRP_Validate_Shipping_Org.Val_Last_Update_Login
                ( g_Shipping_Org_rec.Last_Update_Login )
            THEN

                MRP_Shipping_Org_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Shipping_Org_Util.G_LAST_UPDATE_LOGIN
                ,   p_Shipping_Org_rec            => g_Shipping_Org_rec
                ,   x_Shipping_Org_rec            => g_Shipping_Org_rec
                );

Line: 886

                    g_Shipping_Org_rec.Last_Update_Login := NULL;

Line: 939

    IF g_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

        g_Shipping_Org_rec.Program_Update_Date := Get_Program_Update_Date;

Line: 943

        IF g_Shipping_Org_rec.Program_Update_Date IS NOT NULL THEN

            IF  MRP_Validate_Shipping_Org.Val_Program_Update_Date
                ( g_Shipping_Org_rec.Program_Update_Date )
            THEN

                MRP_Shipping_Org_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Shipping_Org_Util.G_PROGRAM_UPDATE_DATE
                ,   p_Shipping_Org_rec            => g_Shipping_Org_rec
                ,   x_Shipping_Org_rec            => g_Shipping_Org_rec
                );

Line: 955

                    g_Shipping_Org_rec.Program_Update_Date := NULL;

Line: 1195

    OR  g_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE
    OR  g_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE
    OR  g_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR
    OR  g_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR
    OR  g_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM
    OR  g_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM
    THEN

        MRP_Default_Shipping_Org.Attributes
        (   p_Shipping_Org_rec            => g_Shipping_Org_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_Shipping_Org_rec            => x_Shipping_Org_rec
        );