APPS.CSP_PL_SHIP_UTIL SQL Statements

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

Line: 89

    Select PACKLIST_LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ORGANIZATION_ID,
           PACKLIST_LINE_NUMBER,
           PACKLIST_HEADER_ID,
           BOX_ID,
           PICKLIST_LINE_ID,
           PACKLIST_LINE_STATUS,
           INVENTORY_ITEM_ID,
           QUANTITY_PACKED,
           QUANTITY_SHIPPED,
           QUANTITY_RECEIVED,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           UOM_CODE,
           LINE_ID
    From  CSP_PACKLIST_LINES
    WHERE organization_id = p_organization_id
    AND   packlist_header_id = p_packlist_header_id;

Line: 128

        SELECT
          PACKLIST_HEADER_ID ,
          CREATED_BY ,
          CREATION_DATE ,
          LAST_UPDATED_BY ,
          LAST_UPDATE_DATE ,
          LAST_UPDATE_LOGIN ,
          ORGANIZATION_ID ,
          PACKLIST_NUMBER ,
          SUBINVENTORY_CODE ,
          PACKLIST_STATUS ,
          DATE_CREATED ,
          DATE_PACKED ,
          DATE_SHIPPED ,
          DATE_RECEIVED ,
          CARRIER ,
          SHIPMENT_METHOD ,
          WAYBILL ,
          COMMENTS ,
          LOCATION_ID,
          PARTY_SITE_ID,
          ATTRIBUTE_CATEGORY ,
          ATTRIBUTE1 ,
          ATTRIBUTE2 ,
          ATTRIBUTE3 ,
          ATTRIBUTE4 ,
          ATTRIBUTE5 ,
          ATTRIBUTE6 ,
          ATTRIBUTE7 ,
          ATTRIBUTE8 ,
          ATTRIBUTE9 ,
          ATTRIBUTE10 ,
          ATTRIBUTE11 ,
          ATTRIBUTE12 ,
          ATTRIBUTE13 ,
          ATTRIBUTE14 ,
          ATTRIBUTE15
    From  CSP_PACKLIST_HEADERS
    WHERE organization_id = p_organization_id
    AND   packlist_header_id = p_packlist_header_id;

Line: 178

      SELECT transaction_temp_id
      FROM CSP_Picklist_Lines
      WHERE picklist_line_id = l_packlist_line_rec.picklist_line_id;

Line: 183

      SELECT move_order_line_id
      FROM mtl_material_transactions_temp
      WHERE transaction_temp_id = p_temp_id
      AND organization_id = p_organization_id;

Line: 217

                      select organization_id into l_check_existence
                      from mtl_parameters
                      where organization_id = p_organization_id;

Line: 246

                    select packlist_header_id into l_check_existence
                    from csp_packlist_headers
                    where organization_id = p_organization_id
                    and packlist_header_id = p_packlist_header_id;

Line: 283

        l_packlist_headers_rec.last_update_date  := sysdate;

Line: 284

          /*update_packlist_header_sts (
          P_Api_Version_Number          => l_api_version_number,
          P_Init_Msg_List               => FND_API.G_true,
          P_Commit                      => l_commit,
          p_validation_level            => l_validation_level,
          p_packlist_header_id          => p_packlist_header_id,
          p_organization_id             => p_organization_id,
          p_packlist_status             => '2',
          x_return_status               => l_return_status,
          x_msg_count                   => l_msg_count,
          x_msg_data                    => l_msg_data );*/

Line: 297

        CSP_Packlist_Headers_PVT.Update_packlist_headers(
            P_Api_Version_Number         => l_api_version_number,
            P_Init_Msg_List              => p_init_msg_list,
            P_Commit                     => FND_API.G_FALSE,
            p_validation_level           => l_validation_level,
            P_Identity_Salesforce_Id     => NULL,
            P_PLH_Rec                    => l_packlist_headers_rec,
            X_Return_Status              => l_return_status,
            X_Msg_Count                  => l_msg_count,
            X_Msg_Data                   => l_msg_data
        );

