eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_BURDENDETAILS_PUB SQL Statements

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

Line: 220


       ,p_operation       => 'INSERT'
       ,x_header_rec      => l_header_rec
       ,x_dtl_tbl         => l_dtl_tbl
       ,x_user_id         => l_user_id
       ,x_brdn_factor_tbl => l_brdn_factor_tbl
       ,x_return_status   => l_return_status
       ) ;

Line: 248


        log_msg('Calling private API to insert record...');

Line: 370


PROCEDURE Update_Burden_Details
(
  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 VARCHAR2                    ,
  x_msg_data                    OUT NOCOPY VARCHAR2                    ,

  p_header_rec                  IN  Burden_Header_Rec_Type      ,
  p_dtl_tbl                     IN  Burden_Dtl_Tbl_Type
)
IS
        l_api_name              CONSTANT VARCHAR2(30)   := 'Update_Burden_Details' ;

Line: 398


    SAVEPOINT    Update_Burden_Details_PUB;

Line: 418


        log_msg('Beginning Update Burden Details Definition process.');

Line: 436


       ,p_operation       => 'UPDATE'
       ,x_header_rec      => l_header_rec
       ,x_dtl_tbl         => l_dtl_tbl
       ,x_user_id         => l_user_id
       ,x_brdn_factor_tbl => l_brdn_factor_tbl
       ,x_return_status   => l_return_status
       ) ;

Line: 464


        log_msg('Calling private API to update records...');

Line: 466


      GMF_BurdenDetails_PVT.Update_Burden_Details
        (
          p_api_version         => 2.0
        , p_init_msg_list       => FND_API.G_FALSE
        , p_commit              => FND_API.G_FALSE

        , x_return_status       => l_return_status
        , x_msg_count           => l_count
        , x_msg_data            => l_data

        , p_header_rec          => l_header_rec
        , p_dtl_tbl             => l_dtl_tbl
        , p_user_id             => l_user_id
        , p_burden_factor_tbl   => l_brdn_factor_tbl
      );

Line: 521


        ROLLBACK TO  Update_Burden_Details_PUB;

Line: 528


        ROLLBACK TO  Update_Burden_Details_PUB;

Line: 535


        ROLLBACK TO  Update_Burden_Details_PUB;

Line: 550


END Update_Burden_Details ;

Line: 584


PROCEDURE Delete_Burden_Details
(
  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 VARCHAR2                    ,
  x_msg_data                    OUT NOCOPY VARCHAR2                    ,

  p_header_rec                  IN  Burden_Header_Rec_Type      ,
  p_dtl_tbl                     IN  Burden_Dtl_Tbl_Type
)
IS
        l_api_name              CONSTANT VARCHAR2(30)   := 'Delete_Burden_Details' ;

Line: 614


    SAVEPOINT    Delete_Burden_Details_PUB;

Line: 634


        log_msg('Beginning Delete Burden Details process.');

Line: 653


       ,p_operation       => 'DELETE'
       ,x_header_rec      => l_header_rec
       ,x_dtl_tbl         => l_dtl_tbl
       ,x_user_id         => l_user_id
       ,x_brdn_factor_tbl => l_brdn_factor_tbl
       ,x_return_status   => l_return_status
       ) ;

Line: 681


        log_msg('Calling private API to delete records...');

Line: 684


      GMF_BurdenDetails_PVT.Update_Burden_Details
        (
          p_api_version         => 2.0
        , p_init_msg_list       => FND_API.G_FALSE
        , p_commit              => FND_API.G_FALSE

        , x_return_status       => l_return_status
        , x_msg_count           => l_count
        , x_msg_data            => l_data

        , p_header_rec          => l_header_rec
        , p_dtl_tbl             => l_dtl_tbl
        , p_user_id             => l_user_id
        , p_burden_factor_tbl   => l_brdn_factor_tbl
      );

Line: 739


        ROLLBACK TO  Delete_Burden_Details_PUB;

Line: 746


        ROLLBACK TO  Delete_Burden_Details_PUB;

Line: 753


        ROLLBACK TO  Delete_Burden_Details_PUB;

Line: 768


END Delete_Burden_Details ;

Line: 1318


    x_dtl_tbl.delete ;

Line: 1319


    x_brdn_factor_tbl.delete ;

Line: 1444


     SELECT Primary_uom_code INTO l_act_item_uom
     FROM mtl_system_items_b
     WHERE inventory_item_id = nvl(p_header_rec.inventory_item_id,x_header_rec.inventory_item_id)
       AND organization_id = nvl(p_header_rec.organization_id,x_header_rec.organization_id);

