APPS.MRP_DEFAULT_SOURCING_RULE SQL Statements

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

Line: 27

   	SELECT mrp_sourcing_rules_s.NEXTVAL
     	INTO l_sourcing_rule_id
     	FROM dual;

Line: 209

FUNCTION Get_Last_Updated_By
RETURN NUMBER
IS
BEGIN

    RETURN NULL;

Line: 216

END Get_Last_Updated_By;

Line: 218

FUNCTION Get_Last_Update_Date
RETURN DATE
IS
BEGIN

    RETURN NULL;

Line: 225

END Get_Last_Update_Date;

Line: 227

FUNCTION Get_Last_Update_Login
RETURN NUMBER
IS
BEGIN

    RETURN NULL;

Line: 234

END Get_Last_Update_Login;

Line: 272

FUNCTION Get_Program_Update_Date
RETURN DATE
IS
BEGIN

    RETURN NULL;

Line: 279

END Get_Program_Update_Date;

Line: 815

    IF g_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

        g_Sourcing_Rule_rec.Last_Updated_By := Get_Last_Updated_By;

Line: 819

        IF g_Sourcing_Rule_rec.Last_Updated_By IS NOT NULL THEN

            IF  MRP_Validate_Sourcing_Rule.Val_Last_Updated_By
                ( g_Sourcing_Rule_rec.Last_Updated_By )
            THEN

                MRP_Sourcing_Rule_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Sourcing_Rule_Util.G_LAST_UPDATED_BY
                ,   p_Sourcing_Rule_rec           => g_Sourcing_Rule_rec
                ,   x_Sourcing_Rule_rec           => g_Sourcing_Rule_out_rec --NOCOPY CHANGES
                );

Line: 832

                    g_Sourcing_Rule_rec.Last_Updated_By := NULL;

Line: 839

    IF g_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

        g_Sourcing_Rule_rec.Last_Update_Date := Get_Last_Update_Date;

Line: 843

        IF g_Sourcing_Rule_rec.Last_Update_Date IS NOT NULL THEN

            IF  MRP_Validate_Sourcing_Rule.Val_Last_Update_Date
                ( g_Sourcing_Rule_rec.Last_Update_Date )
            THEN

                MRP_Sourcing_Rule_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Sourcing_Rule_Util.G_LAST_UPDATE_DATE
                ,   p_Sourcing_Rule_rec           => g_Sourcing_Rule_rec
                ,   x_Sourcing_Rule_rec           => g_Sourcing_Rule_out_rec --NOCOPY CHANGES
                );

Line: 856

                    g_Sourcing_Rule_rec.Last_Update_Date := NULL;

Line: 863

    IF g_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

        g_Sourcing_Rule_rec.Last_Update_Login := Get_Last_Update_Login;

Line: 867

        IF g_Sourcing_Rule_rec.Last_Update_Login IS NOT NULL THEN

            IF  MRP_Validate_Sourcing_Rule.Val_Last_Update_Login
                ( g_Sourcing_Rule_rec.Last_Update_Login )
            THEN

                MRP_Sourcing_Rule_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Sourcing_Rule_Util.G_LAST_UPDATE_LOGIN
                ,   p_Sourcing_Rule_rec           => g_Sourcing_Rule_rec
                ,   x_Sourcing_Rule_rec           => g_Sourcing_Rule_out_rec --NOCOPY CHANGES
                );

Line: 880

                    g_Sourcing_Rule_rec.Last_Update_Login := NULL;

Line: 983

    IF g_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

        g_Sourcing_Rule_rec.Program_Update_Date := Get_Program_Update_Date;

Line: 987

        IF g_Sourcing_Rule_rec.Program_Update_Date IS NOT NULL THEN

            IF  MRP_Validate_Sourcing_Rule.Val_Program_Update_Date
                ( g_Sourcing_Rule_rec.Program_Update_Date )
            THEN

                MRP_Sourcing_Rule_Util.Clear_Dependent_Attr
                (   p_attr_id                     => MRP_Sourcing_Rule_Util.G_PROGRAM_UPDATE_DATE
                ,   p_Sourcing_Rule_rec           => g_Sourcing_Rule_rec
                ,   x_Sourcing_Rule_rec           => g_Sourcing_Rule_out_rec --NOCOPY CHANGES
                );

Line: 1000

                    g_Sourcing_Rule_rec.Program_Update_Date := NULL;

Line: 1126

    OR  g_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE
    OR  g_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE
    OR  g_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR
    OR  g_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM
    OR  g_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM
    THEN

        MRP_Default_Sourcing_Rule.Attributes
        (   p_Sourcing_Rule_rec           => g_Sourcing_Rule_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_Sourcing_Rule_rec           => x_Sourcing_Rule_rec
        );