Line: 328

          Update_Packlist_Sts_Qty (
                P_Api_Version_Number => l_api_version_number,
                P_Init_Msg_List      => FND_API.G_true,
                P_Commit            => l_commit,
                p_validation_level  => l_validation_level,
                p_organization_id   => p_organization_id,
                p_packlist_line_id  => l_packlist_line_rec.packlist_line_id,
                p_line_status       => '2',
                p_quantity_packed   => NULL,
                p_quantity_shipped  => l_packlist_line_rec.quantity_packed,
                p_quantity_received => NULL,
                x_return_status     => l_return_status,
                x_msg_count         => l_msg_count,
                x_msg_data          => l_msg_data
          );

Line: 377

                        select header_id into l_header_id
                        from csp_moveorder_lines
                        where line_id = l_move_order_line_id;

Line: 381

                        select autoreceipt_flag into l_autoreceipt_flag
                        from csp_moveorder_headers
                        where header_id = l_header_id;

Line: 388

                         l_trolin_rec.last_update_date := SYSDATE;

Line: 389

                         l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 390

                         l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 391

                         INV_Trolin_Util.Update_Row(l_trolin_rec);

Line: 549

Procedure Update_Packlist_Sts_Qty(
    P_Api_Version_Number IN   NUMBER,
    P_Init_Msg_List      IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit             IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level   IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    p_organization_id    IN   NUMBER,
    p_packlist_line_id   IN   NUMBER,
    p_line_status        IN   VARCHAR2,
    p_quantity_packed    IN   NUMBER,
    p_quantity_shipped   IN   NUMBER,
    p_quantity_received  IN   NUMBER,
    x_return_status      OUT NOCOPY  VARCHAR2,
    x_msg_count          OUT NOCOPY  NUMBER,
    x_msg_data           OUT NOCOPY  VARCHAR2)
IS
    l_packlist_line_rec  CSP_packlist_lines_PVT.PLL_Rec_Type;

Line: 567

    Select PACKLIST_LINE_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           ORGANIZATION_ID,
           PACKLIST_LINE_NUMBER,
           PACKLIST_HEADER_ID,
           BOX_ID,
           PICKLIST_LINE_ID,
           PACKLIST_LINE_STATUS,
           INVENTORY_ITEM_ID,
           QUANTITY_PACKED,
           QUANTITY_SHIPPED,
           QUANTITY_RECEIVED,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           UOM_CODE,
           LINE_ID
    From  CSP_PACKLIST_LINES
    WHERE organization_id = p_organization_id
    AND   packlist_line_id = p_packlist_line_id;

Line: 607

    l_api_name           CONSTANT VARCHAR2(50) := 'Update_Packlist_Sts_Qty';

Line: 616

    SAVEPOINT Update_Packlist_Sts_Qty_PUB;

Line: 640

                      select organization_id into l_check_existence
                      from mtl_parameters
                      where organization_id = p_organization_id;

Line: 669

                      select packlist_line_id into l_check_existence
                      from csp_packlist_lines
                      where organization_id = p_organization_id
                      and packlist_line_id = p_packlist_line_id;

Line: 715

        l_packlist_line_rec.last_update_date := sysdate;

Line: 716

        CSP_packlist_lines_PVT.Update_packlist_lines(
              P_Api_Version_Number         => l_api_version_number,
              P_Init_Msg_List              => FND_API.G_FALSE,
              P_Commit                     => FND_API.G_FALSE,
              p_validation_level           => FND_API.G_VALID_LEVEL_NONE,
              P_Identity_Salesforce_Id     => NULL,
              P_PLL_Rec                    => l_packlist_line_rec,
              X_Return_Status              => l_return_status,
              X_Msg_Count                  => l_msg_count,
              X_Msg_Data                   => l_msg_data
        );

Line: 735

            Rollback to Update_Packlist_Sts_Qty_PUB;

Line: 759

                Rollback to Update_Packlist_Sts_Qty_PUB;

Line: 769