Line: 1671


        IF ((p_operation = 'DELETE') AND
            ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
           ) THEN
          add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 1691


          IF ((p_operation = 'UPDATE') AND
              ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR
               (p_dtl_tbl(i).burdenline_id IS NOT NULL))
             ) THEN

              l_burdenline_id := p_dtl_tbl(i).burdenline_id;

Line: 1703


                SELECT resources, burden_qty, burden_usage, burden_uom, item_qty, item_uom
                  INTO l_resources, l_burden_qty, l_burden_usage, l_burden_uom, l_item_qty, l_item_uom
                  FROM cm_brdn_dtl
                 WHERE burdenline_id = l_burdenline_id;

Line: 1865


            IF (p_operation = 'UPDATE') THEN
              --
              -- Bug 2681243: added new elsif block. For updates when burdenline_id is
              -- passed retrieve all burden details to use later in the program for
              -- UOM conversions.
              --
               BEGIN
                 SELECT resources, burden_qty, burden_usage, burden_uom, item_qty, item_uom
                   INTO l_resources, l_burden_qty, l_burden_usage, l_burden_uom, l_item_qty, l_item_uom
                   FROM
                         cm_brdn_dtl
                  WHERE
                         organization_id    = x_header_rec.organization_id
                    AND  inventory_item_id  = x_header_rec.inventory_item_id
                    AND  period_id          = x_header_rec.period_id
                    AND  cost_type_id       = x_header_rec.cost_type_id
                    AND  resources          = l_resources
                    AND  cost_cmpntcls_id   = l_cost_cmpntcls_id
                    AND  cost_analysis_code = p_dtl_tbl(i).cost_analysis_code ;

Line: 1905


          IF (p_operation <> 'DELETE') THEN
            --
            -- Burden Usage
            -- Burden Usage should be > 0
            -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
            -- To put that check here, the cost should not be >= 1,000,000,000
            --
            IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN    -- Bug 2659435
                log_msg('validating Burden Usage : '||p_dtl_tbl(i).burden_usage);

Line: 1937


                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
              add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 1971


                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
              add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2000


                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
                  add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2012


            IF ((p_operation = 'INSERT') OR
                ( (p_operation = 'UPDATE') AND
                  (p_dtl_tbl(i).burden_qty      IS NOT NULL OR
                   p_dtl_tbl(i).burden_usage    IS NOT NULL OR
                   p_dtl_tbl(i).burden_uom      IS NOT NULL OR
                   p_dtl_tbl(i).item_qty        IS NOT NULL OR
                   p_dtl_tbl(i).item_uom        IS NOT NULL)
                )
               ) THEN

               -- Convert item quantity actual item UOM
               IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
                       log_msg('Converting Item Qty ' || l_item_qty ||
                       ' from UOM ' || l_item_uom || ' to UOM ' || l_act_item_uom ||
                       ' for Item_Id : ' || x_header_rec.inventory_item_id);

Line: 2085


                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
              add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2128


                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
                  add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2189


                log_msg('validating delete_mark('||i||') :' ||
                                                 p_dtl_tbl(i).delete_mark);

Line: 2193


            IF (p_dtl_tbl(i).delete_mark <> FND_API.G_MISS_NUM) AND
               (p_dtl_tbl(i).delete_mark IS NOT NULL)  THEN
              IF p_dtl_tbl(i).delete_mark NOT IN (0,1) THEN
                add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2197


                FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');

Line: 2198


                FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_dtl_tbl(i).delete_mark);

Line: 2202


            ELSIF (p_dtl_tbl(i).delete_mark = FND_API.G_MISS_NUM AND    -- Bug 2659435
                   p_operation = 'UPDATE') OR
                  (p_operation = 'INSERT') THEN
                  add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2206


                  FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');

Line: 2210


            IF ((p_operation = 'UPDATE') AND (p_dtl_tbl(i).delete_mark = 1)) THEN
              add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2218


          END IF ;  -- check for delete to eliminate unneccessary validations.

Line: 2227


          IF ((p_operation = 'UPDATE') AND
              ((p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) OR (p_dtl_tbl(i).burdenline_id IS NOT NULL))
             ) THEN
            add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line: 2237


        END IF ; -- Main if(after for loop stmt) to check for delete operation and check for burdenline_id.

Line: 2250


        IF p_operation in ('INSERT', 'UPDATE') THEN
          x_dtl_tbl(l_idx).delete_mark       := 0 ;

Line: 2253


          x_dtl_tbl(l_idx).delete_mark       := 1 ;

Line: 2269


          log_msg('x_delete_mark('||l_idx||'): '||x_dtl_tbl(l_idx).delete_mark);