APPS.GMF_RESOURCECOST_PVT SQL Statements

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

Line: 138

       log_msg('Inserting record for resource : ' || p_resource_cost_rec.resources ||
                ' Legal Entity Id : '   || p_resource_cost_rec.legal_entity_id ||
                ' Organization id : '  || p_resource_cost_rec.organization_id ||
                ' Period Id : ' || p_resource_cost_rec.period_id ||
                ' Cost type id : '|| p_resource_cost_rec.cost_type_id);

Line: 145

    INSERT INTO cm_rsrc_dtl
    (
      resources
    , nominal_cost
    , text_code
    , delete_mark
    , rollover_ind
    , creation_date
    , created_by
    , last_update_date
    , last_updated_by
    , trans_cnt
    , last_update_login
    , organization_id
    , cost_type_id
    , period_id
    , usage_uom
    , legal_entity_id
    )
    VALUES
    (
      p_resource_cost_rec.resources
    , p_resource_cost_rec.nominal_cost
    , ''                -- text code
    , 0                 -- delete mark
    , 0                 -- rollover Indicator
    , sysdate
    , p_user_id
    , sysdate
    , p_user_id
    , ''        -- transaction count (not in use)
    , FND_GLOBAL.LOGIN_ID
    , p_resource_cost_rec.organization_id
    , p_resource_cost_rec.cost_type_id
    , p_resource_cost_rec.period_id
    , p_resource_cost_rec.usage_uom
    , p_resource_cost_rec.legal_entity_id
    );

Line: 185

        log_msg('1 row inserted');

Line: 264

PROCEDURE Update_Resource_Cost
(       p_api_version           IN  NUMBER                              ,
        p_init_msg_list         IN  VARCHAR2 := FND_API.G_FALSE         ,
        p_commit                IN  VARCHAR2 := FND_API.G_FALSE         ,

        x_return_status         OUT NOCOPY VARCHAR2                            ,
        x_msg_count             OUT NOCOPY NUMBER                            ,
        x_msg_data              OUT NOCOPY VARCHAR2                            ,

        p_resource_cost_rec     IN  GMF_ResourceCost_PUB.Resource_Cost_Rec_Type         ,
        p_user_id               IN  NUMBER
)
IS
        l_api_name              CONSTANT VARCHAR2(30)   := 'Update_Resource_Cost' ;

Line: 286

    SAVEPOINT    Update_Resource_Cost_PVT;

Line: 313

    UPDATE cm_rsrc_dtl
    SET
         -- Modified uage_um to usage_uom by pmarada
         usage_uom          = decode(p_resource_cost_rec.usage_uom,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL, usage_uom,
                                     p_resource_cost_rec.usage_uom)
        ,nominal_cost       = decode(p_resource_cost_rec.nominal_cost,
                                     FND_API.G_MISS_NUM, NULL,
                                     NULL, nominal_cost,
                                     p_resource_cost_rec.nominal_cost)
        ,delete_mark        = decode(p_resource_cost_rec.delete_mark,
                                     FND_API.G_MISS_NUM, NULL,
                                     NULL, delete_mark,
                                     p_resource_cost_rec.delete_mark)
        ,last_update_date   = sysdate
        ,last_updated_by    = p_user_id
        ,last_update_login  = FND_GLOBAL.LOGIN_ID
    WHERE
        legal_entity_id = p_resource_cost_rec.legal_entity_id
    /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
    AND organization_id = p_resource_cost_rec.organization_id */
    AND nvl(organization_id,0) = nvl(p_resource_cost_rec.organization_id, 0)  /*B12404853*/
    AND resources       = p_resource_cost_rec.resources
    AND period_id       = p_resource_cost_rec.period_id
    AND cost_type_id    = p_resource_cost_rec.cost_type_id
    ;

Line: 354

        ROLLBACK TO  Update_Resource_Cost_PVT;

Line: 361

        ROLLBACK TO  Update_Resource_Cost_PVT;

Line: 368

        ROLLBACK TO  Update_Resource_Cost_PVT;

Line: 383

END Update_Resource_Cost ;

Line: 430

 l_api_name              CONSTANT VARCHAR2(30)   := 'Delete_Item_Cost' ;

Line: 477

    SELECT
            r.usage_uom
          , r.nominal_cost
          , r.delete_mark
          , f.user_name
    INTO
            x_resource_cost_rec.usage_uom
          , x_resource_cost_rec.nominal_cost
          , x_resource_cost_rec.delete_mark
          , x_resource_cost_rec.user_name
    FROM
          fnd_user f, cm_rsrc_dtl r
    WHERE
       legal_entity_id  = p_resource_cost_rec.legal_entity_id
    /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
    AND organization_id = p_resource_cost_rec.organization_id */
    AND nvl(organization_id,0) = nvl(p_resource_cost_rec.organization_id,0)  /*B12404853*/
    AND resources       = p_resource_cost_rec.resources
    AND period_id       = p_resource_cost_rec.period_id
    AND cost_type_id    = p_resource_cost_rec.cost_type_id
    AND f.user_id       = r.last_updated_by
    ;