END Update_Packlist_Sts_Qty;

Line: 796

        SELECT packlist_line_id
        FROM CSP_Packlist_LINES
        WHERE packlist_header_id = p_packlist_header_id;

Line: 807

                    SELECT packlist_line_status INTO l_line_status
                    FROM CSP_Packlist_Lines
                    WHERE packlist_line_id = l_line_id;

Line: 845

Procedure update_packlist_header_sts (
          P_Api_Version_Number           IN   NUMBER,
          P_Init_Msg_List                IN   VARCHAR2     := FND_API.G_FALSE,
          P_Commit                       IN   VARCHAR2     := FND_API.G_FALSE,
          p_validation_level             IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
          p_packlist_header_id           IN   NUMBER,
          p_organization_id              IN   NUMBER,
          p_packlist_status              IN   VARCHAR2     := FND_API.G_MISS_CHAR,
          x_return_status                OUT NOCOPY  VARCHAR2,
          x_msg_count                    OUT NOCOPY  NUMBER,
          x_msg_data                     OUT NOCOPY  VARCHAR2

    )
IS
    Cursor C_Get_Packlist_Headers IS
        SELECT
          PACKLIST_HEADER_ID ,
          CREATED_BY ,
          CREATION_DATE ,
          LAST_UPDATED_BY ,
          LAST_UPDATE_DATE ,
          LAST_UPDATE_LOGIN ,
          ORGANIZATION_ID ,
          PACKLIST_NUMBER ,
          SUBINVENTORY_CODE ,
          PACKLIST_STATUS ,
          DATE_CREATED ,
          DATE_PACKED ,
          DATE_SHIPPED ,
          DATE_RECEIVED ,
          CARRIER ,
          SHIPMENT_METHOD ,
          WAYBILL ,
          COMMENTS ,
          LOCATION_ID,
          PARTY_SITE_ID,
          ATTRIBUTE_CATEGORY ,
          ATTRIBUTE1 ,
          ATTRIBUTE2 ,
          ATTRIBUTE3 ,
          ATTRIBUTE4 ,
          ATTRIBUTE5 ,
          ATTRIBUTE6 ,
          ATTRIBUTE7 ,
          ATTRIBUTE8 ,
          ATTRIBUTE9 ,
          ATTRIBUTE10 ,
          ATTRIBUTE11 ,
          ATTRIBUTE12 ,
          ATTRIBUTE13 ,
          ATTRIBUTE14 ,
          ATTRIBUTE15
    From  CSP_PACKLIST_HEADERS
    WHERE organization_id = p_organization_id
    AND   packlist_header_id = p_packlist_header_id;

Line: 903

    l_api_name           CONSTANT VARCHAR2(50) := 'Update_Packlist_Sts_Qty';

Line: 913

     SAVEPOINT Update_Packlist_Sts_Qty_PUB;

Line: 939

                      select organization_id into l_check_existence
                      from mtl_parameters
                      where organization_id = p_organization_id;

Line: 967

                    select packlist_header_id into l_check_existence
                    from csp_packlist_headers
                    where organization_id = p_organization_id
                    and packlist_header_id = p_packlist_header_id;

Line: 1007

        l_packlist_headers_rec.last_update_date := sysdate;

Line: 1010

        CSP_Packlist_Headers_PVT.Update_packlist_headers(
            P_Api_Version_Number         => l_api_version_number,
            P_Init_Msg_List              => p_init_msg_list,
            P_Commit                     => FND_API.G_FALSE,
            p_validation_level           => l_validation_level,
            P_Identity_Salesforce_Id     => NULL,
            P_PLH_Rec                    => l_packlist_headers_rec,
            X_Return_Status              => l_return_status,
            X_Msg_Count                  => l_msg_count,
            X_Msg_Data                   => l_msg_data
        );

Line: 1034

            Rollback to Update_Packlist_Sts_Qty_PUB;

Line: 1064

               Rollback to Update_Packlist_Sts_Qty_PUB;

Line: 1074

END update_packlist_header_sts;