APPS.CSP_PICK_SL_UTIL SQL Statements

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

Line: 40

       p_LAST_UPDATED_BY           IN NUMBER,
       p_LAST_UPDATE_DATE          IN DATE,
       p_LAST_UPDATE_LOGIN         IN NUMBER,
       p_PICKLIST_LINE_ID          IN NUMBER,
       p_ORGANIZATION_ID           IN NUMBER,
       p_INVENTORY_ITEM_ID         IN NUMBER,
       p_QUANTITY                  IN NUMBER,
       p_LOT_NUMBER                IN VARCHAR2,
       p_SERIAL_NUMBER             IN VARCHAR2,
       X_Return_Status           OUT NOCOPY     VARCHAR2,
       X_Msg_Count               OUT NOCOPY     NUMBER,
       X_Msg_Data                OUT NOCOPY     VARCHAR2
    )
 IS
    -- csp standard declarations
    l_api_version_number        CONSTANT NUMBER  := 1.0;

Line: 94

                      select organization_id into l_check_existence
                      from mtl_parameters
                      where organization_id = p_organization_id;

Line: 125

                SELECT picklist_line_id INTO l_check_existence
                FROM csp_picklist_lines
                WHERE picklist_line_id = p_picklist_line_id;

Line: 157

            SELECT picklist_serial_lot_id INTO l_check_existence
            FROM CSP_Picklist_Serial_Lots
            WHERE picklist_serial_lot_id = px_picklist_serial_lot_id
            AND picklist_line_id = p_picklist_line_id;

Line: 183

         l_psl_rec.LAST_UPDATED_BY        :=  p_LAST_UPDATED_BY;

Line: 184

         l_psl_rec.LAST_UPDATE_DATE       :=  p_LAST_UPDATE_DATE;

Line: 185

         l_psl_rec.LAST_UPDATE_LOGIN      :=  p_LAST_UPDATE_LOGIN;

Line: 200

            IF p_LAST_UPDATE_DATE IS NULL THEN
               l_psl_rec.LAST_UPDATE_DATE := sysdate;

Line: 217

            IF p_LAST_UPDATE_DATE IS NULL THEN
               l_psl_rec.LAST_UPDATE_DATE := sysdate;

Line: 221

            csp_pick_serial_lots_PVT.Update_pick_serial_lots(
              P_Api_Version_Number         => l_Api_Version_Number,
              P_Init_Msg_List              => p_Init_Msg_List,
              P_Commit                     => l_Commit,
              p_validation_level           => l_validation_level,
              P_Identity_Salesforce_Id     => NULL,
              P_psl_Rec                    => l_psl_rec,
              X_Return_Status             => l_return_status,
              X_Msg_Count                 => l_msg_count,
              X_Msg_Data                  => l_msg_data);

Line: 234

             csp_pick_serial_lots_PVT.Delete_pick_serial_lots(
              P_Api_Version_Number         => l_Api_Version_Number,
              P_Init_Msg_List              => p_Init_Msg_List,
              P_Commit                     => l_Commit,
              p_validation_level           => l_validation_level,
              P_Identity_Salesforce_Id     => NULL,
              P_psl_Rec                    => l_psl_rec,
              X_Return_Status             => l_return_status,
              X_Msg_Count                 => l_msg_count,
              X_Msg_Data                  => l_msg_data);