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.CSP_PC_FORM_PICKLINES SQL Statements

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

Line: 43


          p_action_code                  IN   NUMBER,    /* 0 = insert, 1 = update, 2 = delete */
          px_PICKLIST_LINE_ID            IN OUT NOCOPY NUMBER,
          p_CREATED_BY                   IN   NUMBER  := FND_API.G_MISS_NUM,
          p_CREATION_DATE                IN   DATE    := FND_API.G_MISS_DATE,
          p_LAST_UPDATED_BY              IN   NUMBER  := FND_API.G_MISS_NUM,
          p_LAST_UPDATE_DATE             IN   DATE    := FND_API.G_MISS_DATE,
          p_LAST_UPDATE_LOGIN            IN   NUMBER  := FND_API.G_MISS_NUM,
          p_PICKLIST_LINE_NUMBER         IN   NUMBER  := FND_API.G_MISS_NUM,
          p_picklist_header_id           IN   NUMBER  := FND_API.G_MISS_NUM,
          p_LINE_ID                      IN   NUMBER  := FND_API.G_MISS_NUM,
          p_INVENTORY_ITEM_ID            IN   NUMBER  := FND_API.G_MISS_NUM,
          p_UOM_CODE                     IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_REVISION                     IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_QUANTITY_PICKED              IN   NUMBER    := FND_API.G_MISS_NUM,
          p_TRANSACTION_TEMP_ID          IN   NUMBER    := FND_API.G_MISS_NUM,
          p_ATTRIBUTE_CATEGORY           IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE1                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE2                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE3                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE4                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE5                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE6                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE7                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE8                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE9                   IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE10                  IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE11                  IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE12                  IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE13                  IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE14                  IN   VARCHAR2  := FND_API.G_MISS_CHAR,
          p_ATTRIBUTE15                  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
      l_picklist_line_rec   CSP_PICKLIST_LINES_PVT.picklist_line_Rec_Type;

Line: 91


      l_last_update_date          DATE := p_last_update_date;

Line: 97


      l_last_update_login         NUMBER := p_last_update_login;

Line: 98


      l_last_updated_by           NUMBER := p_last_updated_by;

Line: 100


        Select creation_date
        From csp_picklist_lines
        Where picklist_line_id = px_PICKLIST_LINE_ID;

Line: 133


                  SELECt picklist_line_id into l_check_existence
                  FROM CSP_PICKLIST_LINES
                  WHERE picklist_line_id = px_picklist_line_id;

Line: 161


                  select line_id into l_check_existence
                  from csp_moveorder_lines
                  where line_id = p_line_id;

Line: 192


                  select organization_id into l_organization_id
                  from csp_picklist_headers
                  where picklist_header_id = p_picklist_header_id;

Line: 220


                  select inventory_item_id into l_check_existence
                  from mtl_system_items_kfv
                  where inventory_item_id = p_inventory_item_id
                  and organization_id = l_organization_id;

Line: 255


                 select transaction_temp_id into l_check_existence
                 from mtl_material_transactions_temp
                 where transaction_temp_id = p_transaction_temp_id
                 and inventory_item_id = p_inventory_item_id
                 and move_order_line_id = p_line_id;

Line: 284


                 select UOM_CODE into l_check_var
                 from mtl_units_of_measure
                 where UOM_CODE = p_uom_code;

Line: 308


         IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
              l_last_update_date := sysdate;

Line: 316


         IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
              l_last_update_login := g_login_id;

Line: 320


         IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
              l_last_updated_by := g_user_id;

Line: 332


                  select picklist_line_id into l_check_existence
                  from  csp_picklist_lines
                  where picklist_line_id = px_picklist_line_id;

Line: 359


                    select picklist_header_id into l_check_existence
                    from csp_picklist_headers
                    where picklist_header_id = p_picklist_header_id;

Line: 364


                    select organization_id into l_organization_id
                    from csp_picklist_headers
                    where picklist_header_id = p_picklist_header_id;

Line: 385


                    select organization_id into l_organization_id
                    from csp_picklist_headers
                    where picklist_header_id = (select picklist_header_id
                                                    from csp_picklist_lines
                                                    where picklist_line_id = px_picklist_line_id);

Line: 396


                  select inventory_item_id into l_check_existence
                  from mtl_system_items_kfv
                  where inventory_item_id = p_inventory_item_id
                  and organization_id = l_organization_id;

Line: 418


                    select line_id into l_check_existence
                    from csp_moveorder_lines
                    where line_id = p_line_id;

Line: 443


                 select UOM_CODE into l_check_var
                 from mtl_units_of_measure
                 where UOM_CODE = p_uom_code;

Line: 465


                 select transaction_temp_id into l_check_existence
                 from mtl_material_transactions_temp
                 where transaction_temp_id = p_transaction_temp_id;

Line: 500


          IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
              l_last_update_date := sysdate;

Line: 512


                  select picklist_line_id into l_check_existence
                  from  csp_picklist_lines
                  where picklist_line_id = px_picklist_line_id;

Line: 537


    l_picklist_line_rec.last_updated_by     := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

Line: 538


    l_picklist_line_rec.last_update_date    := l_LAST_UPDATE_DATE;

Line: 539


    l_picklist_line_rec.last_update_login   := l_LAST_UPDATE_LOGIN;

Line: 580


      csp_picklist_lines_pvt.Update_picklist_lines(
        P_Api_Version_Number        => p_api_version_number,
        P_Init_Msg_List             => P_Init_Msg_List,
        P_Commit                    => P_Commit,
        p_validation_level          => l_validation_level,
        --P_Identity_Salesforce_Id     IN   NUMBER       := NULL,
        P_picklist_line_Rec         => l_picklist_line_rec,
        X_Return_Status             => l_return_status,
        X_Msg_Count                 => x_msg_count,
        X_Msg_Data                  => x_msg_data
      );

Line: 593


      csp_picklist_lines_pvt.Delete_picklist_lines(
        P_Api_Version_Number         => p_api_version_number,
        P_Init_Msg_List              => P_Init_Msg_List,
        p_Commit                     => P_Commit,
        p_validation_level           => l_validation_level,
        --P_identity_salesforce_id     IN   NUMBER       := NULL,
        P_picklist_line_Rec          => l_picklist_line_rec,
        X_Return_Status              => l_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data
      );